Submit a ticketCall us

WebinarUpcoming Webinar: Know What’s Changed – with NEW Server Configuration Monitor

Change management in IT is critical. But, even with a good change management process, changes are too often not correctly tracked, if at all. The configuration of your servers and applications is a key factor in their performance, availability, and security. Many incidents can be tracked back to an authorized (and sometimes unauthorized) configuration change, whether to a system file, configuration file, or Windows® Registry entry. Join SolarWinds VP of product management Brandon Shopp to discover how the new SolarWinds® Server Configuration Monitor is designed to help you.

Register now.

Home > Success Center > Web Help Desk (WHD) > WHD - Knowledgebase Articles > 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

Tags

Classifications

Public