Re: PostgreSQL/PAM problem - Mailing list pgsql-admin

From Scott Mead
Subject Re: PostgreSQL/PAM problem
Date
Msg-id d3ab2ec80907150817g19eb3589yc8685b89cdbbbe5a@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL/PAM problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin



On Wed, Jul 15, 2009 at 2:39 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Thomas Kirchtag <tkircht@gmail.com> writes:
> 2009-07-08 21:28:06 CEST LOG:  00000: pam_authenticate failed: Permission
> denied
> 2009-07-08 21:28:06 CEST LOCATION:  CheckPAMAuth, auth.c:1345

> This suggests some problems accessing some pam-related file but I cannot
> imagine which one?

Yeah, I'd guess the same.  Perhaps strace would help determine which
file is inaccessible.

  IIRC, you can only use PAM to authenticate against external services (i.e. LDAP / A.D. users).  I *think* that in order to auth against local accounts, you need to be have a UID=0, which, PG does not.

--Scott

pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Difficulty with make check
Next
From: Chander Ganesan
Date:
Subject: Re: Flush Shared Buffer Cache