Grouper Users - Open Discussion List

["Hyzer, Chris" <>]

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?

Thanks,

Richard