Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 1.3.2
    • Fix Version/s: 1.6.1
    • Component/s: QAN Agent
    • Labels:

      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:1235@localhost: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

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  adamo.tonete Adamo Tonete
                • Votes:
                  2 Vote for this issue
                  Watchers:
                  7 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Time Spent - 1 day Remaining Estimate - 3 days
                    3d
                    Logged:
                    Time Spent - 1 day Remaining Estimate - 3 days
                    1d