OpenText product name changes coming to the community soon! Learn more.

Wikis - Page

[NA support tip] How to connect to a different NA database ?

1 Likes

If the NA database has been moved to a different server, use the tc_tools utility to configure NA to connect to the new database location. This location must include a valid NA database.

The tc_tools utility updates the following information on the NA server:

  • Database server name
  • Database port
  • Database name
  • Database username
  • Database user password


To connect NA to a different NA database, follow these steps:

  1. At a command prompt, run the following command:
    • Windows<installdir>\client\tc_tools.bat
    • Linux<installdir>/client/tc_tools.sh
  2. Type 1 to change the database connection information.
  3. At each prompt, do one of the following:
    • Type the new value for the prompt.
    • Press Enter to retain the value between the brackets ([ ]).
  4. From the tc_tools prompt, exit the utility.
  5. Restart the NA management engine.

Secure NA credentials

The credentials for accessing the NA database are stored in the a.da file. By default, NA encrypts the a.da file using TripleDES. To ensure stronger encryption, you can change the algorithm for the file to AES256. To achieve this, follow these steps:

  1. Stop all NA services on all NA cores.

  2. On each NA core, add the following line to the adjustable_options.rcx file:

    <option name="database/credentials/useAES256Encryption">true</option>

  3. Back up the <NA_HOME>/a.da file to a location outside the NA directory structure.

  4. Edit the a.da file as follows:

    1. Locate the line that starts with the U= string.

    2. Edit that line to delete all the characters after the equals sign (=).
    3. Locate the line that starts with the S= string.
    4. Edit that line to delete all the characters after the equals sign (=).
  5. Verify that the resulting a.da file is similar to the following example:

    ##generated, do not edit this file

    #Wed Jul 25 14:15:15 MDT 2012

    U=

    S=

This process removes the NA database credentials from the a.da file. This results in NA unable to connect to the NA database. You must reconfigure NA to connect to the database location by using the tc_tools utility.

Labels:

Support Tips/Knowledge Docs
Comment List
Related
Recommended