Nagios Support Forum

Dear Team,

We are monitoring around 650 hosts in NagiosXI.

But we are facing issue while taking "Host Availability" report of a particular host. We are not able to see any of the host in dropdown menu.

I ran these command in NagiosXI server:

[root@nagiosXI scripts]# echo 'select count(*) from nagios.nagios_hosts;' | mysql -s -pnagiosxi
0

[root@nagiosXI scripts]# echo 'select count(*) from nagios.nagios_services;' | mysql -s -pnagiosxi
0

When I checked in License Information, I am not able to see any of the host there.
License Type: Host-Based
Number of Licensed Hosts: Unlimited
Current Hosts: 0

Here is the system profile for your reference.
Nagios XI Installation Profile
Download Profile
System:
Nagios XI Version : 2014R1.3
nagiosXI.drreddys.com 2.6.32-431.20.3.el6.x86_64 x86_64
CentOS release 6.5 (Final)
Gnome Installed
Apache Information
PHP Version: 5.3.3
Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:51.0) Gecko/20100101 Firefox/51.0
Server Name: 152.63.2.155
Server Address: 152.63.2.155
Server Port: 80
Date/Time
PHP Timezone: Asia/Kolkata
PHP Time: Wed, 08 Feb 2017 17:32:42 +0530
System Time: Wed, 08 Feb 2017 17:32:42 +0530
Nagios XI Data
License ends in: ONNTNP

nagios (pid 1637) is running...
NPCD running (pid 1527).
ndo2db (pid 1673) is running...
CPU Load 15: 12.53
Total Hosts: 0
Total Services: 0
Function 'get_base_uri' returns: http://152.63.2.155/nagiosxi/
Function 'get_base_url' returns: http://152.63.2.155/nagiosxi/
Function 'get_backend_url(internal_call=false)' returns: http://152.63.2.155/nagiosxi/includes/c ... 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.059 ms
64 bytes from localhost (127.0.0.1): icmp_seq=2 ttl=64 time=0.079 ms
64 bytes from localhost (127.0.0.1): icmp_seq=3 ttl=64 time=4.23 ms

--- localhost ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2007ms
rtt min/avg/max/mdev = 0.059/1.457/4.234/1.963 ms
Test wget To localhost
WGET From URL: http://localhost/nagiosxi/includes/components/ccm/
Running:

/usr/bin/wget http://localhost/nagiosxi/includes/components/ccm/

--2017-02-08 17:32:44-- http://localhost/nagiosxi/includes/components/ccm/
Resolving localhost... 127.0.0.1
Connecting to localhost|127.0.0.1|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/html]
Saving to: "/usr/local/nagiosxi/tmp/ccm_index.tmp"

0K ......... 142M=0s

2017-02-08 17:32:45 (142 MB/s) - "/usr/local/nagiosxi/tmp/ccm_index.tmp" saved [9634]

The load on here is concerning as well. Could you please PM over a profile to dwhitfield, and myself to review? (Admin -> System Profile -> Download Profile)

Also - you're using a fairly old version at this point - is upgrading an option?

UPDATE: Profile received and shared with techs.

I have upgraded Nagios to latest release. Now I am able to see number of hosts configured in License Information.

[root@nagiosXI nagiosxi]# echo 'select count(*) from nagios.nagios_hosts;' | mysql -s -pnagiosxi
629
[root@nagiosXI nagiosxi]# echo 'select count(*) from nagios.nagios_services;' | mysql -s -pnagiosxi
6479

But after upgrading, I am not able to see any of the performance graphs. Its showing "No data to display".

Looking through your profile I noticed - Can you run /usr/local/nagiosxi/scripts/repair_databases.sh to fix this? This could affect your performance graphs.

I ran this script:
/usr/local/nagiosxi/scripts/repairmysql.sh nagios

Able to see performance graph now.

Thanks..!!

Awesome! Did you have additional questions regarding this issue, or can we close this thread and mark the issue as resolved?

Please mark this thread as resolved.

Thanks!!

Will do!

/closed