PAM auth?

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

Responses

Browse pgsql-novice by date

  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