This is just my own internal notes so I don't have to keep them on my desktop...
sudo sh
safe_mysqld &
mysql
drop database sakai;
create database sakai default character set utf8;
grant all on sakai.* to sakaiuser@'localhost' identified by 'sakaipassword';
grant all on sakai.* to sakaiuser@'127.0.0.1' identified by 'sakaipassword';
http://cvs.sakaiproject.org/release/2.0.1/SourceInstallGuide.html#Database
Edit ./kernel/component/src/config/org/sakaiproject/config/sakai.properties
***** NEVER EVER CHECK THIS BACK IN *****
Fix these lines a the top:
jdbc.defaultTransactionIsolation=java.sql.Connection.TRANSACTION_READ_COMMITTED
hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect
Add these at the end
vendor@org.sakaiproject.service.framework.sql.SqlService=mysql
driverClassName@javax.sql.BaseDataSource=com.mysql.jdbc.Driver
url@javax.sql.BaseDataSource=jdbc:mysql://127.0.0.1:3306/sakai?useUnicode=true&characterEncoding=UTF-8
username@javax.sql.BaseDataSource=sakaiuser
password@javax.sql.BaseDataSource=sakaipassword
validationQuery@javax.sql.BaseDataSource=select 1 from DUAL
Compile and deploy sakai into Tomcat.
Add the MySql connector
cp ~/dev/keepzips/mysql-connector-java-3.1.11/mysql-connector-java-3.1.11-bin.jar ~/dev/jakarta-tomcat-5.5.9/common/lib/
NOTE: When switching back and forth from mysql to hsql, make sure to deal with the jakarta-tomcat-5.5.9/sakai/sakai.properties file
Posted by csev at November 6, 2005 12:29 PM