<div dir="ltr">Thank you very much Dimitri, good point.<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Nov 17, 2017 at 2:38 PM, Dmitri Savolainen <span dir="ltr"><<a href="mailto:savolainen@erinaco.ru" target="_blank">savolainen@erinaco.ru</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">One of them is expired in my mind and wiating for  "usrloc" "timer_interval" for clearing in DB.  Expired contact will ignore while calling.  Like this<div><div>MariaDB [kamailio_dev]> select username, expires, UNIX_TIMESTAMP(expires) - UNIX_TIMESTAMP(now()), user_agent from location where username='000*888';</div><div>+----------+------------------<wbr>---+--------------------------<wbr>-----------------------+------<wbr>--------------------------+</div><div>| username | expires             | UNIX_TIMESTAMP(expires) - UNIX_TIMESTAMP(now()) | user_agent                     |</div><div>+----------+------------------<wbr>---+--------------------------<wbr>-----------------------+------<wbr>--------------------------+</div><div>| 000*888  | 2017-11-17 14:24:55 |                                            1260 | Yealink SIP-T46G 28.81.0.25    |</div><div>| 000*888  | 2017-11-17 14:02:02 |                                            -113 | CSipSimpl||errrr               |</div><div>| 000*888  | 2017-11-17 14:17:42 |                                             827 | Bria Android 3.9.6 build 99409 |</div><div>+----------+------------------<wbr>---+--------------------------<wbr>-----------------------+------<wbr>--------------------------+</div></div><div><br></div></div><div class="gmail_extra"><div><div class="h5"><br><div class="gmail_quote">2017-11-16 21:18 GMT+03:00 Gholamreza Sabery <span dir="ltr"><<a href="mailto:gr.sabery@gmail.com" target="_blank">gr.sabery@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div>Dear Daniel,<br><br></div>I can not use db_mode=1 in my setup; but I will try to test it.<br><br></div>Regards<br></div><br></div><div class="m_61583860536753795HOEnZb"><div class="m_61583860536753795h5"><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Nov 16, 2017 at 9:23 PM, Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
  
    
  
  <div text="#000000" bgcolor="#FFFFFF">
    <p>Very busy with the work this week ...</p>
    <p>To see if this a limitation of db only mode or not, can you test
      with db_mode=1?</p>
    <p>Cheers,<br>
      Daniel<br>
    </p><div><div class="m_61583860536753795m_-7351017498331083242h5">
    <br>
    <div class="m_61583860536753795m_-7351017498331083242m_-7119495321069708104moz-cite-prefix">On 16.11.17 16:51, Gholamreza Sabery
      wrote:<br>
    </div>
    <blockquote type="cite">
      <div dir="ltr">No ideas?<br>
      </div>
      <div class="gmail_extra"><br>
        <div class="gmail_quote">On Wed, Nov 15, 2017 at 3:27 PM,
          Gholamreza Sabery <span dir="ltr"><<a href="mailto:gr.sabery@gmail.com" target="_blank">gr.sabery@gmail.com</a>></span>
          wrote:<br>
          <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
            <div dir="ltr">
              <div>Hello Daniel,<br>
                <br>
              </div>
              I use a value of 3 for db_mode.<br>
            </div>
            <div class="m_61583860536753795m_-7351017498331083242m_-7119495321069708104HOEnZb">
              <div class="m_61583860536753795m_-7351017498331083242m_-7119495321069708104h5">
                <div class="gmail_extra"><br>
                  <div class="gmail_quote">On Wed, Nov 15, 2017 at 11:11
                    AM, Daniel-Constantin Mierla <span dir="ltr"><<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>></span>
                    wrote:<br>
                    <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
                      <div text="#000000" bgcolor="#FFFFFF">
                        <p>Hello,</p>
                        <p>what is the value of db_mode parameter for
                          usrloc module?</p>
                        <p>Cheers,<br>
                          Daniel<br>
                        </p>
                        <div>
                          <div class="m_61583860536753795m_-7351017498331083242m_-7119495321069708104m_-1763357836933203002h5"> <br>
                            <div class="m_61583860536753795m_-7351017498331083242m_-7119495321069708104m_-1763357836933203002m_3439348944046314360moz-cite-prefix">On
                              15.11.17 06:36, Gholamreza Sabery wrote:<br>
                            </div>
                          </div>
                        </div>
                        <blockquote type="cite">
                          <div>
                            <div class="m_61583860536753795m_-7351017498331083242m_-7119495321069708104m_-1763357836933203002h5">
                              <div dir="ltr">
                                <div>I have a Kamailio server that has:<br>
                                  <br>
                                  modparam("registrar", "max_contacts",
                                  2)<br>
                                  <br>
                                </div>
                                But recently I noticed some users have
                                more than two records in the location
                                table. For example one of the users has
                                three different records with nearly the
                                same information. The records are as
                                follows. Is this behavior normal? (I am
                                using Kamailio 4XX).<br>
                                <br>
                                *************************** 1. row
                                ***************************<br>
                                           id: 171296745<br>
                                         ruid:
                                uloc-2c69-59db6c73-7ca-132d92<br>
                                     username: 999999999999<br>
                                       domain: NULL<br>
                                      contact: <a href="http://sip:999999999999@5.106.35.18:10362" target="_blank">sip:999999999999@5.106.35.18:1<wbr>0362</a><br>
                                     received: sip:<a href="http://5.106.35.18:10361" target="_blank">5.106.35.18:10361</a><br>
                                         path: NULL<br>
                                      expires: 2017-11-14 08:45:50<br>
                                            q: -1.00<br>
                                       callid: XpCnmaAhRF<br>
                                         cseq: 43<br>
                                last_modified: 2017-11-14 08:44:50<br>
                                        flags: 0<br>
                                       cflags: 64<br>
                                   user_agent:
                                android_1.1.0_samsung_SM-E500H<wbr>_7b271714c08b942aa821fc756cdd2<wbr>e890a37069e/1.1.0
                                (belle-sip/1.4.2)<br>
                                       socket: udp:<a href="http://192.168.103.21:5060" target="_blank">192.168.103.21:5060</a><br>
                                      methods: NULL<br>
                                     instance:
                                <urn:uuid:8369ef6e-202b-4844-8<wbr>928-492a7678c269><br>
                                       reg_id: 0<br>
                                    server_id: 11369<br>
                                connection_id: -1<br>
                                    keepalive: 1<br>
                                    partition: 14<br>
                                *************************** 2. row
                                ***************************<br>
                                           id: 171296746<br>
                                         ruid:
                                uloc-2c69-59db6c73-7f2-eb5d92<br>
                                     username: 999999999999<br>
                                       domain: NULL<br>
                                      contact: <a href="http://sip:999999999999@5.106.35.18:10362" target="_blank">sip:999999999999@5.106.35.18:1<wbr>0362</a><br>
                                     received: sip:<a href="http://5.106.35.18:10361" target="_blank">5.106.35.18:10361</a><br>
                                         path: NULL<br>
                                      expires: 2017-11-14 08:45:50<br>
                                            q: -1.00<br>
                                       callid: BzMKuyJN8C<br>
                                         cseq: 50<br>
                                last_modified: 2017-11-14 08:44:50<br>
                                        flags: 0<br>
                                       cflags: 64<br>
                                   user_agent:
                                android_1.1.0_samsung_SM-E500H<wbr>_7b271714c08b942aa821fc756cdd2<wbr>e890a37069e/1.1.0
                                (belle-sip/1.4.2)<br>
                                       socket: udp:<a href="http://192.168.103.21:5060" target="_blank">192.168.103.21:5060</a><br>
                                      methods: NULL<br>
                                     instance:
                                <urn:uuid:8369ef6e-202b-4844-8<wbr>928-492a7678c269><br>
                                       reg_id: 0<br>
                                    server_id: 11369<br>
                                connection_id: -1<br>
                                    keepalive: 1<br>
                                    partition: 23<br>
                                *************************** 3. row
                                ***************************<br>
                                           id: 171296747<br>
                                         ruid:
                                uloc-2c69-59db6c73-80f-541d92<br>
                                     username: 999999999999<br>
                                       domain: NULL<br>
                                      contact: <a href="http://sip:999999999999@5.106.35.18:10362" target="_blank">sip:999999999999@5.106.35.18:1<wbr>0362</a><br>
                                     received: sip:<a href="http://5.106.35.18:10361" target="_blank">5.106.35.18:10361</a><br>
                                         path: NULL<br>
                                      expires: 2017-11-14 08:45:50<br>
                                            q: -1.00<br>
                                       callid: 3p9P4PgZSv<br>
                                         cseq: 51<br>
                                last_modified: 2017-11-14 08:44:50<br>
                                        flags: 0<br>
                                       cflags: 64<br>
                                   user_agent:
                                android_1.1.0_samsung_SM-E500H<wbr>_7b271714c08b942aa821fc756cdd2<wbr>e890a37069e/1.1.0
                                (belle-sip/1.4.2)<br>
                                       socket: udp:<a href="http://192.168.103.21:5060" target="_blank">192.168.103.21:5060</a><br>
                                      methods: NULL<br>
                                     instance:
                                <urn:uuid:8369ef6e-202b-4844-8<wbr>928-492a7678c269><br>
                                       reg_id: 0<br>
                                    server_id: 11369<br>
                                connection_id: -1<br>
                                    keepalive: 1<br>
                                    partition: 15</div>
                              <br>
                              <fieldset class="m_61583860536753795m_-7351017498331083242m_-7119495321069708104m_-1763357836933203002m_3439348944046314360mimeAttachmentHeader"></fieldset>
                              <br>
                            </div>
                          </div>
                          <pre>______________________________<wbr>_________________
