NDO Utils is not running even after repeated attempts

[Kevin Keane]

The error message says that ndoutils is running, but can't connect to 
the database.

Can you try and see if port 3306 is open? That is the one MySQL should 
be listening on. The command to do that is:

netstat -ltunp

Next, check if there might be a firewall blocking access. For instance, 
to see the rules for iptables:

iptables -vnL

I hope this helps!

rajashekar.s wrote:
> Hello all,
>
> I request your help for this problem of mine.
> Please refer this mail down for all the configuration settings.
>
> I am still getting the same message
>
> Jun 25 18:23:12 excel-desktop nagios: Nagios 3.0.6 starting... (PID=464)
> Jun 25 18:23:12 excel-desktop nagios: Local time is Thu Jun 25 
> 18:23:12 IST 2009
> Jun 25 18:23:12 excel-desktop nagios: LOG VERSION: 2.0
> Jun 25 18:23:12 excel-desktop nagios: ndomod: NDOMOD 1.4b7 
> (10-31-2007) Copyright (c) 2005-2007 Ethan Galstad (nagios at nagios.org)
> Jun 25 18:23:12 excel-desktop nagios: ndomod: Could not open data 
> sink!  I'll keep trying, but some output may get lost...
> Jun 25 18:23:12 excel-desktop nagios: Event broker module 
> '/usr/local/nagios/bin/ndomod-3x.o' initialized successfully.
> Jun 25 18:23:12 excel-desktop nagios: Finished daemonizing... (New 
> PID=465)
> Jun 25 18:23:28 excel-desktop nagios: ndomod: Still unable to connect 
> to data sink.  394 items lost, 5000 queued items to flush.
> Jun 25 18:23:44 excel-desktop nagios: ndomod: Still unable to connect 
> to data sink.  482 items lost, 5000 queued items to flush.
> Jun 25 18:24:00 excel-desktop nagios: ndomod: Still unable to connect 
> to data sink.  579 items lost, 5000 queued items to flush.
>
> Thanks
> Rajshekar
>
>
>
> rajashekar.s wrote:
>> Dear Kevin,
>>
>> I did as you said, but still it is not connected (same message is coming)
>> when I run the command
>>
>> # /usr/local/nagios/bin/ndo2db-3x -c /usr/local/nagios/etc/ndo2db.cfg
>> Error processing config file '/usr/local/nagios/etc/ndo2db.cfg'.
>>
>> I do not know the what is the error?
>>
>> I restarted both Nagios and MySQL
>>
>> Thanks
>> Rajshekar
>>
>> Kevin Keane wrote:
>>> OK, that explains it. Use 127.0.01 instead.
>>>
>>> MySQL tries to be "smart" and in the process confuses everybody; it 
>>> interprets "localhost" to mean "I want to use Unix sockets". But based 
>>> on your configuration file, you obviously want to use TCP sockets. Using 
>>> the IP address instead tells MySQL to use TCP sockets even when 
>>> connecting locally.
>>>
>>> And please respond back to the group so others benefit from the answer 
>>> as well.
>>>
>>> rajashekar.s wrote:
>>>   
>>>> Dear kevin,
>>>> Sorry i have missed it while doing copy paste operation
>>>> *db_host = localhost*
>>>> I have defined in ndo2db.cfg file
>>>>
>>>> Thanks
>>>> Rajshekar
>>>>
>>>> Kevin Keane wrote:
>>>>     
>>>>> I don't see where you specified the db_host in ndo2db.cfg.
>>>>>
>>>>> rajashekar.s wrote:
>>>>>   
>>>>>       
>>>>>> Hi all,
>>>>>> I have installed Nagios 3.0.6 and Nagios Plugin-1.4.13 and NDO 
>>>>>> Utils1.4b7 as given in the installtion manual. but I get message
>>>>>> ndomod:Still unable to connect to data sink
>>>>>>
>>>>>> The following are the related config settings
>>>>>> *_ndo2db.cfg_*
>>>>>>
>>>>>> ndo2db_user=nagios
>>>>>> ndo2db_group=nagios
>>>>>> socket_type=tcp
>>>>>> tcp_port=5668
>>>>>> db_servertype=MySQL
>>>>>> db_port=3306
>>>>>> db_name=nagios
>>>>>> db_prefix=nagios_
>>>>>> db_user=nagios
>>>>>> db_pass=nagios
>>>>>> max_timedevents_age=1440
>>>>>> max_systemcommands_age=10080
>>>>>> max_servicechecks_age=10080
>>>>>> max_hostchecks_age=10080
>>>>>> max_eventhandlers_age=44640
>>>>>> debug_level=-1
>>>>>> debug_verbosity=1
>>>>>> debug_file=/usr/local/nagios/var/ndo2db.debug
>>>>>> max_debug_file_size=1000000
>>>>>>
>>>>>> *_ndomod_*
>>>>>>
>>>>>> instance_name=default
>>>>>> output_type=tcpsocket
>>>>>> output=127.0.0.1
>>>>>> tcp_port=5668
>>>>>> output_buffer_items=5000
>>>>>> buffer_file=/usr/local/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=2
>>>>>>
>>>>>> *_my.cnf (MySQL)_*
>>>>>>
>>>>>> [client]
>>>>>> port        = 3306
>>>>>> socket        = /var/run/mysqld/mysqld.sock
>>>>>>
>>>>>> [mysqld_safe]
>>>>>> socket        = /var/run/mysqld/mysqld.sock
>>>>>> nice        = 0
>>>>>>
>>>>>> [mysqld]
>>>>>>
>>>>>> user        = mysql
>>>>>> pid-file    = /var/run/mysqld/mysqld.pid
>>>>>> socket        = /var/run/mysqld/mysqld.sock
>>>>>> port        = 3306
>>>>>> basedir        = /usr
>>>>>> datadir        = /var/lib/mysql
>>>>>> tmpdir        = /tmp
>>>>>> language    = /usr/share/mysql/english
>>>>>> skip-external-locking
>>>>>>
>>>>>> key_buffer        = 16M
>>>>>> max_allowed_packet    = 16M
>>>>>> thread_stack        = 128K
>>>>>> thread_cache_size    = 8
>>>>>> max_connections        = 100
>>>>>> table_cache            = 64
>>>>>> thread_concurrency     = 10
>>>>>>
>>>>>> query_cache_limit       = 1M
>>>>>> query_cache_size        = 16M
>>>>>>
>>>>>> expire_logs_days    = 10
>>>>>> max_binlog_size         = 100M
>>>>>>
>>>>>> skip-bdb
>>>>>>
>>>>>> [mysqldump]
>>>>>> quick
>>>>>> quote-names
>>>>>> max_allowed_packet    = 16M
>>>>>>
>>>>>> [mysql]
>>>>>>
>>>>>> [isamchk]
>>>>>> key_buffer        = 16M
>>>>>>
>>>>>> !includedir /etc/mysql/conf.d/
>>>>>>
>>>>>> I request you help
>>>>>> -- 
>>>>>>             

-- 
Kevin Keane
Owner
The NetTech
Find the Uncommon: Expert Solutions for a Network You Never Have to Think About

Office: 866-642-7116
http://www.4nettech.com

This e-mail and attachments, if any, may contain confidential and/or proprietary information. Please be advised that the unauthorized use or disclosure of the information is strictly prohibited. The information herein is intended only for use by the intended recipient(s) named above. If you have received this transmission in error, please notify the sender immediately and permanently delete the e-mail and any copies, printouts or attachments thereof.


------------------------------------------------------------------------------
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null