Page 1 of 1

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

Posted: Wed Mar 27, 2002 11:24 am
by Guest
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






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