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?
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