Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id DFA79475E91 for ; Thu, 5 Dec 2002 09:01:01 -0500 (EST) Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id 37053475BD7 for ; Thu, 5 Dec 2002 09:01:01 -0500 (EST) Received: by news.hub.org (Postfix, from userid 8) id BFD6E43A425; Thu, 5 Dec 2002 09:01:00 -0500 (EST) From: Tim Frank X-Newsgroups: comp.databases.postgresql.admin Subject: Re: PAM Date: Thu, 05 Dec 2002 09:01:00 -0500 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 71 Message-ID: References: <87lm361r3k.wl@dgpc1.nifs.ac.jp> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.2) Gecko/20021202 X-Accept-Language: en-us, en In-Reply-To: <87lm361r3k.wl@dgpc1.nifs.ac.jp> To: pgsql-admin@postgresql.org X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/50 X-Sequence-Number: 6545 I was testing this on a 7.3 beta the other week to try to make it work with LDAP authentication, and I think I only got it working if I bypased the system-auth PAM file that everything was normally funneled through. I don't know exactly why it wasn't working, but whenever I put a line that used pam_unix.so it would fail with the same error you are encountering. I didn't invest a huge amount of time figuring out why pam_unix.so was causing a problem because I wanted to use pam_ldap.so anyways. There doesn't seem to be many examples out there that I could find that I got to work. FYI I am testing on RedHat 7.x and 8.0 machines. Tim EMOTO Masahiko wrote: > Does anyone show me a sample of PAM authenticate file? > > I want to use pam for client authentication, and I create pg_hba.cnf as, > > >>host all all 127.0.0.1 255.255.255.255 trust >>host all all 192.168.0.0 255.255.0.0 pam postgresql > > > and /etc/pam.d/postgresql as > >>auth required /lib/security/pam_stack.so service=system-auth >>account required /lib/security/pam_stack.so service=system-auth > > > I tried to connect to the server, but failed. The messages I received were follows; > > >>[CLIENT] >>% psql -h dgpc1 db1 -U emo >>Password: >>psql: FATAL: PAM authentication failed for user "emo" >> >>[SERVER] >>DEBUG: reaping dead processes >>DEBUG: child process (pid 15642) exited with exit code 0 >>DEBUG: BackendStartup: forked pid=15643 socket=8 >>DEBUG: received PAM packet >>LOG: CheckPAMAuth: pam_authenticate failed: 'Authentication failure' >>FATAL: PAM authentication failed for user "emo" >>DEBUG: proc_exit(0) >>DEBUG: shmem_exit(0) >>DEBUG: exit(0) >>DEBUG: reaping dead processes > > > The user account exists in the database, and I typed the system password. > > > Environment: > OS : Linux Kernel 2.4.19 > PostgreSQL 7.3 > > > By the way, what really I want to do is to configure the server behave like FTP servers; > All the users except the guest (anonymous) requires the password authentication. > The guest user can only read the data, and cannot alter the data. > Are there any solutions to do this? > > > --- EMOTO Masahiko --- > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org