How to connect to DB - 8121

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: 

  1. Install the PostgreSQL client which supports your Linux version.

  2. 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.

  3. Go to [SupportCenter Plus Home] \ pgsql \ bin in the command prompt.

# cd [SupportCenter Plus Home]/pgsql/bin

  1. Enter the command: # ./psql -U postgres -h localhost -p 65432 supportcenter

pgsql-linux

 

      New to ADSelfService Plus?

        Resources

            • Related Articles

            • 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 ...
            • 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 ...
            • 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 ...
            • Query for Support Rep list in DB

              Please run this query to find the list of Support Reps available with login in the system select * from aaauser aaau join sduser sdu on aaau.user_id=sdu.userid inner join helpdeskcrew hd on sdu.userid=hd.technicianid inner join aaalogin aaal on ...