Page 1 of 2

Command processing after upgrade from XI 2014R1.4 to XI 5.2.

Posted: Thu Sep 29, 2016 1:07 pm
by rodpayne
I just upgraded from XI 2014R1.4 to XI 5.2.9, and I am having problems with command processing.

For example, scheduling a downtime on the Host Status Detail Advanced tab does nothing, not even the green command processing popup (that I can see anyway).

“Force an immediate check” pops up the green command processing box, but the Next Check time does not update and it does not do a check until that time.

“Acknowledge this problem” does not.

System Status looks okay, all checkmarks are green.

Nagios XI Installation Profile
System:
Nagios XI Version : 5.2.9
KALNAGIOS01.kaleidahealth.org 2.6.32-358.2.1.el6.x86_64 x86_64
CentOS release 6.4 (Final)
Gnome is not installed
Apache Information
PHP Version: 5.3.3
Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like Gecko
Server Name: kalnagios01
Server Address: 10.10.212.100
Server Port: 80
Date/Time
PHP Timezone: America/New_York
PHP Time: Thu, 29 Sep 2016 13:32:36 -0400
System Time: Thu, 29 Sep 2016 13:32:36 -0400
Nagios XI Data
License ends in: TOMSPN

nagios (pid 4855) is running...
NPCD running (pid 1794).
ndo2db (pid 1806) is running...
CPU Load 15: 1.54
Total Hosts: 921
Total Services: 4563
Function 'get_base_uri' returns: http://kalnagios01/nagiosxi/
Function 'get_base_url' returns: http://kalnagios01/nagiosxi/
Function 'get_backend_url(internal_call=false)' returns: http://kalnagios01/nagiosxi/includes/co ... rofile.php
Function 'get_backend_url(internal_call=true)' returns: http://localhost/nagiosxi/backend/
Ping Test localhost
Running:
/bin/ping -c 3 localhost 2>&1
PING localhost (127.0.0.1) 56(84) bytes of data.
64 bytes from localhost (127.0.0.1): icmp_seq=1 ttl=64 time=0.026 ms
64 bytes from localhost (127.0.0.1): icmp_seq=2 ttl=64 time=0.033 ms
64 bytes from localhost (127.0.0.1): icmp_seq=3 ttl=64 time=0.030 ms

--- localhost ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2000ms
rtt min/avg/max/mdev = 0.026/0.029/0.033/0.006 ms
Test wget To localhost
WGET From URL: http://localhost/nagiosxi/includes/components/ccm/
Running:
/usr/bin/wget http://localhost/nagiosxi/includes/components/ccm/
--2016-09-29 13:32:38-- http://localhost/nagiosxi/includes/components/ccm/
Resolving localhost... ::1, 127.0.0.1
Connecting to localhost|::1|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/html]
Saving to: "/usr/local/nagiosxi/tmp/ccm_index.tmp"

0K ......... 521M=0s

2016-09-29 13:32:38 (521 MB/s) - "/usr/local/nagiosxi/tmp/ccm_index.tmp" saved [9886]

Re: Command processing after upgrade from XI 2014R1.4 to XI

Posted: Thu Sep 29, 2016 4:08 pm
by rkennedy
Could you PM over a ZIP version of your profile? It's on the same page you were on, except click 'Download Profile'.

Could you also verify all times are in working order with the following commands? Please post back the output -

Code: Select all

grep "date.timezone" /etc/php.ini
ls -l /etc/localtime
php -r 'echo date("D M j G:i:s T Y")."\n";'
date
mysql -unagiosxi -pn@gweb -e "SELECT NOW();"

Re: Command processing after upgrade from XI 2014R1.4 to XI

Posted: Fri Sep 30, 2016 8:34 am
by rodpayne
[root@KALNAGIOS01 ~]# grep "date.timezone" /etc/php.ini
; http://www.php.net/manual/en/datetime.c ... e.timezone
date.timezone = America/New_York
[root@KALNAGIOS01 ~]# ls -l /etc/localtime
-rw-r--r-- 1 root root 3519 May 4 2010 /etc/localtime
[root@KALNAGIOS01 ~]# php -r 'echo date("D M j G:i:s T Y")."\n";'
Fri Sep 30 9:29:27 EDT 2016
[root@KALNAGIOS01 ~]# date
Fri Sep 30 09:29:27 EDT 2016
[root@KALNAGIOS01 ~]# mysql -unagiosxi -pn@gweb -e "SELECT NOW();"
ERROR 1045 (28000): Access denied for user 'nagiosxi'@'localhost' (using password: YES)
[root@KALNAGIOS01 ~]#

Re: Command processing after upgrade from XI 2014R1.4 to XI

Posted: Fri Sep 30, 2016 10:58 am
by mcapra
Hmm, lets see if changing the MySQL command produces different output:

Code: Select all

grep "date.timezone" /etc/php.ini
ls -l /etc/localtime
php -r 'echo date("D M j G:i:s T Y")."\n";'
date
mysql -uroot -pnagiosxi -e "SELECT NOW();"
psql -U postgres -d nagiosxi -c "SELECT NOW();"

Re: Command processing after upgrade from XI 2014R1.4 to XI

