RE: [Nagios-devel] MSQL Tables and log files mis-match in data types, any ideas
Posted: Thu Mar 28, 2002 12:15 pm
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
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