Problem Hostgroups in Nagiosxi

[roccoss]

Hi @tgriep

I did the changes and restarted Nagios. But after thirty minutes the services don't appearance yet.

Thx.

[tgriep]

I see that there is data in the MYSQL database but the Apache server cannot read it and display it in the GUI.
Can you run the following commands as root and post the output?

Code: Select all

netstat -a |grep mysql
cat /etc/hosts

Also, get these files from the server and upload them to the post.

Code: Select all

/var/log/httpd/access_log
/var/log/httpd/ssl_access_log
/var/log/httpd/ssl_error_log
/var/log/httpd/error_log

Thanks

[roccoss]

Hi @tgriep

I send the logs in PM

The output the those commands:


[root@ih88a ~]# netstat -a | grep mysql
tcp 0 0 *:mysql *:* LISTEN
unix 2 [ ACC ] STREAM LISTENING 114532884 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 162077337 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 162077333 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 162077323 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 162077321 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 162077319 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 162077309 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 162077304 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 162077300 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 162077296 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 162077294 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 160327494 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 160327492 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 160303871 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 160303869 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 159484457 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 159484455 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 158704921 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 158704919 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 158581407 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 158581405 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 158562054 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 158562052 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 158280053 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 158280051 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 158249653 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 158249651 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 158225861 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 158225859 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 158217706 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 158217704 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 157772861 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 157772859 /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 152725283 /var/lib/mysql/mysql.sock
[root@ih88a ~]#
[root@ih88a ~]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
10.142.119.10 ih88a ih88a.sco.ree.es #B1.2net.sh
193.148.127.47 correo2 correo2-sco.sco.ree.es
193.148.127.48 correo1 correo1-sco.sco.ree.es

[root@ih88a ~]#

Thanks

[tgriep]

Thanks for the files. This is a tough one. I am not seeing any errors at all.
One thing I did see is that the Program URL needs to be updated and you have https in the URL.
Go to the Admin > Manage System Config menu and change the Program URL from

Code: Select all

https://10.142.119.10/nagiosxi/

to

Code: Select all

http://10.142.119.10/nagiosxi/

Then update the settings and see if the data can be viewed.

Also, your SSH tunneling, can you provide the details on how the tunnel is setup.

[roccoss]

Hi @tgriep

I modificated the url, but don't show the host`s services

I send PM with images the SSL Tunnel.

Thank you

[tgriep]

I have a question, in the last screen shots, you are using port 9999 in the Putty settings for the tunnel but the URL for the XI GUI shows port 9990, which is it?

Can you run the following commands in the Nagios server and post the output?

Code: Select all

/usr/local/nagios/libexec/check_icmp -H 10.235.166.51 -w 3000.0,80% -c 5000.0,100% -p 5
/usr/local/nagios/libexec/check_nrpe -H 10.229.166.51
/usr/local/nagios/libexec/check_icmp -H 10.235.166.11 -w 3000.0,80% -c 5000.0,100% -p 5
/usr/local/nagios/libexec/check_nrpe -H 10.229.166.11
chage -l nagios
ls -l /usr/local/nagiosxi/
ls -l /usr/local/nagiosxi/var/

Could you post your Nagios XI System Profile so I can review it?
To post your system profile. Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and post it or PM it to me.

[roccoss]

HI @tgriep

The captures are different days, because show differents ports.
I send new captures with correct ports, and profile.zip in PM

The output of the commands:

