Grouper Users - Open Discussion List

[Roger Dills <>]

Hello,

 

Are there any ideas as to why the proof of concept installation does not work?

 

Thank you!

 

 

From: Roger Dills
Sent: Wednesday, March 21, 2018 5:27 PM
To: Hyzer, Chris;
Subject: Re: Grouper Demo installer issues

 

Hello,

 

To remove any confusion I've attached a complete "new" grouper 2.3 install dialogue using all the defaults. You can follow everything it does until it errors out on the WS component.

 

Ideally, there isn't much room to veer off the documented path.

 

Thank you,

 

Roger Dills
Senior Systems Administrator
Digital Infrastructure
The College of Wooster

---

From: Hyzer, Chris <>
Sent: Wednesday, March 21, 2018 2:37:20 PM
To: Roger Dills;
Subject: RE: Grouper Demo installer issues

 

It cant stop tomcat since it might not have been running, you can check processes to make sure its not running, then try continue as “true”

 

From: Roger Dills []
Sent: Wednesday, March 21, 2018 12:19 PM
To: Hyzer, Chris <>;
Subject: RE: Grouper Demo installer issues

 

Hello Chris,

 

I’ve gone through the installer and it always seems to bomb out once it gets to the WS install.

 

The database and Tomcat will be up before it starts and then once it starts the install either or both go offline.

 

This is another attempt where I verified the database was up before the install, the installer verified and indicated tomcat was up, but only to see tomcat crash during the install.

 

Output from the attempt

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

 

################ Checking patch grouper_v2_3_0_ui_patch_42

Patch doesnt exist yet (not an error): https://software.internet2.edu/grouper/release/2.3.0/patches/grouper_v2_3_0_ui_patch_42.tar.gz

 

Enter the GrouperSystem password:

The GrouperSystem password cannot be blank!

Enter the GrouperSystem password:

The GrouperSystem password cannot be blank!

Enter the GrouperSystem password:

The GrouperSystem password cannot be blank!

Enter the GrouperSystem password:

The GrouperSystem password cannot be blank!

Enter the GrouperSystem password: 1234356789

Do you want to set the GrouperSystem password in c:\grouper\apache-tomcat-8.5.12\conf\tomcat-users.xml? [t]:

Editing file: c:\grouper\apache-tomcat-8.5.12\conf\tomcat-users.xml

- adding Tomcat user GrouperSystem line: '<user username="GrouperSystem" password="123456789" roles="grouper_user"/>'

- adding Tomcat role grouper_user line: '<role rolename="grouper_user"/>'

Tomcat is supposed to be listening on port: 8080, port not listening, assuming tomcat is not running...

Should we stop tomcat anyway? (t|f)? [f]

 

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

Tomcat start with command (note you need CATALINA_HOME and JAVA_HOME set):

  c:\grouper\apache-tomcat-8.5.12\bin\startup.bat

 

 

End tomcat start (note: logs are in c:\grouper\apache-tomcat-8.5.12\logs)

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

 

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

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

 

Go here for the Grouper UI (change hostname if on different host): http://localhost:8080/grouper/

 

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

 

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

wsFile path is c:\grouper\tarballs\grouper.ws-2.3.0.tar.gz

File exists: c:\grouper\tarballs\grouper.ws-2.3.0.tar.gz, should we use the local file (t|f)? [t]:

Unzipped file exists: c:\grouper\tarballs\grouper.ws-2.3.0.tar, use unzipped file (t|f)? [t]:

Unzipped Ws file is c:\grouper\tarballs\grouper.ws-2.3.0.tar

Untarred dir exists: c:\grouper\grouper.ws-2.3.0, use untarred dir (t|f)? [t]:

Editing c:\grouper\grouper.ws-2.3.0\grouper-ws\build.properties:

- property grouper.dir already was set to: c:/grouper/grouper.apiBinary-2.3.0, not changing file

The Grouper WS has been built in the past, do you want it rebuilt? (t|f) [t]:

 

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

Tomcat stop with command (note you need CATALINA_HOME and JAVA_HOME set):

  c:\grouper\apache-tomcat-8.5.12\bin\shutdown.bat

 

Mar 21, 2018 12:02:43 PM edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils execCommandHelper

SEVERE: Process exit status=1: out: , err: Mar 21, 2018 12:02:43 PM org.apache.catalina.startup.Catalina stopServer

SEVERE: Could not contact localhost:8005. Tomcat may not be running.

