MySQL

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 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:

   GRANT ALL PRIVILEGES ON crowd.* TO 'crowduser'@'localhost' IDENTIFIED BY 'crowdpass';

4. Edit the my.cnf file (often named my.ini on Windows operating systems) in your MySQL server. Locate the [mysqld]section in the file, and add or modify the following parameters (Refer to MySQL Option Files for detailed instructions on editing my.cnf and my.ini.): 

   • UTF-8 となるデフォルトのキャラクタセットを指定します:

     [mysqld]
     ...
     character-set-server=utf8
     collation-server=utf8_bin
     ...

   • デフォルトのストレージエンジンを InnoDB に設定します:

     [mysqld]
     ...
     default-storage-engine=INNODB
     ...
     

   • set to transaction-isolation = READ-COMMITTED.

     [mysqld]
     ...
     transaction-isolation = READ-COMMITTED
     ...

   メモ:

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

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

次のステップ

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

関連トピック

• サポート対象プラットフォーム
  • Setting JAVA_HOME
• Installing Crowd and CrowdID
  • Connecting Crowd to a Database
  • Connecting CrowdID to a Database
  • Installing Crowd and CrowdID WAR Distribution
  • Specifying your Crowd Home Directory
• セットアップ ウィザードの実行
  • Troubleshooting your Configuration on Setup
• Configuring Crowd
  • 重要なディレクトリとファイル
  • Changing the Port that Crowd uses
  • Configuring Crowd to Work with SSL
  • Installing Crowd as a Windows Service
  • Setting Crowd to Start Automatically on Mac OS X
  • Setting Crowd to Run Automatically and Use an Unprivileged System User on UNIX