Mailinglist Archive: opensuse (4398 mails)

[Lawrence Bowie <thesource@xxxxxxxxxxx>]

I am going to startoff with the basics:

1) Can you ping this address?

2) If you can ping, then can you telnet to 5432, 'telnet 127.0.0.1 5432'

Let us know ...

Thanks,

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/
> ************************************************
>