[DB-SIG] DCOracle2 w/ apache + mod_python under rh7.2 ?

[Praveen Kumar]

Has anyone successfully used DCOracle2 w/ apache +
mod_python under rh7.2 ?

My system consists of rh7.2, apache1.3.26,
mod_python-2.7.8, python2.1.3, Oracle9i .

I see the following when my program accesses the
DCOracle2 module:

  File
"/usr/lib/python2.1/site-packages/DCOracle2/__init__.py",
line 37, in ?
    from DCOracle2 import   *

  File
"/usr/lib/python2.1/site-packages/DCOracle2/DCOracle2.py",
line 104, in ?
    import dco2

ImportError: libclntsh.so.9.0: cannot open shared
object file: No such file or directory



I've tried the following:

-----

Setting LD_LIBRARY_PATH from the same shell where I
start apache:

export LD_LIBRARY_PATH=/home/pk/OraHome1/lib

-----

Setting LD_LIBRARY_PATH to /home/pk/OraHome1/lib via
Apache's PassEnv and SetEnv directives.

-----

Placed libclntsh.so.9.0 in
/usr/lib/python2.1/site-packages/DCOracle2 ( same path
as dco2.so ).

-----

Added /home/pk/OraHome1/lib to /etc/ld.so.conf , and
executed /sbin/ldconfig as root.

-----

Tried adding each of:

os.putenv( 'LD_LIBRARY_PATH', '/home/pk/OraHome1/lib'
)

os.environ[ 'LD_LIBRARY_PATH' ] =
'/home/pk/OraHome1/lib'

in DCOracle2/DCOracle2.py before the "import dco2"
statement

-----

/home/pk/OraHome1/lib is readable by all ; but tried
the following anyway, to eliminate a permissions-issue
as the cause:

As root, copied /home/pk/OraHome1/lib to /oralib ;
tried all of the above, using /oralib

-----

"/home/pk/OraHome1/lib/libclntsh.so.9.0" exists, yet
none of these work. The DCOracle2 module works fine
when I use it from a standalone program. It would be
helpful to know if anyone has gotten this config to
work; also, any suggestions would be appreciated.

pk


__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com