On 3/13/06 4:29 PM, "M. J. [Mike] OBrien" <[EMAIL PROTECTED]> wrote:
> Check against the following that your local recipients are mapped correctly: > > > From previous post: > ...// > > Create a file in your Postfix config directory (/etc/postfix), with > the name sql-recipients.cf, and put the following in it: > > user = <username> > password = <password> > hosts = <dbhost> > dbname = <dbname> > table = dbmail_aliases > select_field = alias > where_field = alias > > Where you replace <username>, <password>, <dbhost> and <dbname> by the > database username, password, host and name of the dbmail database. > > Now we need to tell Postfix to use this file. Add the following line > in main.cf: > > local_recipient_maps = mysql:/etc/postfix/sql-recipients.cf > > This tells Postfix to use the database to check if a recipient is > present in the database. Postfix will refuse the message if a > recipient is not present. > > //... That's not the issue. dbmail is rejecting on delivery. > -=-=-=-=- > Mike > > ----- Original Message ----- > From: "Mark Nernberg" <[EMAIL PROTECTED]> > To: "DBMail mailinglist" <[email protected]> > Sent: Monday, March 13, 2006 4:06 PM > Subject: Re: [Dbmail] can't find user > > >> On 3/13/06 2:53 PM, "Jim Douglas" <[EMAIL PROTECTED]> wrote: >> >>> It obvious from the log file the user can't be found, he definately is in >>> the database, dbmail. >>> >>> I think it's safe to assume dbmail checked the users table and didn't >>> find >>> this email address. >>> >>> How come? >>> >>> main.cf >>> mailbox_transport = dbmail-lmtp:localhost:24 >>> local_recipient_maps = mysql:/etc/postfix/sql-recipients.cf >>> >>> /etc/postfix/sql-recipients.cf >>> user = dbmail >>> password = mypassword >>> hosts = localhost >>> dbname = dbmail >>> table = dbmail_aliases >>> select_field = alias >>> where_field = alias >>> >>> >>> Mar 13 14:42:39 cpe-63-25-161-18 dbmail/lmtpd[26213]: pidfile.c, >>> pidfile_create: File [/var/run/dbmail-lmtpd.pid] exists and process id >>> [26213] is running. >>> Mar 13 14:42:44 cpe-63-25-161-18 postfix/postfix-script: starting the >>> Postfix mail system >>> Mar 13 14:42:44 cpe-63-25-161-18 postfix/master[26259]: daemon started -- >>> version 2.2.2, configuration /etc/postfix >>> Mar 13 14:43:03 cpe-63-25-161-18 postfix/smtpd[26266]: connect from >>> web42206.mail.yahoo.com[66.18.23.27] >>> Mar 13 14:43:03 cpe-63-25-161-18 postfix/smtpd[26266]: NOQUEUE: reject: >>> RCPT >>> from web42206.mail.yahoo.com[66.18.23.27]: 550 <[EMAIL PROTECTED]>: >>> Recipient address rejected: User unknown in local recipient table; >>> from=<[EMAIL PROTECTED]> to=<[EMAIL PROTECTED]> proto=SMTP >>> helo=<web42206.mail.yahoo.com> >>> Mar 13 14:43:03 cpe-63-25-161-18 postfix/smtpd[26266]: disconnect from >>> web42206.mail.yahoo.com[66.18.23.27] >> >> I, too, have been having this problem. My database logs reflect that >> dbmail >> is returning the error. >> >> It especially seems to occur with multi-recipient messages. >> >> >> -- >> Mark J. Nernberg >> Director of Technology >> 1-Fast Computer Service >> (412)478-6262 >> >> http://www.1fast.us/ >> >> Customer Support: [EMAIL PROTECTED] >> >> Providing secure technology solutions since 2003. >> >> >> _______________________________________________ >> Dbmail mailing list >> [email protected] >> https://mailman.fastxs.nl/mailman/listinfo/dbmail >> > > -- Mark J. Nernberg Director of Technology 1-Fast Computer Service (412)478-6262 Company Website: http://www.1fast.us/ For technical support or customer service, please email [EMAIL PROTECTED] 1-Fast Computer Service: secure solutions since 2003
