Uploaded image for project: 'Documentation'
  1. Documentation
  2. DOCS-10508

No information on BI connector v2.2-rc0 connection using MySQL Workbench

    • Type: Icon: Task Task
    • Resolution: Won't Fix
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 3.4.0
    • Component/s: BI Connector
    • Labels:
      None
    • Environment:
      Mac OS

      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

            Assignee:
            steve.renaker@mongodb.com Steve Renaker (Inactive)
            Reporter:
            mythreyis Mythreyi A Solai
            Votes:
            0 Vote for this issue
            Watchers:
            9 Start watching this issue

              Created:
              Updated:
              Resolved:
              6 years, 36 weeks, 2 days ago