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 forand you want to use password authentication, you must change the password on the both the active and standby components.
This topic presents the following sections:
Before you begin
Change the PostgreSQL database authentication method to password authentication. For details, refer to .
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.
- At a command line on the App Visibility server, navigate to the following directory:
The default installationDirectory is C:\Program Files\BMC Software\App Visibility
The default installationDirectory is /opt/bmc/App_Visibility
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.
- Enter the following command:
- At the
Enter current passwordprompt, enter the current password.
The default password is avpsql.
- At the
Enter new passwordprompt, 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 ~ ! @ # $ % ^ & * ( ) _ + - =
Confirm new passwordprompt, enter the new password again.
The new password is set.
- 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.
- On the active node, change the App Visibility database password as describe in the earlier procedure, To change the App Visibility database password.
- On the active node, open the component properties file:
portal.properties, located in installationDirectory\portal\properties
collector.properties, located in installationDirectory\collector\properties
portal.properties, located in installationDirectory/portal/properties
collector.properties, located in installationDirectory/collector/properties
- Copy the encrypted value of the
database.password.encproperty and close the file.
- On the standby node, open the corresponding file and overwrite the copied value of the
- Save the file and restart the component service.