[Dovecot] Authentication using native MySQL PASSWORD() function

Tom Sommer ts at dreamcoder.dk
Fri Oct 28 01:36:01 EEST 2005


Timo Sirainen wrote:
> On Thu, 2005-10-27 at 17:52 +0200, Tom Sommer wrote:
> 
>>This doesn't seem to work, it executes:
>>
>>SELECT username as user, NULL as password FROM users WHERE username = 
>>'test at example.com' AND password = PASSWORD('0')
>>
>>... where password_query is: ...
>>
>>SELECT username as user, NULL as password FROM users WHERE username = 
>>'%u' AND password = PASSWORD('%p')
> 
> 
> I forgot the %p part. Added %w to CVS code now which is the password.

Awesome, Thank You - Will grab a snapshot

--
Tom Sommer




More information about the dovecot mailing list