Thanks. Forgot to restart the mysql server. Works great now. This is truly good stuff. On Jun 12, 2011 11:51 AM, "[email protected]" <[email protected]> wrote: > 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. >
-- 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.
