Stefano Zacchiroli: trac.cs.unibo.it
Experiences with a Trac Server
In the last few days after Xmas I set up http://trac.cs.unibo.it, a server for
my CS department which will host a bunch of Trac instances,
initially for academic projects only then it will be opened to
student projects as well.
The server set-up has been "powered-by" the following
technologies:
new year birthday
trac.cs.unibo.it.
- Debian Etch
- Apache 2.2 with FastCGI, SuExec, and WebDAV over TLS (for accessing SVN repositories without forcibly passing through Trac)
- Trac instances backed by Sqlite databases and Subversion repositories
- Some bits of Genshi templating for generating the projects index
- Some shell scripts for automating creation and removal of projects
- installing Etch is more a dream than ever, in 15 minutes I re-installed the server (which previously was running Ubuntu) with a decent partitioning scheme and all that I needed to work remotely. The sysadm of the department saw me coming out from the server room and asked, unbelievingly, did you already finish?
- apache2.2 in Debian is now annoyingly missing the nice script for creating easily TLS certificates (i.e. apache2-ssl-certificate). I followed-up on #395823 attaching the same script took from Sarge and the needed configuration file. Worked for me
- SuExec is stupid. You have to put stuff under /var/www for it to work at all, the only way to change the path is rebuild apache .... or, you can mount --bind /srv/trac /var/www/trac!
- BTW I like /srv. According to the FHS it's the place where I want to put my Trac projects. Unfortunately the Debian installer neglects that path and per default you end up with a system where /srv is in the same partition as /, and hence with basically no free space. Hence I also bind-mounted /srv/trac from /home/trac
- In Etch we have no available implementation of FastCGI (which really improves Trac performances BTW). libapache2-mod-fastcgi is non-free and for some reason it was not autobuild everywhere and hence is missing from testing. I pinged aba on IRC about that, so the package should probably enter testing again in a few days. Go RMs!
This is a chart from the Debian popularity contest statistics. Submitting data
here is entirely voluntary; the data is used to determine which packages to
put on which CDs in the CD set.
The chart contains four lines, the top line is for bash; pretty much every
system has bash, so this is very close to the number of submissions to the
popularity contest database. Note that this number has doubled within one year.
Sarge was released in June 2005, and thats where the graph changes
significantly. Up to then, popularity contest was a rather uncommon package,
but sarge promoted its use somewhat IIRC. So lets look only on the post-sarge
part of the graph. Ubuntu Dapper was released in June 2006. Any effect? No.
The other lines are gnome-session (green), kwin from KDE (blue) and
openoffice.org-base (red). KDE is at about 25%, Gnome at about 50% and
Openoffice goes up to 50%. This suggests that a significant amount of Debian
installations are actually desktop machines (I remove popcon on all my servers,
where I'm more concerned with not having too much software on it). For KDE and
Gnome, these values have been quite constant. When only counting "active" users,
Gnome drops to about 25% (same for OO.o), and KDE to around 10%. VIM would be
at 35%, same for apache.
I don't claim these numbers are accurate; it's probably more interesting to
compare Gnome vs. KDE and similar things. The total number of submissions
(represented by bash in this graph) shows that Debian is quite healthy.
Oh, and of course I'd like to invite you to install