Hmm.....I just started up phpmyadmin and created new database in MySQL with UTF8 collation and new user with all privileges to that database. So there is no any tables cause its new created. There is no any information in manual about creating tables in MySQL database, so i didnt it. Can u explain please how to do this?
On 27 апр, 15:01, "[email protected]" <[email protected]> wrote: > 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 > > ... > > продолжение >> -- 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.
