2006/7/3, Clodoaldo Pinto <clodoaldo.pinto@xxxxxxxxx>:
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
