|
Graham Dumpleton
graham.dumpleton at gmail.com
Wed Apr 30 02:05:14 EDT 2008
2008/4/30 Graham Dumpleton <graham.dumpleton at gmail.com>: > 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 One hopes then that you always use init.d scripts to stop and start it then, as using apachectl directly will not pick up those entries. Next thing is, have you tried running your Python script from command line but as user that Apache runs as rather than yourself. Code in mod_python will run as that Apache user and so if it can't read files in Oracle installation area, or that user otherwise doesn't have permission to connect to Oracle in some way, you will have problems. Graham > > > > > > > > > > > > > > > > > > > > > > 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 > > > > > > > > >
|