[Devel] lcr module and kannel
Klaus Darilion
klaus.mailinglists at pernau.at
Thu Jul 28 19:44:41 CEST 2005
Hi!
I've tried porting the lcr tables to postgres and encountered a problem:
The lcr module stores the values in unsigned integers in mysql. But,
there are no unsigend intergers in postgresql.
Thus, I have choosen the next bigger integer instead of the unsigned
one. Thus, I changed
ip_addr INT UNSIGNED NOT NULL,
in mysql to
ip_addr BIGINT CHECK (ip_addr > 0 AND ip_addr < 4294967296) NOT NULL,
in postgres. Thus storing in postgres is fine. But there is still a
problem when entering IP addresses where the last octet > 127.
Values in DB:
openser=# select * from gw;
gw_name| ip_addr |port|uri_scheme|transport|grp_id
-------+----------+----+----------+---------+-------
test2 |2155839359|5060| 1| 2| 3 (127.127.127.128)
test1 |2139062143|5060| 1| 2| 3 (127.127.127.127)
Values in lcr module:
philipp:# openserctl fifo lcr_dump
sip:127.127.127.127:5060:tcp
sip:255.255.255.127:5060:tcp
Here is the debug output during "serctl fifo lcr_reload":
1(2520) PG[232] db_init entry
1(2520) PG[187] str2valp got int 2139062143
1(2520) PG[187] str2valp got int 5060
1(2520) PG[187] str2valp got int 1
1(2520) PG[187] str2valp got int 2
1(2520) PG[187] str2valp got int 2155839359
1(2520) PG[187] str2valp got int 5060
1(2520) PG[187] str2valp got int 1
1(2520) PG[187] str2valp got int 2
1(2520) PG[269] db_close entry
1(2520) **** done consume
I do not have any glue where the problem occours: in lcr module? in
openser's DB API? in postgres module?
Any hints to track down and solve this problem are appreciated.
regards,
klaus
More information about the Devel
mailing list