[Nagios-devel] Patch to use a database as the history log

Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
Locked
Guest

[Nagios-devel] Patch to use a database as the history log

Post by Guest »

Has anybody tried this?
I don't know how to start, i.e. how to apply the patch and would be happy if
someone could help. Thanks.

Greetings

Daniel

-----Original Message-----
From: nagios-devel-admin@lists.sourceforge.net
[mailto:nagios-devel-admin@lists.sourceforge.net]On Behalf Of Dougal
Scott
Sent: Thursday, October 24, 2002 9:24 AM
To: nagios-devel@lists.sourceforge.net
Cc: Kamal Amin
Subject: [Nagios-devel] Patch to use a database as the history log



This is a large patch to get nagios to use a mysql database (if someone
wants to volunteer to add postgres support I'm sure it would be
appreciated) for storing and retrieving history information.

This makes it significantly faster for larger sites as instead of
having to do lots of expensive string operations for every line of
every log file, you can just do one SELECT() and pull out exactly what
information is required, so you are not wasting cycles processing
information that you aren't interested in.

I haven't had a chance to test it extensively yet, but a few people
mailed expressing interest in it, so I thought I had better ship it.
Hopefully there aren't too many segfaults left in it :) If you find any
gotchas please mail them to me and I'll fix them up.

There is a simple python script (logconv.py) included in the contrib
directory which will read in your old logs and output the sql commands
necessary to put them into your database.

--
Dougal Scott Connect Internet Solutions
dwagon@connect.com.au 9/114 Albert Rd
Senior Systems Administrator South Melbourne, Australia, 3205







This post was automatically imported from historical nagios-devel mailing list archives
Original poster: agios-devel-admin@lists.sourceforge.ne
Locked