GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Connecting to Linux DB Server from MS Access Using ODBC. User Security Question

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Connecting to Linux DB Server from MS Access Using ODBC. User Security Question

    I am helping out a charity. They want to connect there MS Access 2003 and Access 2010 to MySQL. Because the Microsoft Licence combination are to expensive. I have Setup a Linux MySQL Community Edition and converted all the Tables, Views and Stored Procedures to from MSSQL to MySQL. Access connects nicely to MySQL using the ODBC Connecter we can connect to the server.

    However the problem lies the Windows AD User Credentials is not recognised and not passed to the MySQL Server.

    Is there an add-on for Percona MySQL Server that will allow it to recognised Windows AD User Credentials. There is one for Oracle MySQL Enterprise but have not been able to find any information on how to set it up. Also it is not available for the Community Edition

    So was thinking of suggesting to the Charity to change to Percona MySQL if the following:
    1 - Percona Linux MySQL Server had a add-on that would a allow it to use the Windows AD User Credentials of the connecting user.
    2 - Is there were instructions on how to setup the add-on.

    Now I will admit I'm a developer and not an Engineer. So please excuse if some of my terms and jargon is not correct. If any one can help or provide links to articales that would be much help.

    Thank You
    Last edited by Jackson; 03-25-2014, 03:59 PM.

  • #2
    Hi Jackson,

    If you want to use the active directory for MySQl authentication you'll need to go the PAM route to do so.

    Percona Server comes bundled with a PAM authentication module: http://www.percona.com/doc/percona-pam-for-mysql/

    Youll need to enable the plugin, create a configuration file in /etc/pam.d/mysqld which contains configuration to differ authentication to your AD

    Some resources on this subject:

    http://technet.microsoft.com/en-us/m....12.linux.aspx
    https://wiki.archlinux.org/index.php...onfiguring_PAM

    Finally as per the documentation for the plugin the GRANTs for a user will still need to be maintained within mySQL http://www.percona.com/doc/percona-p...reating-a-user (note the pam file example on this page is for local use authentication not AD / LDAP).

    I hope this aids in bringing Active Directory integration to your deployment.

    Cheers

    David



    Comment

    Working...
    X