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 20.2 on premise cluster -  how is this done?

Environment

DX Operational Intelligence 1.3.x, 20.x +
DX Application Performance Management 11.x, 20.x+
DX AXA 20.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 database

bash-4.2$ psql aoplatform
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';

 

it should respond

 

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