Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 549919FA2BA for ; Sun, 17 Dec 2006 19:58:04 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 32110-05 for ; Sun, 17 Dec 2006 19:57:57 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from worleyco.com (backupmail.worleyco.com [70.158.54.226]) by postgresql.org (Postfix) with ESMTP id AF89E9FA2D4 for ; Sun, 17 Dec 2006 19:57:57 -0400 (AST) Received: from [192.168.4.229] (unknown [192.168.4.229]) by worleyco.com (Postfix) with ESMTP id AD9E112A54C for ; Sun, 17 Dec 2006 17:57:57 -0600 (CST) Message-ID: <4585D94E.4090809@worleyco.com> Date: Sun, 17 Dec 2006 17:57:02 -0600 From: Derrick Stensrud User-Agent: Thunderbird 1.5.0.4 (X11/20060516) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: pam_ldap conversation error Content-Type: multipart/alternative; boundary="------------000603010409040305010806" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.238 tagged_above=0 required=5 tests=AWL, BAYES_50, HTML_30_40, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200612/242 X-Sequence-Number: 24034 This is a multi-part message in MIME format. --------------000603010409040305010806 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit I'm trying to setup postgresql to authenticate using pam_ldap against a windows 2003 Active Directory server. I have setup accounts on the Active directory and tested the authentication against it using services like local machine login and ssh logins and it authenticates properly. I edited the pg_hba.conf and added an entry for one of the users, like this: local all derrick3 pam postgres I have a file in /etc/pam.d/ called postgres and it looks like this: auth required /lib/security/pam_ldap.so account required /lib/security/pam_ldap.so I have logged into the template1 database and added the user derrick3. I then tried to run this: psql -U derrick3 -d template1 it prompts for a password and gives this error after I use the password I setup in Active Directory: psql: FATAL: PAM authentication failed for user "derrick3" if I look in postgresql.log I find this: LOG: pam_authenticate failed: Conversation error FATAL: PAM authentication failed for user "derrick3" LOG: could not send data to client: Broken pipe LOG: pam_authenticate failed: User not known to the underlying authentication module FATAL: PAM authentication failed for user "derrick3" Can anyone help put me on the right track? Thanks. --------------000603010409040305010806 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit I'm trying to setup postgresql to authenticate using pam_ldap against a windows 2003 Active Directory server.  I have setup accounts on the Active directory and tested the authentication against it using services like local machine login and ssh logins and it authenticates properly.  I edited the pg_hba.conf and added an entry for one of the users, like this:

local   all             derrick3                        pam postgres

I have a file in /etc/pam.d/ called postgres and it looks like this:

auth    required        /lib/security/pam_ldap.so
account required        /lib/security/pam_ldap.so


I have logged into the template1 database and added the user derrick3.  I then tried to run this:

psql -U derrick3 -d template1

it prompts for a password and gives this error after I use the password I setup in Active Directory:

psql: FATAL:  PAM authentication failed for user "derrick3"

if I look in postgresql.log I find this:

LOG:  pam_authenticate failed: Conversation error
FATAL:  PAM authentication failed for user "derrick3"
LOG:  could not send data to client: Broken pipe
LOG:  pam_authenticate failed: User not known to the underlying authentication module
FATAL:  PAM authentication failed for user "derrick3"


Can anyone help put me on the right track?  Thanks.
--------------000603010409040305010806--