Nagios Support Forum

kyang wrote:Thanks, could you also tell me the time on XI?

Timezone settings.

http://yourXIipAddress/nagiosxi/admin/globalconfig.php

Let's try checking your Core GUI.
http://ipaddress/nagios

Does it also show the wrong date format here on your checks or is it correct? (Screenshots would be nice)

if you force a check it will then go and run it properly and schedule the next one correctly

You mentioned this, and your check_interval is every 3 minutes.
If you wait 3 minutes, does the check actual work or no?

Could you send a screen of this page?

Admin > System Settings --> Defaults tab

Thanks.

kyang wrote:Let's try checking your Core GUI.
http://ipaddress/nagios

Does it also show the wrong date format here on your checks or is it correct? (Screenshots would be nice)

if you force a check it will then go and run it properly and schedule the next one correctly

You mentioned this, and your check_interval is every 3 minutes.
If you wait 3 minutes, does the check actual work or no?

Could you send a screen of this page?

Admin > System Settings --> Defaults tab

Thanks.

core shows the same, these ones are 3 minutes correct, but no, they never recheck, as you can see in the screenshots last check was days ago, and next check isn't going to be for months.

Could you PM or post your status.dat After you retrieve the status.dat file, you can then run the repair_databases script on your db server. Let us know if that fixes the issue or not.

kyang wrote:Could you PM or post your status.dat

Code: Select all

/usr/local/nagios/var/status.dat

After you retrieve the status.dat file, you can then run the repair_databases script on your db server.

Code: Select all

cd /usr/local/nagiosxi/scripts
./repair_databases.sh

Let us know if that fixes the issue or not.

have pm'd the status.dat file, we have it in a ramdisk so path was slightly different

that has fixed those ones....that's odd

Ah ok! Thanks.

So there are no check timing issues anymore?

kyang wrote:Ah ok! Thanks.

So there are no check timing issues anymore?

not currently no.... but from what I can see all the db repair did was restart the engine as none were corrupt... and restarting cant be an acceptable solution as 16 checks hadn't checked in 4 days.... which is what we rely on to know our business is working....

kyang wrote:Ah ok! Thanks.

So there are no check timing issues anymore?

havejust found 3 new services and 1 host doing the same as yesterday

this one hasn't checked in nearly 12 hours and clearly shows in the screenshot that last check and next check are months apart

Let's truncate some tables in your db.

Run these 3 commands. Then re-run the repair_databases.sh script. Let us know how the recheck timing is after that.

kyang wrote:Let's truncate some tables in your db.

Run these 3 commands.

Code: Select all

mysql -u ndoutils -pn@gweb nagiosxi -e 'TRUNCATE TABLE xi_meta'
mysql -u ndoutils -pn@gweb nagiosxi -e 'TRUNCATE TABLE xi_events'
mysql -u ndoutils -pn@gweb nagiosxi -e 'TRUNCATE TABLE xi_eventqueue'

Then re-run the repair_databases.sh script.

Code: Select all

cd /usr/local/nagiosxi/scripts
./repair_databases.sh

Let us know how the recheck timing is after that.

it had fixed all the ones at the time but again the issue has returned this morning