Using MySQL plugin and NTLM - obscure gotcha
nlindq at maei.ca
Mon May 26 14:52:54 EDT 2003
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.
More information about the Info-cyrus