Resetting a Local User's Password

The VMware Data Services Manager password for a local user can be reset in two ways:

• The user clicks the Forgot Password button on the VMware Data Services Manager login screen to initiate password reset via email. See Recovering the DSM Use Password.
• You reset the password manually using the following procedure.

Prerequisites

Ensure that the password you set for the user meets the password policy rules of VMware Data Services Manager. The password must contain:

• Minimum 8, maximum 20 characters,
• At least one uppercase letter, one lowercase letter,
• At least one number, and
• At least one special character (?!@#$%^&*).

Procedure

Perform the following procedure to set a new password for a local user:

1. SSH into the provider VM.

2. Run the following command to access the database:

   psql vmware postgres

3. Run the following on the psql command prompt.

   Replace <DESIRED_PASSWORD> and <DESIRED_LOCAL_USER_EMAIL> with actual values.

   update vmware.user set failed_login_count=null, last_failed_login_time=null, locked_state_start_time=null, force_password_change = false, password = pgp_sym_encrypt('<DESIRED_PASSWORD>', ((select ek.key from vmware.encryption_key ek where ek.type='PGCRYPTO_PASSWORD')), ((select ek.key from vmware.encryption_key ek where ek.type='PGCRYPTO_ALGORITHM'))) where email='<DESIRED_LOCAL_USER_EMAIL>';
   

4. Confirm the new password by using the following.

   select pgp_sym_decrypt(password, ((select ek.key from vmware.encryption_key ek where ek.type='PGCRYPTO_PASSWORD')), ((select ek.key from vmware.encryption_key ek where ek.type='PGCRYPTO_ALGORITHM'))) from vmware.user where email ='<DESIRED_LOCAL_USER_EMAIL>'; 
   

Next Steps

Communicate the new password to the user.