Ce document décrit un problème rencontré dans Unity Connection où la réplication entre Publisher et Subscriber peut être interrompue après la réinitialisation du mot de passe de sécurité et offre une solution au problème.
Ce document présente deux défauts : ID de bogue Cisco CSCth87452 et CSCua09290.
Après avoir réinitialisé le mot de passe de sécurité afin de résoudre un problème, la réplication n'est pas configurée correctement.
Vous pouvez voir cette sortie si vous entrez cette commande à partir de Publisher : utils dbreplication runtimestate.
PING
SERVER-NAME IP ADDRESS (msec)
----------- ------------ ------
Cisco1 192.168.2.50 0.038
Cisco2 192.168.2.51 0.273
CDR Server REPL. DBver& REPL. REPLICATION SETUP
RPC? (ID) & STATUS QUEUE TABLES LOOP? (RTMT) & details
---- -------------- ----- ------- ----- -----------------
Yes (2) Connected 0 match Yes (2) PUB Setup Completed
Yes (3) Connected 0 match N/A (3) Not Setup
Notez que la colonne REPLICATION SETUP(RTMT) & details indique des problèmes car elle n'affiche pas les deux (2). De même, si vous entrez la vue de fichier activelog /cm/log/informix/ccm.log, la sortie peut afficher :
10:04:02 Password Validation for user [dbmon] failed!
10:04:02 Check for password aging/account lock-out.
10:04:02 listener-thread: err = -952: oserr = 0: errstr =
dbmon@Cisco2.na.cisco.corp[Cisco2]: User (dbmon@Cisco2.na.cisco.corp[Cisco2])'s
password is not correct for the database server.
10:04:06 Password Validation for user [dbauditlog] failed!
10:04:06 Check for password aging/account lock-out.
10:04:06 listener-thread: err = -952: oserr = 0: errstr =
dbauditlog@Cisco2.na.cisco.corp[Cisco2]: User (dbauditlog@Cisco2.na.cisco.corp[Cisco2])'s
password is not correct for the database server.
10:04:06 Password Validation for user [dbdbl] failed!
10:04:06 Check for password aging/account lock-out.
10:04:06 listener-thread: err = -952: oserr = 0: errstr =
dbdbl@Cisco2.na.cisco.corp[Cisco2]: User (dbdbl@Cisco2.na.cisco.corp[Cisco2])'s
password is not correct for the database server.
10:04:07 Password Validation for user [dblpm] failed!
10:04:07 Check for password aging/account lock-out.
10:04:07 listener-thread: err = -952: oserr = 0: errstr =
dblpm@Cisco2.na.cisco.corp[Cisco2]: User (dblpm@Cisco2.na.cisco.corp[Cisco2])'s
password is not correct for the database server.
Initialement, vous pouvez voir que la réplication de base de données (DB) n'est pas établie entre Publisher et Subscriber, et que ce comportement correspond aux ID de bogue Cisco CSCth87452 et CSCua09290. Malheureusement, comme l'accès racine est requis dans le cadre de la solution, le centre d'assistance technique Cisco (TAC) est nécessaire pour résoudre le problème.
Complétez ces étapes afin de résoudre le problème :
cd /tmp
sftp username@IPAdressSFTPServer
get SyncInformixPasswordWithSystem.py
bye
chmod 644 /tmp/SyncInformixPasswordsWithSystem.py
python /tmp/SyncInformixPasswordsWithSystem.py
[root@nw084b-181 /]# python /tmp/SyncInformixPasswordsWithSystem.py
Changing password for user informix.
passwd: all authentication tokens updated successfully.
Changing password for user database.
passwd: all authentication tokens updated successfully.
Changing password for user dbuser.
passwd: all authentication tokens updated successfully.
Changing password for user dbccm.
utils service start A Cisco DB
10:04:02 Password Validation for user [dbmon] failed!
10:04:02 Check for password aging/account lock-out.
10:04:02 listener-thread: err = -952: oserr = 0: errstr =
dbmon@Cisco2.na.cisco.corp[Cisco2]: User (dbmon@Cisco2.na.cisco.corp[Cisco2])'s
password is not correct for the database server.
10:04:06 Password Validation for user [dbauditlog] failed!
10:04:06 Check for password aging/account lock-out.
10:04:06 listener-thread: err = -952: oserr = 0: errstr =
dbauditlog@Cisco2.na.cisco.corp[Cisco2]: User (dbauditlog@Cisco2.na.cisco.corp[Cisco2])'s
password is not correct for the database server.
10:04:06 Password Validation for user [dbdbl] failed!
10:04:06 Check for password aging/account lock-out.
10:04:06 listener-thread: err = -952: oserr = 0: errstr =
dbdbl@Cisco2.na.cisco.corp[Cisco2]: User (dbdbl@Cisco2.na.cisco.corp[Cisco2])'s
password is not correct for the database server.
10:04:07 Password Validation for user [dblpm] failed!
10:04:07 Check for password aging/account lock-out.
10:04:07 listener-thread: err = -952: oserr = 0: errstr =
dblpm@Cisco2.na.cisco.corp[Cisco2]: User (dblpm@Cisco2.na.cisco.corp[Cisco2])'s
password is not correct for the database server.
PING
SERVER-NAME IP ADDRESS (msec)
----------- ------------ ------
Cisco1 192.168.2.50 0.038
Cisco2 192.168.2.51 0.273
CDR Server REPL. DBver& REPL. REPLICATION SETUP
RPC? (ID) & STATUS QUEUE TABLES LOOP? (RTMT) & details
---- -------------- ----- ------- ----- -----------------
Yes (2) Connected 0 match Yes (2) PUB Setup Completed
Yes (3) Connected 0 match N/A (3) Not Setup
10:41:24 CDR CDRD_1: transaction aborted (All rows in a transaction defined with
row scope were rejected) with sql error 0 isam error 0.
10:41:24 CDR CDRD_1: failed rows spooled to
file /tmp/ris.g_Cisco1_ccm9_1_1_20000_5.g_Cisco2_ccm9_1_1_20000_5.D_1.140322_10:41:24.3
10:41:24 CDR CDRD_1: failed transaction spooled to
file /tmp/ats.g_Cisco1_ccm9_1_1_20000_5.g_Cisco2_ccm9_1_1_20000_5.D_1.140322_10:41:24.4
10:41:24 CiscoAlarmStart:Cisco1_ccm9_1_1_20000_5:ATTENTION:48:CDR: ATS and/or RIS
files spooled to disk.
:/tmp/ris.g_Cisco1_ccm9_1_1_20000_5.g_Cisco2_ccm9_1_1_20000_5.D_1.140322_10:41:24.3|
/tmp/ats.g_Cisco1_ccm9_1_1_20000_5.g_Cisco2_ccm9_1_1_20000_5.D_1.140322_10:41:24.4:CiscoAlarmEnd
DB and Replication Services: ALL RUNNING
DB CLI Status: No other dbreplication CLI is running...
Cluster Replication State: BATCHING SYNC Requests from nodes at: 2014-03-22-11-27
Sync Request Progress: Received 1 node requests for DB sync
Sync Request Errors: NO ERRORS
DB Version: ccm9_1_1_20000_5
Repltimeout set to: 300s
PROCESS option set to: 1
Cluster Detailed View from Cisco1 (2 Servers):
PING
SERVER-NAME IP ADDRESS (msec)
----------- ------------ ------
Cisco1 192.168.2.50 0.028
Cisco2 192.168.2.51 0.221
CDR Server REPL. DBver& REPL. REPLICATION SETUP
RPC? (ID) & STATUS QUEUE TABLES LOOP? (RTMT) & details
---- -------------- ----- ------- ----- -----------------
Yes (2) Connected 0 match Yes (2) PUB Batching Sub Req's
Yes (3) Connected 0 match N/A (0) Setup Requested
Cluster Replication State: BROADCAST SYNC Started on 1 server(s) at: 2014-03-22-11-32
Processing Table: typeconfiginputdata
Sync Progress: 275 tables sync'ed out of 603
Sync Errors: NO ERRORS
DB Version: ccm9_1_1_20000_5
Repltimeout set to: 300s
PROCESS option set to: 1
Cluster Detailed View from Cisco1 (2 Servers):
PING
SERVER-NAME IP ADDRESS (msec)
----------- ------------ ------
Cisco1 192.168.2.50 0.031
Cisco2 192.168.2.51 0.210
CDR Server REPL. DBver& REPL. REPLICATION SETUP
RPC? (ID) & STATUS QUEUE TABLES LOOP? (RTMT) & details
---- -------------- ----- ------- ----- -----------------
Yes (2) Connected 0 match Yes (2) PUB Setting Subs
Yes (3) Connected 0 match N/A (0) Setup in Progress
DB and Replication Services: ALL RUNNING
DB CLI Status: No other dbreplication CLI is running...
Cluster Replication State: BROADCAST SYNC Completed on 1 servers at: 2014-03-22-11-33
Last Sync Result: SYNC COMPLETED 603 tables sync'ed out of 603
Sync Errors: NO ERRORS
DB Version: ccm9_1_1_20000_5
Repltimeout set to: 300s
PROCESS option set to: 1
Cluster Detailed View from Cisco1 (2 Servers):
PING
SERVER-NAME IP ADDRESS (msec)
----------- ------------ ------
Cisco2 192.168.2.51 0.0298
Cisco1 192.168.2.50 0.050
CDR Server REPL. DBver& REPL. REPLICATION SETUP
RPC? (ID) & STATUS QUEUE TABLES LOOP? (RTMT) & details
---- -------------- ----- ------- ----- -----------------
Yes (3) Connected 0 match Yes (2) Setup Completed
Yes (2) Connected 0 match Yes (2) PUB Setup Completed
Révision | Date de publication | Commentaires |
---|---|---|
1.0 |
21-Apr-2014 |
Première publication |