Grouper Developers Forum

[Jim Fox <>]

> We have a 2.2.0 Grouper candidate build that we are doing final testing on.  
> It will be released in a couple weeks.  If you want to try the
> candidate tarballs to test an upgrade or sanity test or unit tests or 
> whatever, let me know and I can send you a link.  This will help ensure that
> there are not any obvious issues with 2.2.0.  Note, Im pretty sure there will 
> be some tweaks before now and then, so you should get the official
> release when it is done for production use.

Here's University of Washington's experience testing the upgrade.

TLDR; Conversion of the database went OK.  Took a long time though.
      Even if I had been as efficient as possible it would take 12 hours.

Jim

------- details -------------------------------------------------------------

Note.  I only tested the grouper API.  We don't use the UI or the grouper 
web services.  When I have time I'll try out the new UI.

Following the "v2.2 Upgrade Instructions from v2.1"

1) Get the 2.2.0 binaries.

2) Edit the conf files.

   a) Extract our local config changes to the new, cascading conf
      files.   How about these?

      sources.xml:  looks like they need no conversion at all.
      log4j.conf:   ditto

      correct?

3) Made a copy of my prod database

   $ time  (ssh iamdb11 '/usr/local/pgversion/bin/pg_dump -U postgres gws2'; 
echo '\q') | psql -U postgres gwstest

   [[ took about 1 hour ]]

4) Generated conversion script

   $ time  bin/gsh.sh -registry -check

   [[ took about 2 hours ]]

   The generated script was about 300,000 lines long.  I didn't 'carefully 
review it'.

   I did check for the foreign key being dropped.

   Note:  'you should see foreign keys being dropped' means 'ALTER TABLE xxx 
DROP constraint yyy;'

5) Run conversion script

   Question.  If it gets interrupted, can this script be rerun?

   $ time ./bin/gsh.sh -registry -runsqlfile 
.../grouperDdl_20140619_18_27_25_753.sql

   [[ took about 6 minutes ]]

6) Run secondary conversion

   $ time $ ./bin/gsh.sh misc/postGrouper2_2Upgrade.gsh

   Note:  I edited this script to comment out the PIT parts, since we don't 
use those.

   [[ lost the time.  But I think about 8 hours. ]]

   Numbers were: (I think I lost track of some of them)

   Found 156481 group type assignments
   Found 443817 attribute assignments
   Found 28612 missing self stemSets

--- end of conversion ---

7) Installed the grouper.jar and grouperCLient.jar and the configs into my 
group serice app.

   Also copied in some upgraded jars.
   Note.  It isn't at all clear which jars from the lib directory need to be 
upgraded
   for an app.  I copied in:

     vt-ldap.jar
     hibernate.jar
     hibernate-jpa-2.0-api.jar

8) Started the app.  Works.