Trouble connection string in mongosqld config files when setting up BI connector

Ricky_Ricky · 2024-07-22T11:04:23.550Z

I have a standard connection string that works fine on compass but does not work in the mongosql config file, as it keep producing “–mongo-uri may not contain any authentication information”.

My connection string looks like this mongodb://myusername:mypassword@:27017/?authMechanism=SCRAM-SHA-256&authSource=myusername.
I have tried authsource=admin as well, still does not work.

Am I missing some specific configurations?

chris · 2024-07-23T23:57:13.852Z

If using a configuration file check the example:
https://www.mongodb.com/docs/bi-connector/current/reference/mongosqld/#mongodb-host-options

The auth: section is where that information is added.

If using command line options:
--mongo-username <username>, -u <username>
--mongo-password <password>, -p <password>
--mongo-authenticationSource <auth-db-name>
--mongo-authenticationMechanism <authMechanism>

Ricky_Ricky · 2024-07-25T12:02:53.521Z

Still does not work, is the BI connector working for MongoDB 4.4.27 Community? Do I need to upgrade for the enterprise version?

chris · 2024-07-25T13:49:08.571Z

Yes it an enterprise tool that required MongoDB Enterprise and a subscription agreement.

Some limited use is available without an subscription agreement.

image743×316 38.9 KB

system · 2024-07-30T13:50:07.799Z

This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.