librenms@kx-nms:~$ ./poller.php -h kx-dns-01.cmn.local -m applications -d
LibreNMS 2015.master Poller
Version info:
Commit SHA: 1fe334690c5913159db40f32e165971467b92f66
Commit Date: 2016-08-01 22:38:24 +1000
DB Schema: 126
PHP: 5.6.19-0+deb8u1
MySQL: 5.5.47-0+deb8u1
RRDTool: 1.4.8
SNMP: NET-SNMP version: 5.7.2.1

DEBUG!
Starting polling run:


SQL[SELECT `device_id` FROM `devices` WHERE `disabled` = 0 AND `hostname` LIKE 'kx-dns-01.cmn.local' ORDER BY `device_id` ASC]
SQL[SELECT * FROM `devices` WHERE `device_id` = '139']
SQL[SELECT * FROM `vrf_lite_cisco` WHERE `device_id` = '139']
SQL[SELECT * FROM devices_attribs WHERE `device_id` = '139'] kx-dns-01.cmn.local 139 linux (unix)

SQL[INSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`)  VALUES ('3','3','0','0.13','0.21','0.16','139',NOW())] /usr/bin/snmpget -v2c -c COMMUNITY -Oqv -m SNMPv2-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 sysObjectID.0SNMPv2-SMI::enterprises.8*

/usr/bin/snmpget -v2c -c COMMUNITY -OQnUst -m SNMPv2-MIB:HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 sysUpTime.0 sysLocation.0 sysContact.0 sysName.0 sysObjectID.0sysUpTime.0 = 1026056
sysLocation.0 = Fallenriede 13, 49451 Holdorf
sysContact.0 = Vitali Kari <vitali.kari@komnexx.de>
sysName.0 = kx-dns-01
sysObjectID.0 = enterprises.8*

/usr/bin/snmpget -v2c -c COMMUNITY -OvQ -m SNMPv2-MIB:HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 sysDescr.0Linux kx-dns-01 3.16.0-4-amd64 #1 SMP Debian 3.16.7-ckt25-2 (2016-04-08) x86_64

/usr/bin/snmpget -v2c -c COMMUNITY -OQnUst -m HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 snmpEngineTime.0 hrSystemUptime.0snmpEngineTime.0 = 10260
hrSystemUptime.0 = 1026832

Using hrSystemUptime (10268s)
RRD[update /opt/librenms/rrd/kx-dns-01.cmn.local/uptime.rrd N:10268] Uptime: 2h 51m 8s

SQL[SELECT `lat`,`lng` FROM `locations` WHERE `location`='Fallenriede 13, 49451 Holdorf' LIMIT 1] Using cached lat/lng from other device

#### Load poller module applications ####
SELECT * FROM `applications` WHERE `device_id`  = '139'

SQL[SELECT * FROM `applications` WHERE `device_id`  = '139'] /usr/bin/snmpget -v2c -c COMMUNITY -O qv -m NET-SNMP-EXTEND-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 nsExtendOutputFull.8.112.111.119.101.114.100.110.1152
0
0
0
257291
206420
4053
0
10885
78052
8811
8811
2
0
1
0
276978
276978
268167
276978
0
0

 powerdnsOK u:0.00 s:0.00 r:0.53
RRD[update /opt/librenms/rrd/kx-dns-01.cmn.local/app-powerdns-2.rrd N:2:0:0:0:257291:206420:4053:0:10885:78052:8811:8811:2:0:1:0:276978:276978:268167:276978:0:0] /usr/bin/snmpget -v2c -c COMMUNITY -O qv -M /opt/librenms/mibs udp:HOSTNAME:161 nsExtendOutputFull.6.97.112.97.99.104.101nsExtendOutputFull.6.97.112.97.99.104.101: Unknown Object Identifier (Sub-id not found: (top) -> nsExtendOutputFull)

 apacheOK u:0.00 s:0.00 r:0.60
RRD[update /opt/librenms/rrd/kx-dns-01.cmn.local/app-apache-4.rrd N:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U:U] Expected LAST-UPDATED (SMI): At line 35 in /opt/mibs/SNMPv2-SMI.MIB
 mysqlOK u:0.00 s:0.00 r:0.63
RRD[update /opt/librenms/rrd/kx-dns-01.cmn.local/app-mysql-13.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] ERROR: /opt/librenms/rrd/kx-dns-01.cmn.local/app-mysql-13.rrd: not a simple unsigned integer: '-1'
RRD[update /opt/librenms/rrd/kx-dns-01.cmn.local/app-mysql-13-status.rrd N:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1:-1] /usr/bin/snmpget -v2c -c COMMUNITY -O qv -m NET-SNMP-EXTEND-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 nsExtendOutputFull.10.110.116.112.100.115.101.114.118.101.1142
26.120
-11.868
14.610
2.923
1.986
10242
10
9
0
0
0
439
441

 ntpd-serverOK u:0.00 s:0.00 r:0.68
RRD[update /opt/librenms/rrd/kx-dns-01.cmn.local/app-ntpdserver-17.rrd N:2:26.120:-11.868:14.610:2.923:1.986:10242:10:9:0:0:0:439:441]  powerdns-recrusor

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

OK u:0.00 s:0.00 r:0.74
RRD[update /opt/librenms/rrd/kx-dns-01.cmn.local/poller-perf-applications.rrd N:0.20258688926697]
SQL[SELECT * FROM device_groups ORDER BY name]
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'devices' && COLUMN_NAME = 'device_id']
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='139' AND (devices.location REGEXP ".*Bersenbrück" || devices.hostname REGEXP "kx-ber.*" ) LIMIT 1]
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'devices' && COLUMN_NAME = 'device_id']
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='139' AND (devices.sysName REGEXP ".*dar.*" || devices.hostname REGEXP "dar.*" ) LIMIT 1]
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'devices' && COLUMN_NAME = 'device_id']
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='139' AND (devices.sysName REGEXP ".*dre.*" || devices.hostname REGEXP "kx-dre.*" ) LIMIT 1]
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'devices' && COLUMN_NAME = 'device_id']
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='139' AND (devices.os = "enterasys" ) LIMIT 1]
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'ports' && COLUMN_NAME = 'device_id']
SQL[SELECT DISTINCT(ports.device_id) FROM ports WHERE  ports.device_id='139' AND (ports.port_descr_circuit REGEXP "FV.*" ) LIMIT 1]
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'devices' && COLUMN_NAME = 'device_id']
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='139' AND (devices.hostname REGEXP "gra.*" || devices.location REGEXP ".*Suhlendorf" ) LIMIT 1]
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'devices' && COLUMN_NAME = 'device_id']
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='139' AND (devices.sysName REGEXP ".*par.*" || devices.sysName REGEXP ".*fur.*" || devices.hostname REGEXP "par.*" || devices.hostname REGEXP "fur.*" ) LIMIT 1]
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'devices' && COLUMN_NAME = 'device_id']
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='139' AND (devices.os = "pbn" ) LIMIT 1]
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'devices' && COLUMN_NAME = 'device_id']
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='139' AND (devices.os = "pbn" && devices.sysName = "CP120" ) LIMIT 1]
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'devices' && COLUMN_NAME = 'device_id']
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='139' AND (devices.sysName REGEXP ".*veh.*" || devices.hostname REGEXP "veh.*" ) LIMIT 1]
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'devices' && COLUMN_NAME = 'device_id']
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='139' AND (devices.location REGEXP ".*Wallenhorst" || devices.hostname REGEXP "kx-wah.*" ) LIMIT 1]
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'devices' && COLUMN_NAME = 'device_id']
SQL[SELECT DISTINCT(devices.device_id) FROM devices WHERE  devices.device_id='139' AND (devices.sysName REGEXP ".*war.*" || devices.hostname REGEXP "kx-war.*" ) LIMIT 1]
SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='139'] OK u:0.00 s:0.00 r:0.74
RRD[update /opt/librenms/rrd/kx-dns-01.cmn.local/poller-perf.rrd N:0.755] OK u:0.00 s:0.00 r:0.75
RRD[update /opt/librenms/rrd/kx-dns-01.cmn.local/ping-perf.rrd N:0.16] Polled in 0.755 seconds
Updating kx-dns-01.cmn.local
Array
(
    [uptime] => 10268
    [last_ping] => Array
        (
            [0] => NOW()
        )

    [last_ping_timetaken] => 0.16
    [last_polled] => Array
        (
            [0] => NOW()
        )

    [last_polled_timetaken] => 0.755
)

SQL[UPDATE `devices` set `uptime` ='10268',`last_ping` =NOW(),`last_ping_timetaken` ='0.16',`last_polled` =NOW(),`last_polled_timetaken` ='0.755' WHERE `device_id` = '139'] UPDATED!

SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='139']
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 = '139' ) && NOW() BETWEEN alert_schedule.start AND alert_schedule.end LIMIT 1]
SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='139']
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 = '139' ) || alert_map.target = '139'  )]  #2:
SQL[SELECT state FROM alerts WHERE rule_id = '2' && device_id = '139' 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 = '139') && (devices.status = "down"    &&  devices.os != "multimatic"                       )]  NOCHG  #5:
SQL[SELECT state FROM alerts WHERE rule_id = '5' && device_id = '139' ORDER BY id DESC LIMIT 1]
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'storage' && COLUMN_NAME = 'device_id']
SQL[SELECT * FROM storage WHERE (storage.device_id = '139') && (storage.storage_perc > "85"    &&  storage.storage_descr NOT REGEXP ".*junos"          &&  storage.storage_descr NOT REGEXP "vmfs"    &&  storage.storage_descr NOT REGEXP "SWAP"    &&  storage.storage_descr NOT REGEXP "PageFile"    &&  storage.storage_descr NOT REGEXP "CODEMETER" )]  NOCHG  #10:
SQL[SELECT state FROM alerts WHERE rule_id = '10' && device_id = '139' ORDER BY id DESC LIMIT 1]
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'devices' && COLUMN_NAME = 'device_id']
SQL[SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_NAME = 'ports' && COLUMN_NAME LIKE "%\_id"]
SQL[SELECT * FROM devices,ports WHERE (( ports.device_id = devices.device_id ) && devices.device_id = '139') && (devices.hostname NOT REGEXP "10.2.30..*"      &&  ports.ifInOctets_rate >= "90000000/8"   )]  NOCHG  #11:
SQL[SELECT state FROM alerts WHERE rule_id = '11' && device_id = '139' ORDER BY id DESC LIMIT 1]
SQL[SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_NAME = 'devices' && COLUMN_NAME = 'device_id']
SQL[SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_NAME = 'ports' && COLUMN_NAME LIKE "%\_id"]
SQL[SELECT * FROM devices,ports WHERE (( ports.device_id = devices.device_id ) && devices.device_id = '139') && (devices.hostname NOT REGEXP "10.2.30..*"      &&  ports.ifOutOctets_rate >= "90000000/8"   )]  NOCHG  #12:
SQL[SELECT state FROM alerts WHERE rule_id = '12' && device_id = '139' 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 = '139') && (sensors.sensor_descr = "Seconds on Battery"  &&  sensors.sensor_current > "60"   )]  NOCHG  #13:
SQL[SELECT state FROM alerts WHERE rule_id = '13' && device_id = '139' 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 = '139') && ( (  (  ( ports.ifInOctets_rate*8 =>  ( 85*1024*1024 )  )   ||   ( ports.ifOutOctets_rate*8 =>  ( 85*1024*1024 )  )  )   &&  ports.port_descr_type = "transit"      )]  NOCHG  #14:
SQL[SELECT state FROM alerts WHERE rule_id = '14' && device_id = '139' 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 = '139') && (services.service_status = "1" )]  NOCHG  #15:
SQL[SELECT state FROM alerts WHERE rule_id = '15' && device_id = '139' 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 = '139') && (services.service_status = "2"   )]  NOCHG

SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`)  VALUES ('poll','kx-dns-01.cmn.local','1470138387.7492','0.792','1','kx-nms\n')] ./poller.php kx-dns-01.cmn.local 2016-08-02 13:46:28 - 1 devices polled in 0.792 secs

MySQL: Cell[13/0s] Row[45/0.02s] Rows[12/0s] Column[3/0s] Update[1/0s] Insert[2/0s] Delete[0/0s]
OK u:0.00 s:0.00 r:0.75