Thread: Re: Bouncing replies

Re: Bouncing replies

From
"Dean Gibson (DB Administrator)"
Date:
PostgreSQL list serve output has not been connecting from mail.postgresql.org for a LONG time (see the headers
below). Currently they've been connecting from various hosts at the hub.org domain, but there have several other
non-postgresql.orgconnecting domains in the past.  Whenever I stop getting PostgreSQL mail, I go check my Postfix logs
tosee what the new hostname's domain is, and update my whitelist.<br /><br /> While mail may originally come from a
postgresql.orghost, as I'm sure you know, the only information that a receiving SMTP server can trust is the connecting
IPaddress and the hostname from a DNS reverse IP lookup.  Everything else can be falsified.  That's why virtually all
SMTP-levelspam filtering (including all DNS blacklist lookups) is based on the connecting IP address.<br /><br /> --
Dean<br/><br /> -------- Original Message -------- <table border="0" cellpadding="0" cellspacing="0"
class="moz-email-headers-table"><tbody><tr><thalign="right" nowrap valign="baseline">Return-Path: </th><td><a
class="moz-txt-link-rfc2396E"
href="mailto:pgsql-sql-owner+M30162@postgresql.org"><pgsql-sql-owner+M30162@postgresql.org></a></td></tr><tr><th
align="right"nowrap valign="baseline">X-Original-To: </th><td>***</td></tr><tr><th align="right" nowrap
valign="baseline">Delivered-To:</th><td>***</td></tr><tr><th align="right" nowrap valign="baseline">Received:
</th><td>frommail.mailpen.net (mail.mailpen.net [209.90.228.14]) by sc440a.internal.mailpen.net (Postfix) with ESMTP id
384105444E9for <***>; Mon, 11 Feb 2008 00:56:14 -0800 (PST)</td></tr><tr><th align="right" nowrap
valign="baseline">Received:</th><td>by mail.mailpen.net (Postfix) id D33062FE81D; Mon, 11 Feb 2008 00:56:13 -0800
(PST)</td></tr><tr><thalign="right" nowrap valign="baseline">Delivered-To: </th><td>***</td></tr><tr><th align="right"
nowrapvalign="baseline">Received: </th><td>from maia-1.hub.org (maia-1.hub.org [200.46.204.191]) by mail.mailpen.net
(Postfix)with ESMTP id 952632FE802 for <***>; Mon, 11 Feb 2008 00:56:11 -0800 (PST)</td></tr><tr><th
align="right"nowrap valign="baseline">Received: </th><td>from postgresql.org (postgresql.org [200.46.204.71]) by
maia-1.hub.org(Postfix) with ESMTP id 6734DDB3A14; Mon, 11 Feb 2008 04:56:07 -0400 (AST)</td></tr><tr><th align="right"
nowrapvalign="baseline">Received: </th><td>from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with
ESMTPid 14BEC2E030B for <a class="moz-txt-link-rfc2396E"
href="mailto:pgsql-sql-postgresql.org@postgresql.org"><pgsql-sql-postgresql.org@postgresql.org></a>;Mon, 11 Feb
200804:54:09 -0400 (AST)</td></tr><tr><th align="right" nowrap valign="baseline">Received: </th><td>from postgresql.org
([200.46.204.71])by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 80826-05 for <a
class="moz-txt-link-rfc2396E"
href="mailto:pgsql-sql-postgresql.org@postgresql.org"><pgsql-sql-postgresql.org@postgresql.org></a>;Mon, 11 Feb
200804:54:01 -0400 (AST)</td></tr><tr><th align="right" nowrap valign="baseline">Received: </th><td>from
wx-out-0506.google.com(wx-out-0506.google.com [66.249.82.231]) by postgresql.org (Postfix) with ESMTP id 108552E0306
for<a class="moz-txt-link-rfc2396E" href="mailto:pgsql-sql@postgresql.org"><pgsql-sql@postgresql.org></a>; Mon,
11Feb 2008 04:54:04 -0400 (AST)</td></tr><tr><th align="right" nowrap valign="baseline">Received: </th><td>by
wx-out-0506.google.comwith SMTP id r21so3723208wxc.28 for <a class="moz-txt-link-rfc2396E"
href="mailto:pgsql-sql@postgresql.org"><pgsql-sql@postgresql.org></a>;Mon, 11 Feb 2008 00:54:04 -0800
(PST)</td></tr><tr><thalign="right" nowrap valign="baseline">Received: </th><td>by 10.151.144.4 with SMTP id
w4mr905002ybn.199.1202720044201;Mon, 11 Feb 2008 00:54:04 -0800 (PST)</td></tr><tr><th align="right" nowrap
valign="baseline">Received:</th><td>by 10.150.96.5 with HTTP; Mon, 11 Feb 2008 00:54:04 -0800 (PST)</td></tr><tr><th
align="right"nowrap valign="baseline">Message-ID: </th><td><a class="moz-txt-link-rfc2396E"
href="mailto:937d27e10802110054h6538294bwcb8100665048bd57@mail.gmail.com"><937d27e10802110054h6538294bwcb8100665048bd57@mail.gmail.com></a></td></tr><tr><th
align="right"nowrap valign="baseline">Date: </th><td>Mon, 11 Feb 2008 08:54:04 +0000</td></tr><tr><th align="right"
nowrapvalign="baseline">From: </th><td>Dave Page <***></td></tr><tr><th align="right" nowrap
valign="baseline">To:</th><td>Dean Gibson (DB Administrator) <***></td></tr><tr><th align="right" nowrap
valign="baseline">Subject:</th><td>Re: [SQL] Bouncing replies</td></tr><tr><th align="right" nowrap
valign="baseline">Cc:</th><td><a class="moz-txt-link-abbreviated"
href="mailto:pgsql-sql@postgresql.org">pgsql-sql@postgresql.org</a></td></tr><tr><thalign="right" nowrap
valign="baseline">In-Reply-To:</th><td><a class="moz-txt-link-rfc2396E"
href="mailto:47AFD7DD.2040000@ultimeth.com"><47AFD7DD.2040000@ultimeth.com></a></td></tr><tr><thalign="right"
nowrapvalign="baseline">MIME-Version: </th><td>1.0</td></tr><tr><th align="right" nowrap
valign="baseline">Content-Type:</th><td>text/plain; charset=ISO-8859-1</td></tr><tr><th align="right" nowrap
valign="baseline">Content-Transfer-Encoding:</th><td>7bit</td></tr><tr><th align="right" nowrap
valign="baseline">Content-Disposition:</th><td>inline</td></tr><tr><th align="right" nowrap
valign="baseline">References:</th><td><a class="moz-txt-link-rfc2396E"
href="mailto:47AFA703.5060907@ultimeth.com"><47AFA703.5060907@ultimeth.com></a><a class="moz-txt-link-rfc2396E"
href="mailto:15372.1202698673@sss.pgh.pa.us"><15372.1202698673@sss.pgh.pa.us></a><a class="moz-txt-link-rfc2396E"
href="mailto:15505.1202699499@sss.pgh.pa.us"><15505.1202699499@sss.pgh.pa.us></a><a class="moz-txt-link-rfc2396E"
href="mailto:47AFD7DD.2040000@ultimeth.com"><47AFD7DD.2040000@ultimeth.com></a></td></tr><tr><thalign="right"
nowrapvalign="baseline">X-Virus-Scanned: </th><td>Maia Mailguard 1.0.1</td></tr><tr><th align="right" nowrap
valign="baseline">X-Mailing-List:</th><td>pgsql-sql</td></tr><tr><th align="right" nowrap
valign="baseline">List-Archive:</th><td><a class="moz-txt-link-rfc2396E"
href="http://archives.postgresql.org/pgsql-sql"><http://archives.postgresql.org/pgsql-sql></a></td></tr><tr><th
align="right"nowrap valign="baseline">List-Help: </th><td><a class="moz-txt-link-rfc2396E"
href="mailto:majordomo@postgresql.org?body=help"><mailto:majordomo@postgresql.org?body=help></a></td></tr><tr><th
align="right"nowrap valign="baseline">List-ID: </th><td><pgsql-sql.postgresql.org></td></tr><tr><th align="right"
nowrapvalign="baseline">List-Owner: </th><td><a class="moz-txt-link-rfc2396E"
href="mailto:pgsql-sql-owner@postgresql.org"><mailto:pgsql-sql-owner@postgresql.org></a></td></tr><tr><th
align="right"nowrap valign="baseline">List-Post: </th><td><a class="moz-txt-link-rfc2396E"
href="mailto:pgsql-sql@postgresql.org"><mailto:pgsql-sql@postgresql.org></a></td></tr><tr><thalign="right" nowrap
valign="baseline">List-Subscribe:</th><td><a class="moz-txt-link-rfc2396E"
href="mailto:majordomo@postgresql.org?body=sub%20pgsql-sql"><mailto:majordomo@postgresql.org?body=sub%20pgsql-sql></a></td></tr><tr><th
align="right"nowrap valign="baseline">List-Unsubscribe: </th><td><a class="moz-txt-link-rfc2396E"
href="mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql"><mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql></a></td></tr><tr><th
align="right"nowrap valign="baseline">Precedence: </th><td>bulk</td></tr><tr><th align="right" nowrap
valign="baseline">Sender:</th><td><a class="moz-txt-link-abbreviated"
href="mailto:pgsql-sql-owner@postgresql.org">pgsql-sql-owner@postgresql.org</a></td></tr><tr><thalign="right" nowrap
valign="baseline">Status:</th><td>O</td></tr><tr><th align="right" nowrap valign="baseline">X-UID:
</th><td>25516</td></tr><tr><thalign="right" nowrap valign="baseline">Content-Length: </th><td>1252</td></tr><tr><th
align="right"nowrap valign="baseline">X-Keywords: </th><td><br /></td></tr></tbody></table><br /><br /><pre>On Feb 11,
20085:06 AM, Dean Gibson (DB Administrator) wrote:
 
