[DOCS-11638] Update for MySQL Connector/ODBC 8.0.11 - Tableau & C Auth Created: 20/Apr/18  Updated: 29/Oct/23  Resolved: 27/Apr/18

Status: Closed
Project: Documentation
Component/s: BI Connector
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Major - P3
Reporter: Ivan Grigolon Assignee: Jeffrey Allen
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

???


Participants:
Days since reply: 5 years, 41 weeks, 5 days ago
Story Points: 0.5

 Description   

There are a couple of problem with the current documentation:

1. Connect From Tableau, under prerequisite, the link "The MySQL ODBC driver" will lead you to install the default GA version 8.0.11 of the MySQL Connector/ODBC. This has been tested as not working, so we should specify to click on "Looking for previous GA versions?" and download version 5.3.10 of the Connector/ODBC which is tested as working. Also, instead of saying "The MySQL ODBC driver" can we use the name "MySQL Connector/ODBC" to generate less confusion?

2. Under Install the C Authentication Plugin, the docs say to install the MySQL 5.7.x installer. Would be better to link to both the "MySQL Connector/ODBC" and the "My SQL shell" for simplicity? The installer has other options/components that are not necessary.



 Comments   
Comment by Jeffrey Allen [ 27/Apr/18 ]

Updated based on outlined suggestions. Changes deployed.

Comment by Ivan Grigolon [ 26/Apr/18 ]

jonathan.destefano, in regards to your comment:

I recommend we also restrict users to MySQL Community Server 5.7.x as well.

I have seen in the past many customers confused with the words “MySQL Community Server”, especially the server word. As far as I know MySQL server is not needed, only mysql shell and/or the ODBC Connector are needed. If this is correct I would avoid using the "Server" word. I have seen that this part of the documentation has been already changed last week from:
"Download the MySQL 5.7.x installer and install the MySQL Community Server, which includes the MySQL shell."
to the current:
"Download the MySQL 5.7.x installer. The required product to install depends on your connection method:"

This is also the reason I did recommend my point 2 in the description of this case.

Comment by Jonathan DeStefano [ 25/Apr/18 ]

Thanks Wisdom, the mysql.exe process stopped working.

Comment by Adinoyi Omuya [ 25/Apr/18 ]

What process stopped working?

The updates sgtm.

The JDBC plugin is for JDBC which is different from ODBC - it's only useful for applications that support JDBC. I don't think that's relevant here.

Comment by Jonathan DeStefano [ 25/Apr/18 ]

I tried using the auth plugin with the mysql command line utility v8.0.11 (mysql.exe, not mysqlsh.exe):

C:\>mysql --host localhost --port 3307 --user='jonadmin?source=admin' --default-auth=mongosql_auth --plugin-dir="C:\Program Files\MySQL\MySQL Server 5.7\lib\plugin" -p

I was prompted for my password, saw a connection logged by mongosqld and then the process stopped responding. I recommend we also restrict users to MySQL Community Server 5.7.x as well.

Suggested docs updates:

Some of these docs updates are temporary as we'll be advising the MongoDB ODBC driver in most cases soon.

I have not used the JDBC plugin, should we advise the same? adinoyi.omuya ryan.chipman

Comment by Jonathan DeStefano [ 25/Apr/18 ]

Update the link to:
https://dev.mysql.com/downloads/connector/odbc/5.3.html

Consider putting a note or important admonition that the BIC is only compatible with the MySQL Connector/ODBC version 5.3.x.

The following pages will need to be updated:

Comment by Jeffrey Allen [ 24/Apr/18 ]

ivan.grigolon, adinoyi.omuya, my apologies - I had not properly configured my mongosqld instance and was bypassing the plugin entirely. Now that I have everything properly set up I am in fact running into the same issues. Sorry for all the back and forth confusion. I think it would be best as suggested above to update the links to 5.3.

Comment by Jonathan DeStefano [ 24/Apr/18 ]

I was able to reproduce on the following setup:

  • Windows 10 Enterprise 64bit
  • MongoDB 3.6.4
  • BI Connector 2.4.1
  • 64 bit C Auth Plugin

Got the following error:

[MySQL][ODBC 8.0(w) Driver]ssl is required when using cleartext authentication

I suggest we advise to use 5.3 until the MongoDB ODBC driver is released and the named Tableau connector is updated.

Comment by Ivan Grigolon [ 24/Apr/18 ]

Ok, this is really interesting indeed. I have tried the same using:

Using Connector ODBC 5.3 it just work fine.

Using Connector ODBC 8.0 it doesn't work. I receive the error

"Authentication plugin `mongosql_auth` cannot be loaded: The specified module could not be found" 

That is at the first attempt to connect. If I click connect a second time using the same configuration that failed the first time the error log changes and I am prompted the usual error "SSL is required when using cleartext auth...." indicating that the plugin is not used as indicated in the first attempt.

I tried installing and un-installing the C plugin and the ODBC drivers and always obtained the same results. jeffrey.allen do you see any difference in what I am doing from your repro?

Comment by Adinoyi Omuya [ 23/Apr/18 ]

Interesting. I wasn't able to connect using that so perhaps I had something amiss in the environment I was testing on.

Comment by Jeffrey Allen [ 23/Apr/18 ]

I was using the C auth plugin and a named connector

Comment by Adinoyi Omuya [ 23/Apr/18 ]

Yeah, jeffrey.allen were you able to connect to mongosqld using the authentication plugin?

Comment by Ivan Grigolon [ 23/Apr/18 ]

I tested this in Windows Server 2012 and 2016 64-bit, Tableau 10.5, BIC 2.4.1, no SSL, just the auth plugin, MongoDB 3.6.latest

jeffrey.allen, did you use the named connector or did you configure the DNS? (it shouldn't make a difference).

adinoyi.omuya might also have some context here.

Comment by Jeffrey Allen [ 20/Apr/18 ]

Hi ivan.grigolon, I wasn't able to reproduce your first issue using a Windows 10 7 VM. Using the latest ODBC Driver, 8.0.11, I was able to use Tableau to connect to a mongosqld instance both with and without auth. Can you elaborate on the issues you were experiencing and the error messages received, if any?

Comment by Jonathan DeStefano [ 20/Apr/18 ]

Hi Ivan,

Thanks for filing this ticket. Some questions:

  • What operating system are you using?
  • What version of Tableau are you running?
  • BI Connector version?
  • Are you using SSL, or just the auth plugin?

Interesting timing, it looks like GA version 8.0.11 was just released on 4/19. Previously we encouraged people to download the full installer and pick components for the reasons:

  • I think that Linux and macOS did not have separate ODBC connector installers or it was easier to install the C Auth Plugin because without the server users would have to create the plugin dir and set path variables (which are set by the installer)
  • The MySQL Shell standalone (mysqlsh.exe on windows) is quite different than mysql.exe from the full installer. mysqlsh can not use authentication plugins.

Thanks for the feedback, we'll review and update according.

  • Jon
Generated at Thu Feb 08 08:03:18 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.