go mysql 监控_zabbix自带mysql监控遇到sh: mysql: command not found

最新推荐文章于 2022-04-13 17:04:04 发布

虎猛

最新推荐文章于 2022-04-13 17:04:04 发布

阅读量266

点赞数

文章标签： go mysql 监控

本文链接：https://blog.csdn.net/weixin_28725959/article/details/113566445

版权

在安装Zabbix并添加MySQL监控模板后，遇到Template App MySQL状态显示不支持的问题，错误提示为'sh: mysql: command not found'。解决方案是编辑Zabbix agentd的userparameter_mysql.conf配置文件，将mysql命令替换为其绝对路径，例如'/usr/local/mysql/bin/mysql'。重启Zabbix agentd服务后，监控恢复正常。

摘要由CSDN通过智能技术生成

安装文档添加了mysql监控模版之后，mysql监控一直没用 Template App MySQL: 这几个模版一致是显示不支持，查看报错提示： sh: mysql: command not found 通过修改agentd端的userparameter_mysql.conf解决，修改文件中的执行mysql的语句，写上mysql的绝对路径即可，如下 [root@mysql1 zabbix_agentd.conf.d]# vi userparameter_mysql.conf # For all the following commands HOME should be set to the directory that has .my.cnf file with password information.

# Flexible parameter to grab global variables. On the frontend side, use keys like mysql.status[Com_insert]. # Key syntax is mysql.status[variable]. #UserParameter=mysql.status[*],echo "show global status where Variable_name='$1';" | HOME=/usr/local/zabbix/etc mysql -N | awk '{print $$2}' #原来的语句 UserParameter=mysql.status[*],echo "show global status where Variable_name='$1';" | HOME=/usr/local/zabbix/etc /usr/local/mysql/bin/mysql -N | awk '{print $$2}' #修改后的语句，下面一样

# Flexible parameter to determine database or table size. On the frontend side, use keys like mysql.size[zabbix,history,data]. # Key syntax is mysql.size[,

UserParameter=mysql.ping,HOME=/usr/local/zabbix/etc /usr/local/mysql/bin/mysqladmin ping | grep -c alive #UserParameter=mysql.ping,HOME=/usr/local/zabbix/etc mysqladmin ping | grep -c alive UserParameter=mysql.version,/usr/local/mysql/bin/mysql -V #UserParameter=mysql.version,mysql -V 最后重启zabbix agentd。

site, installation was successful, no errors. Next I created user 'zabbix' with all privileges and database 'zabbix' and imported schema.sql, images.sql and data.sql from Zabbix archive. Then I changed configuration files in /etc/zabbix dir