NDO Utils is not running even after repeated attempts

[Kevin Keane]

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
>>> -- 
>>> ------------------------------------------------------------------------
>>>
>>> ------------------------------------------------------------------------------
>>> Crystal Reports - New Free Runtime and 30 Day Trial
>>> Check out the new simplified licensing option that enables unlimited
>>> royalty-free distribution of the report engine for externally facing 
>>> server and web deployment.
>>> http://p.sf.net/sfu/businessobjects
>>> ------------------------------------------------------------------------
>>>
>>> _______________________________________________
>>> 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
>>>     
>>
>>
>>   
>
>
> -- 


-- 
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.


------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
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