[Dovecot] dovecot + mysql

MAGALLON Lionel Lionel.MAGALLON at rbs.fr
Wed Jan 12 20:00:29 EET 2005


Hi,

I've got a problem of authenticating users when they've 
got the % character in their login name. It always returns 
	-ERR Authentication failed.
 
I've done some tests (explained below).

1. the mysql answer to 
	SELECT password FROM users WHERE uid = 'foo%domain.com' 
   is 123
2. the mysql answer to 
	SELECT password FROM users WHERE uid = 'foo at domain.com'
   is 123
3. with a password_query like this :
	password_query = SELECT password FROM users WHERE uid = '%u'
   it works fine with foo at domain.com but not with foo%domain.com
4. everybody can login with password 123 with a password_query like this
:
	password_query = SELECT password FROM users WHERE uid =
'foo%domain.com'

=> I don't know what's done with the % character when passed to the %u
variable.
Can somebody enlight me ?

Thanks a lot. 



More information about the dovecot mailing list