ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

How to reconfigure TDM Portal to use a new password for GTREP 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 : 4.8+

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 https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-9/administrating/use-the-encryption-utility-to-encrypt-passwords.html

Attachments