Details
-
Bug
-
Status: Done
-
Medium
-
Resolution: Fixed
-
1.3.2
Description
Hello Team,
I'm running a few tests on PMM after a customer opened a ticket mentioning the QAN is not working on their env. And in fact, I noticed when authentication is enabled QAN doesn't show any data.
Our internal ticket is: https://percona.zendesk.com/agent/tickets/207584 kamil.dziedzic joined the call to check with the customer the possible reasons but we don't have access to their environment. for this reason, I've created a test machine to share my test case to try to help with that issue.
Please see the steps I used to reproduce the issue:
Installed mongodb 3.4 in a fresh ubuntu 16.04 wget https://fastdl.mongodb.org/linux/mongodb-linux-x86_64-ubuntu1604-3.4.10.tgz gunzip mongodb-linux-x86_64-ubuntu1604-3.4.10.tgz mkdir /data mongod --dbpath /data --logpath /data/log.log --replSet foo --wiredTigerCacheSizeGB 0.3 --bind_ip 127.0.0.1 --fork --auth ./mongo rs.initiate() rs.createUser({user: 'admin',pwd : '123', roles : ["root"]}) use admin db.auth('admin','123') use admin db.createRole( { role: "pmmmonitor", privileges: [ { resource: { db: "", collection: "system.profile" }, actions: [ "find" ]}, { resource: { db: "admin", collection: "system.users" }, actions: [ "find" ]}, { resource: { db: "admin", collection: "system.roles" }, actions: [ "find" ]} ], roles: [] } ) use admin db.getSiblingDB("admin").createUser({ user: "mongodb_exporter", pwd: "12345", roles: [ { role: "clusterMonitor", db: "admin" }, { role: "pmmmonitor", db: "admin" }, { role: "read", db: "local" } ] }) Installed docker and running: docker run -d \ -p 80:80 \ -m 256M \ --volumes-from pmm-data \ --name pmm-server \ --restart always \ percona/pmm-server:latest sudo pmm-admin add mongodb:queries --uri mongodb://mongodb_exporter:[email protected]:27017/?authSource=admin&connect=direct (tried with both direct or without direct) see pmm running at : http://159.203.61.140/ Issue found on pt-mongo-query-diggest on: https://jira.percona.com/browse/PT-212
Please let me know if you need more details to investigate this case.
Regards