Mar 21, 2018 12:02:43 PM org.apache.catalina.startup.Catalina stopServer

SEVERE: Catalina.stop:

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.apache.catalina.startup.Catalina.stopServer(Catalina.java:476)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:498)

        at org.apache.catalina.startup.Bootstrap.stopServer(Bootstrap.java:408)

        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:497)

 

Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=150m; support was removed in 8.0

, on command: C:\Program Files\Java\jdk1.8.0_162\bin\java -XX:MaxPermSize=150m -Xmx640m -Dcatalina.home=c:\grouper\apache-tomcat-8.5.12 -cp c:\grouper\apache-tomcat-8.5.12\bin\bootstrap.jar;c:\grouper\apache-tomcat-8.5.12\bin\tomcat-juli.jar org.apache.catalina.startup.Bootstrap stop , workingDir: c:\grouper\apache-tomcat-8.5.12\bin

java.lang.RuntimeException: Process exit status=1: out: , err: Mar 21, 2018 12:02:43 PM org.apache.catalina.startup.Catalina stopServer

SEVERE: Could not contact localhost:8005. Tomcat may not be running.

Mar 21, 2018 12:02:43 PM org.apache.catalina.startup.Catalina stopServer

SEVERE: Catalina.stop:

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.apache.catalina.startup.Catalina.stopServer(Catalina.java:476)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:498)

        at org.apache.catalina.startup.Bootstrap.stopServer(Bootstrap.java:408)

        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:497)

 

Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=150m; support was removed in 8.0

,

java.lang.RuntimeException: caller stack

        at edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils.threadRunWithStatusDots(GrouperInstallerUtils.java:8345)

        at edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils.execCommand(GrouperInstallerUtils.java:10078)

        at edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils.execCommand(GrouperInstallerUtils.java:10041)

        at edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils.execCommand(GrouperInstallerUtils.java:10017)

        at edu.internet2.middleware.grouperInstaller.GrouperInstaller.tomcatBounce(GrouperInstaller.java:1175)

        at edu.internet2.middleware.grouperInstaller.GrouperInstaller.buildWs(GrouperInstaller.java:11344)

        at edu.internet2.middleware.grouperInstaller.GrouperInstaller.mainInstallLogic(GrouperInstaller.java:8714)

        at edu.internet2.middleware.grouperInstaller.GrouperInstaller.access$500(GrouperInstaller.java:83)

        at edu.internet2.middleware.grouperInstaller.GrouperInstaller$GrouperInstallerMainFunction$2.logic(GrouperInstaller.java:1487)

        at edu.internet2.middleware.grouperInstaller.GrouperInstaller.mainLogic(GrouperInstaller.java:1710)

        at edu.internet2.middleware.grouperInstaller.GrouperInstaller.main(GrouperInstaller.java:550)

 

        at edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils.execCommandHelper(GrouperInstallerUtils.java:10175)

        at edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils.access$100(GrouperInstallerUtils.java:128)

        at edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils$2.run(GrouperInstallerUtils.java:10073)

        at edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils$1.run(GrouperInstallerUtils.java:8291)

        at java.lang.Thread.run(Thread.java:748)

Do you want to continue (t|f)? [f]

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

 

Maybe the script isn’t waiting long enough for Tomcat to “really” start?

 

 

From: Hyzer, Chris []
Sent: Wednesday, March 21, 2018 11:49 AM
To: Roger Dills;
Subject: Re: Grouper Demo installer issues

 

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.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

        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.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

 

stdout: Using GROUPER_HOME:           c:\grouper\grouper.apiBinary-2.3.0\bin\..

Using GROUPER_CONF:           c:\grouper\grouper.apiBinary-2.3.0\bin\../conf

Using JAVA:                   "C:\Program Files\Java\jdk1.8.0_162/bin/java"

using MEMORY:                 64m-750m

Grouper starting up: version: 2.3.0, build date: null, env: <no label configured>

grouperPatchStatus read from: C:\grouper\grouper.apiBinary-2.3.0\grouperPatchStatus.properties

api patches installed:        0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96

grouper.properties read from: C:\grouper\grouper.apiBinary-2.3.0\conf\grouper.properties

Grouper current directory is: c:\grouper\grouper.apiBinary-2.3.0

log4j.properties read from:   C:\grouper\grouper.apiBinary-2.3.0\conf\log4j.properties

Grouper is logging to file:   c:\grouper\grouper.apiBinary-2.3.0\bin\..\logs\grouper_error.log, at min level WARN for package: edu.internet2.middleware.grouper, based on log4j.properties

