Re: Pg_hba not using local setting - Mailing list pgsql-general

From James Hall
Subject Re: Pg_hba not using local setting
Date
Msg-id EE80A67DD80E304DA779C72BC9FA999604840933@ntmailo.dhcp.tandy.com
Whole thread Raw
In response to Pg_hba not using local setting  (James Hall <James.Hall@RadioShack.com>)
List pgsql-general
I thought I may be confused.

I am using RH 7.1(apache) and perl.

Thanks,
-jim


-----Original Message-----
From: Doug McNaught [mailto:doug@mcnaught.org]
Sent: Friday, March 14, 2003 12:49 PM
To: James Hall
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Pg_hba not using local setting


James Hall <James.Hall@RadioShack.com> writes:

> Thanks for your response.
>
> I changed pg_hba.conf to include the server ip address as shown below:
> ---
> Local        all        trust
> Host        all        123.456.789.10        255.255.255.0
> password
> ---
>
> But still have the same result (users can login with any password if
> local is set to trust). The web server is on the same machine as the
> database, no java used.
>
> Did I misunderstand your comment regarding telling the webserver to
> connect using an IP address?

Yes.

You need to set the webapp's database config to make it connect to an IP
address instead of using the Unix socket (which it does by default for
same-machine connections).  I can't tell you how to do this because you
haven't said what language/app server you're using for the website.

-Doug

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: The folding of unquoted names to lower case in PostgreSQL
Next
From: Rob Storrs
Date:
Subject: Scope Problem with Execute?