All users lost access to own hosts after upgrade to 5.7.0

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

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

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

[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

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

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

[dariusz.nalazek]

upgraded, so far is OK.

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