grouper.hibernate.properties: C:\grouper\grouper.apiBinary-2.3.0\conf\grouper.hibernate.properties

grouper.hibernate.properties: sa@jdbc:hsqldb:hsql://localhost:9001/grouper

subject.properties read from: C:\grouper\grouper.apiBinary-2.3.0\conf\subject.properties

sources.xml read from:        C:\grouper\grouper.apiBinary-2.3.0\conf\sources.xml

sources configured in:        sources.xml

sources.xml        groupersource id: g:gsa

sources.xml        groupersource id: grouperEntities

sources.xml        jdbc source id:   jdbc: GrouperJdbcConnectionProvider

Grouper error: Error connecting to the database with credentials from grouper.hibernate.properties, url: jdbc:hsqldb:hsql://localhost:9001/grouper, driver: org.hsqldb.jdbcDriver, user: sa, java.sql.SQLTransientConnectionException: java.net.ConnectException: Connection refused: connect

        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 java.sql.DriverManager.getConnection(DriverManager.java:664)

        at java.sql.DriverManager.getConnection(DriverManager.java:247)

        at edu.internet2.middleware.grouper.misc.GrouperCheckConfig.checkDatabase(GrouperCheckConfig.java:869)

        at edu.internet2.middleware.grouper.misc.GrouperCheckConfig.checkGrouperDb(GrouperCheckConfig.java:757)

        at edu.internet2.middleware.grouper.misc.GrouperStartup.startup(GrouperStartup.java:298)

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

        ... 10 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)

        ... 13 more

 

 

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

Running client command:

c:\grouper\grouper.clientBinary-2.3.0> C:\Program Files\Java\jdk1.8.0_162\bin\java -jar grouperClient.jar --operation=getMembersWs --groupNames=etc:webServiceClientUsers

........Mar 20, 2018 4:26:59 PM edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils execCommandHelper

SEVERE: Process exit status=1: out: , err: Error with grouper client, check the logs: Bad response from web service: resultCode: EXCEPTION, clientVersion: 2.3.0, wsGroupLookups: Array size: 1: [0]: WsGroupLookup[pitGroups=[],groupName=etc:webServiceClientUsers]

 

, memberFilter: All, includeSubjectDetail: false, actAsSubject: null, fieldName: null, subjectAttributeNames: null

, paramNames:

, params: null

, sourceIds: null

, pointInTimeFrom: null, pointInTimeTo: null, pageSize: null, pageNumber: null, sortString: null, ascending: null, java.lang.RuntimeException: Database schema ddl is not up to date, or has issues, check logs and config ddl in grouper.properties and run: gsh -registry -check,

Problem in HibernateSession: null,

Exception in uniqueResult: (class edu.internet2.middleware.grouper.Member), ByHqlStatic, query: 'from Member as m where      m.subjectIdDb       = :sid    and  m.subjectSourceIdDb = :source and  m.subjectTypeId   = :type', cacheable: true, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.FindBySubject, tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 'sid'->'GrouperSystem', Bind var[1]: 'Param (class java.lang.String): 'type'->'application'Bind var[2]: 'Param (class java.lang.String): 'source'->'g:isa',

        at edu.internet2.middleware.grouper.hibernate.HibernateSession.<init>(HibernateSession.java:176)

        at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSession(HibernateSession.java:467)

        at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:659)

        at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlStatic.java:340)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:296)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:202)

        at edu.internet2.middleware.grouper.MemberFinder.internal_findOrCreateBySubject(MemberFinder.java:401)

        at edu.internet2.middleware.grouper.MemberFinder.internal_findBySubject(MemberFinder.java:318)

        at edu.internet2.middleware.grouper.GrouperSession.start(GrouperSession.java:487)

        at edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:427)

        at edu.internet2.middleware.grouper.ws.GrouperServiceJ2ee.retrieveSubjectLoggedIn(GrouperServiceJ2ee.java:246)

        at edu.internet2.middleware.grouper.ws.GrouperServiceJ2ee.retrieveSubjectActAsHelper(GrouperServiceJ2ee.java:592)

        at edu.internet2.middleware.grouper.ws.GrouperServiceJ2ee.retrieveSubjectActAs(GrouperServiceJ2ee.java:564)

        at edu.internet2.middleware.grouper.ws.util.GrouperServiceUtils.retrieveGrouperSession(GrouperServiceUtils.java:849)

        at edu.internet2.middleware.grouper.ws.GrouperServiceLogic.getMembers(GrouperServiceLogic.java:1411)

        at edu.internet2.middleware.grouper.ws.coresoap.GrouperService.getMembers(GrouperService.java:472)

        at edu.internet2.middleware.grouper.ws.rest.GrouperServiceRest.getMembers(GrouperServiceRest.java:558)

        at edu.internet2.middleware.grouper.ws.rest.method.GrouperWsRestGet$1.service(GrouperWsRestGet.java:91)

        at edu.internet2.middleware.grouper.ws.rest.method.GrouperRestHttpMethod$1.service(GrouperRestHttpMethod.java:57)

        at edu.internet2.middleware.grouper.ws.rest.GrouperRestServlet.service(GrouperRestServlet.java:202)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

        at edu.internet2.middleware.grouper.ws.GrouperServiceJ2ee.doFilter(GrouperServiceJ2ee.java:895)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)

        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:595)

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)

        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)

        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)

        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:341)

        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:783)

        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)

        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:798)

        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1441)

        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

        at java.lang.Thread.run(Thread.java:748)

 

