i ve added these in my.ini file in mysqld: collation_server=utf8_unicode_ci character_set_server=utf8
But got the same result..... On 27 апр, 16:26, "[email protected]" <[email protected]> wrote: > in the my.cnf > > character-set-server should > work:http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mys... > > 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... > > >> 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 > > ... > > продолжение >> -- 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.
