ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

How to change the MySql password in Performance Management

book

Article ID: 143312

calendar_today

Updated On:

Products

CA Infrastructure Management CA Performance Management - Usage and Administration DX NetOps

Issue/Introduction

How can I change the mySql password on Performance Center (CAPC)?

How can we change the current complex MySql Password in use by the DX NetOps Performance Management Portal database?

 

Cause

Admin user of tool left the company. Company policy requires any passwords the user had access to be changed.

Environment

All supported DX NetOps Performance Management releases

Resolution

There are 2 accounts used in the tool for MySql DB access. The root and netqos users. Their passwords must be the same.

To change the password take these steps. Default paths shown.

  1. Open a new MySql prompt. Enter the current password when prompted.
    1. /opt/CA/MySql/bin -uroot -p
  2. Run the following commands. For each replace new-password with the new password.
  3. Run the following command to validate the users have the same password set. It should show the same encrypted string for all users.
    1. select host,user,authentication_string from mysql.user;
  4. Generate a new encrypted password string.
    1. Go to /opt/CA/PerformanceCenter/Tools
    2. Run:
      1. ./doEncryption.sh encrypt new-password
    3. Record the new encryption string for the next step.
  5. Update the db.password field in the following files:
    1. /opt/CA/PerformanceCenter/PC/webapps/pc/WEB-INF/cfg/portal.console.properties
    2. /opt/CA/PerformanceCenter/DM/webapps/dm/WEB-INF/dm.properties
    3. /opt/CA/PerformanceCenter/EM/webapps/EventManager/WEB-INF/em.properties
    4. /opt/CA/PerformanceCenter/sso/webapps/sso/WEB-INF/sso.properties
  6. Stop the four services:
    1. systemctl stop caperfcenter.console
    2. systemctl stop caperfcenter.devicemanager
    3. systemctl stop caperfcenter.eventmanager
    4. systemctl stop caperfcenter.sso
  7. Start the four services:
    1. systemctl stop caperfcenter.sso
    2. systemctl stop caperfcenter.eventmanager
    3. systemctl stop caperfcenter.devicemanager
    4. Wait 60 seconds.
    5. systemctl stop caperfcenter.console