ISPConfig - munin and MySQL

Discussion in 'Installation/Configuration' started by mumbly, Jan 6, 2008.

  1. mumbly

    mumbly Member

    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 ! :D
     
    mumbly, Jan 6, 2008
    #1
  2. mumbly

    mumbly Member

    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
     
    mumbly, Jan 7, 2008
    #2
  3. thibotus01

    thibotus01 Member

    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...
     
    thibotus01, Oct 31, 2009
    #3

Share This Page