Hi Andreas, I did the following test... i used "python manage.py runserver" and i was able to use the admin page (http://127.0.0.1:8000/admin/) of Django and log into the DB.
So that means the apache and the mod_wsgi as you said have a problem, correct ??? Regars, Alex On Tuesday, February 24, 2015 at 6:05:14 PM UTC+2, Andréas Kühne wrote: > > The file you wrote connects to the database itself, it doesn't use djangos > connection, so the only thing you are testing is if you can connect to the > database. And that we know (because you are able to do it with ./manage.py > dbshell). What you need to check is if the settings.py file used by django > is correctly interpreted by mod_wsgi. > > Because you are bepassing all of that, your test file will work and just > connects to the database. > > As I said earlier, make sure that your mod_wsgi is configured correctly > and that it can read your settings file. > > Regards, > > Andréas > > 2015-02-24 16:19 GMT+01:00 <[email protected] <javascript:>>: > >> Well i have created the below test script to check if i am able to >> connect to the DB using mod_wsgi and i get back the sysdate from the DB.. I >> have configured mod_wsgi under the alias /test to execute the below script >> and i always get the time.. So it seems that the configuration in mod_wsgi >> is correct >> ------------------------ >> import os,sys >> >> import cx_Oracle >> >> >> con = cx_Oracle.connect("username/password@DB") >> print('DATABASE VERSION: ' + con.version) >> print '' >> >> time= con.cursor() >> time.execute("SELECT TO_CHAR (SYSDATE, 'MM-DD-YYYY HH24:MI:SS') FROM >> DUAL") >> >> for t in time: >> print t >> >> con.close() >> >> def application(environ, start_response): >> status = '200 OK' >> output = 'Hello World! \r\r' >> output += str(t) >> #print sys.stderr >> >> response_headers = [('Content-type', 'text/plain'), >> ('Content-Length', str(len(output)))] >> >> start_response(status, response_headers) >> >> return [output] >> >> >> ----------------------------- >> >> >> On Tuesday, February 24, 2015 at 4:21:01 PM UTC+2, Andréas Kühne wrote: >>> >>> 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 <[email protected]>: >>> >>>> 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 <[email protected]>: >>>>> >>>>>> 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 <[email protected]>: >>>>>>> >>>>>>>> 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/d >>>>>>>> ispatch/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/d >>>>>>>> b/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 [email protected]. >>>>>>>> To post to this group, send email to [email protected]. >>>>>>>> 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%40googlegroups.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 [email protected]. >>>>>> To post to this group, send email to [email protected]. >>>>>> 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%40goog >>>>>> legroups.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 [email protected]. >>>> To post to this group, send email to [email protected]. >>>> 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 [email protected] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> 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/e3b9bb59-d753-4b6f-9e13-6bbcb72f1ef8%40googlegroups.com >> >> <https://groups.google.com/d/msgid/django-users/e3b9bb59-d753-4b6f-9e13-6bbcb72f1ef8%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 [email protected]. To post to this group, send email to [email protected]. 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/f63dc944-ef4a-4cd2-93cd-31bcfb2237fb%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
