[Building Sakai] Starting up Sakai 2.6 on mysql fails?
Nicola Monat-Jacobs
nicola at nyu.edu
Thu Aug 20 14:07:46 PDT 2009
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"
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090820/e2feabcc/attachment.html
More information about the sakai-dev
mailing list