How do I reset the 'Superuser' account password?

Document ID : KB000018182
Last Modified Date : 14/02/2018
Show Technical Document Details

Introduction: 

The ‘Superuser’ account is the default admin account that gets installed with Release Automation. The default password of this account is 'suser'.

If the password was changed and you cannot login, you can reset the password to the default password to login temporarily using the procedure outlined in this document.

Environment:  

All versions of CA Release Automation

Instructions: 

  1. Run the following query against the nolio_db database: 

    Select * from users where username='superuser' 
  2. The default password for the 'superuser' account is 'suser' and it should be encrypted with the following value in the query result: 
    '515483996667424e5eae87559fb6f67a'. 
  3. If it was changed and you want to reset it, update the field with the above value using the query below, recycle the Release Automation service and try logging in with the 'superuser' account. 

    update users 
    set password='515483996667424e5eae87559fb6f67a' where username='superuser' 

    Note: The above statements are for Microsoft SQL Server and need to be translated to the syntax used by the appropriate database.

****Important: It is recommended to take a backup of the database before running any update query.