The following bug has been logged online:
Bug reference: 1763
Logged by: Sham Rao
Email address: sham@styk.net
PostgreSQL version: 8.0.3
Operating system: SuSe Linux 9.3
Description: PAM Authentication not working...
Details:
No matter what configuration I use I cannot get postgres to authenticate a
user with pam.
The following are the relevent lines of my configuration.
/etc/pam.d/postgresql
#%PAM-1.0
auth required pam_permit.so
auth required pam_warn.so
==> /var/log/messages <==
Jul 11 22:02:16 custodian PAM-warn[26850]: function=[pam_sm_authenticate]
service=[postgresql] terminal=[<unknown>] user=[sham] ruser=[<unknown>]
rhost=[<unknown>]
Jul 11 22:02:16 custodian PAM-warn[26850]: function=[pam_sm_acct_mgmt]
service=[postgresql] terminal=[<unknown>] user=[sham] ruser=[<unknown>]
rhost=[<unknown>]
==> /var/log/postgresql <==
LOG: pam_acct_mgmt failed: User account has expired
FATAL: PAM authentication failed for user "sham"
