RE: [Nagios-devel] MSQL Tables and log files mis-match in data types, any ideas

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

RE: [Nagios-devel] MSQL Tables and log files mis-match in data types, any ideas

Post by Guest »

I've updated the "upcoming" page (http://www.nagios.org/upcoming.php)
to reflect a bit of what I was thinking. Dumping data into a DB
would be handled by an external daemon of some kind.

On 27 Mar 2002 at 20:23, Mark Gillett wrote:

> Thanks for the pointer on the future Ethan, I am not sure how many of the
> Netsaint/Nagios users out here are using the database support, but it seems
> to be a reasonable number. Would you envisage us adding database support as
> a 'patch' or might you consider providing an API against which we could
> implement any other 'storage service' that we might want to play with.
>
> I guess that the alternative might be for someone ;-) to provide a simple
> SQL-->Files bridge (mmmm sounds a bit like mSQL v 0.1) for those who still
> want/need db support.
>
> Personally I am playing with the database as the files get a little clunky
> when writing other analysis code and or interfaces to monitoring/management
> systems other than Nagios :-(. With the db tables some of these operations
> are much faster (to code and to perform), especially when log-file rotation
> (archiving) is enabled.
>
> Where can the community add most value here ?
>
> Mark
>
> -----Original Message-----
> From: nagios-devel-admin@lists.sourceforge.net
> [mailto:nagios-devel-admin@lists.sourceforge.net]On Behalf Of Ethan
> Galstad
> Sent: Wednesday, March 27, 2002 7:27 PM
> To: nagios-devel@lists.sourceforge.net;
> nagios-users@lists.sourceforge.net
> Subject: Re: [Nagios-devel] MSQL Tables and log files mis-match in data
> types, any ideas
>
>
> Thanks for pointing this out. The inconsistencies should be fixed,
> although its not a huge deal. Changing the DB tables at this point
> might be a waste of time, as I plan on dropping native DB support in
> version 2.0.
>
>
> On 27 Mar 2002 at 18:32, Mark Gillett wrote:
>
> > Hi All,
> >
> > I have been investigating linking some of our in-house tools to Nagios and
> > have been working on reading from either the log files or a MySql database
> > for retention and status information.
> >
> > In these explorations I have discovered some 'maybe' inconsistencies in
> the
> > data types used and descriptions of these as below:
> >
> > I may be missing something or might be just straight dumb on this - has
> > anyone else got any ideas ?
> >
> > in
> >
> > TABLE hostretention --->
> >
> >
> > last_check int(11)
> >
> > appears to be a short integer and is described as a time_t since the unix
> > epoch in the log-file documentation,
> >
> > but in
> >
> > TABLE hoststatus --->
> >
> > last_check datetime
> >
> > appears to be a datetime but is still described as a time_t since the
> unix
> > epoch in the log-file documentation
> >
> > also confusing is that in
> >
> > TABLE hoststatus --->
> >
> > time_up bigint(20)
> > time_down bigint(20)
> > time_unreachable bigint(20)
> >
> > and are described as no. of seconds elapsed in that state, or since the
> last
> > start of the server, but in
> >
> > TABLE hostretention --->
> >
> > time_up int(11)
> > time_down int(11)
> > time_undreachable int(11)
> >
> > which is described as no. of seconds elapsed as well.
> >
> > Am I missing something - does anyone know if there is a reason for this,
> if
> > not should I look at harmonising the database descriptions. Also should
> we
> > think about updating the xdata code to unift the storage between the files
> > and the database in terms of data-types.
> >
> > Also - has anyone written a file to database or database to file
> conversion
> > tool ?
> >
> > Thanks,
> >
> >
> > Mark Gillett
> > IXIF Ltd
> > UK NMS Support
> >
> >
> >
> > _______________________________________________
> > Nagios-devel mailing list
> > Nagios-devel@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/lis ... gios-devel
> >
>
>
>
> Ethan Galstad,
> Nagios Developer
> ---
> Email: nagios@nagios.org
> Website: http://www.nagios.org
>
>
> _______________________________________________
> Nagios-devel mailing list
> Nagios-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinf

...[email truncated]...


This post was automatically imported from historical nagios-devel mailing list archives
Original poster: nagios@nagios.org
Locked