Re: Fw: LDAP Search to SQL Select

[Giovanni Baruzzi <giovanni.baruzzi@allianz-leben.de>]

Robert Klerer wrote:

> I have a relational database as my directory.  I would like to be able to
> accept LDAP queries.  Does anyone have a process that will accept LDAP
> searches, generate an SQL select and convert the results back for an LDAP
> response?
>

this is normally the behaviour of a LDAP Front-End. The queries are sent to an
SQL Database.


>
> I notice that there are references in the archives to a "Generic SQL
> backend", which I could not locate the details on.  I may be mistaken, but I
> believe I am asking a different question -- slapd's use of any database
> would require the definition of certain tables.

correct: the structure of these Table is commanded by SLAPD, not by your
previous TABLES.


> I already have the table
> definitions (and contents) and I want to map the query against it (I think).
> Also, I believe that I require only a subset of the ldap functionality.
>

The database connection is becoming a major theme, now; We have still not clear
answer here, apart doing a lot of programming and personalization.
One possibility is to write a plug-in for your SLAPD, converting the QUERIES
that SLAPD sends to new queries that get data from your tables.
You may give a look to what Oracle offers.... It seems that they built an LDAP
front end to their Database.


Giovanni Baruzzi
Network Architect


>
> Any help or pointers to the right resources would be appreciated.
>
> -------------------------------------------------------------
> Robert Klerer
> Crosshair Communications Corporation
> Email:  klerer@xhair.com
> Voice: 914-217-4475
> Fax:  914-722-0877
> Snailmail: 189 Fort Hill Road, Scarsdale NY 10583