Reports display issue

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Bala.Mutyam
Posts: 97
Joined: Wed Apr 29, 2020 12:18 pm

Reports display issue

Post 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?
You do not have the required permissions to view the files attached to this post.
dchurch
Posts: 858
Joined: Wed Oct 07, 2020 12:46 pm
Location: Yo mama

Re: Reports display issue

Post 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.
If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.

Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Bala.Mutyam
Posts: 97
Joined: Wed Apr 29, 2020 12:18 pm

Re: Reports display issue

Post 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.
dchurch
Posts: 858
Joined: Wed Oct 07, 2020 12:46 pm
Location: Yo mama

Re: Reports display issue

Post by dchurch »

Does this happen when you load up the SLA report in a browser, or only when you download a PDF?
If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.

Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
dchurch
Posts: 858
Joined: Wed Oct 07, 2020 12:46 pm
Location: Yo mama

Re: Reports display issue

Post 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:

Code: Select all

max_execution_time = 300
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
If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.

Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Bala.Mutyam
Posts: 97
Joined: Wed Apr 29, 2020 12:18 pm

Re: Reports display issue

Post 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.
You do not have the required permissions to view the files attached to this post.
dchurch
Posts: 858
Joined: Wed Oct 07, 2020 12:46 pm
Location: Yo mama

Re: Reports display issue

Post 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:

Code: Select all

        "charset" => "utf8",
If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.

Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Bala.Mutyam
Posts: 97
Joined: Wed Apr 29, 2020 12:18 pm

Re: Reports display issue

Post by Bala.Mutyam »

Hi @dchurch,

Thanks for the update. I have tried both the options, still no luck?

Thanks
Bala
dchurch
Posts: 858
Joined: Wed Oct 07, 2020 12:46 pm
Location: Yo mama

Re: Reports display issue

Post 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
If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.

Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Bala.Mutyam
Posts: 97
Joined: Wed Apr 29, 2020 12:18 pm

Re: Reports display issue

Post 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.
You do not have the required permissions to view the files attached to this post.