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

book

Article ID: 38245

calendar_today

Updated On:

Products

CA Infrastructure Management CA Infrastructure Management CA Performance Management - Usage and Administration CA Performance Management - Data Polling

Issue/Introduction

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.

 

Question:

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

 

Answer: 

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=dabasepassword

Environment

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