Windows mysql monitoring plugin

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
nagarjuna
Posts: 133
Joined: Mon Dec 09, 2013 2:11 am

Windows mysql monitoring plugin

Post 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
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: Windows mysql monitoring plugin

Post 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
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: Windows mysql monitoring plugin

Post 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?
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
nagarjuna
Posts: 133
Joined: Mon Dec 09, 2013 2:11 am

Re: Windows mysql monitoring plugin

Post 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)
tmcdonald
Posts: 9117
Joined: Mon Sep 23, 2013 8:40 am

Re: Windows mysql monitoring plugin

Post by tmcdonald »

You will need to allow those connections on the MySQL end of things:

http://support.nagios.com/forum/viewtop ... 6&p=108861
Former Nagios employee
nagarjuna
Posts: 133
Joined: Mon Dec 09, 2013 2:11 am

Re: Windows mysql monitoring plugin

Post by nagarjuna »

dear team,

i think given link is Linux Mysql monitoring, we need to monitor windows mysql.

Please do the needful.
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: Windows mysql monitoring plugin

Post 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.
Locked