Joe, maybe you can debug the problem with the debug archive of ndo2db (you set it in the configuration file, and you also set the debug level and verbosity). There you can even see the queries sent to the database, and the errors they generate. I'm using Nagios 3.0 and NDO1.4b7 and I've no problems. Antonio <div>2008/4/4, Joe Precious <<a href="mailto:JoeP@protronics.co.uk">JoeP@protronics.co.uk</a>>:<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> <div link="blue" vlink="blue" lang="EN-GB"> <div> I've double-checked all my config files and all the important settings match yours. I wonder if this is a problem when doing a fresh install on Nagios 3.0 rather than upgrading from previous versions? Joe <div> <div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0cm 0cm;"> From: <a href="mailto:yannig.perre@externe.bnpparibas.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">yannig.perre@externe.bnpparibas.com</a> [mailto:<a href="mailto:yannig.perre@externe.bnpparibas.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">yannig.perre@externe.bnpparibas.com</a>] Sent: 04 April 2008 09:30 To: <a href="mailto:webknowledge@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">webknowledge@gmail.com</a>; Joe Precious Cc: <a href="mailto:Nagios-users@lists.sourceforge.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Nagios-users@lists.sourceforge.net</a> Subject: RE : [Nagios-users] NDOUtils Problem </div> </div> I'm using nagios 3.0 (from b6 through 3.0) and ndoutils 1.4.b7 since a few months against a Solaris 8 without problem. I'm monitoring around 50 servers and 700 services. Here's my configuration: root@xxx # cat ndomod.cfg instance_name=default output_type=unixsocket output=/path/to/nagios/var/ndo.sock tcp_port=5668 # increase this to a higher value if you want to be able to stop ndo2db a long time output_buffer_items=50000 buffer_file=/path/to/nagios /var/ndomod.tmp file_rotation_interval=14400 file_rotation_timeout=60 reconnect_interval=15 reconnect_warning_interval=15 data_processing_options=-1 config_output_options=0 root@xxx # cat ndo2db.cfg # set the name of the user launching ndo2db module broker ndo2db_user=nagios ndo2db_group=nagios socket_type=unix socket_name=/path/to/nagios/var/ndo.sock tcp_port=5668 # config of the mysql backend db_servertype=mysql db_host=localhost db_port=3306 db_name=nagios db_prefix=nagios_ db_user=mysql_user db_pass=mysql_passwd # retention of data max_timedevents_age=1440 max_systemcommands_age=10080 # = 100 days max_servicechecks_age=144000 max_hostchecks_age=10080 max_eventhandlers_age=44640 debug_level=1 debug_verbosity=0 debug_file=/path/to/nagios/var/ndo.debug max_debug_file_size=1000000 Finaly, nagios.cfg contains this line: # ndoutils broker broker_module=/path/to/nagios/bin/ndomod.o config_file=/path/to/nagios/etc/ndomod.cfg -----Message d'origine----- De : <a href="mailto:nagios-users-bounces@lists.sourceforge.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">nagios-users-bounces@lists.sourceforge.net</a> [mailto:<a href="mailto:nagios-users-bounces@lists.sourceforge.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">nagios-users-bounces@lists.sourceforge.net</a>] De la part de <a href="mailto:webknowledge@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">webknowledge@gmail.com</a> Envoyé : jeudi 3 avril 2008 22:47 À : <a href="mailto:JoeP@protronics.co.uk" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">JoeP@protronics.co.uk</a> Cc : <a href="mailto:Nagios-users@lists.sourceforge.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Nagios-users@lists.sourceforge.net</a> Objet : Re: [Nagios-users] NDOUtils Problem >From NDOUtils 1.4.b7 Changelog: 1.4b7 - 10/31/2007 ----------------- NOTE: ** Requires Nagios 2.7 or higher, or Nagios 3.0b6 - Makefile fixes for compilation flags - Fix for bug where service check table always had same start/end time - Added sample init script for SLES (Bruno Quintais) - Added --with-ndo2db-user and --with-ndo2db-group configure script options - Fix for configfilevariables table not holding multiple entries for various variables - Changed/added indexes on various DB tables - Added some very basic debug file capabilities (not complete yet) - Fix for handling (backwards) system time changes - Fix for missing SUN_LEN definition and strtof() functions on Solaris 8 (Christian Masopust) - Fix for segfault when importing duplicate log file entries (Hendrik Frenzel) - Updated to support latest Nagios 3.x code (3.0b6) So, I think Nagios3.0.X isn't supported yet. I'm having issues with ndomod for nagios 3-x installs, so I've sticked with nagios 2.11 with 1.4b7 and it works fine. Hold your migration, for a new release of the mod. Cheers, <div> On Thu, Apr 3, 2008 at 5:22 PM, Joe Precious <<a href="mailto:JoeP@protronics.co.uk" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">JoeP@protronics.co.uk</a>> wrote: <div> <div> Hi </div> <div> </div> <div> I'm having some problems getting NDOUtils running on a new Nagios installation. I have it running fine on a Nagios 3.0rc3 installation on Ubuntu 6.06 server but I need to move to a new server. I've gone to Nagios 3.0 on a Ubuntu 7.10 machine which is all running fine but when I can't get NDOUtils running. I run through the installation several times to make sure I've done everything, double-checked all config files, confirmed the database and access but it won't run. I see the following in the Nagios log:- </div> <div> </div> <div> [04-03-2008 13:32:47] ndomod: Successfully reconnected to data sink! 0 items lost, 78 queued items to flush. [04-03-2008 13:32:31] ndomod: Error writing to data sink! Some output may get lost... [04-03-2008 13:32:31] ndomod: Successfully flushed 289 queued items to data sink. [04-03-2008 13:32:31] ndomod: Successfully reconnected to data sink! 0 items lost, 289 queued items to flush. [04-03-2008 13:32:15] ndomod: Error writing to data sink! Some output may get lost. 194 queued items to flush. [04-03-2008 13:32:15] ndomod: Successfully reconnected to data sink! 0 items lost, 505 queued items to flush. [04-03-2008 13:31:59] ndomod: Error writing to data sink! Some output may get lost. 424 queued items to flush. [04-03-2008 13:31:59] ndomod: Successfully reconnected to data sink! 0 items lost, 588 queued items to flush. [04-03-2008 13:31:43] ndomod: Error writing to data sink! Some output may get lost. 499 queued items to flush. [04-03-2008 13:31:43] ndomod: Successfully reconnected to data sink! 0 items lost, 676 queued items to flush. [04-03-2008 13:31:27] ndomod: Error writing to data sink! Some output may get lost... [04-03-2008 13:31:27] Finished daemonizing... (New PID=14596) [04-03-2008 13:31:27] Event broker module '/usr/local/nagios/bin/ndomod-3x.o' initialized successfully. [04-03-2008 13:31:27] ndomod: Successfully connected to data sink. 0 queued items to flush. [04-03-2008 13:31:27] ndomod: NDOMOD 1.4b7 (10-31-2007) Copyright (c) 2005-2007 Ethan Galstad (<a href="mailto:nagios@nagios.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">nagios@nagios.org</a>) [04-03-2008 13:31:27] LOG VERSION: 2.0 [04-03-2008 13:31:27] Local time is Thu Apr 03 13:31:27 BST 2008 [04-03-2008 13:31:27] Nagios 3.0 starting... (PID=14594) </div> <div> </div> <div> I've found a few threads on the internet with similar errors but not found a resolution. I'm at a loss how to proceed with troubleshooting. </div> <div> </div> <div> Thanks </div> <div> </div> <div> Joe </div> Joe Precious Protronics Tel: 0845 458 3234 <a href="mailto:support@protronics.co.uk" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">support@protronics.co.uk</a> Fax: 0207 407 2441 -------------------------------------------------------------------------- Business Driven IT Microsoft Gold Certified Partner Cisco SMB Select Partner -------------------------------------------------------------------------- Accounts • Networks • Development • Training -------------------------------------------------------------------------- <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" onclick="return top.js.OpenExtLink(window,event,this)">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" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Nagios-users@lists.sourceforge.net</a> <a href="https://lists.sourceforge.net/lists/listinfo/nagios-users" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">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 </div> <pre style="margin-left: 36pt;"> </pre><pre style="margin-left: 36pt;"> </pre><pre style="margin-left: 36pt;"> </pre><pre style="margin-left: 36pt;"> </pre> <pre style="margin-left: 36pt;">This message and any attachments (the "message") is</pre><pre style="margin-left: 36pt;">intended solely for the addressees and is confidential. </pre> <pre style="margin-left: 36pt;">If you receive this message in error, please delete it and </pre><pre style="margin-left: 36pt;">immediately notify the sender. Any use not in accord with </pre> <pre style="margin-left: 36pt;">its purpose, any dissemination or disclosure, either whole </pre><pre style="margin-left: 36pt;">or partial, is prohibited except formal approval. The internet</pre> <pre style="margin-left: 36pt;">can not guarantee the integrity of this message. </pre><pre style="margin-left: 36pt;">BNP PARIBAS (and its subsidiaries) shall (will) not </pre> <pre style="margin-left: 36pt;">therefore be liable for the message if modified. </pre><pre style="margin-left: 36pt;">Do not print this message unless it is necessary,</pre><pre style="margin-left: 36pt;"> consider the environment.</pre><pre style="margin-left: 36pt;"> </pre><pre style="margin-left: 36pt;"> ---------------------------------------------</pre> <pre style="margin-left: 36pt;"> </pre><pre style="margin-left: 36pt;">Ce message et toutes les pieces jointes (ci-apres le </pre><pre style="margin-left: 36pt;">"message") sont etablis a l'intention exclusive de ses </pre> <pre style="margin-left: 36pt;">destinataires et sont confidentiels. Si vous recevez ce </pre><pre style="margin-left: 36pt;">message par erreur, merci de le detruire et d'en avertir </pre> <pre style="margin-left: 36pt;">immediatement l'expediteur. Toute utilisation de ce </pre><pre style="margin-left: 36pt;">message non conforme a sa destination, toute diffusion </pre> <pre style="margin-left: 36pt;">ou toute publication, totale ou partielle, est interdite, sauf </pre><pre style="margin-left: 36pt;">autorisation expresse. L'internet ne permettant pas </pre> <pre style="margin-left: 36pt;">d'assurer l'integrite de ce message, BNP PARIBAS (et ses</pre><pre style="margin-left: 36pt;">filiales) decline(nt) toute responsabilite au titre de ce </pre> <pre style="margin-left: 36pt;">message, dans l'hypothese ou il aurait ete modifie.</pre><pre style="margin-left: 36pt;">N'imprimez ce message que si necessaire,</pre> <pre style="margin-left: 36pt;">pensez a l'environnement.</pre></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 onclick="return top.js.OpenExtLink(window,event,this)" 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 onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:Nagios-users@lists.sourceforge.net">Nagios-users@lists.sourceforge.net</a> <a onclick="return top.js.OpenExtLink(window,event,this)" 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>