[Systems] Spam accounts on trac

[Sascha Silbe]

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".
The "length(sid) != 24" check is needed because SessionStore (which the
AccountManager plugin is configured to use) stores the user account in
the "session" table (which contains the HTTP session IDs). :-/ 

Sascha

--
http://sascha.silbe.org/
http://www.infra-silbe.de/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 490 bytes
Desc: not available
Url : http://lists.sugarlabs.org/private/systems/attachments/20100905/1a8cfb4e/attachment.pgp