Problem with pg_hba.conf

From: Sumit Rohatgi <pgsql_backing(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Problem with pg_hba.conf
Date: 2005-03-01 13:05:55
Message-ID: 20050301130556.39334.qmail@web90208.mail.scd.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marco Colombo 2005-03-01 13:28:23 Re: Clay Shirky observation regarding MySQL
Previous Message Frank van Vugt 2005-03-01 12:00:55 Re: invalid multibyte character for locale