I'm looking for suggestions on where to look for diagnostic information. I'm trying to set up a small openmeetings server. I'm having trouble getting started so I set up a clean base Debian 5.0 server to minimize the number of variables I'm chasing. I don't really understand what's happening "behind the curtain" but I'm trying to learn.
I'm using the red5-openmeetings_1.0.2760.noarch.deb package. The Debian repositories have dropped swftools for want of a maintainer. I couldn't resolve a libjpeg problem creating 0.9.0 from source so I used swftools_0.9.0-0ubuntu1_i386.deb which seems to work fine. I thought a had a probelm with IPv4 ports not being bound, but Sebastian Wagner helped me learn there wasn't a problem (Thanks!) It looks like next hurdle is MySQL related. I'm not finding the openmeeting database. The user has been created, but no database has been. When I try and run http://xx.xx.xx.xx:5080/openmeetings/install the console scrolls messages as fast as it can. It alll seems related to this basic error: Caused by: java.sql.SQLException: No database selected I haven't spotted the installation code that creates the database, or a log file that indicates what the original failure might have been. I was going to create the database by hand, but I'm not sure of it's structure. I'm also not seeing the behavior I expect with the red5 install. I get the index page and the installation page comes up and lets me select and install demos, but when I try and run them I get a 404 page that says "*description* _The requested resource (/demos) is not available._" If I go back and try and reselect the demo for installation, I get the indication that it's already installed. Here's a generous snippet of the loop of what I'm seeing when I try and connect: ------------------------------------------------------------------------------------------------------------ t org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:567) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) [catalina-6.0.20-patched.jar:na] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:847) [tomcat-coyote-6.0.20-patched.jar:na] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) [tomcat-coyote-6.0.20-patched.jar:na] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) [tomcat-coyote-6.0.20-patched.jar:na] at java.lang.Thread.run(Thread.java:619) [na:1.6.0_12] Caused by: java.sql.SQLException: No database selected at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) [mysql-connector-java-5.1.7-bin.jar:na] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) [mysql-connector-java-5.1.7-bin.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515) [mysql-connector-java-5.1.7-bin.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447) [mysql-connector-java-5.1.7-bin.jar:na] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) [mysql-connector-java-5.1.7-bin.jar:na] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) [mysql-connector-java-5.1.7-bin.jar:na] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554) [mysql-connector-java-5.1.7-bin.jar:na] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761) [mysql-connector-java-5.1.7-bin.jar:na] at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1912) [mysql-connector-java-5.1.7-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.id.IncrementGenerator.getNext(IncrementGenerator.java:109) [hibernate3.jar:na] ... 37 common frames omitted [WARN] [http-5080-3] org.hibernate.util.JDBCExceptionReporter - SQL Error: 1046, SQLState: 3D000 [ERROR] [http-5080-3] org.hibernate.util.JDBCExceptionReporter - No database selected ERROR 02-20 15:15:10.702 Fieldmanagment.java 313291 331 org.openmeetings.app.data.basic.Fieldmanagment [http-5080-3] - [getConfKey]: org.hibernate.exception.GenericJDBCException: could not fetch initial value for increment generator at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126) [hibernate3.jar:na] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114) [hibernate3.jar:na] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) [hibernate3.jar:na] at org.hibernate.id.IncrementGenerator.getNext(IncrementGenerator.java:131) [hibernate3.jar:na] at org.hibernate.id.IncrementGenerator.generate(IncrementGenerator.java:68) [hibernate3.jar:na] at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:122) [hibernate3.jar:na] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210) [hibernate3.jar:na] at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56) [hibernate3.jar:na] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195) [hibernate3.jar:na] at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50) [hibernate3.jar:na] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93) [hibernate3.jar:na] at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:562) [hibernate3.jar:na] at org.hibernate.impl.SessionImpl.save(SessionImpl.java:550) [hibernate3.jar:na] at org.hibernate.impl.SessionImpl.save(SessionImpl.java:546) [hibernate3.jar:na] at org.openmeetings.app.data.basic.Fieldmanagment.addFieldValueByFieldAndLanguage(Fieldmanagment.java:324) [openmeetings.jar:na] at org.openmeetings.app.installation.ImportInitvalues.loadInitLanguages(ImportInitvalues.java:497) [openmeetings.jar:na] at org.openmeetings.servlet.outputhandler.Install.handleRequest(Install.java:178) [openmeetings.jar:na] at org.apache.velocity.tools.view.servlet.VelocityViewServlet.doRequest(VelocityViewServlet.java:541) [velocity-tools-view-1.3.jar:1.3] at org.apache.velocity.tools.view.servlet.VelocityViewServlet.doPost(VelocityViewServlet.java:517) [velocity-tools-view-1.3.jar:1.3] at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) [javaee-api-5.1.0-RC3.jar:5.1.0-RC3] at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) [javaee-api-5.1.0-RC3.jar:5.1.0-RC3] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina-6.0.20-patched.jar:na] at org.openmeetings.servlet.outputhandler.ServletRequestExFilter.doFilter(ServletRequestExFilter.java:35) [openmeetings.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina-6.0.20-patched.jar:na] at org.red5.logging.LoggerContextFilter.doFilter(LoggerContextFilter.java:70) [red5.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:567) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) [catalina-6.0.20-patched.jar:na] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:847) [tomcat-coyote-6.0.20-patched.jar:na] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) [tomcat-coyote-6.0.20-patched.jar:na] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) [tomcat-coyote-6.0.20-patched.jar:na] at java.lang.Thread.run(Thread.java:619) [na:1.6.0_12] Caused by: java.sql.SQLException: No database selected at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) [mysql-connector-java-5.1.7-bin.jar:na] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) [mysql-connector-java-5.1.7-bin.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515) [mysql-connector-java-5.1.7-bin.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447) [mysql-connector-java-5.1.7-bin.jar:na] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) [mysql-connector-java-5.1.7-bin.jar:na] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) [mysql-connector-java-5.1.7-bin.jar:na] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554) [mysql-connector-java-5.1.7-bin.jar:na] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761) [mysql-connector-java-5.1.7-bin.jar:na] at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1912) [mysql-connector-java-5.1.7-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.id.IncrementGenerator.getNext(IncrementGenerator.java:109) [hibernate3.jar:na] ... 37 common frames omitted [WARN] [http-5080-1] org.hibernate.util.JDBCExceptionReporter - SQL Error: 1046, SQLState: 3D000 [ERROR] [http-5080-1] org.hibernate.util.JDBCExceptionReporter - No database selected ERROR 02-20 15:15:10.713 Fieldmanagment.java 313302 331 org.openmeetings.app.data.basic.Fieldmanagment [http-5080-1] - [getConfKey]: org.hibernate.exception.GenericJDBCException: could not fetch initial value for increment generator at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126) [hibernate3.jar:na] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114) [hibernate3.jar:na] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) [hibernate3.jar:na] at org.hibernate.id.IncrementGenerator.getNext(IncrementGenerator.java:131) [hibernate3.jar:na] at org.hibernate.id.IncrementGenerator.generate(IncrementGenerator.java:68) [hibernate3.jar:na] at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:122) [hibernate3.jar:na] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210) [hibernate3.jar:na] at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56) [hibernate3.jar:na] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195) [hibernate3.jar:na] at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50) [hibernate3.jar:na] at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93) [hibernate3.jar:na] at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:562) [hibernate3.jar:na] at org.hibernate.impl.SessionImpl.save(SessionImpl.java:550) [hibernate3.jar:na] at org.hibernate.impl.SessionImpl.save(SessionImpl.java:546) [hibernate3.jar:na] at org.openmeetings.app.data.basic.Fieldmanagment.addFieldValueByFieldAndLanguage(Fieldmanagment.java:324) [openmeetings.jar:na] at org.openmeetings.app.installation.ImportInitvalues.loadInitLanguages(ImportInitvalues.java:497) [openmeetings.jar:na] at org.openmeetings.servlet.outputhandler.Install.handleRequest(Install.java:178) [openmeetings.jar:na] at org.apache.velocity.tools.view.servlet.VelocityViewServlet.doRequest(VelocityViewServlet.java:541) [velocity-tools-view-1.3.jar:1.3] at org.apache.velocity.tools.view.servlet.VelocityViewServlet.doPost(VelocityViewServlet.java:517) [velocity-tools-view-1.3.jar:1.3] at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) [javaee-api-5.1.0-RC3.jar:5.1.0-RC3] at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) [javaee-api-5.1.0-RC3.jar:5.1.0-RC3] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina-6.0.20-patched.jar:na] at org.openmeetings.servlet.outputhandler.ServletRequestExFilter.doFilter(ServletRequestExFilter.java:35) [openmeetings.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina-6.0.20-patched.jar:na] at org.red5.logging.LoggerContextFilter.doFilter(LoggerContextFilter.java:70) [red5.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:567) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [catalina-6.0.20-patched.jar:na] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) [catalina-6.0.20-patched.jar:na] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:847) [tomcat-coyote-6.0.20-patched.jar:na] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) [tomcat-coyote-6.0.20-patched.jar:na] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) [tomcat-coyote-6.0.20-patched.jar:na] at java.lang.Thread.run(Thread.java:619) [na:1.6.0_12] Caused by: java.sql.SQLException: No database selected at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) [mysql-connector-java-5.1.7-bin.jar:na] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) [mysql-connector-java-5.1.7-bin.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515) [mysql-connector-java-5.1.7-bin.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447) [mysql-connector-java-5.1.7-bin.jar:na] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) [mysql-connector-java-5.1.7-bin.jar:na] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) [mysql-connector-java-5.1.7-bin.jar:na] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554) [mysql-connector-java-5.1.7-bin.jar:na] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761) [mysql-connector-java-5.1.7-bin.jar:na] at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1912) [mysql-connector-java-5.1.7-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.id.IncrementGenerator.getNext(IncrementGenerator.java:109) [hibernate3.jar:na] ... 37 common frames omitted -- 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.
