[DOCS-11674] Unable to connect to BI connector using Tableau 10.3 Created: 07/May/18  Updated: 07/May/18  Resolved: 07/May/18

Status: Closed
Project: Documentation
Component/s: BI Connector
Affects Version/s: 3.4.7
Fix Version/s: None

Type: Task Priority: Major - P3
Reporter: Mythreyi Solai Assignee: Jonathan DeStefano
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File Screen Shot 2018-05-07 at 10.59.14 AM.png    
Participants:
Days since reply: 5 years, 40 weeks, 2 days ago
Story Points: 0.1

 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.  



 Comments   
Comment by Jonathan DeStefano [ 07/May/18 ]

This ticket has been migrated to support. Please reference support ticket 00494427.

Thanks & Regards,
Jon

Comment by Jonathan DeStefano [ 07/May/18 ]

Hi mythreyi.solai@fmc-na.com,

Thanks for filing a DOCS ticket. Upon first glance it looks like your BI Connector mongosqld is running on 127.0.0.1 (localhost) but your Tableau connection (from the screenshot) is pointing to a different remote host, possibly the MongoDB deployment?

The error looks more like a connection error than an authentication error, so please try the following:

  • On the Tableau "MongoDB BI Connector" screen, set server to 127.0.0.1. This will ensure Tableau is pointing to your locally running mongosqld and not your MongoDB deployment.

If this still does not work let's confirm the authenticating user (from Tableau screen) has sufficient privileges and can connect to the MongoDB deployment via the mongo shell and query one of the namespaces in the "mapped schema" from the log.

mongo --host <mongodb-hostname> --port <mongodb-port> --username <user-from-screenshot> --password <password-from-screenshot> --authenticationDatabase <database-from-screenshot>

Regards,
Jon
MongoDB Docs Team

Comment by Ravind Kumar (Inactive) [ 07/May/18 ]

Hello mythreyi.solai@fmc-na.com

Thank you for filing a ticket on the MongoDB BI connector. I've redacted some additional information from what you provided to remove potentially sensitive information, such as hostnames and schema patterns. We have retained this data as a protected comment, so our engineers can still see it. Please note that the MongoDB DOCS project is a public-facing project. Our engineers can advise you of secure methods for transmitting log information.

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