Page 1 of 1
Windows mysql monitoring plugin
Posted: Mon Oct 06, 2014 1:01 pm
by nagarjuna
Dear Team,
As we have configured following databases and its working fine.
1. Oracle 11.2 G (for windows system)
2. MSSQL (for windows system)
3. MySQL (for Linux system)
but we are not able to monitor MySQL for Windows system. Please let us know the possibilities.
We need to monitor Windows MySQL server please help on it.
Thanks in Advanced
Re: Windows mysql monitoring plugin
Posted: Mon Oct 06, 2014 1:32 pm
by scottwilkerson
This should work fine with the mysql wizard, however you need to make sure your mysql port (3306) is not being blocked by the Windows firewall
Re: Windows mysql monitoring plugin
Posted: Mon Oct 06, 2014 1:33 pm
by abrist
Well, will need more information to help you.
What have you tried?
What were the full commands and arguments?
Did you try a wizard? What errors did you receive or problems did you face?
Re: Windows mysql monitoring plugin
Posted: Tue Oct 07, 2014 6:43 am
by nagarjuna
Hi,
we tried in wizard and we are facing error
CRITICAL - cannot connect to mysql. Access denied for user 'administrator'@'152.XX.XX.X' (using password: YES)
Re: Windows mysql monitoring plugin
Posted: Tue Oct 07, 2014 9:38 am
by tmcdonald
You will need to allow those connections on the MySQL end of things:
http://support.nagios.com/forum/viewtop ... 6&p=108861
Re: Windows mysql monitoring plugin
Posted: Wed Oct 08, 2014 1:04 pm
by nagarjuna
dear team,
i think given link is Linux Mysql monitoring, we need to monitor windows mysql.
Please do the needful.
Re: Windows mysql monitoring plugin
Posted: Wed Oct 08, 2014 2:35 pm
by slansing
You will need to talk to your windows mysql admin on that one, the user in question will need to be given access to the database you are trying to query. The changes that need to be made are similar to those used on the linux mysql build.