Default Postgres Database password from Builds 14620 and above
For users in ServiceDesk Plus MSP build 14620 and above , the default PostgreSQL database password will now be auto-generated for sdpadmin.
For Builds 14620 and above:
For security reasons, the default Postgres database password will now be randomly generated for sdpadmin. Any external tools that use the default sdpadmin password to connect to the database will be impacted.
Kindly refer to the ReadMe for updates .
How to retrieve the Postgres Database password?
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.
Connecting to ServiceDesk Plus MSP Database through external tools :
To connect to ServiceDesk Plus database through external servers, we highly recommend users to use rouser. For the bundled Postgres database, the default password is "rouser".