Configure the Database

 



 

Configure the Database

By default ServiceDesk plus supports PostgreSQL database. To switch over to SQL database you need to configure SQL server to establish connection and start the server.

 

Configuring Postgres SQL database

  1. Execute the changeDBServer.bat [changeDBServer.sh for Linux] file presented under the ServiceDesk Home. This opens the Database Setup Wizard page. Fill in the respective server details..

  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 MY SQL database

  1. Execute the changeDBServer.bat [changeDBServer.sh for Linux] file presented under the ServiceDesk Home. This opens the Database Setup Wizard page. Fill in the respective server details..

  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 MS SQL database

  1. Execute the changeDBServer.bat [changeDBServer.sh for Linux] file presented under the ServiceDesk Home. This opens the Database Setup Wizard page. Fill in the respective server details..

  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.

 

Non GUI Users

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

 

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

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

 

Connect to Prostgres SQL Database in Windows

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

  2. cd ManageEngine\ServiceDesk\pgsql\bin

  3. Enter the command: psql.exe -U postgres -p 65432 servicedesk

  4. C:\> cd ManageEngine\ServiceDesk\pgsql\bin> pgsql.exe -U postgres -p 65432 servicedesk


  1. To use ServiceDesk database, use the command: postgres=# \c servicedesk
  2. The prompt will change to:servicedesk=#

 

Connect to MY SQL Database

ServiceDesk Plus uses MYSQL as its default database.

 

Connect to MYSQL Server in Windows

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

C:\> cd ManageEngine\ServiceDesk\mysql\bin

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

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

ServiceDesk is the name of the database. 33366 is the port on which ServiceDesk Plus database runs. ServiceDesk Plus 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 Database 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 Home] \ mysql \ bin in the command prompt.

# cd [ServiceDesk Plus Home]/mysql/bin

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

Troubleshooting Tips

 

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,

 

ServiceDeskPlus - Help Desk and Asset Management Software

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