NDO2DB Utils

[mlawton1986]

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:

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 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?

[mlawton1986]

Hello,
I have since re-installed it all and it now works!

Is there any way to back date the MYSQL database so it contains all historical data (that is in the perf rrd files)?

Thanks.

[tgriep]

The closest thing is the log2ndo application.
It sends the contents of an archived Nagios log file to STDOUT, a TCP socket, or a Unix domain socket in a format that is understood by the NDO2DB daemon.
It should be part of the ndoutils package.

You can search the exchange site to see if there is something there to do what you want.
https://exchange.nagios.org/