storing host/service down events in database

[Marc Powell]

> -----Original Message-----
> From: nagios-users-admin at lists.sourceforge.net [mailto:nagios-users-
> admin at lists.sourceforge.net] On Behalf Of Joubin Moshrefzadeh
> Sent: Monday, January 10, 2005 3:52 PM
> To: nagios_list
> Subject: [Nagios-users] storing host/service down events in database
> 
> all this time i've been thinking "database integration of downtime"
means
> nagios keeps records of when devices go down and come up (the
unscheduled
> events!!) in the database rather than in a log file... but much to my
> dismay, i found the downtime tables empty after several weeks of
> testing... and finally I read the docs more carfully and picked up on
the
> "Scheduled host and service downtime" section just before the
"Database
> support" section in the documentation.
> 
> tell me I'm missing something... because I was really hoping the day
to
> day down and up events that nagios detects are what get stored in the
> database. If this feature isn't supported, has anyone out there
written a
> script (perl preferably) that scans the logs and makes the database
> entries??

Only the current values are stored in the database. We use postgres and
used a simple trigger to copy the data on INSERT or UPDATE into another
table for longer-term storage and eventual migration to MSSQL.

--
Marc



-------------------------------------------------------
The SF.Net email is sponsored by: Beat the post-holiday blues
Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt
_______________________________________________
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