ndomod: Still unable to connect to data sink.

[bsanjay]

Hello Team,
We are seeing this error in nagios log and DB is not in sync with current status of host/service and we need to restart ndo2db service to sync this DB with host/service current state. What is causing this issue and what steps can be taken to resolve this issue ?

[1563873602] ndomod: Still unable to connect to data sink. 16920006 items lost, 5000 queued items to flush.

I have attached config files for your refenrence.

Best Regards,
BSanjay

[tgriep]

The nagios.cfg file is from a Nagios Core system and not an XI server so I want to verify is the server running Core or XI?

What OS and release is it running?
How many Host and Services are setup on the server?
What version of NDOUTILS did you install on the server?


Typically, when you see that message, the ndo2db daemon cannot connect to the MYSQL database so can you run the following commands as root and post the outout?

Code: Select all

echo 'show tables;' |mysql -t -u ndoutils -pcadence nagios
ps -ef |grep mysql

Thanks.

[bsanjay]

Hello tgriep,
Yes, this is nagios core system.

OS-Release
NAME="CentOS Linux"
VERSION="7 (Core)"
ID="centos"
ID_LIKE="rhel fedora"
VERSION_ID="7"
PRETTY_NAME="CentOS Linux 7 (Core)"

How many hosts & services ?
Hosts - 1468
Services - 9962

NDOUtils Version
NDO2DB 2.1.3
Copyright (c) 2009 Nagios Core Development Team and Community Contributors
Copyright (c) 2005-2008 Ethan Galstad
Last Modified: 2017-04-13
License: GPL v2


At present that error is not there so this command output is listing tables in nagios DB (Attached)

Also, I can see that nagios DB size is 8.7 GB and i am thinking to truncate some tables that are big in size. Please suggest,
1-> can i truncate below listed tables ?
2-> what is the impact of truncating this tables ?
3-> what is the purpose of this tables in nagios DB ?

Table Name Size
nagios_statehistory 1.5 G
nagios_servicechecks 2.3 G
nagios_logentries 2.3 G
nagios_hostchecks 538 M


Best Regards,
BSanjay

[tgriep]

The following document describes the various tables in the Nagios database and their function.
https://assets.nagios.com/downloads/nag ... _Model.pdf

About whether you can truncate the tables, it all depends on what tool you are using to access the data in the MYSQL database and what you are using it for.

FYI, nagios core does not use the data in the MYSQL database to function, all it is used for is to store data for use in other tools.