이 문서에서는 보안 암호를 다시 설정한 후 게시자와 구독자 간의 복제가 중단될 수 있는 Unity Connection에서 발생한 문제를 설명하고 문제를 해결합니다.
이 문서와 관련된 두 가지 결함이 있습니다.Cisco 버그 ID CSCth87452 및 CSCua09290.
문제를 해결하기 위해 보안 비밀번호를 재설정한 후에는 복제가 제대로 설정되지 않습니다.
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
RTMT(REPLICATION SETUP) & details 열은 (2)를 모두 표시하지 않으므로 문제를 나타냅니다. 파일 보기 activelog /cm/log/informix/ccm.log을 입력하면 출력에 다음이 표시될 수 있습니다.
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.
처음에는 Publisher와 Subscriber 간에 데이터베이스(DB) 복제가 설정되지 않았으며, 이 동작은 Cisco 버그 ID CSCth87452 및 CSCua09290과 일치됩니다. 안타깝게도 솔루션의 일부로 루트 액세스가 필요하므로 문제를 해결하려면 Cisco TAC(Technical Assistance Center)가 필요합니다.
문제를 해결하려면 다음 단계를 완료하십시오.
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