8 May
2010
8 May
'10
7:59 p.m.
Why is it an UNIQUE key? It makes things complex when I want to create
another gateway with same IP and port (but belonging to a different
grp_id). I still want to name it with the same name (an internal
domain for example).
Regards.
--
Iñaki Baz Castillo
<ibc(a)aliax.net>
8 May
8 May
9:10 p.m.
New subject: [LCR] Why 'gw_name' column is an UNIQUE index in 'gw' table?
Iñaki Baz Castillo writes:
Why is it an UNIQUE key? It makes things complex when
I want to create
another gateway with same IP and port (but belonging to a different
grp_id). I still want to name it with the same name (an internal
domain for example).
which version? in 3.0:
UNIQUE KEY `lcr_id_grp_id_gw_name_idx` (`lcr_id`,`grp_id`,`gw_name`),
UNIQUE KEY `lcr_id_grp_id_ip_addr_hostname_idx`
(`lcr_id`,`grp_id`,`ip_addr`,`hostname`)
-- juha
9:42 p.m.
New subject: [LCR] Why 'gw_name' column is an UNIQUE index in 'gw' table?
Iñaki Baz Castillo writes:
Could I get into problems if I remove such UNIQUE key
(gw_name column)
in "gw" table and create two entries with same "gw_name"? (kamailio
1.5.4).
gw_name is not used by lcr module. it is for information only. you can
change the index.
-- juha
10:19 p.m.
New subject: [LCR] Why 'gw_name' column is an UNIQUE index in 'gw' table?
2010/5/8 Juha Heinanen <jh(a)tutpro.com>om>:
Iñaki Baz Castillo writes:
Sorry, I mean kamailio 1.5.4:
PRIMARY KEY (`id`),
UNIQUE KEY `gw_name_idx` (`gw_name`),
KEY `grp_id_idx` (`grp_id`)
--
Iñaki Baz Castillo
<ibc(a)aliax.net>
Why is it an UNIQUE key? It makes things complex
when I want to create
another gateway with same IP and port (but belonging to a different
grp_id). I still want to name it with the same name (an internal
domain for example).
which version? in 3.0:
UNIQUE KEY `lcr_id_grp_id_gw_name_idx` (`lcr_id`,`grp_id`,`gw_name`),
UNIQUE KEY `lcr_id_grp_id_ip_addr_hostname_idx`
(`lcr_id`,`grp_id`,`ip_addr`,`hostname`)
10:23 p.m.
New subject: [LCR] Why 'gw_name' column is an UNIQUE index in 'gw' table?
2010/5/8 Iñaki Baz Castillo <ibc(a)aliax.net>et>:
Sorry, I mean kamailio 1.5.4:
PRIMARY KEY (`id`),
UNIQUE KEY `gw_name_idx` (`gw_name`),
KEY `grp_id_idx` (`grp_id`)
Could I get into problems if I remove such UNIQUE key (gw_name column)
in "gw" table and create two entries with same "gw_name"? (kamailio
1.5.4).
Thanks.
--
Iñaki Baz Castillo
<ibc(a)aliax.net>
10:35 p.m.
New subject: [LCR] Why 'gw_name' column is an UNIQUE index in 'gw' table?
2010/5/8 Juha Heinanen <jh(a)tutpro.com>om>:
Iñaki Baz Castillo writes:
Thanks.
--
Iñaki Baz Castillo
<ibc(a)aliax.net>
Could I get into problems if I remove such UNIQUE
key (gw_name column)
in "gw" table and create two entries with same "gw_name"? (kamailio
1.5.4).
gw_name is not used by lcr module. it is for information only. you can
change the index.
5128
days inactive
5128
days old
5 comments
2 participants
participants (2)
-
Iñaki Baz Castillo -
Juha Heinanen