FW: NDOUtils Error writing to data sink! Some output may get lost. xxx queued items to flush

[Jonny Mosco]

In ndo2db.cfg, is the username and password to connect to the db correct?

db_user=nagios	
db_pass=nagios


I had a similar error, and that was how I fixed it.


On Fri, Feb 3, 2012 at 12:37 PM, FTL Nagios <ftlnagios at gmail.com> wrote:

> Ok so for no apparent reason as nothing has changed from me writing the
> original email the log has now logged something new****
>
> ** **
>
> [1328289822] ndomod: Successfully reconnected to data sink! 0 items lost,
> 328 queued items to flush.****
>
> [1328289822] ndomod: Error writing to data sink! Some output may get lost.
> 47 queued items to flush.****
>
> ** **
>
> [1328289838] ndomod: Successfully reconnected to data sink! 0 items lost,
> 189 queued items to flush.****
>
> [1328289838] ndomod: Successfully flushed 189 queued items to data sink.**
> **
>
> [1328289838] ndomod: Error writing to data sink! Some output may get lost…
> ****
>
> [1328289838] ndomod: Please check remote ndo2db log, database connection
> or SSL parameters****
>
> [1328289854] ndomod: Successfully reconnected to data sink! 0 items lost,
> 192 queued items to flush.****
>
> [1328289854] ndomod: Successfully flushed 192 queued items to data sink.**
> **
>
> [1328289854] ndomod: Error writing to data sink! Some output may get lost…
> ****
>
> [1328289854] ndomod: Please check remote ndo2db log, database connection
> or SSL parameters****
>
> ** **
>
> So it started at least flushing stuff if not logging****
>
> ** **
>
> But then a few minutes later back to normal****
>
> ** **
>
> [1328290414] ndomod: Successfully reconnected to data sink! 0 items lost,
> 397 queued items to flush****
>
> [1328290414] ndomod: Error writing to data sink! Some output may get
> lost. 139 queued items to flush****
>
> ** **
>
> ** **
>
> Nothing at all has changed.****
>
> ** **
>
> This will drive me drink, I know it!!!!****
>
> ** **
>
> ** **
>
> *From:* Andrew Thompson [mailto:andrew at fulgent.co.uk]
> *Sent:* 03 February 2012 17:06
> *To:* nagios-users at lists.sourceforge.net
> *Subject:* [Nagios-users] NDOUtils Error writing to data sink! Some
> output may get lost. xxx queued items to flush****
>
> ** **
>
> Hi all,****
>
> ** **
>
> Ubuntu 11.04 32bit Desktop edition****
>
> NDOUtils 1.4b9****
>
> ** **
>
> ** **
>
> ** **
>
> Im trying to install NDOUtils so I can get Nagios writing its log files to
> MYSQL.****
>
> ** **
>
> But im not having much luck.****
>
> ** **
>
> I have followed the install guide to the letter:
> http://nagios.sourceforge.net/docs/ndoutils/NDOUtils.pdf****
>
> ** **
>
> When all said and done that fires out this entry in the nagios.log:****
>
> ** **
>
> [1328283956] ndomod: NDOMOD 1.4b9 (10-27-2009) Copyright © 2009 Nagios
> Core Development Team and Community Contributors****
>
> [1328283956] ndomod: Could not open data sink! I’ll keep trying, but some
> output may get lost…****
>
> [1328283956] Event broker module ‘/usr/local/nagios/bin/ndomod-3x.o’
> initialized successfully.****
>
> [1328283956] Finished daemonizing… (New PID=5771)****
>
> ** **
>
> ** **
>
> ** **
>
> So did a bit of googling and then :-****
>
> ** **
>
> Chmod 755 /usr/local/nagios/bin/ndo2db-3x****
>
> Chmod 755 /usr/local/nagios/bin/ndomod-3x.o****
>
> ** **
>
> ** **
>
> ** **
>
> Restarted the ndomod and nagios services/processes and got somewhere****
>
> ** **
>
> [1328284715] ndomod: NDOMOD 1.4b9 (10-27-2009) Copyright © 2009 Nagios
> Core Development Team and Community Contributors****
>
> [1328284715] ndomod: Successfully connected to data sink. 0 queued items
> to flush.****
>
> [1328284715] Event broker module ‘/usr/local/nagios/bin/ndomod-3x.o’
> initialized successfully.****
>
> [1328284715] ndomod: Error writing to data sink! Some output may get lost…
> ****
>
> [1328284715] Please check remote ndo2db log, database connection or SSL
> Parameters****
>
> [1328284715] Finished daemonizing… (New PID=13760)****
>
> ** **
>
> ** **
>
> ** **
>
> So did a bit more googling and I then:-****
>
> ** **
>
> Chmod 775 /usr/local/nagios/etc/ndo2db.cfg****
>
> Chmod 775 /usr/local/nagios/etc/ndomod.cfg****
>
> Chown nagios:nagios /usr/local/nagios.etc.ndo*****
>
> ** **
>
> ** **
>
> ** **
>
> Restarted the ndomod and nagios services/processes and got a bit further –
> No check log/db/parameters error****
>
> ** **
>
> ** **
>
> [1328285023] ndomod: NDOMOD 1.4b9 (10-27-2009) Copyright © 2009 Nagios
> Core Development Team and Community Contributors****
>
> [1328285023] ndomod: Successfully connected to data sink. 2793 queued
> items to flush.****
>
> [1328285023] ndomod: Error writing to data sink! Some output may get lost.
> 2554 queued items to flush****
>
> [1328285023] Event broker module ‘/usr/local/nagios/bin/ndomod-3x.o’
> initialized successfully.****
>
> [1328285023] Finished daemonizing… (New PID=17107)****
>
> ** **
>
> ** **
>
> ** **
>
> Then read to change the perms on the ndo.sock file, so:****
>
> ** **
>
> Chmod 775 /usr/local/nagios/var/ndo.sock****
>
> ** **
>
> ** **
>
> But still the same output:****
>
> ** **
>
> [1328285748] ndomod: NDOMOD 1.4b9 (10-27-2009) Copyright © 2009 Nagios
> Core Development Team and Community Contributors****
>
> [1328285748] ndomod: Successfully connected to data sink. 957 queued items
> to flush.****
>
> [1328285748] ndomod: Error writing to data sink! Some output may get lost.
> 2374 queued items to flush****
>
> [1328285748] Event broker module ‘/usr/local/nagios/bin/ndomod-3x.o’
> initialized successfully.****
>
> [1328285748] Finished daemonizing… (New PID=19520)****
>
> ** **
>
> My 2 config files can be found here:****
>
> ** **
>
> Ndomod.cfg - http://dl.dropbox.com/u/895609/ndomod.cfg****
>
> Ndo2db.cfg - http://dl.dropbox.com/u/895609/ndo2db.cfg****
>
> ** **
>
> ** **
>
> Can anybody please help me? This has to be permission related im sure of
> it but I cannot solve it.****
>
> ** **
>
> Thankyou in advance****
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
>
> ------------------------------------------------------------------------------
> Try before you buy = See our experts in action!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-dev2
> _______________________________________________
> Nagios-users mailing list
> Nagios-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-users
> ::: Please include Nagios version, plugin version (-v) and OS when
> reporting any issue.
> ::: Messages without supporting info will risk being sent to /dev/null
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20120203/96fed263/attachment.html>
-------------- next part --------------
------------------------------------------------------------------------------
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2
-------------- next part --------------
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null