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

Unable to connect to BI connector using Tableau 10.3

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Done
    • Affects Version/s: 3.4.7
    • Fix Version/s: None
    • Component/s: BI Connector
    • Labels:
      None
    • Last comment by Customer:
      true
    • Story Points:
      0.1
    • Sprint:
      KANBAN BUCKET

      Description

      1. *mongosqld.conf file:*

      systemLog:

        path: '/mongo/mongodb-bi-2.4.1/logs/mongosqld.log'

      net:

        bindIp: '127.0.0.1'

        port: 3307

      mongodb:

        net:

             uri: '<hostname>:27018'

      -----------------------------

      2. My mongosqld command:

      sudo ./mongosqld --config /mongo/mongodb-bi-2.4.1/conf/mongosqld.conf --auth --mongo-username=<admin username> --mongo-password=<admin password> &

      3. mongosqld.log contents:

      2018-05-04T11:35:43.768-0400 I CONTROL    [initandlisten] mongosqld starting: version=v2.4.1 pid=28515 host=<hostname>

      2018-05-04T11:35:43.768-0400 I CONTROL    [initandlisten] git version: 7b3bd0d6cbe0bf9769ee63e100f3699f0c810855

      2018-05-04T11:35:43.768-0400 I CONTROL    [initandlisten] OpenSSL version OpenSSL 1.0.0-fips 29 Mar 2010 (built with OpenSSL 1.0.1e 11 Feb 2013)

      2018-05-04T11:35:43.768-0400 I CONTROL    [initandlisten] options: {config: "/mongo/mongodb-bi-2.4.1/conf/mongosqld.conf", systemLog:

      {path: "/mongo/mongodb-bi-2.4.1/logs/mongosqld.log"}

      , security: {enabled: true}, mongodb: {net: {uri: "<hostname>:27018", auth: {username: "superadmin", password: "<protected>", source: "admin"}}}}

      2018-05-04T11:35:43.770-0400 I NETWORK    [initandlisten] waiting for connections at 127.0.0.1:3307

      2018-05-04T11:35:43.770-0400 I NETWORK    [initandlisten] waiting for connections at /tmp/mysql.sock

      2018-05-04T11:35:43.770-0400 I SAMPLER    [schemaDiscovery] initializing schema

      2018-05-04T11:35:43.800-0400 I SAMPLER    [schemaDiscovery] sampling MongoDB for schema...

      2018-05-04T11:43:53.459-0400 I SAMPLER    [schemaDiscovery] mapped schema for 279 namespaces: 

      I followed the instructions in https://docs.mongodb.com/bi-connector/master/connect/tableau/#connect-from-tableau-with-the-c-authentication-plugin to connect from Tableau 10.3 but I get an error (please see attached). Please let me know how to resolve this issue.  

        Attachments

          Activity

            People

            Assignee:
            jonathan.destefano Jonathan DeStefano
            Reporter:
            mythreyi.solai@fmc-na.com Mythreyi Solai
            Participants:
            Last commenter:
            Jonathan DeStefano Jonathan DeStefano
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since reply:
              3 years, 38 weeks ago
              Date of 1st Reply: