Page 1 of 1
load nagios.log data into existing or new database
Posted: Mon Mar 24, 2014 9:16 pm
by kendallchenoweth
Can you recommend a method to bulk upload some large number of nagios core log files into a new or existing mysql database in order to allow for reporting on nagios events? We converting our Nagios Core to Nagios XI, but want to retrieve the Nagios Core history. Thanks in advance
Re: load nagios.log data into existing or new database
Posted: Tue Mar 25, 2014 10:12 am
by abrist
You could look at using log2ndo to convert the log files and them save them in the db (this assumes that you are using ndoutils). Do note that is will not be very useful unless your objects are named *exactly* the same, otherwise most of the log content will just take up space in the db and will not be able to be queried from the nagios interface.
Re: load nagios.log data into existing or new database
Posted: Tue Mar 25, 2014 10:30 am
by kendallchenoweth
But we could still query the database directly? Could I use this tool to populate a new individual database used as a historical reporting database since some objects will have different names in the XI upgrade/refactoring from the Core environment. Then I could maintain a clean environment going forward in the Nagios XI environment...
Re: load nagios.log data into existing or new database
Posted: Tue Mar 25, 2014 3:30 pm
by abrist
kendallchenoweth wrote:But we could still query the database directly?
Yep, you would need to write the sql queries, and would not be able to visualize the data in the frontend, but it should work.
Re: load nagios.log data into existing or new database
Posted: Wed Mar 26, 2014 3:36 pm
by kendallchenoweth
Thanks. You can consider this question closed.