Changing the database password
How to change 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>]
Note: This procedure on UNIX also updates the database password for Web Reports, if the Web Reports component is installed on the same system where the BigFix server is installed.
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.
If you modify this value, the command restarts all the BigFix server services.
- 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, to change the database password 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.