Connector for BI / mongosqld authentication issue

Working with Data Connectors & Integrations
1

Hello community,

We’ve installed Connector for BI (Mongosqld) and are running into what I hope is a simple issue.

We are connecting to target MongoDB and are successfully sampling data. The process fails while trying to insert schema to local mongosqld_data. the error message is:

2021-11-30T11:47:05.711-0700 W SCHEMA [manager] error initializing schema: error inserting document(s): (Unauthorized) not authorized on mongosqld_data to execute command { insert: "schemas", writeConcern: { w: "majority" }, $db: "mongosqld_data" }

Does anyone have guidance on how to correct this issue?

Thanks,
Steve

Full log file:

H:\>  "C:\Program Files\MongoDB\Connector for BI\2.14\bin\mongosqld.exe" --config "C:\Users\johnson.steve\mongodb\mongosqld.conf"
2021-11-30T11:47:04.518-0700 I CONTROL    [initandlisten] mongosqld starting: version=v2.14.4 pid=29052 host=US-LAPTOP-XXX
2021-11-30T11:47:04.522-0700 I CONTROL    [initandlisten] git version: df0cf0b57e9aac0ab6d545eee0d4451d11d0c6e9
2021-11-30T11:47:04.522-0700 I CONTROL    [initandlisten] OpenSSL version OpenSSL 1.0.2n-fips  7 Dec 2017 (built with OpenSSL 1.0.2s  28 May 2019)
2021-11-30T11:47:04.522-0700 I CONTROL    [initandlisten] options: {config: "C:\\Users\\johnson.steve\\mongodb\\mongosqld.conf", systemLog: {verbosity: 1}, schema: {sample: {namespaces: [gamotdb.CUSTID0016*]}, stored: {mode: "auto", source: "mongosqld_data", name: "mySchema"}}, security: {enabled: true}, mongodb: {net: {uri: "mongodb://targetsystem:27017", auth: {username: "my_username", password: "<protected>", source: "sourcedb"}}}}
2021-11-30T11:47:04.528-0700 I SCHEMA     [manager] attempting to initialize schema
2021-11-30T11:47:04.528-0700 I SCHEMA     [manager] sampling schema
2021-11-30T11:47:04.528-0700 I NETWORK    [initandlisten] waiting for connections at 127.0.0.1:3307
2021-11-30T11:47:04.645-0700 I SCHEMA     [sampler] sampling MongoDB for schema...
2021-11-30T11:47:05.680-0700 I SCHEMA     [sampler] mapped schema for 2 namespaces: "sourcedb" (2): ["CUSTID0016MasterTrackerOrders", "CUSTID0016SiteDetailsData"]
2021-11-30T11:47:05.680-0700 I SCHEMA     [manager] persisting schema

2021-11-30T11:47:05.711-0700 W SCHEMA     [manager] error initializing schema: error inserting document(s): (Unauthorized) not authorized on mongosqld_data to execute command { insert: "schemas", writeConcern: { w: "majority" }, $db: "mongosqld_data" }
2 Likes
2

I have the same issue.

3

Got it working with this config:

security:
  enabled: true
 
mongodb:
  net:
    uri: localhost:27017
    auth:
      username: "db_user"
      password: "..."
      source: "my_auth_db"
 
net:
  bindIp: 0.0.0.0
  port: 3307

 
processManagement:
  service:
    name: mongosqld
    displayName: mongosqld
    description: "BI Connector SQL proxy server"

And executing the mongosqld.exe with this command:
mongosqld.exe --config "C:\Program Files\MongoDB\Connector for BI\2.14\example-mongosqld-config.yml"