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@zoidberg.unixhosts.org Mar 28 14:49:25 amy postfix/qmgr[4410]: 820D478399: from=virtualuser@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@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@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@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