Nginx & MySQL application graphs not functioning

I have been trying to get application support working for Nginx and MySQL data. So far I have followed the documentation and I do get output from the application specific scripts as follows:

iain@BB-TSTSRV1 /usr/lib/check_mk_agent/local $ ./nginx 
<<<nginx>>>

1
0
1
0 
7138

…and also for MySQL:

iain@BB-TSTSRV1 /usr/lib/check_mk_agent/local $ ./mysql | tail
eb:-1
ec:-1
ed:-1
ee:-1
ef:-1
eg:0
eh:3066880
ei:16777216
ej:35829
ek:394

However, the resulting graphs on this localhost (and same with remote nodes) displays no data in the graphs, just a -nan result in each graph.

I am running the latest code and everything appears healthy when executing ./validate.php:

iain@BB-TSTSRV1 /home/webhost/sites/librenms $ sudo ./validate.php 
==========================================================
LibreNMS Version: 12c4b8acb23b7346f2a5e9ab061f3f8970cbfc5e
DB Schema: 141
PHP: 7.0.11-1~dotdeb+8.1
MySQL: 10.1.14-MariaDB-1~jessie
RRDTool: 1.4.8
SNMP: NET-SNMP 5.7.2.1
==========================================================

[OK]    Database connection successful

Could someone please assist in pointing out where I might be going wrong?

Post the output of ./poller.php -h HOSTNAME -d -r -f -m applications

@laf: as requested, sir!

iain@BB-TSTSRV1 /home/webhost/sites/librenms $ ./poller.php -h HOSTNAME -d -r -f -m applications
LibreNMS Poller
Version info:
Commit SHA: 92983042622a3cc9097185de420578ab5ed3546b
Commit Date: 1475788880
DB Schema: 142
PHP: 7.0.11-1~dotdeb+8.1
MySQL: 10.1.14-MariaDB-1~jessie
RRDTool: 1.4.8
SNMP: NET-SNMP 5.7.2.1
DEBUG!
Starting polling run:

