*There is no any > information in manual about creating tables in MySQL database* => no there isn't but the problem is that you need to set the default-character-set=utf8 or server-character-set=utf8 so that the tables are created with utf8
http://code.google.com/p/openmeetings/wiki/InstallationOpenMeetings#Software_Requirements_/_Dependencies http://dev.mysql.com/doc/refman/5.0/en/charset-server.html If NO tables are created at all the host/user/pass of mysql is wrong or mysql does not listen TCP/IP. Sebastian 2011/4/27 [email protected] <[email protected]>: > 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. > > -- 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.
