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 p...@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/u...@domain.tld/Maildir
or
/home/mainuser/domains/domain2.tld/homes/u...@domain2.tld/Maildir

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

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

there in virtual file there is  map like:

u...@domain.tld user-dom...@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....@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??

Reply via email to