[Deploying Sakai] MySQL 5.5 Configuration Sakai 2.9

[Kafir Fukallah]

Greetings.  I am having trouble getting Sakai to work with MySQL.

 

I am testing Sakai on a W7 SP1 x64 box and when I use the HSQLDB it works
fine until I run out of memory.  I have MySQL 5.6 installed and installed
5.5 as well.  When I attempt to start the server using startup.bat it runs
and then hangs in the java console.  It hangs at "INFO localhost-startup-1
org.sakai.project.component.impl.BasicCongurationService - destroy ()"  

 

Here is the log file from Tomcat:

Jan 25, 2014 11:03:21 AM org.apache.catalina.core.AprLifecycleListener init

INFO: Loaded APR based Apache Tomcat Native library 1.1.29 using APR version
1.4.8.

Jan 25, 2014 11:03:21 AM org.apache.catalina.core.AprLifecycleListener init

INFO: APR capabilities: IPv6 [true], sendfile [true], accept filters
[false], random [true].

Jan 25, 2014 11:03:21 AM org.apache.catalina.core.AprLifecycleListener
initializeSSL

INFO: OpenSSL successfully initialized (OpenSSL 1.0.1e 11 Feb 2013)

Jan 25, 2014 11:03:21 AM org.apache.coyote.AbstractProtocol init

INFO: Initializing ProtocolHandler ["http-apr-1976"]

Jan 25, 2014 11:03:21 AM org.apache.coyote.AbstractProtocol init

INFO: Initializing ProtocolHandler ["ajp-apr-8009"]

Jan 25, 2014 11:03:21 AM org.apache.catalina.startup.Catalina load

INFO: Initialization processed in 1092 ms

Jan 25, 2014 11:03:21 AM org.apache.catalina.core.StandardService
startInternal

INFO: Starting service Catalina

Jan 25, 2014 11:03:21 AM org.apache.catalina.core.StandardEngine
startInternal

INFO: Starting Servlet Engine: Apache Tomcat/7.0.50

Jan 25, 2014 11:03:21 AM org.apache.catalina.startup.HostConfig deployWAR

INFO: Deploying web application archive E:\opt\tomcat\webapps\access.war

 

And here are my MySQL settings in the sakai.properties file:

# MySQL settings

# vendor at org.sakaiproject.db.api.SqlService=mysql
<mailto:vendor at org.sakaiproject.db.api.SqlService=mysql> 

# driverClassName at javax.sql.BaseDataSource=com.mysql.jdbc.Driver
<mailto:driverClassName at javax.sql.BaseDataSource=com.mysql.jdbc.Driver> 

# hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect

#
url at javax.sql.BaseDataSource=jdbc:mysql://127.0.0.1:3306/sakai?useUnicode=tr
ue
<mailto:url at javax.sql.BaseDataSource=jdbc:mysql://127.0.0.1:3306/sakai?useUn
icode=true&characterEncoding=UTF-8> &characterEncoding=UTF-8

#&useServerPrepStmts=false&cachePrepStmts=true&prepStmtCacheSize=4096&prepSt
mtCacheSqlLimit=4096

# validationQuery at javax.sql.BaseDataSource=select
<mailto:validationQuery at javax.sql.BaseDataSource=select>  1 from DUAL

#
defaultTransactionIsolationString at javax.sql.BaseDataSource=TRANSACTION_READ_
COMMITTED
<mailto:defaultTransactionIsolationString at javax.sql.BaseDataSource=TRANSACTI
ON_READ_COMMITTED> 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20140125/a694397b/attachment.html