Re: More link spam getting through to the lists

This was posted by someone who was actually a subscriber to the list.
And does have DKIM signatures from gmail - though I don't have the
tools to verify them.

It indicates to me that either someone got their account(s) hacked and
used to send it, or a spammer is sophisticated enough to create a
gmail account and subscribed it to the list before they post.. Which
seems quite advanced..

//Magnus

On Wed, Jun 8, 2011 at 19:18, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Lately I've been seeing about one a day of these obvious spams on the
> lists.  Can we do anything to block them?  It mostly seems to be from
> gmail, though I'm not sure that's helpful for filtering purposes.
>
>                        regards, tom lane
>
>
> ------- Forwarded Message
>
> Return-Path: pgsql-general-owner+M176620@postgresql.org
> Delivery-Date: Wed Jun  8 13:01:58 2011
> Received: from mx1.hub.org (mx1.hub.org [200.46.208.106])
>        by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id p58H1v5p014508
>        for <tgl@sss.pgh.pa.us>; Wed, 8 Jun 2011 13:01:58 -0400 (EDT)
> Received: from postgresql.org (mail.postgresql.org [200.46.204.86])
>        by mx1.hub.org (Postfix) with ESMTP id CE89D27FE07A;
>        Wed,  8 Jun 2011 14:01:54 -0300 (ADT)
> Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
>        by mail.postgresql.org (Postfix) with ESMTP id 56C63B5DF14
>        for <pgsql-general-postgresql.org@mail.postgresql.org>; Wed,  8 Jun 2011 14:01:20 -0300 (ADT)
> Received: from mail.postgresql.org ([200.46.204.86])
>  by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
>  with ESMTP id 19945-02
>  for <pgsql-general-postgresql.org@mail.postgresql.org>;
>  Wed,  8 Jun 2011 17:01:17 +0000 (UTC)
> X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
> Received: from mail-qy0-f196.google.com (mail-qy0-f196.google.com [209.85.216.196])
>        by mail.postgresql.org (Postfix) with ESMTP id 4C938B5DF13
>        for <pgsql-general@postgresql.org>; Wed,  8 Jun 2011 14:01:17 -0300 (ADT)
> Received: by qyk35 with SMTP id 35so57527qyk.7
>        for <pgsql-general@postgresql.org>; Wed, 08 Jun 2011 10:01:16 -0700 (PDT)
> DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
>        d=gmail.com; s=gamma;
>        h=domainkey-signature:mime-version:date:message-id:subject:from:to
>         :content-type;
>        bh=UfJi9a04+0b0OmXcSG0SUsIOM0isuMc4L1UZNdChISo=;
>        b=m/sy0aR9+8nUv7ET42QisKWOXrBPF/m2x0QBxOPJrozZu//FLku0RCog2+3ra7i6ET
>         UeCXPt0aJFU3sK7kyWdp4Zim7bceBDflGPPXBVy/O9L77ZHm42erEwWFMoROq5cs/HrK
>         oSe8X7FM72vger8CgpBZUvspZu1y/vH+dV6UY=
> DomainKey-Signature: a=rsa-sha1; c=nofws;
>        d=gmail.com; s=gamma;
>        h=mime-version:date:message-id:subject:from:to:content-type;
>        b=jfColABQMYePwBWTSrxprqa2MszNxpKN91HfeqcY/Gn3ihhdG9ATJJqR2SqrHv5h24
>         aAnS788JbxnWCXE86Z7or8rKCa6+lUjxOdYlI45Z9LTajmS/XlERzQNveSe8WEn+D4/z
>         Jz1uD3Y0MJJ5gyMWMqY7QOKR7P9Sqk83qgZ5U=
> MIME-Version: 1.0
> Received: by 10.229.127.104 with SMTP id f40mr5709455qcs.48.1307552476721;
>  Wed, 08 Jun 2011 10:01:16 -0700 (PDT)
> Received: by 10.229.95.8 with HTTP; Wed, 8 Jun 2011 10:01:16 -0700 (PDT)
> Date: Wed, 8 Jun 2011 18:01:16 +0100
> Message-ID: <BANLkTi=iG=5MeyMf0r4OY8i0f_nr=T6U4g@mail.gmail.com>
> Subject: [GENERAL]
> From: Callum Scott <scott.callum@gmail.com>
> To: paul.connelly1@o2.co.uk, peterbratcher@hotmail.com,
>        peter.cruickshank@gmail.com, petercruikshank@gmail.com,
>        colinpeters@fvhost.org.uk, pgsql-general@postgresql.org,
>        info@power-adapters.co.uk, rathgild@gmail.com, redmanifesto@gmail.com,
>        register@dum.acc.umu.se
> Content-Type: text/plain; charset=ISO-8859-1
> X-Virus-Scanned: Maia Mailguard 1.0.1
> X-Spam-Status: No, hits=-1.887 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
>  FREEMAIL_FROM=0.001, RFC_ABUSE_POST=0.001, TVD_SPACE_RATIO=0.001,
>  T_TO_NO_BRKTS_FREEMAIL=0.01
> X-Spam-Level:
> X-Mailing-List: pgsql-general
> List-Archive: <http://archives.postgresql.org/pgsql-general>
> List-Help: <mailto:majordomo@postgresql.org?body=help>
> List-ID: <pgsql-general.postgresql.org>
> List-Owner: <mailto:pgsql-general-owner@postgresql.org>
> List-Post: <mailto:pgsql-general@postgresql.org>
> List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-general>
> List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
> Precedence: bulk
> Sender: pgsql-general-owner@postgresql.org
>
> http://alkiosco.com/lindex02.html
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
> ------- End of Forwarded Message
>
>
> --
> Sent via pgsql-www mailing list (pgsql-www@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-www
>