Cisco UCM CAR (CDR) Web GUI Access Request (https:///car/)

http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/admin/11_5_1_SU1/Administration/cucm_b_administration-guide-1151su1/cucm_b_administration-guide-1151su1_chapter_010.pdf

 

To provide a user to CAR (CDR)  (https://<CAR server IP Address>/car/) web page, the following two access groups must be associated with the user. After giving user this access, please test login to other areas of UCM GUI, so the users do not gain unapproved access to UCM Admin pages.

 

  1. Standard CCM End Users
  2. Standard Admin Rep Tool Admin = (Standard CAR Admin Users, Standard CCM Super Users)

 

CAR web gui

Advertisements

Interview question: Cisco Voice Engineer: CUCM Database replication value, do you know what you are talking about?

This is a helpful reminder note for all who manages CUCM on day-to-day basis and one of the favorite Voice/IPTel Engineer interview questions. I think I was asked this question in almost every voice Engineer role interviews. Good luck with your next interview!

Q1. What does CUCM database replication value mean to you (CM Administrator)? 

2 = Good, excellent, no behind pain

Other than 2 = Behind pain begins

Value Meaning Description
0 Initialization State This state indicates that replication is in the process of trying to  setup. Being in this state for a period longer than an hour could  indicate a failure in setup.
1 Number of Replicates not correct This state is rarely seen in 6.x and 7.x but in 5.x can indicate its  still in the setup process. Being in this state for a period longer than  an hour could indicate a failure in setup.
2 Replication is good Logical connections have been established and tables match the other servers on the cluster.
3 Tables are suspect Logical connections have been established but we are unsure if tables match.
In 6.x and 7.x all servers could show state 3 if one server is down in  the cluster.
This can happen because the other servers are unsure if  there is an update to a user facing feature that has not been passed  from that sub to the other device in the cluster.
4 Setup Failed / Dropped The server no longer has an active logical connection to receive  database table across. No replication is occurring in this state.

Source: CCO

Q2. How to check?

Option 1: On CUCM OS CLI, run show command

admin:show perf query class “Number of Replicates Created and State of Replication”
==>query class :

– Perf class (Number of Replicates Created and State of Replication) has instances and values:
ReplicateCount -> Number of Replicates Created = 427
ReplicateCount -> Replicate_State = 2 <<< Life is Good

Option 2: On CUCM Unified Reporting 

Cisco Unified Reporting > System Reports > Unified CM Database Status >> Run report

 

%ec%82%ac%ec%9a%a9%ec%9e%90-%ec%a7%80%ec%a0%95-12%ec%82%ac%ec%9a%a9%ec%9e%90-%ec%a7%80%ec%a0%95-13

Option 3: Real Time Monitoring Tool (RTMT)

Install RTMT plugin on your desktop. Launch RTMT and then go to “Call Manager > Service > Database Summary”

Q3. How to repair a broken db replication issue?

I have come acorss a very good blog and it shows you on how to repair a broken db replication. Click here.

 

 

 

Microsoft – File Checksum Integrity Verifier

Why run this tool?

Answer: Check the integrity of the file before apply to a system/servers/devices so you can avoid a big headache later

Step 1: Download the MD5 checksum program from Microsoft Site:

Step 2: Extract the file into your known folder

filechecksum1

Step 3: Run the tool in Command Line.

filechecksum2

E.G.) I am running a checksum of Cisco IP Phone firmware before an upgrade.

C:\Users\bchoi\Documents\fciv.exemd5 D:\Patch\cmterm-devicepack8.6.2.26159-3.cop.sgn
//
// File Checksum Integrity Verifier version 2.05.
//
f3aa5d2d5a12e1d57aeacdaa43ff1b4d d:\patch\cmterm-devicepack8.6.2.26159-3.cop.sgn

Step 4: Confirm the checksum value on the vendor’s download page and the value that you have received from the tool.

filechecksum3

Cisco Collaboration 101-5: CUCM Mobile Connect (a.k.a CUCM Single Number Reach) configuration, make your deskphone and your Mobile (Cell) phone to ring at the same time

Task

1. Configure Cisco Mobile Connect feature on a user phone

2. Any incoming calls to the user’s deskphone should ring simultaneously on the user deskphone as well as on his Mobile phone (0 + 0414024726) <<<This is an Australian mobile, just an example

3. Mobility softkey should be displayed on the user phone during the call and on-hook status

Step 1: Create a user on CUCM

Go to ‘User Management’ >’ End User’ > ‘Add New’

*If you already have an LDAP integration, simply use existing user and modify the settings for Cisco Mobile Connect

*Presuming that a user is an existing user with an IP Phone configured.

*The CUCM version used is version 10.5

Create a new user

Associate the user’s phone

Tick ‘Enable Mobility’ & ‘Enable Mobile Voice Access’

Click on ‘Save’ to save the changes

Step 2: Go to the user’s device (phone)

Go to ‘Device’ > ‘Phone’

Find the user’s phone

On Device settings, update the ‘Owner User ID’ filed with the user’s profile

Click on ‘Save’ to save the changes

On the same page, under ‘Related Links’, select ‘Copy to Remote Destination Profile’ and click on ‘GO’ button

Configure ‘Remote Destination Profile’, confirm that the information in the red boxes are correctly configured for your CUCM environment. Then click on ‘Save’ to save the changes

Under ‘Associated Remote Destinations”, click on ‘Add a New Remote Destination’

Configure ‘Remote Destination Configuration’, make sure that you place the leading ‘9’ or ‘0’ for calls going out. If the destination is an external number, then you MUST place the outgoing leading ‘9’ or ‘0’. If this is for an internal number, you can simply enter an internal extension.

*Note on above setup, the deskphone will ring for first 4 seconds, then followed by the ringing of the user’s mobile (cell) phone. Adjust the settings per client’s request.

Check ‘Line Association’ box and click on ‘Save’ button.

Go to ‘Device’ > ‘Device Settings’ > ‘Remote Destination Profile’

Click on the user’s extension

On the line settings, scroll down all the way, until you find ‘Multiple Call/Call Waiting Settins on Device rdp_mobile_brchoi and change the “Maximum Number of Calls’ from 2 to 1. Click on ‘Save’ button.

Step 3: Make a softkey for the phone

Go to ‘Device’ > ‘Device Settings’ > ‘Softkey Template’

Locate ‘Standard User’ softkey and copy

Rename it as ‘Standard User-Mobility’ and then, on ‘Related Links’, select ‘Configure Softkey Layout’ and click on ‘Go’ button.

Select when the phone is ‘On-Hook’, add ‘Mobility’ key and place the key as you like.

Select ‘Connected’ option, add ‘Mobility’ softkey and move it up or down as you like. Don’t forget to click on the Save button.

Go to ‘Device’ > ‘Phone’

Locate the same user phone and update the ‘Softkey Template’ to the template which has been created in previous task.

Don’t forget to click on the ‘Save’ button

Click on ‘Apply Config’

Click on ‘Reset’ button to make the change take place on the phone.

Verification:

  • Make a call to the user’s deskphone extension, the phone will ring for 4 seconds, then the user’s Mobile/Cell phone will start ring.
  • As soon as the call is answered on either the deskphone or Mobile/Cell phone, the other phone will start ringing. Now you have a single number reach on this user’s phone.

Cisco Collaboration 101-3: download MoH file from CUCM TFTP server

When you administrate Cisco CUCM, often there is a situation where you have to locate a file and download the file from CUCM server, particularly from the CUCM TFTP and MOH servers.

OK, first, here is an example of ‘file get’ command to download an xml file from a CUCM TFTP server.

admin:file get tftp /WLANDefault.xml
Please wait while the system is gathering files info …done.
Sub-directories were not t*raversed.
Number of files affected: 1
Total size in Bytes: 21768
Total size in Kbytes: 21.257812
Would you like to proceed [y/n]? y
SFTP server IP: 10.168.46.2
SFTP server port [22]:
User ID: administrator
Password: ********

Download directory: /

The authenticity of host ‘192168.46.2 (192168.46.2 )’ can’t be established.
RSA key fingerprint is 08:39:1b:80:c5:e4:c1:60:de:5c:5b:3a:7d:be:8a:ae.
Are you sure you want to continue connecting (yes/no)? yes
.
Transfer completed.
admin:

=====================================================================

Now here is a list of ‘file list’ command sets.

admin:file list
file list activelog
file list inactivelog
file list install
file list license
file list partBsalog
file list salog
file list tftp

We have to snoop around to locate where our hidden MoH files are and it is under “activelog /mohprep” folder:

admin:file list activelog /*
<dir> audit
<dir> car_db
<dir> ccm_db
<dir> cm
<dir> core
<dir> dp_db
<dir> installed_options
<dir> mgetty
<dir> mohprep
<dir> patches
<dir> platform
<dir> sa
<dir> syslog
<dir> tomcat
dir count = 14, file count = 0
admin:file list activelog mohprep /*
CiscoMOHSourceReport.xml SampleAudioSource.alaw.wav
SampleAudioSource.g729.wav SampleAudioSource.ulaw.wav
SampleAudioSource.wb.wav SampleAudioSource.xml
SilenceAudioSource.alaw.wav SilenceAudioSource.g729.wav
SilenceAudioSource.ulaw.wav SilenceAudioSource.wb.wav
SilenceAudioSource.xml
dir count = 0, file count = 11
admin:file list activelog syslog ?
Syntax:
file list activelog file-spec [options]
file-spec mandatory file to view
options optional page|detail|reverse|[date|size]

Let’s also look at what is under active syslog folder:

admin:file list activelog syslog /*
AlternateSyslog CiscoSyslog
CiscoSyslog.1 CiscoSyslog.2
CiscoSyslog.3 CiscoSyslog.4
boot.log boot.log.ori
cron cron.1
cron.2 maillog
messages messages.1
messages.2 messages.3
messages.4 messages.ori
notify.sh.log ntp_start.sh.log
ntp_validate_servers.sh.log ntpd.log
sd_ntp.log secure
secure.1 secure.2
secure.3 secure.4
secure.ori setkeysdetails.sh.log
spooler
dir count = 0, file count = 3

======================================================================

Now if you found what you are looking for in an active MoH folder, go ahead and run “file get activelog /mohprep/[name of your MoH file]”:

admin:file get activelog /mohprep/ECM-MOH-Bunnings-Aug-2015.ulaw.wav
Please wait while the system is gathering files info …done.
Sub-directories were not traversed.
Number of files affected: 1
Total size in Bytes: 1728822
Total size in Kbytes: 1688.3027
Would you like to proceed [y/n]? y
SFTP server IP: 10.171.217.110
SFTP server port [22]:
User ID: cisco
Password: *********

Download directory: /

.
Transfer completed.

======================================================================
admin:file list activelog /mohprep/SampleAudioSource-test.ulaw.wav
SampleAudioSource-test.ulaw.wav
dir count = 0, file count = 1
admin:file get activelog /mohprep/SampleAudioSource-test.ulaw.wav
Please wait while the system is gathering files info …done.
Sub-directories were not traversed.
Number of files affected: 1
Total size in Bytes: 2702728
Total size in Kbytes: 2639.3828
Would you like to proceed [y/n]? n
Files transfer cancelled.
admin:file get activelog /mohprep/SampleAudioSource -test.ulaw.wav
Invalid command, a dash character must be preceded by an alphanumeric character

admin:file get activelog /mohprep/SampleAudioSource test.ulaw.wav
Missing file-spec or invalid command option specified.
Valid options: [reltime|abstime][match][compress]
admin:

The issue with the space seems to match defect CSCsr43052: http://tools.cisco.com/Support/BugToolKit/search/getBugDetails.do?method=fetchBugDetails&bugId=CSCsr43052

Cisco Unified Communications Manager (CallManager) License backup

Hope this helps anyone who also manage Cisco Unified Communications Manager on day-to-day basis:

Task: to export license files from a Cisco Cisco Unified Communications Manager (a.k.a CallManager) ver. 5 – 10
– Reconcile all licenses in production server
– Verify the PAK key inside each license file

Option 1: Log into CUCM OS CLI
Use the following commands to list, view and get the license files:
file list license
file view license
file get license
file get license *
*Option 2: Just grab a copy from your DRS back-up

If you are running DRS backups regularly, the licsense files can be found in the following path:
Copy the backed-up tar file and extract it using 7-zip or Winrar.

E.G.) 2015-07-07-01-00-00_CMPUB_CCM_PLATFORM.tar

\\usr\local\cm\conf\licfiles

CCM license file location