Installing solomon using MySQL

Download and extract the solomon installation as advised in the setup guide but do not run the solomon server. These steps follow on from Step 2 on the installation process for Windows and Linux.

Create a database for solomon

  1. Create a database user for solomon to use (e.g. solomonuser)

  2. Create a database for solomon to use (e.g. solomon)
    create database solomon character set utf8;

  3. Ensure the database has a character set of UTF-8 to support Unicode text.

  4. Ensure that the user you created has permissions to connect to the database and create/drop tables

Download and install the MySQL Driver

Download the MySQL Connector/J JDBC Driver (preferably 5.1) and copy the JAR file for the driver into /solomon/WEB-INF/lib directory of your solomon installation.

Configure solomon to connect to MySQL

Modify solomon/WEB-INF/classes/jdbc.properties to use the MySQL JDBC Driver and connection details for the MySQL DB.

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost/solomon?useUnicode=true&characterEncoding=UTF8
jdbc.username=[enter db username]
jdbc.password=[enter db password]
jdbc.dialect=org.hibernate.dialect.MySQLInnoDBDialect

Run solomon set-up

Now your database is configured, continue from Step 4 of the setup guide