Page 2 of 2

Re: Report PDF is showing 0 kbits

Posted: Tue Sep 03, 2013 3:18 am
by plataformamc3
No I don't, I'm accesing via http. Could it be that the event log report are not withdrawing data from database? I don't know how to check it.

Re: Report PDF is showing 0 kbits

Posted: Tue Sep 03, 2013 2:01 pm
by lmiltchev
Run the following command and show us the output:

Code: Select all

tail -50 /var/log/mysqld.log

Re: Report PDF is showing 0 kbits

Posted: Wed Sep 04, 2013 3:43 am
by plataformamc3
Below is the result after running the tail command:

130904 9:50:02 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_logentries' is marked as crashed and last (automatic?) repair failed

Surfing the internet we have found a nagios document to repair the database (Nagios XI- Repairing the database). After following the document procedure thoroughly, tail command shows no error but the problem with event log report persists.
The most strange thing is that event log report works fine in legacy mode.
Are both, current and legacy mode, using the same database?

Re: Report PDF is showing 0 kbits

Posted: Wed Sep 04, 2013 1:09 pm
by lmiltchev
The info for the legacy reports is pulled from the logs. The info for the XI Event Log reports is pulled from the database. If you had crashed tables, it is possible you are not going to see anything for the same (Last24 Hours) period. Wait until some new data comes in, and try again later. You are sure that there are no more errors in the mysqld.log, right?

Re: Report PDF is showing 0 kbits

Posted: Thu Sep 05, 2013 5:21 am
by plataformamc3
Event log reports is already working. You were right, we just had to wait.
Thank you so much for your advices.

Re: Report PDF is showing 0 kbits

Posted: Thu Sep 05, 2013 9:31 am
by slansing
How is everything looking now?

Re: Report PDF is showing 0 kbits

Posted: Mon Sep 09, 2013 6:04 am
by plataformamc3
Hi, all is working ok now.
Thank you again.