Fix for Munin MySQL Monitoring Plugin Graph Not Showing or Blank Določi za spremljanje Munin mysql plugin graf ne prikazuje ali prazno

Munin is a monitoring tool used to survey and monitor the performance of computers, networks, SANs, applications, databases, weather measurements and other parameters. Munin je orodje za spremljanje, ki se uporabljajo za pregled in spremljanje učinkovitosti računalnikov, omrežij, sans-teh, aplikacij, baz podatkov, vremenskih meritvah in druge parametre. Munin remembers and records information it captured and presents them in graphs through a web interface. Munin spomni in evidenc podatkov, ki jih fotografirate in jih predstavlja v grafe prek spletnega vmesnika. 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, z webhost Manager (WHM) je dodal Munin Service Monitor tako preprosto nameščen plugin za spremljanje spletni strežnik in preveri zmogljivost razpoložljivih sredstev.

Easily install, Lahko namestite, 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 različica dela takoj, ko webmaster jo namesti na strežnik preko cPanel / WHM, in začeti preverjanje in zajemanje različnih virov "uporabo obravnave, vključno z MySQL vozlišč, kot so MySQL throughputs, MySQL poizvedbah, MySQL Slow Poizvedbe in MySQL navoje. However, if you restart the server, Munin will fail to monitor MySQL nodes. Vendar, če ste ponovno zaženete strežnik, Munin ne bo spremljala MySQL vozlišč. No information is capture, and the graphs is no longer updated with statistics and appears blank. Št informacije za zajemanje in grafov ni več posodobitev s statistiko in zdi prazno. Sometimes, the MySQL graphs blank symptom may happen even when web server is not rebooted. Včasih, MySQL grafov prazno simptom se lahko zgodi tudi, ko spletni strežnik ni ponovnega zagona.

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. Se napaka zaradi napake v Perl library Munin uporabah, ki jih povzroča $ PATH spremenljivka, ki se izgubila, in nato povzroči plugin ne more najti mysqladmin programa, ki jo potrebuje za nalaganje številke za Naseljavati v grafi. 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. Odstranite in znova Munin Service Monitor lahko gradenj je spet, pa bolj trajna rešitev je hardcode pot do programa, ki bo odpravite težavo. Here the guide on how to specify the path to mysqladmin to Munin. Tukaj je priročnik o tem, kako opredeliti pot do mysqladmin za Munin.

Fix for Munin installed by cPanel/WHM Popravi Munin namesti cPanel / WHM

1. Determine where is mysqladmin program located with the one of the following command: Določiti, kje se nahaja mysqladmin programa z eno izmed naslednji ukaz:

   which mysqladmin ki mysqladmin
   type mysqladmin Vrsta mysqladmin
   locate mysqladmin poiščite mysqladmin

   If should return a path to mysqladmin which looks similar or the same to /usr/bin/mysqladmin. Vrne, če naj pot do mysqladmin ki izgleda podobno ali enako / usr / bin / mysqladmin.

2. Edit the /etc/munin/plugin-conf.d/cpanel.conf Munin configuration file, and modify the [mysql*] to look like below: Uredite / etc / munin / plugin-conf.d / cpanel.conf Munin konfiguracijske datoteke in spremenite [mysql *], da bi izgledal spodaj:

   
[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. Zagotoviti env.mysqladmin vrednost je pot, ki jih vrne korak zgoraj. Also ensure that /root/.my.cnf contains correct root password to the MySQL databases. Prav tako zagotovijo, da se / root / .my.cnf vsebuje pravilne root geslo za MySQL podatkovnih baz.

3. Then restart Munin service: Znova zaženite Munin storitev:

   /etc/init.d/munin-node restart / etc / init.d / munin-vozlišču znova zaženite

4. Wait a while for MySQL statistics to be gathered, and check the graphs again. Počakajte nekaj časa za MySQL statistike, ki jih je treba zbrati, preveriti in grafi znova.

Fix for Host or Server without cPanel Control Panel Določi za gostitelja ali strežnika brez cPanel Nadzorna plošča

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 Preprosto dodajte "env.mysqladmin / usr / bin / mysqladmin" (zagotovi, da je pravilna pot glede na vašem sistemu), da se v / etc / munin / plugin-conf.d / munin-vozlišče datoteka bo naredil trik, v skladu s Munin FAQ Munin Pogosta vprašanja .

IMPORTANT : This is a machine translated page which is provided "as is" without warranty. POMEMBNO: To je stroj prevede stran, ki je ponujena "kot je" brez garancije. Machine translation may be difficult to understand. Strojno prevajanje je lahko težko razumljiva. Please refer to Prosimo, glejte original English article Originalno angleško članek whenever possible. kadar je to mogoče.

Share and contribute or get technical support and help at Deliti in prispevati ali dobiti tehnično podporo in pomoč pri My Digital Life Forums Moje digitalno življenje Forumi .

Related Articles Sorodni članki

• Fix Munin Exim Mail Throughput Graph Not Updating Problem Popravi Munin Exim mail pretočenega bencina Graf ne posodabljanju problem
• Permanently Disable AdSense-Deluxe WordPress Plugin Reward Plugin Author Option Trajno onemogočiti adsense-Deluxe WordPress Plugin nagrajevanja plugin Avtor možnost
• Notepad Showing Current Time and Date Easter Egg (Function) Beležnica prikazuje trenutni čas in datum Pirh (funkcijo)
• Vista Uninstall, Change or Repair Programs and Updates Button Disappear and Not Showing Vista odstraniti, spremeniti ali popravilo programi in posodobitve gumb izgine in ne prikazuje
• Record Skype Call with Call Graph Snemanje Skype klic s klicem Graf
• Blank or Black Screen When Remote Control Vista System with VNC Prazno ali črni zaslon, ko daljinskega upravljalnika Vista sistem z VNC
• Windows Vista DreamScene Not Working with Black or Blank Background Screen Windows Vista DreamScene ne deluje s črnim ali prazno ozadje zaslona
• Force Firefox to Open Search Box Originated Result Page in New Blank Tab Veljavnosti Firefox, da se odpre iskalno polje izvira rezultat prazno stran v novem zavihku
• Oracle Business Activity Monitoring Reviews Oracle poslovne dejavnosti spremljanja pregledov
• Free Monitoring Network Bandwidth with NetWorx Prosti mrežo za spremljanje pasovne širine z NetWorx

This entry was posted on Saturday, August 25th, 2007 at 2:07 am and is filed under Ta vpis je bil objavljen na sobota, 25. avgust 2007 ob 2:07 in je vložen v skladu s Webmaster Resources Webmaster Resources . . You can follow any responses to this entry through the Lahko se drľite vseh odgovorov na ta vpis preko RSS 2.0 RSS 2.0 feed. You can krme. Lahko leave a response pustite odziv , or , Ali trackback trackback from your own site. od vaš lasten položaj.