[Deploying Sakai] MySQL 5.5 Configuration Sakai 2.9

Kafir Fukallah kafirfukallah at gmail.com
Tue Jan 28 09:55:26 PST 2014 

Hey Steve,

 

Thanks for your response.

 

I installed Tomcat by extracting the files and copying them over to
e:\opt\Tomcat.  I didn't see an installer and in Running.txt I followed 

(2.2) Unpack the binary distribution so that it resides in its own directory
(conventionally named "apache-tomcat-[version]").

 

If I go to the e:\opt\tomcat\components dir I see 68 items.

 

In doing some additional troubleshooting by running the configtest.bat after
Tomcat had started and this is the output

 

I have configured sakai to use port 1976 since I am running IIS on this same
box and it uses port 80-83 and 443.  I read a post regarding this java error
and then commented out the ARP loader in server.xml.  I also stopped the IIS
service, installed Tomcat as a service but all of my attempts don't seem to
have had any impact, the startup hangs at the same spot, when I run
configtest I get the same output as before.

 

Using CATALINA_BASE:   "e:\opt\tomcat"

Using CATALINA_HOME:   "e:\opt\tomcat"

Using CATALINA_TMPDIR: "e:\opt\tomcat\temp"

Using JRE_HOME:        "C:\Program Files\Java\jdk1.7.0_51"

Using CLASSPATH:
"e:\opt\tomcat\bin\bootstrap.jar;e:\opt\tomcat\bin\tomcat-juli.jar"

Jan 28, 2014 10:49:41 AM org.apache.coyote.AbstractProtocol init

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

Jan 28, 2014 10:49:41 AM org.apache.coyote.AbstractProtocol init

SEVERE: Failed to initialize end point associated with ProtocolHandler
["http-bio-1976"]

java.net.BindException: Address already in use: JVM_Bind <null>:1976

        at org.apache.tomcat.util.net.JIoEndpoint.bind(JIoEndpoint.java:410)

        at
org.apache.tomcat.util.net.AbstractEndpoint.init(AbstractEndpoint.java:640)

        at
org.apache.coyote.AbstractProtocol.init(AbstractProtocol.java:434)

        at
org.apache.coyote.http11.AbstractHttp11JsseProtocol.init(AbstractHttp11JsseP
rotocol.java:119)

        at
org.apache.catalina.connector.Connector.initInternal(Connector.java:981)

        at
org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:102)

        at
org.apache.catalina.core.StandardService.initInternal(StandardService.java:5
59)

        at
org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:102)

        at
org.apache.catalina.core.StandardServer.initInternal(StandardServer.java:814
)

        at
org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:102)

        at org.apache.catalina.startup.Catalina.load(Catalina.java:639)

        at org.apache.catalina.startup.Catalina.load(Catalina.java:664)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57
)

        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:43)

        at java.lang.reflect.Method.invoke(Method.java:606)

        at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:281)

        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:460)

Caused by: java.net.BindException: Address already in use: JVM_Bind at
java.net.DualStackPlainSocketImpl.bind0(Native Method)

        at
java.net.DualStackPlainSocketImpl.socketBind(DualStackPlainSocketImpl.java:1
06)

        at
java.net.AbstractPlainSocketImpl.bind(AbstractPlainSocketImpl.java:376)

        at java.net.PlainSocketImpl.bind(PlainSocketImpl.java:190)

        at java.net.ServerSocket.bind(ServerSocket.java:376)

        at java.net.ServerSocket.<init>(ServerSocket.java:237)

        at java.net.ServerSocket.<init>(ServerSocket.java:181)

        at
org.apache.tomcat.util.net.DefaultServerSocketFactory.createSocket(De

faultServerSocketFactory.java:49)

        at org.apache.tomcat.util.net.JIoEndpoint.bind(JIoEndpoint.java:397)

        ... 17 more

 

From: Steve Swinsburg [mailto:steve.swinsburg at gmail.com] 
Sent: Monday, January 27, 2014 8:46 PM
To: Kafir Fukallah
Cc: production at collab.sakaiproject.org
Subject: Re: [Deploying Sakai] MySQL 5.5 Configuration Sakai 2.9

 

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
<mailto: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
<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> 

 

 


_______________________________________________
production mailing list
production at collab.sakaiproject.org
<mailto:production at collab.sakaiproject.org> 
http://collab.sakaiproject.org/mailman/listinfo/production

TO UNSUBSCRIBE: send email to production-unsubscribe at collab.sakaiproject.org
<mailto: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/c577e687/attachment-0001.html

More information about the production mailing list