Grouper Users - Open Discussion List

[Tom Barton <>]

I'm switching this over to grouper-users...

RL 'Bob' Morgan wrote:

> So, I'm trying to use qs, which is configured to use hsqldb.  It appears 
> to me that hsqldb isn't running (nothing is on port 9001).  The qs 
> document has a section entitled "Starting HSQLDB" which doesn't appear 
> to me to say anything about starting it, just configuring it.  Am I 
> supposed to do some manual step to start hsqldb?

Yup. You need to run something like

    java -cp <location of hsqldb.jar> \
        org.hsqldb.Server \
        -database.0 <location of grouper database> \
        -dbname.0 grouper \
        -user sa

That will put up a server on port 9001 offering a database named 
'grouper'. Assuming that before long you'll also run signet, with this 
approach you can simply expand that command to something like

    java -cp <location of hsqldb.jar> \
        org.hsqldb.Server \
        -database.0 <location of grouper database> \
        -dbname.0 grouper \
        -database.1 <location of signet database> \
        -dbname.1 signet \
        -user sa

So, your jdbc urls will look like

    jdbc:hsqldb:hsql://localhost/grouper

and

    jdbc:hsqldb:hsql://localhost/signet

(presuming localhost, of course). Note that <location of grouper 
database> is the pathname of the .script file, exclusive of '.script'. 
So, if you've got a database in '/opt/registries/grouper-demo.script', 
put '/opt/registries/grouper-demo' as the -dbname.0 parameter value.

Tom