From: | "Michael W(dot) Lucas" <mwlucas(at)blackhelicopters(dot)org> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | PAM auth? |
Date: | 2012-06-07 19:03:17 |
Message-ID: | 20120607190316.GA30428@bewilderbeast.blackhelicopters.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
I'm running 9.1.2 on FreeBSD 9, installed via OS vendor package, and
trying to get PAM auth to work.
From what I've read, this should be as simple as the following
/usr/local/share/postgres/pg_hba.conf:
host all all 0.0.0.0/0 pam postgresql
local all all 0.0.0.0/0 pam postgresql
(I'm using my firewall for access control.)
After restarting postgresql, users are still not being prompted for
passwords. Here's my /usr/local/etc/pam.d/postgresql file:
auth sufficient /usr/local/lib/pam_ldap.so no_warn
auth required pam_unix.so no_warn try_first_pass nullok
account include system
session include system
password include system
Hoping to see some auth debugging, I set log_min_messages and
client_min_messages to debug5. Syslog sends local0 to
/var/log/postgres, but nothing on auth appears.
Any suggestions on how I can debug postgres authentication? Or am I
looking in the completely wrong place?
Thanks for any advice,
==ml
--
Michael W. Lucas
http://www.MichaelWLucas.com/, http://blather.MichaelWLucas.com/
Latest book: SSH Mastery http://www.michaelwlucas.com/nonfiction/ssh-mastery
mwlucas(at)BlackHelicopters(dot)org, Twitter @mwlauthor
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-06-07 19:17:19 | Re: PAM auth? |
Previous Message | James David Smith | 2012-06-07 14:27:07 | Re: Installing PostGIS 2.0 |