Page 1 of 2

Nagios XI 5.7 update problem

Posted: Tue Jun 09, 2020 11:24 am
by perryell
Nagios Xi upgrade 5.7 without errors on the running process, but After upgrade

The nagios interface shows in the top
SQL Error [nagiosxi] : ERROR: syntax error at or near "WHERE"
LINE 3: WHERE user_id = 18

A License activation error shows
Your license needs to be re-activated in order to access certain features of Nagios XI. Activate your license now.

Version still show 5.6.13

Thanks

Re: Nagios XI 5.7 update problem

Posted: Tue Jun 09, 2020 12:11 pm
by scottwilkerson
Did the upgrade finish completely? Can you share the upgrade.log?

Re: Nagios XI 5.7 update problem

Posted: Tue Jun 09, 2020 1:23 pm
by perryell
here is the file
nrpe restart fails at the end

Re: Nagios XI 5.7 update problem

Posted: Tue Jun 09, 2020 2:16 pm
by scottwilkerson
Hmm, that upgrade didn't complete

Can you show the output of

Code: Select all

netstat -nlp|grep 5666
Also, can you run these back to back and show the output

Code: Select all

service nrpe start
grep nrpe /var/log/messages|tail -20

Re: Nagios XI 5.7 update problem

Posted: Tue Jun 09, 2020 4:19 pm
by perryell
[root@xxxx nagiosxi]# netstat -nlp|grep 5666
[root@xxxx nagiosxi]# service nrpe start
Starting nrpe [FAILED]
[root@xxxx nagiosxi]# grep nrpe /var/log/messages|tail -20
Jun 9 17:16:17 pevrtmon1 check_nrpe[55247]: Remote 192.168.23.235 does not support version 3/4 packets
Jun 9 17:16:18 pevrtmon1 check_nrpe[55258]: Remote 192.168.23.235 does not support version 3/4 packets
Jun 9 17:16:18 pevrtmon1 check_nrpe[55267]: Remote 10.55.1.234 does not support version 3/4 packets
Jun 9 17:16:18 pevrtmon1 check_nrpe[55271]: Remote 192.168.23.235 does not support version 3/4 packets
Jun 9 17:16:18 pevrtmon1 check_nrpe[55283]: Remote 192.168.40.246 does not support version 3/4 packets
Jun 9 17:16:19 pevrtmon1 check_nrpe[55276]: Remote 192.168.16.6 does not support version 3/4 packets
Jun 9 17:16:19 pevrtmon1 check_nrpe[55277]: Remote 192.168.16.6 does not support version 3/4 packets
Jun 9 17:16:19 pevrtmon1 check_nrpe[55279]: Remote 192.168.28.251 does not support version 3/4 packets
Jun 9 17:16:19 pevrtmon1 check_nrpe[55297]: Remote 192.168.40.249 does not support version 3/4 packets
Jun 9 17:16:19 pevrtmon1 check_nrpe[55287]: Remote 192.168.14.190 does not support version 3/4 packets
Jun 9 17:16:20 pevrtmon1 check_nrpe[55291]: Remote 192.168.16.3 does not support version 3/4 packets
Jun 9 17:16:20 pevrtmon1 check_nrpe[55292]: Remote 192.168.16.3 does not support version 3/4 packets
Jun 9 17:16:20 pevrtmon1 check_nrpe[55293]: Remote 192.168.16.6 does not support version 3/4 packets
Jun 9 17:16:20 pevrtmon1 check_nrpe[55313]: Remote 10.10.1.247 does not support version 3/4 packets
Jun 9 17:16:20 pevrtmon1 check_nrpe[55315]: Remote 10.10.6.236 does not support version 3/4 packets
Jun 9 17:16:20 pevrtmon1 check_nrpe[55308]: Remote 192.168.40.246 does not support version 3/4 packets
Jun 9 17:16:20 pevrtmon1 check_nrpe[55316]: Remote 10.10.1.177 does not support version 3/4 packets
Jun 9 17:16:20 pevrtmon1 check_nrpe[55310]: Remote 192.168.40.246 does not support version 3/4 packets
Jun 9 17:16:20 pevrtmon1 check_nrpe[55306]: Remote 10.55.1.247 does not support version 3/4 packets
Jun 9 17:16:20 pevrtmon1 check_nrpe[55303]: Remote 192.168.16.3 does not support version 3/4 packets

Re: Nagios XI 5.7 update problem

Posted: Tue Jun 09, 2020 4:31 pm
by scottwilkerson
how about

Code: Select all

grep nrpe /var/log/messages|grep -v check_nrpe |tail -20
Also, can you run the following so we can debug why this is failing

Code: Select all

bash -x /etc/init.d/nrpe start

Re: Nagios XI 5.7 update problem

Posted: Tue Jun 09, 2020 4:54 pm
by perryell
I dont believe the nrpe client is running in the nagios server, only in the targets

Re: Nagios XI 5.7 update problem

Posted: Wed Jun 10, 2020 7:44 am
by scottwilkerson
This is strange, you you show the output of the following

Code: Select all

ls -l /etc/init.d/nrpe
Also, attach your current init script /etc/init.d/nrpe

Thanks

Re: Nagios XI 5.7 update problem

Posted: Wed Jun 10, 2020 8:41 am
by perryell
Nrpe is setup in the clients under xinetd.d/nrpe on port 6666
Not setting for nrpe on the server on xinetd.d/nrpe

Re: Nagios XI 5.7 update problem

Posted: Wed Jun 10, 2020 8:54 am
by scottwilkerson
If you aren't using nrpe on the server anyways, lets push past this with the following to get this server up and running

Code: Select all

cat /dev/null > /tmp/nagiosxi/subcomponents/nrpe/upgrade
cd /tmp/nagiosxi
./upgrade