Thread: Problem with pg_hba.conf

Problem with pg_hba.conf

From
celerity12
Date:
Please disregard my previous mail ....

 In the pg_hba.conf file, I have the following entry:

 host    db1    client1    192.168.150.234/32    md5

 Now the problem is:
    The client having IP 192.168.150.234 is trying to
 use phpPgAdmin, but is unable to connect.

 The corresponding config.inc.php has this entry:
 $conf['servers'][0]['desc'] = 'PostgreSQL';
 $conf['servers'][0]['host'] = '192.168.150.245';

Please disregard my previous mail ....
Thank you
celerity

________________________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html

Re: Problem with pg_hba.conf

From
Richard Huxton
Date:
celerity12 wrote:
> Please disregard my previous mail ....
>
>  In the pg_hba.conf file, I have the following entry:
>
>  host    db1    client1    192.168.150.234/32    md5
>
>  Now the problem is:
>     The client having IP 192.168.150.234 is trying to
>  use phpPgAdmin, but is unable to connect.

Make sure connection logging is turned on in your postgresql.conf file,
and let us know what that says.

--
   Richard Huxton
   Archonet Ltd

Re: Problem with pg_hba.conf

From
Richard Huxton
Date:
Don't forget to cc the list.

celerity12 wrote:
> I turned on the connection logging:
>
> Server IP  is 192.168.160.213
>
> Client IP  is 192.168.160.212
>
> Its generating the entry for client in the log file
> but the IP of client is different( .212 not .213 ...
> .213 is server's IP)
>
> Getting this message:

> 2005-03-01 20:51:36 LOG:  connection received:
> host=192.168.160.213 port=3150
> 2005-03-01 20:51:36 FATAL:  no pg_hba.conf entry for
> host "192.168.160.213", user "postgres_db", database
> "template1"

It's not likely to be lying - you're getting the connection from
192.168.160.213 - now you need to find out why.

Have you got a firewall redirecting connections?

Are you running some sort of connection proxy?

--
   Richard Huxton
   Archonet Ltd