pt-mysql-summary requires additional configuration

Description

I get exit = 1 when viewing the MySQL summary in the dashboard, which looks to be caused by the fact that the root OS user does not have a .my.cnf (by choice):

The credentials are confirmed as being sufficient to produce a zero exit code:

How to test

None

How to document

None

Attachments

2

Smart Checklist

Activity

Show:

Nailya Kutlubaeva March 28, 2018 at 11:25 AM

getting MySQL summary from MySQL with auth works ok :

Nailya Kutlubaeva March 28, 2018 at 10:08 AM

I have next instances added to PMM:

MySQL summary doesn't return exit 1 error, but for bm-dell06-qanqa03 it returns info from PXC, because PXC_NODE_1 is first in Host's list

Kamil Dziedzic February 16, 2018 at 6:19 PM

Fixed in qan-app, https://github.com/percona/qan-app/pull/78 but since I'm not really working with frontend, and there are not tests running by travis, may actually still not work Let's check some builds after this got merged to see if it helped or not.

Michael Coburn February 16, 2018 at 2:36 AM

Ok, lets just take a quick look whether we are correctly passing arguments or not for authentication.  Thanks,

Roma Novikov February 15, 2018 at 9:50 PM

we'll check this. but this can be the case when we need the proper ID of Node/ service to use and with current Inventory information, it's hard to do. So this can be postponed until 2.X version with Inventory API  

Done

Details

Assignee

Reporter

Priority

Components

Labels

Fix versions

Smart Checklist

Created February 21, 2017 at 11:28 AM
Updated July 11, 2018 at 5:24 PM
Resolved April 4, 2018 at 2:47 PM