If Oracle is providing access based on the identity of the user connecting though local UNIX socket connection to the database, it could be failing because your application will be running as the Apache user and maybe you haven't configured Oracle to allow that user to connect.
Graham On 25/02/2015, at 10:09 PM, [email protected] wrote: > Hi, > > I migrated my project to a new infrastructure but i kept the same versions > Apache 2.2 + mod_wsgi + python 2.6.1 + Django 1.2.1 + ....... > > I am trying to run my project or even access the admin console of Django > /admin and i can not. > > I tried to connect directly from the Oracle Client (sqlplus) and i can, i > created a simple python script that uses cx_oracle and i am able to connect > to the database without any problems, i have tested "python manage.py > dbshell" and it connects. I also used "python manage.py runserver" and by > navigating to http://127.0.0.1:8000/admin i was able to access the console > without any errors, but when i try using apache + mod_wsgi i get the > following error: > > [Fri Feb 20 17:40:51 2015] [error] [client xx.xx.xx.xx] mod_wsgi (pid=27565): > Exception occurred processing WSGI script '/opt/wgt_proxy/wgtproxyProj/ > wgtproxy/apache/django.wsgi'. > [Fri Feb 20 17:40:51 2015] [error] [client xx.xx.xx.xx] Traceback (most > recent call last): > [Fri Feb 20 17:40:51 2015] [error] [client xx.xx.xx.xx] File > "/opt/wgt_proxy/wgtproxyProj/wgtproxy/apache/django.wsgi", line 50, in > __call__ > [Fri Feb 20 17:40:51 2015] [error] [client xx.xx.xx.xx] return > self.__application(environ, _start_response) > [Fri Feb 20 17:40:51 2015] [error] [client xx.xx.xx.xx] File > "/opt/webtier/python_64/lib/python2.6/site-packages/django/core/handlers/wsgi.py", > line 248, in __call__ > [Fri Feb 20 17:40:51 2015] [error] [client xx.xx.xx.xx] > signals.request_finished.send(sender=self.__class__) > [Fri Feb 20 17:40:51 2015] [error] [client xx.xx.xx.xx] File > "/opt/webtier/python_64/lib/python2.6/site-packages/django/dispatch/dispatcher.py", > line 162, in send > [Fri Feb 20 17:40:51 2015] [error] [client xx.xx.xx.xx] response = > receiver(signal=self, sender=sender, **named) > [Fri Feb 20 17:40:51 2015] [error] [client xx.xx.xx.xx] File > "/opt/webtier/python_64/lib/python2.6/site-packages/django/db/__init__.py", > line 82, in close_connection > [Fri Feb 20 17:40:51 2015] [error] [client xx.xx.xx.xx] conn.close() > [Fri Feb 20 17:40:51 2015] [error] [client xx.xx.xx.xx] File > "/opt/webtier/python_64/lib/python2.6/site-packages/django/db/backends/__init__.py", > line 70, in close > [Fri Feb 20 17:40:51 2015] [error] [client xx.xx.xx.xx] > self.connection.close() > [Fri Feb 20 17:40:51 2015] [error] [client xx.xx.xx.xx] OperationalError: > ORA-03114: not connected to ORACLE > [Fri Feb 20 17:40:51 2015] [error] [client xx.xx.xx.xx] > [Fri Feb 20 17:40:51 2015] [error] [client xx.xx.xx.xx] Request Failed for : > /wgtproxy/admin/, Resp Code : [500] > > Can anyone help me solve my issue? > > Thanks > > -- > You received this message because you are subscribed to the Google Groups > "modwsgi" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/modwsgi. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "modwsgi" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/modwsgi. For more options, visit https://groups.google.com/d/optout.
