Updating the database password

If the Oracle or Microsoft SQL Server database password changes, you need to update it in the following files and service on the TrueSight Network Automation application server:

• database.properties file
• catalina.properties file (required only if you are using local authentication)
• (SQL Server only) BCA-Networks Web Server service 

This topic describes how to update the password in various files and services:

• Before you begin
• To update the password in the database.properties file
• To update the password in the catalina.properties file
• To update the password in the BCA-Networks Web Server service
• After you change the password

Before you begin

• You need an administrator password for the Network Automation application server.
• You need to know the new Oracle or SQL Server database password.

To update the password in the database.properties file

1. Depending on the operating system, log on to the Network Automation server as an Administrator or root.
2. Generate an encrypted password

   1. Run the BcanMaintenanceTool utility:

      BCAN_HOME\utility\BcanMaintenanceTool.cmd

   2. On the Encrypt tab, enter the password in the Password and Confirm Password fields.
   3. Select Encrypt Product Password from the list.
   4. Click Encrypt.
   5. Copy the encrypted hexadecimal string to the clipboard.
3. Open the BCAN_DATA\database.properties file in a text editor.
4. Locate the following property: javax.jdo.option.EncryptedConnectionPassword
5. Paste in the hexadecimal string that you generated in step 2.
6. Save the file and close the editor.

To update the password in the catalina.properties file

1. Depending on the operating system, log on to the Network Automation server as an Administrator or root.
2. Generate an encrypted password

   1. Run the BcanMaintenanceTool utility:

      BCAN_HOME\utility\BcanMaintenanceTool.cmd

   2. On the Encrypt tab, enter the password in the Password and Confirm Password fields.
   3. Select Encrypt Product Password from the list.
   4. Click Encrypt.
   5. Copy the encrypted hexadecimal string to the clipboard.
3. Open the BCAN_DATA\catalina.properties file in a text editor.
4. Locate the following property: bna.jdbcRealm.connectionPassword
5. Replace the hexadecimal string with the encrypted password that you generated in step 2.
6. Save the file and close the editor.

To update the password in the BCA-Networks Web Server service

1. Log on to the Network Automation application server as an Administrator.
2. From the Control Panel, navigate to Administrative Tools > Services.
3. Double-click the BCA-Networks Web Server service and click the Log On tab.
4. Choose the This Account option.
5. Enter the Windows user name in the following format: domain\userName.
6. Enter and confirm the new password.
7. Click Apply and then click OK.

After you change the password

After you change the password in the service and files, restart the BCA-Networks Web Server service.