pdo_pgsql connection problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux