in the my.cnf character-set-server should work: http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_character-set-server
You need to restart mysql after setting the param. Sebastian 2011/4/27 [email protected] <[email protected]>: > But where i should set these parameters? As i see i have to do it in > MySQL console? but i dont know how to get where. > On 27 апр, 15:21, "[email protected]" <[email protected]> > wrote: >> *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#S...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) >> >> ... >> >> продолжение >> > > -- > 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.
