Grouper Users - Open Discussion List

["Hyzer, Chris" <>]

Another method for shutting down hsql is:

 

 

[mchyzer@i2midev1 bin]$ ps -ef | grep -i hsql

mchyzer  27870 19008  0 20:44 pts/0    00:00:00 grep -i hsql

[mchyzer@i2midev1 bin]$ nohup /opt/java8/bin/java -cp /tmp/installer/grouper.apiBinary-2.3.0/lib/jdbcSamples/hsqldb.jar org.hsqldb.Server -database.0 file:/tmp/installer/grouper.apiBinary-2.3.0/grouper -dbname.0 grouper -port 9001 &

[1] 27986

[mchyzer@i2midev1 bin]$ ps -ef | grep -i hsql

mchyzer  27986 19008 17 20:45 pts/0    00:00:02 /opt/java8/bin/java -cp /tmp/installer/grouper.apiBinary-2.3.0/lib/jdbcSamples/hsqldb.jar org.hsqldb.Server -database.0 file:/tmp/installer/grouper.apiBinary-2.3.0/grouper -dbname.0 grouper -port 9001

mchyzer  28001 19008  0 20:45 pts/0    00:00:00 grep -i hsql

[mchyzer@i2midev1 bin]$ echo 'SHUTDOWN' > stopHsql.sql

[mchyzer@i2midev1 bin]$ ./gsh -registry -runsqlfile stopHsql.sql

Using GROUPER_HOME: /tmp/installer/grouper.apiBinary-2.3.0/bin/..

Using GROUPER_CONF: /tmp/installer/grouper.apiBinary-2.3.0/bin/../conf

Using JAVA: /opt/java8/bin/java

using MEMORY: 64m-750m

This db user 'sa' and url 'jdbc:hsqldb:hsql://localhost:9001/grouper' are allowed to be changed in the grouper.properties

Continuing...

Error running script: /tmp/installer/grouper.apiBinary-2.3.0/bin/stopHsql.sql, java.sql.SQLTransientConnectionException: connection exception: connection failure: java.net.SocketException: Broken pipe

        at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:463)

        at edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.sqlRun(GrouperDdlUtils.java:1027)

 

Ignore the stack, the DB is shutdown…

 

[mchyzer@i2midev1 bin]$ ps -ef | grep -i hsql

mchyzer  27870 19008  0 20:44 pts/0    00:00:00 grep -i hsql

 

 

From: Hyzer, Chris
Sent: Friday, November 18, 2016 3:34 PM
To: 'Paul Huckins' <>;
Subject: RE: [grouper-users] Newbie help (LDAP)

 

I just ran the installer and it says this:

 

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: /opt/java8/bin/java -cp /tmp/installer/grouper.apiBinary-2.3.0/lib/jdbcSamples/hsqldb.jar org.hsqldb.Server -database.0 file:/tmp/installer/grouper.apiBinary-2.3.0/grouper -dbname.0 grouper -port 9001

Checking database with query: SELECT 1 FROM INFORMATION_SCHEMA.SYSTEM_USERS

Successfully tested database connection

 

 

So to start the DB, run that command.

 

Yes, to stop you need to kill the process.  For tomcat, you can do this:

 

Tomcat start with command (note you need CATALINA_HOME and JAVA_HOME set):

  /tmp/installer/apache-tomcat-6.0.35/bin/startup.sh

 

Tomcat start with command (note you need CATALINA_HOME and JAVA_HOME set):

  /tmp/installer/apache-tomcat-6.0.35/bin/shutdown.sh

 

I will try to make the installer easier to work with these things…

 

Ok?

 

Thanks

Chris

 

-----Original Message-----
From: Paul Huckins []
Sent: Friday, November 18, 2016 1:24 PM
To: Hyzer, Chris <>;
Subject: RE: [grouper-users] Newbie help (LDAP)

 

 

 

Hi Chris,

 

Ok, I re-installed it all. I saved every line this time and there is no mention of how to start the data base at all.

 

So ps -elf | grep java says this.

 

0 S root     11528     1  1  80   0 - 449588 futex_ 14:59 pts/0   00:00:48 /usr/lib/java-1.7.0/bin/java -cp /opt/grouper/grouper.apiBinary-2.3.0/lib/jdbcSamples/hsqldb.jar org.hsqldb.Server -database.0 file:/opt/grouper/grouper.apiBinary-2.3.0/grouper -dbname.0 grouper -port 9001

 

