<div dir="ltr">Thanks.It's working perfectly. :)</div><div class="gmail_extra"><br><div class="gmail_quote">On 8 December 2016 at 20:45, Ionut Ionita <span dir="ltr"><<a href="mailto:ionutionita@opensips.org" target="_blank">ionutionita@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">
<p><font size="-1">Hello,</font></p>
<font size="-1">It should be solved. Check [0] for master branch and
[1] for 2.2 .<br>
<br>
[0]
<a class="m_-7709736886438972323moz-txt-link-freetext" href="https://github.com/OpenSIPS/opensips/commit/642e8879c10aa38a8745c6db173c447c54c3cddf" target="_blank">https://github.com/OpenSIPS/<wbr>opensips/commit/<wbr>642e8879c10aa38a8745c6db173c44<wbr>7c54c3cddf</a><br>
[1]
<a class="m_-7709736886438972323moz-txt-link-freetext" href="https://github.com/OpenSIPS/opensips/commit/2d55067cdb9ec284ea0d55e1e90dbd421d244a6f" target="_blank">https://github.com/OpenSIPS/<wbr>opensips/commit/<wbr>2d55067cdb9ec284ea0d55e1e90dbd<wbr>421d244a6f</a></font>
<pre class="m_-7709736886438972323moz-signature" cols="72">Regards,
Ionut Ionita
OpenSIPS Developer</pre><div><div class="h5">
<div class="m_-7709736886438972323moz-cite-prefix">On 12/07/2016 04:45 PM, Aqs Younas
wrote:<br>
</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><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="m_-7709736886438972323moz-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 class="m_-7709736886438972323moz-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 class="m_-7709736886438972323moz-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 class="m_-7709736886438972323moz-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><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="m_-7709736886438972323mimeAttachmentHeader"></fieldset>
<br>
</div></div><span class=""><pre>______________________________<wbr>_________________
Users mailing list
<a class="m_-7709736886438972323moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a class="m_-7709736886438972323moz-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>
</span></blockquote>
<br>
</div>
<br>______________________________<wbr>_________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.opensips.org/cgi-<wbr>bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div>