Question are you using a db like postgresql or mysql etc

when running virtual mailboxes it is just simply a better solution

my setup is as follows

i use a django project to drive it

here are the basic's

in the dovecot.conf :

passdb { args = /usr/local/etc/dovecot/dovecot-pgsql.conf driver = sql }

mail_plugins = " virtual notify replication fts fts_lucene "

service lmtp { process_limit=1000 vsz_limit = 512m client_limit=1 unix_listener /usr/home/postfix.local/private/dovecot-lmtp { group = postfix mode = 0600 user = postfix } }

mail_location = maildir:~/

&

# cat dovecot-pgsql.conf driver = pgsql connect = host=localhost port=5433 dbname=scom_billing user=pgsql password=xxxxxxx default_pass_scheme = PLAIN

password_query = SELECT username as user, password FROM email_users WHERE username = '%u' and password <> 'alias' and status = True and destination = '%u'

user_query = SELECT home, uid, gid FROM email_users WHERE username = '%u' and password <> 'alias' and status = True and destination = '%u'

#iterate_query = SELECT user, password FROM email_users WHERE username = '%u' and password <> 'alias' and status = True and destination = '%u'

iterate_query = SELECT "username" as user, domain FROM email_users WHERE status = True and alias_flag = False

Happy Friday !!! Thanks - paul

Paul Kudla

Scom.ca Internet Services <http://www.scom.ca> 004-1009 Byron Street South Whitby, Ontario - Canada L1N 4S3

Toronto 416.642.7266 Main 1.866.411.7266 Fax 1.888.892.7266 Email paul@scom.ca

On 10/21/2022 3:18 AM, George Asenov wrote:

Hello,

I use postfix with dovecot as an lmtp LDA with unix users and multiple domain names and mailboxes in Maildir format placed in domain directory like:

/home/mainuser/homes/user@domain.tld/Maildir or /home/mainuser/domains/domain2.tld/homes/user@domain2.tld/Maildir

which have the main user as a group and user@domain.tld/user@domain2.tld as owner

Postfix have virtual_alias_maps = hash:/etc/postfix/virtual

there in virtual file there is  map like:

user@domain.tld user-domain@domain.tld

and in /etc/passwd

there are actually 2 users with the same home dir and same UID/GID (only the username is different)

and in postfix mailbox_transport = lmtp:unix:private/dovecot-lmtp

The issue is that when postfix passes the email for local delivery to dovecot lmtp it sends the username as user-domain.tld@serverhostname.tld but dovecot is configured with !include auth-system.conf.ext

can't resolve this username thus fails to deliver.

I've found a workaround in the net to use custom userdb just for lmtp like this:

protocol lmtp { mail_plugins = $mail_plugins sieve userdb {

        driver = passwd-file args = username_format=%n /etc/passwd } }

which works but produce some warnings because there is the root user (ID 0) and actually is a dirty workaround

Is there more elegant solution??