[SR-Users] Presence question

[Anca Vamanu]

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 at 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 at 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 at domain.tld.
> From: "103 Zone T"<sip:test103 at domain.tld>;tag=db911ce615f1598c.
> Call-ID: 3f55db6e-b2ec6ca4 at 192.168.219.109.
> CSeq: 53944 SUBSCRIBE.
> Max-Forwards: 68.
> Contact: "103 Zone T"<sip:test103 at 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 at domain.tld;tag=f0253efb8005057b3cc0ab8fa35ff1d9-8c10.
> From: "103 Zone T"<sip:test103 at domain.tld>;tag=db911ce615f1598c.
> Call-ID: 3f55db6e-b2ec6ca4 at 192.168.219.109.
> CSeq: 53944 SUBSCRIBE.
> Expires: 1800.
> Contact:<sip:PRESENCEIP:5060>.
> Server: kamailio (3.1.5 (x86_64/linux)).
> Content-Length: 0.
>