30 Jun
2010
30 Jun
'10
11:17 p.m.
Hi All,
I'm running kamailio 3.0.2.
# ----- permissions params -----
modparam("permissions", "db_url",
"mysql://openserro:openserro@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
--
JR Richardson
Engineering for the Masses