Documentation forWeb Help Desk

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 > General > Database.
  2. Click the drop-down menu and select the database for your Web Help Desk installation.

    If you select PostgreSQL as your primary database, select the Use Embedded Database checkbox 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. (Non-embedded database only) Enter the name of your Web Help Desk database.

  6. Enter the user name and password for your Web Help Desk database connection.

  7. Select the days of the week and time of day when Web Help Desk will automatically backup the database. If you do not select any days of the week, Web Help Desk will not create a backup.

    If you are using the embedded PostgreSQL database, backups are written by default to the following directory:

    <WebHelpDesk>pgsql9/Backups

  8. (Non-embedded database only) Optionally, you can enter a shell command that will execute based on the backup schedule.

  9. (Embedded database only) Select or enter the appropriate backup folder path to store your database backup files.

  10. (Embedded database only) 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.

  11. 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.

  12. Click Save.
  13. Click Restart Web Help Desk to restart the application and the Apache Tomcat web server. This process enables your new database connection settings.