Home Dashboard not loading after upgrade

[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?

[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

[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.

[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

[spatkin]

I was experiencing the same issue and can confirm that the code Benjamin posted works!

Thank you!

[benjaminsmith]

Hi @spatkin, Great, glad that worked for you.

[Matthew.Cary]

This does appear to have fixed my issue!

Thank you.

[benjaminsmith]

This does appear to have fixed my issue!

Excellent! Thanks for the update. We'll go ahead and close this topic.