Find the name of the Data Repository administrator in DX Netops Performance Management
Article ID: 198538
Updated On:
Products
CA Infrastructure Management
CA Performance Management
Network Observability
Issue/Introduction
How to find the name of the Data Repository administrator in DX Netops Performance Management to be able to manage the Vertica database.
Environment
DX Netops Performance Management All Supported Releases.
Resolution
The following are a few ways you can see the OS user (which is also a vertica database user) that is the DR admin on the Data Repository:
1) Look at the running processes:
ps -ef | grep "[v]ertica"
2) On the node the DR was installed on, if it was not removed, under:
/opt/CA/IMDataRepository_vertica9/
There is a file named drinstall.properties
In that file there is an entry:
DbAdminLinuxUser=
This is the name of the OS user used to run the Vertica database.
3) There is another database user used by the Data Aggregator to query the database, but this is not an OS user on the Data Repository
You can find this on the Data Aggregator by running:
grep dbUser /opt/IMDataAggregator/backup/apache-karaf/etc/dbconnection.cfg
Note that your path may vary if you did not install it in the default location.
1) Look at the running processes:
ps -ef | grep "[v]ertica"
2) On the node the DR was installed on, if it was not removed, under:
/opt/CA/IMDataRepository_vertica9/
There is a file named drinstall.properties
In that file there is an entry:
DbAdminLinuxUser=
This is the name of the OS user used to run the Vertica database.
3) There is another database user used by the Data Aggregator to query the database, but this is not an OS user on the Data Repository
You can find this on the Data Aggregator by running:
grep dbUser /opt/IMDataAggregator/backup/apache-karaf/etc/dbconnection.cfg
Note that your path may vary if you did not install it in the default location.
Feedback
Yes
No
Powered by
