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 [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
