Reading status into a MySQL database with NDOUtils

In this recipe, we'll learn how to install the NDOUtils extension to Nagios Core, in order to have all of Nagios Core's configuration and data written into a MySQL database. This allows easy development of custom reports and interfaces for Nagios Core data with languages, such as Perl and PHP, and their standard interfaces to the popular MySQL server, rather than needing to interact with Nagios Core's own logs or its data format. Some plugins, such as NagVis, use this format to read information about Nagios Core configuration and objects.

Getting ready

You will need a Nagios Core server version 3.0 or later. NDOUtils will probably still install and work on older versions of Nagios Core, but the installation process is slightly different; see the INSTALL file included in the NDO source for information on this.

Nagios Core uses its event broker functionality to write information to the socket for the MySQL database to pick up. You will need...