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

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

    XMLWordPrintableJSON

Details

    • Task
    • Status: Closed
    • Major - P3
    • Resolution: Won't Fix
    • 3.4.0
    • None
    • BI Connector
    • None
    • Mac OS
    • KANBAN BUCKET
    • true

    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

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved:
              5 years, 32 weeks, 4 days ago