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
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]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
