[DOCS-10508] No information on BI connector v2.2-rc0 connection using MySQL Workbench Created: 11/Jul/17 Updated: 14/Nov/17 Resolved: 15/Aug/17 |
|
| Status: | Closed |
| Project: | Documentation |
| Component/s: | BI Connector |
| Affects Version/s: | 3.4.0 |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major - P3 |
| Reporter: | Mythreyi A Solai | Assignee: | Steve Renaker (Inactive) |
| Resolution: | Won't Fix | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
Mac OS |
||
| Participants: | |
| Days since reply: | 6 years, 26 weeks, 1 day ago |
| Description |
|
I am able to connect to the BI connector 2.2rc0 via Tableau 10.3 and MySQL client (using the command ./mysql --protocol=tcp --port=3307 --host=hal-mongo-d01 -u 'fkcfhirjpauser?mechanism=SCRAM-SHA-1&source=fkcfhirjpa' --default-auth=mongosql_auth --plugin-dir=/Users/Z00356908/Desktop/DEVHOME/POC/MySQLAuthPlugin/mongosql-auth-osx-x86_64/lib -p) but I do not know how to connect to MySQL Workbench. I have the plugin mongosql_auth.so in the plugin directory and have specified default_auth=default-auth=mongosql_auth in /etc/my.cnf file. My mongosqld command is as follows: This is the error message I get in the logs- handshake error: ERROR 1043 (08S01): error performing authentication: ERROR 1759 (HY000): ssl is required when using cleartext authentication |
| Comments |
| Comment by Steve Renaker (Inactive) [ 15/Aug/17 ] |
|
MySQL Workbench will be included in future work to detail instructions for connecting with other SQL clients, currently begun at https://docs.mongodb.com/bi-connector/master/tutorial/using-the-bi/ |
| Comment by Ryan Chipman [ 12/Jul/17 ] |
|
Hello! Apologies for any confusion – you most certainly can connect to the BI Connector using MySQL Workbench. What MySQL Workbench is unable to do is to connect directly to the BI Connector using the mongosql_auth plugin. However, you should still be able to connect to the BI Connector with MySQL's cleartext authentication plugin and SSL enabled (i.e. the same way that one would connect with BI Connector v2.1) |
| Comment by Mythreyi A Solai [ 12/Jul/17 ] |
|
Does it mean I would not be able to connect to MySQL Workbench using BI connector? |
| Comment by Steve Renaker (Inactive) [ 12/Jul/17 ] |
|
In the BI Connector documentation we have instructions for connecting with the MySQL client and with Tableau, but no other tools. My plan is to add a new section to the "Connecting to the MongoDB Connector for BI" page (mentioned above) near the bottom to the effect that there are many other client tools available, such as MySQL Workbench, SQirreL SQL client, DBeaver, and so on, and that some may work with a third-party ODBC manager (such as iODBC), but others may not. Seems kind of vague, but maybe better than nothing? Correction: we also have instructions for connecting with Atlas. |