#1  
Old 6th January 2008, 21:33
mumbly mumbly is offline
Member
 
Join Date: Jun 2007
Posts: 69
Thanks: 4
Thanked 1 Time in 1 Post
Default ISPConfig - munin and MySQL

I get this error with munin + ISPConfig for the Mysql graphs :

mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'

Any idea ?
Thanx in advance !
Reply With Quote
Sponsored Links
  #2  
Old 7th January 2008, 08:54
mumbly mumbly is offline
Member
 
Join Date: Jun 2007
Posts: 69
Thanks: 4
Thanked 1 Time in 1 Post
Default

SOLVED !
On an Ubuntu 7.10 system :

In /etc/munin/plugin-conf.d/munin-node replace :
[mysql*]
user root
env.mysqladmin /usr/bin/mysqladmin
env.mysqlopts --defaults-extra-file=/etc/mysql/debian.cnf

BY

[mysql*]
user root
env.mysqladmin /usr/bin/mysqladmin
env.mysqlopts -u debian-sys-maint -p1234567890

1234567890 is the password you'll find in /etc/mysql/debian.cnf for the user debian-sys-maint
Reply With Quote
The Following User Says Thank You to mumbly For This Useful Post:
falko (7th January 2008)
  #3  
Old 31st October 2009, 16:51
thibotus01 thibotus01 is offline
Member
 
Join Date: Oct 2009
Posts: 89
Thanks: 2
Thanked 2 Times in 2 Posts
 
Default

Hi,

I had the same problem, and thanks for this help it works now!

But that's weird because --defaults-extra-file=/etc/mysql/debian.cnf should works... It's the same thing !

I've noticed munin worked well with the --defaults-extra-file... until I did an aptitude update on debian I think... And Mysql updated or something else...
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Statistics not compiling. thevinster Installation/Configuration 137 11th November 2010 10:54


All times are GMT +2. The time now is 08:35.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.