Kamailio (SER) - Users Mailing List
<a class="m_61583860536753795m_-7351017498331083242m_-7119495321069708104m_-1763357836933203002m_3439348944046314360moz-txt-link-abbreviated" href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a>
<a class="m_61583860536753795m_-7351017498331083242m_-7119495321069708104m_-1763357836933203002m_3439348944046314360moz-txt-link-freetext" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">https://lists.kamailio.org/cgi<wbr>-bin/mailman/listinfo/sr-users</a><span class="m_61583860536753795m_-7351017498331083242m_-7119495321069708104m_-1763357836933203002HOEnZb"><font color="#888888">
</font></span></pre>
                          <span class="m_61583860536753795m_-7351017498331083242m_-7119495321069708104m_-1763357836933203002HOEnZb"><font color="#888888"> </font></span></blockquote>
                        <span class="m_61583860536753795m_-7351017498331083242m_-7119495321069708104m_-1763357836933203002HOEnZb"><font color="#888888"> <br>
                            <pre class="m_61583860536753795m_-7351017498331083242m_-7119495321069708104m_-1763357836933203002m_3439348944046314360moz-signature" cols="72">-- 
Daniel-Constantin Mierla
<a class="m_61583860536753795m_-7351017498331083242m_-7119495321069708104m_-1763357836933203002m_3439348944046314360moz-txt-link-abbreviated" href="http://www.twitter.com/miconda" target="_blank">www.twitter.com/miconda</a> -- <a class="m_61583860536753795m_-7351017498331083242m_-7119495321069708104m_-1763357836933203002m_3439348944046314360moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda" target="_blank">www.linkedin.com/in/miconda</a>
Kamailio Advanced Training, Nov 13-15, 2017, in Berlin - <a class="m_61583860536753795m_-7351017498331083242m_-7119495321069708104m_-1763357836933203002m_3439348944046314360moz-txt-link-abbreviated" href="http://www.asipto.com" target="_blank">www.asipto.com</a>
Kamailio World Conference - <a class="m_61583860536753795m_-7351017498331083242m_-7119495321069708104m_-1763357836933203002m_3439348944046314360moz-txt-link-abbreviated" href="http://www.kamailioworld.com" target="_blank">www.kamailioworld.com</a></pre>
                          </font></span></div>
                    </blockquote>
                  </div>
                  <br>
                </div>
              </div>
            </div>
          </blockquote>
        </div>
        <br>
      </div>
    </blockquote>
    <br>
    <pre class="m_61583860536753795m_-7351017498331083242m_-7119495321069708104moz-signature" cols="72">-- 
