Nagios XI 5.7 update problem

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
perryell
Posts: 52
Joined: Fri May 06, 2011 10:12 am

Nagios XI 5.7 update problem

Post 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
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: Nagios XI 5.7 update problem

Post by scottwilkerson »

Did the upgrade finish completely? Can you share the upgrade.log?
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
perryell
Posts: 52
Joined: Fri May 06, 2011 10:12 am

Re: Nagios XI 5.7 update problem

Post by perryell »

here is the file
nrpe restart fails at the end
You do not have the required permissions to view the files attached to this post.
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: Nagios XI 5.7 update problem

Post 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
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
perryell
Posts: 52
Joined: Fri May 06, 2011 10:12 am

Re: Nagios XI 5.7 update problem

Post 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
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: Nagios XI 5.7 update problem

Post 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
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
perryell
Posts: 52
Joined: Fri May 06, 2011 10:12 am

Re: Nagios XI 5.7 update problem

Post by perryell »

I dont believe the nrpe client is running in the nagios server, only in the targets
You do not have the required permissions to view the files attached to this post.
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: Nagios XI 5.7 update problem

Post 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
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
perryell
Posts: 52
Joined: Fri May 06, 2011 10:12 am

Re: Nagios XI 5.7 update problem

Post 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
You do not have the required permissions to view the files attached to this post.
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: Nagios XI 5.7 update problem

Post 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
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
Locked