Â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Âpackages are installed. For example, on CentOS I might runÂ"yum list openldap openldap-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 include the option "--with-ldap". You might also want "--with-openssl".Â
3. After PostgreSQL has been installed you can see which options were used built in using the command "$PGHOME/bin/pg_config --configure". Check the 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 ldap libraries: "ldd $PGHOME/bin/postgres". If there are no references to ldap, then go back to steps 1 and 2.
I have not gone past this. I ran into an issue with the one-click installer on RHEL 6 that I'm stuck on.
-Mark
-----Original Message-----
From: Teguh R [mailto:taguah@xxxxxxxxx]
Sent: Friday, May 20, 2011 08:31 AM
To: pgsql-admin@xxxxxxxxxxxxxx
Subject: 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 authentication configuration. It is said in documentation that first the installation 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 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
mi@mi-d525:/opt/PostgreSQL/9.0/bin$ ./pg_config --configure
'--with-libs=/usr/local/lib' '--with-includes=/usr/local/include' '--prefix=/mnt/buildfarm/pginstaller/server/staging/linux' '--with-openssl' '--with-perl' '--with-python' '--with-tcl' '--with-tclconfig=/opt/ActiveTcl-8.5/lib' '--with-pam' '--with-krb5' '--enable-thread-safety' '--with-libxml' '--with-ossp-uuid' '--docdir=/mnt/buildfarm/pginstaller/server/staging/linux/doc/postgresql' '--with-libxslt' '--with-libedit-preferred'
Looks like no --with-ldap option, but there is --with-openssl option. I will trying with configure-make-install from source.
FYI, I use ds from Centos/Fedora.Â
From this documentation, I think the second method of LDAP authentication will fit for my purpose.
Regards,
Teguh
2011/5/20 Mark Johnson <mark@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
