19 Mar
2012
19 Mar
'12
6:48 p.m.
Hi David,
This query comes from code and is executed when a Notify receives an
error reply.
Check which is the reply received by the Notify that is sent imediately
after the 200OK for Subscribe.
Regards,
Anca
On 03/19/2012 06:30 PM, David wrote:
Hello,
I am running a presence server. I am searching for a problem with my
presence, and I have traced it down to this query :
delete from active_watchers where
presentity_uri='sip:test109@domain.tld' AND event='dialog' AND
to_tag='f0253efb8005057b3cc0ab8fa35ff1d9-c961'
This query is being sent to the database a few seconds after the initial
subscribe is received. So the subscription only lasts in the database
for a few seconds.
I tried running level 3 error reporting ( hundreds of DEBUG ). I did not
see any justification for query.
Where is this query coming from ( source code/ config file )? Why is
this subscription being deleted almost immediatly after it is setup ?
Thanks,
David
Here is a sample request ( not the same as the one above, I did not
capture the SIP at the same time as the SQL ) :
U PROXYIP:5060 -> PRESENCEIP:5060
SUBSCRIBE sip:test109@domain.tld SIP/2.0.
Record-Route:<sip:PROXYIP;lr=on;ftag=db911ce615f1598c>.
Record-Route:<sip:TCPPROXYIP;r2=on;lr=on>.
Record-Route:<sip:TCPPROXYIP;transport=tcp;r2=on;lr=on>.
Via: SIP/2.0/UDP PROXYIP;branch=z9hG4bK9543.f0668033.0.
Via: SIP/2.0/UDP TCPPROXYIP;branch=z9hG4bK9543.d2e18073.0;i=0a3.
Via: SIP/2.0/TCP USERIP:61334;branch=z9hG4bK-6ee64c28;rport=61334.
To: sip:test109@domain.tld.
From: "103 Zone T"<sip:test103@domain.tld>;tag=db911ce615f1598c.
Call-ID: 3f55db6e-b2ec6ca4(a)192.168.219.109.
CSeq: 53944 SUBSCRIBE.
Max-Forwards: 68.
Contact: "103 Zone T"<sip:test103@USERIP:8280;transport=tcp>.
Accept: application/dialog-info+xml.
Expires: 1800.
Event: dialog.
User-Agent: Cisco/SPA504G-7.4.9c.
Content-Length: 0.
.
#
U PRESENCEIP:5060 -> PROXYIP:5060
SIP/2.0 202 OK.
Record-Route:<sip:PROXYIP;lr=on;ftag=db911ce615f1598c>.
Record-Route:<sip:TCPPROXYIP;r2=on;lr=on>.
Record-Route:<sip:TCPPROXYIP;transport=tcp;r2=on;lr=on>.
Via: SIP/2.0/UDP PROXYIP;branch=z9hG4bK9543.f0668033.0.
Via: SIP/2.0/UDP TCPPROXYIP;branch=z9hG4bK9543.d2e18073.0;i=0a3.
Via: SIP/2.0/TCP USERIP:61334;branch=z9hG4bK-6ee64c28;rport=61334.
To: sip:test109@domain.tld;tag=f0253efb8005057b3cc0ab8fa35ff1d9-8c10.
From: "103 Zone T"<sip:test103@domain.tld>;tag=db911ce615f1598c.
Call-ID: 3f55db6e-b2ec6ca4(a)192.168.219.109.
CSeq: 53944 SUBSCRIBE.
Expires: 1800.
Contact:<sip:PRESENCEIP:5060>.
Server: kamailio (3.1.5 (x86_64/linux)).
Content-Length: 0.