Changing the App Visibility database password

The App Visibility portal and App Visibility collector each include an App Visibility database, which is a PostgreSQL database that uses trust authentication. This authentication assumes that anyone who can access the App Visibility portal or collector computers is authorized to access the database.

If you want to change the authentication method to password authentication for one or more databases, refer to the PostgreSQL documentation. With password authentication, the password is required when you want to backup, restore, and perform other maintenance tasks on the database.

If your environment is set for high availability and you want to use password authentication, you must change the password on the both the active and standby components.

Related topics

Changing-App-Visibility-portal-settings

Changing-App-Visibility-collector-settings

Applying-private-certificates-to-App-Visibility-components

Backing-up-and-recovering-the-App-Visibility-database

This topic presents the following sections:

Before you begin

Change the PostgreSQL database authentication method to password authentication. For details, refer to PostgreSQL documentation. 

To change the App Visibility database password

After you change the authentication method to password authentication (instead of the default trust authentication) for one or more databases, you must change the database password for the App Visibility component.

  1. At a command line on the App Visibility server, navigate to the following directory:

    • Windows
      installationDirectory\portal\bin\db
      or
      installationDirectory\collector\bin\db
      The default installationDirectory is C:\Program Files\BMC Software\App Visibility
    • Linux
      installationDirectory/portal/bin/db
      or
      installationDirectory/collector/bin/db
      The default installationDirectory is /opt/bmc/App_Visibility

    Note

    If the App Visibility portal and the App Visibility collector are installed on the same host, they use the same database. You only need to change it in one place and the change affects both components.


  2. Enter the following command:
    • Windows
      change-db-pgsql-password.bat
    • Linux
      change-db-pgsql-password.sh
  3. At the  Enter current password  prompt, enter the current password.
    The default password is avpsql.
  4. At the  Enter new password  prompt, enter a new password, using a strong password that comprises the following:
    • A minimum of 10 characters
    • Two of the following nonalphabetic characters that are noncontiguous:
      0 1 2 3 4 5 6 7 8 9 ~ ! @ # $ % ^ & * ( ) _ + - =
  5. At the  Confirm new password  prompt, enter the new password again.
    The new password is set.
  6. Restart the component service.

To change the App Visibility database password in a high-availability environment

If your environment is set for high availability (HA) and you configured your databases to use password authentication (instead of the default trust authentication), you must change the password on the both the active and standby components.

  1. On the active node, change the App Visibility database password as describe in the earlier procedure, To change the App Visibility database password.
  2. On the active node, open the component properties file:
    • Windows
       portal.properties, located in installationDirectory\portal\properties
      or
      collector.properties, located in installationDirectory\collector\properties
    • Linux
      portal.properties, located in installationDirectory/portal/properties
      or
      collector.properties, located in installationDirectory/collector/properties
  3. Copy the encrypted value of the database.password.enc property and close the file.
  4. On the standby node, open the corresponding file and overwrite the copied value of the database.password.enc property.
  5. Save the file and restart the component service.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*