> If mail to my list address doesn't come from one of your list
> servers (and those seems to change much more often than any other list I
> belong to), it gets rejected.

Those must be some *really* long-lived lists. Our mailserver has been
mail.postgresql.org for probably 7 or 8 years now. Many moons ago we
did use some additional relay servers, but I don't think we've done
that for 5+ years.

</pre>

Re: Bouncing replies

From
"Dave Page"
Date:
On Feb 11, 2008 9:30 AM, Dean Gibson (DB Administrator)
<postgresql@ultimeth.com> wrote:
>
>  PostgreSQL list serve output has not been connecting from
> mail.postgresql.org for a LONG time (see the headers below).  Currently
> they've been connecting from various hosts at the hub.org domain, but there
> have several other non-postgresql.org connecting domains in the past.
> Whenever I stop getting PostgreSQL mail, I go check my Postfix logs to see
> what the new hostname's domain is, and update my whitelist.

Without wishing to sound pedantic, the list server itself which was
what you asserted kept changing has in fact not changed. Looking at
the headers I see the message has been relayed through the spam
filtering at hub.org as well which I didn't realise Marc was doing (I
thought he only checked incoming posts), but regardless, all mail
should be coming only from hub.org/postgresql.org machines. I'd be
interested to see where else you've seen it come from, and when.

-- 
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Oracle-compatible database company