Overview

You need to update the passwords for the database schema users ebms and JMS on an Aurea Process  (formerly known as CX Process, Savvion and SBM) cluster running on WebSphere Application Server.

Prerequisites

• Permissions to update the following files on the Aurea Process server
  • SBM_HOME/cluster/conf/sbm-cluster.xml
  • SBM_HOME/adapters/db/conf/db.properties
  • SBM_HOME/conf/sbmdb.properties
• Permissions to make changes in the WebSphere Administration Console.
• Aurea Process cluster on version 2015 SP1 or newer

Solution

To change the password for the database schema users ebms and JMS, you will need to do the following:

1. Stop all of the Aurea Process servers (SBM, EJB and Portal) in the cluster.
2. You will need to encrypt the password for the database schema user using the encrypt.cmd or encrypt.sh script that is found in the SBM_HOME\bin directory
   
   Windows Example:
   

   C:\AureaProcess\2020R1\bin> encrypt.cmd dbpassword
   the input string = dbpassword
   the encrypted string = /G7HLFe/OD6CeGlYcRXDIQ==   

   Linux Example:
   

   user@linux.server:/aurea/2020R1/bin$ encrypt.sh dbpassword   
   the input string = dbpassword
   the encrypted string = /G7HLFe/OD6CeGlYcRXDIQ==   

3. On each of the Aurea Process servers in the cluster, please update the database password with the encrypted string generated in step 2 for your database in the following configuration files:
   • SBM_HOME/cluster/conf/sbm-cluster.xml
   • SBM_HOME/adapters/db/conf/db.properties
   • SBM_HOME/conf/sbmdb.properties
4. Log in to the WebSphere Administration Console and go to any one of the data sources from Resources > JDBC > Datasources.
5. From the right-side below the Related items section, select JAAS - J2C Authentication data.
6. Click on sbmDatabase/authentication and update the target database's password.
7. Click Save to save the configuration.
8. Start all of the Aurea Process servers in the cluster.