Hi Simon It works perfectly fine when i do the below steps $ mysql -u ndouser -p nagios Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 135 Server version: 5.0.54-log Gentoo Linux mysql-5.0.54 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> \s -------------- mysql Ver 14.12 Distrib 5.0.54, for pc-linux-gnu (x86_64) using readline 5.2 Connection id: 135 Current database: nagios Current user: ndouser@localhost SSL: Not in use Current pager: /usr/bin/less Using outfile: '' Using delimiter: ; Server version: 5.0.54-log Gentoo Linux mysql-5.0.54 Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: utf8 Db characterset: utf8 Client characterset: utf8 Conn. characterset: utf8 UNIX socket: /var/run/mysqld/mysqld.sock Uptime: 16 hours 36 min 21 sec Threads: 4 Questions: 1905637 Slow queries: 0 Opens: 150 Flush tables: 1 Open tables: 64 Queries per second avg: 31.877 -------------- mysql> quit Any further clue Awaiting your earnest reply. Thanks and Regards Kaushal On Thu, Jul 10, 2008 at 5:49 AM, Simon Finch <<a href="mailto:finchs@stgeorge.com.au">finchs@stgeorge.com.au</a>> wrote: <div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi Kaushal, The db_user, db_pass and db_name in your ndo2db.cfg file are still set to the defaults of db_user=ndouser db_pass=ndopassword db_name=nagios Did you create the MySql database "nagios" and can you connect to it from the console on your host ? mysql -u ndouser -p nagios should prompt you for a password, ie, "ndopassword" and then give you a mysql prompt. "\s" should then show you a status screen with the database and connection details. Hope this helps. Simon Finch ESM Team Leader St.George Bank Australia >>> "Kaushal Shriyan" <<a href="mailto:kaushalshriyan@gmail.com">kaushalshriyan@gmail.com</a>> 10/07/2008 5:17 am >>> <div><div></div><div class="Wj3C7c">Hi I get [1215630364] ndomod: Still unable to connect to data sink. 1019216 items lost, 5000 queued items to flush. in nagios.log file I can see the ndo2db has been started. nagios 14086 19676 0 11:24 ? 00:00:02 /usr/nagios/bin/ndo2db-2x -c /etc/nagios/ndo2db.cfg nagios 15964 19676 0 11:25 ? 00:00:02 /usr/nagios/bin/ndo2db-2x -c /etc/nagios/ndo2db.cfg nagios 19676 1 0 07:44 ? 00:00:00 /usr/nagios/bin/ndo2db-2x -c /etc/nagios/ndo2db.cfg nagios 23622 19676 0 08:38 ? 00:00:10 /usr/nagios/bin/ndo2db-2x -c /etc/nagios/ndo2db.cfg My NDO2DB DAEMON CONFIG FILE is mentioned here -> <a href="http://www.pastebin.org/50006" target="_blank">http://www.pastebin.org/50006</a> My NDOMOD CONFIG FILE is mentioned here -> <a href="http://www.pastebin.org/50007" target="_blank">http://www.pastebin.org/50007</a> Any clue as what is going wrong Thanks and Regards Kaushal </div></div>*** This is an automatically appended message from St. George ITP. If this email is SPAM please register it with WebSense MailControl by clicking here ( <a href="https://www.mailcontrol.com/sr/kDWEHkhQGD%21TndxI%21oX7UnUYIb7wfOFWhagr5azsOIFSj1TnkEgu%21X53ALSpTnhEATAgmcYJRWld8GUOJKJHvw==" target="_blank">https://www.mailcontrol.com/sr/kDWEHkhQGD!TndxI!oX7UnUYIb7wfOFWhagr5azsOIFSj1TnkEgu!X53ALSpTnhEATAgmcYJRWld8GUOJKJHvw==</a> ). *** ********************************************************************** ***** IMPORTANT INFORMATION ***** This document should be read only by those persons to whom it is addressed and its content is not intended for use by any other persons. If you have received this message in error, please notify us immediately. Please also destroy and delete the message from your computer. Any unauthorised form of reproduction of this message is strictly prohibited. St George Bank Limited AFSL 240997, Advance Asset Management Limited AFSL 240902, St George Life Limited AFSL 240900, ASGARD Capital Management Limited AFSL 240695 and Securitor Financial Group Limited AFSL 240687 is not liable for the proper and complete transmission of the information contained in this communication, nor for any delay in its receipt. ********************************************************************** ------------------------------------------------------------------------- Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at <a href="http://www.sourceforge.net/community/cca08" target="_blank">http://www.sourceforge.net/community/cca08</a> _______________________________________________ Nagios-users mailing list <a href="mailto:Nagios-users@lists.sourceforge.net">Nagios-users@lists.sourceforge.net</a> <a 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>