Configuring MySQL

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

Important:

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

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