[jira] [Created] (DRILL-5212) MongoDB Storage Plugin permissions using MongoDB Plugin

["Ernesto Valero (JIRA)" <ji...@apache.org>]

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)