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

[Aqs Younas]

Thanks.It's working perfectly. :)

On 8 December 2016 at 20:45, Ionut Ionita <ionutionita at opensips.org> 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 listUsers at lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> 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/634b05df/attachment-0001.htm>