2006/7/3, Clodoaldo Pinto <[EMAIL PROTECTED]>:
php can't connect to postgresql server
php error log message:
PHP Warning: pg_connect() [<a
href='function.pg-connect'>function.pg-connect</a>]: Unable to connect
to PostgreSQL server: could not connect to server: Permission
denied\n\tIs the server running on host "127.0.0.1" and
accepting\n\tTCP/IP connections on port 5432?
php connection string:
$conn_string = "hostaddr=127.0.0.1 port=5432 dbname=dbname
user=username password=password";
Also tried host=localhost
pg_hba:
host dbname username 127.0.0.1/32 md5
I can connect as that user with psql:
$ psql -h localhost -U username dbname
Password for user username:
Welcome to psql 8.1.4, the PostgreSQL interactive terminal.
This same setup works in another server running 8.0. Differences:
old server | new server
FC3 | FC5
php 4.3.11 | php 5.1.4
httpd 2.0 | httpd 2.2
What else should I check? I am out of ideas.
The same script running from another server can connect to the new
server using this pg_hba entry:
host dbname usename xx.xx.xxx.xx/32 md5
Clodoaldo
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
