How can we change the database password used by the EP Agent that monitors our API gateway?

Article Id: 142238

Status: Published

Updated On: 23-12-2019 07:43

Products:

CA Application Performance Management Agent (APM / Wily / Introscope) , CA Application Performance Management (APM / Wily / Introscope) , INTROSCOPE , DX Application Performance Management

Issue/Introduction:

We have a CA API precision (EP Agent) installation for an on premise environment and we need to change the password of the "gateway" database user.
Could you tell us where to make this change on the agent?

Environment:

Release : 10.5

Component : APM Agents

Resolution:

The EP Agent database monitoring is performed by calling the mysql command from within the provided perl script gatewayOSResource.pl
The authentication for this utility uses the information held in the .my.cnf file is the user's home directory, the default location would be /home/apmusr.
The default values in this file as created by the installation are

[client]
host=localhost
database=ssg
user=gateway
port=3306
password=7layer

To change the password just modify the value in this file