Skip to main content
Delphix

Changing Password for Masking User "delphix_admin" (Internal Only)

Applicable Delphix Versions

  • 5.1
  • 5.0

Issue

Customer can't remember the password of the delphix_admin (or Axistech) Masking user and the account is locked.

Troubleshooting

Customer has attempted to login more than three times unsuccessfully from the Masking UI and is seeing the following error:

Login to the Delphix Engine and use "/opt/delphix/server/bin/mds_client -- -U dmsuite" to confirm account is_locked:

/opt/delphix/server/bin/mds_client -- -U dmsuite
hercules=> select * from user_security;
 user_security_id | no_of_attempt | is_locked |   first_attempt_time    | last_pwd_updated_date | is_password_changed |   user_name   
------------------+---------------+-----------+-------------------------+-----------------------+---------------------+---------------
 delphix_admin    |             3 |         1 | 2017-08-08 20:05:21.038 |                       |                     | delphix_admin
(1 row)

Resolution

  • Unlock the account
  • hercules=> delete from user_security where is_locked = '1';
    DELETE 1
     
    hercules=> select * from user_security;
     user_security_id | no_of_attempt | is_locked | first_attempt_time | last_pwd_updated_date | is_password_changed | user_name 
    ------------------+---------------+-----------+--------------------+-----------------------+---------------------+-----------
    (0 rows)
    
  • Generate an Encrypted String for generic password Delphix_123 with /opt/delphix/dmsuite/pwdEnc/bin/pwdEnc
$ cd /opt/delphix/dmsuite/pwdEnc/bin
$ ./pwdEnc Delphix_123 ENCRYPT_CLI
 
ERROR: JAVA_HOME is not set and no 'java' command could be found in your PATH.
 
Please set the JAVA_HOME variable in your environment to match the
location of your Java installation.

$ find /opt -name java
/opt/jdk1.6.0/jre/bin/java
/opt/jdk1.6.0/jre/bin/amd64/java
/opt/jdk1.6.0/bin/java
/opt/jdk1.6.0/bin/amd64/java
/opt/jdk1.8.0_60/bin/java
/opt/jdk1.8.0_60/bin/amd64/java
/opt/jdk1.8.0_60/jre/bin/java
 
$ echo $PATH
/usr/ccs/bin:/usr/local/bin:/usr/gnu/bin:/usr/bin:/usr/sbin:/sbin:/opt/gcc-4.8.1/bin:/opt/omni/bin

$ export PATH=/usr/ccs/bin:/usr/local/bin:/usr/gnu/bin:/usr/bin:/usr/sbin:/sbin:/opt/gcc-4.8.1/bin:/opt/omni/bin:/opt/jdk1.8.0_60/bin

$ ./pwdEnc Delphix_123 ENCRYPT_CLI
strEncrypted = /N1Roz03cCXY81UNwHYpLA==
Encrypted Password String is %2FN1Roz03cCXY81UNwHYpLA%3D%3D
  • Change the password to Delphix_123 

/opt/delphix/server/bin/mds_client -- -U dmsuite
hercules=> select * from user_login;
 user_login_nm |     user_password_tx     |           email_tx            | first_nm | last_nm | active_in | is_admin 
---------------+--------------------------+-------------------------------+----------+---------+-----------+----------
 Axistech      | 4k7AuX54qSGcnzg34FU+cA== | support@axistechnologyllc.com | Axis     | Tech    |         1 |        1
 delphix_admin | gwE/LijouyzaypFg0VePdg== | support@delphix.com           | Delphix  | Tech    |         1 |        1
(2 rows)

hercules=> update user_login set user_password_tx='/N1Roz03cCXY81UNwHYpLA==' where user_login_nm='delphix_admin';
UPDATE 1
hercules=> select * from user_login;
 user_login_nm |     user_password_tx     |           email_tx            | first_nm | last_nm | active_in | is_admin 
---------------+--------------------------+-------------------------------+----------+---------+-----------+----------
 Axistech      | 4k7AuX54qSGcnzg34FU+cA== | support@axistechnologyllc.com | Axis     | Tech    |         1 |        1
 delphix_admin | /N1Roz03cCXY81UNwHYpLA== | support@delphix.com           | Delphix  | Tech    |         1 |        1
(2 rows)

  • Have the customer attempt to login as delphix_admin/Delphix_123 via the GUI and show them where to modify the password