Friday, September 30, 2011

Backup Cisco Router files to TFTP Server

Configure TFTP application (eg-3CDaemon)

Steps:
---------

Router#copy flash tftp

Source filename [DistinctiveRingList.xml]? ringtones/DistinctiveRingList.xml

Address or name of remote host []? 10.81.110.3

Destination filename [DistinctiveRingList.xml]? ringtones/DistinctiveRingList.xml
!!
2823 bytes copied in 0.972 secs (2904 bytes/sec)

Monday, September 26, 2011

Unable to delete user from Cisco Unity

Unable to delete user from Cisco Unity system


1. Trouble Shooting Steps

Step 1:

When checked the config found user extension assigned to old user, and user was not present in AD.

Tried to delete the user from CLI by using below Command

admin:run cuc dbquery unitydirdb EXECUTE PROCEDURE csp_UserDelete(pObjectId='a6ef1f75-253c-426f-93f6-88b5af84a788')

Key value for constraint (informix.pk_tbl_globaluser) is still being referencedot .

Command failed

Got above error and checked call routing /call handlers but didnt find anything.

Step 2:

Run the below query and found the following dependency.

admin:run cuc dbquery unitydirdb select * from vw_subscriberreference where objectid IN (select objectid from vw_subscriber where fn_tolower(alias) =fn_tolower('mary.flanders'))

objectid displayname referencetype referrerobjectid referrerobjecttype

------------------------------------ --------------- ------------- ------------------------------------ ------------------

a6ef1f75-253c-426f-93f6-88b5af84a788 AA Recipient c40fa18d-755e-40f5-b6d4-1fbd4a069a75 3

a6ef1f75-253c-426f-93f6-88b5af84a788 Receptionist Recipient 3f1ab745-40ca-4b67-8456-5041e52cbd19 3

a6ef1f75-253c-426f-93f6-88b5af84a788 mary.aRecipient 2081d266-1c83-4392-a9b8-466f391b3c23 3

Step 3:

Removed old user account from AA,Receptionist from following locations

Go to Call Management -- System Call Handlers --and select Call Handlers--choose edit --message settings

And remove associated user

Step 4:

Run the below command and deleted account from data base.

admin: run cuc dbquery unitydirdb SELECT ObjectId from vw_User WHERE Alias='mary.a' --to get the object ID

admin:run cuc dbquery unitydirdb EXECUTE PROCEDURE csp_UserDelete(pObjectId='a6ef1f75-253c-426f-93f6-88b5af84a788')


Few other cmds

----------------------


admin:run sql select userid, pkid from enduser where userid = ''

admin:run sql SELECT fkenduser, fkappserver FROM enduserappservermap WHERE fkenduser = '83215248-6288-446d-87e2-db5efcca3e98'

run sql delete FROM enduserappservermap WHERE fkenduser = '83215248-6288-446d-87e2-db5efcca3e98' and fkappserver = '67285943-ff95-4f4f-88c6-e6206cf23551


CME phone Firmware load

copy tftp:10.10.50.33 flash:apps31.8-4-1-23.sbn
copy tftp:10.10.50.33 flash:cvm31sccp.8-4-1-23.sbn
copy tftp:10.10.50.33 flash:cnu31.8-4-1-23.sbn
copy tftp:10.10.50.33 flash:dsp31.8-4-1-23.sbn
copy tftp:10.10.50.33 flash:jar31sccp.8-4-1-23.sbn
copy tftp:10.10.50.33 flash:SCCP31.8-4-2S.loads
copy tftp:10.10.50.33 flash:term31.default.loads


Tftp-server flash:apps31.8-4-1-23.sbn
Tftp-server flash:cnu31.8-4-1-23.sbn
Tftp-server flash:cvm31sccp.8-4-1-23.sbn
Tftp-server flash:dsp31.8-4-1-23.sbn
Tftp-server flash:jar31sccp.8-4-1-23.sbn
Tftp-server flash:SCCP31.8-4-2S.loads
Tftp-server flash:term31.default.loads


telephony-service
load 7931 SCCP31.8-4-2S
no create cnf
create cnf

