DX Platform - 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?

Cause

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

Environment

DX Operational Intelligence 1.3.x, 20.x +
DX Application Performance Management 11.x, 20.x+
DX AXA 20.x

Resolution

a) Check postgres pod is running:

kubetcl get pods -n<namespace> | grep postgres

# kubectl get pods -ndxi |grep post
dxi-postgresql-868749c9fb-hnjlx                        1/1       Running     0          31d

b) Establish an interactive session to the pod

kubetcl exex -it <dxi-postgresql-pod> bash -n<namespace> 

# kubectl exec -it dxi-postgresql-868749c9fb-hnjlx 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 master1234!

 

UPDATE aradminbasicauthuser
SET strikecount = 0,
    password = '1:ntR6wYamw5OD7lE2MAZjrjACgx09qYcCMEW5yfnzSv4=:ZZAqaVZ0RZ8JWilVGcdRfxaltqAXtGnssj748TMPW+g=',
    passwdresettime = now() AT TIME ZONE 'UTC'
WHERE
    userid = 'MASTERADMIN'AND
    orgname = 'MASTERADMIN';

 

it should respond

 

UPDATE 1

Additional Information

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