Hi Graham, Can you elaborate more on this... Based on the Django project i have created, in the settings for the Oracle DB i have provided the user (db schema) the application should use to connect to the db.
I have not changed anything since i migrated the project to the new infrastructure and the project was working fine before. I am on the same machine i just installed everything again basically.. I know that somewhere there is an exception occurring, but the problem is that it is never caught and printed in the logs.... As you can see in the logs the only errors are when it tries to close the connection and most probably never finds one.. either because it was never created or it is closed before everything else is executed. I want to find a way to debug this ... Is there a way to trace each call and every step so i can place some sort of print to see where the code is not working ... Because i do not know any other way to fix this. I another problem i had, you were the one that suggested something that relieved the actual problem and i was able to fix it, because before that the only errors in the logs i was seeing were not relevant to the problem. Thanks On Thursday, February 26, 2015 at 11:42:26 AM UTC+2, Graham Dumpleton wrote: > > 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] <javascript:> 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] <javascript:>. > To post to this group, send email to [email protected] <javascript:> > . > 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.
