Ok, we've found the problem: SELINUX for those of you who took the time reading my long question, thanks :) regards, Maarten On Tue, 2009-06-09 at 10:07 +0200, Maarten Foqué wrote: > 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 > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
