Hey Sebastian, That seems to be my problem, I can't get it to install to a new database. It won't run the scripts needed to create one, or fill an empty one.
I assumed that since my old connection worked, if I just changed the database name it would rebuild it using that database...but that's where it keeps freezing. Any idea? Thanks, Michael On Aug 26, 9:38 am, Sebastian Wagner <[email protected]> wrote: > Hallo > > you have to run the installer again into a blank database. > Otherwise you miss a lot of labels et cetera. > > Sebastian > > 2010/8/26 MikeMack <[email protected]> > > > Hey Sebastian, > > > I'm using the same connection I had with my previous installation > > (1.0r2688) so I would think it would work, I'm also using SA login so > > it should have no problem creating what it needs. > > > <property name="connection.username">sa</property> > > <property name="connection.password">*******</property> > > > <!-- Database Settings --> > > <property > > > name="connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</ > > property> > > <!-- for performance reasons changed to MyISAM from > > org.hibernate.dialect.MySQLInnoDBDialect --> > > <property name="dialect">org.hibernate.dialect.SQLServerDialect</ > > property> > > <property name="connection.url">jdbc:sqlserver:// > > > **********;databaseName=OpenMeetings123;autoReconnect=true;useUnicode=true;createDatabaseIfNotExist=true;characterEncoding=utf-8</ > > property> > > <property name="hibernate.connection.CharSet">utf8</property> > > <property name="hibernate.connection.characterEncoding">utf8</ > > property> > > <property name="hibernate.connection.useUnicode">true</property> > > > Here is the full error I'm getting, any ideas? I'd appreciate any > > help, I'm really not sure why it works with the current DB but has no > > privilages to create the other DB. Actually in that case, is the > > script to create a fresh DB anywhere? Maybe if I just create it > > myself it'll be good to go? > > > Thanks, Michael > > > ERROR 08-26 09:30:15.583 JDBCExceptionReporter.java 758989 101 > > org.hibernate.util.JDBCExceptionReporter [http-5080-2] - Connections > > could not be acquired from the underlying database! > > ERROR 08-26 09:30:15.599 Statemanagement.java 759005 59 > > org.openmeetings.app.data.user.Statemanagement [http-5080-2] - > > addState > > org.hibernate.exception.GenericJDBCException: Cannot open connection > > 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.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java: > > 52) [hibernate3.jar:na] > > at > > org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java: > > 449) [hibernate3.jar:na] > > at > > org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java: > > 167) [hibernate3.jar:na] > > at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142) > > [hibernate3.jar:na] > > at > > org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java: > > 85) [hibernate3.jar:na] > > at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java: > > 1353) [hibernate3.jar:na] > > at > > > org.openmeetings.app.data.user.Statemanagement.addState(Statemanagement.java: > > 43) [openmeetings.jar:na] > > at > > > org.openmeetings.app.installation.ImportInitvalues.loadCountriesFiles(ImportInitvalues.java: > > 491) [openmeetings.jar:na] > > at > > > org.openmeetings.app.installation.ImportInitvalues.loadInitLanguages(ImportInitvalues.java: > > 581) [openmeetings.jar:na] > > at > > org.openmeetings.servlet.outputhandler.Install.handleRequest(Install.java: > > 212) [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(Unknown Source) [na:1.6.0_21] > > Caused by: java.sql.SQLException: Connections could not be acquired > > from the underlying database! > > at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106) > > [c3p0-0.9.1.jar:0.9.1] > > at > > > com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java: > > 529) [c3p0-0.9.1.jar:0.9.1] > > at > > > com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java: > > 128) [c3p0-0.9.1.jar:0.9.1] > > at > > > org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java: > > 78) [hibernate3.jar:na] > > at > > org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java: > > 446) [hibernate3.jar:na] > > ... 32 common frames omitted > > Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: > > A ResourcePool could not acquire a resource from its primary factory > > or source. > > at > > > com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java: > > 1319) [c3p0-0.9.1.jar:0.9.1] > > at > > > com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java: > > 557) [c3p0-0.9.1.jar:0.9.1] > > at > > > com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java: > > 477) [c3p0-0.9.1.jar:0.9.1] > > at > > > com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java: > > 525) [c3p0-0.9.1.jar:0.9.1] > > ... 35 common frames omitted > > > On Aug 25, 2:51 pm, Sebastian Wagner <[email protected]> wrote: > > > * Cannot open > > > connection* > > > => your db config is wrong. > > > > Maybe your DB user has no grant privileges on the database. > > > > Sebastian > > > > 2010/8/25 MikeMack <[email protected]> > > > > > Hi, > > > > > I tried upgrading from my 1.0 open meetings to 1.4 today, as it's such > > > > a big leap I ended up just removing the open meetings folder and > > > > overwriting it with the new one, then updating the hibernate file. > > > > Openmeetings started up fine after that, however some of the things > > > > said "error" instead of the proper name tag, and the Share your screen > > > > option failed when I went to run it. > > > > > I assume these are a result of my database not loading up properly, so > > > > I changed the database name in the hibernate config file and decided > > > > to try and let it install a fresh version...only that just seems to > > > > freeze on the install command step 1 continue button saying : > > > > > Statemanagement.java 453481 59 > > > > org.openmeetings.app.data.user.Statemanagement [http-5080-3] - > > > > addState org.hibernate.exception.GenericJDBCException: Cannot open > > > > connection > > > > > Which confuses me a bit, as I would think it would work as everything > > > > else for the connection is the same. > > > > > Any suggestions? > > > > > Thanks, > > > > Michael > > > > > -- > > > > 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 > > ... > > read more » -- 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.
