Hey,

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"

Cheers, Thore

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.

--