Fix for Munin MySQL Monitoring Plugin Graph Not Showing or Blank修复munin MySQL的监测插件图无法显示或空白

Munin is a monitoring tool used to survey and monitor the performance of computers, networks, SANs, applications, databases, weather measurements and other parameters. munin是一个监测工具，用来调查和监测的表现，计算机，网络， SAN的，应用程序，数据库，天气测量和其他参数。 Munin remembers and records information it captured and presents them in graphs through a web interface. munin回忆和记录资料，它抓获，并介绍了他们在图通过一个Web界面。 cPanel, through WebHost Manager (WHM) has added the Munin Service Monitor as easily installed plugin to monitor the web host and check the capacity of resources available.的cPanel ，通过网页主机服务经理（的WHM ）中加入了munin服务监察一样容易安装插件监察网页主机和检查的能力，可用的资源。

Easily install,容易安装， Munin munin version 1.24 works immediately once webmaster installs it on the server through cPanel/WHM, and start checking and capturing various resources’ usage reading, including MySQL nodes such as MySQL throughputs, MySQL queries, MySQL Slow Queries, and MySQL threads.版本1.24工程后立即网站管理员安装在服务器上通过的cPanel /的WHM ，并开始检查和捕捉各种资源的使用读，包括MySQL的节点，例如MySQL的吞吐量， MySQL的查询， MySQL和缓慢的疑问，和MySQL线程。 However, if you restart the server, Munin will fail to monitor MySQL nodes.不过，如果您重新启动服务器， munin会失败，监察MySQL的节点。 No information is capture, and the graphs is no longer updated with statistics and appears blank.没有资料撷取，和图形不再是最新的统计数字，并出现空白。 Sometimes, the MySQL graphs blank symptom may happen even when web server is not rebooted.有时候， MySQL的图的空白症状可能会发生，甚至当Web服务器是不重新启动。

The error is due to a bug in a Perl library Munin uses which causes $PATH variable to be lost, and then causes the plugin cannot find the mysqladmin program which it needs to retrieve the numbers to populate in the graphs.错误是由于一个错误，在一个图书馆的Perl munin用途，导致美元PATH变量，以遗失，然后导致插件无法找到mysqladmin程序，它需要检索编号，以填充在图形。 Uninstall and reinstall Munin Service Monitor may make it works again, however, a more permanent solution is to hardcode the path of the program, which will fix the problem.卸载并重新安装munin服务监控可能使工程再次然而，一个更永久性的解决办法是硬编码路径的程序，这将解决这一问题。 Here the guide on how to specify the path to mysqladmin to Munin.在这里，指导如何指定的路径mysqladmin ，以munin 。

Fix for Munin installed by cPanel/WHM 修复munin安装的cPanel /的WHM

1. Determine where is mysqladmin program located with the one of the following command:确定在何处是mysqladmin程序位于同一个以下命令：

   which mysqladmin其中mysqladmin
   type mysqladmin类型mysqladmin
   locate mysqladmin找到mysqladmin

   If should return a path to mysqladmin which looks similar or the same to /usr/bin/mysqladmin.如果要返回的路径mysqladmin ，这看起来类似或相同的为/ usr /斌/ mysqladmin 。

2. Edit the /etc/munin/plugin-conf.d/cpanel.conf Munin configuration file, and modify the [mysql*] to look like below:编辑的/ etc / munin /插件- conf.d / cpanel.conf munin配置文件，并修改[ MySQL中* ]样子如下：

   
   [mysql*] [ MySQL中* ]
user root 用户根
group wheel 车轮组
env.mysqladmin /usr/bin/mysqladmin env.mysqladmin修改/ usr / bin / mysqladmin
env.mysqlopts –defaults-extra-file=/root/.my.cnf env.mysqlopts -默认-课外文件= /根/ .my.cnf
   

   Ensure the env.mysqladmin value is path returned by step above.确保env.mysqladmin价值的路径是经由上述步骤。 Also ensure that /root/.my.cnf contains correct root password to the MySQL databases.也确保/根/ .my.cnf包含正确的root密码，以MySQL的数据库。

3. Then restart Munin service:然后重新启动munin服务：

   /etc/init.d/munin-node restart / etc / init.d /的munin节点重新启动

4. Wait a while for MySQL statistics to be gathered, and check the graphs again.稍候片刻， MySQL的统计收集，并选中图的一次。

Fix for Host or Server without cPanel Control Panel 修复主机或服务器的cPanel控制面板

Simply add the “env.mysqladmin /usr/bin/mysqladmin” (ensure that the path is correct according to your system) to the /etc/munin/plugin-conf.d/munin-node file will do the trick, according to只需添加“ env.mysqladmin修改/ usr / bin / mysqladmin ” （确保路径是正确的根据您的系统）的/ etc / munin /插件- conf.d / munin节点的文件也将这样做的伎俩，根据 Munin FAQ munin常见问题解答 . 。

IMPORTANT : This is a machine translated page which is provided "as is" without warranty. 重要说明 ：这是一个机器翻译网页是“按原样”提供的担保。 Machine translation may be difficult to understand.机器翻译可能很难理解。 Please refer to请参阅 original English article原来的英语文章 whenever possible.只要有可能。

Share and contribute or get technical support and help at分享和贡献，或取得技术的支持和帮助，在 My Digital Life Forums 我的数字生活论坛 . 。

Related Articles相关文章

• Fix Munin Exim Mail Throughput Graph Not Updating Problem修复munin的exim邮件吞吐量图没有更新的问题
• Seasonality for Mac OS Reviews季节性因素，为Mac OS评语
• Installing Web Server in FreeBSD 6.0 with Apache 2.2, MySQL 5.0 and PHP 5 - Part 3安装Web服务器在FreeBSD的6.0与2.2的Apache ， MySQL 5.0的和PHP 5 -第3部分
• Must Have WordPress Plugins必须有wordpress插件
• Install Web Server in Windows XP with Apache2, PHP5 and MySQL4 - Part 4安装Web服务器在Windows XP的Apache2 ， php5和mysql4 -第4部分
• Reset the Root Password of MySQL Server重置root密码的MySQL服务器
• Change and Reset MySQL root Password改变和重置MySQL的root密码
• 3 Column Relaxation WordPress Theme comments-paged.php for Paged-Comments WordPress Plugin三栏放宽的WordPress主题的评论- paged.php为分页-评论wordpress插件
• Record Skype Call with Call Graph记录Skype呼叫与调用图
• How to Find and Replace Text in MySQL Database using SQL如何查找和替换文本在MySQL数据库中使用SQL

This entry was posted on Saturday, August 25th, 2007 at 2:07 am and is filed under 此项目被张贴在周六， 2007年8月25日在上午02时07分，并提交下 Webmaster Resources 网站管理员资源 . 。 You can follow any responses to this entry through the 您可以按照任何的反应，此项目通过 RSS 2.0 2.0 feed. 喂养。 You can 您可以 leave a response 留下的回应 , or ，或 trackback Trackback跟踪 from your own site. 从你自己的网站。