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@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@192.168.219.109. CSeq: 53944 SUBSCRIBE. Expires: 1800. Contact: sip:PRESENCEIP:5060. Server: kamailio (3.1.5 (x86_64/linux)). Content-Length: 0.