[Dovecot] Authentication cache, failure to login after changed password

Tom Sommer mail at tomsommer.dk
Thu Aug 21 10:11:33 EEST 2008


Timo Sirainen wrote:
> On Tue, 2008-08-19 at 15:49 +0200, Tom Sommer wrote:
>> On Tue, August 19, 2008 15:44, Tom Sommer wrote:
>>
>>> Using version 1.1.1, MySQL userdb, with "nopassword=Y".
>>>
>>> Maybe it's due to nopassword?
>> Should add, this is my password_query:
>>
>> password_query = SELECT username as user, NULL as password, "Y" as
>> nopassword FROM users WHERE ...
> 
> So how do you check the password validity?

Simple

SELECT username as user, NULL as password, "Y" as nopassword FROM users 
WHERE username = '%u' AND password = '[password]'

The reason why I need to do this, is because my password is 
unpractically encrypted

// Tom


More information about the dovecot mailing list