[OpenSIPS-Users] permission module problem

[Bogdan-Andrei Iancu]

Hi Jayesh,

Could you post the exact content of the "address" table ?  Do a "select 
* from address" .

Regards,
Bogdan

Jayesh Nambiar wrote:
> 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
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>   


-- 
Bogdan-Andrei Iancu
OpenSIPS Bootcamp
20 - 24 September 2010, Frankfurt, Germany
www.voice-system.ro