2.2 trunk and mysql

Hi,

Has anyone successfully run the 2.2 trunk with mysql yet?

I get two errors - one is from course-management, where mysql complains about a 
key length being too long, and the other is this which causes it not to render 
the gateway site at /portal/. It starts up OK with HSQL.

My sakai.properties settings are:

---
auto.ddl=true
hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect

vendor@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx=mysql
driverClassName@xxxxxxxxxxxxxxxxxxxxxxxx=com.mysql.jdbc.Driver
validationQuery@xxxxxxxxxxxxxxxxxxxxxxxx=select 1 from DUAL
defaultTransactionIsolationString@xxxxxxxxxxxxxxxxxxxxxxxx=TRANSACTION_READ_COMMITTED
username@xxxxxxxxxxxxxxxxxxxxxxxx=XXX
password@xxxxxxxxxxxxxxxxxxxxxxxx=XXX
url@xxxxxxxxxxxxxxxxxxxxxxxx=jdbc:mysql://hostname:3306/sakai22?useUnicode=true&characterEncoding=UTF-8
---

catalina.out logs this:

WARN: Sql.dbRead: sql: select count(1) from SAKAI_REALM_RL_FN,SAKAI_REALM force 
index (AK_SAKAI_REALM_ID) where SAKAI_REALM_RL_FN.REALM_KEY = 
SAKAI_REALM.REALM_KEY and SAKAI_REALM.REALM_ID in (?,?,?) and FUNCTION_KEY in 
(select FUNCTION_KEY from SAKAI_REALM_FUNCTION where FUNCTION_NAME = ?) and 
(ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_RL_GR where ACTIVE = '1' and 
USER_ID = ? and REALM_KEY in (select REALM_KEY from SAKAI_REALM where REALM_ID 
in (?,?,?))) or ROLE_KEY in (select ROLE_KEY from SAKAI_REALM_ROLE where 
ROLE_NAME = '.anon') ) /site/!gateway !user.template !site.helper site.visit 
/site/!gateway !user.template !site.helper (2006-04-29 22:32:53,310
http-8080-Processor24_org.sakaiproject.db.impl.BasicSqlService)
java.sql.SQLException: Key column 'AK_SAKAI_REALM_ID' doesn't exist in table
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
at 
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
at 
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)
at 
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at 
org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:369)
at 
org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:293)
at 
org.sakaiproject.authz.impl.DbAuthzGroupService$DbStorage.isAllowed(DbAuthzGroupService.java:1287)
at 
org.sakaiproject.authz.impl.BaseAuthzGroupService.isAllowed(BaseAuthzGroupService.java:730)
at 
org.sakaiproject.authz.impl.SakaiSecurity.checkAuthzGroups(SakaiSecurity.java:271)
at org.sakaiproject.authz.impl.SakaiSecurity.unlock(SakaiSecurity.java:242)
at org.sakaiproject.authz.impl.SakaiSecurity.unlock(SakaiSecurity.java:202)
at 
org.sakaiproject.site.impl.BaseSiteService.unlockCheck(BaseSiteService.java:158)
at 
org.sakaiproject.site.impl.BaseSiteService.unlock(BaseSiteService.java:178)
at 
org.sakaiproject.site.impl.BaseSiteService.getSiteVisit(BaseSiteService.java:694)
at 
org.sakaiproject.site.cover.SiteService.getSiteVisit(SiteService.java:122)
at 
org.sakaiproject.portal.charon.CharonPortal.doSite(CharonPortal.java:1022)
at org.sakaiproject.portal.charon.CharonPortal.doGet(CharonPortal.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:525)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at 
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at 
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at 
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)

Regards
Stephen

--
Stephen Marquard
Learning Technologies Co-ordinator, Centre for Educational Technology
Centre for Higher Education Development, University of Cape Town
Email: marquard@xxxxxxxxxxxxxx IM: xmpp:marquard@xxxxxxxxxxxxxx
Cell: +27-83-500-5290

----------------------
This automatic notification message was sent by Sakai Collab 
(http://collab.sakaiproject.org/portal) from the DG: Development site.
You can modify how you receive notifications at My Workspace > Preferences.