Customize the database connection

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 Web Help Desk 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 deselect Use Embedded Database, the Database field displays.

  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 back up your new Web Help Desk database file to your backup folder.

    If a Backup command returned exit code 1 error displays, see this KB article for details.

  11. Click Save.
  12. Click Restart Web Help Desk to enable your new database connection settings.