bugzilla spam

bugzilla spam

[Jonathan Wakely]

http://gcc.gnu.org/ml/gcc-bugs/2012-03/msg00961.html

Is there a policy for removing spam comments such as this?

Re: bugzilla spam

[Frank Ch. Eigler]

Hi -

On Tue, Mar 13, 2012 at 09:47:51AM +0000, Jonathan Wakely wrote:
> [...]
> Is there a policy for removing spam comments such as this?

I think what's missing is mechanism, not policy.  AFAIK,
bugzilla just doesn't have reasonable spam removal facilities.

- FChE

Re: bugzilla spam

[Paolo Carlini]

On 03/13/2012 11:43 AM, Frank Ch. Eigler wrote:
> Hi -
>
> On Tue, Mar 13, 2012 at 09:47:51AM +0000, Jonathan Wakely wrote:
>> [...]
>> Is there a policy for removing spam comments such as this?
> I think what's missing is mechanism, not policy.  AFAIK,
> bugzilla just doesn't have reasonable spam removal facilities.
I see. Still, in the past I thought to myself multiple times that it 
seems strange that in general we can only *add* to the audit trail, 
nothing can be removed. I understand that can be also a freedom of 
expression issue, if you see what I mean, but in some extreme cases, 
like pure and obvious spam, shouldn't we have a way to remove things?!? 
Maybe somebody, endowed with appropriate privileges, should simply do 
that by hand, on a case by case basis?

Thanks,
Paolo.

Re: bugzilla spam

[Frank Ch. Eigler]

Hi, Paolo -

> >I think what's missing is mechanism, not policy.  AFAIK,
> >bugzilla just doesn't have reasonable spam removal facilities.

> [...]  but in some extreme cases, like pure and obvious spam,
> shouldn't we have a way to remove things?!?  [...]

Maybe our mozilla friends will have some advice over at
https://bugzilla.mozilla.org/show_bug.cgi?id=735213

- FChE

Re: bugzilla spam

[Paolo Carlini]

On 03/13/2012 04:08 PM, Frank Ch. Eigler wrote:
> Maybe our mozilla friends will have some advice over at
> https://bugzilla.mozilla.org/show_bug.cgi?id=735213
Thanks a lot Frank, I'll track the issue. Crazy, I can't believe there 
is currently *no* mechanism available at all!

Paolo.

Bugzilla spam

[Jeff Johnston]

I have recently been getting bugs opened against newlib which are spam. 
  The bugs have nonsense in them with html attachments which redirect to 
porn pages, etc...

Any plans in place to stop this or make it more difficult?

Bug numbers include:

4355
4363
4382

All 3 bugs are from different e-mail addresses though 2 are randomized 
names from mailinator.com.

-- Jeff J.

Re: Bugzilla spam

[Christopher Faylor]

On Mon, Apr 16, 2007 at 05:52:33PM -0400, Jeff Johnston wrote:
>I have recently been getting bugs opened against newlib which are spam. 
> The bugs have nonsense in them with html attachments which redirect to 
>porn pages, etc...
>
>Any plans in place to stop this or make it more difficult?
>
>Bug numbers include:
>
>4355
>4363
>4382
>
>All 3 bugs are from different e-mail addresses though 2 are randomized 
>names from mailinator.com.

We could, at least, block their IP address if we have logged it.

cgf

Re: Bugzilla spam

[Daniel Berlin]

On 4/16/07, Jeff Johnston <jjohnstn@redhat.com> wrote:
> I have recently been getting bugs opened against newlib which are spam.
>   The bugs have nonsense in them with html attachments which redirect to
> porn pages, etc...
>
> Any plans in place to stop this or make it more difficult?

Like how?
we could simply ban names including mailinator, but past that, ..

>
> Bug numbers include:
>
> 4355
> 4363
> 4382
>
> All 3 bugs are from different e-mail addresses though 2 are randomized
> names from mailinator.com.
>
> -- Jeff J.
>
>

Re: Bugzilla spam

[Frank Ch. Eigler]

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?

- FChE

Re: Bugzilla spam

[Daniel Berlin]

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>

That will delete all comments from them.
> - FChE
>

Re: Bugzilla spam

[Daniel Berlin]

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
> >
>

Re: Bugzilla spam

[Jeff Johnston]

Daniel Berlin wrote:
> On 4/16/07, Jeff Johnston <jjohnstn@redhat.com> wrote:
>> I have recently been getting bugs opened against newlib which are spam.
>>   The bugs have nonsense in them with html attachments which redirect to
>> porn pages, etc...
>>
>> Any plans in place to stop this or make it more difficult?
> 
> Like how?
> we could simply ban names including mailinator, but past that, ..
> 

I was also thinking along the lines of having the Bugzilla registration 
use captcha if not already doing so.

-- Jeff J.