[jira] [Created] (JAMES-2974) Failure when JAMES_MAIBOX.user_name and JAMES_USER.user_name do not match case

["Jerry Malcolm (Jira)" <se...@james.apache.org>]

Jerry Malcolm created JAMES-2974:
------------------------------------

             Summary: Failure when JAMES_MAIBOX.user_name and JAMES_USER.user_name do not match case 
                 Key: JAMES-2974
                 URL: https://issues.apache.org/jira/browse/JAMES-2974
             Project: James Server
          Issue Type: Bug
          Components: mailbox
    Affects Versions: 3.3.0
            Reporter: Jerry Malcolm


More issues with case-sensitivity.  I migrated from v3b5 on Windows to 3.4 on Linux.  I have mailboxes that are 15+ years old.  In the JAMES_MAILBOX table, the user_name in several random records have capital letters which don't match the case of the JAMES_USER user_name field.   There are two symptoms I'm encountering:

1) No mail has been placed in mailboxes with case mismatches since I migrated

2) mailboxes with case mismatches do not appear at all in the imap folder list responses.

I have no clue how/why some of the mailbox user_name fields are mixed case.  Some of these mailboxes go back to James 2.3.  But for whatever reason, they exist.  I can simply go into the database and force all of the names to lower case.  But unless lowercase is enforced, more mixed case names could appear, and we're back to the same problem. 

I recommend that all comparisons to the usersRepository names become case-insensitive searches.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org