The latest release of ManageEngine ServiceDesk Plus MSP changes the default user and password of the Postgres SQL database.
Previously, the command to connect to the database was:
psql -U postgres -p 65432 -d servicedesk -h 127.0.0.1
The new change shows that there is a change in username and password as follows:
psql -U sdpadmin -p 65432 -d servicedesk -h 127.0.0.1
Username: sdpadmin
Password: sdp@123
ServiceDesk Plus MSP build 14620 and above
The default PostgreSQL database password will now be auto-generated for sdpadmin.
The auto-generated password can be retrieved by invoking the following script:
- Windows:
decryptPostgresPassword.bat - Linux:
decryptPostgresPassword.sh
When and how will the password be auto-generated?
- For existing setups, the password will be auto-generated during migration only if the default password was not updated previously.
- For fresh setups, the default password will be auto-generated when the server is started for the first time.
- For setups that switch to PostgreSQL database after migrating to 14620 or later, the database password will be auto-generated while executing changeDBServer.bat/.sh script.
The PostgreSQL password for sdpadmin cannot be retrieved after the database configuration is updated from bundled Postgres to external Postgres/MSSQL. Therefore, ensure the password is retrieved and stored in a secure location for future use. If the sdpadmin password is reset to the default password, the application will fail to start.