Hosts and Services not appearing in views

[Keo]

I recently install Nagios XI on a RHEL 6 64bit system. The install went fine, but after adding a host and services it doesn't show up in any of my views.
If I go to my network map or look under CCM and click on hosts, I see the information.
Any assistance resolving this issue would be helpful

Here is the output from my system data:

Code: Select all

System:
Nagios XI Version : 2012R2.3
pryor 2.6.32-358.14.1.el6.x86_64 x86_64
Red Hat Enterprise Linux Server release 6.4 (Santiago)
Gnome is not installed
Apache Information
PHP Version: 5.3.3
Agent: Mozilla/5.0 (Windows NT 5.1; rv:23.0) Gecko/20100101 Firefox/23.0
Server Name: ***********
Server Address: ***********
Server Port: 80

Date/Time

PHP Timezone: America/Chicago
PHP Time: Thu, 29 Aug 2013 10:08:25 -0500
System Time: Thu, 29 Aug 2013 10:08:25 -0500

Nagios XI Data

nagios (pid 19112) is running...
NPCD not running.
ndo2db (pid 18427) is running...
CPU Load 15: 0.01
Total Hosts: 0
Total Services: 0
Function 'get_base_uri' returns: http://*******/nagiosxi/
Function 'get_base_url' returns: http://********/nagiosxi/
Function 'get_backend_url(internal_call=false)' returns: http://********/nagiosxi/includes/components/profile/profile.php
Function 'get_backend_url(internal_call=true)' returns: http://localhost/nagiosxi/backend/

[abrist]

Just a quick question -> You did apply configuration, right?

[Keo]

Just a quick question -> You did apply configuration, right?

Yes I did.

[Keo]

I am not sure if this helps at all but here is a screen capture from views -> tactical overview.

tactical overview.png

As you see it shows there are items that are being monitored, but clicking on them shows this

host_status.png

If I go to configure -> Core Config Manager and select hosts or services, I see my hosts and services here.

hosts.png

[slansing]

Can you run through the following and then see if they display properly?:

http://assets.nagios.com/downloads/nagi ... tabase.pdf

[Keo]

Can you run through the following and then see if they display properly?:

http://assets.nagios.com/downloads/nagi ... tabase.pdf

Did that and got the same result.

[sreinhardt]

try the following and send us the results please:

Code: Select all

tail -f /var/log/httpd/error_log
Now visit the hosts and services pages individually. 
ctrl+c the tail command and copy the output.

if you see nothing in the error log, also do the access_log. As another note, are you using ssl or no?

[slansing]

Hmm your profile does not even show hosts/services "Total Hosts: 0 Total Services: 0".

Just a heads up your NPCD is not running either, I'd head to the command line and start it:

Code: Select all

service npcd start

Just for safe measure can you restart mysql and check to see if you can see your hosts? Do you see any errors when restarting mysql?

Code: Select all

service mysqld restart

Also, please send us the output of the following after trying to access the Host Details page:

Code: Select all

tail -30 /var/log/mysqld.log

[Keo]

Hmm your profile does not even show hosts/services "Total Hosts: 0 Total Services: 0".

Just a heads up your NPCD is not running either, I'd head to the command line and start it:

Code: Select all

service npcd start

I saw this also, but the service appears to be running

Code: Select all

# service npcd start
NPCD already started
# service npcd status
NPCD running (pid 15167).
# 

Just for safe measure can you restart mysql and check to see if you can see your hosts? Do you see any errors when restarting mysql?

Code: Select all

service mysqld restart

here is my result:

Code: Select all

# service mysqld restart
Stopping mysqld:  
Starting mysqld:  
# 

Also, please send us the output of the following after trying to access the Host Details page:

Code: Select all

tail -30 /var/log/mysqld.log

Code: Select all

# tail -30 /var/log/mysqld.log
130829 11:13:36 [Note] /usr/libexec/mysqld: Normal shutdown

130829 11:13:36 [Note] Event Scheduler: Purging the queue. 0 events
130829 11:13:38  InnoDB: Starting shutdown...
130829 11:13:40  InnoDB: Shutdown completed; log sequence number 0 44233
130829 11:13:40 [Note] /usr/libexec/mysqld: Shutdown complete

130829 11:13:40 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
130829 11:13:56 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130829 11:13:56  InnoDB: Initializing buffer pool, size = 8.0M
130829 11:13:56  InnoDB: Completed initialization of buffer pool
130829 11:13:56  InnoDB: Started; log sequence number 0 44233
130829 11:13:56 [Note] Event Scheduler: Loaded 0 events
130829 11:13:56 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
130829 11:36:50 [Note] /usr/libexec/mysqld: Normal shutdown

130829 11:36:50 [Note] Event Scheduler: Purging the queue. 0 events
130829 11:36:50  InnoDB: Starting shutdown...
130829 11:36:52  InnoDB: Shutdown completed; log sequence number 0 44233
130829 11:36:52 [Note] /usr/libexec/mysqld: Shutdown complete

130829 11:36:52 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
130829 11:36:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130829 11:36:53  InnoDB: Initializing buffer pool, size = 8.0M
130829 11:36:53  InnoDB: Completed initialization of buffer pool
130829 11:36:53  InnoDB: Started; log sequence number 0 44233
130829 11:36:53 [Note] Event Scheduler: Loaded 0 events
130829 11:36:53 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

[lmiltchev]

Can you see the hosts/services in the Nagios Core?

Code: Select all

http://server_ip/nagios