#5 Installation issue with Jetty 5.1.11RC0
Hi,
I've installed infoglue 2.3 (final) on Mac OS X, using
MySQL 5.0 + Jetty 5.1, portlet enabled.
After converting the infoglue db to utf8, removing the
WEBINF xercesImpl jar in each of the infoglue webapps
to address a problem with Jetty's and adding the
portlet-API and apache-pluto jars in, the webapps
initialized ok and I can see the login screen.
Unfortunately, once I signed in as root, the screen
keeps on flashing and the error log fills with the
following exceptions. Same behavior on Firefox or Camino.
Any pointer appreciated, thanks
-Stephane
=================================
[java] 12 Jun 2006 23:07:41.773 [ERROR] [P1-18]
[org.infoglue.cms.controllers.kernel.impl.simple.ContentController]
- An error occurred so we should not complete the
transaction:org.infoglue.cms.exception.SystemException:
An error occurred when we tried to commit an
transaction. Reason:Nested error:
org.exolab.castor.jdo.PersistenceException: Nested
error: java.sql.SQLException: Illegal mix of collations
(latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '=': Illegal
mix of collations (latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '=': Nested
error: java.sql.SQLException: Illegal mix of collations
(latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '=': Illegal
mix of collations (latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '='
[java] org.infoglue.cms.exception.SystemException:
An error occurred when we tried to commit an
transaction. Reason:Nested error:
org.exolab.castor.jdo.PersistenceException: Nested
error: java.sql.SQLException: Illegal mix of collations
(latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '=': Illegal
mix of collations (latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '=': Nested
error: java.sql.SQLException: Illegal mix of collations
(latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '=': Illegal
mix of collations (latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '='
[java] at
org.infoglue.cms.controllers.kernel.impl.simple.BaseController.commitTransaction(BaseController.java:1092)
[java] at
org.infoglue.cms.controllers.kernel.impl.simple.ContentController.getRootContentVO(ContentController.java:973)
[java] at
org.infoglue.cms.treeservice.ss.ContentNodeSupplier.<init>(ContentNodeSupplier.java:70)
[java] at
org.infoglue.cms.applications.contenttool.actions.ViewContentToolMenuHtmlAction.getNodeSupplier(ViewContentToolMenuHtmlAction.java:102)
[java] at
org.infoglue.cms.applications.common.actions.TreeViewAbstractAction.initialize(TreeViewAbstractAction.java:26)
[java] at
org.infoglue.cms.applications.common.actions.TreeViewAbstractAction.doExecute(TreeViewAbstractAction.java:35)
[java] at
org.infoglue.cms.applications.common.actions.WebworkAbstractAction.execute(WebworkAbstractAction.java:106)
[java] at
webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:131)
[java] at
webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:174)
[java] at
org.infoglue.deliver.portal.dispatcher.DeliveryServletDispatcher.service(DeliveryServletDispatcher.java:66)
[java] at
org.infoglue.deliver.portal.dispatcher.PortalServletDispatcher.service(PortalServletDispatcher.java:176)
[java] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
[java] at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
[java] at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830)
[java] at
org.infoglue.cms.security.InfoGlueAuthenticationFilter.doFilter(InfoGlueAuthenticationFilter.java:155)
[java] at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
[java] at
org.infoglue.cms.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:118)
[java] at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
[java] at
org.infoglue.deliver.applications.filters.CacheEvictionFilter.doFilter(CacheEvictionFilter.java:85)
[java] at
org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
[java] at
org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471)
[java] at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
[java] at
org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
[java] at
org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633)
[java] at
org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
[java] at
org.mortbay.http.HttpServer.service(HttpServer.java:909)
[java] at
org.mortbay.http.HttpConnection.service(HttpConnection.java:820)
[java] at
org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:986)
[java] at
org.mortbay.http.HttpConnection.handle(HttpConnection.java:837)
[java] at
org.mortbay.http.SocketListener.handleConnection(SocketListener.java:245)
[java] at
org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
[java] at
org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
[java] Caused by:
org.exolab.castor.jdo.TransactionAbortedException:
Nested error:
org.exolab.castor.jdo.PersistenceException: Nested
error: java.sql.SQLException: Illegal mix of collations
(latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '=': Illegal
mix of collations (latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '=': Nested
error: java.sql.SQLException: Illegal mix of collations
(latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '=': Illegal
mix of collations (latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '='
[java] at
org.exolab.castor.persist.TransactionContext.prepare(TransactionContext.java:1654)
[java] at
org.exolab.castor.jdo.engine.DatabaseImpl.commit(DatabaseImpl.java:545)
[java] at
org.infoglue.cms.controllers.kernel.impl.simple.BaseController.commitTransaction(BaseController.java:1087)
[java] ... 31 more
[java] Caused by:
org.exolab.castor.jdo.PersistenceException: Nested
error: java.sql.SQLException: Illegal mix of collations
(latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '=': Illegal
mix of collations (latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '='
[java] at
org.exolab.castor.jdo.engine.SQLEngine.store(SQLEngine.java:942)
[java] at
org.exolab.castor.persist.ClassMolder.store(ClassMolder.java:1620)
[java] at
org.exolab.castor.persist.LockEngine.store(LockEngine.java:755)
[java] at
org.exolab.castor.persist.TransactionContext.prepare(TransactionContext.java:1599)
[java] ... 33 more
[java] Caused by: java.sql.SQLException: Illegal
mix of collations (latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '='
[java] at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
[java] at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
[java] at
com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1366)
[java] at
com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:952)
[java] at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1974)
[java] at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1897)
[java] at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1758)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
[java] at
org.exolab.castor.jdo.engine.SQLEngine.store(SQLEngine.java:891)
[java] ... 36 more
Logged In: NO
If this can be of help for Mac OS X users, I resolved the
issue by doing the following:
On MySQL:
- setup global options to utf8 for all character set and
collation variables: client, connection, server
- in infoglue db:
--> run alter table <infoglue_table> convert character set
utf8 collation utf8_general_ci
In Infoglue webapp dirs:
- create under Jetty home ./conf/Catalina/localhost
- create under Jetty home ./shared/lib
- u: root p: 6aaqj5
- removed xercesImpl.jar from Infoglue WEBINF/lib webapp dirs
- added log4j in jetty/ext
- convert infoglue db to utf8 as root, mysql> select "alter
table ",table_name," convert to character set utf8 collate
utf8_unicode_ci;" from information_schema.tables where
table_schema="infoglue";
- change webapps/.../database.xml, characterEncoding=utf8
(vs UTF-8)
- change webapps/.../database.xml, hibernate_cfg.xml,
propertyset.xml any references from ISO-8859 to UTF-8
- update the mysql jdbc parameters to: "
jdbc:mysql://localhost:3306/infoglue?autoReconnect=true&useUnicode=true&characterEncoding=utf8&connectionCollation=utf8_general_ci&characterSetResults=utf8
Browser:
- Firefox 1.0.6 was creating the flashing, but safari 2.0.3
is working ok