Thanks for your advice. I will try it out and let you know the results. HL
On Mon, 2004-02-16 at 06:22, Micah wrote: > 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 > _______________________________________________ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail
