Unable to start mysql:queries

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

Hello,

I tried many things but I can’t start mysql:queries.
linux and mysql metrics work as expected, but receiving below error when adding mysql:queries

[I]root # pmm-admin add mysql:queries
Error adding MySQL queries: problem with agent registration on QAN API: exit status 1

root # # pmm-admin check-network
PMM Network Status

Server Address | xxxxxxxxxxx
Client Address | xxxxxxxxxxxxx

  • System Time
    NTP Server (0.pool.ntp.org) | 2017-09-29 10:54:30 +0000 UTC
    PMM Server | 2017-09-29 10:54:30 +0000 GMT
    PMM Client | 2017-09-29 10:54:30 +0000 UTC
    PMM Server Time Drift | OK
    PMM Client Time Drift | OK
    PMM Client to PMM Server Time Drift | OK

  • Connection: Client → Server

SERVER SERVICE STATUS

Consul API OK
Prometheus API OK
Query Analytics API DOWN

Connection duration | 31.077004ms
Request duration | 32.748302ms
Full round trip | 63.825306ms

  • Connection: Client ← Server

SERVICE TYPE NAME REMOTE ENDPOINT STATUS HTTPS/TLS PASSWORD

linux:metrics XXXXXXXX xxxxxxxxx:42000 OK YES YES
mysql:metrics YYYYYYY yyyyyyyyyyy:42002 OK YES YES[/I]

2

Hello,

I have the same problem and would be interested in a solution as well.

I am using

in combination with and EC2 instance

Regards
Michael

3

Can you ssh into PMM Server instance and share the output of the following commands?

sudo df -h
sudo ps ax
sudo systemctl restart percona-qan-api
sudo ps ax
sudo systemctl status percona-qan-api
sudo journalctl -u percona-qan-api
4

I think I found what it’s not working
Looks like qan-api and orchestrator are now using different usernames and passwords
The login information in /etc/percona-qan-api.conf is no longer valid