Dear all,
I'm running into a problem I just can't seem to get fixed. I've
searched a long time for this already but haven't found anything that
comes close to what I'm seeing.
I'm trying to connect (and later use) a postgres database through php,
using PDO.
The webserver is a recently set up server solely for testing, there is a
production server in place where everything works just fine.
The web server (test): (from phpinfo)
Linux hostname.domainname 2.6.25.11-97.fc9.x86_64 #1 SMP Mon Jul 21
01:09:10 EDT 2008 x86_64
Apache 2.0
PHP API 20041225
PHP Extension 20060613
PDO support enabled
PDO drivers pgsql, sqlite
PDO Driver for PostgreSQL enabled
PostgreSQL(libpq) Version 8.3.1
Module version 1.0.2
Revision $Id: pdo_pgsql.c,v 1.7.2.11.2.1 2007/01/01 09:36:05 sebastian
Exp $
The working production server is running on 32 bit, and the database
server is running fc9 x86_64 with postgres 8.3.5
The error I keep getting:
Connection failed to:pgsql:host=hostname.domainname port=5432;dbname=bla
user=username password=secret
SQLSTATE[08006] [7] could not connect to server: Permission denied\n\tIs
the server running on host "hostname.domainname" and accepting\n\tTCP/IP
connections on port 5432?
I can use psql to connect to this database and from what I've seen I'm
suspecting something wrong with pdo/pdo_pgsql or some config setting I
overlooked somewhere in apache/php.
Running tcpdump shows that nothing is even going out when trying the php
PDO connection.
Anything that can set me in the correct direction is greatly
appreciated.
kind regards,
Maarten
|