[Nagiosplug-help] Need help using check_mysql

[Zembower, Kevin]

Tom, thanks so much for writing. I think you're on to something.

I just set up check_mysql for another system, expecting to have the same
problem, and was amazed when it worked right away. The other MySQL is
4.1.20, and doesn't contain any remarks on 'skip networking' in
/etc/my.cnf; in fact, it's surprisingly short. The original system I'm
having trouble with using MySQL 5.0.32 and has these lines in
/etc/mysql/my.cnf:
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address            = 127.0.0.1

Just as soon as I figure out what to change this to (0.0.0.0? 10.
253.192.205? Comment out entirely?), I'll change it and let you all know
if this makes a difference. I expect that it would.

Thanks, again, for your help and suggestion.

-Kevin

-----Original Message-----
From: tom.welsh at bt.com [mailto:tom.welsh at bt.com] 
Sent: Wednesday, September 12, 2007 4:00 PM
To: Zembower, Kevin; nagiosplug-help at lists.sourceforge.net
Subject: RE: [Nagiosplug-help] Need help using check_mysql

Hi Kevin.

This is quite probably a mysql setup problem. Does the mysql database
allow outside connections or just localhost ones?

Check /etc/my.cnf and see if skip networking id uncommented

# Don't listen on a TCP/IP port at all. This can be a security
enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named
pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
#
skip-networking

See my examples which I have just run on my own system

1. With skip-networking enabled

#./check_mysql -H localhost -u nagios -p 6t5Bl0wz
Uptime: 622227  Threads: 1  Questions: 158  Slow queries: 0  Opens: 130
Flush tables: 1  Open tables: 8  Queries per second avg: 0.000

# ./check_mysql -H 132.146.190.32 -u nagios -p 6t5Bl0wz
Can't connect to MySQL server on '132.146.190.32' (111)

2. edit /etc/my.cnf and comment out skip-networking
# vi /etc/my.cnf

3. restart mysql
# /etc/init.d/mysql restart
Shutting down MySQL..
done
Starting MySQL
done

4. test again with IP address
 # ./check_mysql -H 132.146.190.32 -u nagios -p 6t5Bl0wz
Uptime: 4  Threads: 1  Questions: 1  Slow queries: 0  Opens: 12  Flush
tables: 1  Open tables: 6  Queries per second avg: 0.250



-----Original Message-----
From: nagiosplug-help-bounces at lists.sourceforge.net
[mailto:nagiosplug-help-bounces at lists.sourceforge.net] On Behalf Of
Zembower, Kevin
Sent: 12 September 2007 20:27
To: nagiosplug-help at lists.sourceforge.net
Subject: [Nagiosplug-help] Need help using check_mysql

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 

------------------------------------------------------------------------
-
This SF.net email is sponsored by: Microsoft Defy all challenges.
Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Nagiosplug-help mailing list
Nagiosplug-help at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagiosplug-help
::: Please include plugins version (-v) and OS when reporting any issue.

::: Messages without supporting info will risk being sent to /dev/null