Trac not working on Ubuntu Feisty x64 - solved

I've just finished upgrading a number of Trac installs from a Dapper machine to the latest Feisty. I was actually migrating them from Dapper x86 to Feisty x64 and ran into the following problems:

DatabaseError: file is encrypted or is not a database

This is due to the fact that the sqlite db's were originally created as sqlite2 and the version in Feisty compiled against python is for sqlite3.

The solution to this is to migrate the db's to sqlite3 with the following commands:

Note: you need to have sqlite and sqlite3 installed to do this.

ClearSilver not working with Python 2.5

Currently the Trac install for ubuntu on the x64 platform is not working - bug 86685.

This is fixed in clearsilver-10.4 but that is not in Ubuntu yet. To work around this I downloaded this fedora core RPM build of python-clearsilver

Once this was downloaded replace the python 2.5. copy of neo_cgi.so with the version in this rpm.

Note: This is far from the best way to do this - but it does work. And when an updated build of clearsilver is available in ubuntu it should overwrite the neo_cgi.so file with the correct one.