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

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