Mar 20, 2018 4:26:59 PM edu.internet2.middleware.grouperClient.GrouperClient main

SEVERE: Bad response from web service: resultCode: EXCEPTION, clientVersion: 2.3.0, wsGroupLookups: Array size: 1: [0]: WsGroupLookup[pitGroups=[],groupName=etc:webServiceClientUsers]

 

, memberFilter: All, includeSubjectDetail: false, actAsSubject: null, fieldName: null, subjectAttributeNames: null

, paramNames:

, params: null

, sourceIds: null

, pointInTimeFrom: null, pointInTimeTo: null, pageSize: null, pageNumber: null, sortString: null, ascending: null, java.lang.RuntimeException: Database schema ddl is not up to date, or has issues, check logs and config ddl in grouper.properties and run: gsh -registry -check,

Problem in HibernateSession: null,

Exception in uniqueResult: (class edu.internet2.middleware.grouper.Member), ByHqlStatic, query: 'from Member as m where      m.subjectIdDb       = :sid    and  m.subjectSourceIdDb = :source and  m.subjectTypeId   = :type', cacheable: true, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.FindBySubject, tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 'sid'->'GrouperSystem', Bind var[1]: 'Param (class java.lang.String): 'type'->'application'Bind var[2]: 'Param (class java.lang.String): 'source'->'g:isa',

        at edu.internet2.middleware.grouper.hibernate.HibernateSession.<init>(HibernateSession.java:176)

        at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSession(HibernateSession.java:467)

        at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:659)

        at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlStatic.java:340)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:296)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:202)

        at edu.internet2.middleware.grouper.MemberFinder.internal_findOrCreateBySubject(MemberFinder.java:401)

        at edu.internet2.middleware.grouper.MemberFinder.internal_findBySubject(MemberFinder.java:318)

        at edu.internet2.middleware.grouper.GrouperSession.start(GrouperSession.java:487)

        at edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:427)

        at edu.internet2.middleware.grouper.ws.GrouperServiceJ2ee.retrieveSubjectLoggedIn(GrouperServiceJ2ee.java:246)

        at edu.internet2.middleware.grouper.ws.GrouperServiceJ2ee.retrieveSubjectActAsHelper(GrouperServiceJ2ee.java:592)

        at edu.internet2.middleware.grouper.ws.GrouperServiceJ2ee.retrieveSubjectActAs(GrouperServiceJ2ee.java:564)

        at edu.internet2.middleware.grouper.ws.util.GrouperServiceUtils.retrieveGrouperSession(GrouperServiceUtils.java:849)

        at edu.internet2.middleware.grouper.ws.GrouperServiceLogic.getMembers(GrouperServiceLogic.java:1411)

        at edu.internet2.middleware.grouper.ws.coresoap.GrouperService.getMembers(GrouperService.java:472)

        at edu.internet2.middleware.grouper.ws.rest.GrouperServiceRest.getMembers(GrouperServiceRest.java:558)

        at edu.internet2.middleware.grouper.ws.rest.method.GrouperWsRestGet$1.service(GrouperWsRestGet.java:91)

        at edu.internet2.middleware.grouper.ws.rest.method.GrouperRestHttpMethod$1.service(GrouperRestHttpMethod.java:57)

        at edu.internet2.middleware.grouper.ws.rest.GrouperRestServlet.service(GrouperRestServlet.java:202)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

        at edu.internet2.middleware.grouper.ws.GrouperServiceJ2ee.doFilter(GrouperServiceJ2ee.java:895)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)

        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:595)

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)

        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)

        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)

        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:341)

        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:783)

        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)

        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:798)

        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1441)

        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

        at java.lang.Thread.run(Thread.java:748)

 

