Nagios Support Forum

Ppl i just solved the problem, the passive check arriving nagios and are stocked in "non configured objects".
Now i have another problem, i can check time like my example show, and cpu with the cpuload_nrpe_nt.exe addon, but i dont find a lot of addon's for windows, mostly have to be commpiled.
For example i need one who search in a mysql db and find how many records.
Really thx about your patience and help, im new in this fantastic world of nagios where im so rookie.

For the sake of clarity, are you running MySQL on Windows or is that a typo of MS SQL?

Yes, in windows.

If you know the query you want, then it should just be a matter of using the MySQL Query Wizard. Step 2 of the wizard is where you put in the query.

We'd need to know things like table names if we are going to help design the query. If you aren't the MySQL admin, then your MySQL admin should be able to help you with that.

Yes i want to use mysql query and im the admin of the sql, but i need the plugin to load in the nscp in windows for give the passive checks, like the other services i check, like cpuload, logsize, etc.

The plugin is in /usr/local/nagios/libexec/check_mysql_health. You can see if you can get it to run in Windows. It's written in perl. Perl does work on Windows, but not all the modules do. Unfortunately, we aren't set up to test everything on Windows.

There are also a variety of plugins available at https://exchange.nagios.org/directory/P ... ases/MySQL. Unfortunately, not all of the plugin devs say what platforms the plugins support. They may have contact info, and you may be able to contact the plugin writers directly.

Depending on your setup, you might be able to run your MySQL in a Linux VM on the Windows server. We aren't able to help you migrate or anything like that, but it is an option to think about depending on your MySQL skills.

Another option would be custom development, which is a paid service we offer. Please let me know if this is a route your would like to pursue.

dwhitfield wrote:The plugin is in /usr/local/nagios/libexec/check_mysql_health. You can see if you can get it to run in Windows. It's written in perl. Perl does work on Windows, but not all the modules do. Unfortunately, we aren't set up to test everything on Windows.

I just tested and dosen´t work, maybe im doing something wrong or just isn't for windows

dwhitfield wrote:There are also a variety of plugins available at https://exchange.nagios.org/directory/P ... ases/MySQL. Unfortunately, not all of the plugin devs say what platforms the plugins support. They may have contact info, and you may be able to contact the plugin writers directly.

same results

dwhitfield wrote:Depending on your setup, you might be able to run your MySQL in a Linux VM on the Windows server. We aren't able to help you migrate or anything like that, but it is an option to think about depending on your MySQL skills.

i cant do that, because the hardware isn't enough and permissions, etc.

dwhitfield wrote:Another option would be custom development, which is a paid service we offer. Please let me know if this is a route your would like to pursue.

We are testing nagios xi, if the test result are positive, the company will buy the licence and mabye paid the service.

I just tested and dosen´t work, maybe im doing something wrong or just isn't for windows

Could you show us what you attempted?

same results

This as well, sometimes it's something very little for why it does not work properly. It could be a dependency.

i cant do that, because the hardware isn't enough and permissions, etc.

Are you using MySQL or MSSQL? The plugin shouldn't need to run on the direct host, but rather against it. You would just need to create a user, that is allowed to access the specific DB. You're only adding more work load by proxying through the Windows machine to be honest. The only reason I can think of, that would require the needs to run on the Windows machine is if there was a DMZ / routing issue to x machine.

sarpione wrote: I just tested and dosen´t work, maybe im doing something wrong or just isn't for windows

In addition to what @rkennedy said.

Do you have all the needed perl modules installed? The first thing is to get CPAN up and running: http://www.cpan.org/modules/INSTALL.html. My suggestion would be to start with Strawberry Perl, if you don't already have something installed. Although it was the better part of a decade ago, I did not have the greatest experience with ActiveState. Let me know what version of Perl on Windows you are running and then I can help you look for the error log.

cgywin might be another option to try out, but I don't know if you want to go down that rabbit hole.