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

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? 

Environment

AXA 17.3.x

DX Platform 20.x, 21.x

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

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