mysql:queries API Error

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

Our PMM server is being a proxy for security. We can connect to it from our clients and add linux:metrics and mysql:metrics. However, when we try to add mysql:queries, we get an error. “Error adding MySQL queries: timeout 10s waiting on agent to connect to API.” It was working till we put it behind the proxy.

Not sure how we can debug this. Thanks!

2

I have same error dans after repair I get a 409 error :

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

Server Address | pmm.eurecia.com:443
Client Address | X.X.X.141

* System Time
NTP Server (0.pool.ntp.org) | 2017-11-29 14:24:25 +0100 CET
PMM Server | 2017-11-29 13:25:01 +0000 GMT
PMM Client | 2017-11-29 14:24:25 +0100 CET
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 OK

Connection duration | 1.78193ms
Request duration | 10.853308ms
Full round trip | 12.635238ms


* Connection: Client <-- Server
-------------- ------------- -------------------- ------- ---------- ---------
SERVICE TYPE NAME REMOTE ENDPOINT STATUS HTTPS/TLS PASSWORD
-------------- ------------- -------------------- ------- ---------- ---------
linux:metrics XXXX X.X.X.141:42000 OK YES -
mysql:metrics XXXX X.X.X.141:42002 OK YES -

root&#64;XXXX:~# pmm-admin add mysql:queries --user xxx
Error adding MySQL queries: timeout 10s waiting on agent to connect to API.

root&#64;XXXX:~# pmm-admin repair
OK, removed 1 orphaned services.

root&#64;XXXX:~# pmm-admin add mysql:queries --user xxx
Error adding MySQL queries: PUT https://pmmserver.xxxx.xxx:443/qan-api/instances/ec6ff5a748564fa36b5f8ebf963b589d: API returned HTTP status code 409, expected 204
3

So I find a solution you need to configure your proxy to handle websocket : nginx exemple [URL]https://www.nginx.com/blog/websocket-nginx/[/URL]