Re: PostgreSQL/PAM problem

From: Scott Mead <scott(dot)lists(at)enterprisedb(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Thomas Kirchtag <tkircht(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: PostgreSQL/PAM problem
Date: 2009-07-15 15:17:28
Message-ID: d3ab2ec80907150817g19eb3589yc8685b89cdbbbe5a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Jul 15, 2009 at 2:39 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Thomas Kirchtag <tkircht(at)gmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Chander Ganesan 2009-07-15 15:18:22 Re: Flush Shared Buffer Cache
Previous Message Alvaro Herrera 2009-07-15 13:52:48 Re: Difficulty with make check