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

Please keep replies on list, have bounced this back to list so all can
see and perhaps comment.

2008/4/30 wayne collier <Wayne.Collier at noaa.gov>:
>
>  Hi Graham. I set these in /etc/init.d/httpd file. I have following set :
>
>  export LD_LIBRARY_PATH=/u01/app/oracle/product/10.2.0/client_1/lib:
>  TNS_ADMIN=/u01/app/oracle/product/10.2.0/client_1/network/admin ; export
> TNS_ADMIN
>  ORACLE_HOME=/u01/app/oracle/product/10.2.0/client_1;  export ORACLE_HOME
>
>
>
>
>
>
>
>
>
>
>
>  Graham Dumpleton wrote:
>  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
>
>
>
>  _______________________________________________
> Mod_python mailing list
> Mod_python at modpython.org
> http://mailman.modpython.org/mailman/listinfo/mod_python
>
>
>
>