Nagios XI 5.7 update problem

[jovill13]

Hi,
I recently upgrade Nagios XI from 5.6.14 to 5.7.0. on a Red Hat 7.7

But now only admin users and the ones with "Can see all hosts and services" priviledge can see the hosts and services.

Any other user can see the hosts only if they log in to nagios core (url ip/nagios ), but not in nagios xi (ip/nagiosxi), also they get notification alarms normally

The upgrade initially failed because a OS file was needed (git I think), I manage to install those files and start a manual upgrade with no problems, except for the one explained above.

After that I loaded the previous backup and users could see all host normally, but if I upgrade, again they can't.

The upgrade file mention to re-activate the license but, the license appears activated, so I can't do that part.

Right now I'm with the 5.7 version but no one can see hosts, Im hoping there is an easy fix for this situation.

Thanks in advance

[lmiltchev]

Can you run the following command and show the output?

Code: Select all

ls -la /usr/local/nagiosxi/var/keys

Also, upload the /tmp/nagiosxi/upgrade.log and /usr/local/nagios/var/nagios.log on the forum.

[jovill13]

Thanks for the fast reply:

Code: Select all

ls -la /usr/local/nagiosxi/var/keys
total 8
drwxrwxr-x 2 nagios nagios   20 Jan 29 11:17 .
drwxrwxr-x 7 nagios nagios 4096 Jun  9 08:48 ..
-rw-r----- 1 nagios nagios   33 Jan 29 11:17 xi.key

I attached the logs you asked.

Also, I saw a recent post with I think is the same problem and I'm getting this on /var/log/httpd/error_log:

Code: Select all

[Tue Jun 09 08:54:10.429846 2020] [:error] [pid 21431] [client 10.129.32.12:64619] PHP Notice:  Undefined index: service_object_id in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 0, referer: http://172.31.54.222/nagiosxi/includes/components/xicore/status.php?show=servicegroups&servicegroup=all&style=summary
[Tue Jun 09 08:54:10.429865 2020] [:error] [pid 21431] [client 10.129.32.12:64619] PHP Notice:  Undefined index: service_object_id in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 0, referer: http://172.31.54.222/nagiosxi/includes/components/xicore/status.php?show=servicegroups&servicegroup=all&style=summary
[Tue Jun 09 08:54:10.429883 2020] [:error] [pid 21431] [client 10.129.32.12:64619] PHP Notice:  Undefined index: service_object_id in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 0, referer: http://172.31.54.222/nagiosxi/includes/components/xicore/status.php?show=servicegroups&servicegroup=all&style=summary
[Tue Jun 09 08:54:10.429901 2020] [:error] [pid 21431] [client 10.129.32.12:64619] PHP Notice:  Undefined index: service_object_id in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 0, referer: http://172.31.54.222/nagiosxi/includes/components/xicore/status.php?show=servicegroups&servicegroup=all&style=summary
[Tue Jun 09 08:54:10.429919 2020] [:error] [pid 21431] [client 10.129.32.12:64619] PHP Notice:  Undefined index: service_object_id in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 0, referer: http://172.31.54.222/nagiosxi/includes/components/xicore/status.php?show=servicegroups&servicegroup=all&style=summary
[Tue Jun 09 08:54:10.429937 2020] [:error] [pid 21431] [client 10.129.32.12:64619] PHP Notice:  Undefined index: service_object_id in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 0, referer: http://172.31.54.222/nagiosxi/includes/components/xicore/status.php?show=servicegroups&servicegroup=all&style=summary
[Tue Jun 09 08:54:10.429955 2020] [:error] [pid 21431] [client 10.129.32.12:64619] PHP Notice:  Undefined index: service_object_id in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 0, referer: http://172.31.54.222/nagiosxi/includes/components/xicore/status.php?show=servicegroups&servicegroup=all&style=summary
[Tue Jun 09 08:54:10.429973 2020] [:error] [pid 21431] [client 10.129.32.12:64619] PHP Notice:  Undefined index: service_object_id in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 0, referer: http://172.31.54.222/nagiosxi/includes/components/xicore/status.php?show=servicegroups&servicegroup=all&style=summary
[Tue Jun 09 08:54:10.429992 2020] [:error] [pid 21431] [client 10.129.32.12:64619] PHP Notice:  Undefined index: service_object_id in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 0, referer: http://172.31.54.222/nagiosxi/includes/components/xicore/status.php?show=servicegroups&servicegroup=all&style=summary
[Tue Jun 09 08:54:10.430009 2020] [:error] [pid 21431] [client 10.129.32.12:64619] PHP Notice:  Undefined index: service_object_id in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 0, referer: http://172.31.54.222/nagiosxi/includes/components/xicore/status.php?show=servicegroups&servicegroup=all&style=summary

[lmiltchev]

The type of errors that you see in the apache error log usually indicate some NDO issues. Strangely enough, there is nothing "out of ordinary" in the nagios.log.

Can you PM me your profile (profile.zip)?

Admin > System Profile > Download Profile

[jovill13]

I sent you the profile in a PM.

It's almost the same issue of this post, explained different (maybe it helps): https://support.nagios.com/forum/viewto ... 16&t=58922

Could it be an OS thing? I also got Red Hat 7

[lmiltchev]

One of mods that we make for speed improvements in the backend introduced a new bug that we didn't catch.

In order to fix it immediately, download the file below:

queries.inc.php.zip

unzip it and drop it in the "/usr/local/nagiosxi/html/db" directory, replacing the original "queries.inc.php" file.

Note: It may take a several minutes before non-admin users are able to see hosts/services.

Let us know if this helped.

[jovill13]

Yes!!!!

That fix the problem. Thank you very much!!

[lmiltchev]

I am glad I could help!

I will be closing this topic now. If you have any further questions/issues, please start a new thread. Thank you!