No servers have checked in with data yet

[blariv]

hi,

have a new install of fusion and had my one fused server showing data last week I logged in today and get that error message. I do not see anything going on in the fusion logs and just turned on debugging.

Installed Version: 4.1.8

[ssax]

Please attach your /etc/php.ini.

Additionally, send me the full output of this command (as root):
- NOTE: You may need to adjust the -h 127.0.0.1, the -uroot, and -pfusion in the command if your DB is offloaded to another server and/or you've changed the root mysql password

Code: Select all

echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('fusion');" | mysql -h 127.0.0.1 -uroot -pfusion --table​

Is the fused server an XI server or a Core server? What specific version?

Please edit the Server in the Fusion interface, and click the Test Fusion Settings button, does it work?

Then run these commands (as root):

Code: Select all

cd /usr/local/nagiosfusion/scripts/
./truncate_polled.php

Then in the Nagios Fusion web interface go to Admin > System Settings:
- Set Log Level to trace
- Check the box next to Enable writing log data to the specified file
- Check the box next to Enable writing debug data to the specified file.

Then in that same SSH session, please run this command (as root) and LEAVE IT RUNNING:

Code: Select all

tail -Fn0 /var/log/messages /var/log/cron /var/log/httpd/error_log /var/log/httpd/ssl_error_log /usr/local/nagiosfusion/var/log/*.log

Then go to Admin in the web interface and under the "Subsys Status" section, click the gear icon to the right of Polling Locks and then click the "Clear polling locks" button.

Now wait 10 minutes and send me the full output from the still running tail command above.

The following example is a command you can run as root on the Fusion server to see if it can connect to the remote Nagios server using the fusekey.

Run the following replacing the nagiosxiserver with the XI server's host name and the xxxxxxxxxxxxxxxxxxxxxxxx with the fusion key.

Code: Select all

curl -XGET https://nagiosxiserver/nagiosxi/api/v1/system/status?fusekey=xxxxxxxxxxxxxxxxxxxxxxxx -k -L -v

[blariv]

logs attached

+-----------------+------------+
| Table | Size in MB |
+-----------------+------------+
| auth_tokens | 0.03 |
| commands | 0.02 |
| dashboards | 0.02 |
| dashlets | 0.02 |
| dashlets_params | 0.02 |
| log | 0.02 |
| meta | 0.02 |
| options | 0.02 |
| polled_averages | 0.03 |
| polled_data | 0.02 |
| polled_deltas | 0.03 |
| polled_extras | 0.03 |
| polling_lock | 0.02 |
| servers | 0.03 |
| sysstat | 0.03 |
| users | 0.03 |
| users_servers | 0.02 |
| users_sessions | 0.03 |
| views | 0.02 |
+-----------------+------------+

XI server - 5.5.7

Test Fusion settings both green

there were no polling locks

[root@nagiosfusion ~]# curl -XGET https://nagiosxi/nagiosxi/api/v1/system ... 8B54B1AAA9 -k -L -v
* About to connect() to nagiosxi port 443 (#0)
* Trying 10.3.35.139...
* Connected to nagiosxi (10.3.35.139) port 443 (#0)
* Initializing NSS with certpath: sql:/etc/pki/nssdb
* skipping SSL peer certificate verification
* SSL connection using TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
* Server certificate:
* subject: CN=nagiosxi.hasbro.com,OU=Information System,O="Hasbro, Inc.",L=East Providence,ST=Rhode Island,C=US
* start date: Mar 11 19:18:00 2019 GMT
* expire date: Mar 10 19:18:00 2023 GMT
* common name: nagiosxi.hasbro.com
* issuer: CN=Hasbro Ent1 CA,DC=na,DC=hasbro,DC=com
> GET /nagiosxi/api/v1/system/status?fusekey=C9EF8E6AA7D7CE3FD52E4A8B54B1AAA9 HTTP/1.1
> User-Agent: curl/7.29.0
> Host: nagiosxi
> Accept: */*
>
< HTTP/1.1 200 OK
< Date: Tue, 21 Apr 2020 20:53:54 GMT
< Server: Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.2k-fips mod_fcgid/2.3.9 PHP/5.4.16
< X-Powered-By: PHP/5.4.16
< Access-Control-Allow-Orgin: *
< Access-Control-Allow-Methods: *
< Content-Length: 838
< Content-Type: application/json
<
{"instance_id":"1","instance_name":"localhost","status_update_time":"2020-04-21 16:53:53","program_start_time":"2020-04-19 23:00:04","program_run_time":"150830","program_end_time":"0000-00-00 00:00:00","is_currently_running":"1","process_id":"8357","daemon_mode":"1","last_command_check":"1969-12-31 19:00:00","last_log_rotation":"2020-04-20 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":"0","flap_detection_enabled":"0","process_performance_data":"1","obsess_over_hosts":"0","obsess_over_services":"0","modified_host_attributes":"95","modified_service_attributes":"95","global_host_event_handler":"xi_host_event_handler","global_service_event_handler":"xi_service_event_handler"}
* Connection #0 to host nagiosxi left intact

[tgriep]

The following command is the API call that the fusion server is running against the Nagios XI server. I added time to the command so we can see how long it takes to run.
Run the commands as root on the Fusion server.

Code: Select all

time curl -XGET http://10.10.10.10/nagiosxi/api/v1/objects/servicestatus?fusekey=<FUSEKEY>&outputtype=xml&user=nagiosadmin&records=1000:0?brevity=1

Try running it and replace the IP address and the <FUSEKEY> to actual values and the nagiosadmin user name if you are not using that for the credentials. Let us know how it works out.
If the XI server has SSL enabled, use https://

Run these commands and post the output here.

Code: Select all

tail -100 /usr/local/nagiosfusion/var/log/auth_subsys.log
ps -ef --cols=300 |grep nagios

Thanks.

[blariv]

first command just basically crashed the server, see screenshot

send and third commands outputs attached.

[blariv]

you can close and lock this.

I ended up just redeploying the fusion appliance.
thanks!