Smarts NCM: How to reset the retry lockout for the sysadmin user.

Products

• VMware Smart Assurance

Environment

VMware Smart Assurance - NCM

Resolution

If you have locked the database account you can unlock this way:

Login to NCM DB by using the command:
    su - pgdba
 
Now enter this command:
     psql voyencedb voyence

In Windows environment, open a command prompt and navigate here: NCMBase/db/controldb/bin 

Then run this command: psql -p 5435 -h 127.0.0.1 --username=voyence -d voyencedb

After which you'll be prompted to enter the Database password.




Run the following sql commands to unlock the account:

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