Discussion Locked

SQL and LDAP

0 helpful
5 replies
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 jandiar

Hi, the answer depends on how you currently do LDAP searching.

If you can do it programmatically or by using a command line interface, I suggest you to create a simple program/script which consists of the following logic:

search "text_string" on database 1
and save the result in output file A
search "text_string" on database 2
and save the result in output file B
combine the result in file A and B
and print all results to user

Regards, Jan.

by istmaj

Sorry it took so long to respond. I have been on vacation. Thank you for your response I will pass this information on to our administrator.

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/Enterprise_Server.pdf

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

----------

Writing Multithreaded Clients:

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

----------

Remove spaces that may have snuck into the pasted URLs.

by istmaj

I could not get 3 of the links to work. Didn't help me but thatnks for your response

This discussion is closed to new replies.