Obsolete Service/bugs: Difference between revisions
Sascha silbe (talk | contribs) create service page for bugs.sl.o |
Sascha silbe (talk | contribs) →Cleaning user database: include sqlite3 invocation |
||
| Line 35: | Line 35: | ||
To remove inactive accounts (i.e. ones that have never been confirmed or marked as spammers): | To remove inactive accounts (i.e. ones that have never been confirmed or marked as spammers): | ||
sqlite3 /srv/www-sugarlabs/bugs/db/trac.db | |||
DELETE FROM session WHERE length(sid) != 24 AND NOT EXISTS (SELECT * FROM permission WHERE username = sid); | DELETE FROM session WHERE length(sid) != 24 AND NOT EXISTS (SELECT * FROM permission WHERE username = sid); | ||
Revision as of 18:51, 5 February 2011
Description
A Trac instance for keeping track of bugs in upstream Sugar components, some activities and Rainbow.
Hostnames
Hosted on
Administrative contact
systems AT lists DOT sugarlabs DOT org
Sysadmins
For non-emergency calls, preferably send email to the administrative contact.
Notes
Cleaning user database
To remove inactive accounts (i.e. ones that have never been confirmed or marked as spammers):
sqlite3 /srv/www-sugarlabs/bugs/db/trac.db DELETE FROM session WHERE length(sid) != 24 AND NOT EXISTS (SELECT * FROM permission WHERE username = sid);