Nagios 4 and ndoutils 2.0

[kluenni]

Hi,

i just installed nagios 4 and ndoutils 2.0 and get following error message if i try to execute this command:

/usr/local/nagios/bin/ndo2db-4x -c /usr/local/nagios/etc/ndo2db.cfg

Support for the specified database server is either not yet supported, or was not found on your system.

In ndo2db.cfg I defined:

grep "db_" ndo2db.cfg
ndo2db_user=nagios
ndo2db_group=nagios
db_servertype=mysql
db_host=localhost
db_port=3306
db_name=nagios
db_prefix=nagios_
db_user=Nagios
db_pass=xxxxx


nagios.log:

[1427099956] Nagios 4.0.8 starting... (PID=3416)
[1427099956] Local time is Mon Mar 23 09:39:16 CET 2015
[1427099956] LOG VERSION: 2.0
[1427099956] qh: Socket '/usr/local/nagios/var/rw/nagios.qh' successfully initialized
[1427099956] qh: core query handler registered
[1427099956] nerd: Channel hostchecks registered successfully
[1427099956] nerd: Channel servicechecks registered successfully
[1427099956] nerd: Channel opathchecks registered successfully
[1427099956] nerd: Fully initialized and ready to rock!
[1427099956] wproc: Successfully registered manager as @wproc with query handler
[1427099956] wproc: Registry request: name=Core Worker 3417;pid=3417
[1427099956] wproc: Registry request: name=Core Worker 3419;pid=3419
[1427099956] wproc: Registry request: name=Core Worker 3420;pid=3420
[1427099956] wproc: Registry request: name=Core Worker 3418;pid=3418
[1427099956] ndomod: NDOMOD 2.0.0 (02-28-2014) Copyright (c) 2009 Nagios Core Development Team and Community Contributors
[1427099957] ndomod: Could not open data sink! I'll keep trying, but some output may get lost...
[1427099957] ndomod registered for process data
[1427099957] ndomod registered for timed event data
[1427099957] ndomod registered for log data'
[1427099957] ndomod registered for system command data'
[1427099957] ndomod registered for event handler data'
[1427099957] ndomod registered for notification data'
[1427099957] ndomod registered for service check data'
[1427099957] ndomod registered for host check data'
[1427099957] ndomod registered for comment data'
[1427099957] ndomod registered for downtime data'
[1427099957] ndomod registered for flapping data'
[1427099957] ndomod registered for program status data'
[1427099957] ndomod registered for host status data'
[1427099957] ndomod registered for service status data'
[1427099957] ndomod registered for adaptive program data'
[1427099957] ndomod registered for adaptive host data'
[1427099957] ndomod registered for adaptive service data'
[1427099957] ndomod registered for external command data'
[1427099957] ndomod registered for aggregated status data'
[1427099957] ndomod registered for retention data'
[1427099957] ndomod registered for contact data'
[1427099957] ndomod registered for contact notification data'
[1427099957] ndomod registered for acknowledgement data'
[1427099957] ndomod registered for contact status data'
[1427099957] ndomod registered for adaptive contact data'
[1427099957] Event broker module '/usr/local/nagios/bin/ndomod-4x.o' initialized successfully.
[1427099957] Successfully launched command file worker with pid 3421
[1427099976] ndomod: Still unable to connect to data sink. 0 items lost, 223 queued items to flush.




Can you help me?

Florian

[abrist]

Do you have the install log from ndo?
Is mysql/maria installed?
Did ndo create the necessary tables, etc?

[kluenni]

i installed mysql and crate the tables with ./installdb....... from the db directory from ndoutils.

what is the install log from ndb?

Florian

[ssax]

You need to run the commands below and re-install:

Code: Select all

yum install mysql-devel -y

cd into your ndoutils-2.0.0 installation directory and run:

Code: Select all

.configure
make
make install

You can then use:

Code: Select all

/usr/local/nagios/bin/ndo2db -c /usr/local/nagios/etc/ndo2db.cfg
service nagios restart

Instead of:

Code: Select all

/usr/local/nagios/bin/ndo2db-4x -c /usr/local/nagios/etc/ndo2db.cfg

You can then delete the old one with:

Code: Select all

rm -f /usr/local/nagios/bin/ndo2db-4x

That should get you working, if not, run the commands below:

Code: Select all

chown nagios.nagios /usr/local/nagios/bin/ndo*
chown nagios.nagios /usr/local/nagios/etc/ndo*
service nagios restart

[kluenni]

Hi, thanks for the answer. But it is still not working.

Code: Select all

