[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

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

Post by Guest »

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







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