<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&gt; insert into address(ip)
            values('192.168.10.20');</div>
        </div>
        <div>
          <div>    sqlite&gt; 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&gt; INSERT INTO "main"."address" VALUES (1, 1,
          '192.168.10.30', 30, 0, 'ANY', null, '12345675');</div>
        <div>    sqlite&gt; 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">&lt;<a
              moz-do-not-send="true" href="mailto:bogdan@opensips.org"
              target="_blank">bogdan@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"> <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
            =&gt; 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
            =&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>

        </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>