<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=us-ascii"> <META content="MSHTML 6.00.2900.3059" name=GENERATOR></HEAD> <BODY> <DIV><FONT face=Arial size=2><SPAN class=181405814-02052007>I recently installed <FONT face="Times New Roman"><FONT size=3>Nagios 3.0a3 with mysql and NDOUtils 1.4b3<SPAN class=768170715-02052007> on REDHAT 4</SPAN><SPAN class=768170715-02052007>. Nagios is up and running as expected, but i keep running into this issue</SPAN></FONT></FONT></SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=181405814-02052007><FONT face=Arial size=2><SPAN class=768170715-02052007></SPAN></FONT></SPAN></FONT> </DIV> <DIV><FONT face=Arial size=2><SPAN class=181405814-02052007><FONT size=3><SPAN class=768170715-02052007>[1178115841] ndomod: Could not open data sink! I'll keep trying, but some output may get lost...</SPAN></FONT></SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=181405814-02052007><FONT size=3><SPAN class=768170715-02052007><BR><FONT face=Arial size=2>I have double checked everythng I can think of as well as everything I could GOOGLE about this issue.</FONT></SPAN></FONT></SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=181405814-02052007><FONT face=Arial size=2><SPAN class=768170715-02052007></SPAN></FONT></SPAN></FONT> </DIV> <DIV><SPAN class=181405814-02052007><SPAN class=768170715-02052007><FONT face=Arial size=2>I know the account is setup for mysql becasue i can query thru command line and check_mysql_query thru nagios </FONT></SPAN></SPAN></DIV> <DIV><FONT face=Arial size=2><SPAN class=181405814-02052007></SPAN></FONT> </DIV> <DIV><SPAN class=181405814-02052007> <DIV><FONT face=Arial size=2><SPAN class=181405814-02052007>output from <STRONG>/usr/local/var/nagis.log</STRONG></SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=181405814-02052007></SPAN></FONT> </DIV> <DIV><SPAN class=181405814-02052007><FONT face=Arial size=2>[1178115841] Nagios 3.0a3 starting... (PID=25257)<BR>[1178115841] LOG VERSION: 2.0<BR>[1178115841] ndomod: NDOMOD 1.4b3 (04-10-2007) Copyright (c) 2005-2007 Ethan Galstad (</FONT><A href="mailto:nagios@nagios.org"><FONT face=Arial size=2>nagios@nagios.org</FONT></A><FONT face=Arial size=2>)<BR>[1178115841] ndomod: Could not open data sink! I'll keep trying, but some output may get lost...<BR>[1178115841] Event broker module '/usr/local/nagios/bin/ndomod-3x.o' initialized successfully.<BR>[1178115841] Finished daemonizing... (New PID=25258)<BR>[1178116753] ndomod: Still unable to connect to data sink. 0 items lost, 4757 queued items to flush.<BR>[1178117665] ndomod: Still unable to connect to data sink. 4291 items lost, 5000 queued items to flush.</FONT></SPAN></DIV> <DIV><FONT face=Arial size=2><SPAN class=181405814-02052007></SPAN></FONT> </DIV> <DIV><FONT face=Arial size=2><SPAN class=181405814-02052007></SPAN></FONT> </DIV> <DIV><FONT face=Arial size=2><SPAN class=181405814-02052007>ndo2db.cfg</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=181405814-02052007></SPAN></FONT> </DIV> <DIV><FONT face=Arial size=2><SPAN class=181405814-02052007># USER/GROUP PRIVILIGES<BR></SPAN></FONT><FONT face=Arial size=2><SPAN class=181405814-02052007>ndo2db_user=nagios<BR>ndo2db_group=nagios</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2><SPAN class=181405814-02052007># SOCKET TYPE<BR># unix = Unix domain socket (default)<BR># tcp = TCP socket</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=181405814-02052007>socket_type=unix<BR>#socket_type=tcp<BR></SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=181405814-02052007></SPAN></FONT> </DIV> <DIV><FONT face=Arial size=2><SPAN class=181405814-02052007><SPAN class=768170715-02052007> this file is created and owned by nagios</SPAN></SPAN></FONT></DIV> <DIV><FONT size=2><FONT face=Arial><SPAN class=181405814-02052007> </DIV></SPAN></FONT></FONT> <DIV><FONT face=Arial><FONT size=2><SPAN class=181405814-02052007># SOCKET NAME<BR></SPAN><SPAN class=181405814-02052007>socket_name=/usr/local/nagios/var/ndo.sock</SPAN></FONT></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=181405814-02052007></SPAN></FONT> </DIV> <DIV><FONT face=Arial size=2><SPAN class=181405814-02052007># DATABASE SERVER TYPE<BR># mysql = MySQL<BR># pgsql = PostgreSQL</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=181405814-02052007>db_servertype=mysql</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2><SPAN class=181405814-02052007># DATABASE HOST<BR># This option specifies what host the DB server is running on.</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=181405814-02052007>db_host=localhost</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=181405814-02052007></SPAN></FONT> </DIV> <DIV><FONT face=Arial size=2><SPAN class=181405814-02052007># DATABASE PORT<BR># 3306 = Default MySQL port<BR># 5432 = Default PostgreSQL port</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=181405814-02052007>db_port=3306</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV><FONT face=Arial size=2><SPAN class=181405814-02052007># DATABASE NAME<BR># This option specifies the name of the database that should be used.</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=181405814-02052007>db_name=nagios</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=181405814-02052007></SPAN></FONT> </DIV> <DIV><FONT face=Arial size=2><SPAN class=181405814-02052007># DATABASE USERNAME/PASSWORD<BR></SPAN></FONT><FONT face=Arial size=2><SPAN class=181405814-02052007>db_user=nagios<BR>db_pass=********* (the correct password is in the config file)<BR></SPAN></FONT></DIV></SPAN></DIV></BODY></HTML>