/
notes

notes

Jun 03, 2005

  • 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