|Main Archive Page > Month Archives > postfix-users archives|
On 2010-04-21 5:53 PM, mouss wrote:
> Charles Marcus a √©crit :
>> I know this isn't exactly a postfix question, but I'm hoping someone
>> will have pity on me and answer anyway...
>> I have a server using postfix+courier-imap+cyrus-sasl. Currently the
>> query in virtual_mailbox_maps is:
>> query = SELECT maildir FROM mailbox WHERE username='%s'
>> If I want to force the supplied username to lowercase, would I change it to:
>> query = SELECT maildir FROM mailbox WHERE username=LOWER('%s')
> yes. but, in mysql at least, the default is case insensitive. so you
> don't need that.
Ok, well, I'm using postfixadmin, and it must not have set up the
username field as case-insensitive, because mixed case username auth
attempts fail. I'll go check with the postfixadmin list and see if there
is an even simpler way to do this (lowercase usernames, and append a
default domain if one isn't supplied)...
Anyway, the server in question is using
courier-imap+courier-authlib/cyrus-sasl, so I was able to fix this in
authmysqlrc for now (I'll be converting them to dovecot soon)...
-- Best regards, Charles