# PMM 1.x

**URL:** https://forums.percona.com/c/percona-monitoring-and-management-pmm/percona-monitoring-and-management-pmm-v1/19.md?page=4

[Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md)

**Page:** 5

---

## [pmm-admin can't add a service](https://forums.percona.com/t/pmm-admin-cant-add-a-service/7405)

<div class="topic-metadata">

**Author:** [@InfluentialDave](https://forums.percona.com/u/InfluentialDave)\
**Replies:** 6\
**Last updated:** [February 5, 2020, 6:20am UTC](https://forums.percona.com/t/pmm-admin-cant-add-a-service/7405 "2020-02-05T06:20:39Z")

</div>

Hi there Percona forums, I’ve been trying to set up PMM, I have a server running docker with the PMM-server installed, my client has the pmm-agent installed and the initial connection appeared to succeed using the follo…

---

## [Max pmm clients connected to pmm server](https://forums.percona.com/t/max-pmm-clients-connected-to-pmm-server/7390)

<div class="topic-metadata">

**Author:** [@lioral](https://forums.percona.com/u/lioral)\
**Replies:** 4\
**Last updated:** [January 29, 2020, 6:53am UTC](https://forums.percona.com/t/max-pmm-clients-connected-to-pmm-server/7390 "2020-01-29T06:53:06Z")

</div>

Hi, I was wondering how many clients can connect to pmm server 2 . I remember reading a couple of months ago that only max of 20 nodes can connect to 1 pmm server ( in the previous version ) . Is there a new limit in the…

---

## [PMM Query Analytics - 2 Questions about some Queries](https://forums.percona.com/t/pmm-query-analytics-2-questions-about-some-queries/7377)

<div class="topic-metadata">

**Author:** [@mjctjacinto](https://forums.percona.com/u/mjctjacinto)\
**Replies:** 2\
**Last updated:** [January 25, 2020, 5:23am UTC](https://forums.percona.com/t/pmm-query-analytics-2-questions-about-some-queries/7377 "2020-01-25T05:23:02Z")

</div>

I´m using PMM version 1.17.1 What kind of Queries are Low Ranking Queries, that are on the top of Load of my system? What are INIT DB, that are also consuming some resources?

---

## [percona PMM Server(docker installation) behind Haproxy](https://forums.percona.com/t/percona-pmm-server-docker-installation-behind-haproxy/7392)

<div class="topic-metadata">

**Author:** [@ted\_baker](https://forums.percona.com/u/ted_baker)\
**Replies:** 0\
**Last updated:** [January 21, 2020, 10:06am UTC](https://forums.percona.com/t/percona-pmm-server-docker-installation-behind-haproxy/7392 "2020-01-21T10:06:35Z")

</div>

Hi, I have implemented PMM server(docker installation) and it is behind haproxy. If I access the dashboard I can see the data and graphs. Prometheus queries work well. However when I put it behind haproxy some parts of d…

---

## [Getting error - accept4: too many open files; retrying in x ms](https://forums.percona.com/t/getting-error-accept4-too-many-open-files-retrying-in-x-ms/7387)

<div class="topic-metadata">

**Author:** [@csheridan](https://forums.percona.com/u/csheridan)\
**Replies:** 4\
**Last updated:** [January 17, 2020, 2:52pm UTC](https://forums.percona.com/t/getting-error-accept4-too-many-open-files-retrying-in-x-ms/7387 "2020-01-17T14:52:54Z")

</div>

I’m going to try my best to explain this situation: I have 6 physical servers, and 3 of them were recently upgraded. They now have Ubuntu 18.04 (formerly 14.04). These servers (vhost-01, vhost-02, vhost-03, vhost-04, vh…

---

## [PMM MySql 8.0.11 Instances Not Showing Graphs](https://forums.percona.com/t/pmm-mysql-8-0-11-instances-not-showing-graphs/6748)

<div class="topic-metadata">

**Author:** [@baasp](https://forums.percona.com/u/baasp)\
**Replies:** 28\
**Last updated:** [January 17, 2020, 11:39am UTC](https://forums.percona.com/t/pmm-mysql-8-0-11-instances-not-showing-graphs/6748 "2020-01-17T11:39:29Z")

</div>

I have a mixed environment of MySql 5.x and 8.0.11 Instances. The 5.x Instances are Enterprise and the 8.0.11 are Community. I have no issues in monitoring the MySql 5.x with PMM. The 8.0.11 instances do not gather al…

---

## [Enable basic auth on prometheus](https://forums.percona.com/t/enable-basic-auth-on-prometheus/7386)

<div class="topic-metadata">

**Author:** [@cktak](https://forums.percona.com/u/cktak)\
**Replies:** 0\
**Last updated:** [January 17, 2020, 2:58am UTC](https://forums.percona.com/t/enable-basic-auth-on-prometheus/7386 "2020-01-17T02:58:19Z")

</div>

I am using PMM server 2.2.0 in docker. I want to enable the basic auth on prometheus so I do it from the Web UI: Configuration → Data Sources → Prometheus Enable “Basic auth” Enter “User” and “Password” in “Basic Auth …

---

## [rds\_exporter](https://forums.percona.com/t/rds-exporter/7383)

<div class="topic-metadata">

**Author:** [@mateusl](https://forums.percona.com/u/mateusl)\
**Replies:** 0\
**Last updated:** [January 14, 2020, 12:52pm UTC](https://forums.percona.com/t/rds-exporter/7383 "2020-01-14T12:52:59Z")

</div>

HI all, I’m trying rds\_exporter (\[url\]https://github.com/percona/rds\_exporter/\[/url\]). I would like to know if in the config.yml can I use some regex rule to get all rds that starts with dev-\* por example. instances: …

---

## ["No data" on PXC/Galera Cluster Summary](https://forums.percona.com/t/no-data-on-pxc-galera-cluster-summary/7360)

<div class="topic-metadata">

**Author:** [@milosb](https://forums.percona.com/u/milosb)\
**Replies:** 7\
**Last updated:** [December 28, 2019, 2:46pm UTC](https://forums.percona.com/t/no-data-on-pxc-galera-cluster-summary/7360 "2019-12-28T14:46:46Z")

</div>

After updating the PMM server docker instance from 2.1.0-\>2.2.0 I noticed that all graphs in this dashboard no longer show any data. I have also updated the clients on all of the systems monitored. Interestingly enough,…

---

## [Trusted certificates (SSL/TLS) instead of self signed cdrtificates](https://forums.percona.com/t/trusted-certificates-ssl-tls-instead-of-self-signed-cdrtificates/7337)

<div class="topic-metadata">

**Author:** [@stefan-nl](https://forums.percona.com/u/stefan-nl)\
**Replies:** 4\
**Last updated:** [December 19, 2019, 5:00pm UTC](https://forums.percona.com/t/trusted-certificates-ssl-tls-instead-of-self-signed-cdrtificates/7337 "2019-12-19T17:00:45Z")

</div>

Does PMM support the use of “trusted” certificates, i.e. let’s encrypt instead via some docker environment variable?

---

## [Running PMM RDS Exporter with custom Monitoring setup](https://forums.percona.com/t/running-pmm-rds-exporter-with-custom-monitoring-setup/7354)

<div class="topic-metadata">

**Author:** [@kumarDev](https://forums.percona.com/u/kumarDev)\
**Replies:** 0\
**Last updated:** [December 19, 2019, 3:39am UTC](https://forums.percona.com/t/running-pmm-rds-exporter-with-custom-monitoring-setup/7354 "2019-12-19T03:39:46Z")

</div>

Hi Everyone, we want to use percona rds-exporter with our custom prometheus-grafana-alertmanager monitoring setup. Is it possible to run rds-exporter of percona separately? Because if i am able to achieve that then the o…

---

## [Add redis\_exporter to Prometheus in pmm2](https://forums.percona.com/t/add-redis-exporter-to-prometheus-in-pmm2/7353)

<div class="topic-metadata">

**Author:** [@shiron](https://forums.percona.com/u/shiron)\
**Replies:** 0\
**Last updated:** [December 19, 2019, 2:24am UTC](https://forums.percona.com/t/add-redis-exporter-to-prometheus-in-pmm2/7353 "2019-12-19T02:24:17Z")

</div>

Hello, Do you have to config PMM2 to monitor redis server via prometheus redis\_exporter? I search in blog and saw the link: \[url\]Does Percona Monitoring and Management (PMM) Support External Monitoring Services? Yes It…

---

## [How to add custom scrape target to prometheus.yml?](https://forums.percona.com/t/how-to-add-custom-scrape-target-to-prometheus-yml/7338)

<div class="topic-metadata">

**Author:** [@stefan-nl](https://forums.percona.com/u/stefan-nl)\
**Replies:** 2\
**Last updated:** [December 13, 2019, 12:11pm UTC](https://forums.percona.com/t/how-to-add-custom-scrape-target-to-prometheus-yml/7338 "2019-12-13T12:11:06Z")

</div>

I want to scrape metrics from a (windows) node that exposes its metrics on port 9182 ( \[url\]https://github.com/martinlindhe/wmi\_exporter\[/url\]). Currently the only way to add nodes to PMM seems to be via pmm-admin which …

---

## [PMM constantly disconnects/ fails and requires reboot to reconnect](https://forums.percona.com/t/pmm-constantly-disconnects-fails-and-requires-reboot-to-reconnect/7334)

<div class="topic-metadata">

**Author:** [@ealdridge](https://forums.percona.com/u/ealdridge)\
**Replies:** 2\
**Last updated:** [December 6, 2019, 9:19am UTC](https://forums.percona.com/t/pmm-constantly-disconnects-fails-and-requires-reboot-to-reconnect/7334 "2019-12-06T09:19:37Z")

</div>

We are seeing PMM disconnect on multiple systems hosted in AWS. This results in the loss of our monitoring data (we are mostly concerned with the MySQL Amazon Aurora Metrics) during the periods of time that it is down. U…

---

## [pmm-admin add mysql - invalid username or password](https://forums.percona.com/t/pmm-admin-add-mysql-invalid-username-or-password/7330)

<div class="topic-metadata">

**Author:** [@holala](https://forums.percona.com/u/holala)\
**Replies:** 5\
**Last updated:** [December 6, 2019, 7:02am UTC](https://forums.percona.com/t/pmm-admin-add-mysql-invalid-username-or-password/7330 "2019-12-06T07:02:55Z")

</div>

Hello, I’m trying to add mysql monitoring: sudo pmm-admin add mysql --query-source=perfschema --username=XXX --password=XXX --debug Username/password are correct, I can login to mysql locally, to 127.0.0.1. But I alw…

---

## [How to install PMN on real hardware, no VM, Docker, AWS](https://forums.percona.com/t/how-to-install-pmn-on-real-hardware-no-vm-docker-aws/7081)

<div class="topic-metadata">

**Author:** [@rickymouse](https://forums.percona.com/u/rickymouse)\
**Replies:** 4\
**Last updated:** [November 26, 2019, 11:34am UTC](https://forums.percona.com/t/how-to-install-pmn-on-real-hardware-no-vm-docker-aws/7081 "2019-11-26T11:34:47Z")

</div>

We want to install PMM on real hardware. No VM, docker, AWS. Does anyone have the instructions for what needs to be installed ? The only method of deployment is VM, Docker, AWS. We will not use PMM if that is the only wa…

---

## [\[PMM\] 1.17.1 to 1.17.2 - Update Issue](https://forums.percona.com/t/pmm-1-17-1-to-1-17-2-update-issue/7305)

<div class="topic-metadata">

**Author:** [@Valentin](https://forums.percona.com/u/Valentin)\
**Replies:** 6\
**Last updated:** [November 26, 2019, 11:19am UTC](https://forums.percona.com/t/pmm-1-17-1-to-1-17-2-update-issue/7305 "2019-11-26T11:19:36Z")

</div>

Hi eveyone, I can’t update my PMM Server (1.17.1) to the latest version : + echo 'CMD: /usr/bin/pmm-update ' CMD: /usr/bin/pmm-update + echo 'PID: 4365' PID: 4365 + echo 'LOG: /srv/update/log/pmm-update\_\_2019-11-22T13:…

---

## [PMM Server /ping Bad Gateway](https://forums.percona.com/t/pmm-server-ping-bad-gateway/7314)

<div class="topic-metadata">

**Author:** [@Patrick](https://forums.percona.com/u/Patrick)\
**Replies:** 0\
**Last updated:** [November 26, 2019, 8:21am UTC](https://forums.percona.com/t/pmm-server-ping-bad-gateway/7314 "2019-11-26T08:21:07Z")

</div>

We have a PMM server instance (v1.17.2) running as a docker container on an EC2 instance. Unfortunately, we have some issues regarding linux metrics. It seems to be the case that the PMM server is misconfigured, but I’m …

---

## [pmm-server-1.17.2 PMM Installation Wizard first page issue](https://forums.percona.com/t/pmm-server-1-17-2-pmm-installation-wizard-first-page-issue/7310)

<div class="topic-metadata">

**Author:** [@holala](https://forums.percona.com/u/holala)\
**Replies:** 0\
**Last updated:** [November 25, 2019, 7:33am UTC](https://forums.percona.com/t/pmm-server-1-17-2-pmm-installation-wizard-first-page-issue/7310 "2019-11-25T07:33:55Z")

</div>

Hello, on the first page of installation wizard (/password-page/ovf/account-credentials-ovf), after entering new user, I get: \*Cannot set Grafana password This is latest VM appliance (pmm-server-1.17.2.ova). Please hel…

---

## [Monitor size of a mysql table using PMM, and alert](https://forums.percona.com/t/monitor-size-of-a-mysql-table-using-pmm-and-alert/7291)

<div class="topic-metadata">

**Author:** [@sahuk](https://forums.percona.com/u/sahuk)\
**Replies:** 1\
**Last updated:** [November 19, 2019, 2:34am UTC](https://forums.percona.com/t/monitor-size-of-a-mysql-table-using-pmm-and-alert/7291 "2019-11-19T02:34:05Z")

</div>

We want to monitor the size of a particular table, and want PMM to alert us if grows beyond a fixed number of row limit. Does anybody know how can we achieve this using PMM, if possible

---

## [No query analytics after upgrade from 1.17.1 to 1.17.2](https://forums.percona.com/t/no-query-analytics-after-upgrade-from-1-17-1-to-1-17-2/7288)

<div class="topic-metadata">

**Author:** [@davea](https://forums.percona.com/u/davea)\
**Replies:** 3\
**Last updated:** [November 12, 2019, 11:26am UTC](https://forums.percona.com/t/no-query-analytics-after-upgrade-from-1-17-1-to-1-17-2/7288 "2019-11-12T11:26:57Z")

</div>

I upgraded my server and clients and now there is no analytics data. Says mysql not configured correctly. It was working before and I triple checked my mysql servers and verified that they are configured correctly as per…

---

## [Running pmm agent as non-root](https://forums.percona.com/t/running-pmm-agent-as-non-root/7293)

<div class="topic-metadata">

**Author:** [@elshamouty](https://forums.percona.com/u/elshamouty)\
**Replies:** 0\
**Last updated:** [November 12, 2019, 8:41am UTC](https://forums.percona.com/t/running-pmm-agent-as-non-root/7293 "2019-11-12T08:41:18Z")

</div>

Hello All, I have been using PMM for a while now, and I am wondering if it is possible to run pmm-agent as a non privileged user on monitored hosts? It runs as root by default and this is imposing some problems with sec…

---

## [Panel plugin not found: pmm-singlestat-panel](https://forums.percona.com/t/panel-plugin-not-found-pmm-singlestat-panel/7292)

<div class="topic-metadata">

**Author:** [@chris-card](https://forums.percona.com/u/chris-card)\
**Replies:** 0\
**Last updated:** [November 12, 2019, 5:17am UTC](https://forums.percona.com/t/panel-plugin-not-found-pmm-singlestat-panel/7292 "2019-11-12T05:17:39Z")

</div>

I am trying to use the dashboards from \[url\]https://github.com/percona/grafana-dashboards\[/url\] with Grafana (v6.3.0-beta1) by importing the json files, but on the MySQL Overview dashboard the Buffer Pool Size of Total R…

---

## [CentOS7 linux metrics errors logged after update from 1.17.1 to 1.17.2.](https://forums.percona.com/t/centos7-linux-metrics-errors-logged-after-update-from-1-17-1-to-1-17-2/7275)

<div class="topic-metadata">

**Author:** [@Reio\_Remma](https://forums.percona.com/u/Reio_Remma)\
**Replies:** 5\
**Last updated:** [November 8, 2019, 6:35am UTC](https://forums.percona.com/t/centos7-linux-metrics-errors-logged-after-update-from-1-17-1-to-1-17-2/7275 "2019-11-08T06:35:12Z")

</div>

I updated pmm-client a week ago an today noticed 180MB of pmm-linux-metrics log filed with: time=“2019-11-03T22:35:51+02:00” level=error msg=“Error reading textfile collector directory /usr/local/percona/pmm-client/text…

---

## [\*Error 9002: SSL connection is required. Please specify SSL options and retry.](https://forums.percona.com/t/error-9002-ssl-connection-is-required-please-specify-ssl-options-and-retry/6760)

<div class="topic-metadata">

**Author:** [@kamal2222ahmed](https://forums.percona.com/u/kamal2222ahmed)\
**Replies:** 2\
**Last updated:** [November 8, 2019, 6:22am UTC](https://forums.percona.com/t/error-9002-ssl-connection-is-required-please-specify-ssl-options-and-retry/6760 "2019-11-08T06:22:02Z")

</div>

I have installed percona pmm monitoring using Docker: $ docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 345ed86acdad docksal/ssh-agent:1.2 “docker-entrypoint.s…” 28 hours ago Up 16 hours (healthy) dock…

---

## [Alert](https://forums.percona.com/t/alert/7281)

<div class="topic-metadata">

**Author:** [@Kendzi](https://forums.percona.com/u/Kendzi)\
**Replies:** 0\
**Last updated:** [November 6, 2019, 7:56am UTC](https://forums.percona.com/t/alert/7281 "2019-11-06T07:56:27Z")

</div>

Hello I just started to use PMM2 but I can’t add any alert rule, alerting test is working without any problem ? Can someone tell me how to configure/enable alerting ? Fo instance I just shut down a serwer and I did not …

---

## [How to use the qan only in my system?](https://forums.percona.com/t/how-to-use-the-qan-only-in-my-system/7270)

<div class="topic-metadata">

**Author:** [@zhandy](https://forums.percona.com/u/zhandy)\
**Replies:** 1\
**Last updated:** [October 31, 2019, 8:01pm UTC](https://forums.percona.com/t/how-to-use-the-qan-only-in-my-system/7270 "2019-10-31T20:01:31Z")

</div>

Hi, first a big thank you to the percona stuff. I love PMM! My english is poor, I am very sorry about that. I have another exporter node in my CentOS7 Server before, it include linux\_node and mysql\_node.and now , when…

---

## [PMM Query Analytics for Postgres & Aurora Postgres](https://forums.percona.com/t/pmm-query-analytics-for-postgres-aurora-postgres/7235)

<div class="topic-metadata">

**Author:** [@suvkum](https://forums.percona.com/u/suvkum)\
**Replies:** 2\
**Last updated:** [October 23, 2019, 10:12am UTC](https://forums.percona.com/t/pmm-query-analytics-for-postgres-aurora-postgres/7235 "2019-10-23T10:12:50Z")

</div>

Did anyone tried query analytics for postgres and RDS? In status for qan-postgresql-pgstatements-agent it show Waiting. Agent type Status Agent ID Service ID pmm-agent connected /agent\_id/03b9432d-1492-45d2-959b-051904…

---

## [PMM postgres\_exporter returns database does not exist](https://forums.percona.com/t/pmm-postgres-exporter-returns-database-does-not-exist/7255)

<div class="topic-metadata">

**Author:** [@margaash](https://forums.percona.com/u/margaash)\
**Replies:** 1\
**Last updated:** [October 23, 2019, 10:03am UTC](https://forums.percona.com/t/pmm-postgres-exporter-returns-database-does-not-exist/7255 "2019-10-23T10:03:18Z")

</div>

Hello, I’m using pmm2-client-2.0.1-5.el7.x86\_64 under CentOS Linux release 7.6 When using pmm-admin to add a PostgreSQL Service, I execute: pmm-admin add postgresql --username=dod\_pmm --password=xxxxx pmm\_config\_test …

---

## [Problem after hostname change](https://forums.percona.com/t/problem-after-hostname-change/7253)

<div class="topic-metadata">

**Author:** [@tasso85](https://forums.percona.com/u/tasso85)\
**Replies:** 0\
**Last updated:** [October 22, 2019, 5:20am UTC](https://forums.percona.com/t/problem-after-hostname-change/7253 "2019-10-22T05:20:19Z")

</div>

We recently changed the hostname of one of the servers we are monitoring using percona monitoring for MySQL. After the hostname change, I noticed that on the monitor dashboard, the server was still showing up with its o…

[Previous page](https://forums.percona.com/c/percona-monitoring-and-management-pmm/percona-monitoring-and-management-pmm-v1/19.md?page=3)

[Next page](https://forums.percona.com/c/percona-monitoring-and-management-pmm/percona-monitoring-and-management-pmm-v1/19.md?page=5)
