# Server summary:mysql summary - Exit Status 1 **URL:** \ **Category:** PMM 1.x\ **Created:** [February 18, 2017, 2:26am UTC](https://forums.percona.com/t/server-summary-mysql-summary-exit-status-1/5419 "2017-02-18T02:26:02Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![busy882376](https://avatars.discourse-cdn.com/v4/letter/b/f9ae1b/32.png) [@busy882376](https://forums.percona.com/u/busy882376)\ **Post date:** [February 18, 2017, 2:26am UTC](https://forums.percona.com/t/server-summary-mysql-summary-exit-status-1/5419/1 "2017-02-18T02:26:02Z")
I get “Exit Status 1” error in mysql summary and query error log like this: [root@test log]# cat pmm-mysql-queries-0.log # Version: percona-qan-agent 1.0.7 # Basedir: /usr/local/percona/qan-agent # PID: 11372 # API: 192.168.1.2/qan-api # UUID: e7b416c0e9c0466162728fb8840ab066 2017/02/18 14:46:17.492888 main.go:165: Starting agent… 2017/02/18 14:46:17.493570 main.go:346: Agent is ready 2017/02/18 14:46:17.498969 main.go:207: API is ready 2017/02/18 14:54:50.460563 ERROR agent exit status 1 2017/02/18 14:54:50.460641 WARNING agent Cmd fail: Reply[Cmd:GetMySQLSummary Error:‘exit status 1’ Id:17731696-8329-44ce-6aee-90381f02f738] 2017/02/18 15:39:13.971141 ERROR agent exit status 1 2017/02/18 15:39:13.971279 WARNING agent Cmd fail: Reply[Cmd:GetMySQLSummary Error:‘exit status 1’ Id:d1c1ff6f-a90b-4e82-7bb3-6fa556491672] and read this [https://www.percona.com/forums/questions-discussions/percona-monitoring-and-management/46424-server-summary-mysql-summary-exit-status-1](https://www.percona.com/forums/questions-discussions/percona-monitoring-and-management/46424-server-summary-mysql-summary-exit-status-1) I install percona-toolkit and create conf file like this: [root@i-zryeyuku mysql]# cat /etc/percona-toolkit/pt-mysql-summary.conf p=abcd1234 socket=/tmp/mysql1.sock I can run pt-mysql-summary like this: [root@test log]# pt-mysql-summary mysql: [Warning] Using a password on the command line interface can be insecure. # Percona Toolkit MySQL Summary Report System time | 2017-02-18 07:46:27 UTC (local TZ: CST +0800) … … but still get this error,What am I missing? ---
**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\ **Post date:** [February 20, 2017, 3:28am UTC](https://forums.percona.com/t/server-summary-mysql-summary-exit-status-1/5419/2 "2017-02-20T03:28:19Z")
Hi, can you try to remove node and add it again ```auto pmm-admin remove mysql pmm-admin add mysql pmm-admin start --all ``` and check status after that, during add procedure should check DB access and configure credentials correctly. ---
**Author:** ![liuqian](https://avatars.discourse-cdn.com/v4/letter/l/3da27b/32.png) [@liuqian](https://forums.percona.com/u/liuqian)\ **Post date:** [February 20, 2017, 4:23am UTC](https://forums.percona.com/t/server-summary-mysql-summary-exit-status-1/5419/3 "2017-02-20T04:23:17Z")
The machine has tow MySQL instance has this problem ---
**Author:** ![busy882376](https://avatars.discourse-cdn.com/v4/letter/b/f9ae1b/32.png) [@busy882376](https://forums.percona.com/u/busy882376)\ **Post date:** [February 20, 2017, 4:27am UTC](https://forums.percona.com/t/server-summary-mysql-summary-exit-status-1/5419/4 "2017-02-20T04:27:43Z")
Your method I tried many times, but still ineffective. But I am install in a local virtual environment, no problem? ---
**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\ **Post date:** [February 21, 2017, 6:06am UTC](https://forums.percona.com/t/server-summary-mysql-summary-exit-status-1/5419/5 "2017-02-21T06:06:06Z")
hm, quite strange, can you give me output of the following command: ```auto env -i /usr/bin/pt-mysql-summary >/dev/null; echo EC: $? ``` ---
**Author:** ![busy882376](https://avatars.discourse-cdn.com/v4/letter/b/f9ae1b/32.png) [@busy882376](https://forums.percona.com/u/busy882376)\ **Post date:** [February 22, 2017, 6:56am UTC](https://forums.percona.com/t/server-summary-mysql-summary-exit-status-1/5419/6 "2017-02-22T06:56:28Z")
output like this: [root@test conf]# env -i /usr/bin/pt-mysql-summary \>/dev/null; echo EC: $? 2017\_02\_22\_20\_07\_31 Cannot execute mysql. Check that it is in PATH. EC: 1 i try add path like this,but not working export PATH=/usr/bin:/usr/local/mysql/bin:$PATH i try to use mysql commad connect mysql server is ok [root@test ~]# mysql -uroot -p -S /tmp/mysql1.sock Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 114962 Server version: 5.7.17-log MySQL Community Server (GPL) Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement. mysql\> ---
**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\ **Post date:** [February 22, 2017, 9:19am UTC](https://forums.percona.com/t/server-summary-mysql-summary-exit-status-1/5419/7 "2017-02-22T09:19:29Z")
can you try to add the following string as third line into script? ```auto export PATH=/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/usr/local/mysql/bin ``` and try again? ---
**Author:** ![busy882376](https://avatars.discourse-cdn.com/v4/letter/b/f9ae1b/32.png) [@busy882376](https://forums.percona.com/u/busy882376)\ **Post date:** [February 22, 2017, 8:49pm UTC](https://forums.percona.com/t/server-summary-mysql-summary-exit-status-1/5419/8 "2017-02-22T20:49:44Z")
I tried your method, but it did not work i run pt-mysql-summary get this error: [root@test bin]# pt-mysql-summary /usr/bin/pt-mysql-summary: line 552: mktemp: command not found /usr/bin/pt-mysql-summary: line 26: date: command not found Cannot make secure tmpdir This host is provided by the cloud service,I guess they change something that we do not know, There is no problem installing on the local virtual machine in the same way ---
**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\ **Post date:** [February 23, 2017, 12:43am UTC](https://forums.percona.com/t/server-summary-mysql-summary-exit-status-1/5419/9 "2017-02-23T00:43:05Z")
can you locate path to mktemp and date manually and add it to PATH variable? ```auto which mktemp which date ``` ---
**Author:** ![busy882376](https://avatars.discourse-cdn.com/v4/letter/b/f9ae1b/32.png) [@busy882376](https://forums.percona.com/u/busy882376)\ **Post date:** [February 23, 2017, 7:57am UTC](https://forums.percona.com/t/server-summary-mysql-summary-exit-status-1/5419/10 "2017-02-23T07:57:30Z")
i run comd like this: [root@i-gnll91eq ~]# which mktemp /bin/mktemp [root@i-gnll91eq ~]# which date /bin/date and i add to PATH export PATH=$PATH:/usr/local/mysql/bin:/bin run in shell is ok [root@test ~]# pt-mysql-summary mysql: [Warning] Using a password on the command line interface can be insecure. # Percona Toolkit MySQL Summary Report System time | 2017-02-23 13:21:17 UTC (local TZ: CST +0800) … … … restart all pmm client server [root@test ~]#pmm-admin restart --all but still see “exit status 1” in web page.why runing in shell is ok,but can not invoke by server? ---
**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\ **Post date:** [February 24, 2017, 2:18am UTC](https://forums.percona.com/t/server-summary-mysql-summary-exit-status-1/5419/11 "2017-02-24T02:18:18Z")
> [@](#): > > why runing in shell is ok,but can not invoke by server? in 99% because systemd runs apps without environment variables. can you try to run the following command one more time ```auto env -i /usr/bin/pt-mysql-summary >/dev/null; echo EC: $? ``` this command 1. cut all environment variables (like systemd does), so we should see any errors on STDERR 2. redirect STDOUT to /dev/null, so we can see STDERR output only 3. print exist status as “EC: 1” line in the end ---
**Author:** ![busy882376](https://avatars.discourse-cdn.com/v4/letter/b/f9ae1b/32.png) [@busy882376](https://forums.percona.com/u/busy882376)\ **Post date:** [March 1, 2017, 3:46am UTC](https://forums.percona.com/t/server-summary-mysql-summary-exit-status-1/5419/12 "2017-03-01T03:46:56Z")
you are right,systemd runs apps without environment variables. I install use source code and saved it to a non-default directory. I try the way like this: ln -s /apps/mysql/bin/\* /usr/bin/ and the problem is solved.Thank you.