/build/static/layout/Breadcrumb_cap_w.png

Identifying authentication issues with k1000 replication shares

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

This post is locked
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