<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> </head> <body bgcolor="#ffffff" text="#993399"> Kevin, This is the net stat result... I think the port is open tcp 0 0 0.0.0.0:5666 0.0.0.0:* LISTEN 5404/xinetd tcp 0 0 0.0.0.0:389 0.0.0.0:* LISTEN 5060/slapd tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 4992/mysqld tcp 0 0 0.0.0.0:139 0.0.0.0:* LISTEN 5278/smbd tcp 0 0 192.168.2.86:11211 0.0.0.0:* LISTEN 5140/memcached tcp 0 0 0.0.0.0:10000 0.0.0.0:* LISTEN 17553/perl tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN 6493/apache2 tcp 0 0 127.0.0.1:631 0.0.0.0:* LISTEN 5105/cupsd tcp 0 0 0.0.0.0:23 0.0.0.0:* LISTEN 5404/xinetd tcp 0 0 0.0.0.0:3128 0.0.0.0:* LISTEN 24284/(squid) tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN 5236/master tcp 0 0 0.0.0.0:445 0.0.0.0:* LISTEN 5278/smbd tcp6 0 0 127.0.0.1:8005 :::* LISTEN 6578/java tcp6 0 0 :::389 :::* LISTEN 5060/slapd tcp6 0 0 :::8009 :::* LISTEN 6578/java tcp6 0 0 :::22 :::* LISTEN 4868/sshd tcp6 0 0 ::1:25 :::* LISTEN 5236/master tcp6 0 0 :::90 :::* LISTEN 6578/java and This is the result of IP Tables rules Chain INPUT (policy ACCEPT 5448K packets, 567M bytes) pkts bytes target prot opt in out source destination Chain FORWARD (policy ACCEPT 0 packets, 0 bytes) pkts bytes target prot opt in out source destination Chain OUTPUT (policy ACCEPT 2426K packets, 1747M bytes) pkts bytes target prot opt in out source destination sorry to say that I am not understanding the second command out put Please let me know any change is to be made I am able to connect to My SQL at port number 3306 Thanks Rajshekar Kevin Keane wrote: <blockquote cite="mid:4A437859.3030307@kkeane.com" type="cite"> <pre wrap="">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: </pre> <blockquote type="cite"> <pre wrap="">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 (<a class="moz-txt-link-abbreviated" href="mailto:nagios@nagios.org">nagios@nagios.org</a>) 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: </pre> <blockquote type="cite"> <pre wrap="">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: </pre> <blockquote type="cite"> <pre wrap="">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: </pre> <blockquote type="cite"> <pre wrap="">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: </pre> <blockquote type="cite"> <pre wrap="">I don't see where you specified the db_host in ndo2db.cfg. rajashekar.s wrote: </pre> <blockquote type="cite"> <pre wrap="">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 -- </pre> </blockquote> </blockquote> </blockquote> </blockquote> </blockquote> </blockquote> <pre wrap=""> </pre> </blockquote> <div class="moz-signature">-- <img src="cid:part1.02020205.04060404@excelindia.com" border="0"></div> </body> </html>