<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 12:50 PM, Giacomo Vacca wrote:
<blockquote
cite="mid:A4E41C20520BEC409F1B16BA9FD72D34C82D4A@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}
@font-face
{font-family:Tahoma}
@font-face
{font-family:Consolas}
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}
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.grame
{}
span.spelle
{}
span.HTMLPreformattedChar
{font-family:Consolas;
color:black}
span.EmailStyle23
{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>
<div class="WordSection1">
<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"">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>
</blockquote>
<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 style="font-size:12.0pt; font-family:"Times New
Roman","serif""><br>
</span>
<blockquote
cite="mid:A4E41C20520BEC409F1B16BA9FD72D34C82D4A@itixex01"
type="cite">
<div class="WordSection1">
<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"">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>
</blockquote>
<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 class="moz-txt-link-freetext" 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 class="moz-txt-link-freetext" href="sip:test@127.0.0.1;tag=41f6277b">sip:test@127.0.0.1;tag=41f6277b</a>.<br>
To: <a class="moz-txt-link-freetext" href="sip:test@127.0.0.1">sip:test@127.0.0.1</a>.<br>
Call-ID: <a class="moz-txt-link-abbreviated" 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 class="moz-txt-link-freetext" 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 class="moz-txt-link-freetext" 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 class="moz-txt-link-freetext" href="sip:test@127.0.0.1">sip:test@127.0.0.1</a>.<br>
From: <a class="moz-txt-link-freetext" 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 class="moz-txt-link-abbreviated" 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 class="moz-txt-link-rfc2396E" 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 class="moz-txt-link-freetext" href="sip:test@127.0.0.1;tag=41f6277b">sip:test@127.0.0.1;tag=41f6277b</a>.<br>
To: <a class="moz-txt-link-freetext" href="sip:test@127.0.0.1;tag=b27e1a1d33761e85846fc98f5f3a7e58.12b3">sip:test@127.0.0.1;tag=b27e1a1d33761e85846fc98f5f3a7e58.12b3</a>.<br>
Call-ID: <a class="moz-txt-link-abbreviated" href="mailto:1106651003@127.0.1.1">1106651003@127.0.1.1</a>.<br>
CSeq: 1 REGISTER.<br>
Contact: <a class="moz-txt-link-rfc2396E" 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 class="moz-txt-link-freetext" href="sip:test@127.0.0.1;tag=a6a1c5f60faecf035a1ae5b6e96e979a-0f93">sip:test@127.0.0.1;tag=a6a1c5f60faecf035a1ae5b6e96e979a-0f93</a>.<br>
From: <a class="moz-txt-link-freetext" 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 class="moz-txt-link-abbreviated" 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 class="moz-txt-link-freetext" 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 class="moz-txt-link-freetext" href="sip:test@127.0.0.1;tag=2f3b5433">sip:test@127.0.0.1;tag=2f3b5433</a>.<br>
To: <a class="moz-txt-link-freetext" href="sip:test@127.0.0.1">sip:test@127.0.0.1</a>.<br>
Call-ID: <a class="moz-txt-link-abbreviated" 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 class="moz-txt-link-freetext" 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 class="moz-txt-link-freetext" 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 class="moz-txt-link-freetext" href="sip:test@127.0.0.1">sip:test@127.0.0.1</a>.<br>
From: <a class="moz-txt-link-freetext" 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 class="moz-txt-link-abbreviated" 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 class="moz-txt-link-freetext" href="sip:test@127.0.0.1;tag=2f3b5433">sip:test@127.0.0.1;tag=2f3b5433</a>.<br>
To: <a class="moz-txt-link-freetext" href="sip:test@127.0.0.1;tag=b27e1a1d33761e85846fc98f5f3a7e58.a177">sip:test@127.0.0.1;tag=b27e1a1d33761e85846fc98f5f3a7e58.a177</a>.<br>
Call-ID: <a class="moz-txt-link-abbreviated" 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 class="moz-txt-link-freetext" href="sip:test@127.0.0.1;tag=a6a1c5f60faecf035a1ae5b6e96e979a-2698">sip:test@127.0.0.1;tag=a6a1c5f60faecf035a1ae5b6e96e979a-2698</a>.<br>
From: <a class="moz-txt-link-freetext" 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 class="moz-txt-link-abbreviated" 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>
.<br>
<br>
</body>
</html>