Difference between revisions of "Service/bugs"

From Sugar Labs
Jump to navigation Jump to search
(create service page for bugs.sl.o)
 
(→‎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 19:51, 5 February 2011

Description

A Trac instance for keeping track of bugs in upstream Sugar components, some activities and Rainbow.


Hostnames


Hosted on

Machine/sunjammer


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);

Upgrade notes

See Also