I just finished setting the same thing up today. Had some similar issues. I'll post my full how to later today, but until then I have some things to look for below.

Paul J Stevens wrote:
Chris Kolkman wrote:
Thanks for the reply Paul.

I’m pretty sure that the alias table is correct, but I’ve included it
below anyways.

I noticed another info@ email address in the accounts list, and thought
I’d try that to see if I got the same result – and I do.

I set the LMTP trace level to 5 and restarted postfix & lmtpd, and sent
another test message to the account in question.

It may be a postfix -> mysql (a recipient map connection file or
something) or maybe even cyrus – but I’m not sure.  Maybe someone will know.

Anyway here are the requested lines (table exported to xml, also notice
the lack of LMTP responses in the maillog (even at trace level 5, which
is why I think it might be postfix’s connection to the db):

So there's your problem. It's not dbmail. Postfix is not even relaying
the email to dbmail-lmtpd. Try setting up an explicit rule in transport.
As long as there's no logs from dbmail-lmtpd your postfix setup is
incorrect.



-- Add the following lines to postfix master.cf

[code]
dbmail-lmtp     unix    -       -       n       -       -       lmtp
  -o disable_dns_lookups=yes
[/code]

Don't forget the "disable_dns_lookup=yes". Make sure to add put it after the dbmail-lmtp line and indent a couple spaces. This was the sneaky one that made it work for me.



--- Add the following to postfix main.cf

[code]
local_recipient_maps = mysql:/etc/postfix/mysql/local_recipients.cf
virtual_mailbox_maps = mysql:/etc/postfix/mysql/virtual_mailboxes.cf
mailbox_transport = dbmail-lmtp:localhost:24
[/code]



--- Create your postfix mysql cf files

Create the /etc/postfix/mysql directory. Follow the instructions on postfix site for creating mysql cf files.
http://www.postfix.org/mysql_table.5.html




--- Make sure that dbmail-lmtp is started

My dbmail install from apt on debian does not have a startup script for lmtp that I can find... so until then I've been starting it by hand.

/usr/sbin/dbmail-lmtpd -c /path/to/dbmail.conf



I'll post my howto to later today. It will include a step-by-step for getting Dbmail+postfix+mysql running on Debian Sarge 3.1. Most of it will be helpful for other systems as well.


- Kevin Baker





Reply via email to