We have installed the latest pmm in one of the MySQL servers, everything was fine but not able to get the graphs.
I have checked the pmm-admin list which shows its okay but the pmm-admin check-network shows the status DOWN.
Here are the outputs, could you please me out.
[09:13:44 root@prod-mysql-01.fra1 ~]$ pmm-admin list
pmm-admin 1.17.3
PMM Server | prod-perconamm-01.lga1.admarketplace.net (password-protected)
Client Name | prod-mysql-01.fra1.admarketplace.net
Client Address | 10.69.1.10
Service Manager | linux-systemd
-------------- ------------------------------------- ----------- -------- -------------------------------------------- ---------------
SERVICE TYPE NAME LOCAL PORT RUNNING DATA SOURCE OPTIONS
-------------- ------------------------------------- ----------- -------- -------------------------------------------- ---------------
linux:metrics prod-mysql-01.fra1.admarketplace.net 42000 YES -
mysql:metrics prod-mysql-01.fra1.admarketplace.net 42002 YES pmm_app:@unix(/var/lib/mysql/mysql.sock) tablestats=OFF
[09:13:50 root@prod-mysql-01.fra1 ~]$ pmm-admin check-network
PMM Network Status
Server Address | prod-perconamm-01.lga1.admarketplace.net
Client Address | 10.69.1.10
System Time
NTP Server (0.pool.ntp.org) | unable to get ntp time: %!s(<nil>)
PMM Server | 2020-04-06 13:14:02 +0000 GMT
PMM Client | 2020-04-06 09:14:16 -0400 EDT
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 | 192.407236ms
Request duration | -97.706805ms
Full round trip | 94.700431ms
Connection: Client <-- Server
-------------- ------------------------------------- ----------------- ------- ---------- ---------
SERVICE TYPE NAME REMOTE ENDPOINT STATUS HTTPS/TLS PASSWORD
-------------- ------------------------------------- ----------------- ------- ---------- ---------
linux:metrics prod-mysql-01.fra1.admarketplace.net 10.69.1.10:42000 DOWN YES YES
mysql:metrics prod-mysql-01.fra1.admarketplace.net 10.69.1.10:42002 DOWN YES YES
When an endpoint is down it may indicate that the corresponding service is stopped (run ‘pmm-admin list’ to verify).
If it’s running, check out the logs /var/log/pmm-*.log
When all endpoints are down but ‘pmm-admin list’ shows they are up and no errors in the logs,
check the firewall settings whether this system allows incoming connections from server to address:port in question.
Also you can check the endpoint status by the URL: http://prod-perconamm-01.lga1.admarketplace.net/prometheus/targets
[09:14:17 root@prod-mysql-01.fra1 ~]$