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

[Jean-Francois Leveque]

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