Networks

Ask something
Discussion Locked

My SQL merge and LDAP searches

0 helpful
5 replies

by shanghai sam

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have what I think is a complicated question. I don't need to know details on how to do this but if it would be feasible to do this. We have 2 different My SQL databases tied to 2 different IBM AS/400 systems we use for billing, trouble tickets,etc. We use the 2 databases to create new accounts, add/change information test username/passwords and perform LDAP searches and many other tasks. When we add or make a change in the databases it updates the info to the as/400. The 2 as/400's aren't merged (yet) because we were 2 separate companies at one time there are billing issues involved. The way we must perform LDAP searches now is this, if we are searching for a particular email address, user, or domain, we must use one database. If we are searching for a user, email address, etc on one of the many other domains that we have, we must use the the other database.
Now, the question. Is there a way to have the 2 databases perform LDAP searches on all the domains that we have. Making no difference which database you are using?

5 replies

by igorm

hi,
So far so I understand, you need install LDAP servers for both DB (host) and use LDAP features "referrals" for searching on both backend databases in one request.

by maxwell edison

LDAP servers can be multi-threaded to support many LDAP databases simultaneously. I don't know the exact details, but the following links may be helpful:

http://www.openldap.org/doc/admin/intro.html

http://enterprise.netscape.com/products/contentsvcs/Ente rprise_Server.pdf

http://www.process.com/tcpip/iddsspd.pdf

----------

Writing Multithreaded Clients:

http://devedge.netscape.com/docs/manuals/dirsdk/csdk30/t hreaded.htm#996824

----------

Remove spaces that may have snuck into the pasted URLs.

This discussion is closed to new replies.