Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Web Help Desk (WHD) > Web Help Desk Administrator Guide > Set up the application > Customize the database connection

Customize the database connection

Table of contents
No headers
Created by Steve.Hawkins, last modified by Anthony.Rinaldi_ret on Jul 18, 2016

Views: 116 Votes: 0 Revisions: 4

The Database Connection screen allows you to customize your database connection settings and backup schedule.

When you install and run Web Help Desk for the first time, the application automatically selects the embedded PostgreSQL database and will not prompt you for a database connection or license key. If you decide to use an external database, update your database connection settings in this screen. When you are finished, click Save and restart  to enable your new settings. 

  1. In the toolbar, click Setup and select General > Database.
  2. Click the Vendor drop-down menu and select the appropriate database for your Web Help Desk installation.

    If you select PostgreSQL as your primary database, select the Use Embedded Database check box to use the embedded PostgreSQL database included with Web Help Desk.

    When you select both of these options, the Database field is removed and the Backup Folder and Number of backups options become available.

  3. In the Host field, enter the IP address or DNS name of the server hosting the Web Help Desk database.
  4. In the Port field, enter the port number for the database connection.

    The default ports include:

    • 3306 (MySQL)
    • 1433 (Microsoft SQL Server)
    • 5432 (PostgreSQL)
  5. In the Database field (if available), enter the name of your Web Help Desk database.
  6. In the Username and Password fields, enter the user name and password for your Web Help Desk database connection.
  7. In the Backup Schedule row, select the days of the week and time of day when Web Help Desk will automatically backup the database.

    Otherwise, leave this row blank to prevent Web Help Desk from scheduling a backup.

  8. In the Backup Folder row (if available), select or enter the appropriate backup folder path to store your database backup files.
  9. In the Number of backups drop-down menu (if available), select the total number of backups to store in your database backup file.

    Web Help Desk uses first-in, first-out database storage logic. For example, if you choose to save five backup files and in time save a sixth backup file, the first backup in the series will be deleted.

  10. Click Backup Now to backup your new Web Help Desk database file to your backup folder.
  11. Click Save.
  12. Restart Web Help Desk to enable your new database connection settings.
 
Last modified

Tags

Classifications

Public