X-Original-To: pgsql-admin@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 741DD4764FB for ; Fri, 31 Jan 2003 01:18:13 -0500 (EST) Received: from mta02bw.bigpond.com (unknown [144.135.24.138]) by postgresql.org (Postfix) with ESMTP id E91E54764C9 for ; Fri, 31 Jan 2003 01:18:10 -0500 (EST) Received: from AMD1200 ([144.135.24.69]) by mta02bw.bigpond.com (Netscape Messaging Server 4.15 mta02bw Jul 16 2002 22:47:55) with SMTP id H9KERU00.ATK for ; Fri, 31 Jan 2003 16:16:42 +1000 Received: from FLPP-p-144-134-125-128.prem.tmns.net.au ([144.134.125.128]) by bwmam01.mailsvc.email.bigpond.com(MailRouter V3.0n 2/5022070); 31 Jan 2003 16:16:42 Message-ID: <001301c2c8f0$2c54b3d0$0101a8c0@AMD1200> From: "Brett Northcott" To: Subject: PAM authentication Date: Fri, 31 Jan 2003 16:45:37 +1030 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/353 X-Sequence-Number: 7195 ok - fairly new to postgresql & tring to set up tcp/ip access using pam authentication using gentoo_linux 1.4_rc2 postgresql-7.3.1 my pg_hba.conf file has the entries # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD local all all trust host all all 127.0.0.1 255.255.255.255 trust host all all 192.168.1.1 255.255.255.0 pam postgresql my /etc/pam.d/postgresql file has the entries #%PAM-1.0 auth required pam_stack.so service=system-auth account required pam_stack.so service=system-auth when i try to connect (locally).... # psql test -U brett Password: (password entered - i know it is correct) psql: FATAL: PAM authentication failed for user "brett" i get the following entries in /var/log/auth.log - and a Jan 31 16:31:47 achilles unix_chkpwd[25987]: check pass; user unknown Jan 31 16:31:47 achilles postgresql(pam_unix)[25986]: authentication failure; logname= uid=70 euid=70 tty= ruser= rhost= user=brett 'brett' has a system level account. i can connect as user 'brett' if pg_hba.conf is set to 'trust', but never when pam is involved... any ideas? i've been mucking around with this for a couple of days & not getting very far regards, brett