hedgehog lab Bug Tracking, Defect Tracking, and Issue Tracking software for the enterprise.

Installing fixx using MySQL

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.

1. Create a database for fixx

1. Create a database user for fixx to use (eg. fixxuser).
2. Create a database for fixx to use (eg. fixx).

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

   create database fixx character set utf8;

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

2. 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.

3. Configure fixx to connect to MySQL

Modify fixx/WEB-INF/classes/jdbc.properties to connect to the MySQL DB and change hibernate.dialect to org.hibernate.dialect.MySQLMyISAMDialect

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost/fixx?createDatabaseIfNotExist=true&useUnicode=true&characterEncoding=utf-8
jdbc.username=fixxuser
jdbc.password=password
hibernate.dialect=org.hibernate.dialect.MySQLMyISAMDialect

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&useUnicode=true&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>

4. 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