DX 20 - How to reset masteradmin password if forgotten

book

Article ID: 206620

calendar_today

Updated On:

Products

CA Application Performance Management Agent (APM / Wily / Introscope)

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

Release : 20.2

Component : DXI

Resolution

get the postgres pod id

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

establish an interactive session to the pod

# kubectl exec -it dxi-postgresql-868749c9fb-hnjlx bash -ndxi
bash-4.2$

start psql and connect to aoplatform database

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

aoplatform=# 


now you can run the SQL to rest the 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