[Building Sakai] Starting up Sakai 2.6 on mysql fails?
Anthony Whyte
arwhyte at umich.edu
Thu Aug 20 12:51:02 PDT 2009
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/9a820419/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/9a820419/attachment.bin
More information about the sakai-dev
mailing list