Are the tables in utf8_collation too? Sebastian
2011/4/27 [email protected] <[email protected]>: > Im trying to install openmeetings version 1.6.2 on Windows XP SP3 at > the localhost. But have some troubles, when im staring red5 server. > I have XAMPP with running MySQL database. All configurations in > hibernate.cfg file were done properly, such as name of the database, > username and password. Database in MySQL was created with UTF-8 > Unicode. > But when im starting red5 server in cmd promt ive got some errors, so > there is no red5 server running on. > Below there is information from cmd promt when im starting red5: > > ____________________________________________________________________________________ > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java: > 1052) [mysql > -connector-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603) > [mysql-con > nector-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535) > [mysql-con > nector-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989) > [mysql-connecto > r-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150) > [mysql-conne > ctor-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java: > 2626) [mysq > l-connector-java-5.1.15-bin.jar:na] > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja > va:2119) [mysql-connector-java-5.1.15-bin.jar:na] > at > com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java: > 2281) [mysql-connector-java-5.1.15-bin.jar:na] > at > com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr > oxyPreparedStatement.java:76) [c3p0-0.9.1.jar:0.9.1] > at > org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java: > 208) [hibernate3.jar:3.6.1.Final] > at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) > [hibernate > 3.jar:3.6.1.Final] > at org.hibernate.loader.Loader.doQuery(Loader.java:802) > [hibernate3.jar: > 3.6.1.Final] > at > org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo > ader.java:274) [hibernate3.jar:3.6.1.Final] > at org.hibernate.loader.Loader.doList(Loader.java:2533) > [hibernate3.jar: > 3.6.1.Final] > ... 31 common frames omitted > [WARN] [Red5_Scheduler_Worker-2] > org.hibernate.util.JDBCExceptionReporter - SQL > Error: 1146, SQLState: 42S02 > [ERROR] [Red5_Scheduler_Worker-2] > org.hibernate.util.JDBCExceptionReporter - Tab > le 'openmeetings.recording' doesn't exist > [WARN] [Red5_Scheduler_Worker-1] > org.hibernate.util.JDBCExceptionReporter - SQL > Error: 1146, SQLState: 42S02 > [ERROR] [Red5_Scheduler_Worker-1] > org.hibernate.util.JDBCExceptionReporter - Tab > le 'openmeetings.sessiondata' doesn't exist > [WARN] [Red5_Scheduler_Worker-3] > org.hibernate.util.JDBCExceptionReporter - SQL > Error: 1146, SQLState: 42S02 > [ERROR] [Red5_Scheduler_Worker-3] > org.hibernate.util.JDBCExceptionReporter - Tab > le 'openmeetings.meeting_members' doesn't exist > ERROR 04-27 10:26:40.546 AppointmentDaoImpl.java 4187 1004 > org.openmeetings.app. > data.calendar.daos.AppointmentDaoImpl [Red5_Scheduler_Worker-3] - > Error in getTo > daysAppoitmentsForAllUsers : > org.hibernate.exception.SQLGrammarException: could not execute query > at > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j > ava:92) [hibernate3.jar:3.6.1.Final] > at > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp > er.java:66) [hibernate3.jar:3.6.1.Final] > at org.hibernate.loader.Loader.doList(Loader.java:2536) > [hibernate3.jar: > 3.6.1.Final] > at > org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) [h > ibernate3.jar:3.6.1.Final] > at org.hibernate.loader.Loader.list(Loader.java:2271) > [hibernate3.jar:3. > 6.1.Final] > at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java: > 452) [hibe > rnate3.jar:3.6.1.Final] > at > org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.ja > va:363) [hibernate3.jar:3.6.1.Final] > at > org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java > :196) [hibernate3.jar:3.6.1.Final] > at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268) > [hibernate > 3.jar:3.6.1.Final] > at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) > [hibernate3.jar > :3.6.1.Final] > at > org.openmeetings.app.data.calendar.daos.AppointmentDaoImpl.getTodaysA > ppointmentsForAllUsers(AppointmentDaoImpl.java:998) > [openmeetings.jar:na] > at > org.openmeetings.app.data.calendar.management.AppointmentLogic.doSche > duledMeetingReminder(AppointmentLogic.java:328) [openmeetings.jar:na] > at > org.openmeetings.app.quartz.scheduler.QuartzMeetingReminderJob.execut > e(QuartzMeetingReminderJob.java:18) [openmeetings.jar:na] > at > org.red5.server.scheduling.QuartzSchedulingServiceJob.execute(QuartzS > chedulingServiceJob.java:59) [red5.jar:na] > at org.quartz.core.JobRunShell.run(JobRunShell.java:202) > [quartz-1.6.5.j > ar:1.6.5] > at org.quartz.simpl.SimpleThreadPool > $WorkerThread.run(SimpleThreadPool.j > ava:525) [quartz-1.6.5.jar:1.6.5] > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: > Table 'ope > nmeetings.meeting_members' doesn't exist > at > sun.reflect.GeneratedConstructorAccessor23.newInstance(Unknown Source > ) [na:na] > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC > onstructorAccessorImpl.java:27) [na:1.6.0_25] > at java.lang.reflect.Constructor.newInstance(Constructor.java: > 513) [na:1 > .6.0_25] > at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) [mysql- > connector > -java-5.1.15-bin.jar:na] > at com.mysql.jdbc.Util.getInstance(Util.java:382) [mysql- > connector-java- > 5.1.15-bin.jar:na] > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java: > 1052) [mysql > -connector-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603) > [mysql-con > nector-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535) > [mysql-con > nector-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989) > [mysql-connecto > r-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150) > [mysql-conne > ctor-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java: > 2626) [mysq > l-connector-java-5.1.15-bin.jar:na] > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja > va:2119) [mysql-connector-java-5.1.15-bin.jar:na] > at > com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java: > 2281) [mysql-connector-java-5.1.15-bin.jar:na] > at > com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr > oxyPreparedStatement.java:76) [c3p0-0.9.1.jar:0.9.1] > at > org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java: > 208) [hibernate3.jar:3.6.1.Final] > at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) > [hibernate > 3.jar:3.6.1.Final] > at org.hibernate.loader.Loader.doQuery(Loader.java:802) > [hibernate3.jar: > 3.6.1.Final] > at > org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo > ader.java:274) [hibernate3.jar:3.6.1.Final] > at org.hibernate.loader.Loader.doList(Loader.java:2533) > [hibernate3.jar: > 3.6.1.Final] > ... 13 common frames omitted > ERROR 04-27 10:26:40.546 RecordingDaoImpl.java 4187 123 > org.openmeetings.app.dat > a.record.dao.RecordingDaoImpl [Red5_Scheduler_Worker-2] - > getRecordingsByRoom > org.hibernate.exception.SQLGrammarException: could not execute query > at > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j > ava:92) [hibernate3.jar:3.6.1.Final] > at > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp > er.java:66) [hibernate3.jar:3.6.1.Final] > at org.hibernate.loader.Loader.doList(Loader.java:2536) > [hibernate3.jar: > 3.6.1.Final] > at > org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) [h > ibernate3.jar:3.6.1.Final] > at org.hibernate.loader.Loader.list(Loader.java:2271) > [hibernate3.jar:3. > 6.1.Final] > at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java: > 452) [hibe > rnate3.jar:3.6.1.Final] > at > org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.ja > va:363) [hibernate3.jar:3.6.1.Final] > at > org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java > :196) [hibernate3.jar:3.6.1.Final] > at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268) > [hibernate > 3.jar:3.6.1.Final] > at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) > [hibernate3.jar > :3.6.1.Final] > at > org.openmeetings.app.data.record.dao.RecordingDaoImpl.getRecordingWhi > teboardToConvert(RecordingDaoImpl.java:118) [openmeetings.jar:na] > at > org.openmeetings.app.data.record.WhiteboardConvertionJobManager.initJ > obs(WhiteboardConvertionJobManager.java:89) [openmeetings.jar:na] > at > org.openmeetings.app.quartz.scheduler.QuartzRecordingJob.execute(Quar > tzRecordingJob.java:24) [openmeetings.jar:na] > at > org.red5.server.scheduling.QuartzSchedulingServiceJob.execute(QuartzS > chedulingServiceJob.java:59) [red5.jar:na] > at org.quartz.core.JobRunShell.run(JobRunShell.java:202) > [quartz-1.6.5.j > ar:1.6.5] > at org.quartz.simpl.SimpleThreadPool > $WorkerThread.run(SimpleThreadPool.j > ava:525) [quartz-1.6.5.jar:1.6.5] > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: > Table 'ope > nmeetings.recording' doesn't exist > at > sun.reflect.GeneratedConstructorAccessor23.newInstance(Unknown Source > ) [na:na] > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC > onstructorAccessorImpl.java:27) [na:1.6.0_25] > at java.lang.reflect.Constructor.newInstance(Constructor.java: > 513) [na:1 > .6.0_25] > at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) [mysql- > connector > -java-5.1.15-bin.jar:na] > at com.mysql.jdbc.Util.getInstance(Util.java:382) [mysql- > connector-java- > 5.1.15-bin.jar:na] > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java: > 1052) [mysql > -connector-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603) > [mysql-con > nector-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535) > [mysql-con > nector-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989) > [mysql-connecto > r-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150) > [mysql-conne > ctor-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java: > 2626) [mysq > l-connector-java-5.1.15-bin.jar:na] > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja > va:2119) [mysql-connector-java-5.1.15-bin.jar:na] > at > com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java: > 2281) [mysql-connector-java-5.1.15-bin.jar:na] > at > com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr > oxyPreparedStatement.java:76) [c3p0-0.9.1.jar:0.9.1] > at > org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java: > 208) [hibernate3.jar:3.6.1.Final] > at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) > [hibernate > 3.jar:3.6.1.Final] > at org.hibernate.loader.Loader.doQuery(Loader.java:802) > [hibernate3.jar: > 3.6.1.Final] > at > org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo > ader.java:274) [hibernate3.jar:3.6.1.Final] > at org.hibernate.loader.Loader.doList(Loader.java:2533) > [hibernate3.jar: > 3.6.1.Final] > ... 13 common frames omitted > ERROR 04-27 10:26:40.546 Sessionmanagement.java 4187 574 > org.openmeetings.app.da > ta.basic.Sessionmanagement [Red5_Scheduler_Worker-1] - > [getSessionToDelete]: > org.hibernate.exception.SQLGrammarException: could not execute query > at > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j > ava:92) [hibernate3.jar:3.6.1.Final] > at > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp > er.java:66) [hibernate3.jar:3.6.1.Final] > at org.hibernate.loader.Loader.doList(Loader.java:2536) > [hibernate3.jar: > 3.6.1.Final] > at > org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) [h > ibernate3.jar:3.6.1.Final] > at org.hibernate.loader.Loader.list(Loader.java:2271) > [hibernate3.jar:3. > 6.1.Final] > at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java: > 452) [hibe > rnate3.jar:3.6.1.Final] > at > org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.ja > va:363) [hibernate3.jar:3.6.1.Final] > at > org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java > :196) [hibernate3.jar:3.6.1.Final] > at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268) > [hibernate > 3.jar:3.6.1.Final] > at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) > [hibernate3.jar > :3.6.1.Final] > at > org.openmeetings.app.data.basic.Sessionmanagement.getSessionToDelete( > Sessionmanagement.java:565) [openmeetings.jar:na] > at > org.openmeetings.app.data.basic.Sessionmanagement.clearSessionTable(S > essionmanagement.java:590) [openmeetings.jar:na] > at > org.openmeetings.app.quartz.scheduler.QuartzSessionClear.execute(Quar > tzSessionClear.java:24) [openmeetings.jar:na] > at > org.red5.server.scheduling.QuartzSchedulingServiceJob.execute(QuartzS > chedulingServiceJob.java:59) [red5.jar:na] > at org.quartz.core.JobRunShell.run(JobRunShell.java:202) > [quartz-1.6.5.j > ar:1.6.5] > at org.quartz.simpl.SimpleThreadPool > $WorkerThread.run(SimpleThreadPool.j > ava:525) [quartz-1.6.5.jar:1.6.5] > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: > Table 'ope > nmeetings.sessiondata' doesn't exist > at > sun.reflect.GeneratedConstructorAccessor23.newInstance(Unknown Source > ) [na:na] > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC > onstructorAccessorImpl.java:27) [na:1.6.0_25] > at java.lang.reflect.Constructor.newInstance(Constructor.java: > 513) [na:1 > .6.0_25] > at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) [mysql- > connector > -java-5.1.15-bin.jar:na] > at com.mysql.jdbc.Util.getInstance(Util.java:382) [mysql- > connector-java- > 5.1.15-bin.jar:na] > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java: > 1052) [mysql > -connector-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603) > [mysql-con > nector-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535) > [mysql-con > nector-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989) > [mysql-connecto > r-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150) > [mysql-conne > ctor-java-5.1.15-bin.jar:na] > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java: > 2626) [mysq > l-connector-java-5.1.15-bin.jar:na] > at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja > va:2119) [mysql-connector-java-5.1.15-bin.jar:na] > at > com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java: > 2281) [mysql-connector-java-5.1.15-bin.jar:na] > at > com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr > oxyPreparedStatement.java:76) [c3p0-0.9.1.jar:0.9.1] > at > org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java: > 208) [hibernate3.jar:3.6.1.Final] > at org.hibernate.loader.Loader.getResultSet(Loader.java:1953) > [hibernate > 3.jar:3.6.1.Final] > at org.hibernate.loader.Loader.doQuery(Loader.java:802) > [hibernate3.jar: > 3.6.1.Final] > at > org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Lo > ader.java:274) [hibernate3.jar:3.6.1.Final] > at org.hibernate.loader.Loader.doList(Loader.java:2533) > [hibernate3.jar: > 3.6.1.Final] > ... 13 common frames omitted > ERROR 04-27 10:26:40.625 Sessionmanagement.java 4266 605 > org.openmeetings.app.da > ta.basic.Sessionmanagement [Red5_Scheduler_Worker-1] - > clearSessionTable > java.lang.NullPointerException: null > at > org.openmeetings.app.data.basic.Sessionmanagement.clearSessionTable(S > essionmanagement.java:592) [openmeetings.jar:na] > at > org.openmeetings.app.quartz.scheduler.QuartzSessionClear.execute(Quar > tzSessionClear.java:24) [openmeetings.jar:na] > at > org.red5.server.scheduling.QuartzSchedulingServiceJob.execute(QuartzS > chedulingServiceJob.java:59) [red5.jar:na] > at org.quartz.core.JobRunShell.run(JobRunShell.java:202) > [quartz-1.6.5.j > ar:1.6.5] > at org.quartz.simpl.SimpleThreadPool > $WorkerThread.run(SimpleThreadPool.j > ava:525) [quartz-1.6.5.jar:1.6.5] > ERROR 04-27 10:26:40.593 WhiteboardConvertionJobManager.java 4234 130 > org.openme > etings.app.data.record.WhiteboardConvertionJobManager > [Red5_Scheduler_Worker-2] > - [initJobs] > java.lang.NullPointerException: null > at > org.openmeetings.app.data.record.WhiteboardConvertionJobManager.initJ > obs(WhiteboardConvertionJobManager.java:91) [openmeetings.jar:na] > at > org.openmeetings.app.quartz.scheduler.QuartzRecordingJob.execute(Quar > tzRecordingJob.java:24) [openmeetings.jar:na] > at > org.red5.server.scheduling.QuartzSchedulingServiceJob.execute(QuartzS > chedulingServiceJob.java:59) [red5.jar:na] > at org.quartz.core.JobRunShell.run(JobRunShell.java:202) > [quartz-1.6.5.j > ar:1.6.5] > at org.quartz.simpl.SimpleThreadPool > $WorkerThread.run(SimpleThreadPool.j > ava:525) [quartz-1.6.5.jar:1.6.5] > DEBUG 04-27 10:26:40.640 EmoticonsManager.java 4281 53 > org.openmeetings.app.remo > te.red5.EmoticonsManager [Launcher:/openmeetings] - ##### loadEmot > completed > ____________________________________________________________________________________ > > -- > 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.
