Nagios Support Forum

Hi Team,
We are observing reports with no data while dowloading PDF reports from Nagios xi console but report shows data in the console.
Please find the atatched files for addtional details on this regard.

Nagios version:
Nagios xi 5.6.10
OS Version:
Red Hat Enterprise Linux Server release 7.6 (Maipo)

Thank you.
Best Regards,
Jagan

HI Jagan,

Appreciate the attachments and system details. Since you're getting partial information here, I think you may be hitting some PHP limits, and it's not completing correctly.

Please follow the instructions in the knowledgebase article below to optimize the PHP settings on the server, and try running the report again. Be sure to re-start Apache after making the changes.

Nagios xi - Optimizing The PHP Settings File

If the error persists, let's get a tail of the Apache log while you running the report an post the full output to the ticket.

Hi Benjamin,
The reports can be generated and downloaded by local admin user which was created when nagios xi setup was done.
But now we are facing the mentioned issue with all new users (for any new user either local or AD user) created in Nagios xi.
Not sure the issue is related to optimization of PHP settings.

Error message details from Nagios instance where nothing is being monitored right now but the mentioned issue is being observed for the same: :
# tail /var/log/httpd/*rror_log
==> /var/log/httpd/error_log <==
QFontEngine: Glyph neither outline nor bitmap format=0
load glyph failed err=24 face=0x3784100, glyph=0
QFontEngine: Glyph neither outline nor bitmap format=0
load glyph failed err=24 face=0x3784100, glyph=0
QFontEngine: Glyph neither outline nor bitmap format=0
Counting pages (2/6)
Resolving links (4/6)
Loading headers and footers (5/6)
Printing pages (6/6)
Done

==> /var/log/httpd/ssl_error_log <==
[Wed Sep 16 21:30:19.068324 2020] [:error] [pid 54525] [client 10.148.65.112:64006] PHP Warning: array_multisort(): Argument #1 is expected to be an array or a sort flag in /apps/nagiosxi/html/includes/utils-dashboards.inc.php on line 0, referer: https://nagprdappls006.sg.singtelgroup. ... /login.php
[Wed Sep 16 21:30:19.068336 2020] [:error] [pid 54525] [client 10.148.65.112:64006] PHP Notice: Undefined variable: home in /apps/nagiosxi/html/includes/utils-dashboards.inc.php on line 0, referer: https://nagprdappls006.sg.singtelgroup. ... /login.php
[Wed Sep 16 21:30:19.068501 2020] [:error] [pid 54525] [client 10.148.65.112:64006] PHP Notice: Undefined variable: home_id in /apps/nagiosxi/html/includes/utils-dashboards.inc.php on line 0, referer: https://nagprdappls006.sg.singtelgroup. ... /login.php
[Wed Sep 16 21:30:19.068517 2020] [:error] [pid 54525] [client 10.148.65.112:64006] PHP Warning: array_multisort(): Argument #1 is expected to be an array or a sort flag in /apps/nagiosxi/html/includes/utils-dashboards.inc.php on line 0, referer: https://nagprdappls006.sg.singtelgroup. ... /login.php
[Wed Sep 16 21:30:19.068526 2020] [:error] [pid 54525] [client 10.148.65.112:64006] PHP Notice: Undefined variable: home in /apps/nagiosxi/html/includes/utils-dashboards.inc.php on line 0, referer: https://nagprdappls006.sg.singtelgroup. ... /login.php
[Wed Sep 16 21:30:19.069755 2020] [:error] [pid 54525] [client 10.148.65.112:64006] PHP Warning: array_multisort(): Argument #1 is expected to be an array or a sort flag in /apps/nagiosxi/html/includes/utils-dashboards.inc.php on line 0, referer: https://nagprdappls006.sg.singtelgroup. ... /login.php
[Wed Sep 16 21:30:19.069961 2020] [:error] [pid 54525] [client 10.148.65.112:64006] PHP Warning: array_multisort(): Argument #1 is expected to be an array or a sort flag in /apps/nagiosxi/html/includes/utils-dashboards.inc.php on line 0, referer: https://nagprdappls006.sg.singtelgroup. ... /login.php
[Thu Sep 17 03:12:02.061972 2020] [ssl:warn] [pid 9323] AH01906: RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Thu Sep 17 03:12:02.062012 2020] [ssl:warn] [pid 9323] AH01909: RSA certificate configured for nagprdappls006.sg.singtelgroup.net:443 does NOT include an ID which matches the server name
[Thu Sep 17 16:52:04.436893 2020] [:error] [pid 116347] [client 10.148.65.112:65369] PHP Notice: Undefined variable: enable_notifications in /apps/nagiosxi/html/admin/users.php on line 928, referer: https://nagprdappls006.sg.singtelgroup. ... /users.php

Thank you.

Best Regards,
Jagan

HI Jagan,

Ok, making some progress anyhow. I think this is still related to the PHP settings, but since it takes the application longer to check user permissions it might still be getting cut short before it's able to finish the report.

Try to increase to the following values, restart Apache and test once more. If that doesn't resolve it. Please PM your system profile and I'll take a look at the logs. Thanks, Benjamin

To send us your system profile.
Login to the Nagios xi GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and share in a private message or upload it to the post/ticket, and then reply to this post to bring it up in the queue.

Hi Benjimin,
The issue still persists event after following settings put in place and Apache restart done (with systemctl restart httpd.service).
Please find the attached system profile.

max_execution_time = 120
max_input_time = 240
max_input_vars = 50000
memory_limit = 2048M

Thank you.

Best Regards,
Jagan

Moderator's Note: The profile has been shared with the support team but has been removed from the public forum.

Hi Jagan,

Thanks for the profile. The database log is showing crashed tables, so it might be having an issue pulling the necessary data. Please log into the terminal as root and run the database repair script and then test the reports again. If you still having the issue, can you post a screenshot of the user permission settings? Benjamin

Hi Benjamin,
Repair database is done but the issue is still persisting.
Please find the attached screenshot for permission settings.

Thank you.

Best Regards,
Jagan

Hi Benjamin,
Pie-chart in the report is causing issue while downloading the PDF report.
I've tried to download pie-chart from the generated report and that is giving following message where as file system usage with line chart is downloaded successfully from the same report.

"The webpage at https://export.highcharts.com/ might be temporarily down or it may have moved permanently to a new web address."

Refer attached file more details on this regard.

Thank you.

Best Regards,
Jagan

HI Jagan,

I just tested that user permission and was not able to repeat it, so I don't believe there's a bug related to that. However, I believe some of the necessary javascript requests are not loading or timing out.

This may be hard to troubleshoot over the forum, so I would recommend opening a support ticket and reference this post.

https://support.nagios.com/tickets/

In the meantime, please open up the developer tools in Chrome, try downloading the report and let me know if you see any errors. You should see a return code of 200 for successful HTTP requests. Attached a screenshot of any errors you see. Thanks, Benjamin

Locking thread, ticket received, we will continue support through the ticket.

Thank you!