The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Munin stopped logging MySQL data

Discussion in 'General Discussion' started by rnawky, Mar 22, 2010.

  1. rnawky

    rnawky Member

    Joined:
    Jan 13, 2010
    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    1
    Ever since the server was restarted, the Munin plugin for WHM has stopped logging MySQL data all together. Any way to figure out what went wrong and how to fix it?
     
  2. chrishorgan

    chrishorgan Registered

    Joined:
    Mar 31, 2008
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    WA
    In Shell Try...

    service munin-node restart

    or...

    /etc/init.d/munin-node restart

    Cheers
     
    #2 chrishorgan, Mar 23, 2010
    Last edited: Mar 23, 2010
  3. chrishorgan

    chrishorgan Registered

    Joined:
    Mar 31, 2008
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    WA
    And if that doesn't work,

    Find the munin-node process...
    pgrep -u root -l

    Then Kill it.

    Then restart the process again with
    /etc/init.d/munin-node restart

    (It just happened to me!)
     
  4. Dante78

    Dante78 Well-Known Member

    Joined:
    May 1, 2010
    Messages:
    53
    Likes Received:
    0
    Trophy Points:
    6
    mine, is not loggining any data. all graphs are blank

    Cheers
     
  5. anton_latvia

    anton_latvia Well-Known Member
    PartnerNOC

    Joined:
    May 11, 2004
    Messages:
    348
    Likes Received:
    3
    Trophy Points:
    18
    Location:
    Latvia
    cPanel Access Level:
    Root Administrator
    Usually this happens when munin plugin is not able to connect to mysql and grab statistica data. Here is what I do to fix this problem:

    Code:
    cp /root/.my.cnf /home/munin/.my.cnf
    chown munin.munin /home/munin/.my.cnf
    then in the file /home/munin/.my.cnf I change the word [client] to [mysqladmin] and restart munin:

    Code:
    /etc/init.d/munin restart
    Yes, I know, that giving munin root privileges is a bad idea. On the other hand noone will login with that user, but if you are concerned - you could add special user to mysql with permission to run the following command:

    Code:
    mysqladmin variables
    and of course put that login/pass to /home/munin/.my.cnf.

    I hope that helps! ;)
     
Loading...

Share This Page