On Mon, 2006-03-13 at 19:53 +0000, Jim Douglas 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.
Actually that is a postfix error, dbmail itsself isn't involved anywhere yet. > 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] So you're actually delivering mail to a "dbmail" address? Run "dbmail-users -l [EMAIL PROTECTED]". That will check the users table at least, I don't know if it'll check the aliases table, which is what postfix is looking in, so also try a "select * from dbmail_aliases where alias = '[EMAIL PROTECTED]'" and see if you get anything back. I believe dbmail actually looks in both tables nowadays (though I don't know in what order), so it may simply be you have a "users" table entry but not an "aliases" entry. If so, you may be able to change your postfix query to look in both places, or just add an alias for all your users entries (or even make a database view that combines them and have postfix query that, if you like). Jesse -- Jesse Norell - [EMAIL PROTECTED] Kentec Communications, Inc.
