normally that means you just have no right to create another database. You will need a root account, create the database and grant access to the user that you're using.
Sebastian 2010/8/26 MikeMack <[email protected]> > 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]<openmeetings-user%[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.
