Configure the Database

 



 

Configure the Database

By default ServiceDesk Plus - MSP supports PostgreSQL database, to switch over to SQL database, you need to configure SQL server credentials to establish connection and start the server.

 

Configuring PostgreSQL Server

  1. Execute the changeDBServer.bat [changeDBServer.sh for Linux] file presented under the ServiceDesk Plus - MSP Home. This opens the Database Setup Wizard page. Fill in the details of the form to configure SQL server.

  1. To check the availability of connection, click the Test button. A pop up window pops up showing 'Connection Established' message.

  2. Click OK to proceed.

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

 

Configuring MSSQL Server

  1. If you are using a remote MSSql server and do not want to use the inbuilt server then,

  2. Select Server Type as MSSql server. This opens the database wizard page.

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

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

  5. Once the connections are established, save the details and start the server.  

 

Configuring MYSQL Server

  1. If you are using a remote MySql server and do not want to use the inbuilt server then,

  2. Select Server Type as MySql server. This opens the database wizard page.

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

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

  5. Once the connections are 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:\[ServiceDesk Plus - MSP Home]\bin>changeDBServer.bat --console

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

 

Connect to PostgreSQL Server

ServiceDesk Plus - MSP uses PostgreSQL as its default database.

 

Connect to PostgreSQL Server in Windows

  1. Go to [ServiceDesk Plus - MSP Home] \ pgsql \ bin in the command prompt.

C:\> cd ManageEngine\ServiceDeskPlus - MSP\pgsql\bin

  1. Enter the command: pgsql.exe -U postgres -p 65432 -w servicedesk

C:\> cd ManageEngine\ServiceDeskPlus - MSP\pgsql\bin> psql.exe -U postgres -p 65432 -w servicedesk

ServiceDesk is the name of the database. 65432 is the port on which ServiceDesk Plus - MSP database runs. ServiceDesk Plus - MSP uses root 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, mysql 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 [ServiceDesk Plus - MSP Home] \ pgsql \ bin in the command prompt.

# cd [ServiceDesk Plus - MSP Home]/pgsql/bin

  1. Enter the command: pgsql.exe -U postgres -h localhost -p 65432 servicedesk

Connect to MY SQL Server

ServiceDesk Plus - MSP uses MYSQL as its default database.

 

Connect to MYSQL Server in Windows

  1. Go to [ServiceDesk Plus - MSP Home] \ mysql \ bin in the command prompt.

C:\> cd ManageEngine\ServiceDeskPlus - MSP\mysql\bin

  1. Enter the command: mysql.exe -u root -P 33366 servicedesk

C:\> cd ManageEngine\ServiceDeskPlus - MSP\mysql\bin> mysql.exe -u root -P 33366 servicedesk

ServiceDesk is the name of the database. 33366 is the port on which ServiceDesk Plus - MSP database runs. ServiceDesk Plus - MSP uses root account to connect to the database and does not use any password. You can connect to MYSQL database only from the server console.

 

Connect to MYSQL Server in Linux

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

  2. Once this is accomplished, make sure that the command "mysql" is in path. (Most often, mysql should be under path, if not, you may add the complete path to mysql command under PATH variable in the bashrc file.

  3. Go to [ServiceDesk Plus - MSP Home] \ mysql \ bin in the command prompt.

# cd [ServiceDesk Plus - MSP Home]/mysql/bin

  1. Enter the command: # mysql -u root -S ../tmp/mysql.sock servicedesk A

 

Troubleshooting Tips

 

PostgreSQL Connection Resolution

Verify the following,

MY SQL Connection Resolution

Verify the following,

MS SQL Connection Resolution

If a connection is refused and an exception is thrown by SQL Server as 'unable to connect the server' then there could be following reasons why this could happen such as,

 

ServiceDesk Plus - MSP - Help Desk and Asset Management Software

Copyright © 2012, ZOHO Corp. All Rights Reserved.
ManageEngine