grouper-users - [grouper-users] Re: Grouper Demo installer issues

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] Re: Grouper Demo installer issues

From: "Hyzer, Chris" <>
To: Roger Dills <>, "" <>
Subject: [grouper-users] Re: Grouper Demo installer issues
Date: Wed, 21 Mar 2018 15:48:30 +0000
Accept-language: en-US
Authentication-results: spf=none (sender IP is ) ;
Ironport-phdr: 9a23:Tyh+EhRAbP3Gr6w6WVLrqy5Kstpsv+yvbD5Q0YIujvd0So/mwa67ZhWEt8tkgFKBZ4jH8fUM07OQ7/i7HzRYqb+681k6OKRWUBEEjchE1ycBO+WiTXPBEfjxciYhF95DXlI2t1uyMExSBdqsLwaK+i764jEdAAjwOhRoLerpBIHSk9631+ev8JHPfglEnjWwba98IRmssQndqtQdjJd/JKo21hbHuGZDdf5MxWNvK1KTnhL86dm18ZV+7SleuO8v+tBZX6nicKs2UbJXDDI9M2Ao/8LrrgXMTRGO5nQHTGoblAdDDhXf4xH7WpfxtTb6tvZ41SKHM8D6Uaw4VDK/5KpwVhTmlDkIOCI48GHPi8x/kqRboA66pxdix4LYeZyZOOZicq/Ye94RWGhPUdtLVyFZAo2ycZYBD/YPM+hboYnypVoOogexCgS3Huzj1iNEi2Xq0aEm0+ksFxzN0gw6H9IJtXTZtNv5OqUSUOG00qbI1y3PZO5I1Df98ojIcwshrf+RVr93dMre1UkvFgPEj1qOs4zoJDKV1v8RvGSB8upgTfygi2ghqw1rvDeg29osh5DPi4kIxF7E8iB5z5w0Jd2+UEN7bsSkEJxNtyGCKYR2WN8tQ2VpuCkkzL0GpYS3fSYRyJg/yB7fcfuHc5WQ4h39TuadOy13hGp9eL6nhhay91SgxfPmVsmyzllKsjRJnsPSuX8Qyhzf8tSHSvtn/ki/wzmAyhrf6vtZIUAyjabbJIQhwrktlpoLr0vDBDX6mUvtjKOOdkUk5vSo6/z8Yrr4vJ+cKYt0hR/iMqg0mMywG/o4PRIWU2ib5eS8yKXj8VDkTLVSlP02lbXWv47BJcQAoa65GRVZ0oQ55BahFTiqyMkYnWUGLFJBYh6HiZbmO03ILfvlDvm/m0yhnCl3y/3EJLHsDZTAImLenLrgc7tx8VBQxBQrwdxC6Z9YFqsNLfbuVkPrqtDUExs0Pxapz+vlCdhxzo0eVnyMD6OFNa7ftFCF6+IuLuaXYYIYvCjxJ+Yn6vPrgnI1hEUScKas0JQMZn20AvBrLkOEanT2mNgBC30Fvg8mQezqllKCVTlTam6qUa8g4T83FIyrAZ7NSI6qjrGNxSC7EYZIaWxcDVCMDGvoeJ6DW/cRbiKdP9VtkiQeVbimV48uyw2htBP7y7pgKOrY4CoYtY//1Nhx4O3TkhIy+SZoAMSa1mGBV2B0nmUWSD8qxK1zv1Bxx1WZ3aV3gvFUD8Ff6vJHXwsgK5LQ0fR2C9XoVQLAeteJRkymQtKjATwpS9I+398OYkZ8Gtq8lBDOxCuqA6QJmLCRGZw06rzT3373J8pn1XnJybQhg0E8QsRTLW2mmrJ/9w/LCo7GiUWZkLuqdbwC0y7X7WuD0HGOs19CUA5rSqjFWXEfZlDKrdTi+E/OVb6uCbI7MgRf086CLLVFasH3gVlcWvjsJcneMCqNnDKKAhmF3PugbY7uYC1JxincDEwfux8U+m2aOBJ4Cyu89SaWRjN0Ek/3blmp7PJzsmiTT0kowhuMYlE7kbe551Rd0fOGTO4L06hBpTwssS5cHVCh0sjQBsba4QdtYfMPT8k65QIN9XPLuhY5dregNaF5zBZKdg93rlHjzT12EY4GjNAnqnVswQZvf/HLmGhdfi+ViMijcobcLXP/qVX2M/bb
Spamdiagnosticmetadata: NSPM
Spamdiagnosticoutput: 1:99

Do you have the database running before the WS starts? As you install it shows all the related commands, or the installer has commands to start/stop DB etc... ok?

From: <> on behalf of Roger Dills <>
Sent: Tuesday, March 20, 2018 5:07:56 PM
To:
Subject: [grouper-users] Grouper Demo installer issues

Hello,

I’m trying to get a demo install to complete without errors on Grouper V2.3.0.

The install works happily until I get to the web services client. It consistently bombs on its install.

The database contains only what the installer created. Running on Windows Server 2016 with Java JDK 1.8.

The error message

****************************************************

Should we check ports to see if tomcat was able to start (t|f)? [t]:

Waiting for tomcat to start...

Tomcat listening on port: 8080

This is the Grouper WS URL (change hostname if on different host): http://localhost:8080/grouper-ws/

Do you want to install the web services client (t|f)? [t]:

Downloading from URL: https://software.internet2.edu/grouper/release/2.3.0/grouper.clientBinary-2.3.0.tar.gz to file: c:\grouper\tarballs\grouper.clientBinary-2.3.0.tar.gz

Unzipping: c:\grouper\tarballs\grouper.clientBinary-2.3.0.tar.gz

Expanding: c:\grouper\tarballs\grouper.clientBinary-2.3.0.tar to c:\grouper\grouper.clientBinary-2.3.0

Editing c:\grouper\grouper.clientBinary-2.3.0\grouper.client.properties:

- set property: grouperClient.webService.url from: to: http://localhost:8080/grouper-ws/servicesRest

- set property: grouperClient.webService.login from: to: GrouperSystem

- set property: grouperClient.webService.password from: to: 123456789

##################################

Adding user GrouperSystem to grouper-ws users group with command:

cmd /c c:\grouper\grouper.apiBinary-2.3.0\bin\gsh.bat c:\grouper\grouper.apiBinary-2.3.0\gshAddGrouperSystemWsGroup.gsh

............

stderr: Couldnt 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:303)

at edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:156)

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: connect

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: connect

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: connect

at java.net.DualStackPlainSocketImpl.connect0(Native Method)

at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)

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.PlainSocketImpl.connect(PlainSocketImpl.java:172)

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