[Dovecot] Using LDA with postfix and virtual users

[Chris Cohen]

Hi list,

I have 7 virtual users in a sql database. I don't want any systemusers 
or local delivery using postfix.
On the postfix side everything works fine as long as I use the 'local' 
delivery agent. But since I want to use dovecot's sieve functionality I 
set local_transport to dovecot. From now on Postfix seems to ignore 
local_* settings like local_recipient_maps.

Here is my current configuration:
log_timestamp: %Y-%m-%d %H:%M:%S
protocols: imaps managesieve
login_dir: /var/run/dovecot/login
login_executable(default): /usr/lib/dovecot/imap-login
login_executable(imap): /usr/lib/dovecot/imap-login
login_executable(managesieve): /usr/lib/dovecot/managesieve-login
mail_privileged_group: mail
mail_location: maildir:/var/mail/%u
mail_executable(default): /usr/lib/dovecot/imap
mail_executable(imap): /usr/lib/dovecot/imap
mail_executable(managesieve): /usr/lib/dovecot/managesieve
mail_plugin_dir(default): /usr/lib/dovecot/modules/imap
mail_plugin_dir(imap): /usr/lib/dovecot/modules/imap
mail_plugin_dir(managesieve): /usr/lib/dovecot/modules/managesieve
sieve_storage(default):
sieve_storage(imap):
sieve_storage(managesieve): /var/mail/%u/dovecot/sieve/
sieve(default):
sieve(imap):
sieve(managesieve): /var/mail/%u/.dovecot.sieve
auth default:
  mechanisms: plain login
  verbose: yes
  debug: yes
  debug_passwords: yes
  passdb:
    driver: sql
    args: /etc/dovecot/dovecot-sql.conf
  userdb:
    driver: static
    args: uid=5000 gid=5000 home=/var/mail/%u
  socket:
    type: listen
    master:
      path: /var/run/dovecot/auth-master
      mode: 384
      user: vmail
      group: vmail
plugin:
  sieve: /var/mail/%u/.dovecot.sieve

And my postfix configuration:
alias_maps = mysql:/etc/postfix/alias_maps-mysql.cf
command_directory = /usr/sbin
config_directory = /etc/postfix
daemon_directory = /usr/lib/postfix
data_directory = /var/lib/postfix
inet_interfaces = all
local_recipient_maps = mysql:/etc/postfix/local_recipients-mysql.cf 
$alias_maps
local_transport = dovecot
mydestination = $myhostname, localhost.$mydomain, localhost, $mydomain
mydomain = unixhosts.org
myhostname = amy.unixhosts.org
mynetworks = 127.0.0.0/8
myorigin = $myhostname
smtpd_banner = $myhostname ESMTP $mail_name (Debian/GNU)
unknown_local_recipient_reject_code = 550

And accourding to the wiki I have:
dovecot   unix  -       n       n       -       -       pipe
  flags=DRhu user=vmail:vmail argv=/usr/lib/dovecot/deliver -f 
${sender} -d ${user}

As soon as I set local_transport to dovecot postfix seems to lookup 
local_recipients using dovecot. And dovecot doesn't know anything about 
my alias table. Heres a small log:

Mar 28 14:49:25 amy postfix/smtpd[4412]: warning: 10.1.32.13: address 
not listed for hostname amy.unixhosts.org
Mar 28 14:49:25 amy postfix/smtpd[4412]: connect from 
unknown[10.1.32.13]
Mar 28 14:49:25 amy postfix/smtpd[4412]: 820D478399: 
client=unknown[10.1.32.13]
Mar 28 14:49:25 amy postfix/cleanup[4415]: 820D478399: 
message-id=<20080328134925.5E3954C444 at zoidberg.unixhosts.org>
Mar 28 14:49:25 amy postfix/qmgr[4410]: 820D478399: 
from=<virtualuser at daisy.unixhosts.org>, size=762, nrcpt=1 (queue 
active)
Mar 28 14:49:25 amy postfix/smtpd[4412]: disconnect from 
unknown[10.1.32.13]
Mar 28 14:49:25 amy dovecot: auth(default): master in: 
USER^I1^Iroot^Iservice=deliver
Mar 28 14:49:25 amy dovecot: auth-worker(default): sql(root): query: 
SELECT password FROM users WHERE username = 'root';
Mar 28 14:49:25 amy dovecot: auth-worker(default): sql(root): unknown 
user
Mar 28 14:49:25 amy dovecot: auth(default): master out: NOTFOUND^I1
Mar 28 14:49:25 amy postfix/pipe[4416]: 820D478399: 
to=<root at daisy.unixhosts.org>, relay=dovecot, delay=0.09, 
delays=0.03/0.02/0/0.04, dsn=5.1.1, status=bounced (user unknown)
Mar 28 14:49:25 amy postfix/cleanup[4415]: 914C978407: 
message-id=<20080328134925.914C978407 at amy.unixhosts.org>
Mar 28 14:49:25 amy postfix/qmgr[4410]: 914C978407: from=<>, size=2516, 
nrcpt=1 (queue active)
Mar 28 14:49:25 amy postfix/bounce[4418]: 820D478399: sender 
non-delivery notification: 914C978407
Mar 28 14:49:25 amy postfix/qmgr[4410]: 820D478399: removed
Mar 28 14:49:25 amy dovecot: auth(default): master in: 
USER^I1^Ivirtualuser^Iservice=deliver
Mar 28 14:49:25 amy dovecot: auth-worker(default): sql(virtualuser): 
query: SELECT password FROM users WHERE username = 'virtualuser';
Mar 28 14:49:25 amy dovecot: auth(default): password(virtualuser): 
Credentials: {CRYPT}{PLAIN-MD5}ebb12eb47da2af187241a0d74fc3d14f
Mar 28 14:49:25 amy dovecot: auth(default): master out: 
USER^I1^Ivirtualuser^Iuid=5000^Igid=5000^Ihome=/var/mail/virtualuser
Mar 28 14:49:25 amy postfix/pipe[4416]: 914C978407: 
to=<virtualuser at daisy.unixhosts.org>, relay=dovecot, delay=0.03, 
delays=0.01/0/0/0.02, dsn=2.0.0, status=sent (delivered via dovecot 
service)
Mar 28 14:49:25 amy postfix/qmgr[4410]: 914C978407: removed

I have already read a lot of documentation, howtos and so on, but just 
can't figure out how to get this to work.

Could someone please give me a hint?

-- 
Greetings
Chris