Re: AW: LDAP-Question about connection to a central database

[Jan-Piet Mens <jpm@Retail-SC.com>]

I suppose it could work; I've never tried back-sql, because I
allow updates to LDAP and to the RDBMS (under specific conditions and
don't care about conflicts).

AFAIX, back-sql is read-only, but as I already said, I've not looked
at newer versions.

	-JP

On Wed, 3 Jan 2001, Wald, Matthias wrote:

> What about back-sql where the information from the
> directory is delivered from the RDBMS?
>
> > -----Ursprüngliche Nachricht-----
> > Von:	Jan-Piet Mens [SMTP:jpm@Retail-SC.com]
> > Gesendet am:	Mittwoch, 3. Januar 2001 15:58
> > An:	manfred.steinbacher@avl.com
> > Cc:	openldap-software@OpenLDAP.org
> > Betreff:	Re: LDAP-Question about connection to a central database
> >
> > It is certainly possible to have an RDBMS synchronize with an LDAP
> > directory. Since you are posting here, I am supposing you are using
> > OpenLDAP; I don't know of any tools that do this for you.
> >
> > You will probably have to design your own code for doing that. In
> > principle, you "SELECT * FROM dbtable" and compare by doing an
> > equivilant of ldapsearch if all attribute types and their values
> > are set in the directory. If not you do an ldap_modify(3). If an
> > entry is not in the directory, you'll have to ldap_add(3) it and
> > if an entry is in the directory but not in the database, you would
> > probably ldap_delete(3) it.
> >
> > It is not difficult to do, but requires careful thought. I've been
> > able to do this, because I will have a maximum of about 10k entries.
> > This alone already takes a good 20 minutes to sync.
> >
> > Regards,
> > 	-JP
> >
> >
> >
> > On Wed, 3 Jan 2001, manfred.steinbacher@avl.com wrote:
> >
> > > Hello
> > >
> > > I´m new with LDAP and I have following question:
> > >
> > > We have a central database where our user-information were stored!
> > > In the moment our LDAP-Server import every day a ascii-file (we get it
> > from
> > > our central-database)!
> > > The problem is, when we change any settings for a user we must first
> > delete
> > > this user and after that we make a import form the central-database!
> > >
> > > Is it possible that the LDAP-Server synchronice with our Database
> > > (Orcale-System) or any other way to solve this problem!
> > >
> > > MANY THANKS
> > >
> > > Best Regards
> > > Mit freundlichen Grüßen
> > > Manfred Steinbacher
> > > EDS Austria - Core Infrastructure
> > > Network Services
> > >
> > > EDS Austria / AVL - Account
> > > Phone: +43  316 787 470
> > > Fax: +43 316 787 1783
> > > eMail: manfred.steinbacher@avl.com
> > > Hans-List Platz 1  A-8020 GRAZ
> > >
> > >
> > >
> > >
>
>