grouper-dev - RE: [grouper-dev] grouper installer 2.1.0 - local files?

Subject: Grouper Developers Forum

List archive

RE: [grouper-dev] grouper installer 2.1.0 - local files?

From: Chris Hyzer <>
To: Jeff Mccullough <>
Cc: Jeff McCullough <>, Grouper Dev <>
Subject: RE: [grouper-dev] grouper installer 2.1.0 - local files?
Date: Thu, 15 Mar 2012 20:22:56 +0000
Accept-language: en-US

Right, I did some updates to help this if you want to get the latest 2.1.0 installer, then here is what I did to test this. I ran the installer. I deleted the tars (not tar.gzs), and the untarred dirs, so I am left with this:

c:\apps\installerLocal>dir

Volume in drive C is os

Volume Serial Number is 52B0-C9DB

Directory of c:\apps\installerLocal

03/15/2012 02:47 PM <DIR> .

03/15/2012 02:47 PM <DIR> ..

03/15/2012 02:40 PM 8,324,124 apache-ant-1.8.2-bin.tar.gz

03/15/2012 02:40 PM 6,697,806 apache-tomcat-6.0.35.tar.gz

03/15/2012 02:36 PM 40,315,474 grouper.apiBinary-2.1.0.tar.gz

03/15/2012 02:34 PM 2,444,285 grouper.clientBinary-2.1.0.tar.gz

03/15/2012 02:36 PM 18,965,034 grouper.psp-2.1.0.tar.gz

03/15/2012 02:35 PM 10,375,981 grouper.ui-2.1.0.tar.gz

03/15/2012 02:42 PM 33,856,319 grouper.ws-2.1.0.tar.gz

03/15/2012 02:32 PM 1,581,099 grouperInstaller.jar

03/15/2012 02:39 PM 221,647 quickstart.xml

03/15/2012 02:39 PM 46,230 subjects.sql

10 File(s) 122,827,999 bytes

2 Dir(s) 472,167,538,688 bytes free

c:\apps\installerLocal>

You can zip up that folder, and move to another machine with no internet access…

Then I unplug my network cable, and run the installer. In my case the DB and tomcat don’t start since the network is messed up, but maybe it will in your case where you are networked on a private network with no internet access? J Anyways, you will see errors below that you might not see in your situation. Note it detected the downloaded tar gzs and you specify if you want to download them again…

c:\apps\installerLocal>java -jar grouperInstaller.jar

Enter in the Grouper install directory (note: better if no spaces or special chars) [c:\apps\installerLocal]:

Enter the default IP address for checking ports (just hit enter to accept the default unless on a machine with no network, might want to change to 127

.0.0.1): [0.0.0.0]: 127.0.0.1

Note, you will probably need to change the hsql port, and tomcat server.xml ports...

Installing grouper version: 2.1.0

Downloading from URL: http://www.internet2.edu/grouper/release/2.1.0/grouper.apiBinary-2.1.0.tar.gz to file: c:\apps\installerLocal\grouper.apiBinary-

2.1.0.tar.gz

File exists: c:\apps\installerLocal\grouper.apiBinary-2.1.0.tar.gz, should we use the local file (t|f)? [t]:

Unzipping: c:\apps\installerLocal\grouper.apiBinary-2.1.0.tar.gz

Expanding: c:\apps\installerLocal\grouper.apiBinary-2.1.0.tar

Do you want to use the default and included hsqldb database (t|f)? [t]:

Editing c:\apps\installerLocal\grouper.apiBinary-2.1.0\conf\grouper.hibernate.properties:

- property hibernate.connection.url already was set to: jdbc:hsqldb:hsql://localhost:9001/grouper, not changing file

- property hibernate.connection.username already was set to: sa, not changing file

- property hibernate.connection.password already was set to: , not changing file

Do you want this script to start the hsqldb database (note, it must not be running in able to start) (t|f)? [t]:

HSQL was not detected to be running (did not successfully stop it)

Starting DB with command: c:\dev_inst\java\bin\java -cp c:\apps\installerLocal\grouper.apiBinary-2.1.0\lib\jdbcSamples\hsqldb.jar org.hsqldb.Server -d

