Hi, I'm seeing Authorization Failure trying with MongoDB using read-only account on non-default database. Note: It works using "super" credentials

source:
  type: "mongodb"
  config:
    connect_uri: "<mongodb://my.hostname:27017/mydb>"
    username: "readonly"
    password: "readonly"
    env: "DEV"
    authMechanism: "DEFAULT"
    options:
      tls: True
      tlsCAFile: "/path/to/my.pem"

I suspect the account can't access the "default" database, but putting database on the uri didn't help. Any suggestions?

We’re not doing anything fancy in our source - just using the pymongo library under the hood: https://github.com/linkedin/datahub/blob/master/metadata-ingestion/src/datahub/ingestion/source/mongodb.py#L326-L347

Hi, Yes it worked with this script:

from pymongo import MongoClient
from pprint import pprint
import urllib.parse
username = urllib.parse.quote_plus('readonly')
password = urllib.parse.quote_plus('readonly')
uri = 'mongodb://' + username + ':' + password + '@my.hostname:27017/mydb?tls=true&tlsCAFile=/path/to/my.pem'
client = MongoClient(uri)
db = client.student
pprint(db.my_collection.find_one())

Nice