Vertica DB user password change in Data Aggregator configuration file for CA Performance Management (CAPM)

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

How to change the password for vertica DB user in dbconnection.cfg file on the Data Aggregator (DA) Server as it is now encrypted ?

Environment

DX NetOps CAPM 20.2 or later

Resolution

Following are the steps to change the vertica DB user password in the file:

/opt/IMDataAggregator/apache-karaf-<VERSION>/etc/dbconnection.cfg

These steps need to be implemented on the Data Aggregator Server.

1. Change directory to /opt/IMDataAggregator/scripts/common.tools.encryption
   
   
2. Run: ./doEncryption.sh dradmin|dauser NEWPASSWORD

3. Replace  password in dbconnection.cfg with new password provided by step 2 doEncryption.sh script .
   
   
4. Login into the Data Repository server 
   
   
5. Login to the DB: /opt/verica/bin/vsql -U dauser -w <old password>


6. Then, at the VSQL command prompt, run:
   
   ALTER USER dauser IDENTIFIED BY 'NEWPASSWORD';

ALTER USER dradmin IDENTIFIED BY 'NEWPASSWORD'
   
    

Additional Information

TechDocs : DX NetOps CAPM 22.2 : Install a Non-Fault-Tolerant Data Aggregator