Here are all the roles and privileges the user has.
************************
db.runCommand({usersInfo:"ssatsvc",showPrivileges:true})
{
"users" : [
{
"_id" : "meteor.ssatsvc",
"user" : "ssatsvc",
"db" : "meteor",
"roles" : [
{
"role" : "readWrite",
"db" : "meteor"
},
{
"role" : "clusterAdmin",
"db" : "admin"
}
],
"inheritedRoles" : [
{
"role" : "readWrite",
"db" : "meteor"
},
{
"role" : "clusterAdmin",
"db" : "admin"
}
],
"inheritedPrivileges" : [
{
"resource" : {
"db" : "meteor",
"collection" : ""
},
"actions" : [
"collStats",
"convertToCapped",
"createCollection",
"createIndex",
"dbHash",
"dbStats",
"dropCollection",
"dropIndex",
"emptycapped",
"find",
"insert",
"killCursors",
"planCacheRead",
"remove",
"renameCollectionSameDB",
"update"
]
},
{
"resource" : {
"db" : "meteor",
"collection" : "system.indexes"
},
"actions" : [
"collStats",
"dbHash",
"dbStats",
"find",
"killCursors",
"planCacheRead"
]
},
{
"resource" : {
"db" : "meteor",
"collection" : "system.js"
},
"actions" : [
"collStats",
"convertToCapped",
"createCollection",
"createIndex",
"dbHash",
"dbStats",
"dropCollection",
"dropIndex",
"emptycapped",
"find",
"insert",
"killCursors",
"planCacheRead",
"remove",
"renameCollectionSameDB",
"update"
]
},
{
"resource" : {
"db" : "meteor",
"collection" : "system.namespaces"
},
"actions" : [
"collStats",
"dbHash",
"dbStats",
"find",
"killCursors",
"planCacheRead"
]
},
{
"resource" : {
"cluster" : true
},
"actions" : [
"addShard",
"appendOplogNote",
"applicationMessage",
"cleanupOrphaned",
"closeAllDatabases",
"connPoolStats",
"connPoolSync",
"cpuProfiler",
"cursorInfo",
"diagLogging",
"flushRouterConfig",
"fsync",
"getCmdLineOpts",
"getLog",
"getParameter",
"getShardMap",
"hostInfo",
"inprog",
"invalidateUserCache",
"killop",
"listDatabases",
"listShards",
"logRotate",
"netstat",
"removeShard",
"replSetConfigure",
"replSetGetStatus",
"replSetStateChange",
"resync",
"serverStatus",
"setParameter",
"shardingState",
"shutdown",
"top",
"touch",
"unlock"
]
},
{
"resource" : {
"db" : "",
"collection" : ""
},
"actions" : [
"collStats",
"dbStats",
"dropDatabase",
"enableSharding",
"getShardVersion",
"killCursors",
"moveChunk",
"repairDatabase",
"splitChunk",
"splitVector"
]
},
{
"resource" : {
"db" : "config",
"collection" : ""
},
"actions" : [
"collStats",
"dbHash",
"dbStats",
"find",
"killCursors",
"planCacheRead"
]
},
{
"resource" : {
"db" : "config",
"collection" : "system.indexes"
},
"actions" : [
"collStats",
"dbHash",
"dbStats",
"find",
"killCursors",
"planCacheRead"
]
},
{
"resource" : {
"db" : "config",
"collection" : "system.js"
},
"actions" : [
"collStats",
"dbHash",
"dbStats",
"find",
"killCursors",
"planCacheRead"
]
},
{
"resource" : {
"db" : "config",
"collection" : "system.namespaces"
},
"actions" : [
"collStats",
"dbHash",
"dbStats",
"find",
"killCursors",
"planCacheRead"
]
},
{
"resource" : {
"db" : "local",
"collection" : "system.replset"
},
"actions" : [
"collStats",
"dbHash",
"dbStats",
"find",
"killCursors",
"planCacheRead"
]
},
{
"resource" : {
"db" : "",
"collection" : "system.profile"
},
"actions" : [
"find"
]
},
{
"resource" : {
"db" : "config",
"collection" : "settings"
},
"actions" : [
"insert",
"remove",
"update"
]
}
]
}
],
"ok" : 1
}
************************
Thanks,
Mano
From: Rangaswamy, Manoharan
Sent: Tuesday, June 02, 2015 8:27 AM
To: 'Jacques Nadeau'
Cc: user@drill.apache.org
Subject: RE: MapR Drill - mongodb collections does not show up
Hi Jacques,
Here is the error message in the drillbit.log
*************************
2015-06-02 08:18:32,410 [2a9236b6-a426-f129-66fb-f100c6bb8a56:foreman] WARN
o.a.d.e.s.m.s.MongoSchemaFactory - Failure while loading databases in Mongo. {
"serverUsed" : "mamongo01.qualcomm.com:27017" , "ok" : 0.0 , "errmsg" : "not
authorized on admin to execute command { listDatabases: 1 }" , "code" : 13}
2015-06-02 08:18:32,438 [2a9236b6-a426-f129-66fb-f100c6bb8a56:foreman] INFO
o.a.drill.exec.work.foreman.Foreman - State change requested. PENDING -->
RUNNING
2015-06-02 08:18:32,441 [2a9236b6-a426-f129-66fb-f100c6bb8a56:frag:0:0] INFO
o.a.d.e.w.fragment.FragmentExecutor - 2a9236b6-a426-f129-66fb-f100c6bb8a56:0:0:
State change requested from AWAITING_ALLOCATION --> RUNNING for
2015-06-02 08:18:32,442 [2a9236b6-a426-f129-66fb-f100c6bb8a56:frag:0:0] INFO
o.a.d.e.w.f.AbstractStatusReporter - State changed for
2a9236b6-a426-f129-66fb-f100c6bb8a56:0:0. New state: RUNNING
2015-06-02 08:18:32,457 [2a9236b6-a426-f129-66fb-f100c6bb8a56:frag:0:0] INFO
o.a.d.e.w.fragment.FragmentExecutor - 2a9236b6-a426-f129-66fb-f100c6bb8a56:0:0:
State change requested from RUNNING --> FINISHED for
2015-06-02 08:18:32,457 [2a9236b6-a426-f129-66fb-f100c6bb8a56:frag:0:0] INFO
o.a.d.e.w.f.AbstractStatusReporter - State changed for
2a9236b6-a426-f129-66fb-f100c6bb8a56:0:0. New state: FINISHED
2015-06-02 08:18:32,458 [BitServer-4] INFO o.a.drill.exec.work.foreman.Foreman
- State change requested. RUNNING --> COMPLETED
2015-06-02 08:18:32,460 [BitServer-4] INFO o.a.drill.exec.work.foreman.Foreman
- foreman cleaning up.
*************************
Thanks,
Mano
From: Jacques Nadeau [mailto:jacq...@apache.org]
Sent: Monday, June 01, 2015 9:10 PM
To: Rangaswamy, Manoharan
Cc: user@drill.apache.org<mailto:user@drill.apache.org>;
jacq...@apache.org<mailto:jacq...@apache.org>
Subject: Re: MapR Drill - mongodb collections does not show up
No additional debugging info should need to be enabled (at least initially).
You should start by only starting one drillbit and then providing drillbit.log.
When I've seen this before there was an associated warning in drillbit.log
when this type of failure occurred. I would like to see if we're seeing the
same thing here.
thanks,
Jacques
On Mon, Jun 1, 2015 at 10:47 AM, Rangaswamy, Manoharan
<mran...@qualcomm.com<mailto:mran...@qualcomm.com>> wrote:
Hi Jacques,
I saw your reply in the mail list and responding to your question.
Can you please let me know if you want me to execute the failing operation now
and send the log files or setup some more debug info options and send the log
file. Please let me know.
Thanks,
Mano
From: Rangaswamy, Manoharan
Sent: Monday, June 01, 2015 8:24 AM
To: 'user@drill.apache.org<mailto:user@drill.apache.org>'
Subject: MapR Drill - mongodb collections does not show up
We are using MapR Drill 1.0 and configured a mongodb storage plugin as below.
{
"type": "mongo",
"connection": "mongodb://uid:pwd@host:port/dbname",
"enabled": true
}
We are able to connect through CLI and Drill Explorer, but it does display any
databases and query against any collection fail as well.
Robomongo connects well with the same user and it works.
Are we missing any additional configuration? Please let us know.
Thanks,
Mano
