<div dir="ltr">Thanks.It&#39;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">&lt;<a href="mailto:ionutionita@opensips.org" target="_blank">ionutionita@opensips.org</a>&gt;</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
            =&gt; 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
            =&gt; empty rule set</div>
          <div>Dec  7 09:32:45 CDSdev ./opensips[23421]:
            DBG:core:find_mod_export: found &lt;db_bind_api&gt; 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 &quot;192.168.10.20&quot; in &#39;ip&#39; 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>