Hi Aqs, OK, let us run a test and John will be back with you.
Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 07.12.2016 22:12, Aqs Younas wrote:
i have tried multiple things but all in vain. 1) sqlite> insert into address(ip) values('192.168.10.20'); sqlite> select * from address; id|grp|ip|mask|port|proto|pattern|context_info 5|0|192.168.10.20|32|0|any||2) sqlite> INSERT INTO "main"."address" VALUES (1, 1, '192.168.10.30', 30, 0, 'ANY', null, '12345675');sqlite> select * from address; id|grp|ip|mask|port|proto|pattern|context_info 1|1|192.168.10.30|30|0|ANY||12345675 Thanks for replying. Let me know if you need anything else. Regards.On 8 December 2016 at 00:20, Bogdan-Andrei Iancu <[email protected] <mailto:[email protected]>> wrote:Hi Aqs, Please post the line you have inserted, so I can check the type of the "pattern" field - OpenSIPS fails to find a STRING in that field. Best regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com <http://www.opensips-solutions.com> On 07.12.2016 16:45, 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 list [email protected] <mailto:[email protected]> http://lists.opensips.org/cgi-bin/mailman/listinfo/users <http://lists.opensips.org/cgi-bin/mailman/listinfo/users>
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
