Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 8801F475FF1 for ; Thu, 24 Oct 2002 06:06:12 -0400 (EDT) Received: from mail.eckpart.de (mail.eckpart.de [217.6.160.186]) by postgresql.org (Postfix) with SMTP id EC18D4760AB for ; Thu, 24 Oct 2002 06:06:10 -0400 (EDT) Received: (qmail 7283 invoked from network); 24 Oct 2002 10:06:12 -0000 Received: from db2.eckpart.de (HELO db2) (tommi@192.168.41.72) by cserv.eckpart.de with SMTP; 24 Oct 2002 10:06:12 -0000 Content-Type: text/plain; charset="iso-8859-1" From: Tommi Maekitalo Organization: Dr. Eckhardt + Partner GmbH To: pgsql-general@postgresql.org Subject: Re: LDAP authentication Date: Thu, 24 Oct 2002 12:06:12 +0200 User-Agent: KMail/1.4.3 References: <200210231942.g9NJgd802160@e3000b.state.ms.us> <200210232229.39248.t.maekitalo@epgmbh.de> <200210232130.g9NLUO800570@e3000b.state.ms.us> In-Reply-To: <200210232130.g9NLUO800570@e3000b.state.ms.us> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200210241206.12448.t.maekitalo@epgmbh.de> X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/1044 X-Sequence-Number: 32042 Hi, I just tried out. Pam works fine with pam_ldap on linux. But as a told you= =20 need to create databaseusers. I just configured postgresql with --with-pam= =20 and created (or copied one and modified) a /etc/pam.d/postgresql. Her is it: #%PAM-1.0 auth required pam_nologin.so auth sufficient pam_ldap.so auth required pam_unix.so nullok try_first_pass #set_secrpc account sufficient pam_ldap.so account required pam_unix.so password required pam_pwcheck.so nullok password required pam_ldap.so use_first_pass use_authok password required pam_unix.so nullok use_first_pass use_authtok Maybe you can create users with a cronjob, which queries ldap on a daily ba= se=20 about new (and retired) users. Postgresql do need entries in pg_shadow. I= =20 think it would be hard to hack authentication so that it does not need. It might be fine to see a generic way to create pg_shadow on the fly like n= ss=20 does. It should be a table-function, which might query a ldap-tree. Tommi Am Mittwoch, 23. Oktober 2002 23:26 schrieb Richard Ray: > I've had no luck gettting PAM to work with PostgreSQL on HP/UX 11.00 and I > read that PostgreSQL doesn't allow user triggers on system tables. Not mu= ch > left but hack the PostgreSQL authentication code. > > Richard > > On Wednesday 23 October 2002 03:29 pm, you wrote: > > Postgresql supports pam. And there is pam_ldap. I haven't tried out yet. > > But I'm sure you need to create users in postgresql. Just authentication > > comes through pam. There is no nss_ldap as far as I know. > > > > > > Tommi > > > > Am Mittwoch, 23. Oktober 2002 21:38 schrieb Richard Ray: > > > Does anyone know if anyone has tried to use LDAP for authentication? > > > The management here is insisting on it. I'll write it from scratch if > > > neccassary. Any hints or pointers are appreciated. > > > > > > Thanks > > > Richard > > > > > > ---------------------------(end of > > > broadcast)--------------------------- TIP 2: you can get off all lists > > > at once with the unregister command (send "unregister > > > YourEmailAddressHere" to majordomo@postgresql.org) > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 3: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to majordomo@postgresql.org so that your > > message can get through to the mailing list cleanly > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org --=20 Dr. Eckhardt + Partner GmbH http://www.epgmbh.de