Re: openldap, back-sql, database table and stored procedures

["Celine Murphy" <celinem@zartis.com>]

I am relatively new to ldap. I have set it up though and can access it using jndi.
And am fairly familiar at this stage with the slapd.conf.

On a general query about the attached letter. I realise it is possible to set up the
ldap with a sql database but i would like to know how this works. Is it still
possible to access it with jndi? how do you access it with sql (JDBC??)  If it has a
sql database does it still have the properites of the ldap? Can you access the
openldap.ldbm using sql?
As I say I am relatively new, so these questions may be completely ridiculus as my
understanding is minimal, if so my apologies.

Also on another note. Does anyone have an idea of the pros and cons concerning
openldap2.0.6 and openldap2.0.7 (there slapd.conf files seem to be completely
different).

Finally any information about configuring openssl with openldap would be greatly
appreciated.

Thanks in advance.

Celine

Dmitry Kovalev wrote:

> amol wrote:
>
> >  As my current database is SQL server I am using back SQL of openldap
> > so that
> >     1. I need not change it
>
> yes, this is what back-sql is for
>
> >
> >     2. I am not sure How will I add users in ldbm database from servlet code
> > as it's a free service ? ( you can give me some hints here )
>
> through LDAP client library - you can add entries to LDAP directory using JNDI
> LDAP adapter from Java (as well as query it or do anything else that can be done
> with LDAP directory)
>
> >
> > I hope now you can understand my situation. Now please give me some
> > suggestions to go ahead, as most of the people are questioning me about using
> > back-sql and I am a bit confused :-(
>
> back-sql was designed specifically for situations when you already have data in
> RDBMS, and don't want/have ability to migrate to ldbm or synchronize with it.
> It can be tuned to virtually any schema you have to access your data through
> LDAP, but you will have to define how your data fits into LDAP schema you desire
> (SQL queries and stored procedures to support common LDAP operations).
>
> >
> > I am a newbie to stored procedures etc and now trying to go over it. I am
> > getting the sample back-sql implementation a bit. I think the sample back-sql
> > files ( sql queries to create database tables and stored procedures ) are  for
> > core.schema so now if I want to add some more feilds which are there in
> > qmailuser.schema I have to change tables and stored procedures. Is it right ?
>
> not quite. sample files are just _sample files_. they define sample database that
> someone could have, and illustrate how it can be exported to LDAP, depending on
> RDBMS you use. They implement only a small part of what is usually contained in
> real LDAP user directories.
>
> back-sql tries to shield you only from programming your custom backend, but
> shurely not from SQL authoring - it expects you to have enough skills to support
> it from RDBMS side.
>
> "concept" file contains explanations on principles back-sql relays on, it should
> be sufficient to figure out what additional metadata and procedures you will have
> to add to support _your_ schema - you don't have to use these samples as a start
> (you can take only metatables creation script from there).
>
> if you feel it is not enough - I barely can explain it any better, at least in
> English, sorry...
>
> >
> >
> > Thank you very much.
> > Will mail you my developments.
> > Amol
> >
> > Dmitry Kovalev wrote:
> >
> > > amol wrote:
> > >
> > > > I got openldap working with back-sql but now I want to add some feilds
> > > > for each unit ( person ). Where can I find details about making database
> > > > tables and stored procedures for changed schema.
> > > >
> > >
> > > What information exactly do you want? There're general instructions about
> > > construction metadata in servers/slapd/back-sql/docs/concept
> > > Just write any procedures you need ;)
> > >
> > > And again, if you make plain new LDAP database, and have no data in RDBMS
> > > yet - check the concept and FAQs - you probably better not use back-sql at
> > > all - use general-purpose backend.
> > >
> > > WBW, Dmitry
> >
> > --
> > Amol
> > Amol@mailjol.com
> > ----------------------------------------------------------------
> > Send and receive mail in Indian languages
> > Register free at http://www.mailjol.com