Hmmm You can use ./manage.py dbshell, so your configuration is correct in THAT case, however, have you set all the variables correctly for django when running apache + mod_wsgi? Has the connection ever worked there?
What do the config files for mod_wsgi look like and are all of the paths correctly set in the mod_wsgi script? I'm just guessing now, but I think that the problem is your mod_wsgi setup. Regards, Andréas 2015-02-24 14:17 GMT+01:00 <alexandrosstyliano...@gmail.com>: > Is there any way to find out where the problem occurs ?? Is there a way to > enable some debugging or trace in order to see which python scripts are > called in Django and find out where the whole process is failing ?? > > In the last lines of the stack trace it tries to close the connection and > for some reason it fails... is it because the connection was never created > ?? or it was closed before the application was ready to send data.. ??? > > Can anyone help ???? > > On Tuesday, February 24, 2015 at 2:08:53 PM UTC+2, Andréas Kühne wrote: >> >> The reason I asked this is because that means that your connection >> parameters are correct, so it should work? >> >> Sorry I don't know what to do to help you more. >> >> Regards, >> >> Andréas >> >> 2015-02-24 12:49 GMT+01:00 <alexandros...@gmail.com>: >> >>> Hi Andreas, >>> >>> I can connect using "python manage.py dbshell" it connects without any >>> error. >>> >>> Is there a difference, if i am not mistaken the dbshell test shows that >>> the configuration of the DB is correct and that i can connect from the >>> machine, correct ?? From the stack trace it seems that the real issue is >>> not returned and the only thing i get is the "NOT CONNECTED TO ORACLE" error >>> >>> >>> Regards, >>> Alex >>> >>> On Friday, February 20, 2015 at 7:12:05 PM UTC+2, Andréas Kühne wrote: >>>> >>>> >>>> 2015-02-20 17:18 GMT+01:00 <alexandros...@gmail.com>: >>>> >>>>> 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 and i am getting the below exception >>>>> that seems to be from Django and i need help pin pointing the exact cause, >>>>> because i think that the actual exception is never caught and returned to >>>>> the log and all i am getting is the OperationalError: ORA-03114: not >>>>> connected to ORACLE. I checked the Oracle DB and i can connect to it. >>>>> >>>>> [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] >>>>> >>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "Django users" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to django-users...@googlegroups.com. >>>>> To post to this group, send email to django...@googlegroups.com. >>>>> Visit this group at http://groups.google.com/group/django-users. >>>>> To view this discussion on the web visit https://groups.google.com/d/ >>>>> msgid/django-users/88d2de85-f330-4c35-9818-9c19addcc1cf%40goog >>>>> legroups.com >>>>> <https://groups.google.com/d/msgid/django-users/88d2de85-f330-4c35-9818-9c19addcc1cf%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> >>>> What happens if you try to do "python manage.py dbshell"? Are you able >>>> to connect to the database then? >>>> >>>> Regards, >>>> >>>> Andréas >>>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Django users" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to django-users...@googlegroups.com. >>> To post to this group, send email to django...@googlegroups.com. >>> Visit this group at http://groups.google.com/group/django-users. >>> To view this discussion on the web visit https://groups.google.com/d/ >>> msgid/django-users/71056041-36f4-4392-9303-4775dc80a510% >>> 40googlegroups.com >>> <https://groups.google.com/d/msgid/django-users/71056041-36f4-4392-9303-4775dc80a510%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to django-users+unsubscr...@googlegroups.com. > To post to this group, send email to django-users@googlegroups.com. > Visit this group at http://groups.google.com/group/django-users. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/8169e731-f541-4694-be17-c170b9effafe%40googlegroups.com > <https://groups.google.com/d/msgid/django-users/8169e731-f541-4694-be17-c170b9effafe%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at http://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CALXYUbnZ3McCgmjp5PoLbEOHKNpTN7fa_WvUF66NseEVXEmN%3Dw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
