MySQL integration with Active Directory...

Posted on 2004-11-19
Last Modified: 2011-08-18
Let me present this as a need:

We want to do the following:

Provide access to various parts of a website via the groups defined in our Active Directory -

So, I'm looking for ways to integrate that- I don't know if there's something like a PHP script that could make the calls each time someone accesses a page (to find out what group the username belongs to)
or if I'm looking to tie MySQL into Active Directory and build a dynamic table (or update a table every day to reflect user changes), or what..

Seems like many approaches would work-
1. Do this entirely in PHP on the website (which is running IIS btw)
2. Use MySQL somehow
3. I know LDAP's out there- but I'm not sure if our AD has the connectors, and I'd probably run into resistance in modifying our AD to do that-
Question by:acsit
    1 Comment
    LVL 48

    Accepted Solution

    AFAIK there is no way to integrate AD into mysql. You can only replicate "via a script you need to write" the data and populate tables with that information. THos infomation will always be behind. I suggest using ldap in php to authenticate the users.

    e.g A class that can auth against a AD (AFAIK that ldap-connector should be available by default)

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost every time LOAD DATA INFILE comes to the rescue. Here we will try to understand some of the very common scenarios for loading data …
    Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now