Configuring Database

Configuring Database

In GUI Setups

Configuring Database Server

SupportCenter Plus is bundled with PostgreSQL database. You can also configure the application to set up MS SQL database.  

PostgreSQL

    1. Go to <SupportCenter_Plus_Home>\bin directory in the command prompt and execute the changeDBServer.bat [changeDBServer.sh  for Linux] file.

    2. This opens the Database Setup Wizard page. Fill in the following details to configure the server.

  • Server Type: Select PostgresSQL server type from the dropdown. Say PostgreSQL and MS SQL.

  • Host Name:  The IP Address/hostname in which the database is available. The default hostname is 'localhost'.

  • Port:  The default port value is 65432.

  • Database:  The default database name is supportcenter (can be changed as required).

  • Username: Provide username (default username is scpadmin).

  • Password: Enter password (default password is scp@123).

3. Check the availability of the connection by clicking the Test button. A pop-up window showing 'Connection Established' message appears.

4. Click OK to proceed.

5. Finally, click Save.

MS SQL 

    1. Go to <SupportCenter_Plus_Home>\bin directory in the command prompt and execute the changeDBServer.bat [changeDBServer.sh for Linux] file.

    2. This opens the Database Setup Wizard. Fill in the following details to configure the database server.

  • Server Type: Select the server type from the combo box. (MS SQL)

  • Host Name: Enter the IP Address/ hostname in which the database is available. The default hostname is 'localhost'.

  • Port: Specify the Port. The default port is 65432 (can be changed as required).

  • Database: The default database name is supportcenter (can be changed as required).

  • Username: Provide username (default username is scpadmin).

  • Password: Enter password (default password is scp@123).

  • Master Key Password:  Enter a Master Key password to encrypt the SCHAR columns in the database. Master Key password will be asked only during the creation of a database.

3. Check the availability of the connection by clicking the Test button. A pop-up window showing 'Connection Established' message appears.

4. Click OK to proceed.

5. Finally, click Save.

Only admin users can create a master key and it is not stored anywhere.

Non-GUI Setups 

In Windows

Run the changeDBServer.bat [changeDBServer.sh for Linux] under command prompt by passing the parameter as given below. 

<SupportCenter_Plus_Home>\bin>changeDBServer.bat --console  

Connect to PostgreSQL Server

    1. Go to <SupportCenter_Plus_Home]> \ pgsql \ bin in the command prompt.
    c:\> cd ManageEngine\SupporCenterPlus\pgsql\bin

    2. Enter the command: 

    psql -h localhost -U scpadmin -p 65432 -d supportcenter
    Enter the password when prompter. The default password is scp@123

Here, 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 MS SQL Server

Use SQL studio to connect to MS SQL database
Default Database name: supportcenter

In Linux

Connect to PostgreSQL Server in Linux

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

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

    4. Enter the command: # ./psql -U scpadmin -h localhost -p 65432 supportcenter

Troubleshooting Tips 

PostgreSQL Connection Resolution

Verify the following.

    1. Check if PostgreSQL server is running.

    2. Check if the server name or the port number is misspelled or incorrect.

    3. If there is a firewall blocking the port on the server, then you will not be able to connect to the server. To confirm the firewall block connect to TCP/IP use \"telnet<server_host><port number>\"\n to confirm the block. 

    4. If none of the above-mentioned issues matches then contact your system administrator.

MS SQL Connection Resolution 

If a connection is refused and an exception is thrown by SQL Server as 'Unable to connect the server, then the reason for this could be any of the following.

    1. The server name is misspelled or the port number is incorrect.

    2. The SQL server was not configured to use TCP/IP. In this case, enable TCP/IP from SQL servers network utility application.

    3. If there is a firewall blocking the port 65432 on the server, then you will not be able to connect to the server. To confirm the firewall block connect to TCP/IP use \"telnet<server_host>65432\"\n to confirm the block.

If none of the above-mentioned issues matches then contact your system administrator.

    • Related Articles

    • Database Migration Tool

      You can use this tool to migrate data between two databases (Postgres to MSSQL and vice versa) as well as between operating systems (Linux to Windows and vice versa). You can perform the following data migration with this tool: Server migration ...

    • Database Migration

      Migration between Postgres and Microsoft SQL SupportCenter Plus comes bundled with Postgres. From build 14000, the database files generated from the scheduled backup are no longer cross-compatible. However, you can migrate between Postgres and ...

    • Configuring ADFS 3.0 as the Identity Provider

      Before you start the configuration process, make sure that the SupportCenter Plus application is running in the HTTPS mode. Then, configure SupportCenter Plus as a Relying Party Trust (RPT). This can be done either manually or using the metadata ...

    • Database Error Codes and Troubleshooting

      The following table provides common database errors and corresponding troubleshooting tips. Error ID   Error Root cause and troubleshooting steps 1000 ERROR_WHILE_GETTING_CONNECTION Root cause: Connection could not be established with the MSSQL ...

    • Configuring OneLogin as Identity Provider

        Log in your OneLogin domain and click Applications under the Applications tab.     In the displayed page, click Add App.     Search for SAML from the search box and select SAML Test Connector (Advanced) from the search results.       Provide a Name ...