Zabbix-agent returning wrong value

[dreas]

We ran into a very weird bug. Using Zabbix Agent v1.4.6 and Zabbix server 1.8.2.

The agent is returning the correct response (0):

host:~$ zabbix_agent -c /etc/zabbix/zabbix_agentd.conf -t mysql.replication.status
mysql.replication.status                      [t|0]
host:~$

The agent log however shows:

mysql.replication.status:120:0
  2603:20100701:121955 Parsed [mysql.replication.status:120:0]
  2603:20100701:121955 In add_check('mysql.replication.status', 120, 0)
  2603:20100701:121955 Run remote command [/home/user/zabbix/mysql.replication.status] Result [1] [1]...
  2603:20100701:121955 For key [mysql.replication.status] received value [1]

The server indeed received value 1, whilst it should definitely be 0. We have had this problem on different machines. Any ideas how it can be resolved? We cannot trust our monitoring if the agent results are wrongly sent of course.

[Alexei]

Are your sure your script does not depend on some environment variables, a special shell, user, whatever? Show us the command.

[dreas]

#!/bin/bash
SQLresponse=`mysql -e "show slave status \G" | grep -i "Slave_SQL_Running"| gawk '{print $2}'`
IOresponse=`mysql  -e "show slave status \G" | grep -i "Slave_IO_Running"| gawk '{print $2}'`

if [ "$SQLresponse" = "No" ]; then
      echo "0"
      exit
fi

if [ "$IOresponse" = "No" ]; then
      echo "0"
      exit 
fi

echo "1"
exit

So manually running the script was indeed responding 0.

[dreas]

Okay, so the user "zabbix" indeed has no MySQL permission (we should pass the password), which is why this is failing :S Apologies! Completely a mistake on our end.

[Alexei]

I knew it!