[Building Sakai] Starting up Sakai 2.6 on mysql fails?
Anthony Whyte
arwhyte at umich.edu
Thu Aug 20 11:23:08 PDT 2009
Looking at the Hibernate docs there are a number of MySQL specific sub-
classes that extend org.hibernate.dialect.Dialect. See
https://www.hibernate.org/hib_docs/v3/api/org/hibernate/dialect/Dialect.html
MySQLDialect
MySQLInnoDBDialect
MySQLMyISAMDialect
MySQL5Dialect
MySQL5InnoDBDialect
On Aug 20, 2009, at 2:02 PM, Anthony Whyte wrote:
> As an experiment change the hibernate.dialect from
>
> hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
>
> to
>
> hibernate.dialect=org.hibernate.dialect.MySQLDialect
>
> restart Tomcat and see if you can log in.
>
> cheers,
>
> Anth
>
>
> Dialects
>
> MySQL org.hibernate.dialect.MySQLDialect
> MySQL with InnoDB org.hibernate.dialect.MySQLInnoDBDialect
> MySQL with MyISAM org.hibernate.dialect.MySQLMyISAMDialect
>
>
>
> On Aug 20, 2009, at 1:23 PM, Nicola Monat-Jacobs wrote:
>
>> Hi -
>>
>> I've having the very frustrating problem where I can't get 2.6
>> working locally on my mac. I have MySQL 5.0.84 installed with the
>> following settings in sakai.properties:
>>
>> ## MySQL settings - make sure to alter as appropriate
>> vendor at org.sakaiproject.db.api.SqlService=mysql
>> driverClassName at javax.sql.BaseDataSource=com.mysql.jdbc.Driver
>> hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect
>> url at javax.sql.BaseDataSource=jdbc:mysql://127.0.0.1:3306/sakai?
>> useUnicode=true&characterEncoding=UTF-8
>> validationQuery at javax.sql.BaseDataSource=select 1 from DUAL
>> defaultTransactionIsolationString
>> @javax.sql.BaseDataSource=TRANSACTION_READ_COMMITTED
>>
>> I can log in to MySQL just fine with the username and password that
>> I have in sakai.properties. I have created the sakai database with
>> create database sakai default character set utf8;
>> Sakai starts up fine (so the subject of this email is a little
>> misleading), but as soon as I try to login with admin/admin I get
>> the following stack trace and can't proceed. I've dropped and
>> recreated the database a couple times. Anyone have any ideas?
>>
>> Thanks!
>> Nicola
>>
>> 2009-08-20 13:17:58,293 WARN http-8181-Processor25
>> org.sakaiproject.portal.util.ErrorReporter - Bug Report bug-id:
>> 720ace5e-4805-47d0-a9fb-8ad96d8c9b6c user: admin usage-session:
>> 5baa8c1b-01eb-4c4e-a63f-f982c969d581 time: Aug 20, 2009 13:17:58
>> user comment: null stack trace
>> java.lang.AbstractMethodError:
>> org.sakaiproject.authz.impl.SakaiSecurity$$EnhancerByCGLIB$
>> $7cb29c7a.getUserEffectiveRole(Ljava/lang/String;)Ljava/lang/String;
>> at
>> org
>> .sakaiproject
>> .authz
>> .cover.SecurityService.getUserEffectiveRole(SecurityService.java:161)
>> at
>> org
>> .sakaiproject
>> .portal.charon.handlers.SiteHandler.includeTabs(SiteHandler.java:453)
>> at
>> org
>> .sakaiproject
>> .portal.charon.handlers.SiteHandler.includeSiteNav(SiteHandler.java:
>> 370)
>> at
>> org
>> .sakaiproject
>> .portal.charon.handlers.SiteHandler.doSite(SiteHandler.java:219)
>> at
>> org
>> .sakaiproject
>> .portal.charon.handlers.SiteHandler.doGet(SiteHandler.java:113)
>> at
>> org
>> .sakaiproject
>> .portal
>> .charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:768)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
>> at
>> org
>> .apache
>> .catalina
>> .core
>> .ApplicationFilterChain
>> .internalDoFilter(ApplicationFilterChain.java:269)
>> at
>> org
>> .apache
>> .catalina
>> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:
>> 188)
>> at
>> org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:616)
>> at
>> org
>> .apache
>> .catalina
>> .core
>> .ApplicationFilterChain
>> .internalDoFilter(ApplicationFilterChain.java:215)
>> at
>> org
>> .apache
>> .catalina
>> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:
>> 188)
>> at
>> org
>> .apache
>> .catalina
>> .core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
>> at
>> org
>> .apache
>> .catalina
>> .core.StandardContextValve.invoke(StandardContextValve.java:172)
>> at
>> org
>> .apache
>> .catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
>> at
>> org
>> .apache
>> .catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
>> at
>> org
>> .apache
>> .catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:
>> 108)
>> at
>> org
>> .apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:
>> 174)
>> at
>> org
>> .apache.coyote.http11.Http11Processor.process(Http11Processor.java:
>> 875)
>> at org.apache.coyote.http11.Http11BaseProtocol
>> $Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:
>> 665)
>> at
>> org
>> .apache
>> .tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:
>> 528)
>> at
>> org
>> .apache
>> .tomcat
>> .util
>> .net
>> .LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
>> at org.apache.tomcat.util.threads.ThreadPool
>> $ControlRunnable.run(ThreadPool.java:689)
>> at java.lang.Thread.run(Thread.java:613)
>>
>> Tool Placement:
>> No Placement
>>
>> Request:
>> : AuthType:null
>> : CharEncoding:UTF-8
>> : ContentLength:-1
>> : ContentType:null
>> : ContextPath:/portal
>> : LocalAddress:127.0.0.1
>> : LocalName:localhost
>> : LocalPort:8181
>> : Method:GET
>> : PathInfo:/
>> : Protocol:HTTP/1.1
>> : QueryString:null
>> : RemoteAddress:127.0.0.1
>> : RemoteHost:127.0.0.1
>> : RemotePort:62136
>> : Requested URL:http://localhost:8181/portal
>> : Scheme:http
>> : ServerName:localhost
>> : Headers:
>> : Header:host:localhost:8181
>> : Header:user-agent:Mozilla/5.0 (Macintosh; U; Intel Mac OS
>> X 10_5_7; en-us) AppleWebKit/530.18 (KHTML, like Gecko) Version/
>> 4.0.1 Safari/530.18
>> : Header:accept-language:en-us
>> : Header:accept-encoding:gzip, deflate
>> : Header:referer:http://localhost:8181/portal
>> : Header:accept:application/xml,application/xhtml+xml,text/
>> html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
>> : Header:origin:http://localhost:8181
>> : Header:cookie:---censored---
>> : Header:connection:keep-alive
>> : Parameters:
>> : Attributes:
>> :
>> Attribute:sakai.session:org.sakaiproject.tool.impl.SessionComponent
>> $MySession at 457d181f
>> :
>> Attribute:sakai.character.encoding.done:sakai.character.encoding.done
>> : Attribute:sakai.filtered:sakai.filtered
>> Session:
>> : Created:1250788674649
>> : LastAccess:1250788678272
>> : MaxInactive:3600
>> : Attributes:
>> : Attribute:portalskin:defaultskin
>>
>> 2009-08-20 13:17:58,299 WARN http-8181-Processor25
>> org.sakaiproject.email.impl.BasicEmailService - send:
>> javax.mail.internet.AddressException: Illegal address in string ``''
>>
>> _______________________________________________
>> 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"
>
> _______________________________________________
> 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/20090820/d05409dc/attachment.html
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2417 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090820/d05409dc/attachment.bin
More information about the sakai-dev
mailing list