Problem with pg_hba.conf - Mailing list pgsql-general

From Sumit Rohatgi
Subject Problem with pg_hba.conf
Date
Msg-id 20050301130556.39334.qmail@web90208.mail.scd.yahoo.com
Whole thread Raw
Responses Re: Problem with pg_hba.conf  (Richard Huxton <dev@archonet.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Frank van Vugt
Date:
Subject: Re: invalid multibyte character for locale
Next
From: Marco Colombo
Date:
Subject: Re: Clay Shirky observation regarding MySQL