Home Directory Addons Database Backends mysql database loader

Search Exchange

Search All Sites

Nagios Live Webinars

Let our experts show you how Nagios can help your organization.

Contact Us

Phone: 1-888-NAGIOS-1
Email: sales@nagios.com

Login

Remember Me

Directory Tree

mysql database loader

Rating
0 votes
Favoured:
0
Hits
105726
Files:
FileDescription
loadlogs.plLoad nagios log files v2.1
loadconfig.plLoad nagios configuration
Network Monitoring Software - Download Nagios XI
Log Management Software - Nagios Log Server - Download
Netflow Analysis Software - Nagios Network Analyzer - Download
Load the Nagios logs and configuration into tables in a mysql database.
This consists of two perl scripts, which use the DBI and DBD::mysql perl modules, plus the Nagios::Config module (for the config loader).
The loadlogs.pl script load logfiles from the archive directory into a logs table in the database, after filtering them according to your preferences.
The loadconfig.pl script loads the nagios configuration files (including hostextinfo.cfg) via the Nagios::Config perl module into multiple tables in the mysql database.
You can then use the mysql ODBC drivers for windows to report on these tables using Access or Excel.
This is a first version, so no instructions other than the built-in help text. Set up a mysql database and user, configure the scripts, and it should be clear.