not authorized on local to execute command

来源：互联网发布：尚观mysql视频教程编辑：程序博客网时间：2024/04/28 00:51

线上MongoDB 监控项不能出图，检查后发现是权限有问题。

SECONDARY> db.printReplicationInfo()
2017-08-21T14:46:55.587+0800 E QUERY [thread1] Error: listCollections failed: {
“ok” : 0,
“errmsg” : “not authorized on local to execute command { listCollections: 1.0, filter: {} }”,
“code” : 13
} :
_getErrorWithCode@src/mongo/shell/utils.js:25:13
DB.prototype._getCollectionInfosCommand@src/mongo/shell/db.js:773:1
DB.prototype.getCollectionInfos@src/mongo/shell/db.js:785:19
DB.prototype.getCollectionNames@src/mongo/shell/db.js:796:16
DB.prototype.getReplicationInfo@src/mongo/shell/db.js:893:32
DB.prototype.printReplicationInfo@src/mongo/shell/db.js:946:22
@(shell):1:1

解决办法：
PRIMARY> db.grantRolesToUser( “monitor”, [{ role: “read”, db: “local”}])

SECONDARY> db.printReplicationInfo()
configured oplog size: 5000MB
log length start to end: 874307secs (242.86hrs)
oplog first event time: Fri Aug 11 2017 12:07:56 GMT+0800 (CST)
oplog last event time: Mon Aug 21 2017 14:59:43 GMT+0800 (CST)
now: Mon Aug 21 2017 14:59:43 GMT+0800 (CST)

阅读全文

0 0