drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andries Engelbrecht <aengelbre...@maprtech.com>
Subject Re: mongodb authentication problem
Date Tue, 31 Mar 2015 15:19:25 GMT
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 <darrellwang74@gmail.com> 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:test@192.168.170.136: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 ?


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message