Re: Dovecot 2.4.1: Domain part of user gets dropped in userdb_sql_query

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