<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
@font-face
{font-family:Tahoma}
@font-face
{font-family:Consolas}
@font-face
{font-family:"Times New Roman \, serif"}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
color:black}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
pre
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
color:black}
span.HTMLPreformattedChar
{font-family:Consolas;
color:black}
p.msochpdefault, li.msochpdefault, div.msochpdefault
{margin-right:0cm;
margin-left:0cm;
font-size:12.0pt;
font-family:"Calibri","sans-serif";
color:black}
span.emailstyle17
{font-family:"Calibri","sans-serif";
color:windowtext}
span.htmlpreformattedchar0
{font-family:Consolas;
color:black}
span.emailstyle23
{font-family:"Calibri","sans-serif";
color:#1F497D}
span.EmailStyle24
{font-family:"Calibri","sans-serif";
color:#1F497D}
.MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:72.0pt 72.0pt 72.0pt 72.0pt}
div.WordSection1
{}
-->
</style>
</head>
<body bgcolor="white" lang="EN-GB" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Hi Daniel,</span></p>
<p class="MsoNormal"><span style="color:#1F497D">Thanks for your feedback. Yes, using mysql and enabling presence made it work for un-registrations too.</span></p>
<p class="MsoNormal"><span style="color:#1F497D">Just for the purpose of this scenario I’m sending the PUBLISH back to the same entity, and it’s being handled as a presentity.</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="color:#1F497D">I still have a missing piece though (which is in fact the reason for this configuration): having PUBLISH requests triggered by the expiration of a contact.</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="color:#1F497D">When a contact expires, pua_usrloc is now logging:</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Jan 19 10:12:03 debian6 /usr/sbin/kamailio[4359]: INFO: pua_usrloc [ul_publish.c:211]: should not send ul publish</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="color:#1F497D">(please see below for traces and details).</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="color:#1F497D">Since I’m marking a registration with pua_set_publish(), why is that flag not seen as true when usrloc fires an EXPIRE callback?</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="color:#1F497D">I’ve tried marking every REGISTER request with pua_set_publish(), and not just the first one, before calling save(“location”) but the result was the same.</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="color:#1F497D">Thanks again,</span></p>
<p class="MsoNormal"><span style="color:#1F497D">Giacomo</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="color:#1F497D">First registration and PUBLISH:</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">U 2012/01/19 10:08:46.867546 192.168.142.1:13752 -> 192.168.142.131:5060</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">REGISTER sip:192.168.142.131 SIP/2.0.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Via: SIP/2.0/UDP 192.168.142.1:13752;branch=z9hG4bK-d8754z-6dcc94d7866db11d-1---d8754z-;rport.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Max-Forwards: 70.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Contact: <sip:2070109@192.168.142.1:13752;rinstance=f949af25d45274c6>.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">To: "GV_XLite"<sip:2070109@192.168.142.131>.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">From: "GV_XLite"<sip:2070109@192.168.142.131>;tag=0c957d3f.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Call-ID: ZmI1OGFhMzIyYTExNTYzOTIzNDRiZmI1NjQzZGZhZDI..</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">CSeq: 1 REGISTER.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Expires: 3600.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, NOTIFY, MESSAGE, SUBSCRIBE, INFO.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">User-Agent: X-Lite 4 release 4.1 stamp 63214.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Content-Length: 0.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> </span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> </span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">U 2012/01/19 10:08:46.870154 192.168.142.131:5060 -> 127.0.0.1:5060</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">PUBLISH sip:2070109@127.0.0.1 SIP/2.0.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Via: SIP/2.0/UDP 192.168.142.131;branch=z9hG4bK0722.77d94013.0.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">To: sip:2070109@127.0.0.1.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">From: sip:2070109@127.0.0.1;tag=533cb9e91f4b999cf76861cbb9ed54ed-168c.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">CSeq: 10 PUBLISH.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Call-ID: 7fedefec-4355@127.0.0.1.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Content-Length: 338.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">User-Agent: kamailio (3.2.1 (i386/linux)).</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Max-Forwards: 70.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Event: presence.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Expires: 61.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Content-Type: application/pidf+xml.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"><?xml version="1.0"?></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"><presence xmlns="urn:ietf:params:xml:ns:pidf" xmlns:dm="urn:ietf:params:xml:ns:pidf:data-model" xmlns:rpid="urn:ietf:params:xml:ns:pidf:rpid" xmlns:c="urn:ietf:params:xml:ns:pidf:cipid"
entity="2070109@127.0.0.1"></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> <tuple id="0xb727ad14"></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> <status></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> <basic>open</basic></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> </status></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> </tuple></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"></presence></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> </span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> </span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">U 2012/01/19 10:08:46.872917 127.0.0.1:5060 -> 192.168.142.131:5060</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">SIP/2.0 200 OK.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Via: SIP/2.0/UDP 192.168.142.131;branch=z9hG4bK0722.77d94013.0.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">To: sip:2070109@127.0.0.1;tag=a6a1c5f60faecf035a1ae5b6e96e979a-106f.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">From: sip:2070109@127.0.0.1;tag=533cb9e91f4b999cf76861cbb9ed54ed-168c.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">CSeq: 10 PUBLISH.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Call-ID: 7fedefec-4355@127.0.0.1.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Expires: 60.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">SIP-ETag: a.1326967203.4352.2.0.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Server: kamailio (3.2.1 (i386/linux)).</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Content-Length: 0.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> </span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> </span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">U 2012/01/19 10:08:46.874271 192.168.142.131:5060 -> 192.168.142.1:13752</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">SIP/2.0 200 OK.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Via: SIP/2.0/UDP 192.168.142.1:13752;branch=z9hG4bK-d8754z-6dcc94d7866db11d-1---d8754z-;rport=13752.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">To: "GV_XLite"<sip:2070109@192.168.142.131>;tag=b27e1a1d33761e85846fc98f5f3a7e58.4cd5.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">From: "GV_XLite"<sip:2070109@192.168.142.131>;tag=0c957d3f.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Call-ID: ZmI1OGFhMzIyYTExNTYzOTIzNDRiZmI1NjQzZGZhZDI..</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">CSeq: 1 REGISTER.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Contact: <sip:2070109@192.168.142.1:13752;rinstance=f949af25d45274c6>;expires=60.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Server: kamailio (3.2.1 (i386/linux)).</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Content-Length: 0.</span></p>
<p class="MsoNormal"><span style="font-family:"Courier New"; color:windowtext">.</span><span style="color:#1F497D"></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="color:#1F497D">Registration refresh and PUBLISH:</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">U 2012/01/19 10:09:41.599554 192.168.142.1:13752 -> 192.168.142.131:5060</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">REGISTER sip:192.168.142.131 SIP/2.0.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Via: SIP/2.0/UDP 192.168.142.1:13752;branch=z9hG4bK-d8754z-4e5bc39865a12b22-1---d8754z-;rport.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Max-Forwards: 70.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Contact: <sip:2070109@192.168.142.1:13752;rinstance=f949af25d45274c6>.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">To: "GV_XLite"<sip:2070109@192.168.142.131>.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">From: "GV_XLite"<sip:2070109@192.168.142.131>;tag=0c957d3f.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Call-ID: ZmI1OGFhMzIyYTExNTYzOTIzNDRiZmI1NjQzZGZhZDI..</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">CSeq: 2 REGISTER.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Expires: 3600.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, NOTIFY, MESSAGE, SUBSCRIBE, INFO.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">User-Agent: X-Lite 4 release 4.1 stamp 63214.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Content-Length: 0.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> </span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> </span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">U 2012/01/19 10:09:41.605967 192.168.142.131:5060 -> 127.0.0.1:5060</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">PUBLISH sip:2070109@127.0.0.1 SIP/2.0.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Via: SIP/2.0/UDP 192.168.142.131;branch=z9hG4bK568c.a38addc4.0.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">To: sip:2070109@127.0.0.1.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">From: sip:2070109@127.0.0.1;tag=533cb9e91f4b999cf76861cbb9ed54ed-001d.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">CSeq: 10 PUBLISH.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Call-ID: 7fedefed-4357@127.0.0.1.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Content-Length: 0.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">User-Agent: kamailio (3.2.1 (i386/linux)).</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Max-Forwards: 70.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Event: presence.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Expires: 61.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">SIP-If-Match: a.1326967203.4352.2.0.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> </span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> </span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">U 2012/01/19 10:09:41.617174 127.0.0.1:5060 -> 192.168.142.131:5060</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">SIP/2.0 200 OK.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Via: SIP/2.0/UDP 192.168.142.131;branch=z9hG4bK568c.a38addc4.0.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">To: sip:2070109@127.0.0.1;tag=a6a1c5f60faecf035a1ae5b6e96e979a-70c8.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">From: sip:2070109@127.0.0.1;tag=533cb9e91f4b999cf76861cbb9ed54ed-001d.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">CSeq: 10 PUBLISH.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Call-ID: 7fedefed-4357@127.0.0.1.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Expires: 60.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">SIP-ETag: a.1326967203.4351.2.1.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Server: kamailio (3.2.1 (i386/linux)).</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Content-Length: 0.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> </span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> </span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">U 2012/01/19 10:09:41.620221 192.168.142.131:5060 -> 192.168.142.1:13752</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">SIP/2.0 200 OK.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Via: SIP/2.0/UDP 192.168.142.1:13752;branch=z9hG4bK-d8754z-4e5bc39865a12b22-1---d8754z-;rport=13752.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">To: "GV_XLite"<sip:2070109@192.168.142.131>;tag=b27e1a1d33761e85846fc98f5f3a7e58.9769.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">From: "GV_XLite"<sip:2070109@192.168.142.131>;tag=0c957d3f.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Call-ID: ZmI1OGFhMzIyYTExNTYzOTIzNDRiZmI1NjQzZGZhZDI..</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">CSeq: 2 REGISTER.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Contact: <sip:2070109@192.168.142.1:13752;rinstance=f949af25d45274c6>;expires=60.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Server: kamailio (3.2.1 (i386/linux)).</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Content-Length: 0.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">.</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="color:#1F497D">Now pua table contains:</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">> SELECT * FROM pua\G</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">*************************** 1. row ***************************</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> id: 12</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> pres_uri: sip:2070109@127.0.0.1</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> pres_id: UL_PUBLISH.ZmI1OGFhMzIyYTExNTYzOTIzNDRiZmI1NjQzZGZhZDI.</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> event: 1</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> expires: 1326967841</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">desired_expires: 1326967841</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> flag: 1</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> etag: a.1326967203.4351.2.1</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> tuple_id: 0xb727ad14</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> watcher_uri:
</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> call_id:
</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> to_tag:
</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> from_tag:
</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> cseq: 0</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> record_route:
</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> contact:
</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> remote_contact:
</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> version: 1</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext"> extra_headers:
</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">1 row in set (0.00 sec)</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="color:#1F497D">Then I kill the client, and wait for the contact expiration. This is logged (debug level 4), and no PUBLISH issued:</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Jan 19 10:12:03 debian6 /usr/sbin/kamailio[4359]: DEBUG: usrloc [ul_callback.h:89]: contact=0xb4db7638, callback type 8/8, id 1 entered</span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-family:"Courier New"; color:windowtext">Jan 19 10:12:03 debian6 /usr/sbin/kamailio[4359]: INFO: pua_usrloc [ul_publish.c:211]: should not send ul publish</span></p>
<p class="MsoNormal"><span style="font-family:"Courier New"; color:windowtext">Jan 19 10:12:03 debian6 /usr/sbin/kamailio[4359]: DEBUG: usrloc [urecord.c:246]: Binding '2070109','sip:2070109@192.168.142.1:13752;rinstance=f949af25d45274c6' has expired</span><span style="color:#1F497D"></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<div>
<div style="border:none; border-top:solid #B5C4DF 1.0pt; padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt; font-family:"Tahoma","sans-serif"; color:windowtext">From:</span></b><span lang="EN-US" style="font-size:10.0pt; font-family:"Tahoma","sans-serif"; color:windowtext"> Daniel-Constantin Mierla
[mailto:miconda@gmail.com] <br>
<b>Sent:</b> 18 January 2012 21:17<br>
<b>To:</b> SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users Mailing List<br>
<b>Cc:</b> Giacomo Vacca<br>
<b>Subject:</b> Re: [SR-Users] pua_usrloc, PUBLISH not send when contact is deleted or expires</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Hello,<br>
<br>
On 1/18/12 12:50 PM, Giacomo Vacca wrote: </p>
<div>
<p class="MsoNormal"><span style="color:#1F497D">Thanks Daniel,</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<p class="MsoNormal"><span style="color:#1F497D">> </span><span style="font-size:12.0pt; font-family:"Times New Roman , serif","serif"">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?</span></p>
<p class="MsoNormal"><span style="font-size:12.0pt; font-family:"Times New Roman","serif""> </span></p>
<p class="MsoNormal"><span style="font-size:12.0pt; font-family:"Times New Roman","serif"">I’ve switched and now have installed 3.2.1, and moved to sqlite too.</span></p>
<p class="MsoNormal"><span style="font-size:12.0pt; font-family:"Times New Roman","serif"">I’ve spent some time to verify a change in behaviour, but I’m observing the same.</span></p>
<p class="MsoNormal"><span style="font-size:12.0pt; font-family:"Times New Roman","serif"">Registering with a different device (e.g. sipp) gives the same result.</span></p>
</div>
<p class="MsoNormal"><span style="font-size:12.0pt; font-family:"Times New Roman","serif""><br>
I tested with default config, where I enabled mysql and presence service, plus loaded and configured pua and pua_usrloc similar to your snippet. All seemed ok, I pasted the ngrep to the end of my reply, first for register and then for un-register.<br>
<br>
In your case, is the publish for registration getting 200ok?<br>
</span><span style="font-size:12.0pt; font-family:"Times New Roman , serif","serif""><br>
<br>
</span><span style="font-size:12.0pt; font-family:"Times New Roman","serif""></span></p>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt; font-family:"Times New Roman","serif""> </span></p>
<p class="MsoNormal"><span style="color:#1F497D">> </span><span style="font-size:12.0pt; font-family:"Times New Roman , serif","serif"">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.</span></p>
<p class="MsoNormal"><span style="font-size:12.0pt; font-family:"Times New Roman","serif""> </span></p>
<p class="MsoNormal"><span style="font-size:12.0pt; font-family:"Times New Roman","serif"">My current goal is a proof of concept so I’m not concerned about performances – am I right in thinking that the problem in finding the presentity in pua’s hash table
is independent from the DB usage, or may it have an impact?</span></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:12.0pt; font-family:"Times New Roman","serif""><br>
Well, the issue of using db_text might be with storing the xml documents (publish body) in presence table. db_text keeps a raw per line in a text file.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<br>
U 2012/01/18 21:52:40.729795 127.0.0.1:57982 -> 127.0.0.1:5060<br>
REGISTER <a href="sip:127.0.0.1">sip:127.0.0.1</a> SIP/2.0.<br>
Via: SIP/2.0/UDP 127.0.1.1:5080;branch=z9hG4bK.29f7bb6d;rport;alias.<br>
From: <a href="sip:test@127.0.0.1;tag=41f6277b">sip:test@127.0.0.1;tag=41f6277b</a>.<br>
To: <a href="sip:test@127.0.0.1">sip:test@127.0.0.1</a>.<br>
Call-ID: <a href="mailto:1106651003@127.0.1.1">1106651003@127.0.1.1</a>.<br>
CSeq: 1 REGISTER.<br>
Content-Length: 0.<br>
Max-Forwards: 70.<br>
User-Agent: sipsak 0.9.6.<br>
Expires: 70.<br>
Contact: <a href="sip:test@127.0.1.1:5080">sip:test@127.0.1.1:5080</a>.<br>
.<br>
<br>
<br>
U 2012/01/18 21:52:40.732876 127.0.0.1:5060 -> 127.0.0.1:5060<br>
PUBLISH <a href="sip:test@127.0.0.1">sip:test@127.0.0.1</a> SIP/2.0.<br>
Via: SIP/2.0/UDP 127.0.0.1;branch=z9hG4bK25a7.88a7c0d5.0.<br>
To: <a href="sip:test@127.0.0.1">sip:test@127.0.0.1</a>.<br>
From: <a href="sip:test@127.0.0.1;tag=533cb9e91f4b999cf76861cbb9ed54ed-76e3">sip:test@127.0.0.1;tag=533cb9e91f4b999cf76861cbb9ed54ed-76e3</a>.<br>
CSeq: 10 PUBLISH.<br>
Call-ID: <a href="mailto:53162b3d3a4cff50-20164@127.0.0.1">53162b3d3a4cff50-20164@127.0.0.1</a>.<br>
Content-Length: 339.<br>
User-Agent: kamailio (3.3.0-dev5 (x86_64/linux)).<br>
Max-Forwards: 70.<br>
Event: presence.<br>
Expires: 71.<br>
Content-Type: application/pidf+xml.<br>
.<br>
<?xml version="1.0"?><br>
<presence xmlns="urn:ietf:params:xml:ns:pidf" xmlns:dm="urn:ietf:params:xml:ns:pidf:data-model" xmlns:rpid="urn:ietf:params:xml:ns:pidf:rpid" xmlns:c="urn:ietf:params:xml:ns:pidf:cipid" entity=<a href="mailto:test@127.0.0.1">"test@127.0.0.1"</a>><br>
<tuple id="0x7f6352b80eb0"><br>
<status><br>
<basic>open</basic><br>
</status><br>
</tuple><br>
</presence><br>
<br>
<br>
U 2012/01/18 21:52:40.733052 127.0.0.1:5060 -> 127.0.0.1:57982<br>
SIP/2.0 200 OK.<br>
Via: SIP/2.0/UDP 127.0.1.1:5080;branch=z9hG4bK.29f7bb6d;rport=57982;alias;received=127.0.0.1.<br>
From: <a href="sip:test@127.0.0.1;tag=41f6277b">sip:test@127.0.0.1;tag=41f6277b</a>.<br>
To: <a href="sip:test@127.0.0.1;tag=b27e1a1d33761e85846fc98f5f3a7e58.12b3">sip:test@127.0.0.1;tag=b27e1a1d33761e85846fc98f5f3a7e58.12b3</a>.<br>
Call-ID: <a href="mailto:1106651003@127.0.1.1">1106651003@127.0.1.1</a>.<br>
CSeq: 1 REGISTER.<br>
Contact: <a href="sip:test@127.0.1.1:5080"><sip:test@127.0.1.1:5080></a>;expires=70.<br>
Server: kamailio (3.3.0-dev5 (x86_64/linux)).<br>
Content-Length: 0.<br>
.<br>
<br>
<br>
U 2012/01/18 21:52:40.740026 127.0.0.1:5060 -> 127.0.0.1:5060<br>
SIP/2.0 200 OK.<br>
Via: SIP/2.0/UDP 127.0.0.1;branch=z9hG4bK25a7.88a7c0d5.0.<br>
To: <a href="sip:test@127.0.0.1;tag=a6a1c5f60faecf035a1ae5b6e96e979a-0f93">sip:test@127.0.0.1;tag=a6a1c5f60faecf035a1ae5b6e96e979a-0f93</a>.<br>
From: <a href="sip:test@127.0.0.1;tag=533cb9e91f4b999cf76861cbb9ed54ed-76e3">sip:test@127.0.0.1;tag=533cb9e91f4b999cf76861cbb9ed54ed-76e3</a>.<br>
CSeq: 10 PUBLISH.<br>
Call-ID: <a href="mailto:53162b3d3a4cff50-20164@127.0.0.1">53162b3d3a4cff50-20164@127.0.0.1</a>.<br>
Expires: 71.<br>
SIP-ETag: a.1326919182.20164.3.0.<br>
Server: kamailio (3.3.0-dev5 (x86_64/linux)).<br>
Content-Length: 0.<br>
.<br>
<br>
<br>
<br>
<br>
U 2012/01/18 21:53:01.800384 127.0.0.1:36942 -> 127.0.0.1:5060<br>
REGISTER <a href="sip:127.0.0.1">sip:127.0.0.1</a> SIP/2.0.<br>
Via: SIP/2.0/UDP 127.0.1.1:5080;branch=z9hG4bK.55f81f68;rport;alias.<br>
From: <a href="sip:test@127.0.0.1;tag=2f3b5433">sip:test@127.0.0.1;tag=2f3b5433</a>.<br>
To: <a href="sip:test@127.0.0.1">sip:test@127.0.0.1</a>.<br>
Call-ID: <a href="mailto:792417331@127.0.1.1">792417331@127.0.1.1</a>.<br>
CSeq: 1 REGISTER.<br>
Content-Length: 0.<br>
Max-Forwards: 70.<br>
User-Agent: sipsak 0.9.6.<br>
Expires: 0.<br>
Contact: <a href="sip:test@127.0.1.1:5080">sip:test@127.0.1.1:5080</a>.<br>
.<br>
<br>
<br>
U 2012/01/18 21:53:01.802227 127.0.0.1:5060 -> 127.0.0.1:5060<br>
PUBLISH <a href="sip:test@127.0.0.1">sip:test@127.0.0.1</a> SIP/2.0.<br>
Via: SIP/2.0/UDP 127.0.0.1;branch=z9hG4bK2bad.75340815.0.<br>
To: <a href="sip:test@127.0.0.1">sip:test@127.0.0.1</a>.<br>
From: <a href="sip:test@127.0.0.1;tag=533cb9e91f4b999cf76861cbb9ed54ed-e8e8">sip:test@127.0.0.1;tag=533cb9e91f4b999cf76861cbb9ed54ed-e8e8</a>.<br>
CSeq: 10 PUBLISH.<br>
Call-ID: <a href="mailto:53162b3d3a4cff51-20163@127.0.0.1">53162b3d3a4cff51-20163@127.0.0.1</a>.<br>
Content-Length: 0.<br>
User-Agent: kamailio (3.3.0-dev5 (x86_64/linux)).<br>
Max-Forwards: 70.<br>
Event: presence.<br>
Expires: 0.<br>
SIP-If-Match: a.1326919182.20164.3.0.<br>
.<br>
<br>
<br>
U 2012/01/18 21:53:01.802366 127.0.0.1:5060 -> 127.0.0.1:36942<br>
SIP/2.0 200 OK.<br>
Via: SIP/2.0/UDP 127.0.1.1:5080;branch=z9hG4bK.55f81f68;rport=36942;alias;received=127.0.0.1.<br>
From: <a href="sip:test@127.0.0.1;tag=2f3b5433">sip:test@127.0.0.1;tag=2f3b5433</a>.<br>
To: <a href="sip:test@127.0.0.1;tag=b27e1a1d33761e85846fc98f5f3a7e58.a177">sip:test@127.0.0.1;tag=b27e1a1d33761e85846fc98f5f3a7e58.a177</a>.<br>
Call-ID: <a href="mailto:792417331@127.0.1.1">792417331@127.0.1.1</a>.<br>
CSeq: 1 REGISTER.<br>
Server: kamailio (3.3.0-dev5 (x86_64/linux)).<br>
Content-Length: 0.<br>
.<br>
<br>
<br>
U 2012/01/18 21:53:01.806937 127.0.0.1:5060 -> 127.0.0.1:5060<br>
SIP/2.0 200 OK.<br>
Via: SIP/2.0/UDP 127.0.0.1;branch=z9hG4bK2bad.75340815.0.<br>
To: <a href="sip:test@127.0.0.1;tag=a6a1c5f60faecf035a1ae5b6e96e979a-2698">sip:test@127.0.0.1;tag=a6a1c5f60faecf035a1ae5b6e96e979a-2698</a>.<br>
From: <a href="sip:test@127.0.0.1;tag=533cb9e91f4b999cf76861cbb9ed54ed-e8e8">sip:test@127.0.0.1;tag=533cb9e91f4b999cf76861cbb9ed54ed-e8e8</a>.<br>
CSeq: 10 PUBLISH.<br>
Call-ID: <a href="mailto:53162b3d3a4cff51-20163@127.0.0.1">53162b3d3a4cff51-20163@127.0.0.1</a>.<br>
Expires: 0.<br>
SIP-ETag: a.1326919182.20164.3.0.<br>
Server: kamailio (3.3.0-dev5 (x86_64/linux)).<br>
Content-Length: 0.<br>
.</span></p>
</div>
<p class="MsoNormal" style="text-align:justify"><span style="font-size:11.0pt; font-family:"Arial","sans-serif"">Truphone Limited is a limited liability company registered in England & 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:"Arial","sans-serif"">Tru</span></span><span style="font-size:11.0pt; font-family:"Arial","sans-serif""> 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 href="http://www.truphone.com"><span style="font-size:11.0pt; font-family:"Arial","sans-serif"">www.truphone.com</span></a><span style="font-size:11.0pt; font-family:"Arial","sans-serif"">.</span></p>
<br clear="both">
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>
</body>
</html>