X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D82DA3A4252 for ; Thu, 6 Jan 2005 09:53:21 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 16056-04 for ; Thu, 6 Jan 2005 09:53:02 +0000 (GMT) Received: from 9.hellooperator.net (cpc3-cdif2-3-0-cust202.cdif.cable.ntl.com [81.103.32.202]) by svr1.postgresql.org (Postfix) with ESMTP id 0485B3A3C5A for ; Thu, 6 Jan 2005 09:53:02 +0000 (GMT) Received: from rasputin by 9.hellooperator.net with local (Exim 4.43) id 1CmUKD-0002gc-VO for pgsql-admin@postgresql.org; Thu, 06 Jan 2005 09:53:01 +0000 Date: Thu, 6 Jan 2005 09:53:01 +0000 From: Dick Davies To: PostgreSQL Admin Subject: Re: postgresql 7.4.6 and pam_ldap Message-ID: <20050106095301.GH12003@lb.tenfour> Reply-To: Dick Davies References: <20050105164321.GA21400@volga.lan.cerma.archi.fr> <41DC5A19.9020506@kzsdabas.sulinet.hu> <20050106091901.GA15627@volga.lan.cerma.archi.fr> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20050106091901.GA15627@volga.lan.cerma.archi.fr> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.831 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, RCVD_IN_NJABL_DUL, RCVD_IN_SORBS_DUL X-Spam-Level: * X-Archive-Number: 200501/35 X-Sequence-Number: 15894 * Thomas Leduc [0130 09:30]: > Le 5 janvier 2005 ? 22:20, G?mes G?za a ?crit : > > $ cat /etc/pam.d/postgresql > auth required /lib/security//pam_ldap.so Stick a 'debug' after the .so there, see if anything else turns up. > $ cat pg_hba.conf > local all postgres ident sameuser > local all all pam > host all all 127.0.0.1/32 pam > host all all 192.168.10.0/24 pam > > $ sed '/^#/d;/^$/d' /etc/ldap.conf > host 192.168.10.2 > base ou=Users,dc=cerma,dc=archi,dc=fr > ssl no > pam_password md5 can you bind as the user with these settings? I't's probably morth ensuring you are looking for the right objectclass too, by explicityl setting in in /etc/ldap.conf . > # tail -f /var/log/postgresql > Jan 6 10:14:06 tage postgres[21450]: [1-1] TRACE: 00000: pam_authenticate a ?chou? : Conversation error > Jan 6 10:14:06 tage postgres[21450]: [1-2] EMPLACEMENT : CheckPAMAuth, auth.c:712 > Jan 6 10:14:06 tage postgres[21450]: [2-1] FATAL: 28000: PAM authentication ?chou?e pour l'utilisateur "leduc" > Jan 6 10:14:06 tage postgres[21450]: [2-2] EMPLACEMENT : auth_failed, auth.c:395 > Jan 6 10:14:06 tage postgres[21450]: [3-1] ERREUR: 08006: Impossible d'envoyer les donn?es du client : Relais bris? (pipe) > Jan 6 10:14:06 tage postgres[21450]: [3-2] EMPLACEMENT : internal_flush, pqcomm.c:1000 > Jan 6 10:14:09 tage postgres[21451]: [1-1] TRACE: 00000: pam_acct_mgmt a ?chou? : User account has expired > Jan 6 10:14:09 tage postgres[21451]: [1-2] EMPLACEMENT : CheckPAMAuth, auth.c:723 > Jan 6 10:14:09 tage postgres[21451]: [2-1] FATAL: 28000: PAM authentication ?chou?e pour l'utilisateur "leduc" > Jan 6 10:14:09 tage postgres[21451]: [2-2] EMPLACEMENT : auth_failed, auth.c:395 > > => "User account has expired" seems not to be true ! -- 'I should have been a plumber.' -- Albert Einstein Rasputin :: Jack of All Trades - Master of Nuns