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 6B1A63A42F1 for ; Thu, 6 Jan 2005 09:19:28 +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 05558-07 for ; Thu, 6 Jan 2005 09:19:23 +0000 (GMT) Received: from email.nantes.archi.fr (email.nantes.archi.fr [194.199.216.5]) by svr1.postgresql.org (Postfix) with SMTP id CA2F63A4293 for ; Thu, 6 Jan 2005 09:19:21 +0000 (GMT) Received: from email (194.199.216.5) by EMAIL (MailMax 4. 8. 2. 1) with ESMTP id 28591776 for pgsql-admin@postgresql.org; Thu, 06 Jan 2005 10:14:19 +0100 RST Received: From nullclient ([193.49.56.2]) by email (WebShield SMTP v4.5 MR1a P0803.345); id 110500285993; Thu, 6 Jan 2005 10:14:19 +0100 Received: by nullclient (sSMTP sendmail emulation); Thu, 6 Jan 2005 10:19:01 +0100 Date: Thu, 6 Jan 2005 10:19:01 +0100 From: Thomas Leduc To: =?iso-8859-1?Q?G=E9mes_G=E9za?= Cc: pgsql-admin@postgresql.org Subject: Re: postgresql 7.4.6 and pam_ldap Message-ID: <20050106091901.GA15627@volga.lan.cerma.archi.fr> References: <20050105164321.GA21400@volga.lan.cerma.archi.fr> <41DC5A19.9020506@kzsdabas.sulinet.hu> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <41DC5A19.9020506@kzsdabas.sulinet.hu> User-Agent: Mutt/1.4i Organization: Laboratoire CERMA - UMR CNRS 1563 X-Address: Rue Massenet, BP 81931, F-44319 NANTES Cedex 3 X-Phone: +33 2 40 59 04 59 X-Fax: +33 2 40 59 11 77 X-Web: http://thomas.leduc.free.fr/ X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200501/34 X-Sequence-Number: 15893 Le 5 janvier 2005 à 22:20, Gémes Géza a écrit : > > I would suggest to retry it with a postgres user readable > /etc/pam.d/postgresql > an with a pg_hba.conf without postgres specified on the last field after > pam. Also if you want ldap authentication, take care, that in > /etc/pam.d/postgresql you don't reference any other non pam_ldap module, > and your /etc/ldap.conf is readable by postgres user. thank you for your help, That's all i have done : $ id uid=26(postgres) gid=26(postgres) groupes=26(postgres) $ cat /etc/pam.d/postgresql auth required /lib/security//pam_ldap.so $ 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 $ psql -U leduc leduc Mot de passe : psql: FATAL: PAM authentication échouée pour l'utilisateur "leduc" => DID NOT WORK !!! # 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 ! -- Thomas LEDUC CNRS UMR 1563 - Laboratoire CERMA - Ecole d'Architecture de Nantes Tel: +33 (0) 2 40 59 04 59 -- Fax : +33 (0) 2 40 59 11 77 EAN - Rue Massenet - BP 81931 - 44319 NANTES cedex 3 GPG KeyID: B2342343 Fingerprint: D62CF1A9D4BEDE671602504C46514CC8B2342343