[1427179893] Nagios 4.0.8 starting... (PID=30588)
[1427179893] Local time is Tue Mar 24 07:51:33 CET 2015
[1427179893] LOG VERSION: 2.0
[1427179893] qh: Socket '/usr/local/nagios/var/rw/nagios.qh' successfully initialized
[1427179893] qh: core query handler registered
[1427179893] nerd: Channel hostchecks registered successfully
[1427179893] nerd: Channel servicechecks registered successfully
[1427179893] nerd: Channel opathchecks registered successfully
[1427179893] nerd: Fully initialized and ready to rock!
[1427179893] wproc: Successfully registered manager as @wproc with query handler
[1427179893] wproc: Registry request: name=Core Worker 30591;pid=30591
[1427179893] wproc: Registry request: name=Core Worker 30589;pid=30589
[1427179893] wproc: Registry request: name=Core Worker 30590;pid=30590
[1427179893] wproc: Registry request: name=Core Worker 30592;pid=30592
[1427179893] ndomod: NDOMOD 2.0.0 (02-28-2014) Copyright (c) 2009 Nagios Core Development Team and Community Contributors
[1427179893] ndomod: Could not open data sink!  I'll keep trying, but some output may get lost...
[1427179893] ndomod registered for process data
[1427179893] ndomod registered for timed event data
[1427179893] ndomod registered for log data'
[1427179893] ndomod registered for system command data'
[1427179893] ndomod registered for event handler data'
[1427179893] ndomod registered for notification data'
[1427179893] ndomod registered for service check data'
[1427179893] ndomod registered for host check data'
[1427179893] ndomod registered for comment data'
[1427179893] ndomod registered for downtime data'
[1427179893] ndomod registered for flapping data'
[1427179893] ndomod registered for program status data'
[1427179893] ndomod registered for host status data'
[1427179893] ndomod registered for service status data'
[1427179893] ndomod registered for adaptive program data'
[1427179893] ndomod registered for adaptive host data'
[1427179893] ndomod registered for adaptive service data'
[1427179893] ndomod registered for external command data'
[1427179893] ndomod registered for aggregated status data'
[1427179893] ndomod registered for retention data'
[1427179893] ndomod registered for contact data'
[1427179893] ndomod registered for contact notification data'
[1427179893] ndomod registered for acknowledgement data'
[1427179893] ndomod registered for state change data'
[1427179893] ndomod registered for contact status data'
[1427179893] ndomod registered for adaptive contact data'
[1427179893] Event broker module '/usr/local/nagios/bin/ndomod-4x.o' initialized successfully.
[1427179893] Successfully launched command file worker with pid 30593

[jdalrymple]

Code: Select all

grep socket_name /usr/local/nagios/etc/ndo2db.cfg

ls -l the stuff after the equal sign (probably /usr/local/nagios/var/ndo.sock)

Code: Select all

[jdalrymple@localhost etc]$ ls -l /usr/local/nagios/var/ndo.sock
srwxr-xr-x. 1 nagios nagios 0 Mar 20 07:58 /usr/local/nagios/var/ndo.sock

[kluenni]

Code: Select all

root@Monitoring:~# grep socket_name /usr/local/nagios/etc/ndo2db.cfg
socket_name=/usr/local/nagios/var/ndo.sock

Code: Select all

srwxr-xr-x 1 nagios nagios 0 Mar 24 07:50 /usr/local/nagios/var/ndo.sock

[ssax]

Please post the output of the following:

Code: Select all

ls -l /usr/local/nagios/bin/*ndo*
ls -l /usr/local/nagios/etc/ndo*

[kluenni]

Code: Select all

root@Monitoring:~# ls -l /usr/local/nagios/bin/*ndo*
-rwxrwxr-- 1 nagios nagios  50573 Mar 24 07:47 /usr/local/nagios/bin/log2ndo
-rwxr-xr-x 1 nagios nagios 332560 Mar 24 07:47 /usr/local/nagios/bin/ndo2db
-rwxr-xr-x 1 nagios nagios 194091 Mar 23 09:38 /usr/local/nagios/bin/ndomod-4x.o
-rwxr-xr-x 1 nagios nagios 194091 Mar 24 07:47 /usr/local/nagios/bin/ndomod.o

Code: Select all

root@Monitoring:~# ls -l /usr/local/nagios/etc/ndo*
-rwxrw-rw- 1 nagios nagios 4827 Mar 24 07:50 /usr/local/nagios/etc/ndo2db.cfg
-rwxrw-rw- 1 nagios nagios 5112 Mar 23 13:23 /usr/local/nagios/etc/ndomod.cfg

[tgriep]

Could you post the contents of these 2 files so we can review them?

Code: Select all

/usr/local/nagios/etc/ndo2db.cfg
/usr/local/nagios/etc/ndomod.cfg

Can you run this command on the Nagios server to see if the ndo2db service is running?

Code: Select all

service ndo2db status