[Building Sakai] Switching from HSQLDB to MySQL

[Matthew Sharrer]

I've built Sakai, and I can get the demo to work running off of memory with
HSQLDB.

This is my environment:
java version "1.5.0_22"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_22-b03)
Java HotSpot(TM) Client VM (build 1.5.0_22-b03, mixed mode, sharing)

Apache Tomcat 5.5.29

Maven version: 2.0.8
Java version: 1.5.0_22
OS name: "linux" version: "2.6.18-164.el5" arch: "i386" Family: "unix"

I've also set all the needed environment variables.

The builds went alright, and like I said, I could login to Sakai when I was
running off of memory.

I attempted to switch to MySQL and I'm having no luck.  I'm using version
5.0.77.  I added a group and user for mysql, and set up environment
variables.  I was able to start up mysql, and I created the sakai database
with the default character set utf8. I then typed the following:
grant all on sakai.* to sakaiuser@'localhost' identified by
'sakaipassword';
grant all on sakai.* to sakaiuser@'127.0.0.1' identified by
'sakaipassword';
flush privileges;

I've installed the mysql JDBC driver.

I created a my.cnf file in /etc:
[mysqld]
default-storage-engine=InnoDB
Innodb_data_home_dir=/usr/local/mysql/data
Innotdb_data_file_path=ibdata1:10M:autoextend
Innodb_flush_log_at_trx_commit=1

I edited teh sakai.properties file in $CATALINA_HOME/sakai:
username at javax.sql.BaseDataSource=sakaiuser
password at javax.sql.BaseDataSource=sakaipassword

And I commented out the HSQLDB settings while uncommenting the mysql
settings.

I don't know what else to do.  I feel like I followed the configuration
instructions, but perhaps I'm missing something.

If anyone can provide assistance, I'd greatly appreciate it.  I can post
logs, but I didn't want to post too much information at once.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100428/7bf52db4/attachment.html