<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    I did a quick test on a system that has the latest kamailio from
    branch 4.1 and was ok -- see below. I tested db_mode=1 or 2, though.<br>
    <br>
    # /usr/local/kamailio/sbin/kamctl ul show<br>
    <br>
    Domain:: location table=512 records=1 max_slot=1<br>
        AOR:: 1001<br>
            Contact:: <a class="moz-txt-link-freetext" href="sip:1001@1.2.3.4:40187;transport=UDP;ob">sip:1001@1.2.3.4:40187;transport=UDP;ob</a> Q=<br>
                Expires:: 38<br>
                Callid:: dPlovWVWKd0N6fEOPvFtqjknrIAv8-g2<br>
                Cseq:: 54907<br>
                User-agent:: QjSimple 0.6.6 (pjproject 1.14.2/darwin)<br>
                State:: CS_SYNC<br>
                Flags:: 0<br>
                Cflag:: 0<br>
                Socket:: <a class="moz-txt-link-freetext" href="udp:2.3.4.5:5060">udp:2.3.4.5:5060</a><br>
                Methods:: 8143<br>
                Ruid:: uloc-5321b268-976-1<br>
                Reg-Id:: 0<br>
                Last-Keepalive:: 1394725807<br>
                Last-Modified:: 1394725807<br>
    <br>
    # /usr/local/kamailio/sbin/kamctl ul show 1001<br>
    <br>
    Contact::
    <a class="moz-txt-link-rfc2396E" href="sip:1001@1.2.3.4:40187;transport=UDP;ob"><sip:1001@1.2.3.4:40187;transport=UDP;ob></a>;q=;expires=36;flags=0x0;cflags=0x0;state=1;socket=<a class="moz-txt-link-rfc2396E" href="udp:2.3.4.5:5060"><udp:2.3.4.5:5060></a>;methods=0x1FCF;user_agent=<QjSimple
    0.6.6 (pjproject 1.14.2/darwin)>;reg-id=0<br>
    <br>
    # /usr/local/kamailio/sbin/kamailio -v<br>
    <br>
    version: kamailio 4.1.2 (x86_64/linux) 9ce73e<br>
    flags: STATS: Off, USE_TCP, USE_TLS, TLS_HOOKS, USE_RAW_SOCKS,
    DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK, SHM_MEM, SHM_MMAP,
    PKG_MALLOC, DBG_QM_MALLOC, USE_FUTEX, FAST_LOCK-ADAPTIVE_WAIT,
    USE_DNS_CACHE, USE_DNS_FAILOVER, USE_NAPTR, USE_DST_BLACKLIST,
    HAVE_RESOLV_RES<br>
    ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN
    16, MAX_URI_SIZE 1024, BUF_SIZE 65535, DEFAULT PKG_SIZE 4MB<br>
    poll method support: poll, epoll_lt, epoll_et, sigio_rt, select.<br>
    id: 9ce73e<br>
    compiled on 19:07:28 Mar 10 2014 with gcc 4.4.7<br>
    <br>
    <div class="moz-cite-prefix">On 13/03/14 13:24, Raphael Borges
      wrote:<br>
    </div>
    <blockquote
