Nagios Support Forum

Support for Nagios products and services
https://support.nagios.com/forum/

All users lost access to own hosts after upgrade to 5.7.0

https://support.nagios.com/forum/viewtopic.php?t=58922

Page 1 of 1

All users lost access to own hosts after upgrade to 5.7.0

Posted: Tue Jun 09, 2020 8:42 am
by dariusz.nalazek
Hello,

After today's upgrade from recent version of Nagios XI to 5.7.0 all users lost access to monitor own hosts/services.
It had happen on all our Nagios servers (CentOS 6, RHEL 7, CentOS 7), seems it's not a matter of OS or particular server.
Monitoring is working OK, "just" the GUI for users is empty.... none of regular users has access to own servers/services.


After a few hours we had to roll back from backup our main monitoring server, dev/test and watchdog server was left for now as 5.7.0


We noticed such entries in log:

Code: Select all

[Tue Jun 09 13:51:31.282329 2020] [:error] [pid 12432] [client 10.204.32.26:54801] PHP Notice:  Undefined index: service_object_id in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 0, referer: https://10.201.85.148/nagiosxi/includes/page-default-splash.php
[Tue Jun 09 13:51:31.282338 2020] [:error] [pid 12432] [client 10.204.32.26:54801] PHP Notice:  Undefined index: service_object_id in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 0, referer: https://10.201.85.148/nagiosxi/includes/page-default-splash.php
[Tue Jun 09 13:51:31.282346 2020] [:error] [pid 12432] [client 10.204.32.26:54801] PHP Notice:  Undefined index: service_object_id in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 0, referer: https://10.201.85.148/nagiosxi/includes/page-default-splash.php
[Tue Jun 09 13:51:31.282355 2020] [:error] [pid 12432] [client 10.204.32.26:54801] PHP Notice:  Undefined index: service_object_id in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 0, referer: https://10.201.85.148/nagiosxi/includes/page-default-splash.php
[Tue Jun 09 13:51:31.282364 2020] [:error] [pid 12432] [client 10.204.32.26:54801] PHP Notice:  Undefined index: service_object_id in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 0, referer: https://10.201.85.148/nagiosxi/includes/page-default-splash.php
[Tue Jun 09 13:51:31.282373 2020] [:error] [pid 12432] [client 10.204.32.26:54801] PHP Notice:  Undefined index: service_object_id in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 0, referer: https://10.201.85.148/nagiosxi/includes/page-default-splash.php
[Tue Jun 09 13:51:31.282381 2020] [:error] [pid 12432] [client 10.204.32.26:54801] PHP Notice:  Undefined index: service_object_id in /usr/local/nagiosxi/html/includes/dbauth.inc.php on line 0, referer: https://10.201.85.148/nagiosxi/includes/page-default-splash.php

Maybe it will be some help in debuging 5.7.0

Darek.

Re: All users lost access to own hosts after upgrade to 5.7.

Posted: Tue Jun 09, 2020 9:50 am
by jomann
Hello Derek,

I believe this is an ndo3 upgrade problem, possibly no hosts/services are being written into the ndo database. Since it logs to nagios.log, can we get the /usr/local/nagios/var/nagios.log file to see if there are any ndo issues?

Re: All users lost access to own hosts after upgrade to 5.7.

Posted: Tue Jun 09, 2020 3:49 pm
by dariusz.nalazek
nagios.log send on PM and additional info

I applied patch queries.inc.php found in other topic about 5.7.0 on forum.
It solve some problems, ordinary users can see own hosts/services.

However _all_ hosts/services have now (with patch) pending status in GUI, even for admins (after ~18min, over 1k hosts).
Monitoring and alerting seems to work OK (according to logs and mails with alerts), but GUI is not working well.

Darek.

Re: All users lost access to own hosts after upgrade to 5.7.

Posted: Wed Jun 10, 2020 9:32 am
by lmiltchev
Can you run the following commands and show the output?

Code: Select all

echo "describe nagios_hoststatus;" |mysql -pnagiosxi nagios |grep check_options
echo "describe nagios_servicestatus;" |mysql -pnagiosxi nagios |grep check_options

Re: All users lost access to own hosts after upgrade to 5.7.

Posted: Fri Jun 12, 2020 2:31 am
by dariusz.nalazek
5.7.0 restored from backup returns (main server):

Code: Select all

# echo "describe nagios_hoststatus;" |mysql -pnagiosxi nagios |grep check_options
check_options   smallint(6)     NO              0
# echo "describe nagios_servicestatus;" |mysql -pnagiosxi nagios |grep check_options
check_options   smallint(6)     NO              0
the same server with 5.6.14, returns nothing...

Darek.

Re: All users lost access to own hosts after upgrade to 5.7.

Posted: Fri Jun 12, 2020 8:49 am
by lmiltchev
I would recommend that you upgrade to Nagios XI 5.7.1, which was released yesterday. It should fix the issue that you are having.

Here's the changelog:

https://www.nagios.com/downloads/nagios-xi/change-log/

Re: All users lost access to own hosts after upgrade to 5.7.

Posted: Mon Jun 15, 2020 2:58 am
by dariusz.nalazek
upgraded, so far is OK.

Re: All users lost access to own hosts after upgrade to 5.7.

Posted: Mon Jun 15, 2020 8:46 am
by lmiltchev
I am glad your issue has been resolved! I will be closing this topic now. If you have any further questions/issues, please start a new thread. Thank you!
All times are UTC-05:00
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited