[Systems] Spam accounts on trac
Bernie Innocenti
bernie at codewiz.org
Sun Sep 5 19:08:12 EDT 2010
El Sun, 05-09-2010 a las 13:44 +0200, Sascha Silbe escribió:
> Excerpts from Bernie Innocenti's message of Sun Sep 05 10:12:51 +0200 2010:
>
> > there are dozens of accounts in Trac with a @mail.ru email domain which
> > are certainly spammers. How about purging them all with an SQL query?
>
> sqlite> select count(*) from session where length(sid) != 24 and not exists (select * from permission where username=sid);
> 537
> sqlite>
>
> If that query looks fine to you, I'll replace "select count(*)" with
> "delete".
I'm not sure, but I fully trust your judgement on this.
Well, on second thought... let's also keep a backup copy of the original
sqlite DB ;-)
--
// Bernie Innocenti - http://codewiz.org/
\X/ Sugar Labs - http://sugarlabs.org/
More information about the Systems
mailing list