sorry Michael & Tom, blame that on all my testing getting a bit out of 
sync.

I've updated my ndomod.cfg as below, restarted mysql/nagios/ndo, and my 
problems persist

instance_name=default
output_type=unixsocket
output=/usr/local/nagios/var/ndo.sock
tcp_port=5668
use_ssl=0
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


The mysql port is confirmed as 3306

tcp        0      0 0.0.0.0:3306                0.0.0.0:*  LISTEN 
17380/mysqld
unix  2      [ ACC ]     STREAM     LISTENING     79686764 17380/mysqld   
/tmp/mysql.sock

And the table prefixs are (I think correct as nagios_)

mysql> show tables;
+----------------------------------------+
| Tables_in_nagios 
+----------------------------------------+
| nagios_acknowledgements 
| nagios_commands 
| nagios_commenthistory 
| nagios_comments 
...

mysql> show grants for 'ndouser'@'localhost';
+---------------------------------------------------------------------------------------+
| Grants for ndou...@localhost  
+---------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'ndouser'@'localhost' IDENTIFIED BY PASSWORD 
'4da1ca1e5c4de6f2' 
| GRANT ALL PRIVILEGES ON `nagios`.* TO 'ndouser'@'localhost'  
+---------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

Many thanks for all your help

Nigel Leach
Grid Engineer | Front Office Risk Systems | BNP Paribas 
 
,     5Y021 @ Harewood Avenue
( Internal  711 3634 !  Mobile  +44 (0)7789 077 946 !  Direct Dial  +44 
(0)207 595 3634 
*     [email protected]
 
Group Mail: [email protected] | Remedy Requests: CMITP FORS | 
Pickup  711 0350
 
 



Internet 
[email protected]
17/02/2010 12:21

To
Nigel LEACH
cc
[email protected]
Subject
Re: [Nagios-users] ndomod: Could not open data sink






NIgel Leach wrote:
> Nothing unfortunately,what ever debug options I set, this file is always 
empty

good. then ndo2db does not fork itsself meaning ndomod cannot connect 
over the socket. so the current problem is ndomod and/or the socket from 
which ndo2db should read then.

>> and ndomod.cfg?
> 
> here it is, cheers
> 
> instance_name=default
> output_type=tcpsocket
> output=127.0.0.1
> tcp_port=5668
> use_ssl=0
> 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

How does that match with this?

[ndo2db.cfg]
lock_file=/usr/local/nagios/var/ndo2db.lock
ndo2db_user=nagios
ndo2db_group=nagios
socket_type=unix
socket_name=/usr/local/nagios/var/ndo.sock

Kind regards,
Michael

-- 
DI (FH) Michael Friedrich
[email protected]
Tel: +43 1 4277 14359

Vienna University Computer Center
Universitaetsstrasse 7 A-1010 Vienna, Austria


___________________________________________________________
This communication is confidential, may be privileged and is meant only for the 
intended recipient. If you are not the intended recipient, please notify the 
sender by reply and delete the message from your system. Any unauthorised 
dissemination, distribution or copying hereof is prohibited.

BNP Paribas Trust Corporation UK Limited, BNP Paribas UK Limited, BNP Paribas 
Commodity Futures Limited, BNP Paribas Asset Management UK Limited and 
Investment Fund Services Limited are authorised and regulated by the Financial 
Services Authority.

BNP Paribas London Branch and BNP Paribas Wealth Management London Branch are 
authorised by the CECEI and supervised by the Commission Bancaire.  

BNP Paribas London Branch is authorised and subject to limited regulation by 
the Financial Services Authority. Details about the extent of our authorisation 
and regulation by the Financial Services Authority are available from us on 
request. BNP Paribas is also a member of the London Stock Exchange.

BNP Paribas Wealth Management London Branch is subject to limited regulation by 
the Financial Services Authority.  Details about the extent of our 
authorisation and regulation by the Financial Services Authority are available 
from us on request.  

BNP Paribas Securities Services London Branch is authorised by the CECEI and 
supervised by the AMF, and subject to limited regulation by the Financial 
Services Authority. Details on the extent of our regulation by the Financial 
Services Authority are available from us on request. BNP Paribas Securities 
Services is also a member of the London Stock Exchange.

BNP Paribas Trust Corporation UK Limited is registered in England and Wales 
(registered no. 4042668) at registered office 55 Moorgate, London EC2R 6PA.

BNP Paribas UK Limited is registered in England and Wales (registered no. 
1488108) at registered office 10 Harewood Avenue, London NW1 6AA.

BNP Paribas Commodity Futures Limited is registered in England and Wales 
(registered no. 2391477) at registered office 10 Harewood Avenue, London NW1 
6AA.

BNP Paribas Asset Management UK Limited is registered in England and Wales 
(registered no. 2474627) at registered office 10 Harewood Avenue, London NW1 
6AA.

Investment Fund Services Limited is registered in England and Wales (registered 
no. 6110770) at registered office 55 Moorgate, London EC2R 6PA.

BNP Paribas London Branch is registered in England and Wales (registered no. 
FC13447) at registered office 10 Harewood Avenue, London NW1 6AA.

BNP Paribas Wealth Management London Branch is registered in England and Wales 
(registered no. FC023926) at registered office 10 Harewood Avenue, London NW1 
6AA.

BNP Paribas Securities Services London Branch is registered in England and 
Wales (registered no. BR006393) at registered office 55 Moorgate, London, EC2R 
6PA.

BNP Paribas Lease Group Plc  is registered in England and Wales (registered no. 
2341989) at registered office Northern Cross, Basing View, Basingstoke, 
Hampshire RG21 4HL.
____________________________________________________________

------------------------------------------------------------------------------
SOLARIS 10 is the OS for Data Centers - provides features such as DTrace,
Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW
http://p.sf.net/sfu/solaris-dev2dev
_______________________________________________
Nagios-users mailing list
[email protected]
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

Reply via email to