この資料はパブリッシャ および サブスクライバ間の複製が割り込まれるかもしれない Unity Connection でセキュリティパスワードを変えた、問題にソリューションを提供する後直面する問題を記述したものです。
この資料と 2 つの問題が関連していますあります: Cisco バグ ID CSCth87452 および CSCua09290。
問題に対処するためにセキュリティパスワードを変えた後複製はきちんと設定しません。
パブリッシャからこのコマンドを入力する場合この出力を見るかもしれません: 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
両方とも(2)示さないので複製 SETUP(RTMT)及び Details カラムが問題を示すことに注意して下さい。 またファイル ビュー 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.
最初に、パブリッシャ および サブスクライバの間で確立されないデータベース(DB)複製 ISS およびこの動作が Cisco バグ ID CSCth87452 および CSCua09290 と一致することがわかる可能性があります。 ルートアクセスがソリューションの一部として必要となるので残念ながら、Cisco Technical Assistance Center (TAC)は必要問題を解決するためです。
この問題を修正するには、次の手順を実行します。
cd /tmp <enter>
sftp username@IPAdressSFTPServer <enter>
get SyncInformixPasswordWithSystem.py <enter>
bye <enter>
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