Tools

Enable SSL encryption for a MySQL database

This article describes how to set up SSL encryption in a MySQL database for Web Help Desk.

First published date

11/26/2018 6:16 PM

Last published date

11/26/2018 6:16 PM

Overview

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

Product section

Web Help Desk

Resolution

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.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.  You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.