edu.internet2.middleware.grouperClient.ws.GcWebServiceError: Bad response from web service: resultCode: EXCEPTION, clientVersion: 2.3.0, wsGroupLookups: Array size: 1: [0]: WsGroupLookup[pitGroups=[],groupName=etc:webServiceClientUsers]

 

, memberFilter: All, includeSubjectDetail: false, actAsSubject: null, fieldName: null, subjectAttributeNames: null

, paramNames:

, params: null

, sourceIds: null

, pointInTimeFrom: null, pointInTimeTo: null, pageSize: null, pageNumber: null, sortString: null, ascending: null, java.lang.RuntimeException: Database schema ddl is not up to date, or has issues, check logs and config ddl in grouper.properties and run: gsh -registry -check,

Problem in HibernateSession: null,

Exception in uniqueResult: (class edu.internet2.middleware.grouper.Member), ByHqlStatic, query: 'from Member as m where      m.subjectIdDb       = :sid    and  m.subjectSourceIdDb = :source and  m.subjectTypeId   = :type', cacheable: true, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.FindBySubject, tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 'sid'->'GrouperSystem', Bind var[1]: 'Param (class java.lang.String): 'type'->'application'Bind var[2]: 'Param (class java.lang.String): 'source'->'g:isa',

        at edu.internet2.middleware.grouper.hibernate.HibernateSession.<init>(HibernateSession.java:176)

        at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSession(HibernateSession.java:467)

        at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:659)

        at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlStatic.java:340)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:296)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:202)

        at edu.internet2.middleware.grouper.MemberFinder.internal_findOrCreateBySubject(MemberFinder.java:401)

        at edu.internet2.middleware.grouper.MemberFinder.internal_findBySubject(MemberFinder.java:318)

        at edu.internet2.middleware.grouper.GrouperSession.start(GrouperSession.java:487)

        at edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:427)

        at edu.internet2.middleware.grouper.ws.GrouperServiceJ2ee.retrieveSubjectLoggedIn(GrouperServiceJ2ee.java:246)

        at edu.internet2.middleware.grouper.ws.GrouperServiceJ2ee.retrieveSubjectActAsHelper(GrouperServiceJ2ee.java:592)

        at edu.internet2.middleware.grouper.ws.GrouperServiceJ2ee.retrieveSubjectActAs(GrouperServiceJ2ee.java:564)

        at edu.internet2.middleware.grouper.ws.util.GrouperServiceUtils.retrieveGrouperSession(GrouperServiceUtils.java:849)

        at edu.internet2.middleware.grouper.ws.GrouperServiceLogic.getMembers(GrouperServiceLogic.java:1411)

        at edu.internet2.middleware.grouper.ws.coresoap.GrouperService.getMembers(GrouperService.java:472)

        at edu.internet2.middleware.grouper.ws.rest.GrouperServiceRest.getMembers(GrouperServiceRest.java:558)

        at edu.internet2.middleware.grouper.ws.rest.method.GrouperWsRestGet$1.service(GrouperWsRestGet.java:91)

        at edu.internet2.middleware.grouper.ws.rest.method.GrouperRestHttpMethod$1.service(GrouperRestHttpMethod.java:57)

        at edu.internet2.middleware.grouper.ws.rest.GrouperRestServlet.service(GrouperRestServlet.java:202)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

        at edu.internet2.middleware.grouper.ws.GrouperServiceJ2ee.doFilter(GrouperServiceJ2ee.java:895)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)

        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:595)

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)

        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)

        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)

        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:341)

        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:783)

        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)

        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:798)

        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1441)

        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

        at java.lang.Thread.run(Thread.java:748)

 

        at edu.internet2.middleware.grouperClient.ws.GrouperClientWs.handleFailure(GrouperClientWs.java:736)

        at edu.internet2.middleware.grouperClient.api.GcGetMembers.execute(GcGetMembers.java:426)

        at edu.internet2.middleware.grouperClient.GrouperClient.getMembers(GrouperClient.java:2257)

        at edu.internet2.middleware.grouperClient.GrouperClient.main(GrouperClient.java:365)

 

