Alexander E. Patrakov wrote:
The LiveCD Trac has tickets 1652-1670 with Chinese SPAM. I have neither
knowledge nor permissions required to fight with it. No valid issues
were reported in the last three months. Therefore, please remove the
LiveCD section of Trac completely.
True, it hasn't been used much, but having it open would be nice. Also
setting a random password for that user the spammer is using might be a
good idea. It is pretty trivial to remove the spam tickets, I did it in
the postgresql backend for the few we got at trac.cross-lfs.org. Sure,
that ticket number is missing in the ticket list, but at least you don't
have that huge text in Timeline or ticket view.
To remove such tickets (I can't do it, the database is owned by httpd
and not writeable to lfswww)
belgarath:justin /usr/local/trac/livecd/db $ ls -l trac.db
-rw-r--r-- 1 httpd lfswww 2099200 Jul 27 17:43 trac.db
Just enter the database:
sqlite3 trac.db
Then delete the offending ticket:
delete from ticket where id = 1652;
delete from ticket_change where ticket = 1652;
That will delete the ticket and any comments/changes such as ticket
closed or comments. If there are attachments or other weird things in
there:
delete from ticket_custom where ticket = 1652;
delete from attachment where type = "ticket" and id = 1652;
This worked fine in Trac + Postgresql backend, and I don't see any
reason it wouldn't work here.
Justin
--
http://linuxfromscratch.org/mailman/listinfo/livecd
FAQ: http://www.linuxfromscratch.org/faq/
Unsubscribe: See the above information page
