Hi There, I am trying to get postfix to send its mail to dbmail. I have
followed all the instructions that i can find, but its still not
working... Can someone shed some light on this? I am running DBMail
experimental on debian sarge.. Config files as follows:
master.cf:
dbmail unix - n n - - pipe
flags= user=dbmail:dbmail argv=/usr/sbin/dbmail-smtp -d ${recipient}
main.cf:
myhostname = host.domainname.com
alias_maps = hash:/etc/aliases
alias_database = hash:/etc/aliases
myorigin = /etc/mailname
relayhost = outgoing.domainname.com
mynetworks = 127.0.0.0/8,192.168.1.0/24
mailbox_command =
mailbox_size_limit = 0
recipient_delimiter = +
mydestination = mysql:/etc/postfix/mysql-transport.cf
local_recipient_maps = mysql:/etc/postfix/mysql-localusers.cf
the mysql-transport looks up this table:
mysql> select * from transport;
+----+----------------------+-----------+-------------+
| id | domain | transport | comment |
+----+----------------------+-----------+-------------+
| 4 | localhost | dbmail: | Test Domain |
| 5 | host.domainname.com | dbmail: | Test Domain |
| 6 | domain.com | dbmail: | Test Domain |
+----+----------------------+-----------+-------------+
3 rows in set (0.01 sec)
the mysql-localusers.cf looks up this table:
mysql> select user_idnr, userid from dbmail_users;
+-----------+--------------------------------+
| user_idnr | userid |
+-----------+--------------------------------+
| 1 | [EMAIL PROTECTED]@__ |
| 2 | anyone |
| 5 | test |
+-----------+--------------------------------+
3 rows in set (0.00 sec)
SO. In THEORY... when sending to [EMAIL PROTECTED], postfix should look up
'transport' and find the domain name, then lookup 'dbmail_users' and
find the userid, then deliver the mail to DBmail correct?
I have validated that mysql-transport.cf works, as i can add/remove the
record and postfix either accepts or rejects the mail... i THINK the
mysql-localusers.cf works as postfix treats [EMAIL PROTECTED] and
[EMAIL PROTECTED] differently (flat our rejects [EMAIL PROTECTED], but
accepts [EMAIL PROTECTED] then says 'unknown user').
But postfix will no deliver the mail to DBmail.. What am i missing here?
Regards,
Simon