[root@ih88a ~]#
[root@ih88a ~]# /usr/local/nagios/libexec/check_icmp -H 10.235.166.51 -w 3000.0,80% -c 5000.0,100% -p 5
OK - 10.235.166.51: rta 32.805ms, lost 0%|rta=32.805ms;3000.000;5000.000;0; pl=0%;80;100;; rtmax=33.033ms;;;; rtmin=32.678ms;;;;
[root@ih88a ~]# /usr/local/nagios/libexec/check_nrpe -H 10.235.166.51
NRPE v2.13
[root@ih88a ~]# /usr/local/nagios/libexec/check_icmp -H 10.235.166.11 -w 3000.0,80% -c 5000.0,100% -p 5
OK - 10.235.166.11: rta 32.753ms, lost 0%|rta=32.753ms;3000.000;5000.000;0; pl=0%;80;100;; rtmax=33.200ms;;;; rtmin=32.412ms;;;;
[root@ih88a ~]# /usr/local/nagios/libexec/check_nrpe -H 10.235.166.11
NRPE v2.13
[root@ih88a ~]# chage -l nagios
Last password change : Jun 26, 2012
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@ih88a ~]# ls -l /usr/local/nagiosxi/
total 32
drwxr-xr-x 2 nagios nagios 4096 May 28 2018 cron
drwxr-xr-x 3 nagios nagios 4096 May 28 2018 etc
drwxr-xr-x 18 nagios nagios 4096 May 28 2018 html
drwxr-xr-x 3 nagios nagios 4096 May 28 2018 nom
drwxr-xr-x 2 nagios nagios 4096 Feb 11 15:54 scripts
drwsrwsr-x 2 apache nagios 4096 Feb 4 23:40 tmp
drwxr-xr-x 2 nagios nagios 4096 May 28 2018 tools
drwxr-xr-x 4 nagios nagios 4096 Feb 19 16:25 var
[root@ih88a ~]# ls -l /usr/local/nagiosxi/var/
total 292
-rw-r----- 1 nagios users 302 Feb 19 16:25 cleaner.log
-rw-r----- 1 nagios users 302 Jan 27 03:09 cleaner.log-20190127
-rw-r----- 1 nagios users 302 Feb 3 03:17 cleaner.log-20190203
-rw-r----- 1 nagios users 302 Feb 10 03:20 cleaner.log-20190210
-rw-r----- 1 nagios users 302 Feb 17 03:41 cleaner.log-20190217
-rw-r----- 1 nagios users 81 Feb 19 16:25 cmdsubsys.log
-rw-r----- 1 nagios users 81 Jan 27 03:10 cmdsubsys.log-20190127
-rw-r----- 1 nagios users 81 Feb 3 03:18 cmdsubsys.log-20190203
-rw-r----- 1 nagios users 81 Feb 10 03:21 cmdsubsys.log-20190210
-rw-r----- 1 nagios users 81 Feb 17 03:42 cmdsubsys.log-20190217
drwsrwsr-x 2 apache nagios 4096 Jan 23 20:24 components
-rw-r----- 1 nagios users 7 Feb 19 16:25 corelog.data
-rw-r----- 1 nagios users 0 Feb 19 16:25 corelog.diff
-rw-r----- 1 nagios users 2677 Feb 19 16:25 dbmaint.log
-rw-r----- 1 nagios users 8197 Jan 27 03:05 dbmaint.log-20190127
-rw-r----- 1 nagios users 2677 Feb 3 03:15 dbmaint.log-20190203
-rw-r----- 1 nagios users 2677 Feb 10 03:20 dbmaint.log-20190210
-rw-r----- 1 nagios users 2677 Feb 17 03:40 dbmaint.log-20190217
-rw-r----- 1 nagios users 75 Feb 19 16:25 deadpool.log
-rw-r----- 1 nagios users 75 Jan 27 03:05 deadpool.log-20190127
-rw-r----- 1 nagios users 75 Feb 3 03:15 deadpool.log-20190203
-rw-r----- 1 nagios users 75 Feb 11 03:15 deadpool.log-20190211
-rw-r----- 1 nagios users 75 Feb 17 03:40 deadpool.log-20190217
-rw-r----- 1 nagios users 40 Feb 19 16:25 eventman.log
-rw-r----- 1 nagios users 40 Jan 27 03:10 eventman.log-20190127
-rw-r----- 1 nagios users 2062 Feb 3 03:18 eventman.log-20190203
-rw-r----- 1 nagios users 40 Feb 10 03:21 eventman.log-20190210
-rw-r----- 1 nagios users 40 Feb 17 03:42 eventman.log-20190217
-rw-r----- 1 nagios users 25 Feb 19 16:25 feedproc.log
-rw-r----- 1 nagios users 25 Jan 27 03:10 feedproc.log-20190127
-rw-r----- 1 nagios users 25 Feb 3 03:18 feedproc.log-20190203
-rw-r----- 1 nagios users 25 Feb 10 03:21 feedproc.log-20190210
-rw-r----- 1 nagios users 25 Feb 17 03:42 feedproc.log-20190217
-rw-r----- 1 nagios users 856 Feb 19 16:25 load_url.log
-rw-r----- 1 nagios users 856 Jan 27 03:09 load_url.log-20190127
-rw-r----- 1 nagios users 856 Feb 3 03:17 load_url.log-20190203
-rw-r----- 1 nagios users 856 Feb 10 03:20 load_url.log-20190210
-rw-r----- 1 nagios users 856 Feb 17 03:41 load_url.log-20190217
-rw-r----- 1 nagios users 0 Feb 19 16:25 nom.log
-rw-r----- 1 nagios users 651 Dec 29 03:46 nom.log-20181229
-rw-r----- 1 nagios users 651 Dec 30 03:53 nom.log-20181230
-rw-r----- 1 nagios users 643 Jan 11 18:20 nom.log-20190111
-rw-r----- 1 nagios users 243 Feb 19 16:25 perfdataproc.log
-rw-r----- 1 nagios users 243 Jan 27 03:10 perfdataproc.log-20190127
-rw-r----- 1 nagios users 243 Feb 3 03:18 perfdataproc.log-20190203
-rw-r----- 1 nagios users 243 Feb 10 03:21 perfdataproc.log-20190210
-rw-r----- 1 nagios users 243 Feb 17 03:42 perfdataproc.log-20190217
-rw-r----- 1 nagios users 139 Feb 19 16:01 recurringdowntime.log
-rw-r----- 1 nagios users 139 Jan 27 03:01 recurringdowntime.log-20190127
-rw-r----- 1 nagios users 139 Feb 3 03:01 recurringdowntime.log-20190203
-rw-r----- 1 nagios users 139 Feb 10 03:01 recurringdowntime.log-20190210
-rw-r----- 1 nagios users 139 Feb 17 03:01 recurringdowntime.log-20190217
-rw-r----- 1 nagios users 0 Feb 19 16:25 reportengine.log
-rw-r----- 1 nagios users 651 Dec 26 17:19 reportengine.log-20181226
-rw-r----- 1 nagios users 651 Dec 30 03:53 reportengine.log-20181230
-rw-r----- 1 nagios users 643 Jan 11 18:20 reportengine.log-20190111
drwxr-xr-x 2 nagios nagios 4096 Feb 12 23:39 subsys
-rw-r----- 1 nagios users 8229 Feb 19 16:25 sysstat.log
-rw-r----- 1 nagios users 8213 Jan 27 03:10 sysstat.log-20190127
-rw-r----- 1 nagios users 8222 Feb 3 03:18 sysstat.log-20190203
-rw-r----- 1 nagios users 8234 Feb 10 03:21 sysstat.log-20190210
-rw-r----- 1 nagios users 8227 Feb 17 03:42 sysstat.log-20190217
-rw-r--r-- 1 root root 790 May 28 2018 xi-sys.cfg
-rw-r--r-- 1 nagios nagios 202 May 28 2018 xiversion
[root@ih88a ~]#

Thank you

[tgriep]

Edit the Apache config file and change the port from 9990 back to port 80 and restart apache.

In the XI GUI, go to Admin > Manage System Config and put the following in the Program URL: field.

Code: Select all

http://10.142.119.10/nagiosxi/

Restart Apache again as well as Nagios and see if that fixes the issue.