Ways to connect a MySQL Database to Active Directory

Hello,

I am trying to solve a problem that I think has already been solved by others. But, my experience on this topic is limited, so I haven't found the answer yet. My post is lengthly, please bare with me. : D

Situation:

I have a service that I'd like to provide to the public but that service needs Active Directory to function. I am trying to think of ways on how a user can register to my website and that person's account gets created in Active Directory automatically. And, any account changes that the user makes, gets synchronized to Active Directory.

What I've thought of doing so far:

Option A: An export job from MySQL and an import job to Active Directory using a csv file triggered by a scheduled task - So far I think this could work but it's not efficient

Option B: Direct sync from MySQL to Active Directory using some sort of a connector - I don't know how to do this.

Option C: Hire a 3rd-party site Developer - My resources are limited, this option will be my last resort

Option D: Other ways to solving this problem

Question:

For Option B: Is it possible to connect a MySQL Database to Active Directory to when a user account is created through my website it also creates the account in Active Directory automatically? I am thinking that I need some type of a connector between two databases, does anyone know how to do this?

For Other Options: To keep this post short and not too broad, I won't post my questions for my other options, but if you have other ways to solve my problem please feel free to post them here.

Thank you in advance!
LVL 2
petaganayrAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David Johnson, CD, MVPOwnerCommented:
how a user can register to my website and that person's account gets created in Active Directory automatically. And, any account changes that the user makes, gets synchronized to Active Directory.

Definitely a not recommended solution.

on the website you have your accounts page. you will have to add the code to change active directory using ldap http://php.net/manual/en/function.ldap-modify.php
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
petaganayrAuthor Commented:
Hi David,

Thank you for the comment. I've posted the same questions on other websites, and I've received the same comment but nobody explained to me why it is not a recommended solution. I figured its because the Domain Controller will be indirectly exposed to the Internet, but is that the only reason?

Thank you.
0
David Johnson, CD, MVPOwnerCommented:
That is the reason and isn't it reason enough? It's your call..
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.