Uploaded image for project: 'MariaDB Connector/ODBC'
  1. MariaDB Connector/ODBC
  2. ODBC-23

ODBC driver does not include dialog.dll

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 3.1.0
    • General
    • None

    Description

      ODBC does not include dialog.dll which is required to connect with a user that is authenticating via pam. Connector included it, but ODBC does not. Can it be added? I tried pointing to the dialog.dll that was installed with connector, but that did not work. Any assistance or guidance for a work around would be appreciated.

      Attachments

        Activity

          Lawrin Lawrin Novitsky added a comment - - edited

          Thank you for your report!

          No, we can't bundle all connector/c plugins with c/odbc, and not gonna do that. But this is still a valid bug. We will add connector string option for plugins directory.

          The workaround for the problem can be using of MARIADB_PLUGIN_DIR environment variable for the same purpose.

          Lawrin Lawrin Novitsky added a comment - - edited Thank you for your report! No, we can't bundle all connector/c plugins with c/odbc, and not gonna do that. But this is still a valid bug. We will add connector string option for plugins directory. The workaround for the problem can be using of MARIADB_PLUGIN_DIR environment variable for the same purpose.
          lstaiman Lori Staiman added a comment -

          Hi! Thanks for the reply. I am curious why the dialog.dll is included with Connector, but can't be with ODBC? The problem I am trying to solve is using pam authentication from windows clients to CentOS dataservers. Without a correct dialog.dll, tools like workbench and toad can't connect so I end up limited to Heidi.

          I am happy to use the MARIADB_PLUGIN_DIR any guidance how I get to the right version? I installed MariaDB 5.5 as well as ODBC and Connector on my windows workstation, and I don't have a dialog.dll in c:\program files (x86)\MariaDB5.5\lib\plugin. I can't find any documentation pointing me to instructions or downloads.

          Thanks again for the assistance.

          lstaiman Lori Staiman added a comment - Hi! Thanks for the reply. I am curious why the dialog.dll is included with Connector, but can't be with ODBC? The problem I am trying to solve is using pam authentication from windows clients to CentOS dataservers. Without a correct dialog.dll, tools like workbench and toad can't connect so I end up limited to Heidi. I am happy to use the MARIADB_PLUGIN_DIR any guidance how I get to the right version? I installed MariaDB 5.5 as well as ODBC and Connector on my windows workstation, and I don't have a dialog.dll in c:\program files (x86)\MariaDB5.5\lib\plugin. I can't find any documentation pointing me to instructions or downloads. Thanks again for the assistance.

          I think you need to install Connector/C (v.2.2) It comes with plugins. But your in your initial report you said you did that, but it did not work with dialog.dll that came with it.
          Workbenh uses MySQL C/C++, so MARIADB_PLUGIN_DIR won't help you with the Workbench. Not sure about Toad. Perhaps they both have some standard place for plugins, like Heidi does. But why do you need c/odbc with workbench and heidi?

          Lawrin Lawrin Novitsky added a comment - I think you need to install Connector/C (v.2.2) It comes with plugins. But your in your initial report you said you did that, but it did not work with dialog.dll that came with it. Workbenh uses MySQL C/C++, so MARIADB_PLUGIN_DIR won't help you with the Workbench. Not sure about Toad. Perhaps they both have some standard place for plugins, like Heidi does. But why do you need c/odbc with workbench and heidi?
          lstaiman Lori Staiman added a comment -

          I am trying to convert to pam authentication, and when I tested connectivity from windows applications that need to use a system DSN need a dialog.dll to successfully connect. So workbench, toad, as well as internal applications in C#, java, etc all throw an error can't find dialog.dll. If I try to setup a system DSN entry and test it, it can't find dialog.dll. My thought was if I could resolve the issue with DSN entries which are odbc based I would be able to sort out anything else that was still having a problem.

          lstaiman Lori Staiman added a comment - I am trying to convert to pam authentication, and when I tested connectivity from windows applications that need to use a system DSN need a dialog.dll to successfully connect. So workbench, toad, as well as internal applications in C#, java, etc all throw an error can't find dialog.dll. If I try to setup a system DSN entry and test it, it can't find dialog.dll. My thought was if I could resolve the issue with DSN entries which are odbc based I would be able to sort out anything else that was still having a problem.

          Since C/C is now a sub-project, I guess it's the right time to eventually include those plugins into package(s)

          Lawrin Lawrin Novitsky added a comment - Since C/C is now a sub-project, I guess it's the right time to eventually include those plugins into package(s)

          Since ODBC-167, we do not need to include C/C plugins into linux packages. Thus I'm closing the issue.
          The fix has been pushed into 3.1(develop) branch as 077f001

          Lawrin Lawrin Novitsky added a comment - Since ODBC-167 , we do not need to include C/C plugins into linux packages. Thus I'm closing the issue. The fix has been pushed into 3.1(develop) branch as 077f001

          People

            Lawrin Lawrin Novitsky
            lstaiman Lori Staiman
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.