Uploaded image for project: 'Percona Monitoring and Management'
  1. Percona Monitoring and Management
  2. PMM-5608

Correct documentation about QAN For MongoDB

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 2.0.0, 1.17.3
    • Fix Version/s: None
    • Component/s: Documentation
    • Labels:
      None
    • Story Points:
      0.5
    • Sprint:
      Platform Sprint 22
    • Needs Review:
      Yes

      Description

      In page https://www.percona.com/doc/percona-monitoring-and-management/conf-mongodb.html#setting-up-the-essential-permissions

       the instructions are incomplete. When trying to display query execution plans the page errors out due to insufficient privileges.

      what is missing here is that for QAN to be able to display query execution plans, a role like the following is required:

      db.createRole( { role: "explainRole", privileges: [ { resource: { db: "", collection: "" }, actions: [ "listIndexes","listCollections","dbStats","dbHash","collStats","find" ] }], roles:[]}) 
      db.getSiblingDB("admin").createUser({
          user: "mongodb_exporter",
          pwd: "percona",
          roles: [
              { role: "explainRole", db: "admin" ),
              { role: "clusterMonitor", db: "admin" },
              { role: "read", db: "local" }
          ]
      }) 

       

       

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              ivan.groenewold Ivan Groenewold
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0 minutes
                  0m
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 hour
                  1h