- LibreNMS Poller
- SQL[[1;33mselect `version` from `dbSchema` order by `version` desc limit 1 [0;33m[][0m 0.26ms]
- SQL[[1;33mSELECT version() [0;33m[][0m 0.21ms]
- ===================================
- Version info:
- Commit SHA: 3ed20e5f300c77349476f7f3ed12c9f401c0361b
- Commit Date: 1539914950
- DB Schema: 269
- PHP: 7.0.32-0ubuntu0.16.04.1
- MySQL: 10.0.36-MariaDB-0ubuntu0.16.04.1
- RRDTool: 1.5.5
- SNMP: NET-SNMP 5.7.3
- ==================================DEBUG!
- Updating os_def.cache... Done
- Override poller modules: toner
- Starting polling run:
- SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '130.126.110.253' ORDER BY `device_id` ASC [0;33m[][0m 3.02ms]
- SQL[[1;33mSELECT * FROM devices_attribs WHERE `device_id` = ? [0;33m[45][0m 0.2ms]
- Hostname: 130.126.110.253
- Device ID: 45
- OS: jetdirect
- Warning: inet_pton(): Unrecognized address in /opt/librenms/includes/polling/functions.inc.php on line 248
- (printer)
- [FPING] /usr/bin/fping -e -q -c 3 -p 500 -t 500 130.126.110.253
- Array
- (
- [xmt] => 3
- [rcv] => 3
- [loss] => 0
- [min] => 0.60
- [max] => 1.01
- [avg] => 0.79
- [exitcode] => 0
- )
- SQL[[1;33mINSERT IGNORE INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`) VALUES (:xmt,:rcv,:loss,:min,:max,:avg,:device_id,NOW()) [0;33m{"xmt":"3","rcv":"3","loss":"0","min":"0.60","max":"1.01","avg":"0.79","device_id":45}[0m 0.96ms]
- SNMP Check response code: 0
- Modules status: Global+ OS Device
- #### Load poller module core ####
- SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OQnUt -m SNMPv2-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 sysUpTime.0 sysLocation.0 sysContact.0 sysName.0 sysObjectID.0 sysDescr.0[0m]
- .*.*.0 = 64276031
- .*.*.0 =
- .*.*.0 =
- .*.*.0 = ih325
- .*.*.0 = .*.*.3.9.1
- .*.*.0 = HP ETHERNET MULTI-ENVIRONMENT,ROM none,JETDIRECT,JD149,EEPROM JDI23701070,CIDATE 02/24/2016
- SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OQnUst -m HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs udp:HOSTNAME:161 snmpEngineTime.0 hrSystemUptime.0[0m]
- snmpEngineTime.0 = No Such Instance currently exists at this OID
- hrSystemUptime.0 = No Such Instance currently exists at this OID
- Uptime seconds: 642760
- RRD[[0;32mupdate 130.126.110.253/uptime.rrd N:642760 --daemon unix:/var/run/rrdcached.sock[0m]
- [[0;31mRRD Disabled[0m]Uptime: 7 days, 10h 32m 40s
- >> Runtime for poller module 'core': 0.0244 seconds with 15544 bytes
- >> SNMP: [2/0.02s] MySQL: [0/0.00s] RRD: [0/0.00s]
- #### Unload poller module core ####
- RRD[[0;32mupdate 130.126.110.253/poller-perf-core.rrd N:0.0244460105896 --daemon unix:/var/run/rrdcached.sock[0m]
- [[0;31mRRD Disabled[0m]Modules status: Global+ OS+ Device
- #### Load poller module toner ####
- SQL[[1;33mSELECT * FROM toner WHERE device_id = ? [0;33m[45][0m 0.38ms]
- Checking toner Black Cartridge 90X HP CE390X.... SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OUqnv -M /opt/librenms/mibs udp:HOSTNAME:161 .1.3.6.1.2.1.43.11.1.1.9.1.1[0m]
- 19
- 19 %
- RRD[[0;32mupdate 130.126.110.253/toner-1.rrd N:19 --daemon unix:/var/run/rrdcached.sock[0m]
- [[0;31mRRD Disabled[0m]SQL[[1;33mUPDATE `toner` set `toner_current`=?,`toner_capacity`=? WHERE `toner_id` = ? [0;33m[19,100,23][0m 0.96ms]
- Checking toner Maintenance Kit HP 110V-CF064A, ... SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OUqnv -M /opt/librenms/mibs udp:HOSTNAME:161 .1.3.6.1.2.1.43.11.1.1.9.1.2[0m]
- 82
- 82 %
- RRD[[0;32mupdate 130.126.110.253/toner-2.rrd N:82 --daemon unix:/var/run/rrdcached.sock[0m]
- [[0;31mRRD Disabled[0m]SQL[[1;33mUPDATE `toner` set `toner_current`=?,`toner_capacity`=? WHERE `toner_id` = ? [0;33m[82,100,24][0m 1.06ms]
- >> Runtime for poller module 'toner': 0.0328 seconds with 7664 bytes
- >> SNMP: [2/0.03s] MySQL: [3/0.00s] RRD: [0/0.00s]
- #### Unload poller module toner ####
- RRD[[0;32mupdate 130.126.110.253/poller-perf-toner.rrd N:0.032778024673462 --daemon unix:/var/run/rrdcached.sock[0m]
- [[0;31mRRD Disabled[0m]### Start Device Groups ###
- SQL[[1;33mSELECT * FROM device_groups ORDER BY name [0;33m[][0m 0.22ms]
- SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.type = "Printer" ) LIMIT 1 [0;33m[45][0m 0.34ms]
- SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.os = "brother") LIMIT 1 [0;33m[45][0m 0.2ms]
- SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.os = "jetdirect") LIMIT 1 [0;33m[45][0m 0.24ms]
- SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.os = "xerox") LIMIT 1 [0;33m[45][0m 0.2ms]
- SQL[[1;33mSELECT `device_group_id` FROM `device_group_device` WHERE `device_id`=? [0;33m[45][0m 0.15ms]
- Groups Added:
- Groups Removed:
- ### End Device Groups ###
- RRD[[0;32mupdate 130.126.110.253/ping-perf.rrd N:0.79 --daemon unix:/var/run/rrdcached.sock[0m]
- [[0;31mRRD Disabled[0m]RRD[[0;32mupdate 130.126.110.253/poller-perf.rrd N:1.084 --daemon unix:/var/run/rrdcached.sock[0m]
- [[0;31mRRD Disabled[0m]SQL[[1;33mUPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=? WHERE `device_id` = ? [0;33m[642760,"0.79",45][0m 0.84ms]
- Updating 130.126.110.253
- Polled in 1.084 seconds
- #### Start Alerts ####
- SQL[[1;33mSELECT `device_group_id` FROM `device_group_device` WHERE `device_id`=? [0;33m[45][0m 0.15ms]
- SQL[[1;33mSELECT 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 = ? || alert_schedule_items.target = ? || alert_schedule_items.target = ? ) && ((alert_schedule.recurring = 0 AND (NOW() BETWEEN alert_schedule.start AND alert_schedule.end)) OR (alert_schedule.recurring = 1 AND (alert_schedule.start_recurring_dt <= date_format(NOW(), '[1;33m-[0;35m-%d') AND (end_recurring_dt >= date_format(NOW(), '[1;33m-[0;35m-%d') OR end_recurring_dt is NULL OR end_recurring_dt = '0000-00-00' OR end_recurring_dt = '')) AND (date_format(now(), '%H:%i:%s') BETWEEN `start_recurring_hr` AND end_recurring_hr) AND (recurring_day LIKE CONCAT('%',date_format(now(), '[0;37m'),'%') OR recurring_day is null or recurring_day = ''))) LIMIT 1 [0;33m[45,"g2","g5"][0m 0.41ms]
- SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a
- LEFT JOIN alert_device_map d ON a.id=d.rule_id
- LEFT JOIN alert_group_map g ON a.id=g.rule_id
- LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id
- WHERE a.disabled = 0 AND ((d.device_id IS NULL AND g.group_id IS NULL) OR d.device_id=? OR dg.device_id=?) [0;33m[45,45][0m 0.18ms]
- Rule [0;35m#2 (Device rebooted):[0m
- SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) && (devices.uptime < "300" && ((devices.disabled = 0 && devices.ignore = 0)) = "1") [0;33m[45][0m 0.32ms]
- SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[2,45][0m 0.2ms]
- Status: [0;34mNOCHG[0m
- Rule [0;35m#3 (BGP Session down):[0m
- SQL[[1;33mSELECT * FROM bgpPeers,devices WHERE (( devices.device_id = bgpPeers.device_id ) && bgpPeers.device_id = ?) && (bgpPeers.bgpPeerState != "established" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1") [0;33m[45][0m 0.34ms]
- SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[3,45][0m 0.14ms]
- Status: [0;34mNOCHG[0m
- Rule [0;35m#4 (BGP Session established):[0m
- SQL[[1;33mSELECT * FROM bgpPeers WHERE (bgpPeers.device_id = ?) && (bgpPeers.bgpPeerFsmEstablishedTime < "300" && bgpPeers.bgpPeerState = "established") [0;33m[45][0m 0.21ms]
- SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[4,45][0m 0.14ms]
- Status: [0;34mNOCHG[0m
- Rule [0;35m#5 (Port status up/down):[0m
- SQL[[1;33mSELECT * FROM ports WHERE (ports.device_id = ?) && (((ports.ifOperStatus = "down" && ports.ifAdminStatus != "down" && ((ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)))) = "1") [0;33m[45][0m 0.38ms]
- SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[5,45][0m 0.13ms]
- Status: [0;34mNOCHG[0m
- Rule [0;35m#6 (Port utilisation over threshold):[0m
- SQL[[1;33mSELECT * FROM ports WHERE (ports.device_id = ?) && ((((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") [0;33m[45][0m 0.49ms]
- SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[6,45][0m 0.13ms]
- Status: [0;34mNOCHG[0m
- Rule [0;35m#7 (Sensor over limit):[0m
- SQL[[1;33mSELECT * FROM sensors WHERE (sensors.device_id = ?) && (sensors.sensor_current > sensors.sensor_limit && sensors.sensor_alert = "1") [0;33m[45][0m 0.16ms]
- SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[7,45][0m 0.13ms]
- Status: [0;34mNOCHG[0m
- Rule [0;35m#8 (Sensor under limit):[0m
- SQL[[1;33mSELECT * FROM sensors WHERE (sensors.device_id = ?) && (sensors.sensor_current < sensors.sensor_limit_low && sensors.sensor_alert = "1") [0;33m[45][0m 0.18ms]
- SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[8,45][0m 0.17ms]
- Status: [0;34mNOCHG[0m
- #### End Alerts ####
- SQL[[1;33mINSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES (:type,:doing,:start,:duration,:devices,:poller) [0;33m{"type":"poll","doing":"130.126.110.253","start":1539979371.7433,"duration":"1.202","devices":1,"poller":"librenms"}[0m 0.71ms]
- ./poller.php 130.126.110.253 2018-10-19 15:02:52 - 1 devices polled in 1.202 secs
- SNMP [5/0.06s]: Get[5/0.06s] Getnext[0/0.00s] Walk[0/0.00s]
- MySQL [17/0.01s]: Cell[13/0.00s] Row[-13/-0.00s] Rows[10/0.01s] Column[2/0.00s] Update[3/0.00s] Insert[2/0.00s] Delete[0/0.00s]
- RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]