My Pylons application locally works running under mod_wsgi and Apache with Oracle on Windows. I created an egg for distribution and tested it on my local machine and all is running well still.
I moved my deployment over to my Linux machine and test the initial egg quickly under paster. All works well still. I make sure my ORACLE_HOME is set and being exported in the user environment that is running the Pylons application. Now I configure the wsgi part under Linux. mod_wsgi is installed and test scripts are working and a base QuickStart Pylons application loads up and works fine. But when I try to load my application it is acting as if it can't find the ORACLE_HOME. I've added a hard code to the config/environment.py to set it, I've also added the ORACLE_HOME to the .wsgi script using os.environ , I've added a PassEnv ORACLE_HOME in the Apache configuration and set it on the command line when starting Apache, yet the Pylons application under mod_wsgi still behaves as if it cannot find it. Below you can see the variable is set in the CGI environment , any help would be appreciated. Thanks. ERROR.LOG --------------------------------------- [Wed Feb 13 10:27:09 2008] [error] [client 10.1.5.52] CGI Variables [Wed Feb 13 10:27:09 2008] [error] [client 10.1.5.52] ------------- [Wed Feb 13 10:27:09 2008] [error] [client 10.1.5.52] DOCUMENT_ROOT: '/opt/env/apache2/htdocs' [Wed Feb 13 10:27:09 2008] [error] [client 10.1.5.52] GATEWAY_INTERFACE: 'CGI/1.1' [Wed Feb 13 10:27:09 2008] [error] [client 10.1.5.52] HTTP_ACCEPT: 'text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/ plain;q=0.8,image/png,*/*;q=0.5' [Wed Feb 13 10:27:09 2008] [error] [client 10.1.5.52] HTTP_ACCEPT_CHARSET: 'ISO-8859-1,utf-8;q=0.7,*;q=0.7' [Wed Feb 13 10:27:09 2008] [error] [client 10.1.5.52] HTTP_ACCEPT_ENCODING: 'gzip,deflate' [Wed Feb 13 10:27:09 2008] [error] [client 10.1.5.52] HTTP_ACCEPT_LANGUAGE: 'en-us,en;q=0.5' [Wed Feb 13 10:27:09 2008] [error] [client 10.1.5.52] HTTP_CONNECTION: 'keep-alive' [Wed Feb 13 10:27:09 2008] [error] [client 10.1.5.52] HTTP_HOST: 'thigdev01.thig.com' [Wed Feb 13 10:27:09 2008] [error] [client 10.1.5.52] HTTP_KEEP_ALIVE: '300' [Wed Feb 13 10:27:09 2008] [error] [client 10.1.5.52] HTTP_USER_AGENT: 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv: 1.8.1.12) Gecko/20080201 Firefox/2.0.0.12' [Wed Feb 13 10:27:09 2008] [error] [client 10.1.5.52] LD_LIBRARY_PATH: '/opt/env/apache2/lib:' [Wed Feb 13 10:27:09 2008] [error] [client 10.1.5.52] ORACLE_HOME: '/ u01/app/oracle/oracle/product/10.2.0/db_1' Python exception --------------------------------------------- DBAPIError: (RuntimeError) Unable to acquire Oracle environment handle None None --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/pylons-discuss?hl=en -~----------~----~----~----~------~----~------~--~---
