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 Access denied mysql errors

Discussion in 'cPanel Developers' started by jdstallings, Jun 22, 2006.

  1. jdstallings

    jdstallings Well-Known Member

    Joined:
    Jul 27, 2003
    Messages:
    55
    Likes Received:
    0
    Trophy Points:
    6
    While Munin is a really neat package it seems to stop and start on its own. I will assume that the cpanel updates are part to blame.

    Getting this error now and not getting MYSQL stuff


    2006/06/22-18:30:01 CONNECT TCP Peer: "127.0.0.1:55549" Local: "127.0.0.1:4949"
    mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'root'@'localhost' (using password: NO)'
     
  2. basic612

    basic612 Member

    Joined:
    Jun 22, 2006
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    hi - are you running MySQL 4.0 or 4.1?

    I have a similar problem on my server that I think is related to a password compatibility issue following an upgrade of mysql from 4.0 to 4.1
     
  3. jdstallings

    jdstallings Well-Known Member

    Joined:
    Jul 27, 2003
    Messages:
    55
    Likes Received:
    0
    Trophy Points:
    6
    SQL Version

    We are running 4.1.19-standard

    :confused:
     
  4. benito

    benito Well-Known Member

    Joined:
    Jan 8, 2004
    Messages:
    296
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Mar del Plata - Argentina
    I have the same problem, my mysql graphs are stopped.
     
  5. mbrando

    mbrando Active Member

    Joined:
    Dec 31, 2004
    Messages:
    38
    Likes Received:
    0
    Trophy Points:
    6
    Hi,

    I have the same problem, my mysql graphs are stopped after installing eAccelerator and upgrading PHP to 4.43. I'm running mysql 4.023. I'm think of upgrading to 4.1x to night though.

    Mike
     
  6. panayot

    panayot Well-Known Member

    Joined:
    Nov 18, 2004
    Messages:
    125
    Likes Received:
    0
    Trophy Points:
    16
    try this:

    rm -f /var/log/munin/*
    service munin-node restart
     
  7. mbrando

    mbrando Active Member

    Joined:
    Dec 31, 2004
    Messages:
    38
    Likes Received:
    0
    Trophy Points:
    6
    Hi,

    Thanks. That worked for the Exim graphs. For some reason every sunday the exim graph stops. So I put a crontab that removes all *.state files around 3:00am when the failure occures. To fix the MySQL issue I added this directive:

    [mysql*]
    env.mysqladmin /usr/bin/mysqladmin

    to a new file:

    /etc/munin/plugin-conf.d/munin-node

    That seems to fixed it.

    Mike
     
  8. panayot

    panayot Well-Known Member

    Joined:
    Nov 18, 2004
    Messages:
    125
    Likes Received:
    0
    Trophy Points:
    16
    I actually had to add also the root password for mysql to get it to work:

    env.mysqladmin /usr/bin/mysqladmin -uroot -p****


    Important! If someone does this, then you should make sure the file is owned by root and with permissions 600
     
  9. skyhorse

    skyhorse Active Member

    Joined:
    Aug 18, 2004
    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    1
  10. chris74108

    chris74108 Well-Known Member

    Joined:
    Apr 30, 2004
    Messages:
    86
    Likes Received:
    0
    Trophy Points:
    6
  11. skyhorse

    skyhorse Active Member

    Joined:
    Aug 18, 2004
    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    1
    Chris,

    1) Can you confirm you have the .my.cnf file in your root's home directory?

    2) If you do, as root, "mysqladmin extended-status" for example, does it give you an error or can you see the stats?

    3) If 1 and 2 are affirmative, can you see your mysql password if you do:
    cat ~/.my.cnf | grep pass | sed s/pass// | sed s/=// | sed s/\”//g

    ?

    sky
     
  12. chris74108

    chris74108 Well-Known Member

    Joined:
    Apr 30, 2004
    Messages:
    86
    Likes Received:
    0
    Trophy Points:
    6
    Sky thanks for the reply. The file does exist and the command for extended status does give me the information. The command gives me my password, but I noticed it has the "" so its like "password" . When I was reading examples on mysql's website they did not have "" around password in that file. I wonder if I should.
    I have never changed it so I assume thats what it defaulted to.
     
  13. skyhorse

    skyhorse Active Member

    Joined:
    Aug 18, 2004
    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    1
    oh I see the problem, the last "sed" command in the pipe isnt removing the quotes... when I paste it in this forum it changes the quote to a different character...

    let me try again:

    Code:
    cat ~/.my.cnf | grep pass | sed s/pass// | sed s/=// | sed s/\"//g
    this should give you the proper password without quotes, right? Can you see if the original code you're using you have the proper quote or a different character?

    I think that is the problem, when you copy paste directly to a unix shell it will probably not recognize the html characters... try to paste it to a text editor (notepad for example) and then copy paste again to your unix shell...
     
    #13 skyhorse, Oct 4, 2006
    Last edited: Oct 4, 2006
Loading...

Share This Page