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

Create a database for fixx

• Create a database user for fixx to use (e.g. fixxuser)

• Create a database for fixx to use (e.g. fixx) create database fixx 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 /fixx/WEB-INF/lib directory of your fixx installation.

Configure fixx to connect to MySQL

Modify fixx/WEB-INF/classes/applicationContext-resources.xml and edit the dataSource XML specification to use the MySQL JDBC Driver and connection details for the MySQL DB.

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
    <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost/fixx?createDatabaseIfNotExist=true&amp;useUnicode=true&amp;characterEncoding=utf-8"/>
<property name="username" value="fixxuser"/>
<property name="password" value="password"/>
<property name="maxActive" value="100"/>
<property name="maxIdle" value="30"/>
<property name="maxWait" value="1000"/>
<property name="defaultAutoCommit" value="true"/>
<property name="removeAbandoned" value="true"/>
<property name="removeAbandonedTimeout" value="60"/>
</bean>

Finally, modify fixx/WEB-INF/classes/applicationContext-dao.xml and change the hibernate.dialect setting for sessionFactory bean to org.hibernate.dialect.MySQLMyISAMDialect.

<bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
    <property name="dataSource" ref="dataSource"/>
    <property name="configLocation" value="classpath:hibernate.cfg.xml"/>
    <property name="hibernateProperties">
        <value>
            hibernate.dialect=org.hibernate.dialect.MySQLMyISAMDialect
            hibernate.query.substitutions=true 'Y', false 'N'
            hibernate.cache.use_second_level_cache=true
            hibernate.cache.provider_class=org.hibernate.cache.EhCacheProvider
            hibernate.jdbc.batch_size=0
        </value>
    </property>
</bean>

Run fixx set-up

Now your database is configured, run the fixx server and the interactive set-up for your platform as described in the setup guide