openLDAP is capable of using various back end data stores, including an SQL database.
You have to set up MySQL (obviously), and set up MyODBC (which probably means you will need to install an odbc manager like iodbc or unixodbc), and create a data source. Then you can reconfigure slapd so it will utilize that backend. The docs are available on the openLDAP site, but be warned that it isn't a really straightforward process. The way LDAP structures its schemas is not really well adapted to an RDBMS, so there is some ugly black magic you have to do. Basically you have to create a little configuration which tells slapd's back_sql how to map from LDAP attributes to columns, and what columns of which tables the tree is linked together with. I experimented a bit with all of this for reasons similar to yours, but I never got as far as getting the whole thing to work entirely. Seems its not too tough to get slapd talking to mysql, but the real fun is creating the proper table structures and configuration for your schema. My advice would be to get someone who's an expert on LDAP to give you a hand. On Thursday 23 May 2002 02:01, ally wrote: > Dear all, > > my company is currently using mysql database with php. Now there's this > company which is using LDAP with Oracle and we need to be able to link them > together. > > They suggest tht we use LDAP with Mysql. I've tried looking for information > abt using ldap and mysql but invain. > > Can you please enlighten and advice me? > > thank you vey much > > ally. > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
