[mod_python] Problem getting my web app to work with remote oracle server

2008/4/16 wayne collier <Wayne.Collier at noaa.gov>:
>
>  I'm having a frustrating time getting my web app to connect with a remote
> oracle server.
>  However, from the linux prompt I am able to run oracle commands to connect
> to database.
>  The error message I get are as follows:
>
>  Mod_python error: "PythonHandler mod_python.psp" Traceback (most recent
> call last):
>
>  File "apache.py", line 299, in HandlerDispatch result = object(req)
>  File "/usr/local/lib/python2.4/site-packages/mod_python/psp.py", line 302,
> in handler p.run()
>  File "/usr/local/lib/python2.4/site-packages/mod_python/psp.py", line 213,
> in run exec code in global_scope
>  File "/var/www/html/psp/modinfo.psp", line 58, in ? oracle =
> cx_Oracle.connect(myUid, myPwd, myDsn)
>
>  DatabaseError: ORA-12541: TNS:no listener
>
>  I suspect that it has something to do with the permission of the apache
> user defined in the httpd.conf file.
>  Also, I have set the ORACLE_HOME,LD_LIBRARY_PATH and TNS_ADMIN variable to
> load and be initialized on startup. But it does not work!!!

Exactly where have you set these?

Graham

>  Can someone help me with this?
>
>
>  Wayne
>
>
>
>
>  My set up is as follows:
>
>  PYTHON 2.4.4c1 (#1, Nov 6 2006, 14:14:48)
>  operating system  [GCC 3.4.6 20060404 (Red Hat 3.4.6-3)]
>   MOD_PYTHON 3.2.10
>  Apache version 2.0.52
>
>
>
> _______________________________________________
>  Mod_python mailing list
>  Mod_python at modpython.org
>  http://mailman.modpython.org/mailman/listinfo/mod_python
>
>