cancel
Showing results for 
Search instead for 
Did you mean: 

Steps to change password of database user that is used by PEM for monitoring.

Procedure to change database user password which is used by PEM agent to connect to a monitored server.

 

PEM Agents uses SSL authentication to connect to the PEM repository server and changing the database user password has no affect on connection between PEM agent and the PEM repository server. However, if the database user password that you are changing, is used for monitoring the database server, then also change the password in the database connection properties in PEM. The procedure to do this is described below:

 

PEM uses predefined usernames (agent1, agent2…etc) to connect to the PEM Repository database. See below example of a PEM repository server. User Name: agent1, agent2 are used by the PEM agent to connect to PEM repository Server:

 

Screen Shot 2019-08-28 at 8.52.32 AM.png

 

The logins PEM_ADMIN and PEM_AGENT are the group roles and they are never used for login to PEM database. So, if you change their password, it’s not going to break anything as these are only granted as roles to other users needing access to PEM.

 

Screen Shot 2019-08-28 at 10.09.59 AM.png

 

In order to change the password of a database user:

 

Option#1:  In the pem web client, just right click on the database and select Query Tool. Enter the “ALTER USER <username> password <new password> “ in the query editor and execute it by clicking on flash icon:

 

Screen Shot 2019-08-28 at 8.28.58 AM.png

 

Option#2: Right click on the database user and select properties, then enter the new password in the Definition tab. Hit save after words.

 

Screen Shot 2019-08-28 at 10.17.55 AM.png

 

If this database user is also used for connection to monitored database server by the PEM agent, then in PEM Web client, right click on the monitored server, select properties and enter the new password in PEM Agent tab and hit save button:

 

Screen Shot 2019-08-28 at 8.30.23 AM.pngScreen Shot 2019-08-28 at 8.31.06 AM.png

 

After making the password changes, make sure all agents and databases are showing UP status in the Global Overview Dashboard and the probe log has stopped showing any connection errors after changing the password:

 

Screen Shot 2019-08-28 at 8.35.24 AM.pngScreen Shot 2019-08-28 at 10.37.08 AM.png

 

Version history
Revision #:
1 of 1
Last update:
3 weeks ago
Updated by:
 
Labels (1)
Contributors