PHP with PostgreSQL - Pgsql-PHP connection problem

Author

Pgsql-PHP connection problem

Nirav Parikh

2005-09-27, 8:24 pm

Hi Everyone,

I have setup new server running on Fedora Core 4. I am having problem connecting Php to Postgresql database. Now I also got couple of old server running same thing. I can connect through one of the existing server to this Postgresql database on new server. But Can't connect locally.

This is the error message I get

"DB_Error Object ( & #91;error_message_pr
efix] => [mode] => 1 [level] => 1024 [code] => -24 [message] => DB Error: connect failed [userinfo] => & #91;nativecode=Warni
ng: pg_pconnect() [function.pg-pconnect]: Unable to connect to PostgreSQL server: could not connect to server: Permission denied Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432? in /usr/share/pear/DB/pgsql.php on line 124] ** pgsql........"

File settings:

Pg_hba.conf file settings:

local all all trust
host all all 127.0.0.1 255.255.255.255 trust

postgresql.conf file settings:

listen_addresses = '*'
port='5432'

Does anyone know how to resolve this?

Thanks in advance.

Regards,

Nirav

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.8/113 - Release Date: 27/09/2005

John DeSoi

2005-09-28, 3:25 am

On Sep 27, 2005, at 9:10 PM, Nirav Parikh wrote:

> I have setup new server running on Fedora Core 4. I am having
> problem connecting Php to Postgresql database. Now I also got
> couple of old server running same thing. I can connect through one
> of the existing server to this Postgresql database on new server.
> But Can't connect locally.

Have you verified it is specifically a PHP problem? Can you connect
with psql?

psql -h 127.0.0.1 dbname

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Sponsored Links