Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] Re: lost hsql password

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] Re: lost hsql password


Chronological Thread 
  • From: Keith Hazelton <>
  • To: "" <>
  • Subject: Re: [grouper-users] Re: lost hsql password
  • Date: Thu, 23 Mar 2017 17:34:29 +0000
  • Accept-language: en-US
  • Authentication-results: internet2.edu; dkim=none (message not signed) header.d=none;internet2.edu; dmarc=none action=none header.from=wisc.edu;
  • Ironport-phdr: 9a23:1ooBxRP3+0/fIrIgHjMl6mtUPXoX/o7sNwtQ0KIMzox0I/3zrarrMEGX3/hxlliBBdydsKMZzbWN+Pm4ACQp2tWoiDg6aptCVhsI2409vjcLJ4q7M3D9N+PgdCcgHc5PBxdP9nC/NlVJSo6lPwWB6nK94iQPFRrhKAF7Ovr6GpLIj8Swyuu+54Dfbx9GiTe5Yb5+Nhe7oAveusULnYduN7s6xwfUrHdPZ+lY335jK0iJnxb76Mew/Zpj/DpVtvk86cNOUrj0crohQ7BAAzsoL2465MvwtRneVgSP/WcTUn8XkhVTHQfI6gzxU4rrvSv7sup93zSaPdHzQLspVzmu87tnRRn1gyoBKjU38nzYitZogaxVoByvuh1/zZDXboGJOvVzZbnScc8fRWpFQspcTS5MD4WhZIUPFeoBOuNYopH4qVQQrBu+GQmsD/7txDBSh375w6k60/gmEQHAwQctGNEOv2rVrNXpNKceS+C1w7PJzDrda/NWxTD96I7TfxEvoPGMRq5/fdDPxkYyCgPIl1OdopHrMTOS0+QCqWmb7+x4WOKujW4ntx9+oiKpxsgylonFmJgZxU7Z+iVk2Io0K9y4SFVnbtK+DpRfqjyaOo1rSc0hW2FloDs2x7IJtJKheCUG1o4rywPbZvGFaYSE/x3uWPuJLTp5hX9pYq+zihex/ES6yuDxWdO43EtFoyZbitXAqGwB2h7J5sWIS/Zx5Fqt1DeB2gzJ6exIP0Y5nrfBJZE72L4/jJ8TvFzDHiDonEX2i7ebdl4h+ui08+ToeKjmpoOcN4NpkA3/PKUumtejDuQ9KAcOXmyb9f6y1b3i5k32XK9GgeMrnanEqJzaJMIbqbClAwJNz4ou5BmyAy2i3dgGh3ULMVZIdRCdg4T0NFzCPej0DfKljFStlDdryerGPrrkApjVLXjMjrbhfap960JGyAo819Fe6IxQCrEdJ/LzXFT8tdLZDh8iLwO42fjoB8hg1o8GQ2KAHreZML/OsV+P/u8vLPOMZIgIuDblNfcl/efijWIimVADZ6mpxoAaaHS5HvR9P0WZemTgjs0AEWcMogoxUvbqiFucXj5PeXq+Rbwz6SwmCNHuMYCWDI+3h6GZ0T3+A4ZbfHtuC1aQHG3uepneHfoAdWjadsB7lSEcWKLkVpQszwqGtQnmxqBhI/aOvCAUqMSw+sJy4rjwmBAu9XRUBtaQ132KSSkgnW4JWz9w3KltrEhhzVGrzqljiLpVGcEFtKABaRszKZOJl78yMNv1QA+UJto=
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:99

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

 



  • Re: [grouper-users] Re: lost hsql password, Keith Hazelton, 03/23/2017

Archive powered by MHonArc 2.6.19.

Top of Page