[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:
./bin/mongosqld --schemaDirectory=drdl/ -vvvvv --mongo-uri=mongodb://hal-mongo-d01:27018/ --auth --addr=0.0.0.0:3307 --logPath=/mongo/bi-beta/logs/bi.log &

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.

Generated at Thu Feb 08 08:00:43 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.