502 Gateway Error - when accessing postgresql database

Nanoq nginx-forum at forum.nginx.org
Wed Nov 16 02:49:54 UTC 2016


Hi I'm building a website with nginx, uwsgi and a postgresql database. When
I want to access the database with 

curl -i -X POST -H 'Content-Type: application/json' -d '{"username": "test",
"password": "test", "email":"test"}' xxx.xxx.xxx

I get the following error: HTTP/1.1 502 Bad Gateway

The nginx/access.log file tells me: "POST /main/newuser HTTP/1.1" 502 173
"-" "curl/7.35.0"
and the nginx/error.log file says: upstream prematurely closed connection
while reading response header from upstream
request: "POST /main/newuser HTTP/1.1", upstream:
"uwsgi://unix:/var/www/mysite2/mysite2.sock:"

Everything else, beside accessing the database seems to work. When I run the
my webserver on the localhost the connection with the database works.

Here my configuration files:

sites-enabled/project

upstream db {
    server xxx.xxx.xxx:5432;

}

server {
    listen 80;
    server_name xxx.xxx.xxx;

    location / {
        proxy_pass     http://db;
        proxy_redirect off;
        include uwsgi_params;
        uwsgi_pass unix:/var/www/mysite2/mysite2.sock;

}
}


the uwsgi.ini file;
[uwsgi]
module = wsgi

master = true
processes = 5

socket = mysite2.sock
chmod-socket = 660
vacuum = true

die-on-term = true

python-path = /var/www/mysite2

Thanks in advance for your help!

Posted at Nginx Forum: https://forum.nginx.org/read.php?2,270976,270976#msg-270976



More information about the nginx mailing list