Re: dovecot sha512-crypt database storage

2018-03-11 Thread LuKreme
On Mar 11, 2018, at 10:19, David Mehler wrote: > Other suggestions welcome. Does the account you are using have access to write the new passwords?> Doe s the command work from the command line or phpmyadmin? -- My main job is trying to come up with new and innovative

Re: dovecot sha512-crypt database storage

2018-03-11 Thread David Mehler
Hello, Yes I am referencing my virtual users table. Other suggestions welcome. Thanks. Dave. On 3/11/18, @lbutlr wrote: > On 2018-03-10 (16:48 MST), David Mehler wrote: >> >> Thanks. That query doesn't return any parse errors but it does say >> that

Re: dovecot sha512-crypt database storage

2018-03-11 Thread @lbutlr
On 2018-03-10 (16:48 MST), David Mehler wrote: > > Thanks. That query doesn't return any parse errors but it does say > that it can't save the password. Are you referencing the right table in your database? -- It is the business of the future to be dangerous.

Re: dovecot sha512-crypt database storage

2018-03-10 Thread David Mehler
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 wrote: > Hello, > > Thanks. Trying that query adapted to my database table and getting an > error can not save

Re: dovecot sha512-crypt database storage

2018-03-10 Thread Thore Bödecker
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$',

dovecot sha512-crypt database storage

2018-03-10 Thread David Mehler
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