Service/bugs

Description

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

Hostnames

• http://bugs.sugarlabs.org/
• http://bugs-testing.sugarlabs.org/
• http://bugs-devel.sugarlabs.org/

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.

• Sascha Silbe
• Bernie Innocenti

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

Trac sucks

mkdir -p /srv/www-sugarlabs/bugs-testing/lib/python2.6/site-packages
PYTHONPATH=/srv/www-sugarlabs/bugs-testing/lib/python2.6/site-packages easy_install --prefix /srv/www-sugarlabs/bugs-testing http://svn.edgewall.org/repos/genshi/branches/stable/0.5.x/
PYTHONPATH=/srv/www-sugarlabs/bugs-testing/lib/python2.6/site-packages easy_install --prefix /srv/www-sugarlabs/bugs-testing http://svn.edgewall.org/repos/trac/branches/0.11-stable/
PYTHONPATH=/srv/www-sugarlabs/bugs-testing/lib/python2.6/site-packages easy_install --prefix /srv/www-sugarlabs/bugs-testing http://trac-hacks.org/svn/accountmanagerplugin/0.11/

mkdir -p /srv/www-sugarlabs/bugs-devel/lib/python2.6/site-packages
PYTHONPATH=/srv/www-sugarlabs/bugs-devel/lib/python2.6/site-packages easy_install --prefix /srv/www-sugarlabs/bugs-devel http://svn.edgewall.org/repos/genshi/trunk/
PYTHONPATH=/srv/www-sugarlabs/bugs-devel/lib/python2.6/site-packages easy_install --prefix /srv/www-sugarlabs/bugs-devel http://svn.edgewall.org/repos/trac/trunk/
PYTHONPATH=/srv/www-sugarlabs/bugs-devel/lib/python2.6/site-packages easy_install --prefix /srv/www-sugarlabs/bugs-devel http://trac-hacks.org/svn/accountmanagerplugin/trunk
PYTHONPATH=/srv/www-sugarlabs/bugs-devel/lib/python2.6/site-packages bin/trac-admin /srv/www-sugarlabs/bugs-devel upgrade

Maybe must be installed manually? http://trac-hacks.org/svn/accountmanagerplugin/0.11/

upgrade eggs when python changes

rm -r eggs/*
cd plugins
for i in *.egg; do mv $i `echo $i | sed -e s/2\\.5/2.6/`; done
/etc/init.d/apache2 restart