<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    Hello,<br>
    <br>
    On 1/18/12 10:53 AM, Giacomo Vacca wrote:
    <blockquote
      cite="mid:A4E41C20520BEC409F1B16BA9FD72D34C82CD5@itixex01"
      type="cite">
      <meta http-equiv="Content-Type" content="text/html;
        charset=ISO-8859-1">
      <style>
<!--
@font-face
        {font-family:"Cambria Math"}
@font-face
        {font-family:Calibri}
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri","sans-serif"}
a:link, span.MsoHyperlink
        {color:blue;
        text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
        {color:purple;
        text-decoration:underline}
span.EmailStyle17
        {font-family:"Calibri","sans-serif";
        color:windowtext}
.MsoChpDefault
        {font-family:"Calibri","sans-serif"}
@page WordSection1
        {margin:72.0pt 72.0pt 72.0pt 72.0pt}
div.WordSection1
        {}
-->
</style>
      <div class="WordSection1">
        <p class="MsoNormal">Hi all,</p>
        <p class="MsoNormal">I've made a clean installation of kamailio
          3.2.0 from &#8216;<a class="moz-txt-link-freetext" href="http://deb.kamailio.org/kamailio32">http://deb.kamailio.org/kamailio32</a> squeeze main&#8217;</p>
        <p class="MsoNormal">repository, on a squeeze debian machine
          (2.6.32-5-686).</p>
      </div>
    </blockquote>
    can you switch to nightly builds from branch 3.2 just to be sure it
    is not related to something that was fixed since 3.2.0 was released?
    The repo are listed at:<br>
    <br>
<a class="moz-txt-link-freetext" href="http://www.kamailio.org/wiki/packages/debs#kamailio_32_-_nightly_builds">http://www.kamailio.org/wiki/packages/debs#kamailio_32_-_nightly_builds</a><br>
    <br>
    db_text is not really suitable for dealing with large data and write
    to disk when the sip server is shut down, maybe it is better to use
    db_sqlite for this case, at least you can check the content of the
    db table with sqlite tools.<br>
    <br>
    Cheers,<br>
    Daniel<br>
    <br>
    <br>
    <blockquote
      cite="mid:A4E41C20520BEC409F1B16BA9FD72D34C82CD5@itixex01"
      type="cite">
      <div class="WordSection1">
        <p class="MsoNormal">&nbsp;</p>
        <p class="MsoNormal">Installed also kamailio-presence-modules,
          same version.</p>
        <p class="MsoNormal">&nbsp;</p>
        <p class="MsoNormal">I'm just using the default kamailio.cfg
          that comes with the package, with these minimal additions:</p>
        <p class="MsoNormal">&nbsp;</p>
        <p class="MsoNormal">loadmodule "db_text.so"</p>
        <p class="MsoNormal">loadmodule "pua.so"</p>
        <p class="MsoNormal">loadmodule "pua_usrloc.so"</p>
        <p class="MsoNormal">&nbsp;</p>
        <p class="MsoNormal">...</p>
        <p class="MsoNormal">&nbsp;</p>
        <p class="MsoNormal">modparam("pua", "db_url",
          "text:///usr/share/kamailio/dbtext/kamailio")</p>
        <p class="MsoNormal">modparam("pua_usrloc", "default_domain",
          "192.168.142.130")</p>
        <p class="MsoNormal">&nbsp;</p>
        <p class="MsoNormal">Inside the registration management logic
          I've added pua_set_publish() right before saving the location:</p>
        <p class="MsoNormal">&nbsp;</p>
        <p class="MsoNormal">route[REGISTRAR] {</p>
        <p class="MsoNormal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (is_method("REGISTER"))</p>
        <p class="MsoNormal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {</p>
        <p class="MsoNormal">...</p>
        <p class="MsoNormal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pua_set_publish();</p>
        <p class="MsoNormal">&nbsp;</p>
        <p class="MsoNormal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (!save("location"))</p>
        <p class="MsoNormal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sl_reply_error();</p>
        <p class="MsoNormal">&nbsp;</p>
        <p class="MsoNormal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; exit;</p>
        <p class="MsoNormal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }</p>
        <p class="MsoNormal">}</p>
        <p class="MsoNormal">&nbsp;</p>
        <p class="MsoNormal">When I first register (XLite 4.1 for
          Windows), pua_usrloc correctly gets the callback and is able
          to generate a PUBLISH request through pua.</p>
        <p class="MsoNormal">&nbsp;</p>
        <p class="MsoNormal">But when there's an un-registration, or
          when the contact expires, even if the callbacks are correctly
          fired, the PUBLISH (which I'd expect with status 'closed') is
          not generated.</p>
        <p class="MsoNormal">&nbsp;</p>
        <p class="MsoNormal">From the logs (debug level 4), an
          un-registration:</p>
        <p class="MsoNormal">&nbsp;</p>
        <p class="MsoNormal">8(7652) DEBUG: usrloc [ul_callback.h:89]:
          contact=0xb50ae7cc, callback type 4/4, id 3 entered</p>
        <p class="MsoNormal">8(7652) DEBUG: pua_usrloc
          [ul_publish.c:216]:DELETE type</p>
        <p class="MsoNormal">8(7652) DEBUG: pua_usrloc
          [ul_publish.c:255]: uri= <a class="moz-txt-link-freetext" href="sip:20701090@192.168.142.130">sip:20701090@192.168.142.130</a></p>
        <p class="MsoNormal">8(7652) DEBUG: pua_usrloc
          [ul_publish.c:66]: publ:</p>
        <p class="MsoNormal">8(7652) DEBUG: pua_usrloc
          [ul_publish.c:67]: uri= <a class="moz-txt-link-freetext" href="sip:20701090@192.168.142.130">sip:20701090@192.168.142.130</a></p>
        <p class="MsoNormal">8(7652) DEBUG: pua_usrloc
          [ul_publish.c:68]:
          id=UL_PUBLISH.NmY5Zjc2YjcwNzEwNTk4YTY1NzA2Y2Y0MWQyMGRhOGY.</p>
        <p class="MsoNormal">8(7652) DEBUG: pua_usrloc
          [ul_publish.c:69]: expires= 0</p>
        <p class="MsoNormal">8(7652) DEBUG: pua [send_publish.c:403]:
          pres_uri=<a class="moz-txt-link-freetext" href="sip:20701090@192.168.142.130">sip:20701090@192.168.142.130</a></p>
        <p class="MsoNormal">8(7652) DEBUG: pua [hash.c:121]: core_hash=
          444</p>
        <p class="MsoNormal">8(7652) DEBUG: pua [hash.c:174]: record not
          found</p>
        <p class="MsoNormal">8(7652) DEBUG: pua [send_publish.c:444]:
          insert type</p>
        <p class="MsoNormal">8(7652) DEBUG: pua [send_publish.c:448]:
          UPDATE_TYPE and no record found</p>
        <p class="MsoNormal">8(7652) DEBUG: pua [send_publish.c:454]:
          request for a publish with expires 0 and no record found</p>
        <p class="MsoNormal">8(7652) DEBUG: sl [sl.c:278]: reply in
          stateless mode (sl)</p>
        <p class="MsoNormal">&nbsp;</p>
        <p class="MsoNormal">As an additional information, the pua table
          in</p>
        <p class="MsoNormal">/usr/share/kamailio/dbtext/kamailio/pua has
          not been populated.</p>
        <p class="MsoNormal">&nbsp;</p>
        <p class="MsoNormal">The AOR was correctly displayed with &#8216;ul
          show&#8217; while the registration was valid.</p>
        <p class="MsoNormal">&nbsp;</p>
        <p class="MsoNormal">Any suggestion on what am I be doing wrong?</p>
        <p class="MsoNormal">Would it be worth testing the same scenario
          using mysql as DB?</p>
        <p class="MsoNormal">&nbsp;</p>
        <p class="MsoNormal">Thanks in advance for your time.</p>
        <p class="MsoNormal">&nbsp;</p>
        <p class="MsoNormal">Giacomo</p>
      </div>
      <p class="MsoNormal" style="text-align:justify"><span
          style="font-size:11.0pt;
          font-family:&quot;Arial&quot;,&quot;sans-serif&quot;">Truphone
          Limited is a limited liability company registered in England
          &amp; Wales, registered office: 5 New Street Square, London
          EC4A 3TW.
          <span class="GramE">Registered No. 04187081.</span> VAT No. <span
            class="GramE">GB 851 5278 19.</span>
        </span></p>
      <p class="MsoNormal" style="text-align:justify"><span
          class="SpellE"><span style="font-size:11.0pt;
            font-family:&quot;Arial&quot;,&quot;sans-serif&quot;">Tru</span></span><span
          style="font-size:11.0pt;
          font-family:&quot;Arial&quot;,&quot;sans-serif&quot;"> is a
          brand name of Truphone and is a Truphone Communications
          Service. Truphone is a trading name for a number of distinct
          legal entities that operate in combination.
        </span><a moz-do-not-send="true" href="http://www.truphone.com"><span
            style="font-size:11.0pt;
            font-family:&quot;Arial&quot;,&quot;sans-serif&quot;">www.truphone.com</span></a><span
          style="font-size:11.0pt;
          font-family:&quot;Arial&quot;,&quot;sans-serif&quot;">.</span></p>
      <br clear="all">
      This e-mail, and any attachment(s), may contain information which
      is confidential and/or privileged, and is intended for the
      addressee only. If you are not the intended recipient, you may not
      use, disclose, copy or distribute this information in any manner
      whatsoever. If you have received this e-mail in error, please
      contact the sender immediately and delete it.<br>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
    </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://linkedin.com/in/miconda">http://linkedin.com/in/miconda</a> -- <a class="moz-txt-link-freetext" href="http://twitter.com/miconda">http://twitter.com/miconda</a></pre>
  </body>
</html>