Hi All,<div>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:</div><div><div>ERROR:permissions:reload_address_table: database problem</div>
<div><div>Jul 9 10:19:11 [10964] DBG:core:db_allocate_rows: allocate 272 bytes for result rows and values at 0x7b8870</div><div>Jul 9 10:19:11 [10964] DBG:db_mysql:db_mysql_str2val: converting STRING [216.XXX.XXX.9]</div>
<div>Jul 9 10:19:11 [10964] DBG:db_mysql:db_mysql_str2val: converting INT [1]</div><div>Jul 9 10:19:11 [10964] DBG:db_mysql:db_mysql_str2val: converting STRING [31]</div><div>Jul 9 10:19:11 [10964] DBG:db_mysql:db_mysql_str2val: converting INT [0]</div>
<div>Jul 9 10:19:11 [10964] DBG:db_mysql:db_mysql_str2val: converting STRING [UDP]</div><div>Jul 9 10:19:11 [10964] DBG:db_mysql:db_mysql_str2val: converting STRING [^sip:.*$]</div><div>Jul 9 10:19:11 [10964] DBG:db_mysql:db_mysql_str2val: converting STRING []</div>
<div>Jul 9 10:19:11 [10964] DBG:db_mysql:db_mysql_str2val: converting INT [1]</div><div>Jul 9 10:19:11 [10964] DBG:permissions:reload_address_table: number of rows in address table: 1</div><div>Jul 9 10:19:11 [10964] ERROR:permissions:reload_address_table: database problem</div>
<div>Jul 9 10:19:11 [10964] DBG:core:db_free_columns: freeing result columns at 0x7b8778</div><div>Jul 9 10:19:11 [10964] DBG:core:db_free_rows: freeing 1 rows</div><div>Jul 9 10:19:11 [10964] DBG:core:db_free_row: freeing row values at 0x7b8880</div>
<div>Jul 9 10:19:11 [10964] DBG:core:db_free_rows: freeing rows at 0x7b8870</div><div>Jul 9 10:19:11 [10964] DBG:core:db_free_result: freeing result set at 0x7b86b0</div><div>Jul 9 10:19:11 [10964] CRITICAL:permissions:init_address: reload of address table failed</div>
<div>Jul 9 10:19:11 [10964] DBG:core:pool_remove: removing connection from the pool</div><div>Jul 9 10:19:11 [10964] ERROR:permissions:mod_init: failed to initialize the allow_address function</div><div>Jul 9 10:19:11 [10964] ERROR:core:init_mod: failed to initialize module permissions</div>
<div>Jul 9 10:19:11 [10964] ERROR:core:main: error while initializing modules</div><div>Jul 9 10:19:11 [10964] DBG:xlog:destroy: destroy module...</div></div></div><div><br></div><div>I am using MySQL version 5.1.48 as my backend. I've created tables using the schema mentioned here <a href="http://www.opensips.org/html/docs/db/db-schema-1.6.x.html#AEN3632">http://www.opensips.org/html/docs/db/db-schema-1.6.x.html#AEN3632</a>. I have changed the table and column names according to my requirement.</div>
<div>While starting OpenSIPS, it executes this query on my DB:</div><div>"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:</div>
<div>'216.XXX.XXX.9', 1, '31', 0, 'UDP', '^sip:.*$', '', 1. </div><div>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.</div>
<div>Any pointers or mistakes pointed out would be of great help.</div><div><br></div><div>Thanks in advance.</div><div><br></div><div>--- Jayesh</div>