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.