Daniel-Constantin Mierla
<a class="m_61583860536753795m_-7351017498331083242m_-7119495321069708104moz-txt-link-abbreviated" href="http://www.twitter.com/miconda" target="_blank">www.twitter.com/miconda</a> -- <a class="m_61583860536753795m_-7351017498331083242m_-7119495321069708104moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda" target="_blank">www.linkedin.com/in/miconda</a>
Kamailio Advanced Training, Nov 13-15, 2017, in Berlin - <a class="m_61583860536753795m_-7351017498331083242m_-7119495321069708104moz-txt-link-abbreviated" href="http://www.asipto.com" target="_blank">www.asipto.com</a>
Kamailio World Conference - <a class="m_61583860536753795m_-7351017498331083242m_-7119495321069708104moz-txt-link-abbreviated" href="http://www.kamailioworld.com" target="_blank">www.kamailioworld.com</a></pre>
  </div></div></div>

</blockquote></div><br></div>
</div></div><br>______________________________<wbr>_________________<br>
Kamailio (SER) - Users Mailing List<br>
<a href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a><br>
<a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">https://lists.kamailio.org/cgi<wbr>-bin/mailman/listinfo/sr-users</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br></div></div><span class="HOEnZb"><font color="#888888"><div class="m_61583860536753795gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div>Savolainen Dmitri</div></div></div></div></div>
</font></span></div>
<br>______________________________<wbr>_________________<br>
Kamailio (SER) - Users Mailing List<br>
<a href="mailto:sr-users@lists.kamailio.org">sr-users@lists.kamailio.org</a><br>
<a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">https://lists.kamailio.org/<wbr>cgi-bin/mailman/listinfo/sr-<wbr>users</a><br>
<br></blockquote></div><br></div>