, on command: C:\Program Files\Java\jdk1.8.0_162\bin\java -jar grouperClient.jar --operation=getMembersWs --groupNames=etc:webServiceClientUsers , workingDir: c:\grouper\grouper.clientBinary-2.3.0

 

Exception in thread "main" java.lang.RuntimeException: Process exit status=1: out: , err: Error with grouper client, check the logs: Bad response from web service: resultCode: EXCEPTION, clientVersion: 2.3.0, wsGroupLookups: Array size: 1: [0]: WsGroupLookup[pitGroups=[],groupName=etc:webServiceClientUsers]

 

, memberFilter: All, includeSubjectDetail: false, actAsSubject: null, fieldName: null, subjectAttributeNames: null

, paramNames:

, params: null

, sourceIds: null

, pointInTimeFrom: null, pointInTimeTo: null, pageSize: null, pageNumber: null, sortString: null, ascending: null, java.lang.RuntimeException: Database schema ddl is not up to date, or has issues, check logs and config ddl in grouper.properties and run: gsh -registry -check,

Problem in HibernateSession: null,

Exception in uniqueResult: (class edu.internet2.middleware.grouper.Member), ByHqlStatic, query: 'from Member as m where      m.subjectIdDb       = :sid    and  m.subjectSourceIdDb = :source and  m.subjectTypeId   = :type', cacheable: true, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.FindBySubject, tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 'sid'->'GrouperSystem', Bind var[1]: 'Param (class java.lang.String): 'type'->'application'Bind var[2]: 'Param (class java.lang.String): 'source'->'g:isa',

        at edu.internet2.middleware.grouper.hibernate.HibernateSession.<init>(HibernateSession.java:176)

        at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSession(HibernateSession.java:467)

        at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:659)

        at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlStatic.java:340)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:296)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:202)

        at edu.internet2.middleware.grouper.MemberFinder.internal_findOrCreateBySubject(MemberFinder.java:401)

        at edu.internet2.middleware.grouper.MemberFinder.internal_findBySubject(MemberFinder.java:318)

        at edu.internet2.middleware.grouper.GrouperSession.start(GrouperSession.java:487)

        at edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:427)

        at edu.internet2.middleware.grouper.ws.GrouperServiceJ2ee.retrieveSubjectLoggedIn(GrouperServiceJ2ee.java:246)

        at edu.internet2.middleware.grouper.ws.GrouperServiceJ2ee.retrieveSubjectActAsHelper(GrouperServiceJ2ee.java:592)

        at edu.internet2.middleware.grouper.ws.GrouperServiceJ2ee.retrieveSubjectActAs(GrouperServiceJ2ee.java:564)

        at edu.internet2.middleware.grouper.ws.util.GrouperServiceUtils.retrieveGrouperSession(GrouperServiceUtils.java:849)

        at edu.internet2.middleware.grouper.ws.GrouperServiceLogic.getMembers(GrouperServiceLogic.java:1411)

        at edu.internet2.middleware.grouper.ws.coresoap.GrouperService.getMembers(GrouperService.java:472)

        at edu.internet2.middleware.grouper.ws.rest.GrouperServiceRest.getMembers(GrouperServiceRest.java:558)

        at edu.internet2.middleware.grouper.ws.rest.method.GrouperWsRestGet$1.service(GrouperWsRestGet.java:91)

        at edu.internet2.middleware.grouper.ws.rest.method.GrouperRestHttpMethod$1.service(GrouperRestHttpMethod.java:57)

        at edu.internet2.middleware.grouper.ws.rest.GrouperRestServlet.service(GrouperRestServlet.java:202)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

        at edu.internet2.middleware.grouper.ws.GrouperServiceJ2ee.doFilter(GrouperServiceJ2ee.java:895)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)

        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:595)

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)

        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)

        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)

        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:341)

        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:783)

        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)

        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:798)

        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1441)

        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

        at java.lang.Thread.run(Thread.java:748)

 

Mar 20, 2018 4:26:59 PM edu.internet2.middleware.grouperClient.GrouperClient main

SEVERE: Bad response from web service: resultCode: EXCEPTION, clientVersion: 2.3.0, wsGroupLookups: Array size: 1: [0]: WsGroupLookup[pitGroups=[],groupName=etc:webServiceClientUsers]

 

, memberFilter: All, includeSubjectDetail: false, actAsSubject: null, fieldName: null, subjectAttributeNames: null

, paramNames:

, params: null

, sourceIds: null

