unable to connect to data sink

[Kaushal Shriyan]

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 at 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 <finchs at stgeorge.com.au> wrote:

> 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" <kaushalshriyan at gmail.com> 10/07/2008 5:17 am >>>
> 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  ->
> http://www.pastebin.org/50006
> My NDOMOD CONFIG FILE is mentioned here -> http://www.pastebin.org/50007
>
> Any clue as what is going wrong
>
> Thanks and Regards
>
> Kaushal
>
>
>
> *** This is an automatically appended message from St. George ITP.  If this
> email is SPAM please register it with WebSense MailControl by clicking here
> (
> https://www.mailcontrol.com/sr/kDWEHkhQGD!TndxI!oX7UnUYIb7wfOFWhagr5azsOIFSj1TnkEgu!X53ALSpTnhEATAgmcYJRWld8GUOJKJHvw==<https://www.mailcontrol.com/sr/kDWEHkhQGD%21TndxI%21oX7UnUYIb7wfOFWhagr5azsOIFSj1TnkEgu%21X53ALSpTnhEATAgmcYJRWld8GUOJKJHvw==>). ***
>
>
> **********************************************************************
> *****   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 http://www.sourceforge.net/community/cca08
> _______________________________________________
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20080710/c668e6e5/attachment.html>
-------------- next part --------------
-------------------------------------------------------------------------
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 http://www.sourceforge.net/community/cca08
-------------- next part --------------
_______________________________________________
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