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 30D38D1B20E for ; Wed, 7 Jul 2004 11:37:53 -0300 (ADT) 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 28110-03 for ; Wed, 7 Jul 2004 14:37:52 +0000 (GMT) Received: from mailer.elma.loc (mail.elma.fr [213.41.14.138]) by svr1.postgresql.org (Postfix) with ESMTP id 7362BD1B23F for ; Wed, 7 Jul 2004 11:37:47 -0300 (ADT) Received: from mailer.elma.loc (localhost [127.0.0.1]) by localhost (Postfix) with ESMTP id 10D6BEC13C for ; Wed, 7 Jul 2004 15:41:22 +0200 (CEST) Received: from zoot.elma.fr (herve.elma.fr [10.0.1.2]) by mailer.elma.loc (Postfix) with ESMTP id EA7F6EC0A9 for ; Wed, 7 Jul 2004 15:41:21 +0200 (CEST) From: =?iso-8859-15?q?Herv=E9_Piedvache?= Organization: Elma =?iso-8859-15?q?Ing=E9nierie?= Informatique To: pgsql-admin@postgresql.org Subject: pam authentification trouble ... Date: Wed, 7 Jul 2004 16:37:50 +0200 User-Agent: KMail/1.6.2 MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: 8bit Message-Id: <200407071637.50311.herve@elma.fr> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/84 X-Sequence-Number: 14152 Dear all, I have a trouble with the pam authentification for PostgreSQL. I have add in the pg_hba.conf the good line ... and I have create a /etc/pam.d/postresql file which contains : auth        required    pam_unix.so nullok_secure account     required    pam_unix.so Now like this ... impossible for me to connect to the dabase ... I have message like this : Jul  6 13:26:44 zoot arr [local] authentication: (pam_unix) auth could not identify password for [herve] Jul  6 13:26:47 zoot arr [local] authentication: (pam_unix) authentication failure; logname= uid=31 euid=31 tty= ruser= rhost=  user=herve The only solution I have found to make it running is to put the postgres user in the shadow group ... to be able to read the /etc/shadow file ... I think this is not normal ... so please if you have any idea to solve my trouble ... I'll be very pleased ... I'm using linux, on Debian Woody ... but using my own compilation of PostgreSQL v7.4.3. Regards, -- Hervé Piedvache Elma Ingénierie Informatique 6 rue du Faubourg Saint-Honoré F-75008 - Paris - France Pho. 33-144949901 Fax. 33-144949902