Re: Connecting PHP-based Application to Postgres-9.0.3

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



On April 7, 2011, Rich Shepard <rshepard@xxxxxxxxxxxxxxx> wrote:

> On Thu, 7 Apr 2011, Alan Hodgson wrote:

> > What does your pg_hba.conf file contain?

>

> Unmodified from the sample:

>

> # TYPE DATABASE USER CIDR-ADDRESS METHOD

>

> @remove-line-for-nolocal@# "local" is for Unix domain socket connections

> only

> @remove-line-for-nolocal@local all all

> # IPv4 local connections:

> host all all 127.0.0.1/32

> @authmethod@ # IPv6 local connections:

> host all all ::1/128

> @authmethod@

>

> Rich

What is @authmethod@? That looks like a substitution parameter from something?

The default that should be in there is I think ident, which probably allows you to access it as rshepard but not the web server to do so, which is running under a different user.

Try changing the auth method on 127.0.0.1/32 to trust (just for testing), and then if that works set it to md5 and assign a password.

--

The era of procrastination, of half-measures, of soothing and baffling expedients, of delays, is coming to a close. In its place we are entering a period of consequencesâ


[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux