notes

Owned by Thomas Amsler
Last updated: Jun 03, 2005Version comment
2 min read
  • Make sure that you have Java, Ant, and Maven installed.
    • It's assumed that CVS is setep as well as build.properties
  • Create a directory sakai-1-5-1
  • Change to the directory and Download sakai, sam, and sakai-samigo from cvs
    • setenv CVS_RSH ssh
    • cvs -q -z9 -d :ext:sakai_anon_cvs:/cvs co -r sakai_1-5-1 sakai
    • cvs -q -z9 -d :ext:sakai_anon_cvs:/cvs co -r sakai_1-5-1 sam
    • cvs -q -z9 -d :ext:sakai_anon_cvs:/cvs co -r sakai_1-5-1 sakai-samigo
  • Zip the sakai content and move it to ~/src
    • zip -qr sakai-src sakai
  • Move sakai-src.zip to ~/src
  • Run sakai-install.sh from ~/
  • The sakai-install.sh script starts tomcat after the installed had finished. Stop tomcat at this point.
  • Create MySQL sakai user and DB
    • mysql -u root -p
    • 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';
  • Install sakai tables
    • cd ~/local/sakai/reference/src/sql/legacy/mysql
    • mysql -u sakaiuser -p sakai < all.sql
  • Edit /usr/local/sakai/sakai.properties
    • Comment all the NONE mysql db values
    • sql.vendor=mysql
    • sql.driver=com.mysql.jdbc.Driver
    • sql.connect=jdbc:mysql://localhost:3306/sakai?useUnicode=true&characterEncoding=UTF-8
    • sql.user=sakaiuser
    • sql.pw=sakaipassword
    • sql.maxConnection=50
    • sql.maxSlowConnections=25
  • Run maven conf_db
    • cd ~/local/sakai
    • maven conf_db
  • Run sakai and test if it uses MySQL
  • Edit ~/sakai-1-5-1/sam/build.properties, modify appserver.deployment.dir so it points to the correct tomcat webapps location
    • appserver.deployment.dir=~/local/tomcat/webapps
    • e.g. appserver.deployment.dir=/home/sakai/local/tomcat/webapps
  • Also change samigo.db in build.poroperties to point to mysql
    • samigo.db=mysql
  • Prepare MySQL for samigo
    • mysql -u root -p
    • create database samigo;
    • grant all on * to 'sakaiuser'@'%' identified by 'sakaipassword';
  • Change to the MySQL samigo table scipts and create tables
    • cd ~/sakai-1-5-1/sam/ddl/samigo-ddl
    • mysql -u root -p samigo < 01_schema_mysql.sql --force
    • mysql -u root -p samigo < 02_defaultSetUp_mysql.sql --force
    • mysql -u root -p
    • grant all on * to 'sakaiuser'@'%' identified by 'sakaipassword';
  • Configure Samigo's security & settings
    • cp -R ~/sakai-1-5-1/sam/conf/opt/j2ee /opt/
    • cp -R ~/sakai-1-5-1/sam/conf/opt/sa_forms /opt/
  • update the database settings in /opt/sa_forms/java/dev/org/sakaiproject/security/sam/samigo.xml
    • db.driverClassName=com.mysql.jdbc.Driver
    • db.url=jdbc:mysql://localhost:3306/samigo?user=sakaiuser&password=sakaipassword&autoReconnect=true
    • db.username=sakaiuser
    • db.password=sakaipassword
  • Modify hibernate.properties
    • edit ~/sakai-1-5-1/sam/hibernate.properties
    • edit ~/sakai-1-5-1/sam/hibernate-hbm/hibernate.properties
    • enable: hibernate.dialect net.sf.hibernate.dialect.MySQLDialect
    • Note: comment out the oracle line
  • Install the patch "sakai-samigo
    • cd ~/sakai-1-5-1/sakai-samigo
    • tar -cvf /tmp/sakai-samigo.tar --exclude=CVS .
    • cd ../sam
    • tar -xvf /tmp/sakai-samigo.tar
    • maven reg
  • Build samigo
    • cd ~/sakai-1-5-1/sam
    • ant deploy-in-sakai
  • Start tomcat and check for any errors