[cisco-voip] Database Replication fails

Thu Jan 24 17:24:24 EST 2013

Ahmed,

The bug id is CSCti18766.

Thanks,
Kalyan

From: Ahmed Elnagar [mailto:ahmed_elnagar at hotmail.com]
Sent: Thursday, January 24, 2013 4:57 PM
To: Kalyan Iyer (AM); 'VOIP Group'
Subject: RE: [cisco-voip] Database Replication fails

Hello Kalyan;

Do you have the bug ID?

Regards,
Ahmed Elnagar | Unified Communication Team Leader | CCIE #24697, Voice
[cid:image001.jpg at 01CDFA57.A78A4D50]

From: cisco-voip-bounces at puck.nether.net<mailto:cisco-voip-bounces at puck.nether.net> [mailto:cisco-voip-bounces at puck.nether.net]<mailto:[mailto:cisco-voip-bounces at puck.nether.net]> On Behalf Of Ahmed Elnagar
Sent: Thursday, January 24, 2013 7:36 PM
To: Kalyan Iyer (AM); VOIP Group
Subject: Re: [cisco-voip] Database Replication fails

What happened is

I installed Pub and Sub, but configured 3 server "system>server" then when tried to install the 3rd one RAID failure "RMA bla bla" new hardware come after two months "during which I changed the security password.

Now I install normally and having the below issue after installtion "even now reverted back to the old password on all servers :("

I opened a TAC for this now.
Thanks,
Ahmed Elnagar

________________________________
From: kalyan.iyer at dimensiondata.com<mailto:kalyan.iyer at dimensiondata.com>
To: ahmed_elnagar at hotmail.com<mailto:ahmed_elnagar at hotmail.com>
Date: Thu, 24 Jan 2013 12:28:53 -0500
Subject: RE: [cisco-voip] Database Replication fails
Ahmed,

Was the security password changed recently? I ran into the same bug on CUCM 8.5 once, when I tried to add a Sub to an existing cluster and the security password was misplaced and  I had to change it using the pwrecovery option and reboot it. I was able to add the Sub during the installation but the replication failed. The symptoms seem to be the same. It's something to do with the way the password gets hashed after changing it. This is a known bug on CUCM 8.5 and only TAC can fix this by running a script.

Thanks,
Kalyan

From: cisco-voip-bounces at puck.nether.net<mailto:cisco-voip-bounces at puck.nether.net> [mailto:cisco-voip-bounces at puck.nether.net]<mailto:[mailto:cisco-voip-bounces at puck.nether.net]> On Behalf Of Ahmed Elnagar
Sent: Thursday, January 24, 2013 11:55 AM
To: VOIP Group; rratliff at cisco.com<mailto:rratliff at cisco.com>
Subject: [cisco-voip] Database Replication fails

I am having the below issue with one subscriber "my setup is one publisher and two subscribers"

>From the Publisher I have the below:

admin:utils dbreplication runtimestate

DB and Replication Services: ALL RUNNING
Cluster Replication State: BROADCAST SYNC Completed on 1 servers at: 2013-01-24-19-11
     Last Sync Result: SYNC COMPLETED  541 tables sync'ed out of 541
     Sync Errors: 1 Errors or failures were found
     Use this command to see the output - file view activelog /cm/trace/dbl/2013_01_24_19_10_13_dbl_repl_cdr_Broadcast.log
DB Version: ccm8_6_2_22900_9
Number of replicated tables: 541

Cluster Detailed View from PUB (3 Servers):

                                PING            REPLICATION     REPL.   DBver&  REPL.   REPLICATION SETUP
SERVER-NAME     IP ADDRESS      (msec)  RPC?    STATUS          QUEUE   TABLES  LOOP?   (RTMT) & details
-----------     ------------    ------  ----    -----------     -----   ------- -----   -----------------
PUB    10.x.x.x    0.033   Yes     Connected       0       match   Yes     (2) PUB Setup Completed
SUB01    10.x.x.y    0.115   Yes     Connected       0       match   Yes     (2) Setup Completed
SUB02    10.x.x.z    0.107   Yes     Off-Line        N/A     0       N/A     (0) Not Setup
admin:

and on the publisher I see this for the 2nd subscriber I am having an issue with

admin:file view activelog cm/log/informix/ccm.log

19:16:17  Password Validation for user [dblpm] failed!
19:16:17  Check for password aging/account lock-out.
19:16:17  listener-thread: err = -952: oserr = 0: errstr = dblpm at SUB02: User (dblpm at SUB02)'s password is not correct for the database server.

19:16:17  Password Validation for user [dbmon] failed!
19:16:17  Check for password aging/account lock-out.
19:16:17  listener-thread: err = -952: oserr = 0: errstr = dbmon at SUB02: User (dbmon at SUB02)'s password is not correct for the database server.

19:16:17  Password Validation for user [dbris] failed!
19:16:17  Check for password aging/account lock-out.
19:16:17  listener-thread: err = -952: oserr = 0: errstr = dbris at SUB02: User (dbris at SUB02)'s password is not correct for the database server.

19:16:19  Password Validation for user [dbauditlog] failed!
19:16:19  Check for password aging/account lock-out.
19:16:19  listener-thread: err = -952: oserr = 0: errstr = dbauditlog at SUB02: User (dbauditlog at SUB02)'s password is not correct for the database server.

19:16:20  Password Validation for user [dbmon] failed!
19:16:20  Check for password aging/account lock-out.
19:16:20  listener-thread: err = -952: oserr = 0: errstr = dbmon at SUB02: User (dbmon at SUB02)'s password is not correct for the database server.

options: q=quit, n=next, p=prev, b=begin, e=end (lines 1 - 20 of 5708) :
admin:

I am sure that security password is the same everywhere, what do you think the problem is?

Thanks,
Ahmed Elnagar

itevomcid
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20130124/ac1f3796/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 2768 bytes
Desc: image001.jpg
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20130124/ac1f3796/attachment.jpg>