I am going to assume that it is correct.

 

So before I get to deep into LDAP I should ask.

 

What is the recommended procedure for shutting this thing down and bringing it up?

 

I did see the commands for tomcat.

 

Tomcat says I need to set CATALINA_HOME (pretty standard but I did not see where it was done in the install procedure)

 

I have JAVA_HOME and GROUPER_HOME set.

 

I am guessing that the best way to start it is

 

Database

Tomcat

Grouper

 

And reverse for shutdown

 

What is a clean command (rather than kill -9) to shutdown grouper (The script that is used to start it has no stop options that I can see).

 

Thanks for any insight. I will post solutions as I work them out.

 

P

 

-----Original Message-----

From: Hyzer, Chris []

Sent: Thursday, November 17, 2016 11:21 AM

To: Paul Huckins;

Subject: RE: [grouper-users] Newbie help (LDAP)

 

When the installer ran it gave you the command to start hsql.

 

Here is an outdated output which is from a different folder, but something like this:

 

https://spaces.internet2.edu/display/Grouper/Grouper+Installer

 

Starting DB with command: C:\dev_inst\java\bin\java -cp C:\temp\grouperInstaller\grouper.apiBinary-2.0.2\lib\jdbcSamples\hsqldb.jar org.hsqldb.Server -database.0 file:C:\temp\grouperInstaller\grouper.apiBinary-2.0.2\grouper -dbname.0 grouper

 

Does that help?  I recommend getting an oracle or mysql or postgres schema, changing the grouper.hibernate.properties and using a database that is up for you...

 

Or if you want to install again and note the commands, or try to figure it out from the line above...

 

Thanks

Chris

 

 

-----Original Message-----

From: Paul Huckins []

Sent: Thursday, November 17, 2016 12:44 PM

To: Hyzer, Chris <>;

Subject: RE: [grouper-users] Newbie help (LDAP)

 

 

 

All of them  ?

 

Actually I have a more pressing problem at the moment.

 

I stopped Grouper (killed it at the command line) and it will not re-start because the java data base " hsqldb" is not starting prior.

 

I found a script from grouper 1(dot)somthing that started the DB but started the wrong version of it.

 

(here is what I did)

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

 

Once I have my DB running and can start grouper again I need to configure an LDAP connector so that grouper can reference my LDAP directory.

 

Maybe I am being to "old school" about this. Most applications have some kind of config file that details the access to other things (like LDAP, AD or a data base).

 

It almost looks like (in grouper) that when you create a group you define the data source (LDAP info).

 

I have gotten so far as to find

 

GROUPER_HOME/conf/grouper-loader.base.properties

GROUPER_HOME/conf/grouper-loader.properties

 

I edited the base file (which I know is backwards of what I am supposed to do)

But since I cannot re-start grouper due to the hsqldb issues I cannot tell if I am making progress with LDAP or not.

 

THANK YOU

For your reply

 

 

 

 

 

 

 

 

 

-----Original Message-----

From: Hyzer, Chris []

Sent: Wednesday, November 16, 2016 7:22 PM

To: Paul Huckins;

Subject: RE: [grouper-users] Newbie help (LDAP)

 

There is the subject source where you get subjects from (e.g. users), Grouper uses this to add people to groups, to know which users exist, their name, description, attributes, etc

 

There is the loader where grouper reads from LDAP and makes group memberships (or a list of groups and their memberships) [this is the mashed settings one]

 

And finally the pspng, where grouper will provision group memberships into an LDAP.

 

Which are you interested in?

 

Thanks

Chris

 

 

-----Original Message-----

From: [] On Behalf Of

Sent: Wednesday, November 16, 2016 4:44 PM

To:

Subject: [grouper-users] Newbie help (LDAP)

 

I am new at Grouper. I have watched some of the video tutorials.

 

I installed it on a RHEL7 box with java 7.

 

The web front end is working and I can get into it.

 

We have a mix of LDAP and AD here. I think I need to configure Grouper to see both our LDAP infrastructure and our AD infrastructure but cannot seem to find the configuration files to set that up.

 

There also seems to be an indication that it (LDAP configuration) is not done with config files anymore but somehow mashed into the settings when you create a group.

 

I have only been at this for a few days. Our grouper version is whatever is most current (2.3.2 I think).

 

I have googled a lot and found various docs relating to config files that no longer seem to exist.

 

Any sage words of advice (or a pointer at a current tutorial for said issue)

 

Thanks for your help

PH