You have to do one of two things, prevent Postfix from checking to see if the incoming mail is for a valid user, by commenting out
local_recipient_maps = <something> in your main.cf.. This will leave invalid user rejection up to dbmail. What I do however is point postfix to the dbmail mysql table by doing this: in main.cf: local_recipient_maps = mysql:/etc/postfix/mailbox.cf and then my /etc/postfix/mailbox.cf is: user = <dbuser> password = <dbpw> dbname = <dbname> table = aliases hosts = 127.0.0.1 #this may be different for you.. select_field = alias where_field = alias and it works like a charm.. I'm not using dbmail 2.0, and although I don't think there's any alias table changes that would make this fail, I may be wrong there.. Your postfix installation needs to have MySQL support compiled in, but I think this is standard in the newer versions. This has the advantage of having an immediate SMTP rejection if the user is invalid, as opposed to a bounced email which is how DBMail does it. HTH -Micah On Sat February 14 2004 12:10 am, HL Lau wrote: > Hi All, > > I'm experimenting with dbmail in consideration to replace my aging > sendmail installation. > > I've got Fedora Core 1, Postfix 2.0.11, MySql 3.23.58 and DBMail 2.0 RC2 > installed ok. I've also followed the INSTALL instructions from the > DBMail distribution. > > However, I still can't seem to get the whole thing to work. The mail is > arriving at the postfix ok but it does not seem to be handed over to > DBMail. Postfix keeps rejecting the mail with the following error log > in maillog. > > <snip> > postfix/smtpd[5862]: 90B918C4C0: reject: RCPT from > localhost.localdomain[127.0.0.1]: 450 <[EMAIL PROTECTED]>: User unknown > in local recipient table; from=<[EMAIL PROTECTED]> > to=<[EMAIL PROTECTED]> proto=SMTP helo=<bumsoft.com.sg> > <snip> > > The username, sa, was created in DBMail with dbmail-adduser in the > following manner: > > dbmail-adduser a sa sa 0 0 [EMAIL PROTECTED] @havenedge.net > > The local domain name is havenedge.net. > > I've tried to find out more from the mailing archives but I could not > access the server, it seems that it was down. Google search did not > yield any thing positive towards my installation. > > I am appealing to anyone on this list with experience in the same setup > as I have to provide me with some pointers. Many thanks in advance. > > Best regards, > > HL > > > PS: A snippet of the dbmail config is as follows: > > <snip> > host=localhost > sqlport= > sqlsocket=/var/lib/mysql/mysql.sock > user=dbmail > pass=dbmail > db=dbmail > TRACE_LEVEL=5 > > [SMTP] > SENDMAIL=/usr/sbin/sendmail > [EMAIL PROTECTED] > [EMAIL PROTECTED] > AUTO_NOTIFY=no > AUTO_REPLY=no > TRACE_LEVEL=5 > <snip> > > _______________________________________________ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail
