Django 1.4 + Apache WebServer + Mysql and PostgreSQL Connection Error

Question

I have successfully followed the Django 1.4 Tutorial 1-4 (the poll system) and now its running until I deploy it in Apache Webserver 2.2 using Postgres Database. Everytime I access localhost I always have "Internal Server Error" but if I use MySQL as my database everything is ok. What do you think is wrong? Did I miss something to configure in Postgre?

Here is my database connection settings in Mysql(Working) and in Postgre(Not Working), both using Apache2.2 + mod_wsgi.so

//Postgre
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': 'django_demo1',                     
        'USER': 'postgres',
        'PASSWORD': 'mypassword', 
        'HOST': 'localhost',
        'PORT': '',       
    }
}

//MySQL
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'django_demo1',                     
        'USER': 'root',
        'PASSWORD': 'mypassword', 
        'HOST': 'localhost',
        'PORT': '',       
    }
}

Other INFO:

OS: windows 7, Python: 2.7, Django: 1.4, Postgre 9.1

what's the error message in the apache error log file? btw. enable DEBUG=True in your settings. — Pascal
– Pascal, Commented Jul 27, 2012 at 10:15
Check your webserver's logs if you need to know the details. We can just guess. Could be missing python dependencies for postgresql for example. — Torsten Engelbrecht
– Torsten Engelbrecht, Commented Jul 27, 2012 at 10:19
thank you guys. I have found psycopg2 is not found. that solves the problem. — rechie
– rechie, Commented Jul 27, 2012 at 10:23

Babu · Accepted Answer · 2012-07-27 10:18:42Z

1

If you are able to access MySQL but not Postgres, I guess psycopg2 which is the Postgres adapter for python is not installed. Install psycopg2 using pip.

pip install psycopg2

Here is the pypi.

answered Jul 27, 2012 at 10:18

Babu

2,6083 gold badges34 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

rechie Over a year ago

thanks babu! Yes, i just found out that psycopg2 is missing. After i installed, everything is ok.

Collectives™ on Stack Overflow

Django 1.4 + Apache WebServer + Mysql and PostgreSQL Connection Error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related