OpenLDAP-POSTGRESQL HOWTO

Gilles DAROLD, gilles@darold.net

v1.0, 14 August 2001

v2.0, 15 Jan 2003

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.

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