[Dovecot] Make user name CaSe Insensitive
flashweb at gmail.com
Mon Aug 7 23:45:53 EEST 2006
> password_query = select user, password, ..
> ie. make it return the "user" field as in the database.
I have tried this.
password_query = SELECT username as user, password FROM mailbox WHERE
username = '%u' AND active=1
But it do not make the user name case insensitive. I can login with
CAPITAL and small letter user names and getting two different inboxes.
> Another way would be to change the SQL query to do case sensitive
> comparision instead of .. where user = '%u'. I don't remember how
> exactly this was done with MySQL, see its documentation.
This can be done with
password_query = SELECT password FROM mailbox WHERE username = BINARY
'%u' AND active=1
But this will stop login case senstive (do not allow the capital user,
in my case as mysql have lower case user, this is what i have done
This will almost solve my problem. But it will be great if i can allow
case insensitive login to mail box.
More information about the dovecot