zabbix 监控mysql
本帖最后由 dinggel 于 2016-3-8 16:11 编辑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:
user=zabbixuser
password=zabbix....
运行如下：
# /usr/local/zabbix-2.4.7/bin/zabbix_get -s 192.168.1.10 -k mysql.ping
# mysqladmin -S /data/mysql_data_3306/mysql.sock ping |grep -c alive
1
zabbix web上是这样
这个问题在百度google找了好久 都没解决，请问有人能帮我看下吗？线上等帮助 谢谢
没人吗 检查mysql连接权限问题。
在server上面能连接mysql吗。测试一下先 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 and data type
这是昨天14点54分22秒的事件吗？我本地执行mysqladmin的命令是可以获取的到数据的呀
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 and data type
这是昨天14点54分22秒的事件吗？我本地执行mysqladmin的命令是可以获取的到数据的呀
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
24082:20160309:095032.329 server #1 started
这样说明mysql连接没问题吗
UserParameter=mysql.status后面加上[*]试试，my.cnf中再加入
user=zabbixuser
password=zabbix....
试试 chengjia8410 发表于 2016-3-9 10:21
UserParameter=mysql.status后面加上[*]试试，my.cnf中再加入
user=zabbixuser
我是有在my.cnf加入
user=zabbixuser
password=.....
chengjia8410 发表于 2016-3-9 10:21
UserParameter=mysql.status后面加上[*]试试，my.cnf中再加入
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 于 2016-3-9 11:18 编辑
dinggel 发表于 2016-3-9 09:26
你好！ 有在吗
查了下zabbix_server.log:
25055:20160308:145422.605 item "Zabbix server:mysql.ping"...
检查zabbix 是否有权限调用mysql，mysql.sock文件位置,获取的值是模板是否支持
nonowy 发表于 2016-3-9 11:15
检查zabbix 是否有权限调用mysql，mysql.sock文件位置,获取的值是模板是否支持
...
从root切换到zabbix用户一样是能登录mysql的
dinggel 发表于 2016-3-9 14:10
从root切换到zabbix用户一样是能登录mysql的
报错日志是找不到mysql.sock文件，和获取的值格式问题，有权限访问吗？还是定义的位置和实际位置不一致
nonowy 发表于 2016-3-9 14:37
报错日志是找不到mysql.sock文件，和获取的值格式问题，有权限访问吗？还是定义的位置和实际位置不一致
...
现在看zabbix_server.log的最后日志是这样：
24098:20160309:152747.743 error reason for "java.com:mysql.status" changed: Received value is not suitable for value type
24098:20160309:152747.743 error reason for "java.com:mysql.status" changed: Received value is not suitable for value type and data type
24098:20160309:152747.743 error reason for "java.com:mysql.status" changed: Received value is not suitable for value type and data type
dinggel 发表于 2016-3-9 15:31
现在看zabbix_server.log的最后日志是这样：
24098:20160309:152747.743 error reason for "java.com:m ...
获取的值和定义的类型不匹配
兄弟，我跟你的错误一样，Received value is not suitable for value type
你解决了吗？帮帮我，整了一上午，好痛苦啊 a17419 发表于 2017-5-18 12:07
兄弟，我跟你的错误一样，Received value
太久了 已经忘了，不过看你的报错 是数据类型错了 a17419 发表于 2017-5-18 12:07
兄弟，我跟你的错误一样，Received value
已经告诉你浮点型错误了。。你自己对比模版和上报数据类型 一百个赞。
页:
[1]