Submit a ticketCall us

AnnouncementsChange Is Inevitable

Get valuable help when it comes to tracking and monitoring changes. SolarWinds® Server Configuration Monitor (SCM) is designed to help you: detect, track, and receive alerts when changes occur, correlate system performance against configuration changes, compare server and application configuration against custom baselines, and verify application and system changes.

Learn more.

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