[cisco-voip] risdb query
Wes Sisk
wsisk at cisco.com
Fri Mar 2 11:45:29 EST 2012
I believe there is some misunderstanding here. 'show risdb query' queries the shared memory segment on the local server. that shared memory is maintained by the local ccm process. That shared memory contains the registration status of the phones relative to the local node.
If a phone is registered to node1 it should appear in show risdb on node1 as registered. If the phone failed over to node2 and then failed back to node1 then show risdb on node2 would show the phone as unregistered. If ccm is restarted on node2 then the shared memory on node2 is cleared and node2 ris forgets the phone has ever registered there.
This is simply status for ris and the shared memory segment. Internal to the ccm process there is a "process" called DeviceManager that maintains device registration status across the entire cluster. DeviceManager on node2 knows the phone is registered to node1 so calls that originate on node2 can route to the phone.
The shared memory segment accessed with 'show risdb' only matches device manager status for locally registered phones. it does not include remote registrations. The only way the counts and constituent phones on each node would match is if all phones had registered to both nodes since the last time the ccm process was restarted on both nodes. This is likely to happen in a mass failover due to loss of network connectivity to a primary cucm server.
An example might help. Here I login to each node in the cluster and check output. In the below sample you can see the phone SEP001121FF9474 is currently registered to 10.18.172.204 but it has registered, and subsequently unregistered, with 10.18.172.205 since the last time the ccm process was restarted on the node 10.18.172.205.
mymac:uc wsisk$ ssh administrator at 10.18.172.204
administrator at 10.18.172.204's password:
Command Line Interface is starting up, please wait ...
Welcome to the Platform Command Line Interface
VMware Installation:
1 vCPU: Intel(R) Xeon(R) CPU X5680 @ 3.33GHz
Disk 1: 72GB
2048 Mbytes RAM
admin:run sql select name from processnode
name
==================
EnterpriseWideData
10.18.172.204
10.18.172.205
10.18.172.206
admin:show risdb query phone
----------- Phone Information -----------
#TotalPhones, #TotalRegistered, #RegisteredSCCP, #RegisteredSIP, #UnRegistered, #Rejected, #PartiallyRegistered, StateId, #ExpUnreg
15, 12, 9, 3, 3, 0, 0, 28,0
DeviceName, Descr, Ipaddr, Ipv6addr, Ipv4Attr, Ipv6Attr, MACaddr, RegStatus, PhoneProtocol, DeviceModel, HTTPsupport, #regAttempts, prodId, username, seq#, RegStatusChg TimeStamp, IpAddrType, LoadId, ActiveLoadId, InactiveLoadId, ReqLoadId, DnldServer, DnldStatus, DnldFailReason, LastActTimeStamp
SEP44E4D9449BB4, Auto 86274, 14.48.27.61, , 0, 0, 44E4D9449BB4, reg, SIP, 493, yes, 0, 380, NoUserId, 1, 1330632927, 1, sip9971.9-2-1, sip9971.9-2-1, sip9971.9-2-3-27, , , 0, , 1330632927
...<abbreviated>...
SEP001121FF9474, Auto 86204, 14.48.30.11, , 3, 0, 001121FF9474, reg, SCCP, 495, yes, 0, 382, NoUserId, 15, 1330633090, 1, SCCP69xx.9-2-1-0, SCCP69xx.9-2-1-0, , , , 0, , 1330633090
----------------
Total count 15
----------------
admin:quit
Connection to 10.18.172.204 closed.
mymac:uc wsisk$ ssh administrator at 10.18.172.205
administrator at 10.18.172.205's password:
Command Line Interface is starting up, please wait ...
Welcome to the Platform Command Line Interface
VMware Installation:
1 vCPU: Intel(R) Xeon(R) CPU X5680 @ 3.33GHz
Disk 1: 72GB
2048 Mbytes RAM
admin:show risdb query phone
----------- Phone Information -----------
#TotalPhones, #TotalRegistered, #RegisteredSCCP, #RegisteredSIP, #UnRegistered, #Rejected, #PartiallyRegistered, StateId, #ExpUnreg
13, 0, 0, 0, 13, 0, 0, 30,0
DeviceName, Descr, Ipaddr, Ipv6addr, Ipv4Attr, Ipv6Attr, MACaddr, RegStatus, PhoneProtocol, DeviceModel, HTTPsupport, #regAttempts, prodId, username, seq#, RegStatusChg TimeStamp, IpAddrType, LoadId, ActiveLoadId, InactiveLoadId, ReqLoadId, DnldServer, DnldStatus, DnldFailReason, LastActTimeStamp
SEP001121FF9474, Auto 86204, 14.48.30.11, , 3, 0, 001121FF9474, unr, SCCP, 495, yes, 0, 382, NoUserId, 1, 1330633084, 1, SCCP69xx.9-2-1-0, SCCP69xx.9-2-1-0, , , , 0, , 1330633084
...<abbreviated>...
SEP88F07788A774, Auto 86275, 14.48.64.46, , 0, 0, 88F07788A774, unr, SIP, 493, yes, 0, 380, NoUserId, 13, 1330633042, 1, sip9971.9-2-1, sip9971.9-2-1, sip9971.9-2-3-27, , , 0, , 1330633042
----------------
Total count 13
----------------
admin:quit
Connection to 10.18.172.205 closed.
mymac:uc wsisk$ ssh administrator at 10.18.172.206
administrator at 10.18.172.206's password:
Command Line Interface is starting up, please wait ...
Welcome to the Platform Command Line Interface
VMware Installation:
1 vCPU: Intel(R) Xeon(R) CPU X5680 @ 3.33GHz
Disk 1: 72GB
2048 Mbytes RAM
admin:
admin:show risdb query phone
----------- Phone Information -----------
#TotalPhones, #TotalRegistered, #RegisteredSCCP, #RegisteredSIP, #UnRegistered, #Rejected, #PartiallyRegistered, StateId, #ExpUnreg
2, 0, 0, 0, 2, 0, 0, 4,0
DeviceName, Descr, Ipaddr, Ipv6addr, Ipv4Attr, Ipv6Attr, MACaddr, RegStatus, PhoneProtocol, DeviceModel, HTTPsupport, #regAttempts, prodId, username, seq#, RegStatusChg TimeStamp, IpAddrType, LoadId, ActiveLoadId, InactiveLoadId, ReqLoadId, DnldServer, DnldStatus, DnldFailReason, LastActTimeStamp
SEP001121FF9C3F, Auto 86203, 14.48.64.42, , 3, 0, 001121FF9C3F, unr, SCCP, 496, yes, 0, 383, NoUserId, 1, 1330632834, 1, SCCP69xx.9-2-1-0, SCCP69xx.9-2-1-0, , , , 0, , 1330632834
SEP001121FF9474, Auto 86204, 14.48.30.11, , 3, 0, 001121FF9474, unr, SCCP, 495, yes, 0, 382, NoUserId, 2, 1330632834, 1, SCCP69xx.9-2-1-0, SCCP69xx.9-2-1-0, , , , 0, , 1330632834
----------------
Total count 2
----------------
admin:quit
Regards,
Wes
On Mar 2, 2012, at 11:16 AM, Wesley Schochet wrote:
No, the total says 18 - it should be about 350. I get exactly the same results on the Pub and ach of the subs.
>>> On 3/1/2012 at 1:41 PM, Lelio Fulgenzi <lelio at uoguelph.ca> wrote:
ok. this is a really silly question, but it bit me.
what terminal package are you using to capture the information? also, what are you using to open the capture file?
if you use putty and configure to log the output and then use something like wordpad to open the file, you might see different results.
is the Total Count that's at the end what you expect?
---
Lelio Fulgenzi, B.A.
Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1
(519) 824-4120 x56354 (519) 767-1060 FAX (ANNU)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Cooking with unix is easy. You just sed it and forget it.
- LFJ (with apologies to Mr. Popeil)
From: "Wesley Schochet" <Wesley.Schochet at childrensmn.org>
To: cisco-voip at puck.nether.net
Sent: Thursday, March 1, 2012 12:54:47 PM
Subject: [cisco-voip] risdb query
Hi all-
I am trying to understand this risdb query. When I issue the cli command
show risdb query phone
I get a list of 18 phones. However, there are several hundred in my system, most of which are registered. Is there something I am missing with this command? I have tried it from the pub and the subs and get identical results.
Thanks
Wesley A. Schochet
System Architect
Children's of Minnesota
+ wes.schochet at childrensmn.org
( 651-855-2081
È 651-592-5441
Confidentiality Statement:
This email/fax, including attachments, may include confidential
and/or proprietary information and may be used only by the
person or entity to which it is addressed. If the reader of
this email/fax is not the intended recipient or his or her
agent, the reader is hereby notified that any dissemination,
distribution or copying of this email/fax is prohibited. If you
have received this email/fax in error, please notify the sender
by replying to this message and deleting this email or
destroying this facsimile immediately.
_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
Confidentiality Statement:
This email/fax, including attachments, may include confidential
and/or proprietary information and may be used only by the
person or entity to which it is addressed. If the reader of
this email/fax is not the intended recipient or his or her
agent, the reader is hereby notified that any dissemination,
distribution or copying of this email/fax is prohibited. If you
have received this email/fax in error, please notify the sender
by replying to this message and deleting this email or
destroying this facsimile immediately. _______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20120302/43b8fdc9/attachment.html>
More information about the cisco-voip
mailing list