Choose your language

Choose your login

Contact us

Configuring MySQL

This page applies to:

MySQL is a free/open-source database solution that provides robust, proven, and scalable storage at a great price. For database server system requirements see our MF and NG system requirements pages.

Database driver

PaperCut NG/MF does not ship with a database driver for MySQL because the MySQL licensing does not allow redistribution of the driver. Download these drivers for free from the MySQL website as described below.

To download the required version of the driver:

  1. Visit the MySQL web site download page for the MySQL Connector/J product here: http://dev.mysql.com/downloads/connector/j/ .

  2. Select the appropriate driver version (the latest version is best).

  3. Download the driver package and unzip the contents to a temporary directory.

  4. Find the driver JAR file, which is typically named mysql-connector-java-X.Y.Z-bin.jar.

  5. Copy the JAR file into the [app-path]\server\lib-ext directory. This allows PaperCut NG/MF to find and load the driver.

Once the driver is installed into PaperCut NG/MF, you can follow the standard upsizing procedure. For more information, see Upsize to an external database (RDBMS) .

What’s next?

If you’re in the process of migrating to the external database for the first time, head over to continue with the steps (Step 5: Change the PaperCut NG/MF connection details) from our Upsize to an external database (RDBMS) article.

If you’ve already migrated (and changed the connection details as documented in Upsize to an external DB ) and are looking to confirm that the PaperCut Application Server is pointing to the external database successfully, you can check this using the system information in the PaperCut admin interface.

Navigate to the About tab > System info > Database, and you’ll see the type of database server listed. Database: Internal indicates that the App Server is still using the Internal ‘derby’ database, whereas Database: MySQL indicates it’s using a MySQL DB Server.

Comments