Page 1 of 1

Another PostgreSQL/PHP error

Posted: Mon Jul 22, 2002 7:33 am
by Love_Daddy
Hi again,

I've found another error::

No route to host Is the server running on host localhost and accepting TCP/IP connections
on port 5432 in /var/www/html/test.php on line
Connection Failed.

Posted: Mon Jul 22, 2002 8:49 am
by BDKR
Is the server running? Try this in a shell -> netstat -l
This will list all listening progs and the ports they are listening on.

Later on,
BDKR

Posted: Tue Jul 23, 2002 4:25 am
by haagen
If I'm not remebering wrong php connects through the tcp port (the error message idicates it too). Check your ph_hba.conf file, in debain i resides in /etc/postgres.

This file controles who and how who should be allowed to access the server. Check so there is a line looking like this:

Code: Select all

host         all         127.0.0.1     255.255.255.255   trust
This means that everyone (with a psql account) can connect from localhost.

Hope this helps!