[Deploying Sakai] MySQL 5.5 Configuration Sakai 2.9

Steve Swinsburg steve.swinsburg at gmail.com
Tue Jan 28 15:05:55 PST 2014


Address already in use means the port is already taken so I' would be
ensuring that you have it shutdown completely (and/or kill the java
process) before restarting. Also, can you just run it on port 8080, get it
running and then change the port?


On Wed, Jan 29, 2014 at 4:55 AM, Kafir Fukallah <kafirfukallah at gmail.com>wrote:

> 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(AbstractHttp11JsseProtocol.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:559)
>
>         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:106)
>
>         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>
> 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/20140129/f9884693/attachment-0001.html 


More information about the production mailing list