Re: Postgres and PAM config issues

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