dovecot sha512-crypt database storage

Thore Bödecker me at
Sat Mar 10 23:14:27 EET 2018


using the roundcube password plugin allows you to specify arbitrary
statements for password_query.

I'm using SHA512-CRYPT too and this is my $config['password_query']:

"UPDATE vhostapi_prod.mail_accounts SET password=CONCAT(_utf8'{SHA512-CRYPT}',ENCRYPT(_utf8%p,CONCAT(_utf8'$6$', SUBSTRING(SHA(RAND()), -16)))) WHERE email=%u LIMIT 1"


On 10.03.18 - 16:00, David Mehler wrote:
> Hello,
> I've got dovecot authenticating to a MySQL database. I've got a field
> varchar(128) called password. Whenever I create a password I use
> doveadm pw as in:
> doveadm pw -s sha512-crypt
> now i'd like to get MySQL to make a dovecot-specific password. My goal
> is to eventually have roundcube's password plugin working with this
> MySQL database to change the password.
> Thanks.
> Dave.


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: not available
URL: <>

More information about the dovecot mailing list