$dbh = DBI->connect("dbi:Pg:dbname=$dbname;host=${dbserver};port=$dbport;", $dbuser, $dbpasswd) or
errexit( "Unable to connect to dbname $dbname, err: $DBI::errstr");
The exact same connection string works fine in a standalone perl program.errexit( "Unable to connect to dbname $dbname, err: $DBI::errstr");
Susan
On Thu, Jan 23, 2014 at 3:08 PM, Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote:
On 01/23/2014 02:55 PM, Susan Cassidy wrote:
I'm having a problem connecting to postgres via a CGI program. I can
connect just fine using the same connect string in a non-cgi perl
program as in the perl cgi program. The error I get is this:
ERROR: Unable to connect to dbname testdb2, err: could not
connect to server: Permission denied
Is the server running on host "jacensolo.red.dsic.com
<http://jacensolo.red.dsic.com>" (192.168.10.16) and accepting
TCP/IP connections on port 5432?
FYI, in the future you might want to anonymize your host information. For example xxx.yyy.zzz.com
Well from the above it looks like you where trying to connect using TCP/IP not a socket.
What is your connection string?
I tried adding postgres to the apache user's groups, because I saw
something on google that said that that is needed for the socket
connection to work, but it didn't help.
I just tried stopping and restarting apache, and when I try to start I
get this:
apachectl start
(13)Permission denied: make_sock: could not bind to address [::]:80
(13)Permission denied: make_sock: could not bind to address 0.0.0.0:80
<http://0.0.0.0:80>
no listening sockets available, shutting down
Unable to open logs
I took away the group permission for postgres, just in case that had
messed up something, but it didn't help. Now I can't even start apache.
To me it looks like it is already running.
Susan
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
