WMI and JMX with Icinga

Over the past week I have been flexing my monitoring skills again. Of course the landscape has changed since I worked on this a few years ago. Today, I am struggling with a commercial product, unnamed. Bloated, expensive, horrible GUI, and time consuming. I am sure it is a good product given that you have an entire staff dedicated to managing it.

So, I went back to my roots and set up an Icinga instance. I have it fully working on a Linux box monitoring Windows hosts. Agentless. No more nsclient installs. I am using check_wmi_plus plugin for everything Windows. You can supply a wmi query string to the plugin for anything WMI. Here are some URLs:


some service definitions:


I am also monitoring out Java infrastructure. You need to make sure the java app is set up for remote jmx monitoring before this will work.


and some nice service defs and commands:


Maybe I will get some time to write up a comprehensive faq.

Java on Ubuntu 13.04 (Raring Ringtail)

Installing Oracle Java on Ubuntu can be a pretty daunting task. After reading the Ubuntu documentation here:


I came across this nice github project:


Simply run

git clone https://github.com/flexiondotorg/oab-java6.git

Then cd into oab-java6 and run

sudo ./oab-java.sh

This will set up a local apt repository for Sun Java 6 and Oracle Java 7. Now run

sudo apt-get update

to add the packages from the repository. As the documentation states, you can now run

sudo apt-get install sun-java6-jre

To install Java 6 runtime environment.

One small thing to note:

I had to run

sudo update-alternatives --config java

and select the Sun JRE since the system defaulted to IcedTea.

Now do

java -version

to see what you have!

MySQL Connectivity Issues with Spoon 4.4.1

I recently installed Pentaho DI 4.4.1. I was previously using PDI 3.2. Transferring my ETL’s to the new PDI installation resulted in this error message (truncated).

Error connecting to database [mysql] : org.pentaho.di.core.exception.KettleDatabaseException: 
Error occured while trying to connect to the database 

Exception while loading class 

Digging around, the full error can be found here:

Exception while loading class mysql.Driver

The answer is provided in the Jira ticket. You need to download and install the MySQL JDBC connector which can be found here:

Download Connector/J

I am using the Windows x64 version so I had to place the jar file here: C:\Program Files\pentaho\design-tools\data-integration\libext

Now I am able to connect to MySQL.

According to Pentaho, they can no longer include the MySQL JDBC connector as it is not compatible with the Apache 4.3 license.