I have Nagios 3.x running perfactly, I want to load all alerts data to Mysql for future reference so we can create reports accordingly.
I have installed NDOUtils but after instalation I am getting the following error in the /var/log/messages
nagios: ndomod: Still unable to connect to data sink. 14613 items lost, 5000 queued items to flush.
I have fixed the issue by changing socket_type=tcp to socket_type=unix in /usr/local/nagios/etc/ndo2db.cfg
And restart Nagios service and start ndo2db by using the following command /usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
After doing above change, now if you get following logs in /var/log/medssages which means everything alright
Mar 4 04:45:44 server1 nagios: ndomod: Successfully connected to data sink. 18134 items lost, 5000 queued items to flush.
Mar 4 04:45:47 server1 nagios: ndomod: Successfully flushed 5000 queued items to data sink.