Uploaded image for project: 'James Server'
  1. James Server
  2. JAMES-2974

Failure when JAMES_MAIBOX.user_name and JAMES_USER.user_name do not match case

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 3.3.0
    • Fix Version/s: None
    • Component/s: mailbox
    • Labels:
      None

      Description

      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.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              jwmalcolm Jerry Malcolm
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: