[Deploying Sakai] Cleanup users' subscriptions when they are not provided anymore

[Raad Al-Rawi]

Hi J-F

Logged as https://jira.sakaiproject.org/browse/SAK-21336

I've attached a couple of patch files and some additional instructions about controlling the behaviour.
Hope it helps!

Best

Raad

> -----Original Message-----
> From: Jean-Francois Leveque [mailto:jean-francois.leveque at upmc.fr]
> Sent: 21 October 2011 08:58
> To: ra273 at cam.ac.uk
> Cc: production at collab.sakaiproject.org; sakai-dev Developers
> Subject: Re: [Deploying Sakai] Cleanup users' subscriptions when they are
> not provided anymore
> 
> Hi Raad,
> 
> I think this is worth a JIRA with a patch attached. If you have one for 2.7, I'm
> sure this will help with more recent code.
> 
> Maybe this should be available for admins only by default and for site
> maintainers if a sakai.properties option is set.
> 
> What do others think?
> 
> Thanks
> 
> J-F
> 
> On 20/10/2011 18:01, Raad Al-Rawi wrote:
> > Hi J-F
> >
> > We run a similar setup, and had to modify parts of
> > sakai-site-manage-util and sakai-site-manage-tool so we could see user
> > entries that did not have a corresponding user object, and this allows
> > worksite maintainers to remove them.
> > I can provide some diffs (for 2.7) if you or anyone else is
> > interested. I don't think the changes are destructive, in the case
> > where other UDPs and/or internal Sakai users are being used, so maybe
> > it's worth a JIRA for "showing non-existent user entries in worksites"
> > or similar, and I'll post them there.
> >
> > If you're desparate and want to go via the db (at your own risk, no
> > guarantees or warranties provided, yadda yadda...) you can probably
> > remove users from worksites using:
> >
> > delete from sakai_site_user where user_id = 'someuserid'; delete from
> > sakai_realm_rl_gr where user_id = 'someuserid';
> >
> > Of course this is a last-ditch solution and I'd test this carefully on
> > a copy of production before taking the plunge!
> >
> > Cheers
> >
> > Raad
> >
> >
> >> -----Original Message-----
> >> From: production-bounces at collab.sakaiproject.org [mailto:production-
> >> bounces at collab.sakaiproject.org] On Behalf Of Jean-Francois Leveque
> >> Sent: 18 October 2011 16:21
> >> To: production at collab.sakaiproject.org; sakai-dev Developers
> >> Subject: [Deploying Sakai] Cleanup users' subscriptions when they are
> >> not provided anymore
> >>
> >> Hi all,
> >>
> >> My request is about live external/provided users. In my case, they
> >> come from LDAP.
> >>
> >> In the past, they were provided and added as participants to sites
> >> and
> > their
> >> own MyWorkspace if they logged in.
> >>
> >> Now they are not provided anymore but Sakai logs errors when loading
> >> the site they were subscribed to, such as :
> >> org.sakaiproject.site.util.SiteParticipantHelper -
> >> SiteParticipantHelper.prepareParticipants: user not defined xxxxxxxx
> >>
> >> I cannot unsubscribe them from the UI, because they're not provided
> >> anymore.
> >>
> >> Is there any other way to unsubscribe them than doing it directly in
> >> the database?
> >>
> >> If there's no other way, how should I do it in the database?
> >>
> >> Cheers,
> >>
> >> J-F