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

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

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Won't Fix
    • Affects Version/s: 3.4.0
    • Fix Version/s: None
    • Component/s: BI Connector
    • Labels:
      None
    • Environment:
      Mac OS
    • Last comment by Customer:
      true
    • Sprint:
      KANBAN BUCKET

      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

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

              Dates

              Created:
              Updated:
              Resolved:
              Days since reply:
              4 years, 23 weeks, 1 day ago
              Date of 1st Reply: