pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Dick Davies <rasputnik@hellooperator.net>
Cc: PostgreSQL Admin <pgsql-admin@postgresql.org>
Subject: Re: [HACKERS] PostgreSQL pam ldap document
Date: Mon, 25 Apr 2005 23:01:50 -0400 (EDT)
Message-ID: <200504260301.j3Q31ob22833@candle.pha.pa.us> (raw)
In-Reply-To: <20050311200812.GL27608@eris.tenfour>


Addition added to PAM documentation.  Patch attached and will appear in
8.0.3.

---------------------------------------------------------------------------

Dick Davies wrote:
> * Adrian Nida <nida@musc.edu> [0307 18:07]:
> > <Snip/>
> > >>Here is my attempt at doing so:  http://itc.musc.edu/wiki/PostGreSQL
> > <Snip/>
> > >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

Attachments:

/bjm/diff (text/plain, 1.5K) download 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 <literal>postgresql</literal>. You can optionally supply your own service name after the <literal>pam</> key word in the file <filename>pg_hba.conf</filename>. ! For more information about PAM, please read the ! <ulink url="http://www.kernel.org/pub/linux/libs/pam/"> <productname>Linux-PAM</> Page</ulink> and the <ulink url="http://www.sun.com/software/solaris/pam/"> <systemitem class="osname">Solaris</> PAM Page</ulink>. --- 883,892 ---- default PAM service name is <literal>postgresql</literal>. You can optionally supply your own service name after the <literal>pam</> key word in the file <filename>pg_hba.conf</filename>. ! 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 <ulink url="http://www.kernel.org/pub/linux/libs/pam/"> <productname>Linux-PAM</> Page</ulink> and the <ulink url="http://www.sun.com/software/solaris/pam/"> <systemitem class="osname">Solaris</> PAM Page</ulink>.

view thread (6+ messages)

Message-ID: <200504260301.j3Q31ob22833@candle.pha.pa.us>
Permalink:  ../200504260301.j3Q31ob22833@candle.pha.pa.us/
Also on:    postgresql.org/message-id/200504260301.j3Q31ob22833@candle.pha.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: pgman@candle.pha.pa.us, rasputnik@hellooperator.net
  Subject: Re: [HACKERS] PostgreSQL pam ldap document
  In-Reply-To: <200504260301.j3Q31ob22833@candle.pha.pa.us>
  References: <20050311200812.GL27608@eris.tenfour> <200504260301.j3Q31ob22833@candle.pha.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox