OK .. i just read the rest of your email .. which answers my questions .. :) LDB Andrei Verovski (aka MacGuru) wrote:
Hi,
I have PostgreSQL 8.0.3 installed on SuSE 9.3 box along with Apache 2, PHP 5.0.3-14.5 and latest phpPgAdmin 3.5.5. Several months ago I had working setup, but since then my system have been patched with latest RPMs, and old PostgreSQL databases and setup files have been deleted and re-initialized from scratch.
And now I have a problem: whenever I am trying to connect to PostgreSQL 8 with phpPgAdmin, I get this error (even ith ¨extended login¨ option in phpPgAdmin set to false).
from PostgreSQL 8 log: LOG: database system is ready LOG: could not connect to Ident server at address "127.0.0.1", port 113: Connection refused FATAL: Ident authentication failed for user "postgres"
adodb error message: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: FATAL: Ident authentication failed for user "postgres" in /home/andrei/public_html/tools/phpPgAdmin/libraries/adodb/drivers/adodb-postgres64.inc.php on line 404
This is strange because by default PostgreSQL 8 seem to allow password-less connection from localhost. Additionally, what does it have to do with port 113? Config file specifies port 5432.
Additionally,I have changed
Anyone have an idea how to fix this?
Thanks in advance for any suggestion(s).
************************************************ *** with best regards *** Andrei Verovski (aka MacGuru) *** Mac, Linux, DTP, Programming Web Site *** *** http://snow.prohosting.com/guru4mac/ ************************************************