I have MySQL data base listening TCP connections. When i wrote in cmd promt netstat -anp, i got this string: TCP 0.0.0.0:3306 0.0.0.0:0 LISTENING
So i just dont get it, why red5 cant connect to MySQL...... On 27 апр, 16:57, "[email protected]" <[email protected]> wrote: > 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 > > ... > > продолжение » -- 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.
