Difference between revisions of "Obsolete Service/bugs"
Jump to navigation
Jump to search
(Dockerize trac) |
|||
| 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. | ||
| + | * Sam P (email: @sam.today) | ||
* [[User:Daniel Narvaez|Daniel Narvaez]] | * [[User:Daniel Narvaez|Daniel Narvaez]] | ||
* [[User:Bernie|Bernie Innocenti]] | * [[User:Bernie|Bernie Innocenti]] | ||
| Line 34: | Line 29: | ||
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) | |
| − | Edit the | + | # <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]] | ||
Revision as of 23:32, 24 July 2015
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)
- Daniel Narvaez
- Bernie Innocenti
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