No subject


Wed Dec 21 17:12:16 CET 2011


8(7652) DEBUG: usrloc [ul_callback.h:89]: contact=3D0xb50ae7cc, callback t=
ype 4/4, id 3 entered
8(7652) DEBUG: pua_usrloc [ul_publish.c:216]:DELETE type
8(7652) DEBUG: pua_usrloc [ul_publish.c:255]: uri=3D sip:20701090 at 192.168.=
142.130
8(7652) DEBUG: pua_usrloc [ul_publish.c:66]: publ:
8(7652) DEBUG: pua_usrloc [ul_publish.c:67]: uri=3D sip:20701090 at 192.168.1=
42.130
8(7652) DEBUG: pua_usrloc [ul_publish.c:68]: id=3DUL_PUBLISH.NmY5Zjc2YjcwN=
zEwNTk4YTY1NzA2Y2Y0MWQyMGRhOGY.
8(7652) DEBUG: pua_usrloc [ul_publish.c:69]: expires=3D 0
8(7652) DEBUG: pua [send_publish.c:403]: pres_uri=3Dsip:20701090 at 192.168.1=
42.130
8(7652) DEBUG: pua [hash.c:121]: core_hash=3D 444
8(7652) DEBUG: pua [hash.c:174]: record not found
8(7652) DEBUG: pua [send_publish.c:444]: insert type
8(7652) DEBUG: pua [send_publish.c:448]: UPDATE_TYPE and no record found
8(7652) DEBUG: pua [send_publish.c:454]: request for a publish with expire=
s 0 and no record found
8(7652) DEBUG: sl [sl.c:278]: reply in stateless mode (sl)

As an additional information, the pua table in
/usr/share/kamailio/dbtext/kamailio/pua has not been populated.

The AOR was correctly displayed with 'ul show' while the registration was =
valid.

Any suggestion on what am I be doing wrong?
Would it be worth testing the same scenario using mysql as DB?

Thanks in advance for your time.

Giacomo
Truphone Limited is a limited liability company registered in England & Wa=
les, registered office: 5 New Street Square, London EC4A 3TW. Registered N=
o. 04187081. VAT No. GB 851 5278 19.
Tru 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 op=
erate in combination. www.truphone.com<http://www.truphone.com>.

This e-mail, and any attachment(s), may contain information which is confi=
dential and/or privileged, and is intended for the addressee only. If you =
are not the intended recipient, you may not use, disclose, copy or distrib=
ute this information in any manner whatsoever. If you have received this e=
-mail in error, please contact the sender immediately and delete it.




_______________________________________________

SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list

sr-users at lists.sip-router.org<mailto:sr-users at lists.sip-router.org>

http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users



--

Daniel-Constantin Mierla -- http://www.asipto.com

http://linkedin.com/in/miconda -- http://twitter.com/miconda
Truphone Limited is a limited liability company registered in England & Wa=
les, registered office: 5 New Street Square, London EC4A 3TW. Registered N=
o. 04187081. VAT No. GB 851 5278 19.
Tru 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 op=
erate in combination. www.truphone.com<http://www.truphone.com>.

