Remedy Single Sign On - How to Reset Database user password in RSSO configuration files

Version 10
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Remedy Single Sign On


    COMPONENT:

    Remedy Single Sign On


    APPLIES TO:

    RSSO 9.1x and above



    QUESTION:

    We have changed the DB password of the RSSO database user; how can we encrypt the password and modify the RSSO configuration so this new password is used?


    ANSWER:

     

    The following doc was supplied to them but they didn't want to determine a new encryption key.
    https://docs.bmc.com/docs/display/rsso91/Configuring+after+installation

    You must change the encryption key after upgrading BMC Remedy SSO and use it to encrypt the database password again. Perform the following steps to change the encrypt key and re-encrypt the password.

      
       
    1. Determine the new encryption key.

    2.  
    3. Run the following command to obtain a new password for the database user.

          
           
            
             
                                                                       
                  
                   

      java -jar rsso-ds-<RSSO_version>.jar <password> <new-key>

                   

      where,

                   

      * <password>: Is the unencrypted password of the database user.

                   

      * <new-key>: Is the new encryption key.

                   

      * rsso-ds-<RSSO_Version>.jar: Can be found in the <tomcat>/webapps/rsso/WEB-INF/lib folder.

                  
             
            
           
          
    4.  
    5. For each BMC Remedy SSO server in the cluster, perform the following steps:

           
           
      1. Modify the rsso.key file in the <tomcat>/webapps/rsso/WEB-INF/classes folder.

      2.    
      3. Change existing line key=<old-key> to key.old=<old-key>, where <old-key> is the current key in rsso.key file.

      4.    
      5. Add a new line key=<new-key>, where <new-key> is the new key to be applied.

      6.    
      7. Modify the context.xml file in <tomcat>/webapps/rsso/META-INF folder.

      8.    
      9. Update the password field as password="AES:<encrypted-password>", where <encrypted-password> is the encrypted password obtained in Step 2.

      10.   
    6.  
    7. Log in to the Admin console of BMC Remedy SSO.

    8.  
    9. On the General tab, click Save without making any change.

    10.  
    11. Click the Realm tab.

    12.  
    13. Edit each realm and click Save without making any change.

    14.  
    15. For each BMC Remedy SSO server, remove the old encryption key from the rsso.key file in the <tomcat>/webapps/rsso/WEB-INF/classes folder.

      

    Note that there is no need to restart the BMC Remedy SSO server after you change the encryption key.

    When RSSO is installed where the installation creates the RSSO DB and user a file name rsso.key gets created under <tomcat>/webapps/rsso/WEB-INF/classes
    However as the customer installed RSSO with a pre-created DB and user this file didn't get created.
    The key in this file is the same for all OOTB RSSO 9.1 installations and is this value: !esrevinUehTssorcA
    This key can be used if the customer doesn't want to determine a new encryption key.

      

    Once the new password has been encrypted follow the docs to add this to the configuration for RSSO.
    RSSO should now be able to connect to the database successfully.

    Note: using Linux OS you may need to add single quotes around the new password and encryption key for the command to run successfully:
    java -jar rsso-ds-<version>.jar 'newpassword' 'encryptionstring'

     

     


    Article Number:

    000123942


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles