Nagios Support Forum

Posted: **Mon Feb 19, 2018 3:14 pm**

That is weird, maybe there was something stuck on the XI server to cause the Fusion server to not display the groups.
Did the reboot allow the download of the Hostgroup work in the Fusion dashlet?

If you cannot display the Hostgroups in Fusion, Can you run the following as root and post the /tmp/info.txt file so I can get more info on the server's settings?

Code: Select all

echo 'select * from options;' |mysql -t -u fusion -pfusion fusion >/tmp/info.txt
echo 'select * from polled_deltas;' |mysql -t -u fusion -pfusion fusion >>/tmp/info.txt
echo 'select * from polled_averages;' |mysql -t -u fusion -pfusion fusion >>/tmp/info.txt
echo 'SELECT TABLE_NAME AS "Table", round(((data_length + index_length) / 1024 / 1024), 2) AS Size_in_MB FROM information_schema.TABLES WHERE table_schema = "fusion" ORDER BY Size_in_MB DESC;' |mysql -t -u fusion -pfusion fusion >>/tmp/info.txt

Posted: **Tue Feb 20, 2018 11:33 am**

unfortunately, the restart didn't help and now a new problem has come to it.
The informationen of a xi server is no longer visible, see screen1 and the weird is, when i delete and re-add the server, another server is impacted.
Additional attached is the text file from the fusion server.

Posted: **Wed Feb 21, 2018 5:00 pm**

Lets try and delete the polling locks and truncate the polled data.
Run the following as root

Code: Select all

echo 'select * from polling_lock ;' |mysql -u fusion -pfusion fusion
cd /usr/local/nagiosfusion/scripts
./truncate_polled.php

If the system does not update the data in the GUI, run the following as root on the Fusion server and post the /tmp/varlog.tgz file?

Code: Select all

