Re: Postgres and PAM config issues

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: Marcin Porwit <mporwit(at)yahoo-inc(dot)com>
Subject: Re: Postgres and PAM config issues
Date: 2007-08-10 14:45:01
Message-ID: 46BC79ED.3030404@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Marcin Porwit napisal 2007-08-10 03:26:
> positionwhile[pg]% more /etc/pam.d/postgresql
> #%PAM-1.0
> auth required pam_stack.so service=system-auth
>
> The system is a CentOS 4.4 box, and I'm running PostgreSQL 8.0.6.
>
> However, when I try to get psql to do password authentication, I get the
> following:
> positionwhile[postgresql-8.0.13]% psql authtest
> Password:
> psql: FATAL: PAM authentication failed for user "mporwit"

Probably you are missing "account" section in your pam configuration.

Regards,
Tomasz Myrta

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Chris Hoover 2007-08-10 15:24:23 Easy way to change table schema?
Previous Message Witold Gołąb 2007-08-10 09:32:04 exclude logs of one database from log