Submit a ticketCall us

WebinarWebinar: A checklist for planning your Network Performance Monitor (NPM) upgrade

Are you ready for your next upgrade? To help you plan smoothly, join this webcast to learn more about, SolarWinds® Orion® Installer, SolarWinds Upgrade Advisor, Upgrades Guides, Training Videos, and other resources available. We’ll share key upgrade planning considerations, lessons learned from customers with practical advice from SolarWinds Product Experts. We’ll also give practical tips to identify the estimated time needed and resources, how to prepare the business and IT staff for changes, ways to plan for required system changes, and more.

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