Munin does not show mysql-data

Discussion in 'Plugins/Modules/Addons' started by janvl, May 7, 2019.

  1. janvl

    janvl Member

    Hi,
    I have installed munin and monet, both are working fine just that do not seem to be able to solve my problem that munin does not show mysql-data.

    I went through the internet and found some solutions of which I found the one to make a specific munin mysql-user attractive.

    Now I have in
    configuration-file:
    /etc/munin/plugin-conf.d/munin
    ------------------------------------------
    [mysql*]
    user munin
    env.mysqlopts --defaults-file=/etc/mysql/debian.cnf
    env.mysqluser munin
    env.mysqlpassword **mypassword**
    env.mysqlconnection DBI:mysql:mysql;mysql_read_default_file=/etc/mysql/debian.cnf
    env.mysqladmin /usr/bin/mysqladmin

    [mysql_innodb]
    env.warning 0
    env.critical 0
    -----------------------------------

    It seems that some entries are double.

    So my question, what is the minimum to make it work?

    Regards,
    Jan
     
  2. nickdawhick

    nickdawhick New Member

    What were the previous solutions you tried already?
     
  3. janvl

    janvl Member

    Hi nickdawhick
    Thanks for the reply.
    I have tried the root user (mariadb)
    Then I read a thread with a seperate user specifically for munin with the appropiate rights, so now the user is "munin".
    The host is "localhost".

    I guess I do something wrong in the configurationfile,

    Is there an example of a functioning configurationfile?

    The more I use ISPConfig the more enthusiastic I get, one just has to learn how to handle it all.

    Regards,
    Jan
     
  4. Taleman

    Taleman Well-Known Member HowtoForge Supporter

  5. janvl

    janvl Member

    Hi Taleman,
    absolutely right, monit with i. Althouh I like Monet very much too :D
    Thanks for the link I will go through that.

    I had to deal with DKIM/ DMARC / SPF first which is perfectly integrated in ISPConfig.
    To night I will try to make munin work with mysql.

    Regards,
    Jan
     

Share This Page