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@BlackHelicopters.org, Twitter @mwlauthor