Historical data

[Marc Powell]

Paul.Fiero at ci.austin.tx.us <mailto:Paul.Fiero at ci.austin.tx.us> wrote:
> I have a question for you guys.  Where is historical data stored on a
> Nagios system with database capabilities turned on?  I see that
> comments, downtime, extinfo, retention, and status data is stored in
> MySQL database I configured it for.  But is there more data?  For
> example is there a running log of events and changes?  I see that
> there is a nagios.log file in the nagios/var directory.  Is that it? 

/usr/local/nagios/var/nagios.log and /usr/local/nagios/var/archives/*
for a standard install.

> 
> Has anyone figured out a way to store that nagios.log file in a MySQL
> database? 

It can be done through a number of different ways (post processing of
the log files, DB triggers, OCSP, etc). You would need to create your
own table schema and CGI's/scripts to insert and utilize that data of
course. It is not supported by the main distribution and the CGI's will
not be able to access or use that data unless they are re-written.
Nagios would also continue to happily write to the existing log files.

--
Marc


-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g. 
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id149&alloc_id66&op=click
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null