[Greylist-users] Milter error with latest CVS

[Evan Harris]

On Mon, 21 Jul 2003, Nathan A. Stratton wrote:

> changed. I now have it running, but local mail is giving me tempfail. From
> Pine I see the error:
>
>  [Mail not sent. Sending error: 451 4.7.1 Please try again later (TEMPFA]
>
> The relaydelay logs looks like:
>
> === 2003-07-21 17:15:23 ===
> Stored Sender: <nathan at robotics.net>
> Passed Recipient: <nathan at robotics.com>
>   Relay: cyber.robotics.net [209.150.98.78] - If_Addr: 209.150.98.78
>   RelayIP: 209.150.98.78 - RelayName: cyber.robotics.net - RelayIdent:  -
> PossiblyForged: 0
>   From: nathan - To: nathan at robotics.com
>   InMailer: local - OutMailer: esmtp - QueueID: h6LLFN9d020385
>   Mail delivery is sent from a local interface.  Skipping checks.
>   Reverse tracking row successfully inserted for the recipient of this mail.
> rowid: 4
>   IN EOM CALLBACK - PrivData: 0<nathan at robotics.net><nathan at robotics.com>

Are you sure you have the right entry?  If it says skipping checks, you
should not be getting the tempfail.  As a matter of fact, the "IN EOM
CALLBACK" tells me that this mail was successfully passed (unless you have
another later milter that blocked it), because if we were blocking it, we
would have seen the ABORT callback instead.

> So it looks like it is skipping checks, so I am not sure why I am getting
> a tempfail. I added 209.150.98.78 (my server IP) and loopback to
> whitelist:

If you are running from the current cvs code, you don't need a whitelist
entry for your own IP and loopback, unless there are other hosts accepting
mail from you using the same db.  0.02 and earlier versions did though.

> I also love stats, I know it is not required, but any way to get the
> following to work, I am using MYSql Ver 11.15 Distrib 3.23.44, for
> pc-linux-gnu (i686).
>
> # interesting queries for reporting on db contents
> # get the delay time of the most persistent non-passed mails, in 5 minute buckets
> select convert((UNIX_TIMESTAMP( last_update ) - UNIX_TIMESTAMP( create_time
> )) / 300, unsigned) as foo, count(*) from relaytofrom where record_expires
> < NOW() and blocked_count > 0 and passed_count = 0

Since I no longer have a 3.x mysql server setup, can't really help you there
without playing with it.  Maybe someone else can.

> Last question, if I put the graylist stuff before my dns blacklist will I
> get the added benefit of being able to receive mail from uses that are on
> dns blacklists, but whom I have sent mail because graylist would be first
> in sendmail.cf and they would be then whitelisted?

No.  Milters are additive.  If any milter or sendmail rule would block the
mail, it gets blocked.  Using relaydelay.pl will not make other parts accept
the mail when they normally wouldn't.

Evan