Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D899F47638D for ; Thu, 24 Oct 2002 04:55:31 -0400 (EDT) Received: from tounes103.gw.tn (tounes103.gw.tn [193.95.50.103]) by postgresql.org (Postfix) with ESMTP id BB3CB476A10 for ; Thu, 24 Oct 2002 04:54:58 -0400 (EDT) Received: from tounes.ati.tn (tounes-22.ati.tn [193.95.66.22]) by tounes.tngw.tn (8.8.8/8.8.8) with ESMTP id JAA26991 for ; Thu, 24 Oct 2002 09:55:58 -0100 (GMT) Received: from courier.sncft.com.tn ([193.95.107.34]) by smtp.planet.tn (8.11.6/8.11.6) with ESMTP id g9OApGv05892 for ; Thu, 24 Oct 2002 09:51:16 -0100 (GMT) Message-Id: <200210241051.g9OApGv05892@smtp.planet.tn> Received: from server.sfa.sncft.com.tn ([10.2.2.200]) by courier.sncft.com.tn (Lotus Domino Release 5.0.9a) with ESMTP id 2002102409471291:27 ; Thu, 24 Oct 2002 09:47:12 +0200 Received: from gnet.tn (fathi.sfa.sncft.com.tn [10.2.8.11]) (authenticated) by server.sfa.sncft.com.tn (8.11.6/8.11.6) with ESMTP id g9O8sAC32618 for ; Thu, 24 Oct 2002 09:54:10 +0100 Date: 24-Oct-2002 09:53:17 ZE2 From: Fathi Ben Nasr X-Mailer: Mozilla 4.78 [fr] (Win98; U) MIME-Version: 1.0 To: pgsql-general@postgresql.org Subject: Re: LDAP authentication References: <200210231942.g9NJgd802160@e3000b.state.ms.us> <200210232229.39248.t.maekitalo@epgmbh.de> X-MIMETrack: Itemize by SMTP Server on Courier/SNCFT(Release 5.0.9a |January 7, 2002) at 24/10/2002 09:47:13, MIME-CD by Router on Courier/SNCFT(Release 5.0.9a |January 7, 2002) at 24/10/2002 09:47:13, MIME-CD complete at 24/10/2002 09:47:13, Serialize by Router on Courier/SNCFT(Release 5.0.9a |January 7, 2002) at 24/10/2002 09:47:22 Content-type: multipart/mixed; Boundary="0__=4EBBE6CFDFB940F58f9e8a93df938690918c4EBBE6CFDFB940F5" Content-Disposition: inline X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/1163 X-Sequence-Number: 32161 --0__=4EBBE6CFDFB940F58f9e8a93df938690918c4EBBE6CFDFB940F5 Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: quoted-printable Create a file named postgresql in your /etc/pam.d/ directory with this content #%PAM-1.0 auth required /lib/security/pam_ldap.so #nullok #set_secrpc account required /lib/security/pam_ldap.so and something like this in your pg_hba.conf host all 10.0.0.0 255.0.0.0 pam It worked for me. Unfortunately/fortunatly you have to create each user who will acces the database but this can be done easily (i.e. through a php script on an autheticated web location) Fathi Ben Nasr Tommi M=E4kitalo a =E9crit : > 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 (See attached file: smime.p7s) --0__=4EBBE6CFDFB940F58f9e8a93df938690918c4EBBE6CFDFB940F5 Content-type: application/octet-stream; name="=?iso-8859-1?Q?smime.p7s?=" Content-Disposition: attachment; filename="=?iso-8859-1?Q?smime.p7s?=" Content-transfer-encoding: base64 MIIHbQYJKoZIhvcNAQcCoIIHXjCCB1oCAQExCzAJBgUrDgMCGgUAMAsGCSqG SIb3DQEHAaCCBPkwggT1MIIEXqADAgECAgEaMA0GCSqGSIb3DQEBBAUAMIHb MQswCQYDVQQGEwJUTjEOMAwGA1UECBMFVHVuaXMxFzAVBgNVBAcTDlNpZGkg RmF0aGFsbGFoMTcwNQYDVQQKFC5Tb2Np6XTpIE5hdGlvbmFsZSBkZXMgQ2hl bWlucyBkZSBGZXIgVHVuaXNpZW5zMS8wLQYDVQQLFCZBdXRvcml06SBkZSBD ZXJ0aWZpY2F0aW9uIGRlIGxhIFNOQ0ZULjEOMAwGA1UEAxMFU05DRlQxKTAn BgkqhkiG9w0BCQEWGmNlcnQtYXV0aEBzZmEuc25jZnQuY29tLnRuMB4XDTAy MDUyOTEzNDUyNloXDTAzMDUzMDEzNDUyNlowgagxCzAJBgNVBAYTAlROMQ4w DAYDVQQIEwVUdW5pczE3MDUGA1UEChQuU29jael06SBOYXRpb25hbGUgZGVz IENoZW1pbnMgZGUgRmVyIFR1bmlzaWVuczEQMA4GA1UECxMHRE1UL1NGQTEX MBUGA1UEAxMORmF0aGkgQmVuIE5hc3IxJTAjBgkqhkiG9w0BCQEWFmZhdGhp LmVuZ2luZWVyQGduZXQudG4wgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGB ALvoBrAymAVRgNSNC8v2nEWgcxan1VXjZpXfpknrNn5iF8N2RqRIRf5D8gn7 u+I4dBlc6PBZMFr/AMhn5hsULGKMqKFT/xrGxOpeMaiKcedFz1o47hbR4C73 O+tQ3ZdH0VEb6/8gSia8n0K9x2hgd9Hfueq2oJ0uNCDADL10PAuxAgMBAAGj ggH4MIIB9DAJBgNVHRMEAjAAMBEGCWCGSAGG+EIBAQQEAwIEsDALBgNVHQ8E BAMCBeAwUQYJYIZIAYb4QgENBEQWQkdlbmVyYXRlZCBieSB0aGUgVHVuaXNp YW4gTGludXggQ29tbXVuaXR5IENlcnRpZmljYXRpb24gQXV0aG9yaXR5LjAd BgNVHQ4EFgQUrm/6kp7nJ9Cty4jYE+KRZQG+9BwwggEJBgNVHSMEggEAMIH9 gBQZNq1LiUGnuUDEopltuMmcKb6k06GB4aSB3jCB2zELMAkGA1UEBhMCVE4x DjAMBgNVBAgTBVR1bmlzMRcwFQYDVQQHEw5TaWRpIEZhdGhhbGxhaDE3MDUG A1UEChQuU29jael06SBOYXRpb25hbGUgZGVzIENoZW1pbnMgZGUgRmVyIFR1 bmlzaWVuczEvMC0GA1UECxQmQXV0b3JpdOkgZGUgQ2VydGlmaWNhdGlvbiBk ZSBsYSBTTkNGVC4xDjAMBgNVBAMTBVNOQ0ZUMSkwJwYJKoZIhvcNAQkBFhpj ZXJ0LWF1dGhAc2ZhLnNuY2Z0LmNvbS50boIBADAhBgNVHREEGjAYgRZmYXRo aS5lbmdpbmVlckBnbmV0LnRuMCUGA1UdEgQeMByBGmNlcnQtYXV0aEBzZmEu c25jZnQuY29tLnRuMA0GCSqGSIb3DQEBBAUAA4GBAHY19pRgGqwZJXtxUn7f 5q6gxlxJJK3TWvk2+nUjg4n85i+vHLNJOZkDGVGRrpu1WbhygCoYhQUOKwEl BuWl5MDk/ucjd1w/X1+w6cu1Iy8PX9UlzaFMykSuq1l5m5lR7fAeUzV4SA5u p1FzgPSIRzYoTnkcebbvtZQhcUF1dvbpMYICPDCCAjgCAQEwgeEwgdsxCzAJ BgNVBAYTAlROMQ4wDAYDVQQIEwVUdW5pczEXMBUGA1UEBxMOU2lkaSBGYXRo YWxsYWgxNzA1BgNVBAoULlNvY2npdOkgTmF0aW9uYWxlIGRlcyBDaGVtaW5z IGRlIEZlciBUdW5pc2llbnMxLzAtBgNVBAsUJkF1dG9yaXTpIGRlIENlcnRp ZmljYXRpb24gZGUgbGEgU05DRlQuMQ4wDAYDVQQDEwVTTkNGVDEpMCcGCSqG SIb3DQEJARYaY2VydC1hdXRoQHNmYS5zbmNmdC5jb20udG4CARowCQYFKw4D AhoFAKCBsTAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJ BTEPFw0wMjEwMjQwNzUzMThaMCMGCSqGSIb3DQEJBDEWBBTvn/D+XDTTzrWX IZ/qeKb8oaisZDBSBgkqhkiG9w0BCQ8xRTBDMAoGCCqGSIb3DQMHMA4GCCqG SIb3DQMCAgIAgDAHBgUrDgMCBzANBggqhkiG9w0DAgIBQDANBggqhkiG9w0D AgIBKDANBgkqhkiG9w0BAQEFAASBgFm4eyjc4F1NaZAJZvVXl6sA0JsAuVoS /h9rSXIZaj7PdlKuwO4fJl7fcz6Q6AB9oSuvPipj8yiEYRviZDxTtjCfq/qi n8wttwJc5Dlj+xSy1AJI4CkUoyEU/jXNSOQzglxrz7QQK8JEr7BzfhwygwYn TPqQ8k2kaAJCFT5Togoo --0__=4EBBE6CFDFB940F58f9e8a93df938690918c4EBBE6CFDFB940F5--