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
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!