Re: How to add report in Dashboards

[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.

[lmiltchev]

Run the following command and show us the output:

Code: Select all

tail -50 /var/log/mysqld.log

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

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

[plataformamc3]

Event log reports is already working. You were right, we just had to wait.
Thank you so much for your advices.

[slansing]

How is everything looking now?

[plataformamc3]

Hi, all is working ok now.
Thank you again.