PMM QAN - can't add mysql:queries

Percona Monitoring and Management (PMM) PMM 1.x
1

Hello,

Installing pmm-client on new servers. linux:metrics and mysql:metrics have been added successfully. While adding mysql:queries I receive an error:

[root@0913lbmysql01 /]# pmm-admin add mysql:queries --query-source perfschema
Error adding MySQL queries: problem with agent registration on QAN API: exit status 1

Repair doesn’t help:

[root@0913lbmysql01 /]# pmm-admin repair
No orphaned services found.

PMM list:

[root@0913lbmysql01 /]# pmm-admin list
pmm-admin 1.3.2

PMM Server | 10.147.x.x (password-protected)
Client Name | 0913lbmysql01
Client Address | 10.149.x.x
Service Manager | unix-systemv

SERVICE TYPE NAME LOCAL PORT RUNNING DATA SOURCE OPTIONS

linux:metrics 0913lbmysql01 42000 YES -
mysql:metrics 0913lbmysql01 42002 YES pmm:***@unix(/opt/mysql/mysql.sock) tablestats=OFF

Network-check:

[root@0913lbmysql01 /]# pmm-admin check-network
PMM Network Status

Server Address | 10.147.x.x
Client Address | 10.149.x.x

  • System Time
    PMM Server | 2017-10-20 05:47:57 +0000 GMT
    PMM Client | 2017-10-20 13:48:59 +0800 IRKT
    PMM Client to PMM Server Time Drift | 62s
    Time is out of sync. Please make sure the server time is correct to see the metrics.

  • Connection: Client → Server

SERVER SERVICE STATUS

Consul API OK
Prometheus API OK
Query Analytics API DOWN

Connection duration | 47.348766ms
Request duration | 48.225644ms
Full round trip | 95.57441ms

  • Connection: Client ← Server

SERVICE TYPE NAME REMOTE ENDPOINT STATUS HTTPS/TLS PASSWORD

linux:metrics 0913lbmysql01 10.149.x.x:42000 OK YES YES
mysql:metrics 0913lbmysql01 10.149.x.x:42002 OK YES YES

From the Prometheus side: [TABLE]
[TR]
[TD][URL=“https://10.149.138.11:42000/metrics”]https://10.149.x.x:42000/metrics[/URL][/TD]
[TD]UP[/TD]
[/TR]
[/TABLE]
[TABLE]
[TR]
[TD][URL=“https://10.149.138.11:42002/metrics-hr”]https://10.149.x.x:42002/metrics-hr[/URL][/TD]
[TD]UP[/TD]
[/TR]
[/TABLE]
[TABLE]
[TR]
[TD][URL=“https://10.149.138.11:42002/metrics-mr”]https://10.149.x.x:42002/metrics-mr[/URL][/TD]
[TD]UP[/TD]
[/TR]
[/TABLE]
[TABLE]
[TR]
[TD][URL=“https://10.149.138.11:42002/metrics-lr”]https://10.149.x.x:42002/metrics-lr[/URL][/TD]
[TD]UP[/TD]
[/TR]
[/TABLE]
PMM version:
[root@0913lbmysql01 /]# rpm -qa | grep -i pmm
pmm-client-1.3.2-1.x86_64

Linux and mysql metrics work fine. But QAN doesn’t.

How to fix this issue and add mysql:queries?

Regards,
Mikhail Golenkov

2

I guess that the problem originates from PMM-Server. All my PMM-Clients have the same error - problem with agent registration on QAN API: exit status 1.
Version of PMM-Server is 1.3.2. PMM-Server has been installed as a virtual appliance. OVA file downloaded from [url]https://www.percona.com/redir/downloads/TESTING/pmm/pmm-server-1.3.2.ova[/url]
In addition, I could not find login and password in order to connect to PMM-Server. Is it possible to get an OS access to PMM-Server?

3

That can be a source of the problem.