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".
New to ADSelfService Plus?
Related Articles
How to Connect External Postgres
To install an external PostgreSQL server, ensure the PostgreSQL version matches the inbuilt PostgreSQL version series of the ServiceDesk Plus application. For example: If ServiceDesk Plus version is 14010 with PostgreSQL version 10.21, install an ...How to Change default password on PGSQL database
Please do follow the below steps which would assist you in changing the default Postgres password. 1. Stop the application services. 2. Please take a trimmed backup <OR> take a Snapshot of the Server 3. Open Command Prompt with Admin Privileges ...Error While connecting default Postgres Database
If you are getting the below error while connecting the postgresDB , please follow the steps below : Error : psql: FATAL: no pg_hba.conf entry for host “::1”, user “postgres”, database “servicedesk”,SSL off Please open pg_hba.conf under [ServiceDesk ...Remote read only access to database for Postgres customers
Frequently customers want to connect some reporting / dashboard application like PowerBI or Tableau with our Postgres database server. By default, the bundled Postgres is configured to only listen to the local machine. We can configure to allow ...How to reset database users' Password in bundled Postgres?
We have built several database users in our product with bundled postgres, including "rouser," a read-only account used to configure the external reporting tool, "sdpadmin," who handles database activities integrated with our product, and "postgres," ...