Thread: Problem with pg_hba.conf

Problem with pg_hba.conf

From

Sumit Rohatgi

Date:

01 March 2005, 16:05:57

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.234';
$conf['servers'][0]['port'] = 5432;
$conf['servers'][0]['defaultdb'] = 'db';

----------------------------------------------------

If the entry is:
host db1 client1  192.168.150.234/0      md5

Then, any client (client with any IP address) can log
in as no MASK specified.

Thank you
celerity12

________________________________________________________________________
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:

01 March 2005, 16:47:23

Sumit Rohatgi wrote:
> 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.234';

You're trying to connect from/to the same IP address. Might it be using
the loopack (127.0.0.1) instead?

Try adding a definition for 127.0.0.1 and see how that goes.

--
   Richard Huxton
   Archonet Ltd