Skip to Content.
Sympa Menu

grouper-users - [grouper-users] RE: Update Grouper DB Schema

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] RE: Update Grouper DB Schema

Chronological Thread 
  • From: "Black, Carey M." <>
  • To: Akki Kumar <>
  • Cc: "" <>, "Stephen A Sazama" <>, "Hyzer, Chris" <>
  • Subject: [grouper-users] RE: Update Grouper DB Schema
  • Date: Thu, 15 Jun 2017 20:36:08 +0000
  • Accept-language: en-US
  • Authentication-results: spf=pass (sender IP is;; dkim=none (message not signed) header.d=none;; dmarc=pass action=none;
  • Ironport-phdr: 9a23:9cd4bxPm1chLskf22EYl6mtUPXoX/o7sNwtQ0KIMzox0K/z7oMbcNUDSrc9gkEXOFd2CrakV1KyJ7Ou5BDRIyK3CmUhKSIZLWR4BhJdetC0bK+nBN3fGKuX3ZTcxBsVIWQwt1Xi6NU9IBJS2PAWK8TW94jEIBxrwKxd+KPjrFY7OlcS30P2594HObwlSijewZbF/IA+0oAjTucUanItvJroswRbVv3VEfPhby3l1LlyJhRb84cmw/J9n8ytOvv8q6tBNX6bncakmVLJUFDspPXw7683trhnDUBCA5mAAXWUMkxpHGBbK4RfnVZrsqCT6t+592C6HPc3qSL0/RDqv47t3RBLulSwKLCAy/n3JhcNsjaJbuBOhqAJ5w47Ie4GeKf5ycrrAcd8GWWZNW8BcXDFDDIyhdYsCF+oPM/hFoYnhqVUArhW+CgutBOzzxTBFnWX50bE+3uk7DQ3KwA4tEtQTu3rUttX1M6ISXPi7wKTVyTXMde9Z2TTl5IPVbB0uu+uMUqxwcMHMzkcjDQ3JhUiXpIP+OzOazPgCs2uB4+Z9S+6ihXUqqwZqojiy3MsjlJTGhp8Mx13C6C53zoE1JdiiR056Z96pCJpQtyeGN4RoWMMiRX9nuDokxrEcp5G0YTUKxZI6zBDcc/yKa5aE7Qj/WOqMJDp0mW9pdK+6iha8/kWs1vHwW8y60FlUoSdIk9zBu3UP2hHd98SLUuZx8lmi1DqVygze5eBJLVowmKfUMZIt3KA8m5gLvUTNACD7m1n6gaqTe0gk5uen9+rnb7D4qpKTNoJ7lwTzP6sul8G9D+k1NxQBUHOA9uum0rDo4Ff3T69QjvIsl6nUqJDaKtofpq6+GwJbypou5RGjAzu4ydgVgH8JIExcdBKAlIfmJUvCIPflDfejmFuslyprx/bbMbH7GpXNNH/DkKv/crlh905cyQ0zzdZF65JTF7EBPPbzWkj2tNzbFBM2Lwu0w+P/BNV80IMRR36PD7eHPKzIrVOE++ciL/SRaIMIvTv9Jfco6+LygXI8l18SY6ak0JoSZX29HPlrLViVbWLpgtgbEGcKugQ+TPbtiF2HSTNcfHKyULgg6TE4Eo6qEJnPS462jbyGxye7A4daaX5bBVCRCXvobZmLW+8QaCKOJc9sijMEVaKmS488zRGhqhX6x6N6LurP5CIYr4nj2cNx5+3SjhEy6Sd0A9qH32GMSWF0gn0HRyUw3K9hvUxx1E2P3rZljPxFRpRv4KZgUQQ7fb3ByuVgQ4T7XwvTf9GGUUurWcmnBjcqFopu69ALakd5Xd6li0aQ8TCtBupfvbiCD59wuonVxXXgb+M7gT6S3q0ohFpgG5EUHWq9m+hy+xWFVN2BqFmQi6v/LfdU5yXK7mrWiDPW5Ew=
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:99



I think you also need to upgrade all of the components.


The first one will change the DB.

                Which may (or could) cause older components/parts some “problems” until they are upgraded.

                I don’t _know_ that you will have issues, but I would find it hard to believe that everything would work “as expected” in a mixed version grouper universe. ( but maybe)

                I think it all depends on the details of the DB structure changes and the expectations of each grouper component.



I think the “best” (better safe than sorry approach) process would be to:

                Down everything. (All UI’s, WS, PSP’s, loaders, etc..)

                                Take your backups. (ß always a good idea. J )

                Upgrade the “most important things” (a API, UI and Loader, maybe WS if you require that too) then bring them up.

                Then upgrade anything else (load balanced redundant servers?) and bring those back up too.


This might be of some help too:



                And if you have not found this page, about patching, it is a good idea (IMHO too)



However, I have yet to do an “upgrade” with this app. ( So “your mileage may vary”. )

Good luck.



Carey Matthew


From: [mailto:] On Behalf Of Hyzer, Chris
Sent: Thursday, June 15, 2017 3:18 PM
To: Akki Kumar <>
Cc: ; Stephen A Sazama <>
Subject: [grouper-users] RE: Update Grouper DB Schema


Whatever system you are setup in… J


If you have a webapp pointing to the schema, select ui or ws (whichever it is).  If you have an api pointing to it, pick api…





From: Akki Kumar []
Sent: Thursday, June 15, 2017 3:16 PM
To: Hyzer, Chris <>
Cc: ; Stephen A Sazama <>
Subject: Re: Update Grouper DB Schema


Hi Chris,


Thank you for the prompt reply. When I select "update", the only option there are apiuiwspspng, or psp. No option for the DB schema update, which option should I select? (I tried api and that didn't update the schema)


Enter in a Grouper temp directory to download tarballs (note: better if no spaces or special chars) [/grouperInstaller_DB/tarballs]:

What do you want to upgrade?  api, ui, ws, pspng, or psp? [API]: 


Thank you,



On Thu, Jun 15, 2017 at 3:02 PM, Hyzer, Chris <> wrote:

In the installer, instead of picking “install”, pick “update”.  Does it work?  It should update the schema.  Send me the output, logs and SQL script so I can take a look





From: Akki Kumar [mailto:]
Sent: Thursday, June 15, 2017 2:36 PM
To: Hyzer, Chris <>
Cc: ; Stephen A Sazama <>
Subject: Update Grouper DB Schema


Hi Chris,


I am upgrading Grouper DB Schema from v2.2.2 to v2.3.0. I tried running the Grouper 2.3.0 installer, but it ends up initializing DB completely instead of updating schema. Is there a way to update just Grouper schema (keeping data intact) from v2.2.2 to v2.3.0?


Thank you,





Archive powered by MHonArc 2.6.19.

Top of Page