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.
--
signature.asc
Description: PGP signature
