[OpenSIPS-Users] permission module problem

[Jayesh Nambiar]

Hi All,
I am trying to use the permission module and test the address functions. But
whenever I try to start opensips I get the following error:
ERROR:permissions:reload_address_table: database problem
Jul  9 10:19:11 [10964] DBG:core:db_allocate_rows: allocate 272 bytes for
result rows and values at 0x7b8870
Jul  9 10:19:11 [10964] DBG:db_mysql:db_mysql_str2val: converting STRING
[216.XXX.XXX.9]
Jul  9 10:19:11 [10964] DBG:db_mysql:db_mysql_str2val: converting INT [1]
Jul  9 10:19:11 [10964] DBG:db_mysql:db_mysql_str2val: converting STRING
[31]
Jul  9 10:19:11 [10964] DBG:db_mysql:db_mysql_str2val: converting INT [0]
Jul  9 10:19:11 [10964] DBG:db_mysql:db_mysql_str2val: converting STRING
[UDP]
Jul  9 10:19:11 [10964] DBG:db_mysql:db_mysql_str2val: converting STRING
[^sip:.*$]
Jul  9 10:19:11 [10964] DBG:db_mysql:db_mysql_str2val: converting STRING []
Jul  9 10:19:11 [10964] DBG:db_mysql:db_mysql_str2val: converting INT [1]
Jul  9 10:19:11 [10964] DBG:permissions:reload_address_table: number of rows
in address table: 1
Jul  9 10:19:11 [10964] ERROR:permissions:reload_address_table: database
problem
Jul  9 10:19:11 [10964] DBG:core:db_free_columns: freeing result columns at
0x7b8778
Jul  9 10:19:11 [10964] DBG:core:db_free_rows: freeing 1 rows
Jul  9 10:19:11 [10964] DBG:core:db_free_row: freeing row values at 0x7b8880
Jul  9 10:19:11 [10964] DBG:core:db_free_rows: freeing rows at 0x7b8870
Jul  9 10:19:11 [10964] DBG:core:db_free_result: freeing result set at
0x7b86b0
Jul  9 10:19:11 [10964] CRITICAL:permissions:init_address: reload of address
table failed
Jul  9 10:19:11 [10964] DBG:core:pool_remove: removing connection from the
pool
Jul  9 10:19:11 [10964] ERROR:permissions:mod_init: failed to initialize the
allow_address function
Jul  9 10:19:11 [10964] ERROR:core:init_mod: failed to initialize module
permissions
Jul  9 10:19:11 [10964] ERROR:core:main: error while initializing modules
Jul  9 10:19:11 [10964] DBG:xlog:destroy: destroy module...

I am using MySQL version 5.1.48 as my backend. I've created tables using the
schema mentioned here
http://www.opensips.org/html/docs/db/db-schema-1.6.x.html#AEN3632. I have
changed the table and column names according to my requirement.
While starting OpenSIPS, it executes this query on my DB:
"select host,grp,mask,port,protocol,pattern,context_info,id from
trusted_ips" for which the resultset is returned by my DB properly. The
resultset returned is as follows:
'216.XXX.XXX.9', 1, '31', 0, 'UDP', '^sip:.*$', '', 1.
The public IP is masked on purpose while showing here. Does anyone find
something missing in my setup. I am just not able to get this up and
working.
Any pointers or mistakes pointed out would be of great help.

Thanks in advance.

--- Jayesh
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20100709/9758c2a3/attachment.htm