I'm trying to come up with a plan to allow users to auth with a MySQL database (many, actually) using LDAP. More specifically, ActiveDirectory. Database will likely be accessed through applications, not web. What are my options? EDIT: Okay. It seems that there is no "official" way to allow authentication on MySQL using LDAP. What other options exist? Can we synchronize LDAP users and passwords to the MySQL user table?

this is possible with mysql proxy. there's a few things you need to know to make this work: <ul> <li>mysql proxy can execute shell commands</li> <li>mysql proxy can intercept and rewrite authentication</li> </ul> these two pages will help you get started: <ul> <li>example of running a shell command: http://forge.mysql.com/tools/tool.php?id=79 </li> <li>example of intercepting and rewriting authentication: http://web.archive.org/web/20150329071023/http://jan.kneschke.de/2009/6/25/mysql-proxy-roles/ </li> </ul>

Using LDAP (AD) for MySQL authentication

Tags:

I'm trying to come up with a plan to allow users to auth with a MySQL database (many, actually) using LDAP. More specifically, ActiveDirectory. Database will likely be accessed through applications, not web. What are my options?

EDIT:

Okay. It seems that there is no "official" way to allow authentication on MySQL using LDAP. What other options exist? Can we synchronize LDAP users and passwords to the MySQL user table?

750

asked Aug 25 '09 18:08

snicker

1 Answers

this is possible with mysql proxy. there's a few things you need to know to make this work:

mysql proxy can execute shell commands
mysql proxy can intercept and rewrite authentication

these two pages will help you get started:

example of running a shell command: http://forge.mysql.com/tools/tool.php?id=79
example of intercepting and rewriting authentication: http://web.archive.org/web/20150329071023/http://jan.kneschke.de/2009/6/25/mysql-proxy-roles/

answered Oct 19 '22 06:10

longneck

Related questions
                            
                                How to cache content in UIWebView for faster loading later on?
                            
                                External output folder in eclipse
                            
                                Where is stdbool.h?
                            
                                Linking against Apple frameworks with gcc
                            
                                jQuery $.ajax() function's error message source
                            
                                Best way to call Haskell functions from within Java
                            
                                Will Java app slow down by presence of -Xdebug or only when stepping through code?
                            
                                Calling the overridden method from the base class in C#
                            
                                HTML5: dragover(), drop(): how get current x,y coordinates?
                            
                                Detect when multiple enum items map to same value
                            
                                How many activities should I use? [closed]
                            
                                If the address of a function can not be resolved during deduction, is it SFINAE or a compiler error?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With