<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=utf-8"> <meta name=Generator content="Microsoft Word 12 (filtered medium)"> <style>  </style>  </head> <body lang=EN-GB link=blue vlink=purple> <div class=Section1> This is all starting to get a bit too complex for me! Anyway, I’ve managed to narrow down the problem a bit.<o:p></o:p> <o:p> </o:p> I did a fresh install of Ubuntu 7.10 Server with Nagios and NDOUtils (latest versions) and get the same problem exactly.<o:p></o:p> <o:p> </o:p> I then did a fresh install of Ubuntu 6.06 Server with Nagios and NDOUtils and it works perfectly. So there’s obviously something in Ubuntu 7.10 causing the problem. I guess the next step would be to go through all the components and check for version differences, but I’m not really sure I can be bothered - I think I’ll just stick with Ubuntu 6.06 for now.<o:p></o:p> <o:p> </o:p> Thanks for all the help anyway!<o:p></o:p> <o:p> </o:p> Joe<o:p></o:p> <o:p> </o:p> <div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'> From: nagios-users-bounces@lists.sourceforge.net [mailto:nagios-users-bounces@lists.sourceforge.net] On Behalf Of Antonio Grassi Sent: 04 April 2008 18:53 To: Nagios-users@lists.sourceforge.net Subject: Re: [Nagios-users] RE : NDOUtils Problem<o:p></o:p> </div> <o:p> </o:p> I assume, as you have said, that /usr/local/nagios/var/ndo.sock has write permissions for the user/group that Nagios daemon runs as. In the file src/io.c, line 225, is the function ndo_sink_write, wich is returning the value NDO_ERROR and causing the function ndomod_write_to_sink in file src/ndomod.c to log the error "Error writing to data sink!" (that same function is also the one that succesfully reconnects to data sink). Maybe you can get more info about the problem, examining the errno variable after the "write" call in ndo_sink_write. You can modify the line 733 in ndomod.c for something like this: asprintf(&temp_buffer,"ndomod: Error writing to data sink (%d - %s)! Some output may get lost. %lu queued items to flush.",errno,strerror(errno), sinkbuf.items); The function strerror gives you a very short description of the error, and is defined in string.h The error codes should be defined in /usr/include/asm-generic/errno.h If the permissions are ok (which seems to be the case due to the unix socket being opened for writing succesfully), maybe there is a problem with ndo2db disconnecting for some reason in the other extreme of the socket. You can also use netstat -a to see if the ndo2db daemon is listening on the specified socket, before and after getting up nagios. Also, I think that the ndo2db daemon should at least log a query like "SELECT instance_id FROM ...", which is one of the first things that ndo2db does after connecting to the database (in ndo2db_db_hello() in src/db.c), so maybe it's the ndo2db daemon failing to connect to database (or to listen on the unix socket). The function that connects to the database is ndo2db_db_connect, which sends (un)success messages to syslog. Well, I've no more ideas at the moment. <o:p></o:p> <div> 2008/4/4, Joe Precious <<a href="mailto:JoeP@protronics.co.uk">JoeP@protronics.co.uk</a>>:<o:p></o:p> <div> <div> Config files are below. I always get the errors – nothing has been written to the database yet (NDOUtils was installed yesterday morning).<o:p></o:p> <o:p></o:p> Thanks<o:p></o:p> <o:p></o:p> ndomod.cfg:-<o:p></o:p> <o:p></o:p> instance_name=default<o:p></o:p> output_type=unixsocket<o:p></o:p> output=/usr/local/nagios/var/ndo.sock<o:p></o:p> tcp_port=5668<o:p></o:p> output_buffer_items=5000<o:p></o:p> buffer_file=/usr/local/nagios/var/ndomod.tmp<o:p></o:p> file_rotation_interval=14400<o:p></o:p> file_rotation_timeout=60<o:p></o:p> reconnect_interval=15<o:p></o:p> reconnect_warning_interval=15<o:p></o:p> data_processing_options=-1<o:p></o:p> config_output_options=2<o:p></o:p> <o:p></o:p> ndo2db.cfg:-<o:p></o:p> <o:p></o:p> ndo2db_user=nagios<o:p></o:p> ndo2db_group=nagios<o:p></o:p> socket_type=unix<o:p></o:p> socket_name=/usr/local/nagios/var/ndo.sock<o:p></o:p> tcp_port=5668<o:p></o:p> db_servertype=mysql<o:p></o:p> db_host=localhost<o:p></o:p> db_port=3306<o:p></o:p> db_name=nagios<o:p></o:p> db_prefix=nagios_<o:p></o:p> db_user=nagios<o:p></o:p> db_pass=<Removed><o:p></o:p> max_timedevents_age=1440<o:p></o:p> max_systemcommands_age=10080<o:p></o:p> max_servicechecks_age=10080<o:p></o:p> max_hostchecks_age=10080<o:p></o:p> max_eventhandlers_age=44640<o:p></o:p> debug_level=-1<o:p></o:p> debug_verbosity=2<o:p></o:p> debug_file=/var/log/ndo2db.debug<o:p></o:p> max_debug_file_size=1000000<o:p></o:p> <o:p></o:p> <div style='border:none;border-top:solid windowtext 1.0pt;padding:3.0pt 0cm 0cm 0cm; border-color:-moz-use-text-color -moz-use-text-color'> From: <a href="mailto:nagios-users-bounces@lists.sourceforge.net" target="_blank">nagios-users-bounces@lists.sourceforge.net</a> [mailto:<a href="mailto:nagios-users-bounces@lists.sourceforge.net" target="_blank">nagios-users-bounces@lists.sourceforge.net</a>] On Behalf Of Antonio Grassi Sent: 04 April 2008 15:21 To: <a href="mailto:Nagios-users@lists.sourceforge.net" target="_blank">Nagios-users@lists.sourceforge.net</a> Subject: Re: [Nagios-users] RE : NDOUtils Problem<o:p></o:p> </div> <o:p></o:p> Joe, can you please paste your ndomod.cfg and ndo2db.cfg files (without comments)?<o:p></o:p> <div> 2008/4/4, Joe Precious <<a href="mailto:JoeP@protronics.co.uk" target="_blank">JoeP@protronics.co.uk</a>>:<o:p></o:p> <div> <div> Hi<o:p></o:p> <o:p></o:p> I've enabled logging and it creates the debug file but there's nothing in it which implies to me that ndo2db is not actually doing anything at all. I guess this ties in with the errors that imply that ndomod can't connect to the socket.<o:p></o:p> <o:p></o:p> I've checked the location of the socket in both configuration files is the same, I've also confirmed it exists where it should and the permissions look fine on it (the same as my other server where it works).<o:p></o:p> <o:p></o:p> Is there anyway I can test the connection to the socket? This is starting to get a bit beyond my Linux knowledge.<o:p></o:p> <o:p></o:p> BTW I upgraded to 3.0.1 in case this helped but it didn't!<o:p></o:p> <o:p></o:p> Thanks<o:p></o:p> <o:p></o:p> Joe<o:p></o:p> <o:p></o:p> <div style='border:none;border-top:solid windowtext 1.0pt;padding:3.0pt 0cm 0cm 0cm; border-color:-moz-use-text-color'> From: <a href="mailto:nagios-users-bounces@lists.sourceforge.net" target="_blank">nagios-users-bounces@lists.sourceforge.net</a> [mailto:<a href="mailto:nagios-users-bounces@lists.sourceforge.net" target="_blank">nagios-users-bounces@lists.sourceforge.net</a>] On Behalf Of Antonio Grassi Sent: 04 April 2008 13:19 To: <a href="mailto:Nagios-users@lists.sourceforge.net" target="_blank">Nagios-users@lists.sourceforge.net</a> Subject: Re: [Nagios-users] RE : NDOUtils Problem<o:p></o:p> </div> </div> </div> </div> </div> </div> ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. <a href="http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace" target="_blank">http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace</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<o:p></o:p> </div> <o:p> </o:p> </div> </body> </html>