Hello,
On 6/30/10 10:17 PM, JR Richardson wrote:
Hi All,
I'm running kamailio 3.0.2.
hmm, checking the logs I see changes done lately that introduced some bugs:
http://git.sip-router.org/cgi-bin/gitweb.cgi?p=sip-router;a=commitdiff;h=b0091da84ee5bbbc18cb799eefc497be707ab0f9
I could spot at least:
- db handle is initialed by mi child init and then checked to be null
(the cause of error message printed)
- in some error cases, db handle is left initialized, so next times
the command won't work
I will try to fix in the next days, meanwhile you can apply revert patch
and everything should work ... the attempt by that commit is not really
solving the problem it tried to fix.
Cheers,
Daniel
# ----- permissions params -----
modparam("permissions", "db_url",
"mysql://openserro:opense...@localhost/openser")
#modparam("permissions", "db_mode", 1)
snip in route block:
if (!allow_source_address_group()) {
sl_send_reply("403", "Forbidden");
exit;
}
From command line:
sip-router2:/etc/kamailio# kamctl fifo address_reload
400 Address table reload failed
debug output:
during initial kamailio startup:
0(10655) DEBUG: permissions [address.c:122]: Number of rows in address table:
4
0(10655) DEBUG: permissions [address.c:164]: Tuple<1, 10.10.12.0,
24, 0> inserted into subnet table
0(10655) DEBUG: permissions [address.c:164]: Tuple<1, 10.10.14.0,
24, 0> inserted into subnet table
0(10655) DEBUG: permissions [address.c:148]: Tuple<1, 10.10.15.97,
32> inserted into address hash table
0(10655) DEBUG: permissions [address.c:148]: Tuple<1, 10.10.15.98,
32> inserted into address hash table
0(10655) DEBUG:<core> [db_res.c:81]: freeing 4 columns
0(10655) DEBUG:<core> [db_res.c:85]: freeing RES_NAMES[0] at 0x827c158
0(10655) DEBUG:<core> [db_res.c:85]: freeing RES_NAMES[1] at 0x827c220
0(10655) DEBUG:<core> [db_res.c:85]: freeing RES_NAMES[2] at 0x827c168
0(10655) DEBUG:<core> [db_res.c:85]: freeing RES_NAMES[3] at 0x827c230
0(10655) DEBUG:<core> [db_res.c:94]: freeing result names at 0x827c250
0(10655) DEBUG:<core> [db_res.c:99]: freeing result types at 0x827c1b8
0(10655) DEBUG:<core> [db_res.c:54]: freeing 4 rows
0(10655) DEBUG:<core> [db_row.c:97]: freeing row values at 0x827c710
0(10655) DEBUG:<core> [db_row.c:97]: freeing row values at 0x827c6b8
0(10655) DEBUG:<core> [db_row.c:97]: freeing row values at 0x827c660
0(10655) DEBUG:<core> [db_row.c:97]: freeing row values at 0x827c598
0(10655) DEBUG:<core> [db_res.c:62]: freeing rows at 0x827ca10
0(10655) DEBUG:<core> [db_res.c:136]: freeing result set at 0x827c1f8
0(10655) DEBUG:<core> [db_pool.c:102]: removing connection from the pool
0(10655) DEBUG: permissions [address.c:181]: address table reloaded
successfully.
result when issuing "kamctl fifo address_reload"
3(10389) DEBUG: mi_fifo [fifo_fnc.c:489]: entered consume
3(10389) DEBUG: mi_fifo [fifo_fnc.c:489]: **** done consume
3(10389) DEBUG: mi_fifo [fifo_fnc.c:503]: done parsing the mi tree
3(10389) ERROR: permissions [address.c:82]: db_handle already exists
The address table loads fine during startup and if I reload kamailio
it will load any new addresses or subnets so I know there is no syntax
error in the database.
I can reload trusted table and pdt table without an error but address
table is not working.
Any ideas on how I can trouble shoot this further?
Thanks.
JR
--
Daniel-Constantin Mierla
http://www.asipto.com/
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
