Documentation for Crowd 2.5. Documentation for other versions of Crowd is available too.

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.

Crowd supports MySQL 5.0.37 and later. Follow the instructions below to set up MySQL for Crowd.

1. Configure MySQL

  1. Create a database user which Crowd will connect as (e.g. crowduser).

  2. Create a database for Crowd to store data in (e.g. crowd). For a UTF-8 encoded database:

    create database crowd character set utf8 collate utf8_bin;
  3. Ensure that the user has permission to connect to the database, and create and populate tables.

  4. Modify MySQL startup options in the configuration file my.cnf (often named my.ini on Windows), so the transaction level is set to transaction-isolation = READ-COMMITTED. (Refer to MySQL Option Files for detailed instructions on editing my.cnf and my.ini.)

    [mysqld]
transaction-isolation = READ-COMMITTED

    メモ:

    • On Windows, the my.cnf file is often named my.ini. Windows can handle both file names.
    • The above configuration will prevent errors when you import directory information into Crowd. See CWD-1505.
  5. Restart your MySQL server for the configuration change to take effect.

Do not use COLLATE utf8_general_ci (e.g. Case insensitive) use COLLATE utf8_bin (e.g. case sensitive). The crowd schema has keys on varchars which will cause you issues if you use collation ending in CI.

2. Copy the MySQL Driver to your Application Server

  1. Download the MySQL Connector/J JDBC driver driver.
  2. Add the MySQL JDBC driver jar (mysql-connector-java-5.x.x-bin.jar) to the following directory:
    • For Crowd distribution:
      • Crowd 2.0.2 or later: {CROWD_INSTALL}/apache-tomcat/lib/.
      • Crowd 2.0.1 or earlier: {CROWD_INSTALL}/apache-tomcat/common/lib/.
    • For Crowd WAR distribution, copy the driver JAR to your application server. For example, on Tomcat:
      • Tomcat 5.5.x: common/lib/.
      • Tomcat 6.x: lib/.

Do not place Debug Driver on CLASSPATH

Do not place the Debug Driver (mysql-connector-java-5.x.x-bin-g.jar) on the CLASSPATH as this can cause issues. See (JRA-8674).

次のステップ

Complete the Crowd installation, then start Crowd and run the Setup Wizard as described in the Installation Guide.

関連トピック



Log a request with our support team.



Raise an issue for our developers.



See answers from the community.



Blog and update our documentation.

Except where otherwise noted, content in this space is licensed under a Creative Commons Attribution 2.5 Australia License.