cite="mid:CADsZGGsLVacM62HHMUBz8ayFH0HRFmwGvriCL=CVj+E5adG5eQ@mail.gmail.com"
      type="cite">
      <div dir="ltr">
        <div>Daniel understood, is really very strange. I will continue
          analyzing. </div>
        <div><br>
        </div>
        <div>Anyone else had the same problem? </div>
        <div><br>
        </div>
        <div>Thank you.</div>
      </div>
      <div class="gmail_extra">
        <br>
        <br>
        <div class="gmail_quote">2014-03-13 9:17 GMT-03:00
          Daniel-Constantin Mierla <span dir="ltr"><<a
              moz-do-not-send="true" href="mailto:miconda@gmail.com"
              target="_blank">miconda@gmail.com</a>></span>:<br>
          <blockquote class="gmail_quote" style="margin:0 0 0
            .8ex;border-left:1px #ccc solid;padding-left:1ex">
            <div bgcolor="#FFFFFF" text="#000000"> Hello,<br>
              <br>
              the code has to be reviewed, but personally I didn't have
              time for it yet -- hope to get to it very soon.<br>
              <br>
              I don't remember big changes of dumping the cache, there
              were some related to database queries, the reason why I
              asked for db_mode.<br>
              <br>
              Cheers,<br>
              Daniel
              <div>
                <div class="h5"><br>
                  <br>
                  <div>On 13/03/14 13:09, Raphael Borges wrote:<br>
                  </div>
                  <blockquote type="cite">
                    <div dir="ltr">Hello, something new?
                      <div><br>
                      </div>
                      <div>thanks.</div>
                    </div>
                    <div class="gmail_extra"><br>
                      <br>
                      <div class="gmail_quote">2014-03-11 10:46
                        GMT-03:00 Raphael Borges <span dir="ltr"><<a
                            moz-do-not-send="true"
                            href="mailto:raphaelsilvaborges@gmail.com"
                            target="_blank">raphaelsilvaborges@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>this value so:<br>
                            </div>
                            <div><br>
                            </div>
                            modparam("usrloc", "db_mode", 1)<br>
                            <div> <br>
                            </div>
                            <div>thanks</div>
                          </div>
                          <div class="gmail_extra"><br>
                            <br>
                            <div class="gmail_quote">2014-03-11 10:38
                              GMT-03:00 Daniel-Constantin Mierla <span
                                dir="ltr"><<a moz-do-not-send="true"
                                  href="mailto:miconda@gmail.com"
                                  target="_blank">miconda@gmail.com</a>></span>:
                              <div>
                                <div><br>
                                  <blockquote class="gmail_quote"
                                    style="margin:0 0 0
                                    .8ex;border-left:1px #ccc
                                    solid;padding-left:1ex">
                                    <div dir="auto">
                                      <div>Hello,</div>
                                      <div><br>
                                      </div>
                                      <div>What value do you have for
                                        db_mode parameter of usrloc
                                        module?</div>
                                      <div><br>
                                      </div>
                                      <div>Cheers,</div>
                                      <div>Daniel</div>
                                      <div><br>
                                        <br>
                                        Daniel-Constantin Mierla
                                        <div><a moz-do-not-send="true"
                                            href="http://www.asipto.com"
                                            target="_blank">http://www.asipto.com</a></div>
                                      </div>
                                      <div>
                                        <div>
                                          <div><br>
                                            On 11 Mar 2014, at 13:45,
                                            Raphael Borges <<a
                                              moz-do-not-send="true"
                                              href="mailto:raphaelsilvaborges@gmail.com"
                                              target="_blank">raphaelsilvaborges@gmail.com</a>>

                                            wrote:<br>
                                            <br>
                                          </div>
                                          <blockquote type="cite">
                                            <div>
                                              <div dir="ltr">
                                                <div>
                                                  <div>Hello, </div>
                                                  <div><br>
                                                  </div>
                                                  <div>I'm having a
                                                    problem with the
                                                    command kamctl ul
                                                    show, and I do not
                                                    understand what is
                                                    happening. On my
                                                    server when I run
                                                    just "kamctl ul
                                                    show" command works
                                                    fine but when I run
                                                    "kamctl ul show
                                                    [<username>]"
                                                    an error happens.
                                                    Before when I was
                                                    using Kamailio 3.1,
                                                    its work ok. I
                                                    looked for some
                                                    documentation and
                                                    found nothing about
                                                    this.</div>
                                                </div>
                                                <div><br>
                                                </div>
                                                <div>For example:</div>
                                                <div><br>
                                                </div>
                                                <div>
                                                  <div><b>$
                                                      /home2/local/kamailio/sbin/kamctl
                                                      ul show</b></div>
                                                  <div><br>
                                                  </div>
                                                  <div>Domain:: location
                                                    table=512 records=1
                                                    max_slot=1</div>
                                                  <div>        AOR::
                                                    2501</div>
                                                  <div>               
                                                    Contact:: sip:<a
                                                      moz-do-not-send="true"
