[SR-Users] permissions module address_reload not working

[Daniel-Constantin Mierla]

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: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
>    

-- 
Daniel-Constantin Mierla
http://www.asipto.com/