Changing the database password

After you install the database of the BigFix server, you can change its password by running the following command:

On Windows operating systems:

.\BESAdmin.exe -updatepassword -type=<server_db|dsa_db>
[-password=<password>] -sitePvkLocation=<path+license.pvk> 
[-sitePvkPassword=<pvk_password>]

On UNIX operating systems:

./BESAdmin.sh -updatepassword -type=<server_db|dsa_db>
[-password=<password>] -sitePvkLocation=<path+license.pvk> 
[-sitePvkPassword=<pvk_password>]

where:

type=server_db: If you changed the database instance password, specify this value to update the password used by the server to authenticate with the database.
type=dsa_db: If you changed the database instance password on a server of a DSA configuration, specify this value to update the password used in a DSA configuration by remote servers to authenticate with the database.

For example:

./BESAdmin.sh -updatepassword -sitePvkLocation=/mylicenses/license.pvk
-sitePvkPassword=******* -type=server_db

The settings -password and -sitePvkPassword are optional; if they are not specified in the command syntax their value is requested interactively at runtime. The password set by this command is obfuscated.

Changing the database password on UNIX on Web Reports

On UNIX operating systems, the above described procedure does not update the database password for Web Reports. To change it on the local and remote Web Reports server, complete the following steps:

Stop the beswebreports service:
```
service beswebreports stop
```
Open the configuration file: /var/opt/BESWebReportsServer/beswebreports.config
Go to [Software\BigFix\Enterprise Server\FillAggregateDB] and set:
```
Password = "db2newpassword"
```
Start the beswebreports service:
```
#service beswebreports start
```
After restart, passwords are obfuscated and substituted again with "" in the configuration files.