[cisco-voip] CUCM Shared Line Appearance (SIP phones)

[Barnett, Nick]

To add to this, the PKID is generated using newid(), a function defined in the Informix database.

At one point, I started digging around to see if I could actually locate the formula used within that function, but I wasn't able to get very far. I was able to find a reference to sqlfunctions within the sysprocedures table. I don't even know if it is related. According to the Informix documentation I have read, the sysprocedures table stores all procedures, but I'm under the impression this is a function, but it may just be a vocabulary issue on my part. If anyone knows where the actual getid() is stored, I'd be interested in looking at it.

run sql select * from sysprocedures where procname = "sqlfunctions"

Thanks,
Nick

Disclaimer: IANADBA

From: cisco-voip [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Daniel Pagan
Sent: Monday, September 14, 2015 10:07 AM
To: Daniel Pagan; Mark Holloway; voip puck
Subject: Re: [cisco-voip] CUCM Shared Line Appearance (SIP phones)

Adding to this... This is also the URI contained in the Contact header for SIP requests transmitted *from* the IP phone, allowing CUCM to send future requests to the phone within the same dialog using the PKID URI you're seeing. The PKID for the DN is obtained by the phone via TFTP configuration file:

<contact>ae97ba4b-2397-4b52-5ddc-07589fb380ab</contact>

Hope this helps.

- Dan

From: cisco-voip [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Daniel Pagan
Sent: Monday, September 14, 2015 10:44 AM
To: Mark Holloway <mh at markholloway.com<mailto:mh at markholloway.com>>; voip puck <cisco-voip at puck.nether.net<mailto:cisco-voip at puck.nether.net>>
Subject: Re: [cisco-voip] CUCM Shared Line Appearance (SIP phones)

The request-URI in this case is the PKID of the DN followed by the IP address of the phone. Check it out:

https://10.10.13.100/ccmadmin/directoryNumberEdit.do?key=ae97ba4b-2397-4b52-5ddc-07589fb380ab<https://urldefense.proofpoint.com/v2/url?u=https-3A__10.10.13.100_ccmadmin_directoryNumberEdit.do-3Fkey-3Dae97ba4b-2D2397-2D4b52-2D5ddc-2D07589fb380ab&d=BQMF-g&c=M-KQspD_LQogCbR-BWCHOaeDEPOhF8vWqHZTaiwxT3c&r=T9uVLZucbHG2NKKKzOrp-o5cpdReHj02PkJJsCVkgfwcv7S0R5lDeFJg2VRbiNih&m=OxWTXBha_SMEwQWX1utNzxe75Aieb7dfByp4DL_a3RI&s=6hMkdEgry-T3tGS32w810c-uNgWFx_BR9AnxzzHmNsM&e=>

^^^URL of a test DN.
Key= ae97ba4b-2397-4b52-5ddc-07589fb380ab

INVITE sip:ae97ba4b-2397-4b52-5ddc-07589fb380ab at 10.10.31.6:50926;transport=tcp SIP/2.0

^^^ Check out the request URI above.

Hope this helps.

- Dan

From: cisco-voip [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Mark Holloway
Sent: Saturday, September 12, 2015 8:39 AM
To: voip puck <cisco-voip at puck.nether.net<mailto:cisco-voip at puck.nether.net>>
Subject: [cisco-voip] CUCM Shared Line Appearance (SIP phones)

Hi all. When CUCM sends a SIP Invite to shared lines on SIP phones the user portion contains some sort of (what appears to b) a randomly calculated alpha-numeric string. Is there any information or documentation available on how Cisco actually calculates what this string will be?

Here is an example of a SIP Invite going to two SIP phones sharing the same phone number

INVITE sip:8cc951b7-86b6-0c74-1e4d-c0108c268dc2 at 10.232.50.81:49422;transport=tcp SIP/2.0
INVITE sip:8cc951b7-86b6-0c74-1e4d-c0108c268dc2 at 10.232.50.91:51945;transport=tcp SIP/2.0


Thanks,
Mark

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20150914/e844d7f0/attachment.html>