Am 2025-09-01 14:04, schrieb Aki Tuomi via dovecot:
On 01/09/2025 14:53 EEST Robert Czechowski via dovecot <dovecot@dovecot.org> wrote:
Hi,
I stumbled upon a problem where documentation and logs no longer help me.
After upgrading to Debian Trixie / Dovecot 2.4.1-4 I have run into the following problem after fixing up most of my configuration.
I'm using a vmail setup with user information in a mysql database and mailboxes in maildir format. Apparently %{user | domain} will not get set in my SQL query when looking up users for lmtp transport:
With the setting
userdb_sql_query = SELECT 150 AS uid, 8 AS gid FROM users WHERE username = '%{user | username}' AND domain = '%{user | domain}'
I get the following debug log:
You have
protocol lmtp { auth_username_format = %{user | username} }
Aki
You are right, that was it! Thanks a lot!
Looks like this is a Debian specific setting that was added in conf.d/20-lmtp.conf. It's even documented in there. 🙈
Again, thanks!
Robert