If someone can answer Stephen's question, I'd appreciate some
additional information. Can you also show what properties need to be
set and what values should be used in 2.2 to (1) use HSQL saving to
files and (2) save resource bodies to the filesystem?
Thanks.
Jim
Quoting Stephen Marquard <marquard@xxxxxxxxxxxxxx>:
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.
Jim Eng
jimeng@xxxxxxxxx
734-647-6976
----------------------
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.