, pointInTimeFrom: null, pointInTimeTo: null, pageSize: null, pageNumber: null, sortString: null, ascending: null, java.lang.RuntimeException: Database schema ddl is not up to date, or has issues, check logs and config ddl in grouper.properties and run: gsh -registry -check,

Problem in HibernateSession: null,

Exception in uniqueResult: (class edu.internet2.middleware.grouper.Member), ByHqlStatic, query: 'from Member as m where      m.subjectIdDb       = :sid    and  m.subjectSourceIdDb = :source and  m.subjectTypeId   = :type', cacheable: true, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.FindBySubject, tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 'sid'->'GrouperSystem', Bind var[1]: 'Param (class java.lang.String): 'type'->'application'Bind var[2]: 'Param (class java.lang.String): 'source'->'g:isa',

        at edu.internet2.middleware.grouper.hibernate.HibernateSession.<init>(HibernateSession.java:176)

        at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSession(HibernateSession.java:467)

        at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:659)

        at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlStatic.java:340)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:296)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:202)

        at edu.internet2.middleware.grouper.MemberFinder.internal_findOrCreateBySubject(MemberFinder.java:401)

        at edu.internet2.middleware.grouper.MemberFinder.internal_findBySubject(MemberFinder.java:318)

        at edu.internet2.middleware.grouper.GrouperSession.start(GrouperSession.java:487)

        at edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:427)

        at edu.internet2.middleware.grouper.ws.GrouperServiceJ2ee.retrieveSubjectLoggedIn(GrouperServiceJ2ee.java:246)

        at edu.internet2.middleware.grouper.ws.GrouperServiceJ2ee.retrieveSubjectActAsHelper(GrouperServiceJ2ee.java:592)

        at edu.internet2.middleware.grouper.ws.GrouperServiceJ2ee.retrieveSubjectActAs(GrouperServiceJ2ee.java:564)

        at edu.internet2.middleware.grouper.ws.util.GrouperServiceUtils.retrieveGrouperSession(GrouperServiceUtils.java:849)

        at edu.internet2.middleware.grouper.ws.GrouperServiceLogic.getMembers(GrouperServiceLogic.java:1411)

        at edu.internet2.middleware.grouper.ws.coresoap.GrouperService.getMembers(GrouperService.java:472)

        at edu.internet2.middleware.grouper.ws.rest.GrouperServiceRest.getMembers(GrouperServiceRest.java:558)

        at edu.internet2.middleware.grouper.ws.rest.method.GrouperWsRestGet$1.service(GrouperWsRestGet.java:91)

        at edu.internet2.middleware.grouper.ws.rest.method.GrouperRestHttpMethod$1.service(GrouperRestHttpMethod.java:57)

        at edu.internet2.middleware.grouper.ws.rest.GrouperRestServlet.service(GrouperRestServlet.java:202)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

        at edu.internet2.middleware.grouper.ws.GrouperServiceJ2ee.doFilter(GrouperServiceJ2ee.java:895)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)

        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:595)

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)

        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)

        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)

        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:341)

        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:783)

        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)

        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:798)

        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1441)

        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

        at java.lang.Thread.run(Thread.java:748)

 

edu.internet2.middleware.grouperClient.ws.GcWebServiceError: Bad response from web service: resultCode: EXCEPTION, clientVersion: 2.3.0, wsGroupLookups: Array size: 1: [0]: WsGroupLookup[pitGroups=[],groupName=etc:webServiceClientUsers]

 

, memberFilter: All, includeSubjectDetail: false, actAsSubject: null, fieldName: null, subjectAttributeNames: null

, paramNames:

, params: null

, sourceIds: null

, pointInTimeFrom: null, pointInTimeTo: null, pageSize: null, pageNumber: null, sortString: null, ascending: null, java.lang.RuntimeException: Database schema ddl is not up to date, or has issues, check logs and config ddl in grouper.properties and run: gsh -registry -check,

Problem in HibernateSession: null,

