Configure TDM Portal to use a new password for GTREP database and/or different database

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

The password used to access GTREP Repository Database has changed, and now no one is able to access the Portal. How do I reconfigure TDM Portal to use the new GTREP password? 

Cause

Bad GTREP password.

Environment

Release : All supported releases of TDM

Component : Repository (GTREP)
                      CA Test Data Manager Web Portal

Resolution

1. Open C:\Program Files\CA\CA Test Data Manager Portal\conf\application.properties in a text editor (like Notepad++)|
   
   
2. Locate the #Database section, and modify the following values as needed:
   

   spring.datasource.url
   spring.datasource.username
   spring.datasource.password
   spring.datasource.driver-class-name

   For example:
   

   spring.datasource.url=jdbc:sqlserver://SQLHOST\\inst1;database=gtrep
   spring.datasource.username=gtrep-user
   spring.datasource.password={cry}A1wzNmnL5E9AIXAC2f4perkhMV-woosh+7r+XVagMawqTk421a
   spring.datasource.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver

3. Since the GTREP password has changed, you will need to modify the 'spring.datasource.password' parameter with the new encrypted password.
4. To encrypt your new password, open a Windows command line.
   
   
5. Navigate to the installation directory for TDM Portal, by default this would be C:\Program Files\CA\CA Test Data Manager Portal\service\bin
   
   
6. Use the 'EncryptionUtil.bat' to encrypt the new GTREP password, by running the following command:
   cmd> EncryptionUtil.bat -p
   
   
7. The utility will prompt you to enter the password to encrypt.
   
   
8. Confirm the password by re-entering the password.
   
   For example:
   
   
   cmd>EncryptionUtil.bat -p

   Enter password: <new_passwod>

   Re-enter password: <new_password>

   Encrypted password: {cry}AAAAEP13ot80EIZAeGosYD7Wao0/rkMRYfo4gI2eubAXw1D
    
9. Copy the encrypted password {cry}AAAAEP13ot80EIZAeGosYD7Wao0/rkMRYfo4gI2eubAXw1D.
   
   
10. Go back to the application.properties file, and paste the encrypted password value for the spring.datasource.password parameter.
    
    For example:
    

    spring.datasource.url=jdbc:sqlserver://SQLHOST\\inst1;database=gtrep
    spring.datasource.username=gtrep-user
    spring.datasource.password={cry}AAAAEP13ot80EIZAeGosYD7Wao0/rkMRYfo4gI2eubAXw1D
    spring.datasource.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver

11. Save the changes to the application.properties file
    
    
12. Restart the CA Test Data Manager Portal service for the changes to take effect.

Additional Information

For more information regarding the Encryption Utility, see section Use the Encryption Utility to Encrypt Passwords in the TDM documentation of the release you are running.