zabbix 监控mysql

dinggel

zabbix_agentd.conf:
UnsafeUserParameters=1
UserParameter=mysql.ping,HOME=/usr/local/zabbix-2.4.7/etc/zabbix_agentd.conf.d mysqladmin -S /data/mysql_data_3306/mysql.sock ping |grep -c alive
UserParameter=mysql.version,mysql -V
UserParameter=mysql.status,/usr/local/zabbix-2.4.7/alertscripts/checkmysqlperformance.sh $1



checkmysqlperformance.sh:
MYSQL_SOCK="/data/mysql_data_3306/mysql.sock"
ARGS=1
USER=zabbixuser
MYPATH=/usr/local/mysql/bin
if [ $# -ne "$ARGS" ];then
    echo "Please input one arguement:"
fi
case $1 in
    Uptime)
        result=`$MYPATH/mysqladmin -u$USER   -S $MYSQL_SOCK status |cut -f2 -d":"|cut -f1 -d"T"`
            echo $result
            ;;
        Com_update)
            result=`$MYPATH/mysqladmin -u$USER   -S $MYSQL_SOCK extended-status |grep -w "Com_update"|cut -d"|" -f3`
            echo $result
            ;;
        Slow_queries)
        result=`$MYPATH/mysqladmin -u$USER   -S $MYSQL_SOCK status |cut -f5 -d":"|cut -f1 -d"O"`
                echo $result
                ;;


my.cnf:
[client]
user=zabbixuser
password=zabbix....

运行如下：
[iyunv@java zabbix-2.4.7]# /usr/local/zabbix-2.4.7/bin/zabbix_get -s 192.168.1.10 -k mysql.ping

[iyunv@java zabbix-2.4.7]# mysqladmin -S /data/mysql_data_3306/mysql.sock ping |grep -c alive
1

zabbix web上是这样

这个问题在百度google找了好久 都没解决，请问有人能帮我看下吗？线上等帮助 谢谢

dinggel

没人吗

DTitRAGmNt

检查mysql连接权限问题。

231wd

在server上面能连接mysql吗。测试一下先

dinggel

231wd 发表于 2016-3-9 09:08
在server上面能连接mysql吗。测试一下先

