Difference between revisions of "Obsolete Service/bugs"
Jump to navigation
Jump to search
Sascha silbe (talk | contribs) (→Cleaning user database: include sqlite3 invocation) |
m (Bernie moved page Service/bugs to Obsolete Service/bugs) |
||
| (7 intermediate revisions by 3 users not shown) | |||
| Line 2: | Line 2: | ||
A [http://trac.edgewall.org/ Trac] instance for keeping track of bugs in upstream Sugar components, some activities and Rainbow. | A [http://trac.edgewall.org/ Trac] instance for keeping track of bugs in upstream Sugar components, some activities and Rainbow. | ||
| − | |||
| − | |||
== Hostnames == | == Hostnames == | ||
| Line 9: | Line 7: | ||
* http://bugs-testing.sugarlabs.org/ | * http://bugs-testing.sugarlabs.org/ | ||
* http://bugs-devel.sugarlabs.org/ | * http://bugs-devel.sugarlabs.org/ | ||
| − | |||
| − | |||
== Hosted on == | == Hosted on == | ||
| − | [[Machine/ | + | Production site runs dockerized on [[Machine/freedom]]. Data stored in the /srv/socialhelp partition |
| − | |||
| + | (Old) testing and devel sites run on [[Machine/sunjammer]] | ||
== Administrative contact == | == Administrative contact == | ||
[http://lists.sugarlabs.org/listinfo/systems systems AT lists DOT sugarlabs DOT org] | [http://lists.sugarlabs.org/listinfo/systems systems AT lists DOT sugarlabs DOT org] | ||
| − | |||
| − | |||
== Sysadmins == | == Sysadmins == | ||
For non-emergency calls, preferably send email to the administrative contact. | For non-emergency calls, preferably send email to the administrative contact. | ||
| − | * [[User: | + | * [[User:SAMdroid|Sam P]] (email: @sam.today) |
| − | |||
| − | |||
== Notes == | == Notes == | ||
| Line 35: | Line 27: | ||
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/ | + | sqlite3 /srv/socialhelp/tracproject/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); | ||
== Upgrade notes == | == Upgrade notes == | ||
| − | + | # Edit the Dockerfile (stored in /home/sam/trac or from the [https://github.com/sugarlabs-infra/trac-docker github repository]) to include the latest version of Trac (eg. change the version numbers) | |
| − | + | # <code>container.yml start /home/sam/trac -d</code> | |
== See Also == | == See Also == | ||
| − | + | https://github.com/sugarlabs-infra/trac-docker[[Category:Service|bugs]] | |
| − | [[Category:Service|bugs]] | ||
Latest revision as of 17:08, 5 June 2024
Description
A Trac instance for keeping track of bugs in upstream Sugar components, some activities and Rainbow.
Hostnames
Hosted on
Production site runs dockerized on Machine/freedom. Data stored in the /srv/socialhelp partition
(Old) testing and devel sites run on Machine/sunjammer
Administrative contact
systems AT lists DOT sugarlabs DOT org
Sysadmins
For non-emergency calls, preferably send email to the administrative contact.
- Sam P (email: @sam.today)
Notes
Cleaning user database
To remove inactive accounts (i.e. ones that have never been confirmed or marked as spammers):
sqlite3 /srv/socialhelp/tracproject/db/trac.db DELETE FROM session WHERE length(sid) != 24 AND NOT EXISTS (SELECT * FROM permission WHERE username = sid);
Upgrade notes
- Edit the Dockerfile (stored in /home/sam/trac or from the github repository) to include the latest version of Trac (eg. change the version numbers)
container.yml start /home/sam/trac -d