[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