[Nagiosplug-help] Need help using check_mysql

[James Miller]

> -----Original Message-----
> From: nagiosplug-help-bounces at lists.sourceforge.net 
> [mailto:nagiosplug-help-bounces at lists.sourceforge.net] On 
> Behalf Of Zembower, Kevin
> Sent: Wednesday, September 12, 2007 3:16 PM
> To: nagiosplug-help at lists.sourceforge.net
> Subject: Re: [Nagiosplug-help] Need help using check_mysql
> 
> 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.
> 


I realize this is off-topic; but, what are the minimum mysql privilages
needed to use check_mysql?


--Jim