Slow dashboard/pages loading for users ....

[ITOMB_IMT]

Good Morning,

i have upgraded nagios XI to V 5.7.3 this weekened, since then i see slowness in home dashboard loading and pages/tabs for users while admins are good.

when i check httpd logs i see the following errors
tail -F /var/log/httpd/error_log /var/log/httpd/ssl_error_log
[Mon Oct 19 03:34:50.889019 2020] [core:error] [pid 15210] [client ip_address:46218] AH00126: Invalid URI in request GET ..\\..\\..\\..\\..\\..\\winnt\\win.ini HTTP/1.1
[Mon Oct 19 03:34:54.759071 2020] [core:error] [pid 15210] [client ip_address:48966] AH00126: Invalid URI in request GET c:\\boot.ini HTTP/1.1
[Mon Oct 19 03:35:09.248924 2020] [core:error] [pid 15210] [client ip_address:56278] AH00126: Invalid URI in request GET /%2e%2e/%2e%2e/%2e%2e/%2e%2e/%2e%2e/%2e%2e/%2e%2e/etc/passwd HTTP/1.1
[Mon Oct 19 03:35:17.393579 2020] [core:error] [pid 14854] [client ip_address:60290] AH00126: Invalid URI in request GET /././.. HTTP/1.1
[Mon Oct 19 03:35:17.423433 2020] [core:error] [pid 14850] [client ip_address:60304] AH00126: Invalid URI in request GET ././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././././../../../../../../../../ HTTP/1.1
[Mon Oct 19 09:21:55.613326 2020] [mpm_prefork:notice] [pid 16377] AH00170: caught SIGWINCH, shutting down gracefully
[Mon Oct 19 09:23:25.833014 2020] [suexec:notice] [pid 6433] AH01232: suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Mon Oct 19 09:23:25.870556 2020] [lbmethod_heartbeat:notice] [pid 6433] AH02282: No slotmem from mod_heartmonitor
[Mon Oct 19 09:23:25.935819 2020] [mpm_prefork:notice] [pid 6433] AH00163: Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.2k-fips PHP/5.4.16 configured -- resuming normal operations
[Mon Oct 19 09:23:25.935856 2020] [core:notice] [pid 6433] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'


==> /var/log/httpd/ssl_error_log <==
[Mon Oct 19 08:20:42.075215 2020] [:error] [pid 6427] [client ip_address:55744] PHP Notice: Undefined variable: total_services in /usr/local/nagiosxi/html/includes/components/xicore/ajaxhelpers-tac.inc.php on line 177, referer: https://GTM_LOGIN/nagiosxi/includes/components/xicore/tac.php
[Mon Oct 19 08:20:42.075223 2020] [:error] [pid 6427] [client ip_address:55744] PHP Notice: Undefined variable: total_services in /usr/local/nagiosxi/html/includes/components/xicore/ajaxhelpers-tac.inc.php on line 180, referer: https://GTM_LOGIN/nagiosxi/includes/components/xicore/tac.php
[Mon Oct 19 08:21:12.258679 2020] [:error] [pid 9919] [client ip_address:55750] PHP Notice: Undefined variable: total_notok in /usr/local/nagiosxi/html/includes/components/xicore/ajaxhelpers-tac.inc.php on line 177, referer: https://GTM_LOGIN/nagiosxi/includes/components/xicore/tac.php
[Mon Oct 19 08:21:12.258720 2020] [:error] [pid 9919] [client ip_address:55750] PHP Notice: Undefined variable: total_services in /usr/local/nagiosxi/html/includes/components/xicore/ajaxhelpers-tac.inc.php on line 177, referer: https://GTM_LOGIN/nagiosxi/includes/components/xicore/tac.php
[Mon Oct 19 08:21:12.258728 2020] [:error] [pid 9919] [client ip_address:55750] PHP Notice: Undefined variable: total_services in /usr/local/nagiosxi/html/includes/components/xicore/ajaxhelpers-tac.inc.php on line 180, referer: https://GTM_LOGIN/nagiosxi/includes/components/xicore/tac.php
[Mon Oct 19 08:27:42.760367 2020] [:error] [pid 13748] [client ip_address:56232] Connection timed out after 15001 milliseconds, referer: https://GTM_LOGIN/nagiosxi/admin/?xiwindow=updates.php
[Mon Oct 19 08:30:21.030123 2020] [:error] [pid 26272] [client ip_address:56360] PHP Notice: Undefined variable: total_notok in /usr/local/nagiosxi/html/includes/components/xicore/ajaxhelpers-tac.inc.php on line 125, referer: https://GTM_LOGIN/nagiosxi/includes/components/xicore/tac.php
[Mon Oct 19 08:31:21.094753 2020] [:error] [pid 26272] [client ip_address:56360] PHP Notice: Undefined variable: total_notok in /usr/local/nagiosxi/html/includes/components/xicore/ajaxhelpers-tac.inc.php on line 177, referer: https://GTM_LOGIN/nagiosxi/includes/components/xicore/tac.php
[Mon Oct 19 08:31:21.094785 2020] [:error] [pid 26272] [client ip_address:56360] PHP Notice: Undefined variable: total_services in /usr/local/nagiosxi/html/includes/components/xicore/ajaxhelpers-tac.inc.php on line 177, referer: https://GTM_LOGIN/nagiosxi/includes/components/xicore/tac.php
[Mon Oct 19 08:31:21.094792 2020] [:error] [pid 26272] [client ip_address:56360] PHP Notice: Undefined variable: total_services in /usr/local/nagiosxi/html/includes/components/xicore/ajaxhelpers-tac.inc.php on line 180, referer: https://GTM_LOGIN/nagiosxi/includes/components/xicore/tac.php

How can i speed the loading time and clear those errors? please advise.

Thanks

[benjaminsmith]

Hi,

i have upgraded nagios XI to V 5.7.3 this weekened, since then i see slowness in home dashboard loading and pages/tabs for users while admins are good.

Let's get a profile from this system to make sure there are not any database or other issues. Also, can you post a screenshot of the permission settings for the other users to test against?

user-perms.png

In the meantime, I would recommend following the guide to optimize the PHP settings if you haven't done so already. This can really help with GUI performance.
https://support.nagios.com/kb/article/n ... e-611.html

Lastly, the PHP notices are advisory messages and can be safely turned off. For instructions, take a look at the following page:
https://stackoverflow.com/questions/286 ... hp-notices

Regards,
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.

[ITOMB_IMT]

Please see attached screenshot of user profile and i have sent a PM with system profile.

Thanks,

[benjaminsmith]

Hi,

Got the system profile and thanks for the screenshot. I test those settings on my 5.7.3 system here, and while it does take some more time, it should be too much different.

It looks like the database is offloaded. Can you fetch the database log from the remote server as it wasn't included in the profile?

In the meantime, it wouldn't hurt to run the database repair script and let me know if you notice any improvement.

Code: Select all

/usr/local/nagiosxi/scripts/repair_databases.sh

Lastly, did you get a chance to optimize the PHP variables on this system?

Benjamin