Fix for Munin MySQL Monitoring Plugin Graph Not Showing or Blank Noteikt, Munin MySQL Monitoring Plugin Graph nerāda vai Blank

Munin is a monitoring tool used to survey and monitor the performance of computers, networks, SANs, applications, databases, weather measurements and other parameters. Munin ir kontroles līdzeklis, ko izmanto, lai novērotu un uzraudzītu sniegumu no datoriem, tīkliem, sans, lietojumprogrammām, datu bāzēm, laika mērījumi un citi parametri. Munin remembers and records information it captured and presents them in graphs through a web interface. Munin atceras un uzskaites informāciju, kas uztverts un iesniedz tos grafikus caur web interfeisu. 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, izmantojot WebHost vadītājs (WHM) ir pievienojis Munin Service Monitor tik viegli uzstādīt spraudni, lai uzraudzītu Web Host un pārbaudīt jaudu pieejamajiem resursiem.

Easily install, Viegli uzstādīt, 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. Versija 1,24 darbu tiklīdz webmaster instalē to uz serveri, izmantojot cPanel / WHM un sākt pārbaudi un ieguvei un dažādu resursu "izmantošana lasījuma, tostarp MySQL mezglus, piemēram, MySQL throughputs, MySQL queries, MySQL Slow vaicājumi un MySQL pavedieni. However, if you restart the server, Munin will fail to monitor MySQL nodes. Tomēr, ja jūs restart serveri, Munin nespēs kontrolēt MySQL mezgliem. No information is capture, and the graphs is no longer updated with statistics and appears blank. Nav informācijas uztveršanu, un grafikus vairs nav atjaunināts ar statistiku un šķiet tukša. Sometimes, the MySQL graphs blank symptom may happen even when web server is not rebooted. Dažreiz, MySQL grafikus tukšs simptoms var notikt pat tad, ja web serveris nav rebooted.

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. Kļūda ir saistīta ar kļūdu, kas Perl bibliotēka Munin veidiem, kas rada $ PATH mainīgais pazuduši, un tad izraisa spraudnis nevar atrast mysqladmin programmu, kas tai vajadzīga, lai ielādētu numurus aizpildīt ar diagrammas. 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. Atinstalēt un pārinstalēt Munin Service Monitor var darīt tas darbojas atkal, tomēr pastāvīgu risinājumu, lai hardcode ceļu programmu, kas noteiks problēmu. Here the guide on how to specify the path to mysqladmin to Munin. Šeit rokasgrāmata par to, kā norādīt ceļu uz mysqladmin uz Munin.

Fix for Munin installed by cPanel/WHM Noteikt, Munin uzstāda cPanel / WHM

1. Determine where is mysqladmin program located with the one of the following command: Noteikt, kur ir mysqladmin programma atrodas ar vienu šādu komandu:

   which mysqladmin kas mysqladmin
   type mysqladmin tips mysqladmin
   locate mysqladmin atrast mysqladmin

   If should return a path to mysqladmin which looks similar or the same to /usr/bin/mysqladmin. Ja būtu atgriešanās ceļš uz mysqladmin, kas izskatās līdzīgas vai pats uz / usr / bin / mysqladmin.

2. Edit the /etc/munin/plugin-conf.d/cpanel.conf Munin configuration file, and modify the [mysql*] to look like below: Rediģēt / etc / munin / spraudnis-conf.d / cpanel.conf Munin konfigurācijas failu un modificēt [mysql *], kas izskatās šādi:

   
[mysql*]
user root
group wheel
env.mysqladmin /usr/bin/mysqladmin
env.mysqlopts --defaults-extra-file=/root/.my.cnf


   Ensure the env.mysqladmin value is path returned by step above. Nodrošināt env.mysqladmin vērtība ir ceļš atpakaļ pa solim iepriekš. Also ensure that /root/.my.cnf contains correct root password to the MySQL databases. Arī nodrošina, ka / root / .my.cnf satur pareizo root parole MySQL datu bāzēm.

3. Then restart Munin service: Pēc tam restartējiet Munin pakalpojumu:

   /etc/init.d/munin-node restart / etc / init.d / munin-node restart

4. Wait a while for MySQL statistics to be gathered, and check the graphs again. Pagaidiet kamēr MySQL statistiku, kas apkopota, un pārbauda grafiku vēlreiz.

Fix for Host or Server without cPanel Control Panel Noteikt, Host vai serveris bez cPanel Control Panel

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 Vienkārši pievienot "env.mysqladmin / usr / bin / mysqladmin" (nodrošina to, ka ceļš ir pareizs atbilstoši jūsu sistēma) uz / etc / munin / spraudnis-conf.d / munin-node fails darīs triks, saskaņā ar Munin FAQ Munin FAQ . .

IMPORTANT : The page is machine translated and provided "as is" without warranty. SVARĪGI: lapa mašīna iztulkot un pasniegts tàds, "kàds tas ir" bez garantijas. Machine translation may be difficult to understand. Mašīntulkošanas var būt grūti saprast. Please refer to Lūdzu, skatiet original English article oriģināls angļu rakstu whenever possible. kad vien iespējams.

Related Articles Saistītie raksti

• Fix Munin Exim Mail Throughput Graph Not Updating Problem Fix Munin Exim Mail Caurlaide Graph Nav atjaunināšana Problem
• Installing Web Server in FreeBSD 6.0 with Apache 2.2, MySQL 5.0 and PHP 5 – Part 3 Instalēšana Web Server 6.0 FreeBSD ar 2.2 Apache, MySQL 5.0 un PHP 5 - Part 3
• Change and Reset MySQL root Password Pārmaiņas un Reset MySQL root paroli
• Reset the Root Password of MySQL Server Reset root parole MySQL Server
• Apache Status (whm-server-status) in cPanel WebHost Manager Returns Blank Page Apache statuss (WHM-server-status) cPanel WebHost Manager Atgriež tukšu lapu
• Check and Optimize MySQL Database Automatically with Crontab/Cron Pārbaude un pilnveidošana MySQL Database automātiski ar Crontabula / Cron
• Permanently Disable AdSense-Deluxe WordPress Plugin Reward Plugin Author Option Pastāvīgi Atslēgt AdSense-Deluxe WordPress Plugin Reward Plugin Author variants
• Using phpMyAdmin for Effective MySQL Management in Windows XP Izmantojot phpMyAdmin efektīvas MySQL Windows Management XP
• Installing Web Server in FreeBSD 6.0 with Apache 2.2, MySQL 5.0 and PHP 5 – Part 4 Instalēšana Web Server 6.0 FreeBSD ar 2.2 Apache, MySQL 5.0 un PHP 5 - Part 4
• Installing Web Server in FreeBSD 6.0 with Apache 2.2, MySQL 5.0 and PHP 5 – Part 5 Instalēšana Web Server 6.0 FreeBSD ar 2.2 Apache, MySQL 5.0 un PHP 5 - Part 5

This entry was posted on Saturday, August 25th, 2007 at 2:07 am and is filed under Šis ieraksts tika publicēta sestdiena, augusts 25, 2007 at 2:07 un ir iesniegts saskaņā ar Webmaster Resources Webmaster Resources . . You can follow any responses to this entry through the Jūs varat sekot atbildes uz šo ierakstu, izmantojot atbildes RSS 2.0 RSS 2.0 feed. You can barību. Jūs varat leave a response atstāt atbilde , or Vai trackback Trackback from your own site. no jūsu vietā.