# PMM doesn't show Mysql client added - nor does it appear on scrape

**URL:** <https://forums.percona.com/t/pmm-doesnt-show-mysql-client-added-nor-does-it-appear-on-scrape/9259>\
**Category:** PMM 2.x\
**Created:** [February 14, 2021, 4:08pm UTC](https://forums.percona.com/t/pmm-doesnt-show-mysql-client-added-nor-does-it-appear-on-scrape/9259 "2021-02-14T16:08:34Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![bombcar](https://avatars.discourse-cdn.com/v4/letter/b/0ea827/32.png) [@bombcar](https://forums.percona.com/u/bombcar)\
**Post date:** [February 14, 2021, 4:08pm UTC](https://forums.percona.com/t/pmm-doesnt-show-mysql-client-added-nor-does-it-appear-on-scrape/9259/1 "2021-02-14T16:08:34Z")

</div>

I’ve setup PMM on a server, and added a client, which correctly shows up under PMM inventory - but nothing appears in the MYSQL overview, and it doesn’t show on the prometheus scrape list.

Documentation refers to “pmm-admin check-network” but that just errors out with:

```
wiki mysql # pmm-admin check-network
pmm-admin: error: expected command but got "check-network", try --help

```

pmm-admin list shows:

```
wiki mysql # pmm-admin list
Service type Service name Address and port Service ID
MySQL wiki.example.com-mysql 127.0.0.1:3306 /service_id/cbff4c44-2f09-49fb-a0cd-273c4093ee43

Agent type Status Metrics Mode Agent ID Service ID
pmm_agent Connected /agent_id/c49e2a69-33fc-4ddd-9e0f-ec02b7bc5ad8
node_exporter Running push /agent_id/a6ecf473-cf6a-441c-853e-1bc630e96870
mysqld_exporter Running push /agent_id/6b9eb3bd-5989-4dc2-b408-a579e1edb933 /service_id/cbff4c44-2f09-49fb-a0cd-273c4093ee43
mysql_slowlog_agent Running /agent_id/a3706303-1471-4150-8772-1aacbc83ccc3 /service_id/cbff4c44-2f09-49fb-a0cd-273c4093ee43
vmagent Running push /agent_id/8626cb6f-e2d4-4bd1-a1af-43dc6b3f3a72

```

Running curl from either the server or the client gets a large dump of data:

```
curl -k -u pmm:/agent_id/6b9eb3bd-5989-4dc2-b408-a579e1edb933 http://wiki.example.com:42002/metrics

```

---

<div class="post-metadata">

**Author:** ![Vadim\_Yalovets](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadim_yalovets/32/43_2.png) [@Vadim\_Yalovets](https://forums.percona.com/u/Vadim_Yalovets)\
**Post date:** [February 14, 2021, 5:11pm UTC](https://forums.percona.com/t/pmm-doesnt-show-mysql-client-added-nor-does-it-appear-on-scrape/9259/2 "2021-02-14T17:11:35Z")

</div>

Hi Tom,

_“it doesn’t show on the prometheus scrape list.”_

Please confirm that you have checked scrape targets through the next url  
`https://<your pmm server ip>/prometheus/targets`

---

<div class="post-metadata">

**Author:** ![bombcar](https://avatars.discourse-cdn.com/v4/letter/b/0ea827/32.png) [@bombcar](https://forums.percona.com/u/bombcar)\
**Post date:** [February 14, 2021, 5:25pm UTC](https://forums.percona.com/t/pmm-doesnt-show-mysql-client-added-nor-does-it-appear-on-scrape/9259/3 "2021-02-14T17:25:29Z")

</div>

Yes - that’s the one - it shows various things (like a postgresql database) which I assume are the pmm server itself - but nothing about MySQL.

I installed it using the OVA image on VMWARE.

---

<div class="post-metadata">

**Author:** ![Vadim\_Yalovets](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadim_yalovets/32/43_2.png) [@Vadim\_Yalovets](https://forums.percona.com/u/Vadim_Yalovets)\
**Post date:** [February 15, 2021, 10:04am UTC](https://forums.percona.com/t/pmm-doesnt-show-mysql-client-added-nor-does-it-appear-on-scrape/9259/4 "2021-02-15T10:04:48Z")

</div>

No service instances are shown in VM targets if push mode is used.  
Metrics are processed by local vmagent.

You may check amount of collected metrics for a particular service in Explore.

`count({service_name="wiki.example.com-mysql"})`

 ![Screenshot_20210215_115349](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/7/7ea85a72863b97668beebd8e03125630e10d4c8b.png)

---

<div class="post-metadata">

**Author:** ![bombcar](https://avatars.discourse-cdn.com/v4/letter/b/0ea827/32.png) [@bombcar](https://forums.percona.com/u/bombcar)\
**Post date:** [February 15, 2021, 10:19am UTC](https://forums.percona.com/t/pmm-doesnt-show-mysql-client-added-nor-does-it-appear-on-scrape/9259/5 "2021-02-15T10:19:37Z")

</div>

I get: 0 series returned - if monitoring VM targets do I need to run PMM on the mysql server itself?

---

<div class="post-metadata">

**Author:** ![Vadim\_Yalovets](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadim_yalovets/32/43_2.png) [@Vadim\_Yalovets](https://forums.percona.com/u/Vadim_Yalovets)\
**Post date:** [February 15, 2021, 10:44am UTC](https://forums.percona.com/t/pmm-doesnt-show-mysql-client-added-nor-does-it-appear-on-scrape/9259/6 "2021-02-15T10:44:10Z")

</div>

Remotely located services can be monitored as well.

 ![Screenshot_20210215_124013](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/3/36679327de8561083cb057ef785ffb5a167c7e43.png)

---

<div class="post-metadata">

**Author:** ![bombcar](https://avatars.discourse-cdn.com/v4/letter/b/0ea827/32.png) [@bombcar](https://forums.percona.com/u/bombcar)\
**Post date:** [February 15, 2021, 10:52am UTC](https://forums.percona.com/t/pmm-doesnt-show-mysql-client-added-nor-does-it-appear-on-scrape/9259/7 "2021-02-15T10:52:44Z")

</div>

I’m confused - the documentation is incorrect? You are supposed to add a remove server using that and NOT via pmm-admin on the remote system itself?

To be precise, I have PMM running on a host ([pmm.example.com](http://pmm.example.com)) and I ran the pmm-admin commands on [wiki.example.com](http://wiki.example.com) (another host) - both are VMs running Linux (not a “cloud database” if that matters). That remote server thing seems to be wanting to do remote MySQL commands across the internet? I guess I could do that but it seems … insecure.

---

<div class="post-metadata">

**Author:** ![Vadim\_Yalovets](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadim_yalovets/32/43_2.png) [@Vadim\_Yalovets](https://forums.percona.com/u/Vadim_Yalovets)\
**Post date:** [February 15, 2021, 11:10am UTC](https://forums.percona.com/t/pmm-doesnt-show-mysql-client-added-nor-does-it-appear-on-scrape/9259/8 "2021-02-15T11:10:08Z")

</div>

It has to be shown on PMM server side according to provided exporter statuses (Running).  
Do you see any node metrics on dashboards for host [wiki.example.com](http://wiki.example.com)?

Could you perform `pmm-admin summary` command and check if any errors are occurred in logs?

---

<div class="post-metadata">

**Author:** ![bombcar](https://avatars.discourse-cdn.com/v4/letter/b/0ea827/32.png) [@bombcar](https://forums.percona.com/u/bombcar)\
**Post date:** [February 15, 2021, 11:17am UTC](https://forums.percona.com/t/pmm-doesnt-show-mysql-client-added-nor-does-it-appear-on-scrape/9259/9 "2021-02-15T11:17:33Z")

</div>

It appears the PMM server only sees itself. Attached are the summary ZIPs from both ends here: [Box](https://mef.box.com/s/qha3bl5qf57ebiwmw89owa3oyyo9usit)

Looking in the errors indicates it may be an IPv6 issue - the client is trying to communicate with the IPv4 of the server which is a private IP? It should only be using the hostnames.

```
2021/02/14 13:51:17 [warn] 1139#1139: *10 an upstream response is buffered to a temporary file /var/cache/nginx/proxy_temp/1/00/0000000001 while reading upstream, client: 192.168.88.108, server: _, request: "GET /graph/public/img/login_background_dark.svg HTTP/1.1", upstream: "http://127.0.0.1:3000/public/img/login_background_dark.svg", host: "192.168.88.160", referrer: "http://192.168.88.160/graph/"

```

---

<div class="post-metadata">

**Author:** ![Vadim\_Yalovets](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadim_yalovets/32/43_2.png) [@Vadim\_Yalovets](https://forums.percona.com/u/Vadim_Yalovets)\
**Post date:** [February 15, 2021, 12:44pm UTC](https://forums.percona.com/t/pmm-doesnt-show-mysql-client-added-nor-does-it-appear-on-scrape/9259/10 "2021-02-15T12:44:46Z")

</div>

We may exclude such issues by specifying IP addresses in a configuration command.  
Please notice that after a config command a mysql service has to be added for monitoring again.  
e.g.  
`pmm-admin config --server-url="https://admin:K4xu5gDEKQhmsyxW@192.168.88.160" --server-insecure-tls 192.168.88.108 generic myNode`

---

<div class="post-metadata">

**Author:** ![bombcar](https://avatars.discourse-cdn.com/v4/letter/b/0ea827/32.png) [@bombcar](https://forums.percona.com/u/bombcar)\
**Post date:** [February 15, 2021, 1:40pm UTC](https://forums.percona.com/t/pmm-doesnt-show-mysql-client-added-nor-does-it-appear-on-scrape/9259/11 "2021-02-15T13:40:12Z")

</div>

I have been using that but with the domain name of the IPv6 host - the IPv4 is unroutable. Should I be using the bracket form of the ipv6?
