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.
--