ServiceDesk Plus

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

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

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

      • Port: Specify the Port. The default port is 65432.

      • Database: By default the database name will be servicedesk (can be changed to your requirement)

      • User Name: Specify the User Name to login to the server

      • Password: Specify the Password.

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

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

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

      • Port: Specify the Port. The default port is 33366.

      • Database: By default the database name will be servicedesk (can be changed to your requirement)

      • User Name: Specify the User Name to login to the server

      • Password: Specify the Password.

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

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

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

      • Port: Specify the Port. The default port is 1433.

      • Database: By default the database name will be servicedesk (can be changed to your requirement)

      • User Name: Specify the User Name to login to the server

      • Password: Specify the Password.

    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,

      • Check if MY SQL server is running.

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

      • If the 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 there could be following reasons why this could happen such as,

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

      • The SQL server may not be configured to use TCP/IP. In this case, enable TCP/IP from SQL server's 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.

      • SQL Server Instance is not currently supported by ServiceDesk and will be available in the feature release. You can also connect to SQL Server named instance once if you know the machine name and port of the named instance.

      • 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 ServiceDesk Plus currently.

     

     

    Copyright © 2014, ZOHO Corp. All Rights Reserved.