Page 1 of 1

nagios_hostchecks and nagios_servicechecks are always empty

Posted: Wed Oct 22, 2014 4:52 am
by Ryan Qiu
Hi,

We met a problem that nagios_hostchecks and nagios_servicechecks are always empty in nagios database. Recently we would get historical performance data to display and to generate charts accordingly on our mvc page.

1. Does anyone know that why nagios_hostchecks and nagios_servicechecks are always empty? (We have tried it for many times but they are always empty.)
2. Is there any way to let the data to be inserted to nagios_hostchecks and nagios_servicechecks?

We currently use Nagios XI and its version is ' Nagios XI 2014R1.2 - Check for Updates - Copyright © 2008-2014 Nagios Enterprises, LLC '. And Nagios XI is installed on CentOS server.

Thanks in advance. Any suggestions are appreciated.

Re: nagios_hostchecks and nagios_servicechecks are always em

Posted: Thu Oct 23, 2014 10:38 am
by abrist
Ryan Qiu wrote:1. Does anyone know that why nagios_hostchecks and nagios_servicechecks are always empty? (We have tried it for many times but they are always empty.)
I do not believe that ndo in XI writes to those tables. Instead of logging all checks to the db, XI logs the current status to the nagios_*status tables and state change history to the nagios_statehistory table. If I recoall correctly we disabled writing to those tables a while back due to how fast those tables grow and how little they were used in XI.
Ryan Qiu wrote:2. Is there any way to let the data to be inserted to nagios_hostchecks and nagios_servicechecks?
Not sure. What is the use case?