[Building Sakai] Starting up Sakai 2.6 on mysql fails?
Nicola Monat-Jacobs
nicola at nyu.edu
Thu Aug 20 12:14:13 PDT 2009
Unfortunately, Anthony's suggestion didn't work, but Stephen suggested
(offline) the following. Wanted to post for posterity.
On Aug 20, 2009, at 3:04 PM, Stephen Marquard wrote:
> Hi Nicola,
>
> My UCT mail is down at the moment so I can't post to sakai-dev, but
> your 2-6-x failure is probably a result of having older (pre-2.6.0)
> build artefacts in your tomcat deployment or possibly maven repo.
>
> You should start with a clean tomcat every time.
>
> Here's a build / install script for building on a Linux box.
>
> http://source.cet.uct.ac.za/svn/sakai/build/branches/sakai-trunk/sakai-build.sh
> http://source.cet.uct.ac.za/svn/sakai/build/branches/sakai-trunk/sakai-install.sh
>
> (installs into /usr/local/sakai/). I use something very similar on
> my Mac.
>
> Cheers
> Stephen
>
On Aug 20, 2009, at 2:23 PM, Anthony Whyte wrote:
> 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/346ab445/attachment.html
More information about the sakai-dev
mailing list