[Building Sakai] Starting up Sakai 2.6 on mysql fails?

Stephen Marquard stephen.marquard at uct.ac.za
Thu Aug 20 22:36:23 PDT 2009


My tomcat theory is based on this error:

java.lang.AbstractMethodError: org.sakaiproject.authz.impl.SakaiSecurity$$EnhancerByCGLIB$$7cb29c7a.getUserEffectiveRole(Ljava/lang/String;)Ljava/lang/String;

because getUserEffectiveRole was a method added to the SecurityService API (in the kernel) during 2-6-x development but before 2.6.0 release.

If it's not a problem of conflicting jars of different versions, then maybe some other classloader issue? Are you building & running with jdk 1.5? 

Regards
Stephen
 
>>> Nicola Monat-Jacobs <nicola at nyu.edu> 8/20/2009 11:07 PM >>> 
Still can't get rid of this error (now after two fresh tomcat rounds)...

In the interest of full disclosure, I do have another tomcat running  
on a different port - xythos is on 8080 and sakai on 8181 (separate  
tomcats). Perhaps this might be causing the clash Stephen is alluding  
to?

Also, I'm now using hibernate.dialect=org.hibernate.dialect.MySQLDialect

Thanks,
Nicola

On Aug 20, 2009, at 3:51 PM, Anthony Whyte wrote:

> Indeed, an unwashed Tomcat is a foul thing.
>
> Anth
>
>
>
> On Aug 20, 2009, at 3:14 PM, Nicola Monat-Jacobs wrote:
>
>> 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"
>>>
>>
>




More information about the sakai-dev mailing list