CIS Repository Password Change

CIS Repository Password Change

book

Article ID: KB0080609

calendar_today

Updated On:

Products Versions
TIBCO Spotfire Advanced Data Services 6.2.X

Description

This KB describes how to reconfigure the Cisco Information Server (CIS) so that it uses a new password in order to access its repository database (DB).

Issue/Introduction

This KB describes how to reconfigure the Cisco Information Server (CIS) so that it uses a new password in order to access its repository database (DB).

Environment

Product: TIBCO Spotfire Advanced Data Services Version: 6.2.x OS:All Supported Operating Systems --------------------

Resolution

Complete these steps in order to reconfigure CIS so that it uses the new password to access its repository database:

  1. Change the password for the corresponding user. 

    Here is an example:  
     
    mysql> update user set password=PASSWORD('<PASSWORD_IN_CLEAR_TEXT>') where user='cs060205';
    mysql> commit;
    mysql> flush privileges

     
  2. Make a backup of the server_values.xml file located in <CIS_INSTALL>/conf/server.
     
  3. Export the repository configuration file and save it into repo.properties
     
    repo_util.bat -exportConfig > repo.properties

     
  4. Open the server_values.xml file and locate these lines: 
     
    <common:attribute>
    
        <common:name>/server/config/database/databasePassword</common:name>
    
        <common:type>PASSWORD_STRING</common:type>
    
        <common:value>Encrypted:3C69A34C292CE89B</common:value>

     
  5. Replace the encrypted value with the new unencrypted password.  

    Here is an example:
     
    <common:attribute>
    
        <common:name>/server/config/database/databasePassword</common:name>
    
        <common:type>PASSWORD_STRING</common:type>
    
    <common:value>myNewPassword</common:value>

     
  6. Modify repo.properties with a clear text password, which was set in Step 5.

    For more information, refer to Sample repo.properties File .
     
  7. Run repo_util.bat/.sh in order to load new repo.properties.

    Here is an example:
     
    repo_util.bat -updateConfig -configFile repo.properties
    repo_util -listConfig

     
  8. Restart the Composite Server service.

Additional Information

External: CIS Repository Password Change