Configuration (2.7)
Configuring Sakai 2.7+
1.0 Create a sakai.properties file
2.0 Configure home page tool set per site
3.0 Work site setup group helper
4.0 Session timeout warning
5.0 Configure email
6.0 Configure logging
7.0 Database support in Sakai
Sakai supports the following production-grade databases:
Sakai |
Database |
Driver |
Notes |
|---|---|---|---|
2.8, 2.7 |
MySQL 5.1.x |
|
|
2.8. 2.7, 2.6, 2.5 |
MySQL 5.0.x |
|
|
2.6, 2.5 |
MySQL 4.1.12+ |
|
|
2.8, 2.7, 2.6, 2.5 |
Oracle 10g/Oracle 9i |
|
|
2.7 |
DB2 |
|
|
Sakai requires transaction support. In the case of MySQL you must implement the 
Both Oracle 10g AND 9i users must use the 10g driver; the latest 10g "Release 2" (10.2.x) or higher is recommended.Choose the appropriate MySQL or Oracle JDBC driver (or connector) for your installation. For MySQL, download the *zip/*tar.gz archive, extract its contents and copy the mysql-connector-java-<version>-bin.jar to $CATALINA_HOME/common/lib. For Oracle download the ojdbc14.jar file and copy it to $CATALINA_HOME/common/lib.
Note that you will not need to create Sakai database objects (tables, indices, etc) when setting up your database. Sakai generates its own database schema automatically during the Tomcat setup process via the autoDDL setting in sakai.properties.
In actuality, Sakai is not limited to these database choices and integration with other RDBMS systems is not difficult. In the past at least one installation used Microsoft SQL Server while requests for PostgreSQL integration are occasionally raised on the Sakai developers list. However, to date no one in the Sakai Community has stepped forward to support alternatives to either Oracle or MySQL, a prerequisite for adding additional database options to the release.