Changing the TrueSight Network Automation database password

This topic provides instructions on changing the TrueSight Network Automation password.

Do the following:

1. Navigate to the TrueSight Network Automation - Data Warehouse installation directory (TSNADW_INSTALL_DIR) and back up the ReportingAndAnalyticsInstalledConfiguration.xml file.
2. Ensure that any ETL run is not in progress.
3. Disable ETL from the Task Scheduler.

4. Run the Maintenance Tool to encrypt the new password.
   You can run the Maintenance Tool in a graphical user interface or from the command line.

    Click here to see the steps to run the Maintenance tool

   To run the Maintenance Tool in a UI for versions 19.11.02 and later

   1. Navigate to the TSNADW_INSTALL_DIR\utility folder.

   2. Run the TsnadwMaintenanceTool.cmd file.

   To run the Maintenance Tool from the command line for versions 19.11.02 and later

   From the TSNADW_INSTALL_DIR\utility folder, run TsnadwMaintenanceTool.cmd with the -silent option.

   To run the Maintenance Tool in a UI for versions 19.11 and 19.11.01

   1. On the computer where you want to install the product, extract the downloaded product files from the BMC Electronic Product Distribution (EPD) site to a temporary directory.
   2. Navigate to the \Disk1\utility folder, and run the TsnadwMaintenanceTool.cmd file.

   To run the Maintenance Tool from the command line for versions 19.11 and 19.11.01

   On the computer where you have extracted the downloaded product files, from the \Disk1\utility folder, run TsnadwMaintenanceTool.cmd with the -silent option.

   To learn about command-line options

   To learn about available command-line options, use the -help or -? option when you run the command.

   For example:

   TsnadwMaintenance.cmd -help

5. Click the Encrypt tab.
6. Select the encryption method depending on the version:
   • (For versions 19.11.02 and later) Encrypt Product Password.
   • (For versions 19.11.01 and 19.11) Encrypt Silent Install Configuration File Password.
7. In the Password and Confirm Password boxes, type your password.
8. Click Encrypt.
   The encrypted password is generated.
9. Navigate to <TSNADW_INSTALL_DIR> and open the ReportingAndAnalyticsInstalledConfiguration.xml file for editing.

10. Search for the TSNA_DATABASE_USER_PASSWORD property and update its value with the password you encrypted in step 8.
    

    <property> 
    <name>TSNA_DATABASE_USER_PASSWORD</name>
    <value><newPassword></value>
    </property>

    Replace <newPassword> with the encrypted password.

11. Connect to the warehouse database and update the new password in the warehouse database using the following command:

    update sites_details set password='<newPassword>' where site_id=<siteID>

    Replace <newPassword> with the encrypted password and <siteID> with the Network Automation site ID.

    Tip

    To obtain the ID for a site, access the sites table in the warehouse database and look for the site_id column.

12. Enable ETL from the Task Scheduler.
13. Run ETL and verify that it is running successfully.