--- In [email protected], Victor Duchovni <victor.ducho...@...> wrote: > > On Wed, Jan 14, 2009 at 08:54:52PM -0600, Noel Jones wrote: > > > > Jan 14 15:03:37 s postfix/smtpd[44746]: NOQUEUE: reject: RCPT from > > > mail37.messagelabs.com[216.82.241.83]: 553 5.7.1 <katie.prev...@...>: > > > Sender address rejected: not logged in; from=<katie.prev...@...> > > > to=<myu...@...> proto=SMTP helo=<mail37.messagelabs.com> > > > > The map lookup matched on katie.prev...@... > > If you're using SQL for this table, you need to re-examine your query. > > Test queries with something like: > > > > postmap -q katie.prev...@... mysql:/path/to/xxx.cf > > Spot on! > > > Note there is a difference between "not found" and an empty response. > > In most cases Postfix suppresses empty results (and records a warning > int the logs). > > On Thu, Jan 15, 2009 at 12:21:51AM -0000, jeff_homeip wrote: > > > > So either your report is incomplete/inaccurate, or you have managed to > > > list all the senders you tested in smtpd_sender_login_maps (difficult > > > with indexed files, easier with regexp tables and SQL lookups). > > > > Jan 14 15:03:37 s postfix/smtpd[44746]: NOQUEUE: reject: RCPT from > > mail37.messagelabs.com[216.82.241.83]: 553 5.7.1 <katie.prev...@...>: > > Sender address rejected: not logged in; from=<katie.prev...@...> > > to=<myu...@...> proto=SMTP helo=<mail37.messagelabs.com> > > > > > > I don't know how else to interpret this behavior, other than to conclude > > that adding that line to my master.cf caused the mail to be rejected, > > which is not what I expected. > > I suggested two possibilities (and even hinted at SQL query issues as > a possible cause), you seem to have overlooked the second. > > > smtpd_sender_login_maps = > > mysql:/etc/postfix/mysql_smtpd_sender_login_maps.cf > > There's the problem. Now test the table as Noel suggested. > > $ echo katie.prev...@... | > postmap -q - mysql:/etc/postfix/mysql_smtpd_sender_login_maps.cf > > -- > Viktor. > > Disclaimer: off-list followups get on-list replies or get ignored. > Please do not ignore the "Reply-To" header. > > To unsubscribe from the postfix-users list, visit > http://www.postfix.org/lists.html or click the link below: > <mailto:majord...@...?body=unsubscribe%20postfix-users> > > If my response solves your problem, the best way to thank me is to not > send an "it worked, thanks" follow-up. If you must respond, please put > "It worked, thanks" in the "Subject" so I can delete these quickly. >
Noel, Viktor: I see why you think that - but I did test with postmap -q quite extensively before I added this, sorry I didn't mention it here. I just tested again with this result: % /etc/postfix : postmap -q [email protected] mysql:/etc/postfix/mysql_smtpd_sender_login_maps.cf % /etc/postfix : postmap returned an empty result, which I thought was correct. Should it be returning something different? If so, what should the result for an address not listed on my server be? I appreciate your help and your work to narrow down and isolate the issue here. Thanks! --Jeff
