Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 2F0B79F9268 for ; Fri, 10 Aug 2007 12:09:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 10623-10 for ; Fri, 10 Aug 2007 12:09:09 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id D4B229F925D for ; Fri, 10 Aug 2007 12:09:11 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.8/8.13.8) with ESMTP id l7AF9B1c051178 for ; Fri, 10 Aug 2007 12:09:11 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.8/8.13.8/Submit) id l7AEiuGJ045798 for pgsql-admin@postgresql.org; Fri, 10 Aug 2007 11:44:56 -0300 (ADT) (envelope-from news) From: Tomasz Myrta X-Newsgroups: pgsql.admin Subject: Re: Postgres and PAM config issues Date: Fri, 10 Aug 2007 16:45:01 +0200 Organization: Hub.Org Networking Services Lines: 17 Message-ID: <46BC79ED.3030404@klaster.net> References: <174112B8F646484A89DDC7A3DD25B4B6054CC9@SNV-EXVS05.ds.corp.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org To: Marcin Porwit User-Agent: Thunderbird 2.0.0.0 (Windows/20070326) In-Reply-To: <174112B8F646484A89DDC7A3DD25B4B6054CC9@SNV-EXVS05.ds.corp.yahoo.com> To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/118 X-Sequence-Number: 26449 Marcin Porwit napisal 2007-08-10 03:26: > positionwhile[pg]% more /etc/pam.d/postgresql > #%PAM-1.0 > auth required pam_stack.so service=system-auth > > The system is a CentOS 4.4 box, and I'm running PostgreSQL 8.0.6. > > However, when I try to get psql to do password authentication, I get the > following: > positionwhile[postgresql-8.0.13]% psql authtest > Password: > psql: FATAL: PAM authentication failed for user "mporwit" Probably you are missing "account" section in your pam configuration. Regards, Tomasz Myrta