<div dir="ltr">Apologies, Sorry for the fuss. Working perfectly. <br><div><br></div><div>Thanks. </div></div><div class="gmail_extra"><br><div class="gmail_quote">On 8 December 2017 at 15:36, Bogdan-Andrei Iancu <span dir="ltr"><<a 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>The "state" column is of integer type, see:<br>
         
<a class="m_4672733348204248107moz-txt-link-freetext" href="https://github.com/OpenSIPS/opensips/blob/2.3/scripts/dbtext/opensips/dispatcher" target="_blank">https://github.com/OpenSIPS/<wbr>opensips/blob/2.3/scripts/<wbr>dbtext/opensips/dispatcher</a><br>
      <br>
      Why do you have it as "string" in your file ???<br>
      <br>
      Regard,<br>
    </tt><span class="">
    <pre class="m_4672733348204248107moz-signature" cols="72">Bogdan-Andrei Iancu
  OpenSIPS Founder and Developer
  <a class="m_4672733348204248107moz-txt-link-freetext" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.<wbr>com</a>
</pre>
    </span><div><div class="h5"><div class="m_4672733348204248107moz-cite-prefix">On 12/08/2017 11:55 AM, Aqs Younas
      wrote:<br>
    </div>
    <blockquote type="cite">
      <div dir="ltr">Never thought there would be such parameter, this
        leaves me with the 3rd error.  Upon dispatcher reload I see this
        CRITICAL log. 
        <div><br>
        </div>
        <div><span style="font-size:12.8px">Dec  7 20:00:41 sbc2
            /usr/local/opensips/sbin/</span><span style="font-size:12.8px">opens<wbr>ips[2441]:
            CRITICAL:dispatcher:add_</span><span style="font-size:12.8px">dest2l<wbr>ist: BUG: unknown state
            -1953657376 for destination sip:</span><a href="http://172.31.0.107:5080/" style="font-size:12.8px" target="_blank">172.31.0.107:5080</a><br>
        </div>
        <div><br>
        </div>
        <div>
          <div style="font-size:12.8px">dispatcher table. </div>
          <div style="font-size:12.8px"><br>
          </div>
          <div style="font-size:12.8px">
            <div>id(int,auto) setid(int) destination(string)
              socket(string) state(string)  weight(int) priority(string)
              attrs(string) description(string)</div>
            <div>1:21:sip\:172.31.0.107\:5080:u<wbr>dp\:172.31.0.188\:5060:0:50:1:<wbr>backend=pbx.test.co-pbx.test.<wbr>co:first</div>
          </div>
        </div>
      </div>
      <div class="gmail_extra"><br>
        <div class="gmail_quote">On 8 December 2017 at 14:23,
          Bogdan-Andrei Iancu <span dir="ltr"><<a 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,<br>
                <br>
                What db_mode do you have in the dbtext module ?<br>
                <br>
                Regards,<br>
              </tt>
              <pre class="m_4672733348204248107m_213942019169823194moz-signature" cols="72">Bogdan-Andrei Iancu
  OpenSIPS Founder and Developer
  <a class="m_4672733348204248107m_213942019169823194moz-txt-link-freetext" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.<wbr>com</a>
</pre>
              <div>
                <div class="m_4672733348204248107h5">
                  <div class="m_4672733348204248107m_213942019169823194moz-cite-prefix">On
                    12/07/2017 10:09 PM, Aqs Younas wrote:<br>
                  </div>
                </div>
              </div>
              <blockquote type="cite">
                <div>
                  <div class="m_4672733348204248107h5">
                    <div dir="ltr">Greetings of the day, 
                      <div><br>
                      </div>
                      <div>I am having the following issues by using
                        DBTEXT with opensips 2.3.2 (x86_64/linux).</div>
                      <div>  </div>
                      <div>1. If I add anything(new domain) through
                        openipsctl it does not reflect in DBTEXT. </div>
                      <div>2. If I manually insert entries in DBTEXT,
                        reload command does not work. I had to restart
                        opensips to make changes effective. </div>
                      <div>3. I see this error on opensips restart no
                        matter whatever value I set in 'state' column of
                        the dispatcher. </div>
                      <div><br>
                      </div>
                      <div>
                        <div>Dec  7 20:00:41 sbc2
                          /usr/local/opensips/sbin/opens<wbr>ips[2441]:
                          CRITICAL:dispatcher:add_dest2l<wbr>ist: BUG:
                          unknown state -1953657376 for destination sip:<a href="http://172.31.0.107:5080" target="_blank">172.31.0.107:5080</a></div>
                      </div>
                      <div><br>
                        dispatcher table. </div>
                      <div><br>
                      </div>
                      <div>
                        <div>id(int,auto) setid(int) destination(string)
                          socket(string) state(string)  weight(int)
                          priority(string) attrs(string)
                          description(string)</div>
                        <div>1:21:sip\:172.31.0.107\:5080:u<wbr>dp\:172.31.0.188\:5060:0:50:1:<wbr>backend=pbx.test.co-pbx.test.<wbr>co:first</div>
                      </div>
                      <div><br>
                      </div>
                      <div><br>
                      </div>
                      <div>Any help would be much appreciated. <br>
                        <br>
                        Best Regards, </div>
                    </div>
                    <br>
                    <fieldset class="m_4672733348204248107m_213942019169823194mimeAttachmentHeader"></fieldset>
                    <br>
                  </div>
                </div>
                <pre>______________________________<wbr>_________________
Users mailing list
<a class="m_4672733348204248107m_213942019169823194moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a class="m_4672733348204248107m_213942019169823194moz-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>
              <br>
            </div>
          </blockquote>
        </div>
        <br>
      </div>
    </blockquote>
    <br>
  </div></div></div>

</blockquote></div><br></div>