atabase.0 file:c:\apps\installerLocal\grouper.apiBinary-2.1.0\grouper -dbname.0 grouper -port 9001

Checking database with query: SELECT 1 FROM INFORMATION_SCHEMA.SYSTEM_USERS

Error: could not connect to the database:

java.lang.RuntimeException: Error with query: SELECT 1 FROM INFORMATION_SCHEMA.SYSTEM_USERS

at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.listSelect(GiDbUtils.java:385)

at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.listSelect(GiDbUtils.java:308)

at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.select(GiDbUtils.java:319)

at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.checkConnection(GiDbUtils.java:459)

at edu.internet2.middleware.grouperInstaller.GrouperInstaller.checkDatabaseConnection(GrouperInstaller.java:1589)

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

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

Caused by: java.lang.RuntimeException: Error connecting to: null

at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.connection(GiDbUtils.java:295)

at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.listSelect(GiDbUtils.java:349)

... 6 more

Caused by: java.sql.SQLException: Connection is broken: java.net.SocketException: Connection reset

at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)

at org.hsqldb.jdbcDriver.getConnection(Unknown Source)

at org.hsqldb.jdbcDriver.connect(Unknown Source)

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

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

at edu.internet2.middleware.grouperInstaller.util.GiDbUtils.connection(GiDbUtils.java:291)

... 7 more

Do you want to init the database (delete all existing grouper tables, add new ones) (t|f)? f

Do you want to add quickstart subjects to DB (t|f)? [t]:

Downloading from URL: http://anonsvn.internet2.edu/cgi-bin/viewvc.cgi/i2mi/tags/GROUPER_2_1_0/grouper-qs-builder/subjects.sql?view=co to file: c:\apps

\installerLocal\subjects.sql

File exists: c:\apps\installerLocal\subjects.sql, should we use the local file (t|f)? [t]:

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

Adding sample subjects with command: cmd /c c:\apps\installerLocal\grouper.apiBinary-2.1.0\bin\gsh.bat -registry -runsqlfile c:\apps\installerLocal\su

bjects.sql -noprompt

stderr: Couldnt startup grouper: Problem adding include/exclude type: addIncludeExclude

java.lang.RuntimeException: Problem adding include/exclude type: addIncludeExclude

at edu.internet2.middleware.grouper.misc.GrouperStartup.initIncludeExcludeType(GrouperStartup.java:364)

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

at edu.internet2.middleware.grouper.registry.RegistryInitializeSchema.main(RegistryInitializeSchema.java:172)

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

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

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

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

at edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:189)

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

at edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:16)

Caused by: edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem in HibernateSession: HibernateSession: isNew: true, isReadonly:

true, grouperTransactionType: READONLY_NEW,

Exception in uniqueResult: (class edu.internet2.middleware.grouper.Member), ByHqlStatic, query: 'from Member as m where m.subjectIdDb = :si

d and m.subjectSourceIdDb = :source and m.subjectTypeId = :type', cacheable: true, cacheRegion: edu.internet2.middleware.grouper.internal.dao.h

ib3.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._internal_hibernateSessionCatch(HibernateSession.java:433)

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

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

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

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

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

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

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

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

at edu.internet2.middleware.grouper.misc.GrouperStartup.initIncludeExcludeType(GrouperStartup.java:304)

... 9 more

Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection

at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)

at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)

at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)

at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)

at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)

at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)

at org.hibernate.loader.Loader.doQuery(Loader.java:801)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)

at org.hibernate.loader.Loader.doList(Loader.java:2533)

at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2319)

at org.hibernate.loader.Loader.list(Loader.java:2268)

at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)

at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)

at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)

at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)

at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)

at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890)

at edu.internet2.middleware.grouper.hibernate.ByHql.uniqueResult(ByHql.java:242)

at edu.internet2.middleware.grouper.hibernate.ByHqlStatic$1.callback(ByHqlStatic.java:306)

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

... 17 more

Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!

at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)

at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)

at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)

at org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:78)

at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)

... 34 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:1319)

at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)

at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)

at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)

... 37 more