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