# PMM 1.x **URL:** https://forums.percona.com/c/percona-monitoring-and-management-pmm/percona-monitoring-and-management-pmm-v1/19.md?page=5 [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) **Page:** 6 --- ## [what is the default password of admin user?](https://forums.percona.com/t/what-is-the-default-password-of-admin-user/7238)
**Author:** [@romber](https://forums.percona.com/u/romber)\ **Replies:** 1\ **Last updated:** [October 16, 2019, 9:37pm UTC](https://forums.percona.com/t/what-is-the-default-password-of-admin-user/7238 "2019-10-16T21:37:49Z")
i’m using pmm1 and i found admin user exists, so what is the default password of this user? --- ## [creating users with different privileges for login to PMM](https://forums.percona.com/t/creating-users-with-different-privileges-for-login-to-pmm/6430)
**Author:** [@Jagannath](https://forums.percona.com/u/Jagannath)\ **Replies:** 6\ **Last updated:** [October 15, 2019, 7:11am UTC](https://forums.percona.com/t/creating-users-with-different-privileges-for-login-to-pmm/6430 "2019-10-15T07:11:23Z")
By default, when we click pmm-server URL , it is taking us to summary dashboard homepage without asking user and password. Is it possible to change this default behavior? And also, if we want to create different users wi… --- ## [PMM - Server cannot connect to the Client (ext IP --\> int. IP)](https://forums.percona.com/t/pmm-server-cannot-connect-to-the-client-ext-ip-int-ip/7233)
**Author:** [@Serguei](https://forums.percona.com/u/Serguei)\ **Replies:** 0\ **Last updated:** [October 10, 2019, 12:59pm UTC](https://forums.percona.com/t/pmm-server-cannot-connect-to-the-client-ext-ip-int-ip/7233 "2019-10-10T12:59:32Z")
We have installed PMM server and are trying to connect the very first client to monitor. The client machine (Ubuntu) has internal IP, and the external IP → internal IP forwarding is being done outside of the machine itse… --- ## [Feature to log all queries executed in mysql and view in Percona M and M.](https://forums.percona.com/t/feature-to-log-all-queries-executed-in-mysql-and-view-in-percona-m-and-m/7226)
**Author:** [@John\_Blaze](https://forums.percona.com/u/John_Blaze)\ **Replies:** 1\ **Last updated:** [October 3, 2019, 3:15am UTC](https://forums.percona.com/t/feature-to-log-all-queries-executed-in-mysql-and-view-in-percona-m-and-m/7226 "2019-10-03T03:15:00Z")
Is is possible to save all queries executed in mysql in a file (grouped by days) and view in PMM. --- ## [OVA server change IP](https://forums.percona.com/t/ova-server-change-ip/6192)
**Author:** [@jpage](https://forums.percona.com/u/jpage)\ **Replies:** 5\ **Last updated:** [September 30, 2019, 10:55pm UTC](https://forums.percona.com/t/ova-server-change-ip/6192 "2019-09-30T22:55:24Z")
Hi, I’ve installed pmm-server from the OVA file. After the deployment operation, I’ve changed the hostname and the IP in the file /etc/sysconfig/network-scripts/ifcfg-eth0 but those settings are lost after rebooting. I… --- ## [Configure Static IP for OVA Installation method](https://forums.percona.com/t/configure-static-ip-for-ova-installation-method/7222)
**Author:** [@PrawinNed](https://forums.percona.com/u/PrawinNed)\ **Replies:** 0\ **Last updated:** [September 27, 2019, 2:14pm UTC](https://forums.percona.com/t/configure-static-ip-for-ova-installation-method/7222 "2019-09-27T14:14:39Z")
Hi All, I’m currently in process of testing PMM tool to monitor MySQL DB and preferred installation method is Virtual Appliance using OVA image. I’m looking to setup static IP but could not open the link “Configuring ne… --- ## [pmm-agent error 'value out of range' converting driver.Value types in SUM\_TIMER\_WAIT](https://forums.percona.com/t/pmm-agent-error-value-out-of-range-converting-driver-value-types-in-sum-timer-wait/7219)
**Author:** [@margaash](https://forums.percona.com/u/margaash)\ **Replies:** 1\ **Last updated:** [September 27, 2019, 9:08am UTC](https://forums.percona.com/t/pmm-agent-error-value-out-of-range-converting-driver-value-types-in-sum-timer-wait/7219 "2019-09-27T09:08:43Z")
Hello, I’ve registered two MySQL services (MySQL Community Server (GPL) version 5.7.15) with pmm-admin and query-source=‘perfschema’. When executing ‘pmm-admin list’ one of the two ‘qan-mysql-perfschema-agent’ agents i… --- ## [Is there a yum repo available for PMM.](https://forums.percona.com/t/is-there-a-yum-repo-available-for-pmm/6231)
**Author:** [@jai](https://forums.percona.com/u/jai)\ **Replies:** 9\ **Last updated:** [September 27, 2019, 8:28am UTC](https://forums.percona.com/t/is-there-a-yum-repo-available-for-pmm/6231 "2019-09-27T08:28:51Z")
Hi, All three options to install PMM is out of question for us. I am wondering if there is a yum repo available for PMM or at least install files as .tar.gz will help as well. Thanks, Jai --- ## [pmm always change my log\_output variables!](https://forums.percona.com/t/pmm-always-change-my-log-output-variables/7135)
**Author:** [@Fan](https://forums.percona.com/u/Fan)\ **Replies:** 9\ **Last updated:** [September 19, 2019, 8:35am UTC](https://forums.percona.com/t/pmm-always-change-my-log-output-variables/7135 "2019-09-19T08:35:19Z")
We are building our own slow query platform. we set global log\_output=FILE,TABLE, then slow query will log into mysql.slow\_log table and slow log file. The mysql.slow\_log table is a CSV engine table. so we can use filebe… --- ## [Explain and Example sections are not available in QAN panel](https://forums.percona.com/t/explain-and-example-sections-are-not-available-in-qan-panel/7190)
**Author:** [@leonids2005](https://forums.percona.com/u/leonids2005)\ **Replies:** 4\ **Last updated:** [September 18, 2019, 3:47am UTC](https://forums.percona.com/t/explain-and-example-sections-are-not-available-in-qan-panel/7190 "2019-09-18T03:47:49Z")
When I select a query in QAN panel Explain and Example sections are not available. Do I need to do configure it? I am monitoring AWS RDS MySql. --- ## [Unable to view Query Analytics for specific server](https://forums.percona.com/t/unable-to-view-query-analytics-for-specific-server/7207)
**Author:** [@ritwik\_garg](https://forums.percona.com/u/ritwik_garg)\ **Replies:** 0\ **Last updated:** [September 18, 2019, 2:01am UTC](https://forums.percona.com/t/unable-to-view-query-analytics-for-specific-server/7207 "2019-09-18T02:01:47Z")
Hi All, I have recently installed PMM Platform. PMM-server is setup on a standalone server and currently pmm-client is installed on 3 different MySQL DB servers. I’m able to view Query Analytics for 2 clients and howev… --- ## [Support for Google Cloud Platform in PMM2](https://forums.percona.com/t/support-for-google-cloud-platform-in-pmm2/7189)
**Author:** [@rpedrero](https://forums.percona.com/u/rpedrero)\ **Replies:** 3\ **Last updated:** [September 17, 2019, 4:50am UTC](https://forums.percona.com/t/support-for-google-cloud-platform-in-pmm2/7189 "2019-09-17T04:50:47Z")
It’s possible to include support for GCP in the new version of PMM? It’s mean to monitor the GCP instances & possiblity to download from the marketplace. --- ## [pmm ipv6 compatible](https://forums.percona.com/t/pmm-ipv6-compatible/7192)
**Author:** [@marcio](https://forums.percona.com/u/marcio)\ **Replies:** 0\ **Last updated:** [September 10, 2019, 5:41am UTC](https://forums.percona.com/t/pmm-ipv6-compatible/7192 "2019-09-10T05:41:02Z")
Hello for everyone!! Could anyone confirm if pmm is compatible with ipv6 networks? I have a postgresql server with ipv6 only and I can’t connect to pmm server running ipv6. Thank you. --- ## [PMM on KVM](https://forums.percona.com/t/pmm-on-kvm/7187)
**Author:** [@Federico\_Razzoli](https://forums.percona.com/u/Federico_Razzoli)\ **Replies:** 1\ **Last updated:** [September 7, 2019, 5:09am UTC](https://forums.percona.com/t/pmm-on-kvm/7187 "2019-09-07T05:09:46Z")
Can you provide specific instructions to run PMM as a virtual appliance on KVM (if this is supported)? --- ## [PMM clients cannot use both ssl and password?](https://forums.percona.com/t/pmm-clients-cannot-use-both-ssl-and-password/7185)
**Author:** [@davea](https://forums.percona.com/u/davea)\ **Replies:** 0\ **Last updated:** [September 4, 2019, 11:27am UTC](https://forums.percona.com/t/pmm-clients-cannot-use-both-ssl-and-password/7185 "2019-09-04T11:27:20Z")
I have set up a pmm server and enabled both ssl and added a username and password. When trying to connect with pmm-admin I can not get it to connect using ssl and a username and password. I get this error: This client i… --- ## [Orchestrator update](https://forums.percona.com/t/orchestrator-update/7182)
**Author:** [@Karl1](https://forums.percona.com/u/Karl1)\ **Replies:** 0\ **Last updated:** [September 2, 2019, 8:50pm UTC](https://forums.percona.com/t/orchestrator-update/7182 "2019-09-02T20:50:26Z")
Current PMM (1.17.1) is bundled with Orchestrator 3.0.6 which is quite old (3.1.2 is now available). Is there a plan to refresh the Orchestrator version any time soon? --- ## [Error Adding MariaDb RDS](https://forums.percona.com/t/error-adding-mariadb-rds/7177)
**Author:** [@dalicea](https://forums.percona.com/u/dalicea)\ **Replies:** 0\ **Last updated:** [August 29, 2019, 10:46am UTC](https://forums.percona.com/t/error-adding-mariadb-rds/7177 "2019-08-29T10:46:14Z")
I am attempting to connect a MariaDB RDS (v10.2.15) to PMM and I get an error that reads "dial tcp :3306: i/o timeout. I have a second RDS MariaDB instance (v10.2.21) that I can connect to without an issue. Any ideas wha… --- ## [Monitoring rds postgres with pmm docker container](https://forums.percona.com/t/monitoring-rds-postgres-with-pmm-docker-container/7172)
**Author:** [@peru\_uparkar](https://forums.percona.com/u/peru_uparkar)\ **Replies:** 3\ **Last updated:** [August 27, 2019, 8:25pm UTC](https://forums.percona.com/t/monitoring-rds-postgres-with-pmm-docker-container/7172 "2019-08-27T20:25:11Z")
I am trying to setup rds postgres monitoring with pmm docker contaner. As part of setup , I created aws user plus following user policy plus separate db user with necessary permissions. { “Version”: “2012-10-17”, “Sta… --- ## [How can I turn on the tablestats option?](https://forums.percona.com/t/how-can-i-turn-on-the-tablestats-option/7166)
**Author:** [@peng19832](https://forums.percona.com/u/peng19832)\ **Replies:** 3\ **Last updated:** [August 27, 2019, 2:29am UTC](https://forums.percona.com/t/how-can-i-turn-on-the-tablestats-option/7166 "2019-08-27T02:29:16Z")
When I was using pmm-admin to add a monitoring instance(mysql 5.7) to the server, I found that the tablestats option was turned off by default. Why? And I did not find the option to force open tablestats. How can I tur… --- ## [PMM and postgres RDS](https://forums.percona.com/t/pmm-and-postgres-rds/7001)
**Author:** [@phunmoiblackpeony](https://forums.percona.com/u/phunmoiblackpeony)\ **Replies:** 2\ **Last updated:** [August 26, 2019, 12:32pm UTC](https://forums.percona.com/t/pmm-and-postgres-rds/7001 "2019-08-26T12:32:43Z")
I want to add postgres RDS in PMM, please let me know if this is possible and help me with the steps to configure. --- ## [Unable to start PMM](https://forums.percona.com/t/unable-to-start-pmm/7161)
**Author:** [@peng19832](https://forums.percona.com/u/peng19832)\ **Replies:** 0\ **Last updated:** [August 18, 2019, 8:53pm UTC](https://forums.percona.com/t/unable-to-start-pmm/7161 "2019-08-18T20:53:32Z")
Unable to start PMM after shutting down the server abnormally and restarting manually. How to deal with this situation？ ERROR logs: Aug 18 21:23:56 srv-cd-percona01 dockerd-current: time=“2019-08-18T21:23:56.880031238… --- ## [Is there any way to build a PMM cluster?](https://forums.percona.com/t/is-there-any-way-to-build-a-pmm-cluster/7160)
**Author:** [@peng19832](https://forums.percona.com/u/peng19832)\ **Replies:** 0\ **Last updated:** [August 18, 2019, 8:39pm UTC](https://forums.percona.com/t/is-there-any-way-to-build-a-pmm-cluster/7160 "2019-08-18T20:39:04Z")
Such as the title. Is there any way to build a PMM cluster? --- ## [Delete orphan databases in QAN and PMM System Summary using curl commands](https://forums.percona.com/t/delete-orphan-databases-in-qan-and-pmm-system-summary-using-curl-commands/7155)
**Author:** [@BFPsy](https://forums.percona.com/u/BFPsy)\ **Replies:** 0\ **Last updated:** [August 8, 2019, 10:59am UTC](https://forums.percona.com/t/delete-orphan-databases-in-qan-and-pmm-system-summary-using-curl-commands/7155 "2019-08-08T10:59:18Z")
I have a dozens of old staging databases and their respective agents were removed via curl commands. Curl commands are more practical for my deployment/decommissioning tools. However, the databases still remain in the dr… --- ## [PMM Query analytics is blank](https://forums.percona.com/t/pmm-query-analytics-is-blank/7114)
**Author:** [@tanujbolisetty](https://forums.percona.com/u/tanujbolisetty)\ **Replies:** 2\ **Last updated:** [July 30, 2019, 11:20am UTC](https://forums.percona.com/t/pmm-query-analytics-is-blank/7114 "2019-07-30T11:20:40Z")
We are using PMM to monitor CloudSQL from google. we used the docker install. Initially we saw query analytics show up. Now we cannot see any data. How to troubleshoot the issue. --- ## [problem starting services on pmm client.](https://forums.percona.com/t/problem-starting-services-on-pmm-client/7141)
**Author:** [@leonids2005](https://forums.percona.com/u/leonids2005)\ **Replies:** 0\ **Last updated:** [July 29, 2019, 3:39pm UTC](https://forums.percona.com/t/problem-starting-services-on-pmm-client/7141 "2019-07-29T15:39:48Z")
I have problem starting service on a client. There is a similar ticket for CentOS. I have similar issue running pmm-client on a mysql 5.7 docker image (on Mac) Could you help please? Do you need more details? Here is … --- ## [pmm-admin add client error](https://forums.percona.com/t/pmm-admin-add-client-error/6622)
**Author:** [@donli](https://forums.percona.com/u/donli)\ **Replies:** 3\ **Last updated:** [July 28, 2019, 3:47pm UTC](https://forums.percona.com/t/pmm-admin-add-client-error/6622 "2019-07-28T15:47:18Z")
Hi, I tried to add new client in centos pmm-admin config --server serverip:4444 pmm-admin add linux:metrics pmm-admin list I got SERVICE TYPE NAME LOCAL PORT RUNNING DATA SOURCE OPTIONS linux:metrics server4.com … --- ## [Template variables are not supported in alert queries](https://forums.percona.com/t/template-variables-are-not-supported-in-alert-queries/7119)
**Author:** [@Dillon\_lu](https://forums.percona.com/u/Dillon_lu)\ **Replies:** 2\ **Last updated:** [July 23, 2019, 8:07pm UTC](https://forums.percona.com/t/template-variables-are-not-supported-in-alert-queries/7119 "2019-07-23T20:07:49Z")
Hi all, version: pmm-admin 1.17.1 I tried to create alert message by PMM with “Template variables are not supported in alert queries”. I searched website and found a solution by Percona: to copy and created a new metri… --- ## [can pmm suport multiple account?](https://forums.percona.com/t/can-pmm-suport-multiple-account/7126)
**Author:** [@Fan](https://forums.percona.com/u/Fan)\ **Replies:** 0\ **Last updated:** [July 22, 2019, 9:00pm UTC](https://forums.percona.com/t/can-pmm-suport-multiple-account/7126 "2019-07-22T21:00:10Z")
Obviously DBA needs pmm, sometimes our developer want’s to see some db metrics too(such as qps, threads\_running and slow query). But pmm now only suport one account – the “server\_user”(we use this account to login to pmm… --- ## [MySQL long running queries](https://forums.percona.com/t/mysql-long-running-queries/7125)
**Author:** [@sampathkamineni](https://forums.percona.com/u/sampathkamineni)\ **Replies:** 0\ **Last updated:** [July 22, 2019, 5:40pm UTC](https://forums.percona.com/t/mysql-long-running-queries/7125 "2019-07-22T17:40:34Z")
Is there a way to monitor for Long running queries on a MySQL database and have a dashboard, so that we can setup alerting if a query is running for more than x minutes on a db server. Can someone please point me in the … --- ## [PMM-2.0 beta possible bug](https://forums.percona.com/t/pmm-2-0-beta-possible-bug/7124)
**Author:** [@abirladeanu](https://forums.percona.com/u/abirladeanu)\ **Replies:** 3\ **Last updated:** [July 22, 2019, 6:05am UTC](https://forums.percona.com/t/pmm-2-0-beta-possible-bug/7124 "2019-07-22T06:05:54Z")
Hello. I was trying to test the new PMM 2.0 beta in a local kubernetes cluster with a mounted /srv folder with 0777 rights and it failed to run. I got the following error message in logs: Error: The directory named as… [Previous page](https://forums.percona.com/c/percona-monitoring-and-management-pmm/percona-monitoring-and-management-pmm-v1/19.md?page=4) [Next page](https://forums.percona.com/c/percona-monitoring-and-management-pmm/percona-monitoring-and-management-pmm-v1/19.md?page=6)