On 2026-01-20 23:44, Gordon Dickens via dovecot wrote:
My cut/paste of the dovecot.conf file in my previous post was somehow corrupted. Here is the actual file instead:

# *** REQUIRED *** Dovecot config and storage versions
dovecot_config_version = 2.4.2
dovecot_storage_version = 2.4.2

passdb sql {
query = SELECT crypt as password FROM users WHERE username = '%{user}' AND (type = 'local' OR type = 'piped');
}
userdb sql {
query = SELECT pop as home, uid, gid FROM users WHERE username = '%{user}';
}
The queries look ok, quite similar to mine. I use ${user | lower} filter to lowercase the usernames.

What's the error in the log?

To get even more verbose logs, have you set
auth_verbose = yes
log_debug=category=auth


sql_driver = mysql
mysql /var/run/mysqld/mysqld.sock {
  user = exim4u
  password = $Cr@bby-P3lican$
  dbname = exim4u
}
You just posted your password to the internet, best to change it.

--
 Christian Kivalo
_______________________________________________
dovecot mailing list -- [email protected]
To unsubscribe send an email to [email protected]

Reply via email to