Thread: BUG #1763: PAM Authentication not working...
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"
On Tue, Jul 12, 2005 at 05:59:36AM +0100, Sham Rao wrote: > > 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. Note that you need the user to be created in PostgreSQL as well as your PAM system. However apparently your problem is something else: > ==> /var/log/postgresql <== > LOG: pam_acct_mgmt failed: User account has expired > FATAL: PAM authentication failed for user "sham" Maybe you need to give the user a newer, non-expired password. -- Alvaro Herrera (<alvherre[a]alvh.no-ip.org>) "Nadie esta tan esclavizado como el que se cree libre no siendolo" (Goethe)