Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Web Help Desk (WHD) > Enable SSL encryption for a MySQL database

Enable SSL encryption for a MySQL database

Overview

This article describes how to download, install, and enable the latest Java™ Database Connectivity (JDBC) driver in Web Help Desk.

Environment

All Web Help Desk versions

Steps

Download and install the JDBC driver

  1. Download the latest JDBC driver from the MySQL™ website
  2. Copy the JDBC driver into one of the following extension directories.
    • Microsoft® Windows®:  \Program Files\WebHelpDesk\bin\jre\lib\ext
    • Apple® OS X:  /Library/Java/Extensions
    • Linux: /usr/local/webhelpdesk/bin/jre/lib/ext
  3. Set the SSL connection for the server.
    See Using Secure Connections on the MySQL website for details. 
  4. Start the database server and enable SSL.

Enable the JDBC driver in a new Web Help Desk installation

  1. Download the Web Help Desk installer.
  2. Log in to the Web Help Desk server as an administrator.
  3. Follow the steps in the Getting Started Wizard.
  4. In the Select your Web Help Desk database window, add the database information. 
    1. Select Use Custom SQL database (advanced).
    2. In the Database Name field, enter:
      whd?ssl=true
  5. Complete the wizard.
    The JDBC driver is enabled. 

Enable the JDBC driver in an existing Web Help Desk installation

  1. Log in to the Web Help Desk server as an administrator.
  2. Navigate to the Web Help Desk home directory.
    • Apple® OS X: /Library/WebHelpDesk 
    • Microsoft® Windows®: \Program Files\WebHelpDesk 
    • Red Hat®/CentOS™/Fedora Linux: /usr/local/webhelpdesk
  3. Open the conf directory. 
  4. Open the .whd.properties file in a text editor (such as Notepad).
  5. Edit the following properties:
    • whd.db.port=3306
    • whd.db.sid=
    • whd.db.customUrl=
    • whd.db.subprotocol=mysql
    • whd.db.password={DES}B/cdbZvGZws\=
    • whd.db.host=<server_name>
    • whd.db.useCustomUrl=NO
    • whd.db.name=whd:encrypt=true #
    • whd.db.username=whd
    • whd.db.embedded=NO
  6. Save and close the file. 
  7. Locate the Portecle application at:
    <WebHelpDesk>/bin/Portecle.jar
  8. Using Portecle, import the appropriate certificates to:
    <WebHelpDesk>/bin/jre/lib/security/cacerts
  9. Restart Web Help Desk.
    The JDBC driver is enabled.

If you are unable to connect to the MySQL database, ensure that:

  • The appropriate certificate was imported into the cacerts directory.
  • The path to the Web Help Desk home directory is correct.

If you still cannot connect to the SQL Server database, collect the log files and contact SolarWinds Support.

Last modified
10:31, 22 Mar 2017

Tags

Classifications

Public