postgres connection problem via python pg DBI

Started by Dan Jooalmost 18 years ago2 messagesgeneral
Jump to latest
#1Dan Joo
djoo@agraquest.com

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!

#2Dan Joo
djoo@agraquest.com
In reply to: Dan Joo (#1)
Re: postgres connection problem via python pg DBI

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!