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)
