<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
mso-fareast-language:EN-US;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";
mso-fareast-language:EN-US;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-GB link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='color:#1F497D'>Ok so for no apparent reason as nothing has changed from me writing the original email the log has now logged something new<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>[1328289822] ndomod: Successfully reconnected to data sink! 0 items lost, 328 queued items to flush.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>[1328289822] ndomod: Error writing to data sink! Some output may get lost. 47 queued items to flush.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>[13282898</span><span style='color:#1F497D'>38</span><span style='color:#1F497D'>]</span><span style='color:#1F497D'> ndomod: Successfully reconnected to data sink! 0 items lost, 189 queued items to flush.</span><span style='color:#1F497D'><o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>[13282898</span><span style='color:#1F497D'>38</span><span style='color:#1F497D'>]</span><span style='color:#1F497D'> ndomod: Successfully flushed 189 queued items to data sink.</span><span style='color:#1F497D'><o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>[13282898</span><span style='color:#1F497D'>38</span><span style='color:#1F497D'>]</span><span style='color:#1F497D'> ndomod: Error writing to data sink! Some output may get lost…</span><span style='color:#1F497D'><o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>[13282898</span><span style='color:#1F497D'>38</span><span style='color:#1F497D'>]</span><span style='color:#1F497D'> ndomod: Please check remote ndo2db log, database connection or SSL parameters</span><span style='color:#1F497D'><o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>[13282898</span><span style='color:#1F497D'>54</span><span style='color:#1F497D'>]</span><span style='color:#1F497D'> ndomod: Successfully reconnected to data sink! 0 items lost, 192 queued items to flush.</span><span style='color:#1F497D'><o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>[13282898</span><span style='color:#1F497D'>54</span><span style='color:#1F497D'>]</span><span style='color:#1F497D'> ndomod: Successfully flushed 192 queued items to data sink.</span><span style='color:#1F497D'><o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>[13282898</span><span style='color:#1F497D'>54</span><span style='color:#1F497D'>]</span><span style='color:#1F497D'> ndomod: Error writing to data sink! Some output may get lost…</span><span style='color:#1F497D'><o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>[13282898</span><span style='color:#1F497D'>54</span><span style='color:#1F497D'>]</span><span style='color:#1F497D'> ndomod: Please check remote ndo2db log, database connection or SSL parameters<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>So it started at least flushing stuff if not logging<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>But then a few minutes later back to normal<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>[132829041</span><span style='color:#1F497D'>4</span><span style='color:#1F497D'>]</span><span style='color:#1F497D'> ndomod: Successfully reconnected to data sink! 0 items lost, 397 queued items to flush</span><span style='color:#1F497D'><o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>[132829041</span><span style='color:#1F497D'>4</span><span style='color:#1F497D'>]</span><span style='color:#1F497D'> ndomod: Error writing to data sink! Some output may get lost. 139 queued items to flush<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Nothing at all has changed.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>This will drive me drink, I know it!!!!</span><span style='color:#1F497D'><o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-GB'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-GB'> Andrew Thompson <a href="mailto:[mailto:andrew@fulgent.co.uk]">[mailto:andrew@fulgent.co.uk]</a> <br><b>Sent:</b> 03 February 2012 17:06<br><b>To:</b> <a href="mailto:nagios-users@lists.sourceforge.net">nagios-users@lists.sourceforge.net</a><br><b>Subject:</b> [Nagios-users] NDOUtils Error writing to data sink! Some output may get lost. xxx queued items to flush<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Hi all,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Ubuntu 11.04 32bit Desktop edition<o:p></o:p></p><p class=MsoNormal>NDOUtils 1.4b9<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Im trying to install NDOUtils so I can get Nagios writing its log files to MYSQL.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>But im not having much luck.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I have followed the install guide to the letter: <a href="http://nagios.sourceforge.net/docs/ndoutils/NDOUtils.pdf">http://nagios.sourceforge.net/docs/ndoutils/NDOUtils.pdf</a><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>When all said and done that fires out this entry in the nagios.log:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>[1328283956] ndomod: NDOMOD 1.4b9 (10-27-2009) Copyright © 2009 Nagios Core Development Team and Community Contributors<o:p></o:p></p><p class=MsoNormal>[1328283956] ndomod: Could not open data sink! I’ll keep trying, but some output may get lost…<o:p></o:p></p><p class=MsoNormal>[1328283956] Event broker module ‘/usr/local/nagios/bin/ndomod-3x.o’ initialized successfully.<o:p></o:p></p><p class=MsoNormal>[1328283956] Finished daemonizing… (New PID=5771)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>So did a bit of googling and then :-<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Chmod 755 /usr/local/nagios/bin/ndo2db-3x<o:p></o:p></p><p class=MsoNormal>Chmod 755 /usr/local/nagios/bin/ndomod-3x.o<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Restarted the ndomod and nagios services/processes and got somewhere<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>[1328284715] ndomod: NDOMOD 1.4b9 (10-27-2009) Copyright © 2009 Nagios Core Development Team and Community Contributors<o:p></o:p></p><p class=MsoNormal>[1328284715] ndomod: Successfully connected to data sink. 0 queued items to flush.<o:p></o:p></p><p class=MsoNormal>[1328284715] Event broker module ‘/usr/local/nagios/bin/ndomod-3x.o’ initialized successfully.<o:p></o:p></p><p class=MsoNormal>[1328284715] ndomod: Error writing to data sink! Some output may get lost…<o:p></o:p></p><p class=MsoNormal>[1328284715] Please check remote ndo2db log, database connection or SSL Parameters<o:p></o:p></p><p class=MsoNormal>[1328284715] Finished daemonizing… (New PID=13760)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>So did a bit more googling and I then:-<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Chmod 775 /usr/local/nagios/etc/ndo2db.cfg<o:p></o:p></p><p class=MsoNormal>Chmod 775 /usr/local/nagios/etc/ndomod.cfg<o:p></o:p></p><p class=MsoNormal>Chown nagios:nagios /usr/local/nagios.etc.ndo*<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Restarted the ndomod and nagios services/processes and got a bit further – No check log/db/parameters error<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>[1328285023] ndomod: NDOMOD 1.4b9 (10-27-2009) Copyright © 2009 Nagios Core Development Team and Community Contributors<o:p></o:p></p><p class=MsoNormal>[1328285023] ndomod: Successfully connected to data sink. 2793 queued items to flush.<o:p></o:p></p><p class=MsoNormal>[1328285023] ndomod: Error writing to data sink! Some output may get lost. 2554 queued items to flush<o:p></o:p></p><p class=MsoNormal>[1328285023] Event broker module ‘/usr/local/nagios/bin/ndomod-3x.o’ initialized successfully.<o:p></o:p></p><p class=MsoNormal>[1328285023] Finished daemonizing… (New PID=17107)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Then read to change the perms on the ndo.sock file, so:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Chmod 775 /usr/local/nagios/var/ndo.sock<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>But still the same output:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>[1328285748] ndomod: NDOMOD 1.4b9 (10-27-2009) Copyright © 2009 Nagios Core Development Team and Community Contributors<o:p></o:p></p><p class=MsoNormal>[1328285748] ndomod: Successfully connected to data sink. 957 queued items to flush.<o:p></o:p></p><p class=MsoNormal>[1328285748] ndomod: Error writing to data sink! Some output may get lost. 2374 queued items to flush<o:p></o:p></p><p class=MsoNormal>[1328285748] Event broker module ‘/usr/local/nagios/bin/ndomod-3x.o’ initialized successfully.<o:p></o:p></p><p class=MsoNormal>[1328285748] Finished daemonizing… (New PID=19520)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>My 2 config files can be found here:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Ndomod.cfg - <a href="http://dl.dropbox.com/u/895609/ndomod.cfg">http://dl.dropbox.com/u/895609/ndomod.cfg</a><o:p></o:p></p><p class=MsoNormal>Ndo2db.cfg - <a href="http://dl.dropbox.com/u/895609/ndo2db.cfg">http://dl.dropbox.com/u/895609/ndo2db.cfg</a><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Can anybody please help me? This has to be permission related im sure of it but I cannot solve it.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thankyou in advance<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>