dovecot - Jun 2019 - Updating passwords

I created some new users in my MySQL database using postfoxadmin. The passwords
looked correct in the database and show the right prefix {SHA256-CRYPT} but
logins were failing, so I manually created new passwords from the command line:

doveadm pw -s SHA256-CRYPT  -p ?a password" -u kremels at kreme.com
{SHA256-CRYPT}$5$ZKsovTv0Ddc9k4?

I then went into the postfix database and manually updated the password field in
the database.

update  mailbox  set password = '$5$ZKsovTv0Ddc9k4?' where username like
'kremels at kreme.com';

SOME of the accounts can now login, but not all.

I get a debug line like:

dovecot: auth-worker(26599): Debug: sql(kremels at
kreme.com,xx.xx.xx.xx,<rnadomlookingstuff>): SHA256-CRYPT(a password) !=
'$5$ZKsovTv0Ddc9k4?






-- 
'They've given us the answers,' he [Carrot] said. 'Perhaps we
can find
out what the questions should have been.' --Feet of Clay

> On 12 Jun2019, at 13:47, @lbutlr <kremels at kreme.com> wrote:
> 
> doveadm pw -s SHA256-CRYPT  -p ?a password" -u kremels at kreme.com
Well, I did make SOME progress. One fo the passwords that I simply could not get
to work at all had a $ in it, and evidently;y the shell expansion kicked in with
the double quotes.

I will check the other passwords that did not work for special characters and
see it using ? ? will work. Ugh.


-- 
A cubicle is simply a cell without a door.