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

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

book

Article ID: 226907

calendar_today

Updated On:

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? 

Environment

Release : All supported releases of TDM

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

Cause

Bad GTREP password.

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.