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