Effect on a user: User cannot see mysql:metrics on PMM dashboards *STR:* Try to add mysql:metrics on Ubuntu 18.04
sudo pmm-admin add mysql:metrics
Given result: Service is not running:
sudo pmm-admin check-network
PMM Network Status
Server Address | localhost:8080
Client Address | 172.17.0.1
* System Time
NTP Server (0.pool.ntp.org) | 2018-06-19 12:23:21 +0000 UTC
PMM Server | 2018-06-19 12:23:21 +0000 GMT
PMM Client | 2018-06-19 12:23:21 +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 OK
Connection duration | 133.812µs
Request duration | 193.858057ms
Full round trip | 193.991869ms
* Connection: Client <-- Server
-------------- ------------------- ----------------- ------- ---------- ---------
SERVICE TYPE NAME REMOTE ENDPOINT STATUS HTTPS/TLS PASSWORD
-------------- ------------------- ----------------- ------- ---------- ---------
mysql:metrics <instance_name> 172.17.0.1:42002 DOWN - -
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://localhost:8080/prometheus/targets
In pmm-mysql-metrics.logs:
time="2018-06-19T12:19:43Z" level=fatal msg="failed reading ini file: open .my.cnf: no such file or directory" source="mysqld_exporter.go:300"
Expected result: Service is running and there is no any errors in logs
User's report:
I'm working on pmm configuration for my needs and faced an issue.
So I successfully got pmm-client up and running on Ubuntu 16.04.
But now I'm trying to run it on Ubuntu 18.04 and "mysql:metrics" is not working there.
$ sudo pmm-admin check-network
PMM Network Status
Server Address | localhost:8080
Client Address | 172.17.0.1
* System Time
NTP Server (0.pool.ntp.org) | 2018-06-19 12:23:21 +0000 UTC
PMM Server | 2018-06-19 12:23:21 +0000 GMT
PMM Client | 2018-06-19 12:23:21 +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 OK
Connection duration | 133.812µs
Request duration | 193.858057ms
Full round trip | 193.991869ms
* Connection: Client <-- Server
-------------- ------------------- ----------------- ------- ---------- ---------
SERVICE TYPE NAME REMOTE ENDPOINT STATUS HTTPS/TLS PASSWORD
-------------- ------------------- ----------------- ------- ---------- ---------
linux:metrics <instance_name> 172.17.0.1:42000 OK YES -
mysql:metrics <instance_name> 172.17.0.1:42002 DOWN - -
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://localhost:8080/prometheus/targets
$ sudo pmm-admin list
pmm-admin 1.11.0
PMM Server | localhost:8080
Client Name | RDS
Client Address | 172.17.0.1
Service Manager | linux-systemd
-------------- ------------------- ----------- -------- --------------------------------------------------------------------------- ---------------------------------------------
SERVICE TYPE NAME LOCAL PORT RUNNING DATA SOURCE OPTIONS
-------------- ------------------- ----------- -------- --------------------------------------------------------------------------- ---------------------------------------------
mysql:queries <instance_name> - YES pmm:***@tcp(<db_instance_url>:3306) query_source=perfschema, query_examples=true
linux:metrics <instance_name> 42000 YES -
mysql:metrics <instance_name> 42002 NO pmm:***@tcp(<db_instance_url>:3306)
From pmm-mysql-metrics-42002.log:
time="2018-06-19T12:19:43Z" level=fatal msg="failed reading ini file: open .my.cnf: no such file or directory" source="mysqld_exporter.go:300"
High
Effect on a user: User cannot see mysql:metrics on PMM dashboards
*STR:* Try to add mysql:metrics on Ubuntu 18.04
sudo pmm-admin add mysql:metricsGiven result: Service is not running:
sudo pmm-admin check-network PMM Network Status Server Address | localhost:8080 Client Address | 172.17.0.1 * System Time NTP Server (0.pool.ntp.org) | 2018-06-19 12:23:21 +0000 UTC PMM Server | 2018-06-19 12:23:21 +0000 GMT PMM Client | 2018-06-19 12:23:21 +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 OK Connection duration | 133.812µs Request duration | 193.858057ms Full round trip | 193.991869ms * Connection: Client <-- Server -------------- ------------------- ----------------- ------- ---------- --------- SERVICE TYPE NAME REMOTE ENDPOINT STATUS HTTPS/TLS PASSWORD -------------- ------------------- ----------------- ------- ---------- --------- mysql:metrics <instance_name> 172.17.0.1:42002 DOWN - - 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://localhost:8080/prometheus/targetsIn pmm-mysql-metrics.logs:
time="2018-06-19T12:19:43Z" level=fatal msg="failed reading ini file: open .my.cnf: no such file or directory" source="mysqld_exporter.go:300"Expected result: Service is running and there is no any errors in logs
User's report:
I'm working on pmm configuration for my needs and faced an issue.
So I successfully got pmm-client up and running on Ubuntu 16.04.
But now I'm trying to run it on Ubuntu 18.04 and "mysql:metrics" is not working there.
Below are some details.
$ cat /etc/lsb-release DISTRIB_ID=Ubuntu DISTRIB_RELEASE=18.04 DISTRIB_CODENAME=bionic DISTRIB_DESCRIPTION="Ubuntu 18.04 LTS"$ sudo pmm-admin check-network PMM Network Status Server Address | localhost:8080 Client Address | 172.17.0.1 * System Time NTP Server (0.pool.ntp.org) | 2018-06-19 12:23:21 +0000 UTC PMM Server | 2018-06-19 12:23:21 +0000 GMT PMM Client | 2018-06-19 12:23:21 +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 OK Connection duration | 133.812µs Request duration | 193.858057ms Full round trip | 193.991869ms * Connection: Client <-- Server -------------- ------------------- ----------------- ------- ---------- --------- SERVICE TYPE NAME REMOTE ENDPOINT STATUS HTTPS/TLS PASSWORD -------------- ------------------- ----------------- ------- ---------- --------- linux:metrics <instance_name> 172.17.0.1:42000 OK YES - mysql:metrics <instance_name> 172.17.0.1:42002 DOWN - - 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://localhost:8080/prometheus/targets$ sudo pmm-admin list pmm-admin 1.11.0 PMM Server | localhost:8080 Client Name | RDS Client Address | 172.17.0.1 Service Manager | linux-systemd -------------- ------------------- ----------- -------- --------------------------------------------------------------------------- --------------------------------------------- SERVICE TYPE NAME LOCAL PORT RUNNING DATA SOURCE OPTIONS -------------- ------------------- ----------- -------- --------------------------------------------------------------------------- --------------------------------------------- mysql:queries <instance_name> - YES pmm:***@tcp(<db_instance_url>:3306) query_source=perfschema, query_examples=true linux:metrics <instance_name> 42000 YES - mysql:metrics <instance_name> 42002 NO pmm:***@tcp(<db_instance_url>:3306)From pmm-mysql-metrics-42002.log:
time="2018-06-19T12:19:43Z" level=fatal msg="failed reading ini file: open .my.cnf: no such file or directory" source="mysqld_exporter.go:300"