I'm testing OpenNMS in a virtual machine, and I want to monitor MySQL server in another VM. I'm going to install OpenNMS at my work, and I already tested several options to monitor MySQL: a third party plugin (mysql-snmp), the HTTP collector and the JDBC collector, but the first one and the last one needs I open the port 3306 to my OpenNMS IP, and I'm not allowed to do this at my work, and my boss told me that I can't install apache in the MySQL Server VM, so I can't monitor it with HTTP.
So... is there a way to monitor JUST the availability of the MySQL service? I don't want DB stats or graphs, I need just the availability of the service.
Thanks in advance.