Ernesto Valero created DRILL-5212: ------------------------------------- Summary: MongoDB Storage Plugin permissions using MongoDB Plugin Key: DRILL-5212 URL: https://issues.apache.org/jira/browse/DRILL-5212 Project: Apache Drill Issue Type: Improvement Components: Documentation Environment: We have a replica set configured with authentication enabled. From a client we try to connect Apache Drill to our replica set with MongoDB connection uri passing user and password it doesn't show any information with a user with readWrite role. Reporter: Ernesto Valero Priority: Minor
When you try to connect to a MongoDB storage with authentication enabled using a user with readWrite roles, Apache Drill doesn't works. To solve this scenario, Apache Drill user must have the role 'readAnyDatabase' because it use MongoDB command 'listDatabases'. It could be very useful to include this in MongoDB Storage Plugin in order to solve the same issue to other users. Firstly, create MongoDB user: {quote} use admin db.createUser(\{"user":"ApacheDrill, ... ... ... "pwd":"ApacheDrill123", ... ... ... "roles": [ ... \{ "role" :"readAnyDatabase", "db":"admin"}]}) {quote} Then connect to your mongodb instance: {quote} mongodb://ApacheDrill:ApacheDrill123@host1\[:port1]\[,host2\[:port2\],...\[,hostN\[:portN\]\]\]\[/admin?rs=replicaSet=ReplicasetName {quote} -- This message was sent by Atlassian JIRA (v6.3.4#6332)