You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Wang Darrell <da...@gmail.com> on 2015/04/01 07:40:02 UTC

Re: mongodb authentication problem

Thanks for your answer ,

I tried both two links and still having the same error ,

CommandFailureException: { "serverUsed" : "192.168.170.136:27017" , "ok" :
0.0 , "errmsg" : "not authorized on admin to execute command {
listDatabases: 1 }"

my mongodb storage config
{
  "type": "mongo",
  "connection":"mongodb://test:test@192.168.170.136:27017/",
  "enabled": true
}

I am sure this test/test mongodb user can read and listDatabases ( tried it
in mongo shell ) .
Therefore , I still can't get it why drill just keep returning this error
message .

If it won't bother , can anyone share your experience with connecting
mongodb with security ?

What is the exact role the mongodb user is?

Re: mongodb authentication problem

Posted by Kamesh <ka...@gmail.com>.
Hi Wang,
 Still the patch for DRILL-1502 is not committed. It is still in review
state.

On Wed, Apr 8, 2015 at 2:03 PM, Wang Darrell <da...@gmail.com>
wrote:

> Hello
>
> I still can't figure it out this problem.
> After trying to solve this for almost a week.
>
> I used java to check the mongodb connection uri to see the error message.
> it came out that the error message that Drill gave me
>
> CommandFailureException: { "serverUsed" : "192.168.170.136:27017" , "ok" :
> 0.0 , "errmsg" : "not authorized on admin to execute command {
> listDatabases: 1 }"
>
> is same as the connection url like "mongodb:host:port"
>
> so the problem is
> As I set my drill storage config like this
>
> {
>   "type": "mongo",
>   "connection": "mongodb://zipsread:zipsread@localhost:27017/zips",
>   "enabled": true
> }
>
> but the drill sending the uri like "mongodb://localhost:27017"
>
> drill version is 0.8 ( but has tested on 0.7 and 0.9 and have same problem
> )
> mongodb version is 2.6.9  ( has tested on 3.0 and 2.4 and have same problem
> )
> drill is start as distributed mode ( need to use squirrel )
> mongodb is started alone , no clustering
>
> can someone help me out ?
> really stuck at it for very long time.
>



-- 
Kamesh.

Re: mongodb authentication problem

Posted by Wang Darrell <da...@gmail.com>.
Hello

I still can't figure it out this problem.
After trying to solve this for almost a week.

I used java to check the mongodb connection uri to see the error message.
it came out that the error message that Drill gave me

CommandFailureException: { "serverUsed" : "192.168.170.136:27017" , "ok" :
0.0 , "errmsg" : "not authorized on admin to execute command {
listDatabases: 1 }"

is same as the connection url like "mongodb:host:port"

so the problem is
As I set my drill storage config like this

{
  "type": "mongo",
  "connection": "mongodb://zipsread:zipsread@localhost:27017/zips",
  "enabled": true
}

but the drill sending the uri like "mongodb://localhost:27017"

drill version is 0.8 ( but has tested on 0.7 and 0.9 and have same problem )
mongodb version is 2.6.9  ( has tested on 3.0 and 2.4 and have same problem
)
drill is start as distributed mode ( need to use squirrel )
mongodb is started alone , no clustering

can someone help me out ?
really stuck at it for very long time.