tar cvfz /tmp/varlog.tgz /usr/local/nagiosfusion/var/log/*.log

Posted: **Mon Mar 05, 2018 2:49 am**

this is the result from the mysql command:

PHP Warning: include_once(/usr/local/nagiosfusion/html/includes/dashlets/statusinfo/../dashlethelper.inc.php): failed to open stream: No such file or directory in /usr/local/nagiosfusion/html/includes/dashlets/statusinfo/statusinfo.inc.php on line 6
PHP Warning: include_once(): Failed opening '/usr/local/nagiosfusion/html/includes/dashlets/statusinfo/../dashlethelper.inc.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php') in /usr/local/nagiosfusion/html/includes/dashlets/statusinfo/statusinfo.inc.php on line 6
polled tables truncated!

the varlog.tgz can't be uploaded, it's 675 MB large and the upload attachment doesn't finish

Posted: **Mon Mar 05, 2018 10:09 am**

Was this server and upgrade from a pre 4.x.x version of Fusion?

Lets clear the mysql tables manually.
Run the following as root

Code: Select all

service crond stop
echo 'TRUNCATE TABLE polled_data;' | mysql -u fusion -pfusion fusion -f
echo 'TRUNCATE TABLE polled_averages;' | mysql -u fusion -pfusion fusion -f
echo 'TRUNCATE TABLE polled_deltas;' | mysql -u fusion -pfusion fusion -f
echo 'TRUNCATE TABLE polled_extras;' | mysql -u fusion -pfusion fusion -f
echo 'TRUNCATE TABLE polling_lock;' | mysql -u fusion -pfusion fusion -f

echo 'OPTIMIZE TABLE polled_data;' | mysql -u fusion -pfusion fusion
echo 'OPTIMIZE TABLE polled_averages;' | mysql -u fusion -pfusion fusion
echo 'OPTIMIZE TABLE polled_deltas;' | mysql -u fusion -pfusion fusion
echo 'OPTIMIZE TABLE polled_extras;' | mysql -u fusion -pfusion fusion
echo 'OPTIMIZE TABLE polling_lock;' | mysql -u fusion -pfusion fusion -f

service crond start

This will reset all of the data and it will take a while for the system to gather the data so give it some time.

If possible, upgrade the Fusion server to the latest version which you can download from here.
https://www.nagios.com/products/nagios-fusion/

If you still have issues, run the following as root and post the output.

Code: Select all

df -h
df -i
ls -l /usr/local/nagiosfusion/var/log/

Posted: **Wed Mar 14, 2018 1:42 am**

Hi,

execute your command, update fusion and the nagiosxi instance to the latest version, nothing worked :-/

Code: Select all

[root@xxx ~]# df -h
Filesystem             Size  Used Avail Use% Mounted on
/dev/mapper/rhel-root   46G  4.2G   42G  10% /
devtmpfs               1.9G     0  1.9G   0% /dev
tmpfs                  1.9G     0  1.9G   0% /dev/shm
tmpfs                  1.9G   57M  1.8G   3% /run
tmpfs                  1.9G     0  1.9G   0% /sys/fs/cgroup
/dev/sda1              497M  161M  336M  33% /boot
[root@xxx ~]# df -i
Filesystem              Inodes IUsed    IFree IUse% Mounted on
/dev/mapper/rhel-root 47804416 45783 47758633    1% /
devtmpfs                483040   330   482710    1% /dev
tmpfs                   485377     1   485376    1% /dev/shm
tmpfs                   485377   429   484948    1% /run
tmpfs                   485377    13   485364    1% /sys/fs/cgroup
/dev/sda1               512000   335   511665    1% /boot
[root@xxx ~]# ls -l /usr/local/nagiosfusion/var/log/
total 795272
-rw-r--r-- 1 nagios nagios   9112436 Mar 13 23:37 auth_subsys.log
-rw-r--r-- 1 nagios nagios 112569398 Mar 13 23:37 cmd_subsys.log
-rw-r--r-- 1 nagios nagios  81622253 Mar 13 23:35 dbmaint_subsys.log
-rw-r--r-- 1 nagios nagios         0 Mar 13 08:03 du
-rw-r--r-- 1 nagios nagios   7859219 Mar 13 23:35 fusion.log
-rw-r--r-- 1 nagios nagios 111865733 Mar 13 23:37 log_subsys.log
-rw-r--r-- 1 nagios nagios      5260 Mar 13 23:32 poll_subsys.10.nagiosadm.log
-rw-r--r-- 1 nagios nagios      6897 Jan 22 00:04 poll_subsys.10.nagiosfusion.lo                                               g
-rw-r--r-- 1 nagios nagios      5746 Feb 14 06:45 poll_subsys.11.jegadea.log
-rw-r--r-- 1 nagios nagios      5748 Feb 14 06:45 poll_subsys.11.nagiosadm.log
-rw-r--r-- 1 nagios nagios      6053 Jan 22 00:03 poll_subsys.11.nagiosfusion.lo                                               g
-rw-r--r-- 1 nagios nagios     11753 Jan 21 21:43 poll_subsys.12.nagiosadmin.log
-rw-r--r-- 1 nagios nagios      4535 Jan 22 00:05 poll_subsys.12.nagiosadm.log
-rw-r--r-- 1 nagios nagios     14073 Jan 19 02:24 poll_subsys.12.Nagiosadm.log
-rw-r--r-- 1 nagios nagios      4360 Mar 13 23:35 poll_subsys.13.nagiosadm.log
-rw-r--r-- 1 nagios nagios     10575 Feb 15 23:03 poll_subsys.14.nagiosadm.log
-rw-r--r-- 1 nagios nagios      4360 Mar 13 23:29 poll_subsys.15.nagiosadm.log
-rw-r--r-- 1 nagios nagios      4581 Mar 13 23:28 poll_subsys.16.nagiosadm.log
-rw-r--r-- 1 nagios nagios      9298 Mar 13 08:42 poll_subsys.17.nagiosadm.log
-rw-r--r-- 1 nagios users       9298 Mar 13 23:28 poll_subsys.18.nagiosadm.log
-rw-r--r-- 1 nagios nagios     11063 Nov 28 11:44 poll_subsys.1.ade-adm.log
-rw-r--r-- 1 nagios nagios      9913 Nov 28 11:34 poll_subsys.1.levveladm.log
-rw-r--r-- 1 nagios nagios      9911 Nov 28 11:44 poll_subsys.1.mujahih.log
-rw-r--r-- 1 nagios nagios      9916 Nov 28 11:44 poll_subsys.1.nagiosfusion.log
-rw-r--r-- 1 nagios nagios     23746 Nov 28 12:00 poll_subsys.2.ade-adm.log
-rw-r--r-- 1 nagios nagios     12859 Nov 28 11:39 poll_subsys.2.levveladm.log
-rw-r--r-- 1 nagios nagios     12857 Nov 28 11:43 poll_subsys.2.mujahih.log
-rw-r--r-- 1 nagios nagios     12859 Nov 28 11:48 poll_subsys.2.nagiosfusion.log
-rw-r--r-- 1 nagios nagios     13406 Nov 28 11:47 poll_subsys.3.ade-adm.log
-rw-r--r-- 1 nagios nagios     13407 Nov 28 11:37 poll_subsys.3.levveladm.log
-rw-r--r-- 1 nagios nagios     13403 Nov 28 11:46 poll_subsys.3.mujahih.log
-rw-r--r-- 1 nagios nagios     13403 Nov 28 11:47 poll_subsys.3.Nagios.log
-rw-r--r-- 1 nagios nagios      7397 Nov 28 11:45 poll_subsys.4.ade-adm.log
-rw-r--r-- 1 nagios nagios      7399 Nov 28 11:35 poll_subsys.4.levveladm.log
-rw-r--r-- 1 nagios nagios      7397 Nov 28 11:45 poll_subsys.4.mujahih.log
-rw-r--r-- 1 nagios nagios      7395 Nov 28 11:45 poll_subsys.4.Nagios.log
-rw-r--r-- 1 nagios nagios      6027 Nov 28 11:44 poll_subsys.5.ade-adm.log
-rw-r--r-- 1 nagios nagios      6029 Nov 28 11:39 poll_subsys.5.levveladm.log
-rw-r--r-- 1 nagios nagios      6026 Nov 28 11:44 poll_subsys.5.Nagios.log
-rw-r--r-- 1 nagios nagios      6010 Jan 24 23:27 poll_subsys.6.nagiosadmin.log
-rw-r--r-- 1 nagios nagios      4585 Mar 13 23:36 poll_subsys.6.nagiosadm.log
-rw-r--r-- 1 nagios nagios      9721 Nov 30 08:48 poll_subsys.7.ade-adm.log
-rw-r--r-- 1 nagios nagios      4360 Mar 13 23:34 poll_subsys.7.nagiosadm.log
-rw-r--r-- 1 nagios nagios      9648 Jan 22 00:03 poll_subsys.7.nagiosfusion.log
-rw-r--r-- 1 nagios nagios      4895 Feb  5 03:37 poll_subsys.8.nagiosadm.log
-rw-r--r-- 1 nagios nagios     12408 Jan 22 00:03 poll_subsys.8.nagiosfusion.log
-rw-r--r-- 1 nagios nagios     12943 Dec  7 08:11 poll_subsys.9.nagiosfusion.log
-rw-r--r-- 1 nagios nagios   2069399 Mar 13 23:37 poll_subsys.log
-rw-r--r-- 1 nagios nagios 486671602 Mar 13 23:37 sysstat_subsys.log

Posted: **Wed Mar 14, 2018 1:19 pm**

It you look in the /usr/local/nagiosfusion/var/log/auth_subsys.log file, you you see any authentication errors when connecting to that Nagios XI server?

I have a few commands that you can run from a root shell on the FUsion server.

This will test the connectivity to the XI server.

In the following commands, replace xxx.xxx.xxx.xxx with the IP address of the XI server and YYYYYYYYYYYYYYYYYYYYYYYY with the Fusekey from that XI server.

Code: Select all

curl -XGET http://xxx.xxx.xxx.xxx/nagiosxi/api/v1/system/status?fusekey=YYYYYYYYYYYYYYYYYYYYYYYY -k -v
curl -XGET https://xxx.xxx.xxx.xxx/nagiosxi/api/v1/system/status?fusekey=YYYYYYYYYYYYYYYYYYYYYYYY -k -v

Run them both and post the output to the ticket.
The first one is for port 80 access to the XI server and the second is for SSL access (port 443) but run them both to be safe.

You should see an output like below showing the status information for the XI server. If both commands fail, then we need to see the Apache configuration files from the XI server.

Code: Select all

* About to connect() to xxx.xxx.xxx.xxx port 80 (#0)
*   Trying 1xxx.xxx.xxx.xxx... connected
* Connected to xxx.xxx.xxx.xxx (xxx.xxx.xxx.xxx) port 80 (#0)
> GET /nagiosxi/api/v1/system/status?fusekey=YYYYYYYYYYYYYYYYYYYYYYYY HTTP/1.1
> User-Agent: curl/7.19.7 (x86_64-redhat-linux-gnu) libcurl/7.19.7 NSS/3.15.3 zlib/1.2.3 libidn/1.18 libssh2/1.4.2
> Host: xxx.xxx.xxx.xxx
> Accept: */*
> 
< HTTP/1.1 200 OK
< Date: Wed, 14 Mar 2018 18:11:09 GMT
< Server: Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips mod_fcgid/2.3.9 PHP/5.6.32
< X-Powered-By: PHP/5.6.32
< Access-Control-Allow-Orgin: *
< Access-Control-Allow-Methods: *
< Content-Length: 834
< Content-Type: application/json
< 
{"instance_id":"1","instance_name":"localhost","status_update_time":"2018-03-14 13:11:08","program_start_time":"2018-03-14 11:03:54","program_run_time":"7636","program_end_time":"0000-00-00 00:00:00","is_currently_running":"1","process_id":"4599","daemon_mode":"1","last_command_check":"1969-12-31 18:00:00","last_log_rotation":"1969-12-31 18:00:00","notifications_enabled":"0","active_service_checks_enabled":"1","passive_service_checks_enabled":"1","active_host_checks_enabled":"1","passive_host_checks_enabled":"1","event_handlers_enabled":"1","flap_detection_enabled":"1","process_performance_data":"1","obsess_over_hosts":"0","obsess_over_services":"0","modified_host_attributes":"1","modified_service_attributes":"1","global_host_event_handler":"xi_host_event_handler","global_service_event_handler":"xi_service_event_handler"}
* Connection #0 to host xxx.xxx.xxx.xxx left intact

