How to find out the current Data Repository?s vertica database admin password?

Products

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

Issue/Introduction

In CA Performance Management, the Data Repository (DR) component uses a Vertica Database to store information about devices and their respective polled data. This DB has its own login/authentication which needs to be used in order to access it.

If a user forgets the admin password for the Vertica database, can it be retrieved?

 

 

Environment

Release: IMDAGG99000-2.5-Infrastructure Management-Data Aggregator
Component:

Resolution

After installing the Vertica database for the Data Repository, if the user has not subsequently changed the admin password, then it will be stored in the following file:

/opt/CA/IMDataRepository_vertica7/drinstall.properties

Open the drinstall.properties file, and search for

DbPwd

The Vertica admin password and database name will be similar to the following example:

# Database name

DbName=drdata

# Database password

DbPwd=dabasepasswor