exit
wr mem

tftp 10.10.60.250 get SEP001D09130611.cnf.xml

Deb ephone detail mac
Deb tftp event
debug ephone register
debug ephone statistics
debug ephone error
debug ephone message
debug ephone state
debug dhcp

PRI Config

isdn switch-type primary-net5
controller E1 0/0/0
framing crc4
linecode hdb3
pri-group timeslots 1-31
isdn bchan-number-order asce
clock source line

-----------------------------------------------

!
card type t1 1 0
!

//Enable T1 1/0

!
controller T1 1/0/0
framing esf
linecode b8zs
cablelength long 0db
pri-group timeslots 1-24
!
// configure T1
!
interface Serial1/0/0:23
no ip address
encapsulation hdlc
isdn switch-type primary-ni
isdn incoming-voice voice
isdn map address ^011 plan unknown type unknown
isdn supp-service name calling
no cdp enable
!


//Configure the T1 controller 1/0/0:23


voice-port 1/0/0:23
bearer-cap Speech
!

// For Bearer Capability in the ISDN Q.931 SETUP message.

!
dial-peer voice 7 pots
preference 5
incoming called-number .
direct-inward-dial
port 1/0/0:23
!

Refrence:

http://www.voip-info.org/wiki/view/CallManager+Express

http://uc500.com/en/configuring-cisco-unified-communications-manager-express

http://3packet.com/voip-phones-cisco-asterisk/ -- B/w calc

http://www.uccx.net/ –UCCX

http://chikkis.blogspot.com/ -Lab

http://cciev.wordpress.com/ -wordpress

http://voip.rheid.com/voip-faqs/voip-bandwidth-calculator.html

http://www.asteriskguide.com/bandcalc/bandcalc.php

tcping utility

http://www.elifulkerson.com/projects/tcping.php

http://pushkarbhatkoti.wordpress.com/ - Moh Download

http://pushkarbhatkoti.wordpress.com/2009/06/08/cisco-presence-integration-with-ccm-7x-in-20-minutes/ - Presence Configuration

http://my.lovelycharts.com    -->Flow charts


Cisco Icons

http://wenku.baidu.com/view/a6a518ff700abb68a982fbae.html

Cisco Unity Express Backup Procedure

Backup procedure

1. Configure a FTP server where you have to store the backup files .

Check ftp status using following DOS commands

ftp

telnet 21

There are two ways to take CUE backup files ,CLI or GUI

CLI backup procedure:

(config)# backup server url ftp:/// username XXX password XXX

# offline

=> It will bring the CUE off the production

# backup category all

Once complete the CUE back up enter below cmd It will bring the CUE back into production

# continue

Status commands

# show backup history

# show backup server

GUI backup procedure:

Go to Administration menu and select backup/Restore->choose configuration

Ref - http://netribe.blogspot.be/2010/08/upgrading-cisco-cue-from-311-to-32x.html

Debug CMDs

MGCP gateway

--------------


show ccm manger--to check reg or not

show mgcp statistic

show mgcp endpoints

show mgcp connection

debug mgcp packets

debug mgcp state

debug mgcp error

debug isdn q931



H.323

----------


show dialplan number

debug vtsp session

debug vpm signal

debug voice ccapi inout

debug voip dialpeer

debug cch323 h225


debug cch323 session


debug ccsip mess

debug voice ccapi inout


show isdn status

show isdn active

show isdn history

sh voice call summary

sh voice call status

show voip rtp connections


show dial-peer voice summary
show dialplan number
show call active voice
show call active voice brief
show isdn status




CM CLI

admin:file list activelog /cm/trace/cti/sdl/ date detail page

admin:file list activelog /cm/trace/cti/

admin:file list activelog /cm/trace/

admin:file list activelog /cm/trace/ccm/sdi/ detail date page

admin:file list activelog /cm/cdr_repository/car - CDR info

tftp 172.22.32.12 GET SEPFCFBFBCA1B1B.cnf.xml

utils diagnose test 
file get activelog tomcat/logs/*  -  To download Tomcat logs