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 ManageEngine\SupportCenter\pgsql\bin>psql.exe -U postgres -p 65432 -h 127.0.0.1 supportcenter
SupportCenter is the name of the database. 65432 is the port on which SupportCenter Plus database runs. SupportCenter Plus uses postgres account to connect to the database and does not use any password. You can connect to PostgreSQL database only from the server console.
Connect to PostgreSQL Server in Linux:
Install the PostgreSQL client which supports your Linux version.
Once this is accomplished, make sure that the command "psql" is in path. (Most often, psql should be under path, if not, you may add the complete path to psql command under PATH variable in the bashrc file.
Go to [SupportCenter Plus Home] \ pgsql \ bin in the command prompt.
# cd [SupportCenter Plus Home]/pgsql/bin
Enter the command: # ./psql -U postgres -h localhost -p 65432 supportcenter
New to ADSelfService Plus?
Related Articles
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 ...No DB bundled with the application error in the logs while starting from windows services
When not able to start the application from the windows services and it runs in the CMD fine without any issues. After checking the logs you will find the error trace as "NO DB BUNDLED WITH THE APPLICATION". If the database is MSSQL please follow the ...Database migration from MySQL to Postgres/MSSQL in SCP 8.1
We no longer support the use of MYSQL as database in SupportCenter Plus. Hence, we request our users to migrate to Postgres (which is in-built) or Microsoft SQL. Please follow the below steps to carry out the database migration: 1. Shutdown the ...To connect Postgres database from remote PC using PgAdmin tool
Please follow the below steps to connect Postgres database from remote PC using PgAdmin tool. Stop the server and perform the steps. 1. Go to the location C:\\ManageEngine\\SupportCenter\\pgsql\\data, edit the file postgresql.conf and make the below ...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 ...