One of the most common problems I've come across when setting up several replication shares at once is that the password commonly gets entered wrong. Most users use the same service account across all of their replication shares, the account normally has a non-expiring password and is used exclusively for the k1000 replication tasks.
All of the passwords in the database are encrypted so viewing the contents and comparing them is painful. An easy way arond this is to conver the password output to a hexidecimal format, this makes comparing the output easier and the differences can jump out.
The SQL code below can be copied and pasted into a new SQL report on the K1000 or pasted into you favorite reporting tool like MySQL Workbench.
SELECT MACHINE.NAME AS REP_SHARE_NAME,
DESTINATION_DIR,
DESTINATION_DIR_USER,
HEX(DESTINATION_DIR_PASSWORD_ENC) AS ENCRYPTED_DESTINATION_PASSWORD,
DOWNLOAD_DIR, DOWNLOAD_DIR_USER,
HEX(DOWNLOAD_DIR_PASSWORD_ENC) AS ENCRYPTED_DOWNLOAD_DIR
FROM REPLICATION_SHARE
INNER JOIN MACHINE on
REPLICATION_SHARE.MACHINE_ID = MACHINE.ID
The image below shows the column for the ENCRYPTED_DESTINATION_PASSWORD, guess which one is wrong.
Comments