<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>Hi Aqs,<br>
<br>
OK, let us run a test and John will be back with you.<br>
<br>
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 22:12, Aqs Younas wrote:<br>
</div>
<blockquote
cite="mid:CAGVOjVXH3hdyGRgJJz9aC3Hh4NuB8q8T9Fye98CXX=Vx9YbYpw@mail.gmail.com"
type="cite">
<div dir="ltr">i have tried multiple things but all in vain.
<div><br>
</div>
<div>
<div>1) sqlite> insert into address(ip)
values('192.168.10.20');</div>
</div>
<div>
<div> sqlite> select * from address;</div>
<div> id|grp|ip|mask|port|proto|pattern|context_info</div>
<div> 5|0|192.168.10.20|32|0|any||</div>
</div>
<div><br>
</div>
<div>2) sqlite> INSERT INTO "main"."address" VALUES (1, 1,
'192.168.10.30', 30, 0, 'ANY', null, '12345675');</div>
<div> sqlite> select * from address;</div>
<div> id|grp|ip|mask|port|proto|pattern|context_info</div>
<div> 1|1|192.168.10.30|30|0|ANY||12345675</div>
<div><br>
</div>
<div>Thanks for replying. Let me know if you need anything
else. </div>
<div>Regards. </div>
<div><br>
</div>
<div><br>
</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On 8 December 2016 at 00:20,
Bogdan-Andrei Iancu <span dir="ltr"><<a
moz-do-not-send="true" href="mailto:bogdan@opensips.org"
target="_blank">bogdan@opensips.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div 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="m_3159444976041267291moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a moz-do-not-send="true" class="m_3159444976041267291moz-txt-link-freetext" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.<wbr>com</a></pre><div><div class="h5">
<div class="m_3159444976041267291moz-cite-prefix">On 07.12.2016 16:45, Aqs Younas wrote:
</div>
</div></div><blockquote type="cite"><div><div class="h5">
<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>
</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 moz-do-not-send="true" class="m_3159444976041267291moz-txt-link-freetext">INFO:permissions:parse_config_<wbr>file</a>: file not found:
/opt/opensips2.2//etc/<wbr>opensips/permissions.allow</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
<a moz-do-not-send="true" class="m_3159444976041267291moz-txt-link-freetext">INFO:permissions:mod_init</a>: default allow file
(/opt/opensips2.2//etc/<wbr>opensips/permissions.allow) not found
=> empty rule set</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
<a moz-do-not-send="true" class="m_3159444976041267291moz-txt-link-freetext">INFO:permissions:parse_config_<wbr>file</a>: file not found:
/opt/opensips2.2//etc/<wbr>opensips/permissions.deny</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
<a moz-do-not-send="true" class="m_3159444976041267291moz-txt-link-freetext">INFO:permissions:mod_init</a>: default deny file
(/opt/opensips2.2//etc/<wbr>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/<wbr>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_<wbr>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_<wbr>columns:
RES_NAMES(0x7fe95a2cb310)[0]=[<wbr>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_<wbr>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_<wbr>columns:
RES_NAMES(0x7fe95a2cb3b8)[0]=[<wbr>ip]</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:db_sqlite:db_sqlite_get_<wbr>columns:
RES_NAMES(0x7fe95a2cb3c8)[1]=[<wbr>grp]</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:db_sqlite:db_sqlite_get_<wbr>columns:
RES_NAMES(0x7fe95a2cb3d8)[2]=[<wbr>mask]</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:db_sqlite:db_sqlite_get_<wbr>columns:
RES_NAMES(0x7fe95a2cb3e8)[3]=[<wbr>port]</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:db_sqlite:db_sqlite_get_<wbr>columns:
RES_NAMES(0x7fe95a2cb3f8)[4]=[<wbr>proto]</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:db_sqlite:db_sqlite_get_<wbr>columns:
RES_NAMES(0x7fe95a2cb408)[5]=[<wbr>pattern]</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:db_sqlite:db_sqlite_get_<wbr>columns:
RES_NAMES(0x7fe95a2cb418)[6]=[<wbr>context_info]</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]:
DBG:permissions:reload_<wbr>address_table: number of rows in
address table: 1</div>
<div>Dec 7 09:32:45 CDSdev ./opensips[23421]: <b>ERROR:permissions:reload_<wbr>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_<wbr>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>
</div>
<div>
</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>
</div>
<div>But with no luck. Could someone please suggest what i am
doing wrong here. </div>
<div>
</div>
<div>Best, </div>
<div>Aqs Younas</div>
</div>
<fieldset class="m_3159444976041267291mimeAttachmentHeader"></fieldset>
</div></div><pre>______________________________<wbr>_________________
Users mailing list
<a moz-do-not-send="true" class="m_3159444976041267291moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a moz-do-not-send="true" class="m_3159444976041267291moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-<wbr>bin/mailman/listinfo/users</a>
</pre>
</blockquote>
</div>
</blockquote></div>
</div>
</blockquote>
</body></html>