drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ernesto Valero (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-5212) MongoDB Storage Plugin permissions using MongoDB Plugin
Date Mon, 23 Jan 2017 12:44:26 GMT
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)

Mime
View raw message