[Deploying Sakai] MySQL 5.5 Configuration Sakai 2.9

[Steve Swinsburg]

Hi,

That startup time is nowhere near long enough for Sakai. How did you
install Tomcat? If you go to the Tomcat directory, do you see a
'components' directory?

cheers,
Steve



On Sun, Jan 26, 2014 at 9:06 AM, Kafir Fukallah <kafirfukallah at gmail.com>wrote:

> 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
>
> # 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=true&characterEncoding=UTF-8
>
>
> #&useServerPrepStmts=false&cachePrepStmts=true&prepStmtCacheSize=4096&prepStmtCacheSqlLimit=4096
>
> # validationQuery at javax.sql.BaseDataSource=select 1 from DUAL
>
> #
> defaultTransactionIsolationString at javax.sql.BaseDataSource=TRANSACTION_READ_COMMITTED
>
>
>
>
>
> _______________________________________________
> production mailing list
> production at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/production
>
> TO UNSUBSCRIBE: send email to
> production-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20140128/35c052ba/attachment-0001.html