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
-
Create a database user for solomon to use (e.g. solomonuser)
-
Create a database for solomon to use (e.g. solomon)
create database solomon character set utf8; -
Ensure the database has a character set of UTF-8 to support Unicode text.
-
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