NDO2DB Utils
Posted: Mon Jul 18, 2016 7:47 am
Hi, I've installed MYSQL and NDOUTILS on Centos and I'm trying to use NDO2DB. I have set it all up as per the instructions.
If I do a "watch ipcs -q" I can see that messages keep increasing rapidly:
key msqid owner perms used-bytes messages
0x5f000002 458752 nagios 600 17762304 17346
But the MYSQL is not populating any tables and therefore the queue never decreases.
The kernel settings are:
kernel.msgmnb = 262144000
kernel.msgmax = 262144000
I imagine once I hit the limit I'll start getting errors in my messages log.
I've checked:
- MYSQL has a database called "nagios" and a user/password of nagios that has the correct permissions to write to the various nagios_tables.
- On starting NDO2DB and Nagios I've checked the nagios.log and recieve no errors:
- I've also put debug mode on "2" in my config.
- I've checked /var/log/messages and recieve no messages.
Any ideas on why my mysql wouldn't be populating?
If I do a "watch ipcs -q" I can see that messages keep increasing rapidly:
key msqid owner perms used-bytes messages
0x5f000002 458752 nagios 600 17762304 17346
But the MYSQL is not populating any tables and therefore the queue never decreases.
The kernel settings are:
kernel.msgmnb = 262144000
kernel.msgmax = 262144000
I imagine once I hit the limit I'll start getting errors in my messages log.
I've checked:
- MYSQL has a database called "nagios" and a user/password of nagios that has the correct permissions to write to the various nagios_tables.
- On starting NDO2DB and Nagios I've checked the nagios.log and recieve no errors:
Code: Select all
[1468844514] ndomod: NDOMOD 2.0.0 (02-28-2014) Copyright (c) 2009 Nagios Core Development Team and Community Contributors
[1468844514] ndomod: Successfully connected to data sink. 141 queued items to flush.
[1468844514] ndomod: Successfully flushed 141 queued items to data sink.
[1468844514] ndomod registered for process data
[1468844514] ndomod registered for timed event data
[1468844514] ndomod registered for log data'
[1468844514] ndomod registered for system command data'
[1468844514] ndomod registered for event handler data'
[1468844514] ndomod registered for notification data'
[1468844514] ndomod registered for service check data'
[1468844514] ndomod registered for host check data'
[1468844514] ndomod registered for comment data'
[1468844514] ndomod registered for downtime data'
[1468844514] ndomod registered for flapping data'
[1468844514] ndomod registered for program status data'
[1468844514] ndomod registered for host status data'
[1468844514] ndomod registered for service status data'
[1468844514] ndomod registered for adaptive program data'
[1468844514] ndomod registered for adaptive host data'
[1468844514] ndomod registered for adaptive service data'
[1468844514] ndomod registered for external command data'
[1468844514] ndomod registered for aggregated status data'
[1468844514] ndomod registered for retention data'
[1468844514] ndomod registered for contact data'
[1468844514] ndomod registered for contact notification data'
[1468844514] ndomod registered for acknowledgement data'
[1468844514] ndomod registered for contact status data'
[1468844514] ndomod registered for adaptive contact data'
[1468844514] Event broker module '/usr/local/nagios/bin/ndomod.o' initialized successfully.- I've checked /var/log/messages and recieve no messages.
Any ideas on why my mysql wouldn't be populating?