查了下zabbix_server.log:
25055:20160308:145422.605 item "Zabbix server:mysql.ping" became not supported: Received value [^Gmysqladmin: connect to server at 'localhost' failederror: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
这是昨天14点54分22秒的事件吗？  我本地执行mysqladmin的命令是可以获取的到数据的呀

dinggel

DTitRAGmNt 发表于 2016-3-8 21:35
检查mysql连接权限问题。

你好！ 有在吗
查了下zabbix_server.log:
25055:20160308:145422.605 item "Zabbix server:mysql.ping" became not supported: Received value [^Gmysqladmin: connect to server at 'localhost' failederror: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
这是昨天14点54分22秒的事件吗？  我本地执行mysqladmin的命令是可以获取的到数据的呀

dinggel

231wd 发表于 2016-3-9 09:08
在server上面能连接mysql吗。测试一下先

重启了下服务   日志：
25040:20160309:095024.276 syncing history data...
25040:20160309:095024.279 syncing history data done
25040:20160309:095024.280 syncing trends data...
25040:20160309:095024.285 syncing trends data done
25040:20160309:095024.294 Zabbix Server stopped. Zabbix 2.4.7 (revision 56694).
24080:20160309:095032.303 Starting Zabbix Server. Zabbix 2.4.7 (revision 56694).
24080:20160309:095032.303 ****** Enabled features ******
24080:20160309:095032.303 SNMP monitoring:           YES
24080:20160309:095032.303 IPMI monitoring:            NO
24080:20160309:095032.303 WEB monitoring:            YES
24080:20160309:095032.303 VMware monitoring:         YES
24080:20160309:095032.303 Jabber notifications:       NO
24080:20160309:095032.303 Ez Texting notifications:  YES
24080:20160309:095032.303 ODBC:                       NO
24080:20160309:095032.303 SSH2 support:               NO
24080:20160309:095032.303 IPv6 support:               NO
24080:20160309:095032.303 ******************************
24080:20160309:095032.303 using configuration file: /usr/local/zabbix-2.4.7/etc/zabbix_server.conf
24080:20160309:095032.315 current database version (mandatory/optional): 02040000/02040000
24080:20160309:095032.315 required mandatory version: 02040000
24080:20160309:095032.328 server #0 started [main process]
24082:20160309:095032.329 server #1 started [configuration syncer #1]
这样说明mysql连接没问题吗

chengjia8410

UserParameter=mysql.status后面加上[*]试试，my.cnf中再加入
[mysqladmin]
user=zabbixuser
password=zabbix....
试试

dinggel

chengjia8410 发表于 2016-3-9 10:21
UserParameter=mysql.status后面加上

试试，my.cnf中再加入
[mysqladmin]
user=zabbixuser

我是有在my.cnf加入
[client]
user=zabbixuser
password=.....

dinggel

chengjia8410 发表于 2016-3-9 10:21
UserParameter=mysql.status后面加上

试试，my.cnf中再加入
[mysqladmin]
user=zabbixuser

UnsafeUserParameters=1
UserParameter=mysql.ping,HOME=/usr/local/zabbix-2.4.7/etc/zabbix_agentd.conf.d mysqladmin -S /data/mysql_data_3306/mysql.sock ping |grep -c alive
UserParameter=mysql.version,mysql -V
UserParameter=mysql.status

,/usr/local/zabbix-2.4.7/alertscripts/chk_mysql.sh $1
“

”这个是有的  奇怪当时没有复制进去

nonowy

dinggel 发表于 2016-3-9 09:26
你好！ 有在吗
查了下zabbix_server.log:
25055:20160308:145422.605 item "Zabbix server:mysql.ping"  ...

检查zabbix 是否有权限调用mysql，mysql.sock文件位置,获取的值是模板是否支持

dinggel

nonowy 发表于 2016-3-9 11:15
检查zabbix 是否有权限调用mysql，mysql.sock文件位置,获取的值是模板是否支持
...

从root切换到zabbix用户一样是能登录mysql的

nonowy

dinggel 发表于 2016-3-9 14:10
从root切换到zabbix用户一样是能登录mysql的

报错日志是找不到mysql.sock文件，和获取的值格式问题，有权限访问吗？还是定义的位置和实际位置不一致

dinggel

nonowy 发表于 2016-3-9 14:37
报错日志是找不到mysql.sock文件，和获取的值格式问题，有权限访问吗？还是定义的位置和实际位置不一致
...

现在看zabbix_server.log的最后日志是这样：

24098:20160309:152747.743 error reason for "java.com:mysql.status[Questions]" changed: Received value [Warning: Using a password on the command line interface can be insecure.243847] is not suitable for value type [Numeric (float)]
24098:20160309:152747.743 error reason for "java.com:mysql.status[Slow_queries]" changed: Received value [Warning: Using a password on the command line interface can be insecure.55751] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
24098:20160309:152747.743 error reason for "java.com:mysql.status[Uptime]" changed: Received value [Warning: Using a password on the command line interface can be insecure.89002] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]

nonowy

dinggel 发表于 2016-3-9 15:31
现在看zabbix_server.log的最后日志是这样：

24098:20160309:152747.743 error reason for "java.com:m ...

获取的值和定义的类型不匹配

a17419

兄弟，我跟你的错误一样，Received value [sh: /usr/local/zabbix/script/check_mysql.sh: Permission denied] is not suitable for value type [Numeric (float)]
你解决了吗？帮帮我，整了一上午，好痛苦啊

dinggel

a17419 发表于 2017-5-18 12:07
兄弟，我跟你的错误一样，Received value [sh: /usr/local/zabbix/script/check_mysql.sh: Permission deni ...

太久了 已经忘了，  不过看你的报错 是数据类型错了  

hbbdgyb

a17419 发表于 2017-5-18 12:07
兄弟，我跟你的错误一样，Received value [sh: /usr/local/zabbix/script/check_mysql.sh: Permission deni ...

已经告诉你浮点型错误了。。你自己对比模版和上报数据类型

hellghost

一百个赞。