Below is the relevant presence/pua stuff. Let me know if I should be examining other tables.
When the call ends, there are no dialogs remaining in the dialog table. A few things do hang around in the presentity and pua tables for a short period of time.
Regarding CLI changing, it does seem to do so. When the call is routed onto the billing platform, the CLI is changed to the local “extension” (e.g. 9989) on the leg that comes back to Kamailio, destined for the
callee.
Regarding only advertising the leg going to the callee, not all calls will terminate on a UA registered against Kamailio (e.g. calls from a Kamailio registered UA to the PSTN). The more I think about it, determining
the correct leg in all scenarios will be difficult.
mysql> SELECT * FROM presentity\G
*************************** 1. row ***************************
id: 1
username: 441164969989
domain: 185.28.212.118
event: dialog
etag: a.1453224139.18802.144.0
expires: 1453226868
received_time: 1453226743
body: <?xml version="1.0"?>
<dialog-info xmlns="urn:ietf:params:xml:ns:dialog-info" version="0" state="full" entity="sip:441164969989@185.28.212.118">
<dialog id="b2d95153-ea311679-84b889bb@172.31.17.81" call-id="b2d95153-ea311679-84b889bb@172.31.17.81" direction="initiator">
<state>Trying</state>
<remote>
<identity>sip:9988@185.28.212.118;user=phone</identity>
<target uri="sip:9988@185.28.212.118;user=phone"/>
</remote>
<local>
<identity>sip:441164969989@185.28.212.118</identity>
<target uri="sip:441164969989@185.28.212.118"/>
</local>
</dialog>
</dialog-info>
sender:
priority: 0
*************************** 2. row ***************************
id: 2
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453224139.18803.173.0
expires: 1453226869
received_time: 1453226744
body: <?xml version="1.0"?>
<dialog-info xmlns="urn:ietf:params:xml:ns:dialog-info" version="0" state="full" entity="sip:441164969988@185.28.212.118">
<dialog id="b2d95153-ea311679-84b889bb@172.31.17.81~2o" call-id="b2d95153-ea311679-84b889bb@172.31.17.81~2o" local-tag="8D404FC4-3EB13CE3" remote-tag="sl4pzhsqvrpk4wqa.o" direction="recipient">
<state>early</state>
<remote>
<identity>sip:9989@91.228.242.21</identity>
<target uri="sip:91.228.242.21:5061"/>
</remote>
<local>
<identity>sip:441164969988@185.28.212.118</identity>
<target uri="sip:441164969988@185.28.212.246:51415"/>
</local>
</dialog>
</dialog-info>
sender:
priority: 0
*************************** 3. row ***************************
id: 3
username: 441164969989
domain: 185.28.212.118
event: dialog
etag: a.1453224139.18816.93.0
expires: 1453226869
received_time: 1453226744
body: <?xml version="1.0"?>
<dialog-info xmlns="urn:ietf:params:xml:ns:dialog-info" version="0" state="full" entity="sip:441164969989@185.28.212.118">
<dialog id="b2d95153-ea311679-84b889bb@172.31.17.81" call-id="b2d95153-ea311679-84b889bb@172.31.17.81" local-tag="72DEDDC3-BABA2049" remote-tag="hu7u5gyrvjx5ebvc.i" direction="initiator">
<state>early</state>
<remote>
<identity>sip:9988@185.28.212.118;user=phone</identity>
<target uri="sip:91.228.242.21:5061"/>
</remote>
<local>
<identity>sip:441164969989@185.28.212.118</identity>
<target uri="sip:441164969989@185.28.212.246:7816"/>
</local>
</dialog>
</dialog-info>
sender:
priority: 0
*************************** 4. row ***************************
id: 4
username: 9988
domain: 185.28.212.118
event: dialog
etag: a.1453224139.18804.132.0
expires: 1453226869
received_time: 1453226744
body: <?xml version="1.0"?>
<dialog-info xmlns="urn:ietf:params:xml:ns:dialog-info" version="0" state="full" entity="sip:9988@185.28.212.118;user=phone">
<dialog id="b2d95153-ea311679-84b889bb@172.31.17.81" call-id="b2d95153-ea311679-84b889bb@172.31.17.81" local-tag="hu7u5gyrvjx5ebvc.i" remote-tag="72DEDDC3-BABA2049" direction="recipient">
<state>early</state>
<remote>
<identity>sip:441164969989@185.28.212.118</identity>
<target uri="sip:441164969989@185.28.212.246:7816"/>
</remote>
<local>
<identity>sip:9988@185.28.212.118;user=phone</identity>
<target uri="sip:91.228.242.21:5061"/>
</local>
</dialog>
</dialog-info>
sender:
priority: 0
*************************** 5. row ***************************
id: 5
username: 441164969988
domain: 185.28.212.118
event: dialog
etag: a.1453224139.18802.145.0
expires: 1453226881
received_time: 1453226756
body: <?xml version="1.0"?>
<dialog-info xmlns="urn:ietf:params:xml:ns:dialog-info" version="0" state="full" entity="sip:441164969988@185.28.212.118">
<dialog id="b2d95153-ea311679-84b889bb@172.31.17.81~2o" call-id="b2d95153-ea311679-84b889bb@172.31.17.81~2o" direction="recipient">
<state>confirmed</state>
<remote>
<identity>sip:9989@91.228.242.21</identity>
<target uri="sip:91.228.242.21:5061"/>
</remote>
<local>
<identity>sip:441164969988@185.28.212.118</identity>
<target uri="sip:441164969988@185.28.212.118"/>
</local>
</dialog>
</dialog-info>
sender:
priority: 0
*************************** 6. row ***************************
id: 6
username: 441164969989
domain: 185.28.212.118
event: dialog
etag: a.1453224139.18803.174.0
expires: 1453226881
received_time: 1453226756
body: <?xml version="1.0"?>
<dialog-info xmlns="urn:ietf:params:xml:ns:dialog-info" version="0" state="full" entity="sip:441164969989@185.28.212.118">
<dialog id="b2d95153-ea311679-84b889bb@172.31.17.81" call-id="b2d95153-ea311679-84b889bb@172.31.17.81" direction="initiator">
<state>confirmed</state>
<remote>
<identity>sip:9988@185.28.212.118;user=phone</identity>
<target uri="sip:9988@185.28.212.118;user=phone"/>
</remote>
<local>
<identity>sip:441164969989@185.28.212.118</identity>
<target uri="sip:441164969989@185.28.212.246:7816"/>
</local>
</dialog>
</dialog-info>
sender:
priority: 0
*************************** 7. row ***************************
id: 7
username: 9988
domain: 185.28.212.118
event: dialog
etag: a.1453224139.18800.126.0
expires: 1453226881
received_time: 1453226756
body: <?xml version="1.0"?>
<dialog-info xmlns="urn:ietf:params:xml:ns:dialog-info" version="0" state="full" entity="sip:9988@185.28.212.118;user=phone">
<dialog id="b2d95153-ea311679-84b889bb@172.31.17.81" call-id="b2d95153-ea311679-84b889bb@172.31.17.81" direction="recipient">
<state>confirmed</state>
<remote>
<identity>sip:441164969989@185.28.212.118</identity>
<target uri="sip:441164969989@185.28.212.246:7816"/>
</remote>
<local>
<identity>sip:9988@185.28.212.118;user=phone</identity>
<target uri="sip:9988@185.28.212.118;user=phone"/>
</local>
</dialog>
</dialog-info>
sender:
priority: 0
7 rows in set (0.00 sec)
mysql> SELECT * FROM pua\G
*************************** 1. row ***************************
id: 1
pres_uri: sip:441164969989@185.28.212.118
pres_id: DIALOG_PUBLISH.b2d95153-ea311679-84b889bb@172.31.17.81
event: 32
expires: 1453226868
desired_expires: 1453226867
flag: 1024
etag: a.1453224139.18802.144.0
tuple_id:
watcher_uri:
call_id:
to_tag:
from_tag:
cseq: 0
record_route:
contact:
remote_contact:
version: 0
extra_headers:
*************************** 2. row ***************************
id: 3
pres_uri: sip:441164969989@185.28.212.118
pres_id: DIALOG_PUBLISH.b2d95153-ea311679-84b889bb@172.31.17.81
event: 32
expires: 1453226869
desired_expires: 1453226868
flag: 1024
etag: a.1453224139.18816.93.0
tuple_id:
watcher_uri:
call_id:
to_tag:
from_tag:
cseq: 0
record_route:
contact:
remote_contact:
version: 0
extra_headers:
*************************** 3. row ***************************
id: 4
pres_uri: sip:9988@185.28.212.118;user=phone
pres_id: DIALOG_PUBLISH.b2d95153-ea311679-84b889bb@172.31.17.81
event: 32
expires: 1453226869
desired_expires: 1453226868
flag: 1024
etag: a.1453224139.18804.132.0
tuple_id:
watcher_uri:
call_id:
to_tag:
from_tag:
cseq: 0
record_route:
contact:
remote_contact:
version: 0
extra_headers:
*************************** 4. row ***************************
id: 6
pres_uri: sip:441164969989@185.28.212.118
pres_id: DIALOG_PUBLISH.b2d95153-ea311679-84b889bb@172.31.17.81
event: 32
expires: 1453226881
desired_expires: 1453226880
flag: 1024
etag: a.1453224139.18803.174.0
tuple_id:
watcher_uri:
call_id:
to_tag:
from_tag:
cseq: 0
record_route:
contact:
remote_contact:
version: 0
extra_headers:
*************************** 5. row ***************************
id: 7
pres_uri: sip:9988@185.28.212.118;user=phone
pres_id: DIALOG_PUBLISH.b2d95153-ea311679-84b889bb@172.31.17.81
event: 32
expires: 1453226881
desired_expires: 1453226880
flag: 1024
etag: a.1453224139.18800.126.0
tuple_id:
watcher_uri:
call_id:
to_tag:
from_tag:
cseq: 0
record_route:
contact:
remote_contact:
version: 0
extra_headers:
5 rows in set (0.00 sec)
Phil Lavin
Telecoms Systems Manager
CloudCall by SYNETY
www.cloudcall.com
T: +44 (0) 330 335 0000 / +1 617 982 1600
D: +44 (0) 116 424 4790 / +1 617 982 4790
SM:
LinkedIn
READ
OUR BLOG FOR SMARTER COMMUNICATIONS
Confidentiality: This e-mail transmission, including any attachments, is intended only for the named recipient(s) and may contain information that is privileged, confidential and/or exempt from
disclosure under applicable law. If you have received this transmission in error, or are not the named recipient(s), please notify the sender immediately by return e-mail and permanently delete this transmission, including any attachments.
Security: This e-mail and any attachments are believed to be free from any virus but it is the responsibility of the recipient to ensure this is so. E-mail is not a 100% secure communication.
From: Daniel-Constantin Mierla [mailto:miconda@gmail.com]
Sent: 19 January 2016 17:49
To: Phil Lavin <phil.lavin@synety.com>; Kamailio (SER) - Users Mailing List <sr-users@lists.sip-router.org>
Subject: Re: [SR-Users] Strange PUA Behaviour
Hello,
is any of these two dialogs staying not terminated when the call is ended?
I would only advertise the dialog info states for the call leg going to callee, because it is the one for call pickup.
On the other hand for shared line appearance, the caller is watched as well. Is the caller id changed in the middle?
Cheers,
Daniel
On 19/01/16 11:25, Phil Lavin wrote:
Hi Daniel,
The multiple records are because we are routing calls between UAs which are both registered against Kamailio via an external SIP server (our billing engine). That is causing there to be 2 dialogs created.
We have put in a quick hack to not call dlg_manage() when the $fU is “9989”. This does not create 2 records in the dialogs table and the BLF functionality works as expected.
What do you propose as the correct fix for this situation?
Thanks
Phil
From: Phil Lavin
Sent: 19 January 2016 09:42
To: 'miconda@gmail.com' <miconda@gmail.com>; Kamailio (SER) - Users Mailing List <sr-users@lists.sip-router.org>
Subject: RE: [SR-Users] Strange PUA Behaviour
Hi Daniel,
Thanks for your response. There are 2 records in the database. They are below:
--
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Book: SIP Routing With Kamailio - http://www.asipto.com
http://miconda.eu