[ILUG] openldap frontend to postgres

[David Golden]

On Friday 31 December 2004 10:41, John P. Looney wrote:

>  Is there a good solution to this problem?
>

We-ell... perhaps...

You know the way openldap typically backends onto a BerkeleyDB*

Well,  It can backend onto SQL databases too with back-sql [1].  
Slightly nontrivial to setup, and you'll still need to write stored 
procs to transform from your tables to the ldap-in-sql schema (but that 
could be done on trigger, maybe, for insta-update goodness).  There's a 
good-looking LDAP-Postgres HOWTO, though I don't know how up-to-date it 
is [2]

[1] http://www.openldap.org/faq/data/cache/978.html
[2] http://www.samse.fr/GPL/ldap_pg/HOWTO/index.html


* One really should familiarise oneself with BDB admin tools
([lib]dbX.Y-util packages in debian - do an apt-cache search berkeley) 
if one is running OpenLDAP  with a bdb backend - several heart attacks 
averted in DIAS by  proper use of db_recover [3]

[3] http://www.sleepycat.com/docs/utility/db_recover.html