Re: OperationalError: ORA-03114: not connected to ORACLE.

2015-02-25 Thread Andreas Kuhne
Hi Alex, Correct. There seems to be something wrong with the configuration of mod_wsgi, because you are able to connect via dbshell (which loads all of your environment variables and is able to connect). The same thing with runserver. Check for a good tutorial on how to configure apache + mod_wsg

Re: OperationalError: ORA-03114: not connected to ORACLE.

2015-02-25 Thread alexandrosstylianou88
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, Februa

Re: OperationalError: ORA-03114: not connected to ORACLE.

2015-02-24 Thread Andreas Kuhne
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

Re: OperationalError: ORA-03114: not connected to ORACLE.

2015-02-24 Thread alexandrosstylianou88
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

Re: OperationalError: ORA-03114: not connected to ORACLE.

2015-02-24 Thread Andreas Kuhne
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 correctl

Re: OperationalError: ORA-03114: not connected to ORACLE.

2015-02-24 Thread alexandrosstylianou88
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 s

Re: OperationalError: ORA-03114: not connected to ORACLE.

2015-02-24 Thread Andreas Kuhne
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 : > Hi Andreas, > > I can connect using "python manage.py dbshell" it connects without any >

Re: OperationalError: ORA-03114: not connected to ORACLE.

2015-02-24 Thread alexandrosstylianou88
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

Re: OperationalError: ORA-03114: not connected to ORACLE.

2015-02-20 Thread Andreas Kuhne
2015-02-20 17:18 GMT+01:00 : > 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