Grouper Users - Open Discussion List

[Keith Hazelton <>]

Nevermind. Got past this, too.  Thanks again --k

 

From: <> on behalf of Keith Hazelton <>
Date: Thursday, March 23, 2017 at 11:53
To: "" <>
Subject: [grouper-users] Re: lost hsql password

 

Restarting hsql fixed that, as you expected. Now looking at an NPE at Grouper startup, something to do with c3p0 connection pool.

 

      Thanks,   --Keith

 

INFO: Jk running ID=0 time=0/19  config=null

Mar 23, 2017 4:39:39 PM org.apache.catalina.startup.Catalina start

INFO: Server startup in 15740 ms

Exception in thread "C3P0PooledConnectionPoolManager[identityToken->dzyyhr9m1xxj3a7lveufb|69cd401]-AdminTaskTimer" java.lang.NullPointerException

      at com.mchange.v2.log.slf4j.Slf4jMLog$Slf4jMLogger.levelLogger(Slf4jMLog.java:164)

 

 

From: Chris Hyzer <>
Date: Thursday, March 23, 2017 at 11:32
To: Keith Hazelton <>, "" <>
Subject: RE: lost hsql password

 

I think the hsql server died or is hung and you need to (re)start…

 

Note, the installer can (re)start the hsql for you…

 

https://spaces.internet2.edu/display/Grouper/Grouper+installer+admin+tool#Grouperinstalleradmintool-Admin-manage-services-database(onlyhsql):

 

Or you can run a command like this (from README):

 

Run from the GROUPER_HOME directory:

 

    % java -cp lib/jdbcSamples/hsqldb.jar org.hsqldb.Server -port 9001 -database.0 file:grouperHSQL -dbname.0 grouper

 

Note, you either need to run that command in the background, or use a terminal window that will wait for the server to exit.

 

Ps: I think there is no password!  J

 

From: [mailto:] On Behalf Of Keith Hazelton
Sent: Thursday, March 23, 2017 10:58 AM
To:
Subject: [grouper-users] lost hsql password

 

Using Grouper-2.3.0 on CentOS 7. Probably too many cooks: Somewhere along the line, the password in grouper.hibernate.properties stopped working, and grouper fails to start with a ‘refused database connection’ message.

 

Is there any way to determine or change the password in question?

 

…jdbc:hsqldb:hsql://localhost:9001/grouper, driver: org.hsqldb.jdbcDriver, user: sa…

 

           --Keith

 

___________________________________

email & jabber:

calendar: http://go.wisc.edu/i6zxx0