Database configuration

Requirements

• PowerFolder Server 2.0+
• The database server (we recommend MySQL Community Server)
• The JDBC driver (for MySQL it is called a Connector)

Setup

• Install PowerFolder Server 2.0+
• Install and configure the database server
• Create a database (e. g. 'CREATE DATABASE powerfolder')
• Add users and grant permissions.
• Copy the JDBC driver into the installation folder of PowerFolder Server
• Edit PowerFolder.sh / wrapper.conf and add the JDBC driver to the classpath ("JAVA_OPTS"), e.g. mysql-connector-java-5.1.18-bin.jar
• Edit the configuration file (PowerFolder.config)
• Start PowerFolder Server

PowerFolder.sh example

...
JAVA_OPTS="-Xms256m -Xmx1024m -cp $POWERFOLDER_INSTALL/PowerFolder-server.jar:$POWERFOLDER_INSTALL/mysql-connector-java-5.1.18-bin.jar"
...

wrapper.conf example

...
wrapper.java.classpath.1=wrapper.jar
wrapper.java.classpath.2=PowerFolder-server.jar
wrapper.java.classpath.3=mysql-connector-java-5.1.18-bin.jar
...