<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>Hi Aqs,<br>
<br>
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.<br>
<br>
Best regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<div class="moz-cite-prefix">On 07.12.2016 16:45, Aqs Younas wrote:<br>
</div>
<blockquote
cite="mid:CAGVOjVXevgE0z35HxJhAg5BsU9QMq+3abtd6cGbnin9SXgKUcw@mail.gmail.com"
type="cite">
<div dir="ltr">Greetings list,
<div>
<div>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.</div>
<div><br>
</div>
<div> Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:core:init_mod: initializing module permissions</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:permissions:mod_init: initializing...</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
<a class="moz-txt-link-freetext" href="INFO:permissions:parse_config_file">INFO:permissions:parse_config_file</a>: file not found:
/opt/opensips2.2//etc/opensips/permissions.allow</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
<a class="moz-txt-link-freetext" href="INFO:permissions:mod_init">INFO:permissions:mod_init</a>: default allow file
(/opt/opensips2.2//etc/opensips/permissions.allow) not found
=> empty rule set</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
<a class="moz-txt-link-freetext" href="INFO:permissions:parse_config_file">INFO:permissions:parse_config_file</a>: file not found:
/opt/opensips2.2//etc/opensips/permissions.deny</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
<a class="moz-txt-link-freetext" href="INFO:permissions:mod_init">INFO:permissions:mod_init</a>: default deny file
(/opt/opensips2.2//etc/opensips/permissions.deny) not found
=> empty rule set</div>
<div>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/]</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:core:db_bind_mod: using db bind api for db_sqlite</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:core:db_do_init: connection 0x7fe95a2c9200 not found in
pool</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:core:db_do_init: connection 0x7fe95a2c9200 inserted in
pool as 0x7fe95a2c92a0</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:core:db_new_result: allocate 48 bytes for result set at
0x7fe95a2cb2c0</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:db_sqlite:db_sqlite_get_columns: 1 columns returned from
the query</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:core:db_allocate_columns: allocate 28 bytes for result
columns at 0x7fe95a2cb308</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:db_sqlite:db_sqlite_get_columns:
RES_NAMES(0x7fe95a2cb310)[0]=[table_version]</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:core:db_free_columns: freeing result columns at
0x7fe95a2cb308</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:core:db_new_result: allocate 48 bytes for result set at
0x7fe95a2cb2c0</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:db_sqlite:db_sqlite_get_columns: 8 columns returned from
the query</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:core:db_allocate_columns: allocate 224 bytes for result
columns at 0x7fe95a2cb378</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:db_sqlite:db_sqlite_get_columns:
RES_NAMES(0x7fe95a2cb3b8)[0]=[ip]</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:db_sqlite:db_sqlite_get_columns:
RES_NAMES(0x7fe95a2cb3c8)[1]=[grp]</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:db_sqlite:db_sqlite_get_columns:
RES_NAMES(0x7fe95a2cb3d8)[2]=[mask]</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:db_sqlite:db_sqlite_get_columns:
RES_NAMES(0x7fe95a2cb3e8)[3]=[port]</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:db_sqlite:db_sqlite_get_columns:
RES_NAMES(0x7fe95a2cb3f8)[4]=[proto]</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:db_sqlite:db_sqlite_get_columns:
RES_NAMES(0x7fe95a2cb408)[5]=[pattern]</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:db_sqlite:db_sqlite_get_columns:
RES_NAMES(0x7fe95a2cb418)[6]=[context_info]</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:permissions:reload_address_table: number of rows in
address table: 1</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]: <b>ERROR:permissions:reload_address_table:
invalid pattern column type on row 0, skipping..</b></div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:core:db_free_columns: freeing result columns at
0x7fe95a2cb378</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:permissions:reload_address_table: address table reloaded
successfully.</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:core:pool_remove: removing connection from the pool</div>
</div>
<div><br>
</div>
<div><br>
</div>
<div>I have tried different combinations, e.g, </div>
<div>1) Inserting data according to column type in address
table. </div>
<div>2) Inserting only a string "192.168.10.20" in 'ip' column
and keeping remaining columns default. </div>
<div><br>
</div>
<div>But with no luck. Could someone please suggest what i am
doing wrong here. </div>
<div><br>
</div>
<div>Best, </div>
<div>Aqs Younas</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>