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 <[email protected]>:
> > Sender address rejected: not logged in; from=<[email protected]>
> > to=<[email protected]> proto=SMTP helo=<mail37.messagelabs.com>
> 
> The map lookup matched on [email protected].  
> If you're using SQL for this table, you need to re-examine your query.
> Test queries with something like:
>
>       postmap -q [email protected] 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 <[email protected]>:
> Sender address rejected: not logged in; from=<[email protected]>
> to=<[email protected]> 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 [email protected] |
        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:[email protected]?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.

Reply via email to