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部分
• Change and Reset MySQL root Password改變和重置MySQL的root密碼
• Reset the Root Password of MySQL Server重置root密碼的MySQL服務器
• 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. 從你自己的網站。