Page 1 of 1
Home Dashboard not loading after upgrade
Posted: Thu Mar 25, 2021 10:19 am
by Matthew.Cary
Since upgrading to 5.8.2, non admin users are clocking on the Home Dashboard.
When a non-admin user opens Nagios the Host Status Summary and the Service Status Summary just give spinning progress wheels for 5-10 min. Admin users don't experience this. (I've uploaded a screen shot)
Any thoughts?
Re: Home Dashboard not loading after upgrade
Posted: Fri Mar 26, 2021 10:17 am
by benjaminsmith
Hi
@Matthew.Cary,
Can you post a screenshot of the user settings? I'll try to replicate this on my systems. Do you have an idea of how many users are logged in at a time?
user-perms.png
There could be an issue with the database calls as the system has to check each user's permissions before displaying the data. Try running the repair script and let me know if you see any improvement.
Code: Select all
/usr/local/nagiosxi/scripts/repair_databases.sh
Also, let's optimize the PHP settings as well and let me know if there's any improvement.
Nagios XI - Optimizing The PHP Settings File
Lastly, please send over a system profile for us to review. 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
Re: Home Dashboard not loading after upgrade
Posted: Mon Mar 29, 2021 3:38 pm
by Matthew.Cary
It appears that users with more rights don't have the issue.
The user who reported the problem is a DBA who only sees a subset of our hosts and doesn't have many rights in Nagios.
I'll try running the cleanup scripts and see if they help.
Profile is attached
Moderator's Note: The profile has been shared with the support team but has been removed from the public forum.
Re: Home Dashboard not loading after upgrade
Posted: Tue Mar 30, 2021 10:17 am
by benjaminsmith
Hi,
Thanks for sending over the profile. I believe we have identified the issue here. Please
take a backup, then run the following command and let me know if the issue is resolved.
Code: Select all
mysql -h 127.0.0.1 -uroot -pnagiosxi nagios -e "update nagios_dbversion set version = '2.1.3';"
Regards,
Benjamin
Re: Home Dashboard not loading after upgrade
Posted: Wed Mar 31, 2021 1:14 pm
by spatkin
I was experiencing the same issue and can confirm that the code Benjamin posted works!
Thank you!
Re: Home Dashboard not loading after upgrade
Posted: Thu Apr 01, 2021 10:11 am
by benjaminsmith
Hi
@spatkin, Great, glad that worked for you.
Re: Home Dashboard not loading after upgrade
Posted: Thu Apr 01, 2021 12:21 pm
by Matthew.Cary
This does appear to have fixed my issue!
Thank you.
Re: Home Dashboard not loading after upgrade
Posted: Thu Apr 01, 2021 12:28 pm
by benjaminsmith
This does appear to have fixed my issue!
Excellent! Thanks for the update. We'll go ahead and close this topic.