added first MySQL PMM Client, but PMM Server running at docker doesn't "see" it

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

Greetings,

We’ve installed PMM Server at docker infrastructure.
At another - MySQL DB - host, installed PMM client RPM, and added that client :

pmm-admin add mysql --user root --password XXXXXXX

[linux:metrics] OK, already monitoring this system.
[mysql:metrics] OK, now monitoring MySQL metrics using DSN root:@unix(/var/lib/mysql/mysql.sock)
[mysql:queries] OK, now monitoring MySQL queries from slowlog using DSN root:@unix(/var/lib/mysql/mysql.sock)

pmm-admin list

pmm-admin 1.15.0

PMM Server | 10.236.151.47:80
Client Name | vm-tskapin2
Client Address | 10.236.151.49
Service Manager | linux-systemd

SERVICE TYPE NAME LOCAL PORT RUNNING DATA SOURCE OPTIONS

mysql:queries vm-tskapin2 - YES root:@unix(/var/lib/mysql/mysql.sock) query_source=slowlog, query_examples=true, slow_log_rotation=true, retain_slow_logs=1
linux:metrics vm-tskapin2 42000 YES -
mysql:metrics vm-tskapin2 42002 YES root:@unix(/var/lib/mysql/mysql.sock)

However, the main PMM Server dashboard still doesn’t present any information about the new-added PMM/MySQL client.

Anything else should be done to ensure the DB-Host is properly presented/monitored by PMM Server ?

Best regards,
Avi Vainshtein

2

Hi avi vainshtein
do you have any firewall rules blocking access?

If you share your logs.zip we can also review to see if the targets are being scraped, or you can check Prometheus at /prometheus/targets

3

Hello Michael Coburn
Many thanks, the problem was in firewall (iptables settings). Now it seems to work.

4

Glad it is fixed avi vainshtein