PMM QAN - can't add mysql:queries

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]https://10.149.x.x:42000/metrics[/TD]
[TD]UP[/TD]
[/TR]
[/TABLE]
[TABLE]
[TR]
[TD]https://10.149.x.x:42002/metrics-hr[/TD]
[TD]UP[/TD]
[/TR]
[/TABLE]
[TABLE]
[TR]
[TD]https://10.149.x.x:42002/metrics-mr[/TD]
[TD]UP[/TD]
[/TR]
[/TABLE]
[TABLE]
[TR]
[TD]https://10.149.x.x:42002/metrics-lr[/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

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 https://www.percona.com/redir/downloads/TESTING/pmm/pmm-server-1.3.2.ova
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?

That can be a source of the problem.