Database Configurations

---

• Configure the Database

  • Configuring PostgreSQL Server

  • Configuring MS SQL Server

  • Configuring MY SQL Server

• Non GUI Users

• Connect to PostgreSQL Server

• Troubleshooting Tips

---

 

Configure the Database

SupportCenter Plus supports PostgreSQL database, by default.To switch over to SQL database you need to configure SQL server to establish connection and start the server.

 

Configuring PostgreSQL Server

1. Go to <SupportCenter>\bin directory from the command prompt. Execute the changeDBServer.bat [changeDBServer.sh  for Linux] file.

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

   • Server Type: Select the server type from the combo box. Say PostgreSQL, MS SQL, and MY SQL.

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

   • Port:  The default port value is 1433.

• Database:  The database name is supportcenter in non-editable format, by default.

• User Name: The user name to login to the server.

• Password: The password for the username provided.

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

4. Click OK to proceed.

5. Click Save button to save the SQL server settings.

 

Configuring MSSQL Server

If you are using a remote MSSQL server and do not wish to use the in-built server then,

1. Select Server Type as MSSQL server. This opens the database wizard page.

2. Specify the Host Name, Port, User Name & Password.

3. Click Test button and check the availability of the connection.

4. Once the connection is established,Save the details and start the server.  

Configuring MY SQL Server

If you are using MY SQL server,

1. Select Server Type as MY SQL server. This opens the database wizard page.

2. Specify the Host Name, Port, User Name & Password.

3. Click Test button and check the availability of the connection.

4. Once the connection is established,Save the details and start the server.

 

Non GUI Users

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

 

C:\[SupportCenter Plus Home]\bin>changeDBServer.bat --console

 

It will get the DB Server necessary information from the console.

 

Connect to PostgreSQL Server

SupportCenter Plus uses PostgreSQL as its default database.

 

Connect to PostgreSQL Server in Windows

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

C:\> cd ManageEngine\SupporCenter\pgsql\bin

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

 

Troubleshooting Tips

 

PostgreSQL Connection Resolution

Verify the following,

• Check if PostgreSQL server is running.

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

• If PostgreSQL server is running in a remote machine then there may be a firewall blocking the port number you have entered.

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

MY SQL Connection Resolution

Verify the following,

• Check if MY SQL server is running.

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

• If MY SQL server is running in a remote machine then there may be a firewall blocking the port number you have entered.

• 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,

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

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

• If there is a firewall blocking the port 1433 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>1433\"\n to confirm the block.

• You can connect to SQL Server named instantly if you know the machine name and port number.  

• Create new user with full privileges as shown below,

• While configuring SQL server properties select the authentication type as SQL server as shown below. Windows authentication is not supported by SupportCenter currently.