On 3/13/06 4:50 PM, "M. J. [Mike] OBrien" <[EMAIL PROTECTED]> wrote:
> Ok. > Then try this postmap test to simulate postfix doing a lookup and see if the > alias exists in your dbmail_aliases table and if your sql-recipients.cf > correctly enables postix to make that query: > >> From the command line: > > postmap -q <[EMAIL PROTECTED]> mysql:/etc/postfix/sql-recipients.cf > > If that doesn't produce a response of : > <[EMAIL PROTECTED]> > > check that the alias exists in the dbmail_aliases table; username and > password are correct sql-recipients.cf as well as all other aspects of > /sql-recipients.cf > > best... > Mike > > This is a log entry from one such problem last week: Please note that if I send a message to only "[EMAIL PROTECTED]", it will be delivered! Log entry: Feb 28 15:36:18 fw postfix/smtpd[15481]: connect from echo.1fast.us [72.244.45.37] Feb 28 15:36:19 fw postfix/policy-spf[15485]: : testing: stripped [EMAIL PROTECTED], stripped [EMAIL PROTECTED] Feb 28 15:36:19 fw postfix/policy-spf[15485]: : SPF pass: smtp_comment=Please see http://spf.pobox.com/why.html?sender=mark% 40downtownhelpdesk.com&ip=72.244.45.37&receiver=fw.cindrich.com: 72.244.45.32/29 contains 72.244.45.37, header_comment=fw.cindrich.com: domain of [EMAIL PROTECTED] designates 72.244.45.37 as permitted sender Feb 28 15:36:19 fw postfix/policy-spf[15485]: decided action=DUNNO Feb 28 15:36:19 fw postfix/smtpd[15481]: NOQUEUE: client=echo.1fast.us [72.244.45.37] Feb 28 15:36:19 fw policyd: rcpt=2172, whitelist=pass, host=72.244.45.37 (echo.1fast.us), [EMAIL PROTECTED], [EMAIL PROTECTED], size=758 Feb 28 15:36:19 fw postfix/policy-spf[15485]: : testing: stripped [EMAIL PROTECTED], stripped [EMAIL PROTECTED] Feb 28 15:36:19 fw postfix/policy-spf[15485]: : SPF pass: smtp_comment=Please see http://spf.pobox.com/why.html?sender=mark% 40downtownhelpdesk.com&ip=72.244.45.37&receiver=fw.cindrich.com: 72.244.45.32/29 contains 72.244.45.37, header_comment=fw.cindrich.com: domain of [EMAIL PROTECTED] designates 72.244.45.37 as permitted sender Feb 28 15:36:19 fw postfix/policy-spf[15485]: decided action=DUNNO Feb 28 15:36:19 fw amavis[15287]: (15287-03) ESMTP::10023 /var/amavis/ tmp/amavis-20060228T150339-15287: <[EMAIL PROTECTED]> -> <[EMAIL PROTECTED]>,<[EMAIL PROTECTED]> Received: SIZE=758 from postoffice.cindrich.com ([127.0.0.1]) by localhost (postoffice.cindrich.com [127.0.0.1]) (amavisd-new, port 10023) with ESMTP id 15287-03; Tue, 28 Feb 2006 15:36:19 -0500 (EST) Feb 28 15:36:19 fw amavis[15287]: (15287-03) Actual message size 928 B greater than the declared 758 B Feb 28 15:36:19 fw amavis[15287]: (15287-03) Checking: TUFDFkt16QOg [72.244.45.37] <[EMAIL PROTECTED]> -> <[EMAIL PROTECTED]>,<[EMAIL PROTECTED]> Feb 28 15:36:19 fw amavis[15287]: (15287-03) p001 1 Content-Type: text/plain, size: 42 B, name: Feb 28 15:36:20 fw postfix/smtpd[15487]: connect from localhost.cindrich.com[127.0.0.1] Feb 28 15:36:20 fw postfix/smtpd[15487]: 1D80ED5098: client=localhost.cindrich.com[127.0.0.1] Feb 28 15:36:20 fw postfix/cleanup[15488]: 1D80ED5098: message- id=<[EMAIL PROTECTED]> Feb 28 15:36:20 fw postfix/qmgr[15476]: 1D80ED5098: from=<[EMAIL PROTECTED]>, size=1358, nrcpt=2 (queue active) Feb 28 15:36:20 fw postfix/smtpd[15487]: disconnect from localhost.cindrich.com[127.0.0.1] Feb 28 15:36:20 fw amavis[15287]: (15287-03) FWD via SMTP: <[EMAIL PROTECTED]> -> <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>, 250 2.6.0 Ok, id=15287-03, from MTA([127.0.0.1]: 587): 250 2.0.0 Ok: queued as 1D80ED5098 Feb 28 15:36:20 fw amavis[15287]: (15287-03) Passed CLEAN, [72.244.45.37] [72.244.45.37] <[EMAIL PROTECTED]> -> <[EMAIL PROTECTED]>,<[EMAIL PROTECTED]>, Message-ID: <07103736- [EMAIL PROTECTED]>, mail_id: TUFDFkt16QOg, Hits: -0.001, 630 ms Feb 28 15:36:20 fw postfix/smtpd[15481]: disconnect from echo.1fast.us [72.244.45.37] Feb 28 15:36:20 fw dbmail/smtp[15493]: sort.c, sort_and_deliver: message id=25136, size=1328 is inserted Feb 28 15:36:20 fw dbmail/smtp[15495]: dbmysql.c,db_query: query [UPDATE dbmail_users SET curmail_size = curmail_size + '1328' WHERE user_idnr = '6'] failed Feb 28 15:36:20 fw dbmail/smtp[15495]: dbmysql.c,db_query: mysql_real_query failed: Deadlock found when trying to get lock; Try restarting transaction Feb 28 15:36:20 fw dbmail/smtp[15495]: db.c,db_add_quotum_used: error adding [1328] to quotum of user [6] Feb 28 15:36:20 fw dbmail/smtp[15495]: db.c,db_copymsg: error setting the new quotum used value for user [6] Feb 28 15:36:20 fw dbmail/smtp[15495]: sort.c, sort_and_deliver: error copying message to user [6] Feb 28 15:36:20 fw postfix/pipe[15491]: 1D80ED5098: to=<[EMAIL PROTECTED]>, relay=dbmail, delay=0.4, delays=0.15/0.08/0/0.17, dsn=2.0.0, status=sent (delivered via dbmail service) Feb 28 15:36:20 fw dbmail/smtp[15495]: pipe.c, insert_messages: temporary failure sort_and_deliver for useridnr [6] Feb 28 15:36:20 fw postfix/pipe[15494]: 1D80ED5098: to=<[EMAIL PROTECTED]>, relay=dbmail, delay=0.42, delays=0.15/0.12/0/0.15, dsn=5.1.1, status=bounced (user unknown) > > > ----- Original Message ----- > From: "Mark Nernberg" <[EMAIL PROTECTED]> > To: "M. J. [Mike] OBrien" <[EMAIL PROTECTED]>; "DBMail mailinglist" > <[email protected]> > Sent: Monday, March 13, 2006 4:36 PM > Subject: Re: [Dbmail] can't find user > > >> 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 >> >> >> >> >> > > _______________________________________________ > 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 http://www.1fast.us/ Customer Support: [EMAIL PROTECTED] Providing secure technology solutions since 2003.
