How to Change the SA Store Connection Password in SOI

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

How to Change the SA Store Connection Password in SOI? what are the files need to be updated with the new password?

Resolution

The following files need to be updated with the new encrypted password and there are 2 encryption methods (encrypter and EncryptSAMCreds)
 
Here is the procedure:
 
1) Stop SOI Manager, UI & All connector services
 
2) Generate new encrypted password and update following files on SOI Manager
 
A) Generate new encrypted password "\SOI\Tools\EncryptSAMCreds.bat <new password>" and update below configuration file
 
           \SOI\tomcat\lib\hibernate.cfg.xml

 
B) Generate new encrypted password using "\SOI\Tools\CatalystEncrypt\encrypter.bat <new password>" and update below files with new encrypted string
 

\SOI\tomcat\registry\topology\physical\node0\sor\restserver.xml
\SOI\tomcat\registry\topology\physical\node0\sor\sorapp.xml 
\SOI\tomcat\registry\topology\physical\node0\sor\ssaserver.xml 
\SOI\tomcat\registry\topology\physical\node0\sor\ssaweb.xml 
\SOI\wso2registry\repository\conf\registry.xml
\SOI\wso2registry\repository\conf\user-mgt.xml
\SOI\wso2registry\repository\conf\Cipher-text.properties
\SOI\ME\ServiceDiscovery\connectivityContext.xml

If running 4.2 CU4 or CU5 then add changes with additional file also

 
3) Open a command prompt on SOI Manager, CD to \SOI\tomcat\registry folder and run "registryloader.bat"
 
4) Start manager services in an order as described in below KB article

https://knowledge.broadcom.com/external/article/135251
 

Additional Information

Note: You may refer to the below link for more information about DB user password change procedure 

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/service-operations-insight/4-2/administrating/customization-and-maintenance/installation-maintenance/password-maintenance/how-to-change-the-sa-store-connection-password.html