This e-mail, and any attachment(s), may contain information which is confi=
dential and/or privileged, and is intended for the addressee only. If you =
are not the intended recipient, you may not use, disclose, copy or distrib=
ute this information in any manner whatsoever. If you have received this e=
-mail in error, please contact the sender immediately and delete it.
--_000_A4E41C20520BEC409F1B16BA9FD72D34C82D4Aitixex01_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii=
">
<style>
<!--
@font-face
=09{font-family:"Cambria Math"}
@font-face
=09{font-family:Calibri}
@font-face
=09{font-family:Tahoma}
@font-face
=09{font-family:Consolas}
p.MsoNormal, li.MsoNormal, div.MsoNormal
=09{margin:0cm;
=09margin-bottom:.0001pt;
=09font-size:11.0pt;
=09font-family:"Calibri","sans-serif";
=09color:black}
a:link, span.MsoHyperlink
=09{color:blue;
=09text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
=09{color:purple;
=09text-decoration:underline}
pre
=09{margin:0cm;
=09margin-bottom:.0001pt;
=09font-size:10.0pt;
=09font-family:"Courier New";
=09color:black}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
=09{margin-top:0cm;
=09margin-right:0cm;
=09margin-bottom:0cm;
=09margin-left:36.0pt;
=09margin-bottom:.0001pt;
=09font-size:11.0pt;
=09font-family:"Calibri","sans-serif";
=09color:black}
p.msochpdefault, li.msochpdefault, div.msochpdefault
=09{margin-right:0cm;
=09margin-left:0cm;
=09font-size:12.0pt;
=09font-family:"Calibri","sans-serif";
=09color:black}
span.emailstyle17
=09{font-family:"Calibri","sans-serif";
=09color:windowtext}
span.grame
=09{}
span.spelle
=09{}
span.HTMLPreformattedChar
=09{font-family:Consolas;
=09color:black}
span.EmailStyle23
=09{font-family:"Calibri","sans-serif";
=09color:#1F497D}
.MsoChpDefault
=09{font-size:10.0pt}
@page WordSection1
=09{margin:72.0pt 72.0pt 72.0pt 72.0pt}
div.WordSection1
=09{}
-->
</style>
</head>
<body bgcolor=3D"white" lang=3D"EN-GB" link=3D"blue" vlink=3D"purple">
<div class=3D"WordSection1">
<p class=3D"MsoNormal"><span style=3D"color:#1F497D">Thanks Daniel,</span>=
</p>
<p class=3D"MsoNormal"><span style=3D"color:#1F497D">&nbsp;</span></p>
<p class=3D"MsoNormal"><span style=3D"color:#1F497D">&gt; </span><span sty=
le=3D"font-size:12.0pt; font-family:&quot;Times New Roman&quot;,&quot;seri=
f&quot;">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?</s=
pan></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt; font-family:&quot;=
Times New Roman&quot;,&quot;serif&quot;">&nbsp;</span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt; font-family:&quot;=
Times New Roman&quot;,&quot;serif&quot;">I&#8217;ve switched and now have =
installed 3.2.1, and moved to sqlite too.</span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt; font-family:&quot;=
Times New Roman&quot;,&quot;serif&quot;">I&#8217;ve spent some time to ver=
ify a change in behaviour, but I&#8217;m observing the same.</span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt; font-family:&quot;=
Times New Roman&quot;,&quot;serif&quot;">Registering with a different devi=
ce (e.g. sipp) gives the same result.</span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt; font-family:&quot;=
Times New Roman&quot;,&quot;serif&quot;">&nbsp;</span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt; font-family:&quot;=
Times New Roman&quot;,&quot;serif&quot;">&nbsp;</span></p>
<p class=3D"MsoNormal"><span style=3D"color:#1F497D">&gt; </span><span sty=
le=3D"font-size:12.0pt; font-family:&quot;Times New Roman&quot;,&quot;seri=
f&quot;">db_text is not really suitable for dealing with large data and wr=
ite 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=3D"MsoNormal"><span style=3D"font-size:12.0pt; font-family:&quot;=
Times New Roman&quot;,&quot;serif&quot;">&nbsp;</span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt; font-family:&quot;=
Times New Roman&quot;,&quot;serif&quot;">My current goal is a proof of con=
cept so I&#8217;m not concerned about performances &#8211; am I right in t=
hinking that the problem in finding the presentity in pua&#8217;s hash tab=
le
 is independent from the DB usage, or may it have an impact?</span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt; font-family:&quot;=
Times New Roman&quot;,&quot;serif&quot;">&nbsp;</span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt; font-family:&quot;=
Times New Roman&quot;,&quot;serif&quot;">Cheers,</span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt; font-family:&quot;=
Times New Roman&quot;,&quot;serif&quot;">Giacomo</span><span style=3D"colo=
r:#1F497D"></span></p>
<p class=3D"MsoNormal"><span style=3D"color:#1F497D">&nbsp;</span></p>
<p class=3D"MsoNormal"><span style=3D"color:#1F497D">&nbsp;</span></p>
<div>
<div style=3D"border:none; border-top:solid #B5C4DF 1.0pt; padding:3.0pt 0=
cm 0cm 0cm">
<p class=3D"MsoNormal"><b><span lang=3D"EN-US" style=3D"font-size:10.0pt; =
font-family:&quot;Tahoma&quot;,&quot;sans-serif&quot;; color:windowtext">F=
rom:</span></b><span lang=3D"EN-US" style=3D"font-size:10.0pt; font-family=
:&quot;Tahoma&quot;,&quot;sans-serif&quot;; color:windowtext"> Daniel-Cons=
tantin Mierla
 [mailto:miconda at gmail.com] <br>
<b>Sent:</b> 18 January 2012 10:25<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 i=
s deleted or expires</span></p>
</div>
</div>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">Hello,<br>
<br>
On 1/18/12 10:53 AM, Giacomo Vacca wrote: </p>
<div>
<p class=3D"MsoNormal">Hi all,</p>
<p class=3D"MsoNormal">I've made a clean installation of kamailio 3.2.0 fr=
om &#8216;<a href=3D"http://deb.kamailio.org/kamailio32">http://deb.kamail=
io.org/kamailio32</a> squeeze main&#8217;</p>
<p class=3D"MsoNormal">repository, on a squeeze debian machine (2.6.32-5-6=
86).</p>
</div>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt; font-family:&quot;=
Times New Roman&quot;,&quot;serif&quot;">can you switch to nightly builds =
from branch 3.2 just to be sure it is not related to something that was fi=
xed since 3.2.0 was released? The repo are listed at:<br>
<br>
<a href=3D"http://www.kamailio.org/wiki/packages/debs#kamailio_32_-_nightl=
y_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 di=
sk when the sip server is shut down, maybe it is better to use db_sqlite f=
or this case,=20at least you can check the content of the db table with sq=
lite tools.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<br>
<br>
</span></p>
<div>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">Installed also kamailio-presence-modules, same vers=
ion.</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">I'm just using the default kamailio.cfg that comes =
with the package, with these minimal additions:</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">loadmodule &quot;db_text.so&quot;</p>
<p class=3D"MsoNormal">loadmodule &quot;pua.so&quot;</p>
<p class=3D"MsoNormal">loadmodule &quot;pua_usrloc.so&quot;</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">...</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">modparam(&quot;pua&quot;, &quot;db_url&quot;, &quot=
;text:///usr/share/kamailio/dbtext/kamailio&quot;)</p>
<p class=3D"MsoNormal">modparam(&quot;pua_usrloc&quot;, &quot;default_doma=
in&quot;, &quot;192.168.142.130&quot;)</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">Inside the registration management logic I've added=
 pua_set_publish() right before saving the location:</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">route[REGISTRAR] {</p>
<p class=3D"MsoNormal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (is_m=
ethod(&quot;REGISTER&quot;))</p>
<p class=3D"MsoNormal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {</p>
<p class=3D"MsoNormal">...</p>
<p class=3D"MsoNormal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pua_set_publish();</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (!save(&quot;location&quot;))</=
p>
<p class=3D"MsoNormal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp; sl_reply_error();</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; exit;</p>
<p class=3D"MsoNormal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }</p>
<p class=3D"MsoNormal">}</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">When I first register (XLite 4.1 for Windows), pua_=
usrloc correctly gets the callback and is able to generate a PUBLISH reque=
st through pua.</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">But when there's an un-registration, or when the co=
ntact expires, even if the callbacks are correctly fired, the PUBLISH (whi=
ch I'd expect with status 'closed') is not generated.</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">From the logs (debug level 4), an un-registration:<=
/p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">8(7652) DEBUG: usrloc [ul_callback.h:89]: contact=3D=
0xb50ae7cc, callback type 4/4, id 3 entered</p>
<p class=3D"MsoNormal">8(7652) DEBUG: pua_usrloc [ul_publish.c:216]:DELETE=
 type</p>
<p class=3D"MsoNormal">8(7652) DEBUG: pua_usrloc [ul_publish.c:255]: uri=3D=
 <a href=3D"sip:20701090 at 192.168.142.130">
sip:20701090 at 192.168.142.130</a></p>
<p class=3D"MsoNormal">8(7652) DEBUG: pua_usrloc [ul_publish.c:66]: publ:<=
/p>
<p class=3D"MsoNormal">8(7652) DEBUG: pua_usrloc [ul_publish.c:67]: uri=3D=
 <a href=3D"sip:20701090 at 192.168.142.130">
sip:20701090 at 192.168.142.130</a></p>
<p class=3D"MsoNormal">8(7652) DEBUG: pua_usrloc [ul_publish.c:68]: id=3DU=
L_PUBLISH.NmY5Zjc2YjcwNzEwNTk4YTY1NzA2Y2Y0MWQyMGRhOGY.</p>
<p class=3D"MsoNormal">8(7652) DEBUG: pua_usrloc [ul_publish.c:69]: expire=
s=3D 0</p>
<p class=3D"MsoNormal">8(7652) DEBUG: pua [send_publish.c:403]: pres_uri=3D=
<a href=3D"sip:20701090 at 192.168.142.130">sip:20701090 at 192.168.142.130</a><=
/p>
<p class=3D"MsoNormal">8(7652) DEBUG: pua [hash.c:121]: core_hash=3D 444</=
p>
<p class=3D"MsoNormal">8(7652) DEBUG: pua [hash.c:174]: record not found</=
p>
<p class=3D"MsoNormal">8(7652) DEBUG: pua [send_publish.c:444]: insert typ=
e</p>
<p class=3D"MsoNormal">8(7652) DEBUG: pua [send_publish.c:448]: UPDATE_TYP=
E and no record found</p>
<p class=3D"MsoNormal">8(7652) DEBUG: pua [send_publish.c:454]: request fo=
r a publish with expires 0 and no record found</p>
<p=20class=3D"MsoNormal">8(7652) DEBUG: sl [sl.c:278]: reply in stateless =
mode (sl)</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">As an additional information, the pua table in</p>
<p class=3D"MsoNormal">/usr/share/kamailio/dbtext/kamailio/pua has not bee=
n populated.</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">The AOR was correctly displayed with &#8216;ul show=
&#8217; while the registration was valid.</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">Any suggestion on what am I be doing wrong?</p>
<p class=3D"MsoNormal">Would it be worth testing the same scenario using m=
ysql as DB?</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">Thanks in advance for your time.</p>
<p class=3D"MsoNormal">&nbsp;</p>
<p class=3D"MsoNormal">Giacomo</p>
</div>
<p class=3D"MsoNormal" style=3D"text-align:justify"><span style=3D"font-fa=
mily:&quot;Arial&quot;,&quot;sans-serif&quot;">Truphone Limited is a limit=
ed liability company registered in England &amp; Wales, registered office:=
 5 New Street Square, London EC4A 3TW.
<span class=3D"grame">Registered No. 04187081.</span> VAT No. <span class=3D=
"grame">GB 851 5278 19.</span>
</span></p>
<p class=3D"MsoNormal" style=3D"text-align:justify"><span class=3D"spelle"=
><span style=3D"font-family:&quot;Arial&quot;,&quot;sans-serif&quot;">Tru<=
/span></span><span style=3D"font-family:&quot;Arial&quot;,&quot;sans-serif=
&quot;"> is a brand name of Truphone and is a Truphone Communications Serv=
ice. Truphone
 is a trading name for a number of distinct legal entities that operate in=
 combination.
</span><a href=3D"http://www.truphone.com"><span style=3D"font-family:&quo=
t;Arial&quot;,&quot;sans-serif&quot;">www.truphone.com</span></a><span sty=
le=3D"font-family:&quot;Arial&quot;,&quot;sans-serif&quot;">.</span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt; font-family:&quot;=
Times New Roman&quot;,&quot;serif&quot;"><br clear=3D"all">
This e-mail, and any attachment(s), may contain information which is confi=
dential and/or privileged, and is intended for the addressee only. If you =
are not the intended recipient, you may not use, disclose, copy or distrib=
ute 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>
<br>
<br>
</span></p>
<pre>_______________________________________________</pre>
<pre>SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing li=
st</pre>
<pre><a href=3D"mailto:sr-users at lists.sip-router.org">sr-users at lists.sip-r=
outer.org</a></pre>
<pre><a href=3D"http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-us=
ers">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a></pr=
e>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt; font-family:&quot;=
Times New Roman&quot;,&quot;serif&quot;"><br>
<br>
</span></p>
<pre>-- </pre>
<pre>Daniel-Constantin Mierla -- <a href=3D"http://www.asipto.com">http://=
www.asipto.com</a></pre>
<pre><a href=3D"http://linkedin.com/in/miconda">http://linkedin.com/in/mic=
onda</a> -- <a href=3D"http://twitter.com/miconda">http://twitter.com/mico=
nda</a></pre>
</div>
<p=20class=3D"MsoNormal" style=3D"text-align:justify"><span style=3D"font-=
size:11.0pt; font-family:&quot;Arial&quot;,&quot;sans-serif&quot;">Truphon=
e Limited is a limited liability company registered in England &amp; Wales=
, registered office: 5 New Street Square, London EC4A 3TW.
<span class=3D"GramE">Registered No. 04187081.</span> VAT No. <span class=3D=
"GramE">GB 851 5278 19.</span>
</span></p>
<p class=3D"MsoNormal" style=3D"text-align:justify"><span class=3D"SpellE"=
><span style=3D"font-size:11.0pt; font-family:&quot;Arial&quot;,&quot;sans=
-serif&quot;">Tru</span></span><span style=3D"font-size:11.0pt; font-famil=
y:&quot;Arial&quot;,&quot;sans-serif&quot;"> is a brand name of Truphone a=
nd is a Truphone
 Communications Service. Truphone is a trading name for a number of distin=
ct legal entities that operate in combination.
</span><a href=3D"http://www.truphone.com"><span style=3D"font-size:11.0pt=
; font-family:&quot;Arial&quot;,&quot;sans-serif&quot;">www.truphone.com</=
span></a><span style=3D"font-size:11.0pt; font-family:&quot;Arial&quot;,&q=
uot;sans-serif&quot;">.</span></p>
<br clear=3D"both">
This e-mail, and any attachment(s), may contain information which is confi=
dential and/or privileged, and is intended for the addressee only. If you =
are not the intended recipient, you may not use, disclose, copy or distrib=
ute 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>

--_000_A4E41C20520BEC409F1B16BA9FD72D34C82D4Aitixex01_--



More information about the sr-users mailing list