If that was the case he would ahve been getting the same error when executing tit via the CLI not just via the nagios .
On Wednesday 21 October 2009 14:41:18 you wrote: > Based on the error message, I would check to make sure that mysql is > even listening on a tcp port(skip networking). > > See this thread for more info: > > http://lists.mysql.com/mysql/196669 > > Lyle Giese > LCR Computer Services, Inc. > > Assaf Flatto wrote: > > >From first glance the parameters you are passing from command line are > > > not the same as you are > > > > passing from the nagios command execution . > > > >> define command{ > >> command_name check_mysql > >> command_line $USER1$/check_mysql -H $HOSTADDRESS$ -p $ARG1$ -c > >> $ARG2$ > >> > >> > >> > >> /usr/lib/nagios/plugins/check_mysql -H localhost -u <username> > >> -p<password> > > > > Here you are giving a user name and password , while on the nagios > > command you specify the password and the critiacl parameters , no > > username > > > > Assaf > > > > On Wednesday 21 October 2009 12:21:53 J. Bakshi wrote: > >> Dear list, > >> > >> My previous nagios (version 2) was running on a clarkconnect server. I > >> have replaced the OS with debian lenny and the nagios shipped with is > >> version3. > >> I have installed here nagios-plugins; nagios-plugins-basic; > >> nagios-nrpe-plugin; nagios3-common; nagios3. The default setup shipped > >> with nagios3 is working fine. > >> fine ........ > >> Now I have imported the old config here and I have done the following > >> setup in nagios.cfg > >> > >> ```````````````````````````````````````` > >> # Commands definitions > >> cfg_file=/etc/nagios3/my_commands.cfg > >> cfg_dir=/etc/nagios3/my_conf.d > >> > >> # I hv ommited this as my command definations are already there at > >> /etc/nagios3/my_commands.cfg ## > >> #cfg_dir=/etc/nagios-plugins/config > >> > >> ``````````````````````````````````` > >> > >> After restarting the nagios; it can successfully monitor the remote > >> servers trough nrpe perfectly :-) > >> > >> But some problems !! > >> > >> check_mysql is not working here properly. > >> > >> the command declination is > >> > >> ````````````````````` > >> define command{ > >> command_name check_mysql > >> command_line $USER1$/check_mysql -H $HOSTADDRESS$ -p $ARG1$ -c > >> $ARG2$ } > >> ````````````````````````````` > >> > >> and the localhost.cfg has > >> > >> ````````````````````````````````` > >> define service{ > >> use local-service ; Name of > >> service template to use > >> host_name Office server > >> service_description MYSQL > >> check_command > >> check_mysql!localhost!root!password123 > >> } > >> `````````````````````````` > >> > >> After restaring the nagipos3 the mysql check reports > >> > >> `````````````````````````` > >> Host '192.168.1.1' is not allowed to connect to this MySQL server > >> ``````````````````````````````` > >> > >> Though the plugin working perfectly > >> > >> /usr/lib/nagios/plugins/check_mysql -H localhost -u <username> > >> -p<password> > >> Uptime: 510145 Threads: 3 Questions: 281108 Slow queries: 0 Opens: > >> 966 Flush tables: 1 Open tables: 952 Queries per second avg: 0.551 > >> > >> > >> what might be the problem then ? > >> kindly enlighten me. > >> > >> ------------------------------------------------------------------------ > >>--- --- Come build with us! The BlackBerry(R) Developer Conference in SF, > >> CA is the only developer event you need to attend this year. Jumpstart > >> your developing skills, take BlackBerry mobile applications to market > >> and stay ahead of the curve. Join us from November 9 - 12, 2009. > >> Register now! http://p.sf.net/sfu/devconference > >> _______________________________________________ > >> Nagios-users mailing list > >> [email protected] > >> https://lists.sourceforge.net/lists/listinfo/nagios-users > >> > >> ::: Please include Nagios version, plugin version (-v) and OS when > >> ::: reporting any issue. Messages without supporting info will risk > >> ::: being sent to /dev/null -- Assaf Flatto SSP Ops Team Linux System Administrator 169 Euston Road, London, NW1 2AE IMPORTANT . this email and the information in it may be confidential, legally privileged and/or protected by law. It is intended solely for the use of the person to whom it is addressed. If you are not the intended recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information in any medium. Please also delete all copies of this email and any attachments from your system. We cannot guarantee the security or confidentiality of email communications. We do not accept any liability for losses or damages that you may suffer as a result of your receipt of this email including but not limited to computer service or system failure, access delays or interruption, data non-delivery or mis-delivery, computer viruses or other harmful components. Copyright in this email and any attachments belong to Select Service Partner UK Limited. Should you communicate with anyone at Select Service Partner UK Limited by email, you consent to us monitoring and reading any such correspondence. Nothing in this email shall be taken or read as suggesting, proposing or relating to any agreement concerted practice or other practice that could infringe UK or EC competition legislation. Select Service Partner UK Limited is a company registered in England and Wales (company number 05687183) whose registered office is at 1 The Heights, Brooklands, Weybridge. Surrey. KT13 0NY ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ Nagios-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
