[Dovecot] Authentication using native MySQL PASSWORD() function

Timo Sirainen tss at iki.fi
Thu Oct 27 18:16:35 EEST 2005


On Thu, 2005-10-27 at 17:02 +0200, Jakob Hirsch wrote:
> Maybe it would be even better/cleaner to be able to use something like
> 
> SELECT userid AS user, 1 AS password_ok FROM users WHERE userid = '%u' AND
> password = PASSWORD('%p')

Actually I think this already works:

SELECT userid AS user, NULL as password WHERE userid = '%u' AND password = PASSWORD('%p')

NULL passwords accept any password. This was needed for proxying but
works nicely elsewhere too.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://dovecot.org/pipermail/dovecot/attachments/20051027/2a61bb86/attachment.pgp


More information about the dovecot mailing list