href="mailto:2501@192.168.XXX.XXX" target="_blank">2501@192.168.XXX.XXX</a>:5060;transport=udp

                                                    Q=</div>
                                                  <div>                 
                                                          Expires:: 3594</div>
                                                  <div>                 
                                                          ...</div>
                                                  <div>Domain:: aliases
                                                    table=512 records=0
                                                    max_slot=0</div>
                                                  <div><br>
                                                  </div>
                                                  <div><br>
                                                  </div>
                                                  <div><b>$
                                                      /home2/local/kamailio/sbin/kamctl
                                                      ul show 2501</b></div>
                                                  <div>404 AOR not found</div>
                                                </div>
                                                <div><br>
                                                </div>
                                                <div>Thanks for Help.</div>
                                                <div>Best regards.</div>
                                                <div><br>
                                                </div>
                                                <div>Raphael</div>
                                                <div><br>
                                                </div>
                                              </div>
                                            </div>
                                          </blockquote>
                                        </div>
                                      </div>
                                      <blockquote type="cite">
                                        <div><span>_______________________________________________</span><br>
                                          <span>SIP Express Router (SER)
                                            and Kamailio (OpenSER) -
                                            sr-users mailing list</span><br>
                                          <span><a
                                              moz-do-not-send="true"
                                              href="mailto:sr-users@lists.sip-router.org"
                                              target="_blank">sr-users@lists.sip-router.org</a></span><br>
                                          <span><a
                                              moz-do-not-send="true"
                                              href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users"
                                              target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a></span><br>
                                        </div>
                                      </blockquote>
                                    </div>
                                    <br>
_______________________________________________<br>
                                    SIP Express Router (SER) and
                                    Kamailio (OpenSER) - sr-users
                                    mailing list<br>
                                    <a moz-do-not-send="true"
                                      href="mailto:sr-users@lists.sip-router.org"
                                      target="_blank">sr-users@lists.sip-router.org</a><br>
                                    <a moz-do-not-send="true"
                                      href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users"
                                      target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
                                    <br>
                                  </blockquote>
                                </div>
                              </div>
                            </div>
                            <br>
                          </div>
                        </blockquote>
                      </div>
                      <br>
                    </div>
                    <br>
                    <fieldset></fieldset>
                    <br>
                    <pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a moz-do-not-send="true" href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<a moz-do-not-send="true" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
                  </blockquote>
                  <br>
                </div>
              </div>
              <span class="HOEnZb"><font color="#888888">
                  <pre cols="72">-- 
Daniel-Constantin Mierla - <a moz-do-not-send="true" href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a moz-do-not-send="true" href="http://twitter.com/#%21/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a moz-do-not-send="true" href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Kamailio World Conference - April 2-4, 2014, Berlin, Germany
<a moz-do-not-send="true" href="http://www.kamailioworld.com" target="_blank">http://www.kamailioworld.com</a></pre>
                </font></span></div>
            <br>
            _______________________________________________<br>
            SIP Express Router (SER) and Kamailio (OpenSER) - sr-users
            mailing list<br>
            <a moz-do-not-send="true"
              href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
            <a moz-do-not-send="true"
              href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users"
              target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
            <br>
          </blockquote>
        </div>
        <br>
      </div>
    </blockquote>
    <br>
    <pre class="moz-signature" cols="72">-- 
Daniel-Constantin Mierla - <a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a>
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a>
Kamailio World Conference - April 2-4, 2014, Berlin, Germany
<a class="moz-txt-link-freetext" href="http://www.kamailioworld.com">http://www.kamailioworld.com</a></pre>
  </body>
</html>