Unable to see "Current Hosts" in License Information

[vinish098]

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]

[rkennedy]

Code: Select all

CPU Load 15: 12.53
Total Hosts: 0
Total Services: 0

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.

[vinish098]

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

[rkennedy]

Looking through your profile I noticed -

Code: Select all

170209 11:38:53 [ERROR] /usr/libexec/mysqld: Table './nagios/nagios_statehistory' is marked as crashed and last (automatic?) repair failed

Can you run /usr/local/nagiosxi/scripts/repair_databases.sh to fix this? This could affect your performance graphs.

[vinish098]

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

Able to see performance graph now.

Thanks..!!

[mcapra]

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

[vinish098]

Please mark this thread as resolved.

Thanks!!

[rkennedy]

Will do!

/closed