Using MySQL plugin and NTLM - obscure gotcha

[Nels Lindquist]

On 23 May 2003 at 18:48, Dave O wrote:

> On Fri, 23 May 2003, Nels Lindquist wrote:
> 
> > Problem:  MySQL SELECT statements are case insensitive.  Cyrus IMAP
> > namespace is not.  Clients logged into Windows with any case
> > variation of their username can authenticate with NTLM.  However,
> > since the authentication token is passed on to IMAP completely
> > unmodified, case variants of the username token other than all-
> > lowercase don't map to valid IMAP namespace, and 'LIST "" "INBOX"'
> > returns nothing useful.

> You could alter your MySQL query to look like this:
> 
> SELECT * FROM foo WHERE BINARY bar = 'value'
> 
> which makes the SELECT into a case-sensitive query.  HTH

Thanks!  That'll work, though it's kind of ugly from a UI 
perspective, since one needs to convince all the Windows users to use 
only a lowercase username when they log in.  Still, a login failure 
is an improvement over the original behaviour.

----
Nels Lindquist <*>
Information Systems Manager
Morningstar Air Express Inc.