Displaying 1 result from an estimated 1 matches for "password_digest_md5".
2020 Sep 01
3
Deleted mail reappearing
...ovecot/auth-master
mail_plugins = quota sieve
postmaster_address = postmaster at localhost
sendmail_path = /usr/lib/sendmail
}
dovecot-sql.conf:
driver = mysql
connect = host=127.0.0.1 dbname=mail user=mail password=####
password_query = SELECT IF('%m' = 'DIGEST-MD5', users.password_digest_md5, NULL) as password, IF('%m' = 'DIGEST-MD5', NULL, 'Y') as nopassword, username FROM users LEFT JOIN domains ON users.domain = domains.domain WHERE users.username = '%u' AND users.domain = '%d' AND users.active = 'yes' AND domains.state = '1' A...