How to connect to Database in Version 11.0? PGSQL
1.Open a cmd with admin privileges
2.navigate to ManageEngine\SupportCenterPlus\pgsql\bin and enter the below command:
psql.exe -U scpadmin -p 65432 -h 127.0.0.1 supportcenter
For example:
SupportCenterPlus\pgsql\bin>psql.exe -U scpadmin -p 65432 -h 127.0.0.1 supportcenter
3.Once done, you will be prompted for a password and the default password would be scp@123
Attachment included.
New to ADSelfService Plus?
Related Articles
How to connect to the ServiceDesk database?
For MSSQL database 1. To know the database server information, open command prompt on the server, change the directory to <sdp_home>\bin and invoke the batch file changeDBServer.bat (or changeDBServer.sh) to see the database server information. Note ...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 Connect to SCP Database ? (from 11000 builds)
In-Built POSTGRES (PGSQL) : Open a CMD prompt as an administrator and navigate to ManageEngine\supportcenterplus\pgsql\bin and run the below command 1. If the database is PGSQL (Default database) psql -h localhost -U scpadmin -p 65432 -d ...How to resolve Connectivity issues with Postgresql Database from our product?
Log Traces Feb 20, 2024 6:40:00 PM [SYSERR] [INFO] : java.sql.SQLException: java.lang.Exception: Exception during getConnection from pool Exception occurred during get connection from datasource Nov 15, 2023 1:29:10 PM [SYSERR] [INFO] : Caused by: ...How to connect to DB - 8121
Connect to PostgreSQL Server in Windows: Go to [SupportCenter Plus Home] \ pgsql \ bin in the command prompt. -> C:\> cd ManageEngine\SupportCenter\pgsql\bin Enter the command: psql.exe -U postgres -p 65432 -h 127.0.0.1 supportcenter -> C:\> cd ...