search cancel

Change the database password for Identity Access Manager (IAM)

book

Article ID: 76553

calendar_today

Updated On:

Products

CA Application Test CA Continuous Application Insight (PathFinder) Service Virtualization

Issue/Introduction

How do I change the database password for IdentityAccessManager? 


Steps followed:
Configure DevTest for MySQL  

Configure VS Catalog and Identity Manager & Access Manager for MySQL

It will update the Datasource.properties file as seen below 

#Updated by DatasourceUpdater 
#Wed Apr 04 14:24:31 EDT 2018 
JDBC_DRIVER_CLASS=com.mysql.jdbc.Driver 
DATABASE_URL=jdbc\:mysql\://abrsh01N218001\:3306/vscatalog?useSSL\=false 
JDBC_DRIVER_PATH=C\:\\Program Files\\CA\\DevTest\\lib\\shared\\mysql-connector-java-5.1.25-bin.jar 
DATABASE_PASSWORD=26bcec2e2005094f 
DATABASE_USER=devtest 
JDBC_DRIVER_NAME=mysql 
JDBC_DRIVER_MODULE_NAME=com.mysql.jdbc.driver

The password field is encrypted.  

Do we need to run the installer again to update this file every 6 months?  

Cause

N/A

Environment

All supported DevTest releases.

Resolution

The user can run DatasourceUpdater utility in <INSTALL_DIR>/IdentityAccessManager/bin/   to update the password.
As this utility can also be used for changing the database used by IAM, it will prompt for the database details.

The password can also be changed in the IAM_HOME/iam.properties file.