ndoutils: problem importing historical data to DB with log2n
Posted: Tue Nov 05, 2013 4:25 am
Hello,
I am trying to import the nagios historical data from the logs into a DB using ndoutils, but something is amiss since the only table that is getting populated is nagios_logentries.
This is the command that I am using to import:
And this is the configuration in my ndmod.cfg:
And the configuration in my ndo2db.cfg:
Both nagios and the DB are in the same computer (using centos 5). I tried enabling debug but it did not log any error messages: not in the ndo2db.debug nor in the messages log. I also checked that data_processing_options=-1 is set, and nd2dbo is running: at least /etc/init.d/ndo2db status returns ndo2db (pid xxx) is running .... New data is getting inserted in the DB (for example the current status information when I modify the host configuration files to add new machines), and to sum it up everything with ndo is working perfectly except for the fact that I can figure out how to import the historic data.
As I said after every import a log file the number of entries in the table nagios_logentries increases, but the rest of the tables remain unaltered: therefore I got no information on downtimes, notifications, etc.
Please, any idea of what I did wrong and how could I fix it?
I am trying to import the nagios historical data from the logs into a DB using ndoutils, but something is amiss since the only table that is getting populated is nagios_logentries.
This is the command that I am using to import:
Code: Select all
log2ndo /var/log/nagios/archives/nagios-09-24-2013-00.log -d 127.0.0.1 -i "default" -t tcp -p 5668
Code: Select all
instance_name=default
output_type=tcpsocket
output=127.0.0.1
tcp_port=5668
output_buffer_items=5000
buffer_file=/var/log/nagios/ndomod.tmp
file_rotation_interval=14400
file_rotation_timeout=60
reconnect_interval=15
reconnect_warning_interval=900
data_processing_options=-1
config_output_options=3
Code: Select all
ndo2db_user=nagios
ndo2db_group=nagios
socket_type=tcp
socket_name=/var/log/nagios/ndo.sock
tcp_port=5668
db_servertype=mysql
db_host=localhost
db_name=nagios
db_port=3306
db_prefix=nagios_
db_user=root
max_timedevents_age=1440
max_systemcommands_age=1440
max_servicechecks_age=1440
max_hostchecks_age=1440
max_eventhandlers_age=1440
As I said after every import a log file the number of entries in the table nagios_logentries increases, but the rest of the tables remain unaltered: therefore I got no information on downtimes, notifications, etc.
Please, any idea of what I did wrong and how could I fix it?