Difference between revisions of "Obsolete Service/bugs"
Jump to navigation
Jump to search
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);