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.
./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:
After restart, passwords are obfuscated and substituted again with#service beswebreports start
""
in the configuration files.