search cancel

AIOps - How to change the default password expiration policy of 180 days?

book

Article ID: 226240

calendar_today

Updated On:

Products

DX Operational Intelligence DX Application Performance Management CA App Experience Analytics

Issue/Introduction

How to set a longer password lifecycle for the "masteradmin" password? 

Cause

By default password expires after 180 days

How to check this value?

If you are using DX Platform 20.x

a) obtain the postgres pod name

kubectl get pods -n<namespace> | grep postgres

b) exec postgres pod

kubectl exec -it <postgres-pod> -n<namespace> bash


1) connect to aoplatform database

psql -U aopuser -d aoplatform

2) Check default validity Period as below

select * from aradminpwdpolicy ;

orgname         | minpasswordlength | maxpasswordlength | minnumericchars | minalphachars | minspecialchars | strikecount | allowedsplchars | isglobal | validityperiod |
 passwordhistcount | isallowall
------------------------+-------------------+-------------------+-----------------+---------------+-----------------+-------------+-----------------+----------+----------------+
-------------------+------------
 --globalorganization-- |                 6 |                25 |               1 |             4 |               1 |           5 | [email protected]#$%^&*()_+    | Y        |            180 |
                 3 | N
 MASTERADMIN            |                 6 |                25 |               1 |             4 |               1 |           5 | [email protected]#$%^&*()_+    | N        |              0 |
                 3 | N
 DEFAULTORG             |                 6 |                25 |               1 |             4 |               1 |           5 | [email protected]#$%^&*()_+    | N        |              0 |
                 3 | N

Environment

AXA 17.3.x

DX Platform 20.x, 21.x

Resolution

1) connect to aoplatform database
psql -U aopuser -d aoplatform
 
2) Execute:
UPDATE aradminpwdpolicy SET validityperiod = <# of days>;
 
for example:
UPDATE aradminpwdpolicy SET validityperiod = 365;
 
3) Verify the changes:
 
select * from aradminpwdpolicy ;

Additional Information

https://knowledge.broadcom.com/external/article/190815/dx-aiops-troubleshooting-common-issues-a.html