[Tutor] Python2.3.4, PySqlite2 and Solaris

[Luis N]

Hi,

After fighting with installing pysqlite2, (although you require the
.tar.gz for a *Nix build, the header file required, sqlite3.h, was
actually in the source .zip supplied for windows users sans a unix
build environment)

Anyway, I have pysqlite2, but:

Python 2.3.4 (#1, Aug 23 2004, 13:59:34)
[GCC 3.2.3] on sunos5
Type "help", "copyright", "credits" or "license" for more information.
>>> from pysqlite2 import dbapi2 as sqlite
Traceback (most recent call last):
  File "<stdin>", line 1, in ?
  File "/home/rbnewby/lib/python/pysqlite2/dbapi2.py", line 32, in ?
    from pysqlite2._sqlite import *
ImportError: ld.so.1: python: fatal: relocation error: file
/home/NaN/lib/python/pysqlite2/_sqlite.so: symbol sqlite3_libversion:
referenced symbol not found

However,

bash-2.05$ ldd -s _sqlite.so

   find object=libsqlite.so.0; required by ./_sqlite.so
    search path=/usr/openwin/lib  (LD_LIBRARY_PATH)
    trying path=/usr/openwin/lib/libsqlite.so.0
    search path=/home/NaN/lib  (RPATH from file ./_sqlite.so)
    trying path=/home/NaN/lib/libsqlite.so.0
        libsqlite.so.0 =>        /home/NaN/lib/libsqlite.so.0

I'm a little confused why a python process wouldn't also be able to
find the required library.

Any insights about what's happening would be appreciated.

Luis