[Building Sakai] user_id Case sensitivity causing InUseException in Preferences

[Niebel, William D. (Bill) (wdn5e)]

Hi, Kimberly.
We had a similar problem few years ago at the University of Virginia.  We use PubCookie for SSO login to our Sakai.  (We have an Apache server running mod_pubcookie in front of each Tomcat.)  The Sakai ldap provider supplements the user data but is never used for authentication of users.  (We also have misc. and guest accounts local to the Sakai database.)
Our problem at the time stemmed from PubCookie login server being case-insensitive for non-certificate (pubcookie html form) logins.  In some cases, the exact id as entered in whatever mixed-case user choice was the one Sakai took to be the user's id.  This caused problems on ldap lookup.
A few upgrades ago, we modified our ldap provider Sakai code and configuration to lowercase the id provided by user on login before it is then used for ldap lookup.  (Our enterprise user ids are all lowercase.)  This fixed our problems at the time.  I word it this way, as I think the underlying cause has somehow separately been fixed.  Anyway our modified code fixed the problem at the time and has been working for a few years and still is.
If you think it would help, let me know and I'll send along patches to ldap provider to do this.
Good luck with this.
Bill


________________________________
From: sakai-dev-bounces at collab.sakaiproject.org [sakai-dev-bounces at collab.sakaiproject.org] on behalf of Wilson, Kimberly [wilsonk at mail.amc.edu]
Sent: Friday, August 15, 2014 12:01 PM
To: sakai-dev at collab.sakaiproject.org
Subject: [Building Sakai] user_id Case sensitivity causing InUseException in Preferences

When some of our users are logging in with caps in their user_ids and then attempting to reorganize sites in Preferences they get a InUseException,
For example:
A red exclamation mark followed by:
org.sakaiproject.exception.InUseException id=IRVINED

This message is repeated 3 times, with a box surrounding all three errors

This occurs when any part of the user_id is capatilized as well

[cid:image003.jpg at 01CFB880.A700DCD0]

My manager entered this jira 2 years ago, but no one has responded
Specific User throwing exception in Preferences
https://jira.sakaiproject.org/browse/SAK-22244

I found this jira:
Case sensitivity of usernames
https://jira.sakaiproject.org/browse/SAK-1324

but I can’t see where to go in our current version 2.9.3 to see what to do to stop this from occurring

Thanks!

Kim Wilson, MSCIS | Systems Analyst – Sakai & IS Academic Systems | Albany Medical Center | 518-264-1055


________________________________
----------------------------------------- CONFIDENTIALITY NOTICE: This email and any attachments may contain confidential information that is protected by law and is for the sole use of the individuals or entities to which it is addressed. If you are not the intended recipient, please notify the sender by replying to this email and destroying all copies of the communication and attachments. Further use, disclosure, copying, distribution of, or reliance upon the contents of this email and attachments is strictly prohibited. To contact Albany Medical Center, or for a copy of our privacy practices, please visit us on the Internet at www.amc.edu.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140815/2f8c3d35/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.jpg
Type: image/jpeg
Size: 11375 bytes
Desc: image003.jpg
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140815/2f8c3d35/attachment.jpg