In Re:

I tried setting up a workingenv for playing with SQLAlchemy today but I ran into a number of problems. First, since I had installed pysqlite2 via Synaptix, easy_install was not finding the package. So I had to uninstall the pysqlite2 that I had installed with Synaptix and then install with easy_setup.

However, there is a bug for pysqlite on cheeseshop and no download is listed. So after inquiring on the TG mailing list, I tried:
easy_install -f http://initd.org/pub/software/pysqlite/releases/2.3/2.3.2/ pysqlite

but that failed because it couldn’t find the sqlite headers.
In file included from src/module.c:24:
src/connection.h:33:21: error: sqlite3.h: No such file or directory
...
error: Setup script exited with error: command 'gcc' failed with exit status 1

So I installed the libsqlite3-dev package via Synaptix — and finally all was right with the world.

I couldn’t get pysqlite to install fully into the workingenv, so I had to install it on the base system and then when I issued the
easy_install -f http://initd.org/pub/software/pysqlite/releases/2.3/2.3.2/ pysqlite
in the workingenv a proper entry was made pointing back to the package in site-packages
Adding pysqlite 2.3.2 to easy-install.pth file
Using /usr/lib/python2.4/site-packages/pysqlite-2.3.2-py2.4-linux-i686.egg

This entry was posted on Friday, January 5th, 2007 at 9:48 pm and is filed under Python, TurboGears, Ubuntu, workingenv. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.