# Mysql 5.7.x version intgeration with PMM
**URL:** https://forums.percona.com/t/mysql-5-7-x-version-intgeration-with-pmm/14610
**Category:** Percona Distribution for MySQL
**Created:** [March 3, 2022, 8:01am UTC](https://forums.percona.com/t/mysql-5-7-x-version-intgeration-with-pmm/14610 "2022-03-03T08:01:15Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@Anurag\_sharma](https://forums.percona.com/u/Anurag_sharma)
#### Post date: [March 3, 2022, 8:01am UTC](https://forums.percona.com/t/mysql-5-7-x-version-intgeration-with-pmm/14610/1 "2022-03-03T08:01:15Z")
Hi,
can someone please explain and end to end process of mysql 5.7 integration with PMM tool using docker approach?
Note: I tried using below steps but was getting error:
Step1:Created the the mysql5.7 docker container (based on debian GNU favour)
Step2:created and run the PMM server and launched the web ui thriugh local browser.
Step3: while adding mysql instance using PMM dasboard getting “TLS connection not establihed error”
---
### Author:  [@Ivan\_Groenewold](https://forums.percona.com/u/Ivan_Groenewold)
#### Post date: [March 3, 2022, 11:13am UTC](https://forums.percona.com/t/mysql-5-7-x-version-intgeration-with-pmm/14610/2 "2022-03-03T11:13:54Z")
Hello, you should be following the steps here [Install Percona Monitoring and Management](https://www.percona.com/software/pmm/quickstart#)
Adding mysql instances through the web UI is useful for the cases where you don’t have the ability to deploy the pmm2-client directly on the mysql instance. It is preferred to install pmm2-client and use the `pmm-admin add` command on the mysql instance.
---
### Author:  [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [March 3, 2022, 2:04pm UTC](https://forums.percona.com/t/mysql-5-7-x-version-intgeration-with-pmm/14610/3 "2022-03-03T14:04:40Z")
@Anurag_sharma,
Am I correct in understanding that you have 1 docker container with MySQL server and 1 docker container with PMM? If so, then you have two choices: A) access the shell of the mysql container and manually add the pmm agent, or B) use the add remote instance in PMM web UI. Make sure to turn off any SSL/TLS verification. Make sure you have created a monitoring user in MySQL and use those credentials when adding to PMM.
---
### Author:  [@Anurag\_sharma](https://forums.percona.com/u/Anurag_sharma)
#### Post date: [March 7, 2022, 5:05am UTC](https://forums.percona.com/t/mysql-5-7-x-version-intgeration-with-pmm/14610/4 "2022-03-07T05:05:05Z")
Thanks igroene for the response.Will try the method suggested by you.
---
### Author:  [@Anurag\_sharma](https://forums.percona.com/u/Anurag_sharma)
#### Post date: [March 7, 2022, 5:06am UTC](https://forums.percona.com/t/mysql-5-7-x-version-intgeration-with-pmm/14610/5 "2022-03-07T05:06:01Z")
Thanks matthewb for the repnonse. Will try apply method suggested by you.
---
### Author:  [@Anurag\_sharma](https://forums.percona.com/u/Anurag_sharma)
#### Post date: [March 8, 2022, 4:47am UTC](https://forums.percona.com/t/mysql-5-7-x-version-intgeration-with-pmm/14610/6 "2022-03-08T04:47:34Z")
Hi ,
as a continuation of issue stated by me in my first post…
I am succesfully able to proceed with getting Mysql DB sql queries stats into the percona UI dashboard.However remaining stats like CPU,Memory,disk usage etc metrics of my Mysql db instance(dockerised ) are not getting captured.I could only see complete metrics of PMM-server and my local host metrics stats.
Below is the screenshot:
Steps: executed by me as of now:
step1: Created mysql5.7 DB dockerised container
step2: careted and run the PMM
data and PM server
step3: Added the dockerised mysql db instance using Percona UI dashboard by giving hostname ,port details
your help will be highly appreciated.
Thanks
---
### Author:  [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [March 8, 2022, 3:04pm UTC](https://forums.percona.com/t/mysql-5-7-x-version-intgeration-with-pmm/14610/7 "2022-03-08T15:04:54Z")
Yes, this is correct. If you use the UI to add a remote Mysql instance, you will never see the CPU/memory metrics. These metrics can only be gathered by installing the PMM agent on to the same server/container as Mysql.
---
### Author:  [@Anurag\_sharma](https://forums.percona.com/u/Anurag_sharma)
#### Post date: [March 9, 2022, 11:08am UTC](https://forums.percona.com/t/mysql-5-7-x-version-intgeration-with-pmm/14610/8 "2022-03-09T11:08:54Z")
Hi,
I am getting errors and issues while installing the PMM2 client on Mysql5.7(dockerised container based on debian).
I performed below steps after getting inside into MY\_sql 5.7.x(container):
step1)install GnuPG, the GNU Privacy Guard:
_apt install gnupg_
Note: Note gnupg2 was not avaible
step2)Fetch the repository packages from Percona web:
**wget [https://repo.percona.com/apt/percona-release\_latest.zesty\_all.deb](https://repo.percona.com/apt/percona-release_latest.zesty_all.deb)**
Note: I have Replaced $(lsb\_release -sc).as given in percona site, with zesty
Step3)Install the downloaded package
**apt-get install percona-release\_latest.zesty\_all.deb**
Note:Step3 gives error as “Unable to locate package percona-release\_latest.zesty\_all.deb” and “Couldn’t find any package by glob ‘percona-release\_latest.zesty\_all.deb’” and “Couldn’t find any package by regex ‘percona-release\_latest.zesty\_all.deb’”
below is screenshot:
As step3 is failing so I am not ale to proceed further.
Any help will be highly appreciated.
Thanks
---
### Author:  [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [March 9, 2022, 4:21pm UTC](https://forums.percona.com/t/mysql-5-7-x-version-intgeration-with-pmm/14610/9 "2022-03-09T16:21:19Z")
If you download the package, you need to use dpkg to install it, not apt.
```auto
sudo dpkg -i percona-release_latest.zesty_all.deb
```
---
### Author:  [@Anurag\_sharma](https://forums.percona.com/u/Anurag_sharma)
#### Post date: [March 11, 2022, 5:09am UTC](https://forums.percona.com/t/mysql-5-7-x-version-intgeration-with-pmm/14610/10 "2022-03-11T05:09:22Z")
Hi ,
I am getting error as “pmm-agent is not running” when I am trying to make Connection of Client to Server using below command:
“pmm-admin config --server-insecure-tls --server-url=[https://admin:\@pmm.example.com](https://admin:%3Cpassword%3E@pmm.example.com)”
Can you please suggest on that:
Thanks
---
### Author:  [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [March 11, 2022, 3:54pm UTC](https://forums.percona.com/t/mysql-5-7-x-version-intgeration-with-pmm/14610/11 "2022-03-11T15:54:11Z")
Did you install pmm2-agent or pmm-agent? You need v2 as v1 is obsolete.
---
### Author:  [@Anurag\_sharma](https://forums.percona.com/u/Anurag_sharma)
#### Post date: [March 14, 2022, 5:41am UTC](https://forums.percona.com/t/mysql-5-7-x-version-intgeration-with-pmm/14610/12 "2022-03-14T05:41:24Z")
Hi Matthewb,
I have installed the pmmclient2 using below comand "apt-get install pmm2-client " but it is stil throwing error as agent not running.Could you pase suggest
Thanks
---
### Author:  [@Anurag\_sharma](https://forums.percona.com/u/Anurag_sharma)
#### Post date: [March 14, 2022, 6:21am UTC](https://forums.percona.com/t/mysql-5-7-x-version-intgeration-with-pmm/14610/13 "2022-03-14T06:21:16Z")
Hi Matthewb,
I have installed the pmmclient2 using below command "apt-get install pmm2-client " but it is still throwing error as below:
“pmm-agent is not running. Please re-run `pmm-agent setup` with --config-file flag.”
Could you please suggest as I am stuck on this step for a long time.
Thanks
---
### Author:  [@Ivan\_Groenewold](https://forums.percona.com/u/Ivan_Groenewold)
#### Post date: [March 14, 2022, 12:47pm UTC](https://forums.percona.com/t/mysql-5-7-x-version-intgeration-with-pmm/14610/14 "2022-03-14T12:47:15Z")
Hello, you need to start the pmm-agent service before running pmm-admin config command.
---
### Author:  [@Anurag\_sharma](https://forums.percona.com/u/Anurag_sharma)
#### Post date: [March 15, 2022, 11:28am UTC](https://forums.percona.com/t/mysql-5-7-x-version-intgeration-with-pmm/14610/15 "2022-03-15T11:28:20Z")
Hi,
I have started the pmm-agent service using “pmm-agent run” command but I am still getting error .
1)Getting below error when running pm-admin status command:
"Failed to get PMM Agent status from local pmm-agent: pmm-agent is running, but not set up.
2)Getting below error when running pmm-admin config command:
“Checking local pmm-agent status…
pmm-agent is running but does not read configuration from the file. Please restart it with --config-file flag.
Please run `pmm-admin config` with --server-url flag.”
Below is the screenshot for the reference:
Can you please suggest on that
Thanks
---
### Author:  [@Anurag\_sharma](https://forums.percona.com/u/Anurag_sharma)
#### Post date: [March 24, 2022, 4:38am UTC](https://forums.percona.com/t/mysql-5-7-x-version-intgeration-with-pmm/14610/16 "2022-03-24T04:38:29Z")
Hi igroene/matthewb,
I have started the pmm-agent service using “pmm-agent run” command but I am still getting error .
1)Getting below error when running pm-admin status command:
"Failed to get PMM Agent status from local pmm-agent: pmm-agent is running, but not set up.
2)Getting below error when running pmm-admin config command:
“Checking local pmm-agent status…
pmm-agent is running but does not read configuration from the file. Please restart it with --config-file flag.
Please run `pmm-admin config` with --server-url flag.”
Below is the screenshot for the reference:
Can you please suggest on that
Thanks
---
### Author:  [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [March 24, 2022, 2:16pm UTC](https://forums.percona.com/t/mysql-5-7-x-version-intgeration-with-pmm/14610/17 "2022-03-24T14:16:02Z")
Looks like PMM agent is crashing because something else is listening on port 7777. Can you check this?
---
### Author:  [@Anurag\_sharma](https://forums.percona.com/u/Anurag_sharma)
#### Post date: [March 25, 2022, 1:42pm UTC](https://forums.percona.com/t/mysql-5-7-x-version-intgeration-with-pmm/14610/18 "2022-03-25T13:42:24Z")
Hi mattheweb,igroene,perconateam
I have been struggling in setting up percona from last few weeks…I have listed down detailed the steps which has been exceuted by me and errors which I am getting:
Note:
1)I have run the Mysql 5.7.x DB conatiner succesfully.
2)I have run the PMM server also sucessfully using container
On Step1 I am getting stuck from last few weeks.
Step1) I am getting error while configuring PMM server and PMM client connection using below command:
sudo pmm-admin config --server-insecure-tls --server-url=[https://admin:admin@192.x.1.2:443](https://admin:admin@192.x.1.2:443)
output error:
Checking local pmm-agent status…
pmm-agent is not running. Please re-run `pmm-agent setup` with --config-file flag
Step2) I tried peforming several below commands in order to rectify the error but still different new errors:
i)command:
pmm-agent setup --server-address=192.x.1.2:443 --config-file=pmm-agent.yaml
Output error message:
root@4be85634a7c3:/# pmm-agent setup --server-address=192.x.1.2:443 --config-file=pmm-agent.yaml
INFO[2022-03-25T13:18:45.354+00:00] Loading configuration file /pmm-agent.yaml. component=setup
INFO[2022-03-25T13:18:45.354+00:00] Using /usr/local/percona/pmm2/exporters/node\_exporter component=setup
INFO[2022-03-25T13:18:45.354+00:00] Using /usr/local/percona/pmm2/exporters/mysqld\_exporter component=setup
INFO[2022-03-25T13:18:45.354+00:00] Using /usr/local/percona/pmm2/exporters/mongodb\_exporter component=setup
INFO[2022-03-25T13:18:45.355+00:00] Using /usr/local/percona/pmm2/exporters/postgres\_exporter component=setup
INFO[2022-03-25T13:18:45.355+00:00] Using /usr/local/percona/pmm2/exporters/proxysql\_exporter component=setup
INFO[2022-03-25T13:18:45.355+00:00] Using /usr/local/percona/pmm2/exporters/rds\_exporter component=setup
INFO[2022-03-25T13:18:45.355+00:00] Using /usr/local/percona/pmm2/exporters/azure\_exporter component=setup
INFO[2022-03-25T13:18:45.355+00:00] Using /usr/local/percona/pmm2/exporters/vmagent component=setup
Checking local pmm-agent status…
pmm-agent is not running.
Registering pmm-agent on PMM Server…
Failed to register pmm-agent on PMM Server: Post “[https://192.x.1.2:443/v1/management/Node/Register](https://192.x.1.2:443/v1/management/Node/Register)”: x509: cannot validate certificate for 192.x.1.2 because it doesn’t contain any IP SANs.
ii) command:
pmm-agent run
output error messge:
root@4be85634a7c3:/# pmm-agent run
INFO[2022-03-25T13:21:47.536+00:00] Using /usr/local/percona/pmm2/exporters/node\_exporter component=main
INFO[2022-03-25T13:21:47.536+00:00] Using /usr/local/percona/pmm2/exporters/mysqld\_exporter component=main
INFO[2022-03-25T13:21:47.536+00:00] Using /usr/local/percona/pmm2/exporters/mongodb\_exporter component=main
INFO[2022-03-25T13:21:47.536+00:00] Using /usr/local/percona/pmm2/exporters/postgres\_exporter component=main
INFO[2022-03-25T13:21:47.536+00:00] Using /usr/local/percona/pmm2/exporters/proxysql\_exporter component=main
INFO[2022-03-25T13:21:47.536+00:00] Using /usr/local/percona/pmm2/exporters/rds\_exporter component=main
INFO[2022-03-25T13:21:47.537+00:00] Using /usr/local/percona/pmm2/exporters/azure\_exporter component=main
INFO[2022-03-25T13:21:47.537+00:00] Using /usr/local/percona/pmm2/exporters/vmagent component=main
INFO[2022-03-25T13:21:47.537+00:00] Starting local API server on [http://127.0.0.1:7777/](http://127.0.0.1:7777/) … component=local-server/JSON
INFO[2022-03-25T13:21:47.537+00:00] Starting… component=client
ERRO[2022-03-25T13:21:47.538+00:00] PMM Server address is not provided, halting. component=client
INFO[2022-03-25T13:21:47.541+00:00] Started. component=local-server/JSON
^CWARN[2022-03-25T13:21:57.880+00:00] Got SIGINT, shutting down… component=main
INFO[2022-03-25T13:21:57.881+00:00] Done. component=actions-runner
INFO[2022-03-25T13:21:57.881+00:00] Done. component=supervisor
INFO[2022-03-25T13:21:57.881+00:00] Stopped. component=local-server/JSON
INFO[2022-03-25T13:21:57.883+00:00] Done. component=local-server
INFO[2022-03-25T13:21:57.883+00:00] Done. component=main
iii)command: I have checked using “netstat -abn” comand that 7777 port is not being used by any applictaion
iv)command:
pmm-agent --version
Output message:
root@4be85634a7c3:/# pmm-agent --version
ProjectName: pmm-agent
Version: 2.26.0
PMMVersion: 2.26.0
Timestamp: 2022-02-03 14:03:52 (UTC)
FullCommit: c74f5ae58331dc29af34d29c2b6905b8f47cc3ab
root@4be85634a7c3:/#
Attached is the screenshot for the refernce:
Any help will be highly appreciable
Thanks
---
### Author:  [@Anurag\_sharma](https://forums.percona.com/u/Anurag_sharma)
#### Post date: [March 25, 2022, 1:45pm UTC](https://forums.percona.com/t/mysql-5-7-x-version-intgeration-with-pmm/14610/19 "2022-03-25T13:45:02Z")
Hi Matthewb,
I have checked using “netstat -abn” command and noticed that 7777 port is not being used by any application in my host.
Attched is the screenshot for the reference:
Please suggest on this.
Thanks
---
### Author:  [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [March 25, 2022, 2:47pm UTC](https://forums.percona.com/t/mysql-5-7-x-version-intgeration-with-pmm/14610/20 "2022-03-25T14:47:16Z")
Hello @Anurag_sharma ,
I’m not sure what to tell you at this point. I cannot find any Ubuntu Zesty images in AWS to test this out for you. It sounds like you have something non-standard going on with your system. I suggest that you try starting over with a fresh docker install (remove all containers, volumes, images, etc) and follow our documentation. If you would like further assistance, you can contact our support team and they can dive deeper into your issue that we can here on the forums.