# Server summary:mysql summary - Exit Status 1

**URL:** <https://forums.percona.com/t/server-summary-mysql-summary-exit-status-1/5212>\
**Category:** PMM 1.x\
**Created:** [November 15, 2016, 12:47pm UTC](https://forums.percona.com/t/server-summary-mysql-summary-exit-status-1/5212 "2016-11-15T12:47:35Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![brian](https://avatars.discourse-cdn.com/v4/letter/b/97f17d/32.png) [@brian](https://forums.percona.com/u/brian)\
**Post date:** [November 15, 2016, 12:47pm UTC](https://forums.percona.com/t/server-summary-mysql-summary-exit-status-1/5212/1 "2016-11-15T12:47:35Z")

</div>

PMM Ver 1.05, Grafana seems fine on OS, Percona-Mysql.

Did a pmm-admin remove mysql:queries, then added back

pmm-mysql-queries-42001.log shows:

# Version: percona-qan-agent 1.0.5

# Basedir: /usr/local/percona/qan-agent

# Listen: 127.0.0.1:42001

# PID: 24463

# API: 192.168.0.24/qan-api

# UUID: 015a594c599943cd62fb5b3f9ad37c00

09:43:40.458053 main.go:165: Starting agent…

09:43:40.458517 main.go:343: Agent is ready

09:43:40.462348 main.go:207: API is ready

09:44:04.674202 ERROR agent exit status 1

09:44:04.674264 WARNING agent Cmd fail: Reply[Cmd:GetMySQLSummary Error:‘exit status 1’ Id:eb6dc548-ac1b-4b9a-7d2d-9f94f7e813b5]

09:44:48.460546 WARNING data-sender Waiting for API to ack qan\_1479231720025795596: read tcp 192.168.0.175:38511-\>192.168.0.24:80: i/o timeout

09:47:30.728374 ERROR agent exit status 1

09:47:30.728464 WARNING agent Cmd fail: Reply[Cmd:GetMySQLSummary Error:‘exit status 1’ Id:adcb7031-93fa-445f-4357-9c6ef3dc3315]

All communication are via LAN with _MY_ firewall rules allowing everything and anything on 192.168.0.0/24 (still digging into what Docker does as far as chains and rules).

On the server, qan-api.log (not sure about this warning yet):

09:44:51 mysql.go:178: WARNING: %!s(int=30) duplicate query class metrics: start\_ts=‘2016-11-15 17:41:00.00059533 +0000 UTC’: MySQL ab743f3216584e9e4c4c6f6e191ef3df

09:44:51 mysql.go:242: WARNING: duplicate global metrics: start\_ts=‘2016-11-15 17:41:00.00059533 +0000 UTC’: MySQL ab743f3216584e9e4c4c6f6e191ef3df

What am I missing, ideas?

---

<div class="post-metadata">

**Author:** ![weber](https://avatars.discourse-cdn.com/v4/letter/w/da6949/32.png) [@weber](https://forums.percona.com/u/weber)\
**Post date:** [November 15, 2016, 3:06pm UTC](https://forums.percona.com/t/server-summary-mysql-summary-exit-status-1/5212/2 "2016-11-15T15:06:25Z")

</div>

For system summary you need to install percona-toolkit package from percona repo on the pmm client node.

---

<div class="post-metadata">

**Author:** ![brian](https://avatars.discourse-cdn.com/v4/letter/b/97f17d/32.png) [@brian](https://forums.percona.com/u/brian)\
**Post date:** [November 21, 2016, 12:52pm UTC](https://forums.percona.com/t/server-summary-mysql-summary-exit-status-1/5212/3 "2016-11-21T12:52:53Z")

</div>

Oops, didn’t see my post right away so reposted/duplicated ;~(\>

percona-toolkit was installed, still same issue.

---

<div class="post-metadata">

**Author:** ![weber](https://avatars.discourse-cdn.com/v4/letter/w/da6949/32.png) [@weber](https://forums.percona.com/u/weber)\
**Post date:** [November 22, 2016, 3:28am UTC](https://forums.percona.com/t/server-summary-mysql-summary-exit-status-1/5212/4 "2016-11-22T03:28:22Z")

</div>

Please verify whether you can run “pt-summary” and “pt-mysql-summary” on the db node.

---

<div class="post-metadata">

**Author:** ![brian](https://avatars.discourse-cdn.com/v4/letter/b/97f17d/32.png) [@brian](https://forums.percona.com/u/brian)\
**Post date:** [November 22, 2016, 7:09am UTC](https://forums.percona.com/t/server-summary-mysql-summary-exit-status-1/5212/5 "2016-11-22T07:09:00Z")

</div>

pt-mysql-summary works only with --ask-pass

---

<div class="post-metadata">

**Author:** ![brian](https://avatars.discourse-cdn.com/v4/letter/b/97f17d/32.png) [@brian](https://forums.percona.com/u/brian)\
**Post date:** [January 3, 2017, 1:27pm UTC](https://forums.percona.com/t/server-summary-mysql-summary-exit-status-1/5212/6 "2017-01-03T13:27:41Z")

</div>

Problem solved.

On Wheezy/Percona client, mkdir /etc/percona-toolkit, vi /etc/percona-toolkit/pt-mysql-summary.conf and insert one line: p=yourpassword

run: pt-mysql-summary --config /etc/percona-toolkit/pt-mysql-summary.conf

Now mysql summary shows up on the pmm server.
