Page 1 of 2
Reports display issue
Posted: Fri Feb 12, 2021 12:34 pm
by Bala.Mutyam
Hi,
It seems to be there is an issue with the reporting and we email a report nothing reporting in charts and just Add this to a dashboard message. Please see attached example email reports and not display. How to fix the display?
Re: Reports display issue
Posted: Mon Feb 15, 2021 11:07 am
by dchurch
- Did anything with your configuration change recently?
- Did anything surrounding how the component is drawn change recently?
If you PM me a system profile I can diagnose further. Get one by going to Admin (top menu) => System Profile (in the left menu), then clicking the blue button.
If you're unable to generate the the profile through the web interface, please try generating it from the command line by running these commands as root:
Code: Select all
rm -rf /usr/local/nagiosxi/var/components/profile*
/usr/local/nagiosxi/scripts/components/getprofile.sh SUPPORT
Then send me the resulting
/usr/local/nagiosxi/var/components/profile.zip file.
If the profile script fails, please include the ENTIRE output.
Re: Reports display issue
Posted: Wed Feb 17, 2021 6:54 am
by Bala.Mutyam
@dchurch: Hi,
Did anything with your configuration change recently?
No
Did anything surrounding how the component is drawn change recently?
No
PM'd latest systems profile.
Re: Reports display issue
Posted: Wed Feb 17, 2021 4:16 pm
by dchurch
Does this happen when you load up the SLA report in a browser, or only when you download a PDF?
Re: Reports display issue
Posted: Wed Feb 17, 2021 4:33 pm
by dchurch
The request may be timing out due to a lag. I'd suggest making a backup of php.ini then using
this guide to fiddle with your PHP settings, specifically increasing
max_execution_time to 5 minutes:
Also, you have some crashed tables, try running the database repair script, and let me know if that is successful. Run the following as root from the terminal.
Code: Select all
/usr/local/nagiosxi/scripts/repair_databases.sh
See here for complete instructions:
run the database repair
Re: Reports display issue
Posted: Thu Feb 18, 2021 9:53 am
by Bala.Mutyam
Hi @dchurch,
Thanks for the output.
I have changed max_execution_time to 300 in php.ini file and restarted apache, Also ran database repair successfully but no luck still missing graphs on the report.
Do i need to do/restart anything else?
Please see attachments for latest reports samples.
Re: Reports display issue
Posted: Thu Feb 18, 2021 2:42 pm
by dchurch
Try increasing the "Default Delay" to something like 1500.
It's under Admin (top menu) => Performance Settings (left menu) => PDF/JPG exporting (tab).
If that doesn't work, one other thing you could try if that doesn't work is to update
/usr/local/nagiosxi/html/config.inc.php, find this code:
Code: Select all
"ndoutils" => array(
"dbtype" => 'mysql',
"dbserver" => 'localhost',
"user" => 'ndoutils',
"db" => 'nagios',
"charset" => "latin1",
Change just the last line to:
Re: Reports display issue
Posted: Fri Feb 19, 2021 4:32 am
by Bala.Mutyam
Hi @dchurch,
Thanks for the update. I have tried both the options, still no luck?
Thanks
Bala
Re: Reports display issue
Posted: Fri Feb 19, 2021 4:43 pm
by dchurch
Is your server's certificate the correct one for the FQDN? This can cause issues when rendering PDF's since part of it has to make an API call to grab graph data.
What's the output for the following command?
Code: Select all
openssl s_client -connect <YOUR NAGIOS XI SERVER IP ADDRESS>:443 < /dev/null
Re: Reports display issue
Posted: Wed Feb 24, 2021 9:51 am
by Bala.Mutyam
Hi @dchurch,
We haven't got proper ssl cert yet and currently using self signed associated with ip.
Code: Select all
openssl s_client -connect <YOUR NAGIOS XI SERVER IP ADDRESS>:443 < /dev/null
Attached the output.