Grouper Users - Open Discussion List

["Hyzer, Chris" <>]

I think you only need GROUPER_HOME if you don’t start grouper from the 
directory where its installed.  If you are in the bin directory and start gsh 
(and assuming the database is started), then you should be fine.

Thanks
Chris

-----Original Message-----
From: 

 
[mailto:]
 On Behalf Of tom dopirak
Sent: Saturday, May 06, 2017 1:45 PM
To: 

Subject: [grouper-users] more information

So once I figured out the GROUPER_HOME didn't get set by the install 
script I was able to use gsh and restart grouper. Obviously the install 
of the database didn't go well or something is missing from the ubuntu 
distribution. Anyone care to save me a bit of time?

Tom


t@t-VirtualBox:~/grouper/grouper.apiBinary-2.3.0$ bin/gsh --loader  > 
./test.errCouldnt startup grouper: Problems with db: DB: user: sa, url: 
jdbc:hsqldb:hsql://localhost:9001/grouper, driver: org.hsqldb.jdbcDriver
java.lang.RuntimeException: Problems with db: DB: user: sa, url: 
jdbc:hsqldb:hsql://localhost:9001/grouper, driver: org.hsqldb.jdbcDriver
     at 
edu.internet2.middleware.grouper.app.loader.db.GrouperLoaderDb.connection(GrouperLoaderDb.java:254)
     at 
edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrapHelper(GrouperDdlUtils.java:436)
     at 
edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrap(GrouperDdlUtils.java:340)
     at 
edu.internet2.middleware.grouper.misc.GrouperStartup.startup(GrouperStartup.java:251)
     at 
edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:151)
     at 
edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:31)
Caused by: java.sql.SQLException: Connections could not be acquired from 
the underlying database!
     at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
     at 
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:692)
     at 
com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
     at 
edu.internet2.middleware.grouper.app.loader.db.GrouperLoaderDb.connection(GrouperLoaderDb.java:251)
     ... 5 more
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:1469)
     at 
com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644)
     at 
com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554)
     at 
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758)
     at 
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:685)
     ... 7 more
Caused by: java.sql.SQLTransientConnectionException: 
java.net.ConnectException: Connection refused (Connection refused)
     at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
     at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
     at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
     at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
     at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
     at 
com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
     at 
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
     at 
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
     at 
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
     at 
com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
     at 
com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
     at 
com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
     at 
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
     at 
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Caused by: org.hsqldb.HsqlException: java.net.ConnectException: 
Connection refused (Connection refused)
     at org.hsqldb.ClientConnection.openConnection(Unknown Source)
     at org.hsqldb.ClientConnection.initConnection(Unknown Source)
     at org.hsqldb.ClientConnection.<init>(Unknown Source)
     ... 12 more
Caused by: java.net.ConnectException: Connection refused (Connection 
refused)
     at java.net.PlainSocketImpl.socketConnect(Native Method)
     at 
java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
     at 
java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
     at 
java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
     at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
     at java.net.Socket.connect(Socket.java:589)
     at java.net.Socket.connect(Socket.java:538)
     at java.net.Socket.<init>(Socket.java:434)
     at java.net.Socket.<init>(Socket.java:211)
     at org.hsqldb.server.HsqlSocketFactory.createSocket(Unknown Source)
     ... 15 more
Exception in thread "main" java.lang.RuntimeException: Problems with db: 
DB: user: sa, url: jdbc:hsqldb:hsql://localhost:9001/grouper, driver: 
org.hsqldb.jdbcDriver
     at 
edu.internet2.middleware.grouper.app.loader.db.GrouperLoaderDb.connection(GrouperLoaderDb.java:254)
     at 
edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrapHelper(GrouperDdlUtils.java:436)
     at 
edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrap(GrouperDdlUtils.java:340)
     at 
edu.internet2.middleware.grouper.misc.GrouperStartup.startup(GrouperStartup.java:251)
     at 
edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:151)
     at 
edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:31)
Caused by: java.sql.SQLException: Connections could not be acquired from 
the underlying database!
     at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
     at 
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:692)
     at 
com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
     at 
edu.internet2.middleware.grouper.app.loader.db.GrouperLoaderDb.connection(GrouperLoaderDb.java:251)
     ... 5 more
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:1469)
     at 
com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644)
     at 
com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554)
     at 
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758)
     at 
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:685)
     ... 7 more
Caused by: java.sql.SQLTransientConnectionException: 
java.net.ConnectException: Connection refused (Connection refused)
     at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
     at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
     at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
     at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
     at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
     at 
com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
     at 
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
     at 
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
     at 
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
     at 
com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
     at 
com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
     at 
com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
     at 
com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
     at 
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Caused by: org.hsqldb.HsqlException: java.net.ConnectException: 
Connection refused (Connection refused)
     at org.hsqldb.ClientConnection.openConnection(Unknown Source)
     at org.hsqldb.ClientConnection.initConnection(Unknown Source)
     at org.hsqldb.ClientConnection.<init>(Unknown Source)
     ... 12 more
Caused by: java.net.ConnectException: Connection refused (Connection 
refused)
     at java.net.PlainSocketImpl.socketConnect(Native Method)
     at 
java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
     at 
java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
     at 
java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
     at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
     at java.net.Socket.connect(Socket.java:589)
     at java.net.Socket.connect(Socket.java:538)
     at java.net.Socket.<init>(Socket.java:434)
     at java.net.Socket.<init>(Socket.java:211)
     at org.hsqldb.server.HsqlSocketFactory.createSocket(Unknown Source)
     ... 15 more