Problems installing PySQLite, SQLite and Trac

[Jon Clements]

On 1 Feb, 15:48, kimwlias <kimwl... at gmail.com> wrote:
> My initial goal is to finally install Trac. This is the second day
> I've been trying to make this possible but I can't find, for the life
> of me, how to do this. OK, here is the story:
>
> My system is a VPS with CentOS 5.
>
> I found out that I have two versions of python: 2.4 at /usr/bin/
> python2.4 and 2.5.2 at /usr/local/apps/python/bin/python2.5
>
> My first try was to download the SQLite amalgamation, './configure',
> 'make' and 'make install'. Then I downloaded the PySQLite and 'python
> setup.py install'. The funny part is that python2.4 has sqlite while
> python2.5 doesn't:
>
>     [root at xxx]# python
>     Python 2.5.2 (r252:60911, May 10 2008, 17:42:40)
>     [GCC 4.1.2 20070626 (Red Hat 4.1.2-14)] on linux2
>     Type "help", "copyright", "credits" or "license" for more
> information.
>     >>> import sqlite
>     Traceback (most recent call last):
>     File "", line 1, in
>     ImportError: No module named sqlite
>
>     [root at xxx]# python2.4
>     Python 2.4.3 (#1, Mar 14 2007, 18:51:08)
>     [GCC 4.1.1 20070105 (Red Hat 4.1.1-52)] on linux2
>     Type "help", "copyright", "credits" or "license" for more
> information.
>     >>> import sqlite
>     >>>
>
> After some more research I found out that the amalgamation is not the
> default way and I needed to run the extended_setup.py which isn't
> inside the pysqlite! ->http://oss.itsystementwicklung.de/trac/pysqlite/wiki/PysqliteAmalgama...
>
> I then thought, "OK, let's install the SQLite from the precompiled
> binary packages". So I downloaded the first two packages from here:http://www.sqlite.org/download.html. The one contains a .bin file and
> the other an .so file. I must admit, I'm relatively new in Linux so I
> don't know what do with these files. And there is NO DOCUMENTATION
> what so ever on how to use these two in the SQLite website. Not even a
> slight hint where to look for. The so called documentation is just a
> download version of the website....
>
> You can find some more information about my problem here:http://stackoverflow.com/questions/500055/issues-installing-sqlite-py...
>
> I really really really need your help. Thank you so much in advance.

IIRC, pysqlite was a wrapper for the SQLite library. However, in
version 2.5+ of Python, it's part of the standard distribution and is
in the module called sqlite3. Just walking throuh the instructions
(although I only have 2.5.2 installed gives me this):

Python 2.5.2 (r252:60911, Oct  5 2008, 19:24:49)
[GCC 4.3.2] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
>>> import pysqlite2


Are you trying to set up using 2.4 or 2.5? I'm just a little confused
as to why if sqlite works on 2.4 which looking at the installation
instruction [ref: http://www.installationwiki.org/Installing_Trac_and_Subversion#Python]
is what's recommended, is what the problem is?

As you're under a redhat derivative, perhaps it might be worth just
getting the rpm(s) for pysqlite2 and that might well sort it out for
you.

Sorry to have not been of more help,

Jon.