Posted: **Mon Mar 19, 2018 6:46 am**

Code: Select all

[root@hostname ~]# curl -XGET http://IPADDRESS /nagiosxi/api/v1/system/status?fusekey=F87BE76A2B3A92509F394F30C576D599 -k -v
* About to connect() to IPADDRESS  port 80 (#0)
*   Trying IPADDRESS ...
* Connected to IPADDRESS  (IPADDRESS ) port 80 (#0)
> GET /nagiosxi/api/v1/system/status?fusekey=F87BE76A2B3A92509F394F30C576D599 HTTP/1.1
> User-Agent: curl/7.29.0
> Host: IPADDRESS 
> Accept: */*
>
< HTTP/1.1 200 OK
< Date: Mon, 19 Mar 2018 14:05:56 GMT
< Server: Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.1e-fips PHP/5.4.16
< X-Powered-By: PHP/5.4.16
< Access-Control-Allow-Orgin: *
< Access-Control-Allow-Methods: *
< Content-Length: 836
< Content-Type: application/json
<
{"instance_id":"1","instance_name":"localhost","status_update_time":"2018-03-19 10:05:55","program_start_time":"2018-03-17 09:41:21","program_run_time":"174275","program_end_time":"0000-00-00 00:00:00","is_currently_running":"1","process_id":"1847","daemon_mode":"1","last_command_check":"1969-12-31 19:00:00","last_log_rotation":"2018-03-18 23:59:59","notifications_enabled":"1","active_service_checks_enabled":"1","passive_service_checks_enabled":"1","active_host_checks_enabled":"1","passive_host_checks_enabled":"1","event_handlers_enabled":"1","flap_detection_enabled":"1","process_performance_data":"1","obsess_over_hosts":"0","obsess_over_services":"0","modified_host_attributes":"0","modified_service_attributes":"0","global_host_event_handler":"xi_host_event_handler","global_service_event_handler":"xi_service_event_handler"}
* Connection #0 to host IPADDRESS  left intact

Code: Select all

[root@HOSTNAME ~]# curl -XGET https://IPADDRESS /nagiosxi/api/v1/system/status?fusekey=F87BE76A2B3A92509F394F30C576D599 -k -v
* About to connect() to IPADDRESS  port 443 (#0)
*   Trying IPADDRESS ...
* Connected to IPADDRESS (IPADDRESS ) port 443 (#0)
* Initializing NSS with certpath: sql:/etc/pki/nssdb
* skipping SSL peer certificate verification
* SSL connection using TLS_DHE_RSA_WITH_AES_128_CBC_SHA
* Server certificate:
*       subject: E=root@HOSTNAME,CN=HOSTNAME,OU=SomeOrganizationalUnit,O=SomeOrganization,L=SomeCity,ST=SomeState,C=--
*       start date: May 31 14:58:06 2017 GMT
*       expire date: May 31 14:58:06 2018 GMT
*       common name: IPADDRESS 
*       issuer: E=root@IPADDRESS ,CN=IPADDRESS ,OU=SomeOrganizationalUnit,O=SomeOrganization,L=SomeCity,ST=SomeState,C=--
> GET /nagiosxi/api/v1/system/status?fusekey=F87BE76A2B3A92509F394F30C576D599 HTTP/1.1
> User-Agent: curl/7.29.0
> Host: IPADDRESS 
> Accept: */*
>
< HTTP/1.1 200 OK
< Date: Mon, 19 Mar 2018 14:12:37 GMT
< Server: Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.1e-fips PHP/5.4.16
< X-Powered-By: PHP/5.4.16
< Access-Control-Allow-Orgin: *
< Access-Control-Allow-Methods: *
< Content-Length: 836
< Content-Type: application/json
<
{"instance_id":"1","instance_name":"localhost","status_update_time":"2018-03-19 10:12:37","program_start_time":"2018-03-17 09:41:21","program_run_time":"174676","program_end_time":"0000-00-00 00:00:00","is_currently_running":"1","process_id":"1847","daemon_mode":"1","last_command_check":"1969-12-31 19:00:00","last_log_rotation":"2018-03-18 23:59:59","notifications_enabled":"1","active_service_checks_enabled":"1","passive_service_checks_enabled":"1","active_host_checks_enabled":"1","passive_host_checks_enabled":"1","event_handlers_enabled":"1","flap_detection_enabled":"1","process_performance_data":"1","obsess_over_hosts":"0","obsess_over_services":"0","modified_host_attributes":"0","modified_service_attributes":"0","global_host_event_handler":"xi_host_event_handler","global_service_event_handler":"xi_service_event_handler"}
* Connection #0 to host IPADDRESS left intact

Posted: **Mon Mar 19, 2018 2:30 pm**

Did you look in the /usr/local/nagiosfusion/var/log/auth_subsys.log file on the Fusion server for any authentication errors when connecting to that Nagios XI server?

Posted: **Tue Mar 20, 2018 7:34 am**

you mean this :

2018-03-13 08:11:34[s: 0, u: 0] Checking authentication for server: ( [server_id] => 17, [enabled] => 1, [auto_login] => 1, [name] => Ashburn, [address] => , [server_type] => 1, [authentication_type] => 0, [url] => http://hostname/nagiosxi, [cgi_bin] => , [location] => Ashburn, [notes] => , [fusekey] => F87BE76A2B3A92509F394F30C576D599, [username] => username, [password] => password, [last_auth_time] => 2018-03-13 08:11:07, [polling_interval] => 0, [auth_interval] => 0, [ignore_xi_meta] => 0, [timezone] => America/Los_Angeles, [logserver_token] => , [version] => , [last_auth_unix] => 1520953867 )

PHP Warning: include_once(): Failed opening '/usr/local/nagiosfusion/html/includes/dashlets/statusinfo/../dashlethelper.inc.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php') in /usr/local/nagiosfusion/html/includes/dashlets/statusinfo/statusinfo.inc.php on line 6
PHP Warning: include_once(/usr/local/nagiosfusion/html/includes/dashlets/statusinfo/../dashlethelper.inc.php): failed to open stream: No such file or directory in /usr/local/nagiosfusion/html/includes/dashlets/statusinfo/statusinfo.inc.php on line 6
PHP Warning: include_once(): Failed opening '/usr/local/nagiosfusion/html/includes/dashlets/statusinfo/../dashlethelper.inc.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php') in /usr/local/nagiosfusion/html/includes/dashlets/statusinfo/statusinfo.inc.php on line 6

an addtional error occured!
I don't see any information from 2 instances in the Dashlets but it possible to login to the nagios xi instance through the dashboard.
Please check the attachments!

We have been working on the case since December still have no solution. Is there a possibility of a remote support?

Nagios Support Forum

Nagios Fusion Hostgroup Dashboard

Re: Nagios Fusion Hostgroup Dashboard

Re: Nagios Fusion Hostgroup Dashboard

Re: Nagios Fusion Hostgroup Dashboard

Re: Nagios Fusion Hostgroup Dashboard

Re: Nagios Fusion Hostgroup Dashboard

Re: Nagios Fusion Hostgroup Dashboard

Re: Nagios Fusion Hostgroup Dashboard

Re: Nagios Fusion Hostgroup Dashboard

Re: Nagios Fusion Hostgroup Dashboard

Re: Nagios Fusion Hostgroup Dashboard