This page last changed on Jun 01, 2009 by smaddox.
When you run the Crowd Setup Wizard, you will be asked to choose a database and provide configuration settings for that database. It will make things easier if you have created the database and deployed the database driver before you start the Setup Wizard.
Follow the instructions below to set up MySQL (5.0.37 and later) for Crowd.
1. Configure MySQL
- Create a database user which Crowd will connect as (e.g. crowduser).
- Create a Latin 1 encoded database for Crowd to store data in (e.g. crowd).
At present, Crowd does not support UTF-8 encoding for MySQL. If you would like MySQL UTF-8 support, please vote on this issue.
- Ensure that the user has permission to connect to the database, and create and populate tables.
- Modify MySQL startup options in the configuration file my.cnf, so the transaction level is set to transaction-isolation = READ-COMMITTED. (Refer to MySQL Option Files for detailed instructions on editing my.cnf.)
The above configuration will prevent errors when you import directory information into Crowd. See CWD-1505.
- Restart your MySQL server for the configuration change to take effect.
2. Copy the MySQL driver to your application server
- Download the MySQL Connector/J JDBC driver driver. Warning: Avoid using version 5.1.x of the driver as it can lead to errors.
- Add the MySQL JDBC driver jar (mysql-connector-java-3.x.x-bin.jar) to the apache-tomcat/common/lib/ directory. NOTE: Do not place the Debug Driver (mysql-connector-java-3.x.x-bin-g.jar) on the CLASSPATH as this can cause issues. (JRA-8674).
Next Steps
Complete the Crowd installation, then start Crowd and run the Setup Wizard as described in the Installation Guide.
RELATED TOPICS
|