OpenLDAP-POSTGRESQL HOWTO

Gilles DAROLD, gilles AT darold DOT net

v1.0, 14 August 2001

v2.0, 15 Jan 2003

v2.1, 11 Feb 2010: Add answers of common install problems. Thanks to Cristina Arias for the report.

This document is about building an LDAP server with a PostgreSQL database as backend instead of the standard Bekerley DB. This HOWTO doesn't talk about OpenLDAP, PostgreSQL or iODBC in this document I suppose that you know all that, I just provide my personnal installation of these apps.

Note that even if this HOWTO is old now it still works with latest releases of OpenLDAP and PostgreSQL (Feb 2010)

Table of Contents

1. Introduction

1.1. Why a HOWTO ?
1.2. Why a PostgreSQL backend ?
1.3. Want to know more ?

2. Installation

2.1. PostgreSQL
2.2. iODBC
2.3. PostgreSQL ODBC Driver
2.4. OpenLDAP

3. Configuration

3.1. iODBC
3.2. OpenLDAP
3.3. PostgreSQL

4. Testing the ODBC installation

5. Testing the LDAP directory

5.1. Performing a search
5.2. Creating entry
5.3. Setting entry attribute
5.4. Performing a search
5.5. Deleting attribute
5.6. Deleting entry

6. A live example

6.1. The LDAP Schema
6.2. The back-sql LDAP configuration
6.3. Creating the PostgreSQL backend

		Next
		Introduction