Changing the OpsCenter database administrator password
The changeDbPassword utility lets you change the password that is used to connect to the OpsCenter database.
OpsCenter uses the Sybase SQL Anywhere to store data.
The database administrator user ID is DBA.
After fresh OpsCenter installation, the database password is set to an auto-generated string. You can change the password using the following procedure.
After OpsCenter upgrade, the database password is set to an auto-generated string, if it is still the default one, which is 'SQL'.
You can change the password using the following procedure.
However, if you had changed the password from the default one in the earlier version, OpsCenter retains that password.
Review the rules for forming a new database password.
The OpsCenter database administrator password has the following constraints:
It should contain 7 or more characters, but should not exceed 30 characters.
It should not contain consecutive black slash characters.
It should not contain any bracket characters.
It should not contain any of the following characters (these characters have special meaning in Windows or in shell scripts):
' ! $ % & . ; ^ | < > , { } $ " ~ [ ] \\
It should not contain the ASCII characters that are less than 32 or greater than 127.
It should not begin with a white space or a single quote character.
It should not end with a white space.
Note:
Information about role-based access in OpsCenter is available.
See User access rights and functions in OpsCenter user interface.
To change the database administrator password on Windows and UNIX
- Enter the following command on Windows:
INSTALL_PATH\OpsCenter\server\bin\changeDbPassword.bat
Enter the following command on UNIX:
<INSTALL_PATH>/SYMCOpsCenterServer/bin/changeDbPassword.sh
- Enter the OpsCenter Administrator's password. OpsCenter Administrator is authorized to change the database password.
- Enter the new password for the database that you want to set.
- Restart the OpsCenter services and processes on Windows and UNIX platforms.
Windows
Enter the following commands to stop and then start the OpsCenter services:
INSTALL_PATH\OpsCenter\server\bin\opsadmin.bat stop
INSTALL_PATH\OpsCenter\server\bin\opsadmin.bat start
UNIX
Enter the following commands to stop and then start the OpsCenter processes:
<INSTALL_PATH>/SYMCOpsCenterServer/bin/opsadmin.sh stop
<INSTALL_PATH>/SYMCOpsCenterServer/bin/opsadmin.sh start