Thread: postgres connection problem via python pg DBI
Hi all,
I have a problem connecting to postgres via the python pg module ONLY from the cgi-scripts.
The command is:
db=pg.connect('aqdev','localhost',5432,None,None,'postgres',None)
From the commandline the connection works great, but from a cgi-script it barfs with the following message:
InternalError: could not create socket: Permission denied
Does anyone have any idea how I can get around this issue?
Thanks a bunch!
Just solved it.
For others, here is the solution.
setsebool -P httpd_can_network_connect_db 1
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Dan Joo
Sent: Thursday, June 05, 2008 4:18 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] postgres connection problem via python pg DBI
Hi all,
I have a problem connecting to postgres via the python pg module ONLY from the cgi-scripts.
The command is:
db=pg.connect('aqdev','localhost',5432,None,None,'postgres',None)
From the commandline the connection works great, but from a cgi-script it barfs with the following message:
InternalError: could not create socket: Permission denied
Does anyone have any idea how I can get around this issue?
Thanks a bunch!
Dan Joo wrote:
> db=pg.connect('aqdev','localhost',5432,None,None,'postgres',None)
>
> From the commandline the connection works great, but from a
> cgi-script it barfs with the following message:
>
> *InternalError*: could not create socket: Permission denied
My (obvious, granted) guess is that you're running it from the command
line as your own user, but the web server is running under another user
who doesn't have the proper permissions (or ident response) to access
the database.
Colin