[OpenSIPS-Users] address_table: invalid pattern column type on row 0, skipping..

Bogdan-Andrei Iancu bogdan at opensips.org
Thu Dec 8 04:55:41 EST 2016


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 <bogdan at opensips.org 
> <mailto:bogdan at opensips.org>> 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
>>     Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>     <http://lists.opensips.org/cgi-bin/mailman/listinfo/users>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20161208/fe316dee/attachment-0001.htm>


More information about the Users mailing list