Mongodb bi connector won't start with readAnyDatabase role

Hello all,

i’ve installed the mongodb bi connector on my replset. with this config :

systemLog:
path: ‘/var/log/mongosqld.log’
verbosity: 2
net:
bindIp: ‘0.0.0.0’
port: 3307
ssl:
mode: “disabled”
mongodb:
net:
uri: “mongodb://srv1:27017,srv2:27017”
auth:
username: mongosqld
password: xxxxxxxxxxxxx
source: admin
mechanism: “SCRAM-SHA-256”
security:
enabled: true

When i start it with readAnyDatabase role, it fails to initialize the schema with this error :

[manager] error initializing schema: error sampling collection: error running aggregation: (Location40601) $out can only be the final stage in the pipeline

If i grant my user the readWriteAnyDatabase, it starts.

The doc only says that the user needs the readAnyDatabase role, nothing else.

Am I missing something?

Thanks.

I’m still stuck with this issue, any help welcome.

I am also having the same issue!

I finally found the raeson : some db had views that weren’t compatible with the tools. Removing them fixed the issue.

1 Like

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