# mysql:queries and mysql:metrics not work ..
**URL:** https://forums.percona.com/t/mysql-queries-and-mysql-metrics-not-work/7469
**Category:** Percona Server for MySQL 5.7
**Created:** [March 13, 2020, 5:33am UTC](https://forums.percona.com/t/mysql-queries-and-mysql-metrics-not-work/7469 "2020-03-13T05:33:21Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@umargoury](https://forums.percona.com/u/umargoury)
#### Post date: [March 13, 2020, 5:33am UTC](https://forums.percona.com/t/mysql-queries-and-mysql-metrics-not-work/7469/1 "2020-03-13T05:33:21Z")
Hello,
we test the functionality pmm.
We have only 1 server : -
PMM Server (CentOS Linux release 7.7.1908 (Core) : [http://89.200.136.175:8081/](http://89.200.136.175:8081/)
PMM Client - [89.200.136.175](http://89.200.136.175:8081/)
For the Slow Query check for QAN PMM on the PMM Client :
slow\_query\_log\_file=/var/log/mysql-slow.log
slow\_query\_log=ON
long\_query\_time=0.01
log\_slow\_admin\_statements=ON
log\_slow\_slave\_statements=ON
ON The Client:
[root@inkpraa5 ~]# pmm-admin list
pmm-admin 1.1.3
PMM Server | 89.200.136.175:8081
Client Name | inkpraa5.memset.netClient Address | 89.200.136.175
Service Manager | linux-systemd
* * *
SERVICE TYPE NAME LOCAL PORT RUNNING DATA SOURCE OPTIONS
* * *
mysql:queries [inkpraa5.memset.net](http://inkpraa5.memset.net) - YES aalabels\_monitor:_**@unix(/var/lib/mysql/mysql.sock) query\_source=perfschema, query\_examples=true
linux:metrics [inkpraa5.memset.net](http://inkpraa5.memset.net) 42000 YES -
mysql:metrics [inkpraa5.memset.net](http://inkpraa5.memset.net) 42002 YES aalabels\_monitor:**_@unix(/var/lib/mysql/mysql.sock)
* * *
[root@inkpraa5 ~]# pmm-admin check-network
PMM Network Status
Server Address | 89.200.136.175:8081
Client Address | 89.200.136.175
- System Time
NTP Server ([0.pool.ntp.org](http://0.pool.ntp.org)) | 2020-03-13 10:24:42 +0000 GMT
PMM Server | 2020-03-13 10:24:42 +0000 GMT
PMM Client | 2020-03-13 10:24:42 +0000 GMT
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 | 254.426µs
Request duration | 664.149µs
Full round trip | 918.575µs
- Connection: Client ← Server
* * *
SERVICE TYPE NAME REMOTE ENDPOINT STATUS HTTPS/TLS PASSWORD
* * *
linux:metrics [inkpraa5.memset.net](http://inkpraa5.memset.net) 89.200.136.175:42000 DOWN YES -
mysql:metrics [inkpraa5.memset.net](http://inkpraa5.memset.net) 89.200.136.175:42002 DOWN 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://89.200.136.175:8081/prometheus/targets](http://89.200.136.175:8081/prometheus/targets)
* * *
[root@inkpraa5 log]# cat pmm-mysql-metrics-42002.log
time=“2020-03-12T09:31:06Z” level=info msg=“Starting mysqld\_exporter (version=1.1.3, branch=master, revision=4a4c53fb313fb1883bcbd464f53c83f73b336100)” source=“mysqld\_exporter.go:679”
time=“2020-03-12T09:31:06Z” level=info msg=“Build context (go=go1.8, user=, date=)” source=“mysqld\_exporter.go:680”
time=“2020-03-12T09:31:06Z” level=info msg=“HTTPS/TLS is enabled” source=“mysqld\_exporter.go:724”
time=“2020-03-12T09:31:06Z” level=info msg=“Listening on 89.200.136.175:42002” source=“mysqld\_exporter.go:727”
time=“2020-03-12T09:31:06Z” level=error msg=“Error scraping for collect.info\_schema.innodb\_metrics: Error 1227: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation” source=“mysqld\_exporter.go:435”
time=“2020-03-12T09:31:06Z” level=error msg=“Error scraping for collect.slave\_status: Error 1227: Access denied; you need (at least one of) the SUPER, REPLICATION CLIENT privilege(s) for this operation” source=“mysqld\_exporter.go:477”
time=“2020-03-12T09:31:06Z” level=error msg=“Error scraping for collect.perf\_schema.eventswaits: Error 1142: SELECT command denied to user ‘aalabels\_monitor’@‘localhost’ for table ‘events\_waits\_summary\_global\_by\_event\_name’” source=“mysqld\_exporter.go:489”
time=“2020-03-12T09:31:06Z” level=error msg=“Error scraping for collect.perf\_schema.file\_events: Error 1142: SELECT command denied to user ‘aalabels\_monitor’@‘localhost’ for table ‘file\_summary\_by\_event\_name’” source=“mysqld\_exporter.go:495”
time=“2020-03-12T09:31:06Z” level=error msg=“Error scraping for collect.perf\_schema.tablelocks: Error 1142: SELECT command denied to user ‘aalabels\_monitor’@‘localhost’ for table ‘table\_lock\_waits\_summary\_by\_table’” source=“mysqld\_exporter.go:501”
time=“2020-03-12T09:31:06Z” level=error msg=“Error scraping for collect.perf\_schema.tableiowaits: Error 1142: SELECT command denied to user ‘aalabels\_monitor’@‘localhost’ for table ‘table\_io\_waits\_summary\_by\_table’” source=“mysqld\_exporter.go:579”
time=“2020-03-12T09:31:06Z” level=error msg=“Error scraping for collect.perf\_schema.indexiowaits: Error 1142: SELECT command denied to user ‘aalabels\_monitor’@‘localhost’ for table ‘table\_io\_waits\_summary\_by\_index\_usage’” source=“mysqld\_exporter.go:585”
time=“2020-03-12T12:27:33Z” level=info msg=“Starting mysqld\_exporter (version=1.1.3, branch=master, revision=4a4c53fb313fb1883bcbd464f53c83f73b336100)” source=“mysqld\_exporter.go:679”
2020/03/13 09:52:21 http: TLS handshake error from 89.200.136.175:55970: tls: first record does not look like a TLS handshake
2020/03/13 10:24:42 http: TLS handshake error from 89.200.136.175:53802: tls: first record does not look like a TLS handshake
* * *
[root@inkpraa5 log]# cat pmm-mysql-queries-0.log
# Version: percona-qan-agent 1.1.3
# Basedir: /usr/local/percona/qan-agent
# PID: 151754
# API: 89.200.136.175:8081/qan-api
# UUID: 196c4c948415433540723086884db2c4
## 2020/03/13 08:44:22.932996 main.go:165: Starting agent… 2020/03/13 08:44:22.935802 main.go:346: Agent is ready 2020/03/13 08:44:22.939176 main.go:207: API is ready 2020/03/13 08:44:51.620525 WARNING agent ws error: EOF 2020/03/13 08:44:51.620659 WARNING agent Lost connection to API 2020/03/13 08:44:51.620796 WARNING log Lost connection to API 2020/03/13 08:44:54.621487 WARNING agent-ws websocket.Dial ws://89.200.136.175:8081/qan-api/agents/196c4c948415433540723086884db2c4/cmd: dial tcp 89.200.136.175:8081: getsockopt: connection refused 2020/03/13 08:44:54.621596 WARNING log-ws websocket.Dial ws://89.200.136.175:8081/qan-api/agents/196c4c948415433540723086884db2c4/log: dial tcp 89.200.136.175:8081: getsockopt: connection refused 2020/03/13 08:45:00.001133 ERROR qan-analyzer-5b93639d Error 1142: SELECT command denied to user ‘aalabels\_monitor’@'localhost’for table ‘events\_statements\_summary\_by\_digest’ 2020/03/13 08:45:01.623976 WARNING agent-ws websocket.Dial ws://89.200.136.175:8081/qan-api/agents/196c4c948415433540723086884db2c4/cmd: dial tcp 89.200.136.175:8081: getsockopt: connection refused 2020/03/13 08:45:01.624055 WARNING log-ws websocket.Dial ws://89.200.136.175:8081/qan-api/agents/196c4c948415433540723086884db2c4/log: dial tcp 89.200.136.175:8081: getsockopt: connection refused 2020/03/13 08:46:00.002680 ERROR qan-analyzer-5b93639d Error 1142: SELECT command denied to user ‘aalabels\_monitor’@'localhost’for table ‘events\_statements\_summary\_by\_digest’ ‘events\_statements\_summary\_by\_digest’
## [root@inkpraa5 ~]# docker exec -ti pmm-server bash [root@c0ae057562b1 opt]# curl [http://89.200.136.175:42002/metrics](http://89.200.136.175:42002/metrics) curl: (7) Failed connect to 89.200.136.175:42002; Connection timed out
## [root@c0ae057562b1 opt]# date Fri Mar 13 10:48:08 UTC 2020
Do you have the idea for this problem ?
Thank you for your help,
Regards,
Umar
---
### Author:  [@Rick\_James](https://forums.percona.com/u/Rick_James)
#### Post date: [March 22, 2020, 5:11pm UTC](https://forums.percona.com/t/mysql-queries-and-mysql-metrics-not-work/7469/2 "2020-03-22T17:11:03Z")
You also need log\_output = FILE (or TABLE or FILE,TABLE)