sqlite.so cannot be opened on RHEL 4

[klaus@…]

Hi, I followed the instructions on ​http://trac.edgewall.org/wiki/TracOnRhel4, and it installed sqlite-2.8.16, python-sqlite-1.0.1, on python 2.3.4, and Trac 0.10.

However, when running the "trac-admin … initenv", it complains about not being able to find sqlite.

When I try to import sqlite, I get an error although it seems to be installed:

% python
Python 2.3.4 (#1, Feb  6 2006, 10:38:45) 
[GCC 3.4.5 20051201 (Red Hat 3.4.5-2)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite;
Traceback (most recent call last):
  File "<stdin>", line 1, in ?
  File "/usr/lib/python2.3/site-packages/sqlite/__init__.py", line 1, in ?
    import _sqlite
ImportError: /usr/lib/python2.3/site-packages/_sqlite.so: cannot open shared object file: No such file or directory
>>> 

The file "_sqlite.so" is actually there:

% ls -l /usr/lib/python2.3/site-packages/*sql*
-rwxr-xr-x  1 root root 60610 Jan  9  2006 /usr/lib/python2.3/site-packages/_sqlite.so

/usr/lib/python2.3/site-packages/sqlite:
total 80
-rw-r--r--  1 root root  2304 Oct 21  2004 __init__.py
-rw-r--r--  1 root root  2417 Jan  9  2006 __init__.pyc
-rw-r--r--  1 root root  2417 Jan  9  2006 __init__.pyo
-rw-r--r--  1 root root 17418 Oct 21  2004 main.py
-rw-r--r--  1 root root 24281 Jan  9  2006 main.pyc
-rw-r--r--  1 root root 24281 Jan  9  2006 main.pyo

Any idea on how to get it working?

[Christian Boos]

Any idea on how to get it working?

yes… start by following the instructions in TracInstall and only if that's not enough consult the specific instructions you could find in the various TracInstallPlatforms wiki pages, keeping in mind that they are quite probably out-of-date, most of them are about Trac 0.9 and I'm sure you can still find instructions about how to install Trac 0.8 ;)

It could be a good idea to add a few warnings here and there.

In your specific case, sqlite-2.8.16 and python-sqlite-1.0.1 are not the recommended versions of SQLite for Trac 0.10: you should rather install SQLite 3.3.7 or newer, and PySqlite 2.3.2.

If you still have installation issues after that, please ask for help on the MailingList or on the IrcChannel, as we prefer to keep tickets for development issues.