that means that you've missed to configure mysql to use utf8 as default character set. You need to set server-character-set=utf8 in my.cnf, stop openmeetings, restart mysql, drop the database, start openmeetings and run the installer again.
Sebastian 2011/6/12 shawn wilson <[email protected]>: > i have a debian 6 box that i want openmeetings on. i went through the > debian steps (pretty much, i used packages whenever possible). then i > looked at the centos guide and realized that i probably didn't need > half of those packages (and they don't modify the openoffice Startup > file). > > however, where i'm at is, i go to the install, fill out the forum and > it errors. i'm guessing i've got issues with my sql config. i didn't > think i needed to change anything in my mysql_hibernate.cfg.xml other > than the user/pass (that file was moved to hibernate.cfg.xml per the > instructions as well). also, i've checked the db and it has created an > openmeetings db and 20+ tables. here is the error message i'm getting > (it loops): > > > [WARN] [http-0.0.0.0-5080-3] org.hibernate.util.JDBCExceptionReporter > - SQL Error: 1366, SQLState: HY000 > [ERROR] [http-0.0.0.0-5080-3] org.hibernate.util.JDBCExceptionReporter > - Incorrect string value: '\xD0\x92\xD1\x8B \xD0...' for column > 'value' at row 1 > [ERROR] [http-0.0.0.0-5080-3] > org.hibernate.event.def.AbstractFlushingEventListener - Could not > synchronize database state with session > org.hibernate.exception.GenericJDBCException: Could not execute JDBC > batch update > at > org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java: > 140) [hibernate3.jar:3.6.1.Final] > at > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java: > 128) [hibernate3.jar:3.6.1.Final] > at > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java: > 66) [hibernate3.jar:3.6.1.Final] > at > org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java: > 275) [hibernate3.jar:3.6.1.Final] > at > org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268) > [hibernate3.jar:3.6.1.Final] > at > org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184) > [hibernate3.jar:3.6.1.Final] > at > org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java: > 321) [hibernate3.jar:3.6.1.Final] > at > org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java: > 51) [hibernate3.jar:3.6.1.Final] > at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) > [hibernate3.jar:3.6.1.Final] > at > org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383) > [hibernate3.jar:3.6.1.Final] > at > org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java: > 133) [hibernate3.jar:3.6.1.Final] > at > org.openmeetings.app.data.basic.Fieldmanagment.addFieldValueByFieldAndLanguage(Fieldmanagment.java: > 343) [openmeetings.jar:na] > at > org.openmeetings.app.installation.ImportInitvalues.loadInitLanguages(ImportInitvalues.java: > 724) [openmeetings.jar:na] > at > org.openmeetings.servlet.outputhandler.Install.handleRequest(Install.java: > 226) [openmeetings.jar:na] > at > org.apache.velocity.tools.view.servlet.VelocityViewServlet.doRequest(VelocityViewServlet.java: > 541) [velocity-tools-view-1.3.jar:1.3] > at > org.apache.velocity.tools.view.servlet.VelocityViewServlet.doPost(VelocityViewServlet.java: > 517) [velocity-tools-view-1.3.jar:1.3] > at javax.servlet.http.HttpServlet.service(HttpServlet.java: > 637) [javaee-api-5.1.1.jar:5.1.1] > at javax.servlet.http.HttpServlet.service(HttpServlet.java: > 717) [javaee-api-5.1.1.jar:5.1.1] > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: > 290) [catalina-6.0.24.jar:na] > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: > 206) [catalina-6.0.24.jar:na] > at > org.openmeetings.servlet.outputhandler.ServletRequestExFilter.doFilter(ServletRequestExFilter.java: > 35) [openmeetings.jar:na] > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: > 235) [catalina-6.0.24.jar:na] > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: > 206) [catalina-6.0.24.jar:na] > at > org.red5.logging.LoggerContextFilter.doFilter(LoggerContextFilter.java: > 87) [red5.jar:na] > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: > 235) [catalina-6.0.24.jar:na] > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: > 206) [catalina-6.0.24.jar:na] > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: > 233) [catalina-6.0.24.jar:na] > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: > 191) [catalina-6.0.24.jar:na] > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java: > 465) [catalina-6.0.24.jar:na] > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: > 127) [catalina-6.0.24.jar:na] > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: > 102) [catalina-6.0.24.jar:na] > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java: > 555) [catalina-6.0.24.jar:na] > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: > 109) [catalina-6.0.24.jar:na] > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: > 298) [catalina-6.0.24.jar:na] > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java: > 852) [tomcat-coyote-6.0.24.jar:na] > at org.apache.coyote.http11.Http11Protocol > $Http11ConnectionHandler.process(Http11Protocol.java:588) [tomcat- > coyote-6.0.24.jar:na] > at org.apache.tomcat.util.net.JIoEndpoint > $Worker.run(JIoEndpoint.java:489) [tomcat-coyote-6.0.24.jar:na] > at java.lang.Thread.run(Thread.java:662) [na:1.6.0_24] > Caused by: java.sql.BatchUpdateException: Incorrect string value: > '\xD0\x92\xD1\x8B \xD0...' for column 'value' at row 1 > at > com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java: > 2024) [mysql-connector-java-5.1.15-bin.jar:na] > at > com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java: > 1449) [mysql-connector-java-5.1.15-bin.jar:na] > at > com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java: > 1723) [c3p0-0.9.1.jar:0.9.1] > at > org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java: > 70) [hibernate3.jar:3.6.1.Final] > at > org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java: > 268) [hibernate3.jar:3.6.1.Final] > ... 34 common frames omitted > Caused by: java.sql.SQLException: Incorrect string value: > '\xD0\x92\xD1\x8B \xD0...' for column 'value' at row 1 > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java: > 1073) [mysql-connector-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603) > [mysql-connector-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535) > [mysql-connector-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989) > [mysql-connector-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150) > [mysql-connector-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java: > 2626) [mysql-connector-java-5.1.15-bin.jar:na] > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java: > 2119) [mysql-connector-java-5.1.15-bin.jar:na] > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java: > 2415) [mysql-connector-java-5.1.15-bin.jar:na] > at > com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java: > 1976) [mysql-connector-java-5.1.15-bin.jar:na] > ... 38 common frames omitted > ERROR 06-12 16:27:56.395 Fieldmanagment.java 150046 348 > org.openmeetings.app.data.basic.Fieldmanagment [http-0.0.0.0-5080-3] - > [getConfKey]: > org.hibernate.exception.GenericJDBCException: Could not execute JDBC > batch update > at > org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java: > 140) [hibernate3.jar:3.6.1.Final] > at > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java: > 128) [hibernate3.jar:3.6.1.Final] > at > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java: > 66) [hibernate3.jar:3.6.1.Final] > at > org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java: > 275) [hibernate3.jar:3.6.1.Final] > at > org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268) > [hibernate3.jar:3.6.1.Final] > at > org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184) > [hibernate3.jar:3.6.1.Final] > at > org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java: > 321) [hibernate3.jar:3.6.1.Final] > at > org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java: > 51) [hibernate3.jar:3.6.1.Final] > at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) > [hibernate3.jar:3.6.1.Final] > at > org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383) > [hibernate3.jar:3.6.1.Final] > at > org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java: > 133) [hibernate3.jar:3.6.1.Final] > at > org.openmeetings.app.data.basic.Fieldmanagment.addFieldValueByFieldAndLanguage(Fieldmanagment.java: > 343) [openmeetings.jar:na] > at > org.openmeetings.app.installation.ImportInitvalues.loadInitLanguages(ImportInitvalues.java: > 724) [openmeetings.jar:na] > at > org.openmeetings.servlet.outputhandler.Install.handleRequest(Install.java: > 226) [openmeetings.jar:na] > at > org.apache.velocity.tools.view.servlet.VelocityViewServlet.doRequest(VelocityViewServlet.java: > 541) [velocity-tools-view-1.3.jar:1.3] > at > org.apache.velocity.tools.view.servlet.VelocityViewServlet.doPost(VelocityViewServlet.java: > 517) [velocity-tools-view-1.3.jar:1.3] > at javax.servlet.http.HttpServlet.service(HttpServlet.java: > 637) [javaee-api-5.1.1.jar:5.1.1] > at javax.servlet.http.HttpServlet.service(HttpServlet.java: > 717) [javaee-api-5.1.1.jar:5.1.1] > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: > 290) [catalina-6.0.24.jar:na] > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: > 206) [catalina-6.0.24.jar:na] > at > org.openmeetings.servlet.outputhandler.ServletRequestExFilter.doFilter(ServletRequestExFilter.java: > 35) [openmeetings.jar:na] > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: > 235) [catalina-6.0.24.jar:na] > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: > 206) [catalina-6.0.24.jar:na] > at > org.red5.logging.LoggerContextFilter.doFilter(LoggerContextFilter.java: > 87) [red5.jar:na] > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: > 235) [catalina-6.0.24.jar:na] > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: > 206) [catalina-6.0.24.jar:na] > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: > 233) [catalina-6.0.24.jar:na] > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: > 191) [catalina-6.0.24.jar:na] > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java: > 465) [catalina-6.0.24.jar:na] > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: > 127) [catalina-6.0.24.jar:na] > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: > 102) [catalina-6.0.24.jar:na] > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java: > 555) [catalina-6.0.24.jar:na] > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: > 109) [catalina-6.0.24.jar:na] > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: > 298) [catalina-6.0.24.jar:na] > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java: > 852) [tomcat-coyote-6.0.24.jar:na] > at org.apache.coyote.http11.Http11Protocol > $Http11ConnectionHandler.process(Http11Protocol.java:588) [tomcat- > coyote-6.0.24.jar:na] > at org.apache.tomcat.util.net.JIoEndpoint > $Worker.run(JIoEndpoint.java:489) [tomcat-coyote-6.0.24.jar:na] > at java.lang.Thread.run(Thread.java:662) [na:1.6.0_24] > Caused by: java.sql.BatchUpdateException: Incorrect string value: > '\xD0\x92\xD1\x8B \xD0...' for column 'value' at row 1 > at > com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java: > 2024) [mysql-connector-java-5.1.15-bin.jar:na] > at > com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java: > 1449) [mysql-connector-java-5.1.15-bin.jar:na] > at > com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java: > 1723) [c3p0-0.9.1.jar:0.9.1] > at > org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java: > 70) [hibernate3.jar:3.6.1.Final] > at > org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java: > 268) [hibernate3.jar:3.6.1.Final] > ... 34 common frames omitted > Caused by: java.sql.SQLException: Incorrect string value: > '\xD0\x92\xD1\x8B \xD0...' for column 'value' at row 1 > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java: > 1073) [mysql-connector-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603) > [mysql-connector-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535) > [mysql-connector-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989) > [mysql-connector-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150) > [mysql-connector-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java: > 2626) [mysql-connector-java-5.1.15-bin.jar:na] > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java: > 2119) [mysql-connector-java-5.1.15-bin.jar:na] > at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java: > 2415) [mysql-connector-java-5.1.15-bin.jar:na] > at > com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java: > 1976) [mysql-connector-java-5.1.15-bin.jar:na] > ... 38 common frames omitted > > -- > You received this message because you are subscribed to the Google Groups > "OpenMeetings User" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/openmeetings-user?hl=en. > > -- Sebastian Wagner http://www.webbase-design.de http://openmeetings.googlecode.com http://www.wagner-sebastian.com [email protected] -- You received this message because you are subscribed to the Google Groups "OpenMeetings User" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/openmeetings-user?hl=en.
