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
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
Use case: 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 ...How to connect to external postgres(external DB)
1. From the postgres installed path navigate to bin folder and open a command prompt 2. Execute the command --> pg_ctl -D "C:\Program Files\PostgreSQL\10\data" start (Postgres server gets started) 3. Connect to DB using the command-->psql -U postgres ...How to Connect to SDP MSP Database ?
1. In-Built POSTGRES (PGSQL) : Open a CMD prompt as an administrator and navigate to ManageEngine\ServiceDeskPlus-MSP\pgsql\bin and run the below command From SDP MSP build 10538 , please use the below method. psql -h localhost -U sdpadmin -p 65432 ...How to reset administrator password in ServiceDesk Plus MSP
Follow the below steps to reset Administrator password for builds more than 10600 (To reset the password for less than 10600. Please contact support. ) 1.Connect to the DB Server. i) For MS-SQL-Connect to the MS-SQL Server ii) For Postgres, go to ...