Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] Change loader db name?

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] Change loader db name?

Chronological Thread 
  • From: Richard Frovarp <>
  • To: " Mailing List" <>
  • Subject: Re: [grouper-users] Change loader db name?
  • Date: Thu, 31 Oct 2019 17:29:14 +0000
  • Arc-authentication-results: i=1; 1; spf=pass; dmarc=pass action=none; dkim=pass; arc=none
  • Arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed;; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=daflxHZYk1p3j+8nDcXxA4lPSoynPyImaQzdDw8xclQ=; b=W0kc6ogdqYyqs34BHOUt81uzlgUW78OLrA2L+IdpSJ4vpAACLZJjJY1H4BA9Q0wtBTRAvlljugDx/42IWnXAyjbrBnsiizXuz9z+l4dohNIMtrfgxXlI2hQFRGdWoV9QqEl8BJPw9KO1Ri6X8RGcyTrRImAfFC4slUtDsHDc/MVEmnLvHpKNZ/CI3rYxQ3zFRfbH3vuhZxJsdODaB4MUWfKNMxpd5VpOCYIodTGO376rzdyi0dYLKv5TuBF6UqqJpI5P/pipt69ejTbvuDWQNP0LpA7wWif+an/Y8Z2656hcswtYpFJbf0b7yARb6iK64I4XDKvd81VqmKSQYyWekQ==
  • Arc-seal: i=1; a=rsa-sha256; s=arcselector9901;; cv=none; b=hWLv8+cYBG3s5GAZTmSbT9rkahIILcD6WSr3hHkhgH4lkUWmzmvouu9qkUNxJgeqbOegcvfgApPI1f1HWZxYgDQ9qv5cSYxGasbDxX/+BfhzY+GMMt5ADaNXLATP+GAltLDNfMeSD+Fzxa+xNuXJ9C2sr17c8P3dfbaV05wTqj4cepF2x25PNk5e1W1KEDXaBfQgyihNuygAs/lbPB4+mVWlT6cX67gycIPG7bzQe1WLB6iUB+jDnv8J/4yuiRXMTQ89CpHhf72qyLFG4kTkkCIyQYhnE6eNyGLPF4TrdPgKR/FpT20UfW1h3iwLHEa0yT2fGTOOVkoi9qCoyi4wVQ==

I was able to follow Chris' suggestion. Don't know about point in time data, but it was outside of my concern. Thanks for all of the advice.

On 10/31/19 12:20 PM, Shilen Patel wrote:

I think since this is a direct DB update, the point in time data won’t be updated.  So to do that:


update grouper_pit_attr_assn_value gaav set value_string = 'pennCommunity'  where gaav.value_string='grouper' and gaav.ATTRIBUTE_ASSIGN_ID in

(select from grouper_pit_attribute_assign aa where aa.source_id in

(select  gaaagv.attribute_assign_id2 from grouper_aval_asn_asn_group_v gaaagv where gaaagv.value_string = 'pennCommunity'

  and attribute_def_name_name2 = 'penn:etc:legacy:attribute:legacyAttribute_grouperLoaderDbName'));


It should update the same number of rows.




- Shilen


From: on behalf of "Hyzer, Chris"
Reply-To: "Hyzer, Chris"
Date: Thursday, October 31, 2019 at 10:17 AM
To: Richard Frovarp ,
Subject: Re: [grouper-users] Change loader db name?


I did something like this:


Find loader jobs:

select  gaaagv.attribute_assign_id2 from grouper_aval_asn_asn_group_v gaaagv where gaaagv.value_string = 'grouper'
  and attribute_def_name_name2 = 'penn:etc:legacy:attribute:legacyAttribute_grouperLoaderDbName'


Update them:

update grouper_attribute_assign_value gaav set value_string = 'pennCommunity'  where gaav.ATTRIBUTE_ASSIGN_ID in

(select  gaaagv.attribute_assign_id2 from grouper_aval_asn_asn_group_v gaaagv where gaaagv.value_string = 'grouper'

  and attribute_def_name_name2 = 'penn:etc:legacy:attribute:legacyAttribute_grouperLoaderDbName');


From: Hyzer, Chris
Sent: Monday, October 21, 2019 11:30 AM
To: Richard Frovarp ; Mailing List
Subject: RE: Change loader db name?


You can add the new database, go to all loaders and change the name to the new one, delete the old, bounce.  should be fine.  right?  😊

-----Original Message-----
From: On Behalf Of Richard Frovarp
Sent: Thursday, October 17, 2019 2:17 PM
To: Mailing List
Subject: [grouper-users] Change loader db name?

Wondering what sort of chaos I will incur if I change the name of the
database that my loaders are using. I named the legacy database the
thing that I would now like the new one to use. If I go into the config,
I can change the name of the DB, but what will that do to the loaders I
already have defined? Do I just delete the loaders and start over? Small
change? Or do I just consider that name lost to time?



Archive powered by MHonArc 2.6.19.

Top of Page