Exception in uniqueResult: (class edu.internet2.middleware.grouper.Member), ByHqlStatic, query: 'from Member as m where      m.subjectIdDb       = :sid    and  m.subjectSourceIdDb = :source and  m.subjectTypeId   = :type', cacheable: true, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.FindBySubject, tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 'sid'->'GrouperSystem', Bind var[1]: 'Param (class java.lang.String): 'type'->'application'Bind var[2]: 'Param (class java.lang.String): 'source'->'g:isa',

        at edu.internet2.middleware.grouper.hibernate.HibernateSession.<init>(HibernateSession.java:176)

        at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSession(HibernateSession.java:467)

        at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:659)

        at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlStatic.java:340)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:296)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:202)

        at edu.internet2.middleware.grouper.MemberFinder.internal_findOrCreateBySubject(MemberFinder.java:401)

        at edu.internet2.middleware.grouper.MemberFinder.internal_findBySubject(MemberFinder.java:318)

        at edu.internet2.middleware.grouper.GrouperSession.start(GrouperSession.java:487)

        at edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:427)

        at edu.internet2.middleware.grouper.ws.GrouperServiceJ2ee.retrieveSubjectLoggedIn(GrouperServiceJ2ee.java:246)

        at edu.internet2.middleware.grouper.ws.GrouperServiceJ2ee.retrieveSubjectActAsHelper(GrouperServiceJ2ee.java:592)

        at edu.internet2.middleware.grouper.ws.GrouperServiceJ2ee.retrieveSubjectActAs(GrouperServiceJ2ee.java:564)

        at edu.internet2.middleware.grouper.ws.util.GrouperServiceUtils.retrieveGrouperSession(GrouperServiceUtils.java:849)

        at edu.internet2.middleware.grouper.ws.GrouperServiceLogic.getMembers(GrouperServiceLogic.java:1411)

        at edu.internet2.middleware.grouper.ws.coresoap.GrouperService.getMembers(GrouperService.java:472)

        at edu.internet2.middleware.grouper.ws.rest.GrouperServiceRest.getMembers(GrouperServiceRest.java:558)

        at edu.internet2.middleware.grouper.ws.rest.method.GrouperWsRestGet$1.service(GrouperWsRestGet.java:91)

        at edu.internet2.middleware.grouper.ws.rest.method.GrouperRestHttpMethod$1.service(GrouperRestHttpMethod.java:57)

        at edu.internet2.middleware.grouper.ws.rest.GrouperRestServlet.service(GrouperRestServlet.java:202)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

        at edu.internet2.middleware.grouper.ws.GrouperServiceJ2ee.doFilter(GrouperServiceJ2ee.java:895)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)

        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:595)

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)

        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)

        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)

        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:341)

        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:783)

        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)

        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:798)

        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1441)

        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

        at java.lang.Thread.run(Thread.java:748)

 

        at edu.internet2.middleware.grouperClient.ws.GrouperClientWs.handleFailure(GrouperClientWs.java:736)

        at edu.internet2.middleware.grouperClient.api.GcGetMembers.execute(GcGetMembers.java:426)

        at edu.internet2.middleware.grouperClient.GrouperClient.getMembers(GrouperClient.java:2257)

        at edu.internet2.middleware.grouperClient.GrouperClient.main(GrouperClient.java:365)

 

,

java.lang.RuntimeException: caller stack

        at edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils.threadRunWithStatusDots(GrouperInstallerUtils.java:8345)

        at edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils.execCommand(GrouperInstallerUtils.java:10078)

        at edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils.execCommand(GrouperInstallerUtils.java:10041)

        at edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils.execCommand(GrouperInstallerUtils.java:10017)

        at edu.internet2.middleware.grouperInstaller.GrouperInstaller.runClientCommand(GrouperInstaller.java:11653)

        at edu.internet2.middleware.grouperInstaller.GrouperInstaller.mainInstallLogic(GrouperInstaller.java:8767)

        at edu.internet2.middleware.grouperInstaller.GrouperInstaller.access$500(GrouperInstaller.java:83)

        at edu.internet2.middleware.grouperInstaller.GrouperInstaller$GrouperInstallerMainFunction$2.logic(GrouperInstaller.java:1487)

        at edu.internet2.middleware.grouperInstaller.GrouperInstaller.mainLogic(GrouperInstaller.java:1710)

        at edu.internet2.middleware.grouperInstaller.GrouperInstaller.main(GrouperInstaller.java:550)

 

        at edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils.execCommandHelper(GrouperInstallerUtils.java:10175)

        at edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils.access$100(GrouperInstallerUtils.java:128)

        at edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils$2.run(GrouperInstallerUtils.java:10073)

        at edu.internet2.middleware.grouperInstaller.util.GrouperInstallerUtils$1.run(GrouperInstallerUtils.java:8291)

        at java.lang.Thread.run(Thread.java:748)

 

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

 

Oracle Java JDK 1.8 seems to be the only version of Java that works well compiling the code (worse results with 1.7 and 1.9).  

 

Thank you!