Munin Access denied mysql errors

[jdstallings]

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)'

 

[basic612]

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

 

[jdstallings]

SQL Version

We are running 4.1.19-standard

 

[benito]

I have the same problem, my mysql graphs are stopped.

 

[mbrando]

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

 

[panayot]

try this:

rm -f /var/log/munin/*
service munin-node restart

 

[mbrando]

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

 

[panayot]

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

 

[skyhorse]

Alternative solution, and nicer, is to read the password directly from the .my.cnf file.

Full details at: http://www.skyhorse.org/web-server-administration/the-definite-guide-of-obscure-tweaks-to-install-and-maintain-cpanel-whm-version-10/monitoring-your-server/

 

[chris74108]

Alternative solution, and nicer, is to read the password directly from the .my.cnf file.

Full details at: http://www.skyhorse.org/web-server-administration/the-definite-guide-of-obscure-tweaks-to-install-and-maintain-cpanel-whm-version-10/monitoring-your-server/

I tried the suggested and did not have any luck with it

 

[skyhorse]

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

 

[chris74108]

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.

 

[skyhorse]

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:

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...