[Nagiosplug-help] Need help using check_mysql
    Zembower, Kevin 
    kzembowe at jhuccp.org
       
    Wed Sep 12 21:27:26 CEST 2007
    
    
  
I'm trying to configure check_mysql on my Debian etch system:
cn2:/etc/nagios2/conf.d# /usr/lib/nagios/plugins/check_mysql -V
check_mysql (nagios-plugins 1.4.5) 1.33
I can't get the check to work unless I use the defaults:
cn2:/etc/nagios2/conf.d# /usr/lib/nagios/plugins/check_mysql -H
10.253.192.205 -u nagios -p secret
Can't connect to MySQL server on '10.253.192.205' (111)
cn2:/etc/nagios2/conf.d# /usr/lib/nagios/plugins/check_mysql -H
localhost -u nagios -p secret
Uptime: 2000705  Threads: 1  Questions: 3546235  Slow queries: 0  Opens:
18915  Flush tables: 1  Open tables: 64  Queries per second avg: 1.772
cn2:/etc/nagios2/conf.d# /usr/lib/nagios/plugins/check_mysql -u nagios
-p secret
Uptime: 2000710  Threads: 1  Questions: 3546236  Slow queries: 0  Opens:
18915  Flush tables: 1  Open tables: 64  Queries per second avg: 1.772
cn2:/etc/nagios2/conf.d#
I think I've got the IP address right:
cn2:/etc/nagios2/conf.d# ifconfig eth0
eth0      Link encap:Ethernet  HWaddr 00:B0:D0:49:55:20  
          inet addr:10.253.192.205  Bcast:10.253.192.255
Mask:255.255.255.192
<snip>
I first thought that this could be caused by the 'nagios' MySQL user,
but I have this user defined for all hosts:
kevinz at cn2:~$ mysql -A mysql
Server version: 5.0.32-Debian_7etch1-log Debian etch distribution
mysql> select * from user where User like 'nagios%'\G
*************************** 1. row ***************************
                 Host: %
                 User: nagios
             Password: <snip>
          Select_priv: N
          Insert_priv: N
          Update_priv: N
          Delete_priv: N
          Create_priv: N
            Drop_priv: N
          Reload_priv: N
        Shutdown_priv: N
         Process_priv: N
            File_priv: N
           <snip>
1 row in set (0.00 sec)
mysql>
Can anyone help me get check_mysql working from the command line?
Thanks for all your help and suggestions.
-Kevin
Kevin Zembower
Internet Services Group manager
Center for Communication Programs
Bloomberg School of Public Health
Johns Hopkins University
111 Market Place, Suite 310
Baltimore, Maryland  21202
410-659-6139 
    
    
More information about the Help
mailing list