How to reset the retry lockout and password for the sysadmin user

Products

• VMware Smart Assurance
• Network Observability

Issue/Introduction

• sysadmin is not working while logging to NCM GUI.
• sysadmin password is forgotten and cannot be changed. 
• Unable to login to NCM GUI as sysadmin password is not known. 

Environment

All supported NCM versions

Resolution

1. Login to NCM DB with 'root' access
2. Run command to login to NCM voyence DB 

   su - pgdba -c 'psql voyencedb voyence' 

3. Provide Database password when prompted. 
4. Run the following sql commands
   1. To unlock the account without password change:

      update cm_user set login_attempts_remaining=3, enabled='t' where user_name='sysadmin';

       
   2. To rest account with default password:
      

      update cm_user set enabled='t', login_attempts_remaining=3, password='SKNltM4eMipVrpAX89rwwA==' where user_name='sysadmin';

                   This will reset password to default, login to NCM with default username and password. Change password if needed as per the requirement. 

Additional Information

Refer to Cannot connect to the Smarts NCM database because the password is unknown if DB password is not known/forgotten.