are you using mysql5 the latest one? Did you see that there are two mysql hibernate configs? One for mysql5/latest mysql and the other one still for older mysql database servers. The two configs have different JDBC-Driver configurations.
Sebastian 2011/7/7 syed abdul nadeem <[email protected]>: > Sebastian, > Thats exactly right! This occurs during the installation itself and none of > the tables are being created upon running the Red5 batch file. > We were able to successfully install it until last week, but suddenly upon > trying the same installation on a fresh system gives the mentioned error. > Let me know if you need any more detailed log files to understand the root > cause. > Regards, > Syed / Ambarish > > On Thu, Jul 7, 2011 at 3:00 PM, [email protected] > <[email protected]> wrote: >> >> that sounds a lot like an actual installation issue. >> What database are you using? Did you check if the database and the >> tables are created during installation process? >> I guess there is not a single table as the application was never able >> to connect to the database? >> >> Sebastian >> >> 2011/7/6 ambairish kumar <[email protected]>: >> > >> > Table does not error while running openmeetings .. >> > >> > what might have gone wronge......:) >> > >> > >> > >> > >> > ERROR 07-06 20:58:32.374 AppointmentDaoImpl.java 40359 1004 >> > org.openmeetings.app.data.calendar.daos.AppointmentDaoImpl >> > [Red5_Scheduler_Worker-4] - Error in getTodaysAppoitmentsForA >> > llUsers : >> > org.hibernate.exception.SQLGrammarException: could not execute query >> > at >> > >> > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92) >> > [hibernate3.jar:3.6.1.Final] >> > at >> > >> > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.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) >> > [hibernate3.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) >> > [hibernate3.jar:3.6.1.Final] >> > at >> > >> > org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java: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) >> > [hibernate3.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.getTodaysAppointmentsForAllUsers(AppointmentDaoImpl.java:998) >> > [openmeetings.jar:na] >> > at >> > >> > org.openmeetings.app.data.calendar.management.AppointmentLogic.doScheduledMeetingReminder(AppointmentLogic.java:331) >> > [openmeetings.jar:na] >> > at >> > >> > org.openmeetings.app.quartz.scheduler.QuartzMeetingReminderJob.execute(QuartzMeetingReminderJob.java:18) >> > [openmeetings.jar:na] >> > at >> > >> > org.red5.server.scheduling.QuartzSchedulingServiceJob.execute(QuartzSchedulingServiceJob.java:59) >> > [red5.jar:na] >> > at org.quartz.core.JobRunShell.run(JobRunShell.java:202) >> > [quartz-1.6.5.jar:1.6.5] >> > at >> > >> > org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525) >> > [quartz-1.6.5.jar:1.6.5] >> > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: >> > Table >> > 'openmeetings.meeting_members' doesn't exist >> > at >> > sun.reflect.GeneratedConstructorAccessor23.newInstance(Unknown >> > Source) [na:na] >> > at >> > >> > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) >> > [na:1.6.0] >> > at >> > java.lang.reflect.Constructor.newInstance(Constructor.java:513) >> > [na:1.6.0] >> > 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-connector-java-5.1.15-bin.jar:na] >> > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535) >> > [mysql-connector-java-5.1.15-bin.jar:na] >> > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989) >> > [mysql-connector-java-5.1.15-bin.jar:na] >> > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150) >> > [mysql-connector-java-5.1.15-bin.jar:na] >> > at >> > com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626) >> > [mysql-connector-java-5.1.15-bin.jar:na] >> > at >> > >> > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java: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(NewProxyPreparedStatement.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) >> > [hibernate3.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(Loader.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 07-06 20:58:35.249 Sessionmanagement.java 43234 605 >> > org.openmeetings.app.data.basic.Sessionmanagement >> > [Red5_Scheduler_Worker-2] >> > - clearSessionTable >> > java.lang.NullPointerException: null >> > at >> > >> > org.openmeetings.app.data.basic.Sessionmanagement.clearSessionTable(Sessionmanagement.java:592) >> > [openmeetings.jar:na] >> > at >> > >> > org.openmeetings.app.quartz.scheduler.QuartzSessionClear.execute(QuartzSessionClear.java:24) >> > [openmeetings.jar:na] >> > at >> > >> > org.red5.server.scheduling.QuartzSchedulingServiceJob.execute(QuartzSchedulingServiceJob.java:59) >> > [red5.jar:na] >> > at org.quartz.core.JobRunShell.run(JobRunShell.java:202) >> > [quartz-1.6.5.jar:1.6.5] >> > at >> > >> > org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525) >> > [quartz-1.6.5.jar:1.6.5] >> > >> > >> > -- >> > Ambarish Kumar Lowsarwar >> > >> > -- >> > 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. >> > > -- > 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.
