[Building Sakai] Starting up Sakai 2.6 on mysql fails?
Anthony Whyte
arwhyte at umich.edu
Thu Aug 20 11:02:35 PDT 2009
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"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090820/b36c6241/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/b36c6241/attachment.bin
More information about the sakai-dev
mailing list