From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <overseers-return-9434-listarch-overseers=sources.redhat.com@sourceware.org>
Received: (qmail 29559 invoked by alias); 17 Apr 2007 15:07:37 -0000
Received: (qmail 29524 invoked by uid 22791); 17 Apr 2007 15:07:36 -0000
X-Spam-Check-By: sourceware.org
Received: from nz-out-0506.google.com (HELO nz-out-0506.google.com) (64.233.162.239)
    by sourceware.org (qpsmtpd/0.31) with ESMTP; Tue, 17 Apr 2007 16:07:33 +0100
Received: by nz-out-0506.google.com with SMTP id m7so1512930nzf
        for <overseers@sourceware.org>; Tue, 17 Apr 2007 08:07:33 -0700 (PDT)
Received: by 10.115.55.1 with SMTP id h1mr1357036wak.1176822452681;
        Tue, 17 Apr 2007 08:07:32 -0700 (PDT)
Received: by 10.115.91.14 with HTTP; Tue, 17 Apr 2007 08:07:32 -0700 (PDT)
Message-ID: <4aca3dc20704170807m26462233w331a9f2672633592@mail.gmail.com>
Date: Tue, 17 Apr 2007 15:07:00 -0000
From: "Daniel Berlin" <dberlin@dberlin.org>
To: "Frank Ch. Eigler" <fche@redhat.com>
Subject: Re: Bugzilla spam
Cc: "Jeff Johnston" <jjohnstn@redhat.com>, overseers@sourceware.org
In-Reply-To: <4aca3dc20704170807s344f4155h5935939fe1f49588@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <4623F021.9040000@redhat.com>
	 <4aca3dc20704162309g73c14e9al55c235627782b6db@mail.gmail.com>
	 <20070417105918.GC12538@redhat.com>
	 <4aca3dc20704170807s344f4155h5935939fe1f49588@mail.gmail.com>
Mailing-List: contact overseers-help@sourceware.org; run by ezmlm
Precedence: bulk
List-Id: <overseers.sourceware.org>
List-Archive: <http://sourceware.org/ml/overseers/>
List-Post: <mailto:overseers@sourceware.org>
List-Help: <mailto:overseers-help@sourceware.org>,
	<http://sourceware.org/ml/#faqs>
Sender: overseers-owner@sourceware.org
X-SW-Source: 2007-q2/txt/msg00026.txt.bz2

On 4/17/07, Daniel Berlin <dberlin@dberlin.org> wrote:
> On 4/17/07, Frank Ch. Eigler <fche@redhat.com> wrote:
> > Hi -
> >
> > On Mon, Apr 16, 2007 at 11:09:19PM -0700, Daniel Berlin wrote:
> > > >[...] Any plans in place to stop this or make it more difficult?
> > >
> > > Like how? [...]
> >
> > For one thing, how does one *clean up* spam, that is, remove it from
> > the database?
> >
>
> perl /home/dberlin/userlookup.pl <emailaddressofspammer>
>
> mysql -u<mysql username> -p<mysql password> bugs (You can get the
> user/password from the userlookup.pl script)
> delete from longdescs where who=<id it printed out>

s/bugs/sourcesbugs/ for sources.redhat.com bugzilla.
>
> That will delete all comments from them.
> > - FChE
> >
>