Configuring MySQL

MySQL is a free/open-source database solution that provides robust, proven, and scalable storage at a great price. PaperCut NG supports MySQL 5.5 and higher.

Important:

PaperCut NG requires the use of the MySQL InnoDB table type, which provides full support for transactions. Ensure your MySQL database server is configured to support InnoDB (usually this is enabled by default).

Database driver

PaperCut NG 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 to find and load the driver.

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


Comments

Share your findings and experience with other PaperCut users. Feel free to add comments and suggestions about this Knowledge Base article. Please don't use this for support requests.