SQL[SELECT `device_id` FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'HOSTNAME' ORDER BY `device_id` ASC] 
SQL[SELECT * FROM `devices` WHERE `device_id` = 5] 
SQL[SELECT * FROM `vrf_lite_cisco` WHERE `device_id` = 5] 
SQL[SELECT * FROM devices_attribs WHERE `device_id` = '5'] 
HOSTNAME 5 linux (unix)
SQL[INSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`)  VALUES ('3','3','0','44.6','45.2','44.9','5',NOW())] 
SNMP[/usr/bin/snmpget -v3 -n '' -l 'authPriv' -a 'SHA' -A 'remember to change this one too' -u 'SNMPAUTH' -x 'DES' -X 'remember to change this one too' -Oqv -m SNMPv2-MIB -M /home/webhost/sites/librenms/mibs udp:HOSTNAME:161 sysObjectID.0]
SNMPv2-SMI::enterprises.8*

SNMP[/usr/bin/snmpget -v3 -n '' -l 'authPriv' -a 'SHA' -A 'remember to change this one too' -u 'SNMPAUTH' -x 'DES' -X 'remember to change this one too' -OQnUst -m SNMPv2-MIB:HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /home/webhost/sites/librenms/mibs udp:HOSTNAME:161 sysUpTime.0 sysLocation.0 sysContact.0 sysName.0 sysObjectID.0]
sysUpTime.0 = 276124523
sysLocation.0 = Hetzner, DE
sysContact.0 = CONTACT
sysName.0 = HOSTNAME
sysObjectID.0 = enterprises.8*

SNMP[/usr/bin/snmpget -v3 -n '' -l 'authPriv' -a 'SHA' -A 'remember to change this one too' -u 'SNMPAUTH' -x 'DES' -X 'remember to change this one too' -OvQ -m SNMPv2-MIB:HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /home/webhost/sites/librenms/mibs udp:HOSTNAME:161 sysDescr.0]
Linux bb-websrv3 3.16.0-4-amd64 #1 SMP Debian 3.16.7-ckt25-2+deb8u3 (2016-07-02) x86_64

SNMP[/usr/bin/snmpget -v3 -n '' -l 'authPriv' -a 'SHA' -A 'remember to change this one too' -u 'SNMPAUTH' -x 'DES' -X 'remember to change this one too' -OQnUst -m HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /home/webhost/sites/librenms/mibs udp:HOSTNAME:161 snmpEngineTime.0 hrSystemUptime.0]
snmpEngineTime.0 = 2761245
hrSystemUptime.0 = 276125075

Using hrSystemUptime (2761250s)
RRD[update /home/webhost/sites/librenms/rrd/HOSTNAME/uptime.rrd N:2761250]
[RRD Disabled]Uptime: 31 days, 23h 50s

#### Load poller module applications ####
SELECT * FROM `applications` WHERE `device_id`  = '5'
SQL[SELECT * FROM `applications` WHERE `device_id`  = '5'] 
 mysqlRRD[update /home/webhost/sites/librenms/rrd/HOSTNAME/app-mysql-3.rrd N:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1]
[RRD Disabled]RRD[update /home/webhost/sites/librenms/rrd/HOSTNAME/app-mysql-3-status.rrd N:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1]
[RRD Disabled]SNMP[/usr/bin/snmpget -v3 -n '' -l 'authPriv' -a 'SHA' -A 'remember to change this one too' -u 'SNMPAUTH' -x 'DES' -X 'remember to change this one too' -Ovq -m NET-SNMP-EXTEND-MIB -M /home/webhost/sites/librenms/mibs udp:HOSTNAME:161 nsExtendOutputFull.5.110.103.105.110.120]
No Such Instance currently exists at this OID

 nginxactive:  reading:  writing:  waiting:  Requests: RRD[update /home/webhost/sites/librenms/rrd/HOSTNAME/app-nginx-4.rrd N:U:U:U:U:U]
[RRD Disabled]

>> Runtime for poller module 'applications': 0.369225025177 seconds
#### Unload poller module applications ####

RRD[update /home/webhost/sites/librenms/rrd/HOSTNAME/poller-perf-applications.rrd N:0.369225025177]
[RRD Disabled]### Start Device Groups ###
SQL[SELECT * FROM device_groups ORDER BY name] 
SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='5'] 
Groups Added: 
Groups Removed: 
### End Device Groups ###
RRD[update /home/webhost/sites/librenms/rrd/HOSTNAME/poller-perf.rrd N:1.500]
[RRD Disabled]RRD[update /home/webhost/sites/librenms/rrd/HOSTNAME/ping-perf.rrd N:44.9]
[RRD Disabled]Polled in 1.500 seconds
Updating HOSTNAME
SQL[UPDATE `devices` set `uptime` ='2761250',`last_ping` =NOW(),`last_ping_timetaken` ='44.9',`last_polled` =NOW(),`last_polled_timetaken` ='1.500' WHERE `device_id` = '5'] 
UPDATED!
#### Start Alerts ####
SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='5'] 
SQL[SELECT alert_schedule.schedule_id FROM alert_schedule LEFT JOIN alert_schedule_items ON alert_schedule.schedule_id=alert_schedule_items.schedule_id WHERE ( alert_schedule_items.target = '5' ) && NOW() BETWEEN alert_schedule.start AND alert_schedule.end LIMIT 1] 
SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='5'] 
SQL[SELECT alert_rules.* FROM alert_rules LEFT JOIN alert_map ON alert_rules.id=alert_map.rule WHERE alert_rules.disabled = 0 && ( (alert_rules.device_id = -1 || alert_rules.device_id = '5' ) || alert_map.target = '5'  )] 
Rule #1 (Devices up/down): 
SQL[SELECT state FROM alerts WHERE rule_id = '1' && device_id = '5' ORDER BY id DESC LIMIT 1] 
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'devices' && COLUMN_NAME = 'device_id'] 
SQL[SELECT * FROM devices WHERE (devices.device_id = '5') && ( (  ( devices.status = 0  &&   (  ( devices.disabled = 0  &&  devices.ignore = 0 )  )  )  )  = "1")] 
Status: NOCHG
Rule #2 (Device rebooted): 
SQL[SELECT state FROM alerts WHERE rule_id = '2' && device_id = '5' ORDER BY id DESC LIMIT 1] 
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'devices' && COLUMN_NAME = 'device_id'] 
SQL[SELECT * FROM devices WHERE (devices.device_id = '5') && (devices.uptime < "300"  &&   (  ( devices.disabled = 0  &&  devices.ignore = 0 )  )  = "1")] 
Status: NOCHG
Rule #5 (Port status up/down): 
SQL[SELECT state FROM alerts WHERE rule_id = '5' && device_id = '5' ORDER BY id DESC LIMIT 1] 
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'ports' && COLUMN_NAME = 'device_id'] 
SQL[SELECT * FROM ports WHERE (ports.device_id = '5') && ( (  ( ports.ifOperStatus = "down"  &&  ports.ifAdminStatus != "down"  &&   (  ( ports.deleted = 0  &&  ports.ignore = 0  &&  ports.disabled = 0 )  )  )  )  = "1")] 
Status: NOCHG
Rule #6 (Port utilisation over threshold): 
SQL[SELECT state FROM alerts WHERE rule_id = '6' && device_id = '5' ORDER BY id DESC LIMIT 1] 
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'ports' && COLUMN_NAME = 'device_id'] 
SQL[SELECT * FROM ports WHERE (ports.device_id = '5') && ( (  (  ( ports.ifInOctets_rate*8 )  / ports.ifSpeed ) *100 )  >= "80"  &&   (  ( ports.ifOperStatus = "up"  &&  ports.ifAdminStatus = "up"  &&   (  ( ports.deleted = 0  &&  ports.ignore = 0  &&  ports.disabled = 0 )  )  )  )  = "1"  &&   (  ( ports.deleted = 0  &&  ports.ignore = 0  &&  ports.disabled = 0 )  )  = "1")] 
Status: NOCHG
Rule #7 (Sensor over limit): 
SQL[SELECT state FROM alerts WHERE rule_id = '7' && device_id = '5' ORDER BY id DESC LIMIT 1] 
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'sensors' && COLUMN_NAME = 'device_id'] 
SQL[SELECT * FROM sensors WHERE (sensors.device_id = '5') && (sensors.sensor_current > sensors.sensor_limit  &&  sensors.sensor_alert = "1")] 
Status: NOCHG
Rule #8 (Sensor under limit): 
SQL[SELECT state FROM alerts WHERE rule_id = '8' && device_id = '5' ORDER BY id DESC LIMIT 1] 
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'sensors' && COLUMN_NAME = 'device_id'] 
SQL[SELECT * FROM sensors WHERE (sensors.device_id = '5') && (sensors.sensor_current < sensors.sensor_limit_low  &&  sensors.sensor_alert = "1")] 
Status: NOCHG
Rule #9 (Service up/down): 
SQL[SELECT state FROM alerts WHERE rule_id = '9' && device_id = '5' ORDER BY id DESC LIMIT 1] 
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'services' && COLUMN_NAME = 'device_id'] 
SQL[SELECT * FROM services WHERE (services.device_id = '5') && (services.service_status != "0")] 
Status: NOCHG
#### End Alerts ####
SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`)  VALUES ('poll','HOSTNAME','1475823132.0463','1.710','1','BB-TSTSRV1\n')] 
./poller.php HOSTNAME 2016-10-07 08:52:13 - 1 devices polled in 1.710 secs

MySQL: Cell[1/0s] Row[18/0.01s] Rows[12/0.12s] Column[3/0s] Update[1/0.06s] Insert[2/0.12s] Delete[0/0s]

That’s moving on to try snmp extended output so we aren’t seeing <<<nginx>>> in the output.

Can you telnet to the check_mk agent port and provide that output pls.

@laf: Many thanks for your help. Your pointing me in this direction prompted me to run through the process from the start again. All working now. No idea what the initial goof-up was, but all working now. Got a bitcoin address I can send some love to?

Glad you got it sorted. No need for bitcoin donation though.