[Building Sakai] changing default database in 2.8.2

Ese Egerega ese at cis.com.ng
Sat Mar 9 17:54:16 PST 2013 

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130310/fb5234f0/attachment.html

More information about the sakai-dev mailing list