Skip to Content.
Sympa Menu

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

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] Re: lost hsql password


Chronological Thread 
  • From: Keith Hazelton <>
  • To: "" <>
  • Subject: [grouper-users] Re: lost hsql password
  • Date: Thu, 23 Mar 2017 16:53:23 +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:WmuCABOcQh1DkjKsRIkl6mtUPXoX/o7sNwtQ0KIMzox0I/76rarrMEGX3/hxlliBBdydsKMZzbWN+PG6EUU7or+5+EgYd5JNUxJXwe43pCcHRPC/NEvgMfTxZDY7FskRHHVs/nW8LFQHUJ2mPw6arXK99yMdFQviPgRpOOv1BpTSj8Oq3Oyu5pHfeQtFiT69bL9oLhi7owrdu80IjYB/Nqs/1xzFr2dSde9L321oP1WTnxj95se04pFu9jlbtuwi+cBdT6j0Zrw0QrNEAjsoNWA1/9DrugLYTQST/HscU34ZnQRODgPY8Rz1RJbxsi/9tupgxCmXOND9QL4oVTi+6apgVRnlgzoFOTEk6mHaksJ+gqJGrh2jphxx3Y3aYJ2bNPVwZa7SZ88WRW9FXspNTSFMAIWxZJYPAeobOuZYqpHwqV4Qohu/GQmsBP7kxD1SiX73w6I61/ghEQbA3Ac9GN8Os2rbrNTpNKcSS+y1zLPHzDTdYPNSxTf9747IfwsvoPGNRrJ/bdDdxlcyGAPYl1idr5HuMT2S1uQIqWeb7uxgWPqui24htwF+vCKvxsEyhYnVmI4Z0E7L+jhkwIotK9y4SVV7bsK+HJROqi6aKo17Sd4hTWFwoCs217ILtJGhcCUO1pgr3QPTZviFfoSS/B7vSvidLS95iX9kYr6zmhe//Eu6xuD8WcS4yktGoyVbntXUqHwByh3e5tKJR/dj5EutxDWC2x3J5u1ZIk05mqzWIIM7zLEqjJocq0HDEzf2mEroiK+WcV0p+vOt6+T7erXpvIKcN5N0ig3gKKgvlM2/Af8kPQgLRWeb+OC82Kft/E34W7VFkuc6nbfEv5DHPcgbp6i5DBFJ0os79hqyADir3M4ckHUZNl5JZRaKgorzN13QPvz0E++zg1G2nzdqw/DGMKfhApLILnXbk7fuY7d961JcyAYpzdBQ/ZNVBa8FIPLvXU/xssfVDxE4Mwyv3+nrEsty2Z4DWW6XGK+WLLvSsUOU5uIoO+SMa5UVuDHgK/g9+fHul2Y1mUIGfaa3x5sXc2u1HvBnI0WCfXrsmckNHX0Lvgo4UOzllkeCUThNaHauQa4w/C80B5+7DdSLeof4yrOb2zqjE4cTe3tLEEukEHH0ep+CVutWLi+eP4UpxjMeUqW5RpVkyAqjrhTSyrx7I/DS9zFC85/vyY4myffUkEQR+D1oD4y92nOAS31zmCtcRDI3wKA5oUVvx1Of1q5QnP1DHppe6+4fAVRyDoLV0+EvU4O6YQnGZNrcEFs=
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:99

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

 




Archive powered by MHonArc 2.6.19.

Top of Page