Thanks.It's working perfectly. :) On 8 December 2016 at 20:45, Ionut Ionita <[email protected]> wrote:
> Hello, > It should be solved. Check [0] for master branch and [1] for 2.2 . > > [0] https://github.com/OpenSIPS/opensips/commit/ > 642e8879c10aa38a8745c6db173c447c54c3cddf > [1] https://github.com/OpenSIPS/opensips/commit/ > 2d55067cdb9ec284ea0d55e1e90dbd421d244a6f > > Regards, > Ionut Ionita > OpenSIPS Developer > > On 12/07/2016 04:45 PM, Aqs Younas wrote: > > Greetings list, > > I am doing IP authentication and populating the address table of > SQLite database of opensips. As soon as try to start my opensips I see > opensips throwing this error. > > Dec 7 09:32:45 CDSdev ./opensips[23421]: DBG:core:init_mod: initializing > module permissions > Dec 7 09:32:45 CDSdev ./opensips[23421]: DBG:permissions:mod_init: > initializing... > Dec 7 09:32:45 CDSdev ./opensips[23421]: INFO:permissions:parse_config_ > file: file not found: /opt/opensips2.2//etc/opensips/permissions.allow > Dec 7 09:32:45 CDSdev ./opensips[23421]: INFO:permissions:mod_init: > default allow file (/opt/opensips2.2//etc/opensips/permissions.allow) not > found => empty rule set > Dec 7 09:32:45 CDSdev ./opensips[23421]: INFO:permissions:parse_config_ > file: file not found: /opt/opensips2.2//etc/opensips/permissions.deny > Dec 7 09:32:45 CDSdev ./opensips[23421]: INFO:permissions:mod_init: > default deny file (/opt/opensips2.2//etc/opensips/permissions.deny) not > found => empty rule set > Dec 7 09:32:45 CDSdev ./opensips[23421]: DBG:core:find_mod_export: found > <db_bind_api> in module db_sqlite [/opt/opensips2.2/lib64/ > opensips/modules/] > Dec 7 09:32:45 CDSdev ./opensips[23421]: DBG:core:db_bind_mod: using db > bind api for db_sqlite > Dec 7 09:32:45 CDSdev ./opensips[23421]: DBG:core:db_do_init: connection > 0x7fe95a2c9200 not found in pool > Dec 7 09:32:45 CDSdev ./opensips[23421]: DBG:core:db_do_init: connection > 0x7fe95a2c9200 inserted in pool as 0x7fe95a2c92a0 > Dec 7 09:32:45 CDSdev ./opensips[23421]: DBG:core:db_new_result: allocate > 48 bytes for result set at 0x7fe95a2cb2c0 > Dec 7 09:32:45 CDSdev ./opensips[23421]: DBG:db_sqlite:db_sqlite_get_columns: > 1 columns returned from the query > Dec 7 09:32:45 CDSdev ./opensips[23421]: DBG:core:db_allocate_columns: > allocate 28 bytes for result columns at 0x7fe95a2cb308 > Dec 7 09:32:45 CDSdev ./opensips[23421]: DBG:db_sqlite:db_sqlite_get_columns: > RES_NAMES(0x7fe95a2cb310)[0]=[table_version] > Dec 7 09:32:45 CDSdev ./opensips[23421]: DBG:core:db_free_columns: > freeing result columns at 0x7fe95a2cb308 > Dec 7 09:32:45 CDSdev ./opensips[23421]: DBG:core:db_new_result: allocate > 48 bytes for result set at 0x7fe95a2cb2c0 > Dec 7 09:32:45 CDSdev ./opensips[23421]: DBG:db_sqlite:db_sqlite_get_columns: > 8 columns returned from the query > Dec 7 09:32:45 CDSdev ./opensips[23421]: DBG:core:db_allocate_columns: > allocate 224 bytes for result columns at 0x7fe95a2cb378 > Dec 7 09:32:45 CDSdev ./opensips[23421]: DBG:db_sqlite:db_sqlite_get_columns: > RES_NAMES(0x7fe95a2cb3b8)[0]=[ip] > Dec 7 09:32:45 CDSdev ./opensips[23421]: DBG:db_sqlite:db_sqlite_get_columns: > RES_NAMES(0x7fe95a2cb3c8)[1]=[grp] > Dec 7 09:32:45 CDSdev ./opensips[23421]: DBG:db_sqlite:db_sqlite_get_columns: > RES_NAMES(0x7fe95a2cb3d8)[2]=[mask] > Dec 7 09:32:45 CDSdev ./opensips[23421]: DBG:db_sqlite:db_sqlite_get_columns: > RES_NAMES(0x7fe95a2cb3e8)[3]=[port] > Dec 7 09:32:45 CDSdev ./opensips[23421]: DBG:db_sqlite:db_sqlite_get_columns: > RES_NAMES(0x7fe95a2cb3f8)[4]=[proto] > Dec 7 09:32:45 CDSdev ./opensips[23421]: DBG:db_sqlite:db_sqlite_get_columns: > RES_NAMES(0x7fe95a2cb408)[5]=[pattern] > Dec 7 09:32:45 CDSdev ./opensips[23421]: DBG:db_sqlite:db_sqlite_get_columns: > RES_NAMES(0x7fe95a2cb418)[6]=[context_info] > Dec 7 09:32:45 CDSdev ./opensips[23421]: > DBG:permissions:reload_address_table: > number of rows in address table: 1 > Dec 7 09:32:45 CDSdev ./opensips[23421]: > *ERROR:permissions:reload_address_table: > invalid pattern column type on row 0, skipping..* > Dec 7 09:32:45 CDSdev ./opensips[23421]: DBG:core:db_free_columns: > freeing result columns at 0x7fe95a2cb378 > Dec 7 09:32:45 CDSdev ./opensips[23421]: > DBG:permissions:reload_address_table: > address table reloaded successfully. > Dec 7 09:32:45 CDSdev ./opensips[23421]: DBG:core:pool_remove: removing > connection from the pool > > > I have tried different combinations, e.g, > 1) Inserting data according to column type in address table. > 2) Inserting only a string "192.168.10.20" in 'ip' column and keeping > remaining columns default. > > But with no luck. Could someone please suggest what i am doing wrong here. > > Best, > Aqs Younas > > > _______________________________________________ > Users mailing > [email protected]http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
