[jira] [Created] (DRILL-6996) Unauthorized command execution error received for Mongo

["Kris Dalpiaz (JIRA)" <ji...@apache.org>]

Kris Dalpiaz created DRILL-6996:
-----------------------------------

             Summary: Unauthorized command execution error received for Mongo
                 Key: DRILL-6996
                 URL: https://issues.apache.org/jira/browse/DRILL-6996
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - MongoDB
    Affects Versions: 1.15.0
         Environment: Running in embedded mode.

Storage:

{
 "type": "mongo",
 "connection": "mongodb://[user]:[pass]@[host1]:[port1],[host2]:[port2],[host3]:[port3]/[db]?authMechanism=SCRAM-SHA-1&ssl=true&replicaSet=[set]",
 "enabled": true
}

Query: 

SELECT _id FROM  [storage].[db].[collection];

Error:

Error: SYSTEM ERROR: MongoCommandException: Command failed with error 13 (Unauthorized): 'not authorized on [db] to execute command \{ count: "[collection]", query: {} }' on server [host1]:[port1]. The full response is { "ok" : 0.0, "errmsg" : "not authorized on [db] to execute command \{ count: \"[collection]\", query: {} }", "code" : 13, "codeName" : "Unauthorized" }

Successful Robo command:

db.runCommand({
 count: "[collection]",
 query: {}
})
            Reporter: Kris Dalpiaz


We recently upgraded from 1.13 to 1.15 for the support of Decimal128 between Drill and some of our Mongo dbs. We are now receiving a MongoCommandException error when trying to query a Mongo db. No auth settings have been changed for the previously working login, and the same login is able to execute the command through Robo 3T.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)