[cisco-voip] Database Replication fails

Thu Jan 24 19:00:25 EST 2013

Just finished the TAC case, there is a new bug ID for the new version now J 

Bug Id is CSCua09290

Regards,

Ahmed Elnagar | Unified Communication Team Leader | CCIE #24697, Voice

Description: Description: Description: MS Green

From: Kalyan Iyer (AM) [mailto:kalyan.iyer at dimensiondata.com] 
Sent: Friday, January 25, 2013 12:24 AM
To: Ahmed Elnagar; 'VOIP Group'
Subject: RE: [cisco-voip] Database Replication fails

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

Description: Description: Description: MS Green

From: cisco-voip-bounces at puck.nether.net
[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
To: 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] On Behalf Of Ahmed Elnagar
Sent: Thursday, January 24, 2013 11:55 AM
To: VOIP Group; 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/20130125/a2ec4389/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 2768 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20130125/a2ec4389/attachment.jpg>