Posted: Fri Sep 30, 2016 11:49 am
by rodpayne
[root@KALNAGIOS01 html]# grep "date.timezone" /etc/php.ini
; http://www.php.net/manual/en/datetime.c ... e.timezone
date.timezone = America/New_York
[root@KALNAGIOS01 html]# ls -l /etc/localtime
-rw-r--r-- 1 root root 3519 May 4 2010 /etc/localtime
[root@KALNAGIOS01 html]# php -r 'echo date("D M j G:i:s T Y")."\n";'
Fri Sep 30 12:47:01 EDT 2016
[root@KALNAGIOS01 html]# date
Fri Sep 30 12:47:01 EDT 2016
[root@KALNAGIOS01 html]# mysql -uroot -pxxxxxxxx -e "SELECT NOW();"
+---------------------+
| NOW() |
+---------------------+
| 2016-09-30 12:47:01 |
+---------------------+
[root@KALNAGIOS01 html]# psql -U postgres -d nagiosxi -c "SELECT NOW();"
now
-------------------------------
2016-09-30 12:47:01.580958-04
(1 row)

[root@KALNAGIOS01 html]#

Re: Command processing after upgrade from XI 2014R1.4 to XI

Posted: Fri Sep 30, 2016 12:22 pm
by tgriep
It could also be an account / permission issue causing the problem.
Can you run the following as root on the server and post the output?

Code: Select all

chage -l nagios
grep nag /etc/group
ls -l /usr/local/nagios/
ls -l /usr/local/nagios/var/
ls -l /usr/local/nagios/var/rw/

Re: Command processing after upgrade from XI 2014R1.4 to XI

Posted: Fri Sep 30, 2016 12:53 pm
by rodpayne
[root@KALNAGIOS01 problemoverview]# chage -l nagios
Last password change : Oct 14, 2013
Password expires : never
Password inactive : never
Account expires : never
Minimum number of days between password change : 0
Maximum number of days between password change : 99999
Number of days of warning before password expires : 7
[root@KALNAGIOS01 problemoverview]# grep nag /etc/group
nagios:x:500:nagios,apache
nagcmd:x:501:nagios,apache
[root@KALNAGIOS01 problemoverview]# ls -l /usr/local/nagios/
total 28
drwxrwxr-x 2 nagios nagios 4096 Sep 28 16:10 bin
drwsrwsr-x 8 apache nagios 4096 Sep 28 16:17 etc
drwxr-xr-x 2 root root 4096 Aug 13 2013 include
drwsrwsr-x 2 apache nagios 4096 Sep 28 16:12 libexec
drwxrwxr-x 2 nagios nagios 4096 Sep 28 16:09 sbin
drwxrwxr-x 18 nagios nagios 4096 Sep 28 16:09 share
drwxrwxr-x 6 nagios nagios 4096 Sep 30 13:50 var
[root@KALNAGIOS01 problemoverview]# ls -l /usr/local/nagios/var/
total 48860
drwxrwxr-x 2 nagios nagios 65536 Sep 29 23:59 archives
-rw-r--r-- 1 apache apache 2680084 Jun 20 14:03 graphapi.log
-rw-r--r-- 1 nagios nagios 289 Sep 30 13:50 host-perfdata
-rw-r--r-- 1 nagios nagios 37799 Nov 8 2013 livestatus.log
-rw-r--r-- 1 nagios nagios 2569 Sep 30 07:47 nagios.configtest
-rw-r--r-- 1 nagios nagios 6 Sep 30 03:25 nagios.lock
-rw-r--r-- 1 nagios nagios 8680733 Sep 30 13:50 nagios.log
-rw-r--r-- 1 nagios nagios 5 Sep 28 16:40 ndo2db.lock
-rw-r--r-- 1 nagios nagios 0 Sep 30 03:25 ndomod.tmp
srwxr-xr-x 1 nagios nagios 0 Sep 28 16:40 ndo.sock
-rw-r--r-- 1 nagios nagios 6661265 Sep 30 11:42 npcd.log
-rw-r--r-- 1 nagios nagios 4896397 Sep 30 03:25 objects.cache
-rw-r--r-- 1 nagios nagios 4896397 Sep 30 07:47 objects.precache
-rw-rw-rw- 1 nagios nagios 2969454 Sep 30 11:42 perfdata.log
-rw------- 1 nagios nagios 9529773 Sep 30 13:25 retention.dat
drwxrwsr-x 2 nagios nagcmd 4096 Sep 30 03:25 rw
-rw-r--r-- 1 nagios nagios 1293 Sep 30 13:50 service-perfdata
drwxr-xr-x 5 root root 4096 Jun 5 2013 spool
drwxr-xr-x 2 nagios nagios 4096 Sep 5 14:01 stats
-rw-rw-r-- 1 nagios nagios 9545004 Sep 30 13:50 status.dat
[root@KALNAGIOS01 problemoverview]# ls -l /usr/local/nagios/var/rw/
total 0
prw-rw---- 1 nagios nagcmd 0 Sep 30 13:50 nagios.cmd
srw-rw---- 1 nagios nagcmd 0 Sep 30 03:25 nagios.qh
[root@KALNAGIOS01 problemoverview]#

Re: Command processing after upgrade from XI 2014R1.4 to XI

Posted: Fri Sep 30, 2016 1:03 pm
by tgriep
Permissions and the user account look good.
Can you login to the server using the Core interface and the nagiosadmin account and see if it fails the same there?
To access the Core interface, use this link below.

Code: Select all

 http://kalnagios01/nagios/

Re: Command processing after upgrade from XI 2014R1.4 to XI

Posted: Fri Sep 30, 2016 1:41 pm
by rodpayne
Actually, I just tried it again in XI and all three functions look like they are working. Maybe it had something to do with some kind of startup processing that it is doing:
Capture.JPG
CaptureCPU.JPG

Re: Command processing after upgrade from XI 2014R1.4 to XI

Posted: Fri Sep 30, 2016 1:54 pm
by bwallace
Glad to see it's working now! Is it alright if we close this thread or were there other questions on the topic?