Configurar MySQL en Munin (Gráfico en blanco)

Fix for Munin installed by cPanel/WHM

  1. Determine where is mysqladmin program located with the one of the following command:which mysqladmin
    type mysqladmin
    locate mysqladminIf should return a path to mysqladmin which looks similar or the same to /usr/bin/mysqladmin.
  2. Edit the /etc/munin/plugin-conf.d/cpanel.conf Munin configuration file, and modify the [mysql*] to look like below:
    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. Also ensure that /root/.my.cnf contains correct root password to the MySQL databases.
  3. Then restart Munin service:/etc/init.d/munin-node restart
  4. Wait a while for MySQL statistics to be gathered, and check the graphs again.

Fix for Host or Server without 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 Munin FAQ.

Léete también  Cómo volcar comandos de Linux a un archivo

AYUDANOS a poder seguir dando respuestas. Te podemos echar una mano y tú también a nosotros, símplemente dale a me gusta.