(Database) Change the SA Store Connection Password in all CA Catalyst Files

Change the SA Store connection password in all the CA Catalyst files using the encrypter.bat utility for the change to occur in the CA Catalyst Registry.

Follow these steps:

1. Stop the CA SAM Application Server service on the SA Manager.
2. Open the command prompt, navigate to SOI_HOME\Tools\CatalystEncrypt on the SA Manager system, and run the following command:

   encrypter <new password>
   

   An encrypted password appears.

3. Open the following files located at SOI_HOME\tomcat\registry\topology\physical\node0\sor, paste the new encrypted password in the listed sections, and save the files:
   1. restserver.xml
   2. sorapp.xml
   3. ssaserver.xml
   4. ssaweb.xml

      <tns:dataSource inj:injID="dbconfig">
      <tns:username>sa</tns:username>
      <tns:password>password</tns:password>
      

4. Open the SOI_HOME\ServiceDiscovery\connectivityContext.xml file, paste the new encrypted password into the password property value in the '<!-- connectivity to the persistence store database -->' and '<!-- connectivity to the SSA database -->' sections, and save and close the file.

   All CA Catalyst configuration files contain the new encrypted password.

5. Start the CA SAM Application Server service from Administrative Tools.
6. Run the registryloader.bat file that is located at SOI_HOME\tomcat\registry. Ignore any "log4j:WARN" messages.

   The Registry loads an updated record of all files in which you changed the password.

7. Restart the CA SAM Application Server service from Administrative Tools

   The Registry reconnects to all product components using the new password.

8. Access the following files located at SOI_HOME\wso2registry\repository\conf directory, paste the new encrypted password into the listed sections, and save the changes:

   registry.xml
   <dbConfig name="wso2registry">
   <userName>sa</userName>
   <password> password</password>
   user-mgt.xml
   <Configuration>
   <Property name="userName">sa</Property>
   <Property name="password">password</Property>
   

   The password is changed in all CA Catalyst files. If the UI Server is installed with the SA Manager, the password change is complete. If you installed the UI Server on a separate system, continue with Step 9.

9. (Standalone UI Server only) Repeat Step 8 in the same files on the UI Server, pasting the encrypted password from the SA Manager.

   The password change is complete in all CA Catalyst files.