[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 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: 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):
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: 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:
Got the following error:
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
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 | |
| Comment by Jonathan DeStefano [ 20/Apr/18 ] | |
|
Hi Ivan, Thanks for filing this ticket. Some questions:
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:
Thanks for the feedback, we'll review and update according.
|