Skip to content
CA Service Operations Insight - 4.0 CU1, SP2
Documentation powered by DocOps

How to Change the SA Store Connection Password

Last update June 10, 2016

Contents

As an administrator, you can change the connection password for the SA Store database in CA SOI. You change this password on the SA Manager server. Complete the following process to change the SA Store connection password in all necessary areas:

Use this scenario to guide you through the process:

Change the SA Store Connection Password

  1. Files" class="conf-macro output-inline" data-hasbody="true" data-macro-name="sp-plaintextbody-link">Change the SA Store connection password in all CA Catalyst files.
  2. Files" class="conf-macro output-inline" data-hasbody="true" data-macro-name="sp-plaintextbody-link">Change the SA Store connection password in all CA SOI files.

Change the SA Store Connection Password in all CA Catalyst Files

You must change the SA Store connection password in all CA Catalyst files using the ComponentsUsingtheEncrypterUtility" class="conf-macro output-inline" data-hasbody="true" data-macro-name="sp-plaintextbody-link">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 a 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:
    • restserver.xml
    • sorapp.xml
    • ssaserver.xml
    • 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. 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>
    • Cipher-text.properties 

      UserManager.Configuration.Property.password=encrypted password
      ...
      wso2registry.wso2registry.password=encrypted password

    The password is changed in all CA Catalyst files.
  6. Start the CA SAM Application Server service.
    The Registry reconnects to all product components using the new password.

  7. Run registryloader.bat 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.
    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 8.

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

Change the SA Store Connection Password in all CA SOI Files

Change the SA Store connection password in all CA SOI files using the EncryptSAMCreds.bat utility.

Follow these steps:

  1. Shut down the CA SAM Application Server and CA SAM User Interface Server services on the SA Manager system.
  2. Open a command prompt, navigate to <SOI_HOME>\Tools, and run the following command:

    EncryptSAMCreds <old password> <new password> Database
    

    Use the word 'Database' as written in the command syntax, not the database name.


    This command updates the database password in all necessary configuration files on the SA Manager system.

  3. Copy the <SOI_HOME>\tomcat\lib\hibernate.cfg.xml file on the SA Manager to <tomcat_path>\webapps\SpectrumSA on the report server, remove the <!DOCTYPE...> element at the top of the file, and save and close the file.

    Note: tomcat_path refers to the default BusinessObjects Tomcat installation directory of C:\Program Files\CA\SC\CommonReporting3\Tomcat55.
  4. Select Start, Programs, BusinessObjects XI 3.x, BusinessObjects Enterprise, Central Configuration Manager.
  5. Select Apache Tomcat and Server Intelligence Agent, click Stop, and then click Start when the services stop.
    The database password is changed on the report server.
  6. Access the Control Panel on the report server and double-click Administrative Tools, then Data Sources (ODBC).
  7. Click the System DSN tab, select SAMStore, and click Configure.
  8. Click Next, enter the new password in the Password field, and click Next again.
    The connection is verified with the new password.
  9. Click Finish.
  10. Open the <SOI_HOME>\Reports\samreports.xml file on the report server, enter the new password in the <password> attribute, and save and close the file.
    Future report redeployments will use the new database connection password.
  11. Start the CA SAM Application Server and CA SAM User Interface Server services.
    The password change takes effect.
Was this helpful?

Please log in to post comments.