In ndo2db.cfg, is the username and password to connect to the db correct?<div><pre style="word-wrap:break-word;white-space:pre-wrap">db_user=nagios db_pass=nagios</pre><pre style="word-wrap:break-word;white-space:pre-wrap"> </pre>I had a similar error, and that was how I fixed it.</div><div> </div><div> <div class="gmail_quote">On Fri, Feb 3, 2012 at 12:37 PM, FTL Nagios <<a href="mailto:ftlnagios@gmail.com">ftlnagios@gmail.com</a>> wrote: <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="EN-GB" link="blue" vlink="purple"><div>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!!!! <div><div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0cm 0cm 0cm"> From: Andrew Thompson <a href="mailto:[mailto:andrew@fulgent.co.uk]" target="_blank">[mailto:andrew@fulgent.co.uk]</a> Sent: 03 February 2012 17:06 To: <a href="mailto:nagios-users@lists.sourceforge.net" target="_blank">nagios-users@lists.sourceforge.net</a> Subject: [Nagios-users] NDOUtils Error writing to data sink! Some output may get lost. xxx queued items to flush </div></div> 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: <a href="http://nagios.sourceforge.net/docs/ndoutils/NDOUtils.pdf" target="_blank">http://nagios.sourceforge.net/docs/ndoutils/NDOUtils.pdf</a> 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-3xChmod 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.cfgChmod 775 /usr/local/nagios/etc/ndomod.cfgChown 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 - <a href="http://dl.dropbox.com/u/895609/ndomod.cfg" target="_blank">http://dl.dropbox.com/u/895609/ndomod.cfg</a>Ndo2db.cfg - <a href="http://dl.dropbox.com/u/895609/ndo2db.cfg" target="_blank">http://dl.dropbox.com/u/895609/ndo2db.cfg</a> Can anybody please help me? This has to be permission related im sure of it but I cannot solve it. Thankyou in advance </div></div> ------------------------------------------------------------------------------ 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! <a href="http://p.sf.net/sfu/learndevnow-dev2" target="_blank">http://p.sf.net/sfu/learndevnow-dev2</a> _______________________________________________ Nagios-users mailing list <a href="mailto:Nagios-users@lists.sourceforge.net">Nagios-users@lists.sourceforge.net</a> <a href="https://lists.sourceforge.net/lists/listinfo/nagios-users" target="_blank">https://lists.sourceforge.net/lists/listinfo/nagios-users</a> ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null </blockquote></div> </div>