See the following links. http://drill.apache.org/blog/2014/11/19/sql-on-mongodb/
https://issues.apache.org/jira/browse/DRILL-1502 —Andries On Mar 31, 2015, at 2:24 AM, Wang Darrell <[email protected]> wrote: > Is there anyone who tried to connect drill to mongodb with --auth. > > When I started my mongo with auth. > drill can't do any query. > > My mongodb version is 2.6.9 > > here is the mongodb admin user information > > db.createUser({ > user:"test", > pwd :"test", > roles:[{ > role : "readAnyDatabase" , db:"admin" > }] > > }) > > I just want the user can query data that just need "read" permission. > > here is the drill storage config > > { > "type": "mongo", > "connection":"mongodb://test:[email protected]:27017/", > "enabled": true > } > > Then it just keep return this error > CommandFailureException: { "serverUsed" : "192.168.170.136:27017" , "ok" : > 0.0 , "errmsg" : "not authorized on admin to execute command { > listDatabases: 1 }" > > don't know where is the problem. I tried mongo shell and robomongo , they > all can login with this account and query the data. > > I find a similar problem with this > https://issues.apache.org/jira/browse/DRILL-1502?jql=text%20~%20%22mongo%20auth%22 > > Is the mongo user permission went wrong ?
