Installing database drivers

This feature is not available to users of the Squiz Experience Cloud version of Funnelback.

Funnelback ships with JDBC database drivers for PostgreSQL and SQLite.

Other databases are supported via JDBC, but this requires installation of the relevant JDBC drivers.

Database drivers are installed on Funnelback by copying the relevant jar file to a specific folder on the Funnelback server.

Funnelback will automatically detect the driver once the file is copied in to the correct location and has the appropriate permissions.

Make sure you only have one version of the JDBC driver for any particular database present in the dbgather folder otherwise you may get errors when you attempt to start the database update. Remove other versions of the same driver, or rename them so they don’t have a .jar file extension.
Table of Contents

Install a database driver

To install a database driver:

  1. Download the driver files from the database vendor and copy the relevant JDBC .jar file to the Funnelback server.

  2. Copy the file to $SEARCH_HOME/lib/java/dbgather/

    $ cp mydriver.jar $SEARCH_HOME/lib/java/dbgather/
  3. Ensure that the file is owned by the search user and has group and owner read/write permissions, and public read permission.

    $ chown search:search $SEARCH_HOME/lib/java/dbgather/mydriver.jar
    $ chmod 664  $SEARCH_HOME/lib/java/dbgather/mydriver.jar