Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 99B19B5D95B for ; Fri, 20 May 2011 10:27:34 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 21966-02 for ; Fri, 20 May 2011 13:27:27 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from omr6.networksolutionsemail.com (omr6.networksolutionsemail.com [205.178.146.56]) by mail.postgresql.org (Postfix) with ESMTP id 401A2B5D8B2 for ; Fri, 20 May 2011 10:27:26 -0300 (ADT) Received: from cm-omr7 (mail.networksolutionsemail.com [205.178.146.50]) by omr6.networksolutionsemail.com (8.13.6/8.13.6) with ESMTP id p4KDRQpW009841 for ; Fri, 20 May 2011 09:27:26 -0400 X-Authenticated-IP: 205.178.146.50 Received: from [205.178.146.50] ([205.178.146.50:54534] helo=webmail9) by cm-omr7 (envelope-from ) (ecelerity 2.2.2.41 r(31179/31189)) with ESMTP id 24/9F-02537-E3C66DD4; Fri, 20 May 2011 09:27:26 -0400 Received: from 63.125.4.210 (mark@remingtondatabasesolutions.com [63.125.4.210]) by webmail9 (Netsol 11.2.30) with WEBMAIL id 21821; Fri, 20 May 2011 13:27:26 +0000 From: "Mark Johnson" To: "Teguh R" , pgsql-admin@postgresql.org Importance: Normal Sensitivity: Normal Message-ID: X-Mailer: Network Solutions Webmail, Build 11.2.30 X-Originating-IP: [63.125.4.210] X-Forwarded-For: [(null)] Date: Fri, 20 May 2011 13:27:26 +0000 Subject: Re: LDAP Authentication MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="--=_vm_0011_W974661285_21821_1305898046" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.735 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_NUMERIC_HELO=1.164 X-Spam-Level: X-Archive-Number: 201105/129 X-Sequence-Number: 37566 ----=_vm_0011_W974661285_21821_1305898046 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I too have been looking into this as a new user of PostgreSQL 9.0. 1. Before you install PostgreSQL you might want to verify the LDAP packag= es are installed. For example, on CentOS I might run "yum list openldap o= penldap-devel". 2. If you install PostgreSQL from source code, one of the steps is to run= the "configure" utility. To use LDAP based authentication you should inc= lude the option "--with-ldap". You might also want "--with-openssl". 3. After PostgreSQL has been installed you can see which options were use= d built in using the command "$PGHOME/bin/pg_config --configure". Check t= he output. If there are no references to ldap, then go back to step 1. 4. You can also use this command to see if postgres is linked with the ld= ap libraries: "ldd $PGHOME/bin/postgres". If there are no references to l= dap, then go back to steps 1 and 2. I have not gone past this. I ran into an issue with the one-click install= er on RHEL 6 that I'm stuck on. -Mark -----Original Message----- From: Teguh R [mailto:taguah@gmail.com] Sent: Friday, May 20, 2011 08:31 AM To: pgsql-admin@postgresql.org Subject: [ADMIN] LDAP Authentication Hi, My first post, new to postgresql, forgive me if this is better suited= to other postgresql mailing list. I would like to ask about LDAP authent= ication configuration. It is said in documentation that first the install= ation compiled with LDAP option. I use installer from official postresql = site, is it LDAP authentication ready? Is there any straight tutorial for= setting up LDAP authentication for pg? where to put the LDAP configurati= on (pg_services.conf?) and other step to make LDAP user can login using t= heir id. Thanks in advance, Teguh -- Sent via pgsql-admin mailing list (p= gsql-admin@postgresql.org) To make changes to your subscription: http://w= ww.postgresql.org/mailpref/pgsql-admin ----=_vm_0011_W974661285_21821_1305898046 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
 

I too have been looking into this as a n= ew user of PostgreSQL 9.0.

1. Before you install PostgreSQL you might want to= verify the LDAP packages are installed.  For example, on CentO= S I might run "yum list openldap openldap-devel".   

2. If you install PostgreSQL from source code, one of t= he steps is to run the "configure" utility.  To use LDAP based authe= ntication you should include the option "--with-ldap".  You might al= so want "--with-openssl". 

3. After PostgreSQL has been installed you can see whic= h options were used built in using the command "$PGHOME/bin/pg_config --c= onfigure".  Check the output.  If there are no references to ld= ap, then go back to step 1.

4. You can also use this command to see if postgres is = linked with the ldap libraries:  "ldd $PGHOME/bin/postgres".  I= f there are no references to ldap, then go back to steps 1 and 2.<= /P>

I have not gone past this.  I ran into an issue wi= th the one-click installer on RHEL 6 that I'm stuck on.

-Mark

-----Original Message-----
= From: Teguh R [mailto:taguah@gmail.com]
Sent: Friday, May 2= 0, 2011 08:31 AM
To: pgsql-admin@postgresql.org
Subject:<= /B> [ADMIN] LDAP Authentication

Hi, My first post, new to p= ostgresql, forgive me if this is better suited to other postgresql mailin= g list. I would like to ask about LDAP authentication configuration. It i= s said in documentation that first the installation compiled with LDAP op= tion. I use installer from official postresql site, is it LDAP authentica= tion ready? Is there any straight tutorial for setting up LDAP authentica= tion for pg? where to put the LDAP configuration (pg_services.conf?) and = other step to make LDAP user can login using their id. Thanks in advance,= Teguh -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) = To make changes to your subscription: http://www.postgresql.org/mailpref/= pgsql-admin
----=_vm_0011_W974661285_21821_1305898046--