[Building Sakai] removing a user from a realm

[Zhen Qian]

Will:

It seems like the LDAP exception blocks the process of adding users.

You could do the following:

1. Make sure there is such a user with id 173c909d-1daf-4094-bac5- 
adf3d2d1ae9b:

	select * from sakai_user where user_id ='173c909d-1daf-4094-bac5- 
adf3d2d1ae9b';

2. If so, make sure there is an entry inside sakai_user_id_map:

	select * from sakai_user_id_map where user_id='173c909d-1daf-4094- 
bac5-adf3d2d1ae9b';

3. Then to remove a user from a realm, use the following:

	delete from sakai_realm_rl_gr where user_id = '173c909d-1daf-4094- 
bac5-adf3d2d1ae9b';

     If necessary:
	delete from sakai_user_id_map where user_id='173c909d-1daf-4094-bac5- 
adf3d2d1ae9b';
	delete from sakai_user where user_id = '173c909d-1daf-4094-bac5- 
adf3d2d1ae9b';

But it is interesting to find out how "user template2010" was getting  
into play in the first place. Would you please attach some  
screenshots and create a JIRA?

Thanks,

- Zhen
On May 26, 2009, at 3:46 PM, will at serensoft.com wrote:

> Quick: how do you remove one user from a realm (when the site-info
> tool isn't cooperating)?
>
>
> Long version:
>
> Okay, in Site Info > add participants, we pasted in a bunch of student
> user-names, which come via LDAP, and...
>
> One of them winds up with a screwy LDAP lookup:
>
> 2009-05-26 15:22:36,792  WARN http-80-Processor13
> org.sakaiproject.site.tool.SiteAction -
> org.sakaiproject.site.tool.SiteAction at 8f2a81d buildContextForTemplate
> chef_site-siteInfo-list.vm
> java.lang.RuntimeException: getUsers(): LDAPException during search
> [eid = user template2010][result code = Sizelimit Exceeded][error
> message = null]
>
> The userid we asked for was 'jblow' but now it's looking for 'user
> template2010' instead. Now, the 'site info' display has an empty list
> of worksite participants (and the logfile gets plenty of LDAPException
> messages). There are no user names shown, and no checkboxes to click
> -- so we can't remove the student there.
>
> Looking at the realm itself (!admin > realms), lots of students are
> listed properly except for one:
> ...
> aeinstein
> mcurie
> 173c909d-1daf-4094-bac5-adf3d2d1ae9b
> inewton
> bpascal
>
> How do we remove that one miscreant from the realm? When we click that
> user-name link, we get "Alert: internal error: user not found."
>
> Is there some SQL that will unravel this?
>
> --
> will trillich
> "Our only real economic security lies in our power to meet human
> needs." -- S.Covey, the 8th Habit
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev- 
> unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
>
>