[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