sakai 的安装-mysql及中文的安装

 

网上有很多Sakai 的安装指南, 但是搜了很久, 中文网页上并没找到有关Mysql 配置及中文配置的说明,特别补充如下:

 

Sakai 基本安装指南请参考: http://linux.chinaitlab.com/set/523349.html

 

Mysql及中文的配置:

修改 ./sakai/sakai.properties 文件如下:

# sakai.properties - the demo edition

# set the shared datasource URL to use a file based HSQLDB
#url@javax.sql.BaseDataSource=jdbc:hsqldb:${sakai.home}/db/sakai.db

###################################################################################################
#
# examples of other driver class name values - HSQLDB is the default
#driverClassName@javax.sql.BaseDataSource=org.hsqldb.jdbcDriver
driverClassName@javax.sql.BaseDataSource=com.mysql.jdbc.Driver
#driverClassName@javax.sql.BaseDataSource=oracle.jdbc.driver.OracleDriver
username@javax.sql.BaseDataSource=root
password@javax.sql.BaseDataSource=password
#
###################################################################################################
#
# examples of other datasource URLs for other technologies: HSQLDB in-memory is the default, and above see how to put this in a file
#url@javax.sql.BaseDataSource=jdbc:hsqldb :.
url@javax.sql.BaseDataSource=jdbc:mysql://localhost:3306/sakai?useUnicode=true&characterEncoding=UTF-8
#url@javax.sql.BaseDataSource=jdbc:oracle:thin:@monster.oracle.org:1521:db
#
###################################################################################################
#
# example vendor settings - must match your hibernate dialect set in the "placeholder.properties" file - "hsqldb" is the default
#vendor@org.sakaiproject.db.api.SqlService=hsqldb
vendor@org.sakaiproject.db.api.SqlService=mysql
#vendor@org.sakaiproject.db.api.SqlService=oracle
#
###################################################################################################
#
# set the validation query - the default is for hsqldb "select 1 from SYSTEM_USERS"
# for MySQL and Oracle, change it to this:
validationQuery@javax.sql.BaseDataSource=select 1 from DUAL
#
# Note: This has been shown to cause performance problems in Oracle - to leave it unset, set it to:
#validationQuery@javax.sql.BaseDataSource =

#
###################################################################################################
#
# set the default transaction isolation level - Up to and including 1.7.1, HSQLDB supports only "TRANSACTION_READ_UNCOMMITTED" - this is the default
# MySQL and Oracle should be set to TRANSACTION_READ_COMMITTED.
#defaultTransactionIsolationString@javax.sql.BaseDataSource=TRANSACTION_READ_UNCOMMITTED
defaultTransactionIsolationString@javax.sql.BaseDataSource=TRANSACTION_READ_COMMITTED

#
# Note: TRANSACTION_READ_COMMITTED is the default for Oracle, and performance problems have been seen when attempting to set this default.
# To leave it unset, set it to:
#defaultTransactionIsolationString@javax.sql.BaseDataSource =
#
###################################################################################################
#
# Examples of interesting values to set.  This is not an inclusive list, since every property can be overridden in the property files
#
# set the default skin
#skin.default=default
#
# set the path to the skin repository
#skin.repo=/library/skin
#
# maximum allowed user file upload - in megabytes.  Default is 1 (megabyte).
#content.upload.max=20
#
###################################################################################################
#
# set the hibernate dialect (for shared datasource), HSQLDB by default, mySql and Oracle examples
#hibernate.dialect=org.hibernate.dialect.HSQLDialect
hibernate.dialect=org.hibernate.dialect.MySQLDialect
#hibernate.dialect=org.hibernate.dialect.Oracle9Dialect
#
###################################################################################################
#
# set the auto.ddl - default value is "true"
#auto.ddl=true
#auto.ddl=false
#
###################################################################################################

# Supported language locales for user preferences
locales = en, ja_JP, ko_KR, nl_NL, zh_CN, es_ES, fr_CA, ca_ES

 

修改./bin/catalina.sh 如下:

# Set juli LogManager if it is present
if [ -r "$CATALINA_HOME"/bin/tomcat-juli.jar ]; then
  JAVA_OPTS="$JAVA_OPTS -Duser.language=zh -Duser.region=CN"
  JAVA_OPTS="$JAVA_OPTS "-Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager" "-Djava.util.logging.config.file="$CATALINA_BASE/conf/logging.properties"
fi

 

拷贝Mysql 驱动程序mysql-connector-java-3.1.12.jar
到 ./common/lib

启动sakai, mysql 中的数据,程序会自动生成, 直接就可以使用了!

 

Good luck!