[Building Sakai] changing default database in 2.8.2
Steve Swinsburg
steve.swinsburg at gmail.com
Sat Mar 9 18:27:27 PST 2013
Hi,
Tomcat can't start because something is already on port 8080:
java.net.BindException: Address already in use:8080
Either change the port for Sakai or stop whatever is running on 8080. It
may just be an old Sakai process that didnt full shutdown.
cheers,
Steve
On Sun, Mar 10, 2013 at 12:54 PM, Ese Egerega <ese at cis.com.ng> wrote:
> Dear all,
>
> I successfully deployed sakai 2.8.2 on Ubuntu 10.0.4 using the default
> database (*HSQLDB). I was able to login, create users, sites, etc. *Am
> now trying to change the default database from *HSQLDB* to mysql but am
> having problems.
>
> I have followed all the steps in the documentation with no luck.
>
> Below is my server login details in case someone want's to login and
> check. It's a demo server so feel free to make changes:
>
> http://50.57.171.197
> Username: root
> Password: eMIt6Kd56sakaii
>
> Thanks in advance.
>
> Ese
>
>
> ******************************************************************
>
> The following are my sakai.properties setting and tomcat's log:
>
>
>
> # Enable hibernate SQL debugging output.
> hibernate.show_sql=true
>
> # The database username and password. The defaults are for the
> out-of-the-box HSQLDB.
> # Change to match your setup. Do NOT enable access to your database
> without a password.
> username at javax.sql.BaseDataSource=root
> password at javax.sql.BaseDataSource=P@$$word
>
> # MySQL settings
> vendor at org.sakaiproject.db.api.SqlService=mysql
> driverClassName at javax.sql.BaseDataSource=com.mysql.jdbc.Driver
> hibernate.dialect=org.hibernate.dialect.MySQLDialect
> #hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
> url at javax.sql.BaseDataSource=jdbc:mysql://
> 50.57.171.197:3306/sakai?useUnicode=true&characterEncoding=UTF-8
> validationQuery at javax.sql.BaseDataSource=select 1 from DUAL
> defaultTransactionIsolationString at javax.sql.BaseDataSource
> =TRANSACTION_READ_COMMITTED
>
>
>
> 2013-03-10 01:43:36,840 INFO main
> org.apache.catalina.core.AprLifecycleListener - The APR based Apache Tomcat
> Native library which allows optimal performance in production environments
> was not found on the java.library.path:
> /usr/lib/jvm/java-6-sun-1.6.0.26/jre/lib/amd64/server:/usr/lib/jvm/java-6-sun-1.6.0.26/jre/lib/amd64:/usr/lib/jvm/java-6-sun-1.6.0.26/jre/../lib/amd64:/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
> 2013-03-10 01:43:36,985 ERROR main
> org.apache.coyote.http11.Http11BaseProtocol - Error initializing endpoint
> java.net.BindException: Address already in use:8080
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.initEndpoint(PoolTcpEndpoint.java:298)
> at
> org.apache.coyote.http11.Http11BaseProtocol.init(Http11BaseProtocol.java:139)
> at
> org.apache.catalina.connector.Connector.initialize(Connector.java:1029)
> at
> org.apache.catalina.core.StandardService.initialize(StandardService.java:578)
> at
> org.apache.catalina.core.StandardServer.initialize(StandardServer.java:782)
> at org.apache.catalina.startup.Catalina.load(Catalina.java:504)
> at org.apache.catalina.startup.Catalina.load(Catalina.java:524)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:267)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
> 2013-03-10 01:43:36,988 ERROR main org.apache.catalina.startup.Catalina -
> Catalina.start
> LifecycleException: Protocol handler initialization failed:
> java.net.BindException: Address already in use:8080
> at
> org.apache.catalina.connector.Connector.initialize(Connector.java:1031)
> at
> org.apache.catalina.core.StandardService.initialize(StandardService.java:578)
> at
> org.apache.catalina.core.StandardServer.initialize(StandardServer.java:782)
> at org.apache.catalina.startup.Catalina.load(Catalina.java:504)
> at org.apache.catalina.startup.Catalina.load(Catalina.java:524)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:267)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
> 2013-03-10 01:43:36,988 INFO main org.apache.catalina.startup.Catalina -
> Initialization processed in 484 ms
> 2013-03-10 01:43:37,083 INFO main
> org.apache.catalina.core.StandardService - Starting service Catalina
> 2013-03-10 01:43:37,087 INFO main org.apache.catalina.core.StandardEngine
> - Starting Servlet Engine: Apache Tomcat/5.5.35
> 2013-03-10 01:43:37,100 INFO main org.apache.catalina.core.StandardHost -
> XML validation disabled
> 2013-03-10 01:43:41,885 INFO main org.sakaiproject.util.ComponentsLoader
> - load: loading components from: /opt/tomcat/components/
> 2013-03-10 01:43:41,887 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/accountvalidator-pack
> 2013-03-10 01:43:42,017 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/archive-pack
> 2013-03-10 01:43:42,038 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/basiclti-pack
> 2013-03-10 01:43:42,049 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/content-copyright-pack
> 2013-03-10 01:43:42,059 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/content-providers-pack
> 2013-03-10 01:43:42,084 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/content-types-pack
> 2013-03-10 01:43:42,093 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage:
> /opt/tomcat/components/coursemanagement-hibernate-pack
> 2013-03-10 01:43:42,095 INFO main org.sakaiproject.util.ComponentsLoader
> - Skipping demo components from
> /opt/tomcat/components/coursemanagement-hibernate-pack
> 2013-03-10 01:43:42,125 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/emailtemplateservice-pack
> 2013-03-10 01:43:42,167 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/entitybroker-pack
> 2013-03-10 01:43:42,246 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/gradebook-service-pack
> 2013-03-10 01:43:42,291 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/import-pack
> 2013-03-10 01:43:42,311 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/localization-bundles-pack
> 2013-03-10 01:43:42,326 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/login-pack
> 2013-03-10 01:43:42,343 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/messageforums-components
> 2013-03-10 01:43:42,466 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/osp-common-component
> 2013-03-10 01:43:42,628 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/osp-glossary-component
> 2013-03-10 01:43:42,657 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/osp-integration-component
> 2013-03-10 01:43:42,699 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/osp-matrix-component
> 2013-03-10 01:43:42,767 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/osp-portal-component
> 2013-03-10 01:43:42,789 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/osp-presentation-component
> 2013-03-10 01:43:42,839 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/osp-warehouse-component
> 2013-03-10 01:43:42,954 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/osp-wizard-components
> 2013-03-10 01:43:43,006 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/polls-pack
> 2013-03-10 01:43:43,042 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/profile-component
> 2013-03-10 01:43:43,053 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/profile2-pack
> 2013-03-10 01:43:43,102 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/sakai-announcement-pack
> 2013-03-10 01:43:43,361 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/sakai-anouncement-import
> 2013-03-10 01:43:43,367 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/sakai-assignment-pack
> 2013-03-10 01:43:43,392 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/sakai-calendar-pack
> 2013-03-10 01:43:43,416 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/sakai-chat-pack
> 2013-03-10 01:43:43,436 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/sakai-citations-pack
> 2013-03-10 01:43:43,456 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/sakai-common-components
> 2013-03-10 01:43:43,472 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/sakai-comp-help
> 2013-03-10 01:43:43,494 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/sakai-courier-pack
> 2013-03-10 01:43:43,503 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage:
> /opt/tomcat/components/sakai-gradebooksample-grade-converter
> 2013-03-10 01:43:43,513 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/sakai-kernel-component
> 2013-03-10 01:43:43,993 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/sakai-mailarchive-pack
> 2013-03-10 01:43:44,013 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/sakai-metaobj-component
> 2013-03-10 01:43:44,066 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/sakai-news-pack
> 2013-03-10 01:43:44,078 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/sakai-podcasts-pack
> 2013-03-10 01:43:44,094 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/sakai-portal-render-pack
> 2013-03-10 01:43:44,111 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/sakai-portal-service-pack
> 2013-03-10 01:43:44,128 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/sakai-postem-pack
> 2013-03-10 01:43:44,137 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/sakai-presence-pack
> 2013-03-10 01:43:44,147 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/sakai-privacy-pack
> 2013-03-10 01:43:44,158 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/sakai-provider-pack
> 2013-03-10 01:43:44,163 INFO main org.sakaiproject.util.ComponentsLoader
> - Skipping demo components from /opt/tomcat/components/sakai-provider-pack
> 2013-03-10 01:43:44,218 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/sakai-rights-pack
> 2013-03-10 01:43:44,228 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/sakai-roster-components
> 2013-03-10 01:43:44,241 INFO main org.sakaiproject.util.ComponentsLoader
> - loadComponentPackage: /opt/tomcat/components/sakai-rwiki-pack
>
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130310/b77fe7d6/attachment.html
More information about the sakai-dev
mailing list