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 164EA56499 for ; Tue, 26 Apr 2005 00:02:49 -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 39651-02 for ; Tue, 26 Apr 2005 03:02:41 +0000 (GMT) Received: from candle.pha.pa.us (candle.pha.pa.us [64.139.89.126]) by svr1.postgresql.org (Postfix) with ESMTP id 48BC453A88 for ; Tue, 26 Apr 2005 00:02:07 -0300 (ADT) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.11.6) id j3Q31ob22833; Mon, 25 Apr 2005 23:01:50 -0400 (EDT) From: Bruce Momjian Message-Id: <200504260301.j3Q31ob22833@candle.pha.pa.us> Subject: Re: [HACKERS] PostgreSQL pam ldap document In-Reply-To: <20050311200812.GL27608@eris.tenfour> To: Dick Davies Date: Mon, 25 Apr 2005 23:01:50 -0400 (EDT) Cc: PostgreSQL Admin X-Mailer: ELM [version 2.4ME+ PL121 (25)] MIME-Version: 1.0 Content-Type: multipart/mixed; boundary=ELM1114484510-23900-1_ Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.01 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/365 X-Sequence-Number: 17378 --ELM1114484510-23900-1_ Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII Addition added to PAM documentation. Patch attached and will appear in 8.0.3. --------------------------------------------------------------------------- Dick Davies wrote: > * Adrian Nida [0307 18:07]: > > > > >>Here is my attempt at doing so: http://itc.musc.edu/wiki/PostGreSQL > > > > >I get a "not exists" error on that URL. > > Sorry, I renamed the URL after someone pointed out the correct spelling. > > This was a link to the old one. I apologize for the confusion, the > > right URL is: > > > > http://itc.musc.edu/wiki/PostgreSQL > > > > >I assume you looked at: > > > http://www.postgresql.org/docs/8.0/interactive/auth-methods.html#AUTH-PAM > > >Do you have additions to it? > > > > Yes, I did look at it. No offense to the original author, but my doc > > has a lot more than the four sentences that are there. I was hoping it > > would help others in my situation. Again any and all > > comments/questions/blah are appreciated. > > I think the point he's trying to make is that most of your howto is > how to setup pg_hba.conf (which is in the docs anyway) and how to set up pam_ldap > for a service (which is really a pam howto). > > It'd be nice if the docs at > > http://www.postgresql.org/docs/8.0/interactive/auth-methods.html#AUTH-PAM > > said > > 'you need to createuser(8) a postgres user too. PAM is only used to > validate a username/password pair - the user has to exist in postgres as well.' > > and it will, once it updates :) > > > > -- > 'When the door hits you in the ass on the way out, clean off the smudge > your ass leaves, please' > -- Alien loves Predator > Rasputin :: Jack of All Trades - Master of Nuns > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 --ELM1114484510-23900-1_ Content-Transfer-Encoding: 7bit Content-Type: text/plain Content-Disposition: inline; filename="/bjm/diff" Index: doc/src/sgml/client-auth.sgml =================================================================== RCS file: /cvsroot/pgsql/doc/src/sgml/client-auth.sgml,v retrieving revision 1.76 diff -c -c -r1.76 client-auth.sgml *** doc/src/sgml/client-auth.sgml 22 Apr 2005 04:18:58 -0000 1.76 --- doc/src/sgml/client-auth.sgml 26 Apr 2005 02:50:34 -0000 *************** *** 883,890 **** default PAM service name is postgresql. You can optionally supply your own service name after the pam key word in the file pg_hba.conf. ! For more information about PAM, please read the ! Linux-PAM Page and the Solaris PAM Page. --- 883,892 ---- default PAM service name is postgresql. You can optionally supply your own service name after the pam key word in the file pg_hba.conf. ! PAM is used only to validate username/password pairs. ! The user must already exist in the database before PAM ! can be used for authentication. For more information about ! PAM, please read the Linux-PAM Page and the Solaris PAM Page. --ELM1114484510-23900-1_--