[ODBC-23] ODBC driver does not include dialog.dll Created: 2015-05-21  Updated: 2018-11-06  Resolved: 2018-10-09

Status: Closed
Project: MariaDB Connector/ODBC
Component/s: General
Affects Version/s: None
Fix Version/s: 3.1.0

Type: Task Priority: Major
Reporter: Lori Staiman Assignee: Lawrin Novitsky
Resolution: Fixed Votes: 1
Labels: 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.

 Comments   
Comment by Lawrin Novitsky [ 2015-09-14 ]

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.

Comment by Lori Staiman [ 2015-09-14 ]

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.

Comment by Lawrin Novitsky [ 2016-01-27 ]

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?

Comment by Lori Staiman [ 2016-01-27 ]

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.

Comment by Lawrin Novitsky [ 2018-07-05 ]

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

Comment by Lawrin Novitsky [ 2018-10-09 ]

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

Generated at Thu Feb 08 03:25:40 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.