AIOps - Unable to login - How to reset masteradmin password if forgotten

Products

• DX Application Performance Management
• DX Operational Intelligence
• CA App Experience Analytics

Issue/Introduction

I have forgotten the masteradmin password and need to reset it on a DX 2x.x on premise cluster -  how is this done?

Environment

DX Operational Intelligence 2x.x 
DX Application Performance Management 2x.x
DX AXA 2x.x

Cause

The admin passwords are stored in a Postgres database so the update needs directly in the pod running Postgres

Resolution

a) Check postgres pod is running:

kubectl get pods -n<namespace> | grep postgres

# kubectl get pods -ndxi |grep post
dxi-example                        1/1       Running     0          31d

b) Establish an interactive session to the pod

kubectl exec -it <dxi-postgresql-pod> bash -n<namespace> 

# kubectl exec -it dxi-example bash -ndxi
bash-4.2$

 

c) start psql and connect to aoplatform_db database (23.2 and later)

bash-4.2$ psql aoplatform_db
psql (9.6.10)
Type "help" for help.

aoplatform=# 

 

d) run the SQL to reset the master password to <password>

 

UPDATE aradminbasicauthuser
SET strikecount = 0,
    password = '<password>',
    passwdresettime = now() AT TIME ZONE 'UTC'
WHERE
    userid='MASTERADMIN'AND
    orgname='MASTERADMIN';

 

UPDATE 1

NOTE: after you have changed the password and if you would like to set a new and different password, you will need to login as the Masteradmin the reset the password

Additional Information

DX AIOPs - Troubleshooting, Common Issues and Best Practices
https://knowledge.broadcom.com/external/article/190815/dx-oi-troubleshooting-common-issues-and.html