Hi,

Thanks. That query doesn't return any parse errors but it does say that it can't save the password.

Any ideas?

Thanks. Dave.

On 3/10/18, David Mehler <dave.mehler@gmail.com> wrote:

Hello,

Thanks. Trying that query adapted to my database table and getting an error can not save password, any ideas?

When you made your initial database tables how did you set up the password field and in MySQL how did you make it?

I'm trying to figure out what is different about your setup than mine.

Thanks. Dave.

On 3/10/18, Thore Bödecker <me@foxxx0.de> wrote:

...

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.

--