Changing Password Schemes

[Gedalya]

On 05/02/2016 05:32 AM, Carl Jeptha wrote:
> May  2 05:26:03 |****** dovecot: auth-worker(3442): Error:
> sql(user at domain.tld,xxx.xxx.xxx.xxx): Password query must return a
> field named 'password'
I'm not sure, maybe it's checking case-sensitive. Your query returns PASSWORD. Make it lowercase.

>
> For testing purposes I put the query in PHPMyAdmin and it complains this
> (notice it drops "PASSWORD", but shows it in the query:
> #1064 - You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use near '\
>     IF(cryptpwd IS NULL OR cryptpwd='', CONCAT('{PLAIN}',clearpwd),
> cryptpwd) as ' at line 1
>
>
It also sarts with a \ ... did you leave that in? That is specific to the dovecot config file. In PHPMyAdmin you should remove the line-continuation backslashes.

Actually if you use the mysql command-line client, you would be able to paste that in with the backlashes.

Make sure to put in a real value in WHERE username = '%u' <<<