Re: Client Authentication

Stefan Sturm wrote:
> Hello,
>
> I set up a PostgreSQL 8.3.1 Server on my Webserver( located somewhere
> in the web ).
> On my local Server I use the trust method to access the server. But on
> my Webserver I want to use an user with password to access the Server.
> So I did the following:
>
> I created a user( as superuser ) with:
> createuser -P username
>
>
> Then I add a new line to the pg_hba.conf file:
> host    all         username      0.0.0.0
> <http://0.0.0.0>               md5
>
> I want to access all databases from all IP-Adresses with this user.
>
> But this fails :-(
>
> WHere is my Error? I hope some can help me.
try adding a subnet mask
   host all username 0.0.0.0  0.0.0.0 md5
or a cidr mask
   host all username 0.0.0.0/0 md5

klint.

--
Klint Gore
Database Manager
Sheep CRC
A.G.B.U.
University of New England
Armidale NSW 2350

Ph: 02 6773 3789
Fax: 02 6773 3266
EMail: kgore4@une.edu.au