This is just my own internal notes so I don’t have to keep them on my desktop…<\/p>\n
\nsudo sh
\nsafe_mysqld &
\nmysql
\ndrop database sakai;
\ncreate database sakai default character set utf8;
\ngrant all on sakai.* to sakaiuser@’localhost’ identified by ‘sakaipassword’;
\ngrant all on sakai.* to sakaiuser@’127.0.0.1′ identified by ‘sakaipassword’;
\nhttp:\/\/cvs.sakaiproject.org\/release\/2.0.1\/SourceInstallGuide.html#Database
\nEdit .\/kernel\/component\/src\/config\/org\/sakaiproject\/config\/sakai.properties
\n***** NEVER EVER CHECK THIS BACK IN *****
\nFix these lines a the top:
\njdbc.defaultTransactionIsolation=java.sql.Connection.TRANSACTION_READ_COMMITTED
\nhibernate.dialect=net.sf.hibernate.dialect.MySQLDialect
\nAdd these at the end
\nvendor@org.sakaiproject.service.framework.sql.SqlService=mysql
\ndriverClassName@javax.sql.BaseDataSource=com.mysql.jdbc.Driver
\nurl@javax.sql.BaseDataSource=jdbc:mysql:\/\/127.0.0.1:3306\/sakai?useUnicode=true&characterEncoding=UTF-8
\nusername@javax.sql.BaseDataSource=sakaiuser
\npassword@javax.sql.BaseDataSource=sakaipassword
\nvalidationQuery@javax.sql.BaseDataSource=select 1 from DUAL
\nCompile and deploy sakai into Tomcat.
\nAdd the MySql connector
\ncp ~\/dev\/keepzips\/mysql-connector-java-3.1.11\/mysql-connector-java-3.1.11-bin.jar ~\/dev\/jakarta-tomcat-5.5.9\/common\/lib\/
\nNOTE: When switching back and forth from mysql to hsql, make sure to deal with the jakarta-tomcat-5.5.9\/sakai\/sakai.properties file<\/p>\n","protected":false},"excerpt":{"rendered":"
This is just my own internal notes so I don’t have to keep them on my desktop…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-104","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/posts\/104","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/comments?post=104"}],"version-history":[{"count":1,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/posts\/104\/revisions"}],"predecessor-version":[{"id":2184,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/posts\/104\/revisions\/2184"}],"wp:attachment":[{"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/media?parent=104"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/categories?post=104"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dr-chuck.com\/csev-blog\/wp-json\/wp\/v2\/tags?post=104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}