LibreNMS Poller =================================== Version info: Commit SHA: 1c6b7a967f4eeeae8215936d3a5a887a94263cce Commit Date: 1511923217 DB Schema: 217 PHP: 7.0.9 MySQL: 5.5.47-MariaDB RRDTool: 1.4.8 SNMP: NET-SNMP 5.7.2 ==================================DEBUG! Starting polling run: SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '10.20.18.123' ORDER BY `device_id` ASC] SQL[SELECT * FROM devices_attribs WHERE `device_id` = '4'] Hostname: 10.20.18.123 Device ID: 4 OS: linux (unix) SQL[INSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`) VALUES ('3','3','0','0.43','0.59','0.50','4',NOW())] SNMP Check response code: 0 SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQnUst -m SNMPv2-MIB:HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 sysUpTime.0 sysLocation.0 sysContact.0 sysName.0 sysObjectID.0] sysUpTime.0 = 17208406 sysLocation.0 = Unknown (edit /etc/snmp/snmpd.conf) sysContact.0 = Root (configure /etc/snmp/snmp.local.conf) sysName.0 = SIT-EnterpriseDB sysObjectID.0 = enterprises.8* SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OvQ -m SNMPv2-MIB:HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 sysDescr.0] Linux SIT-EnterpriseDB 2.6.32-696.13.2.el6.x86_64 #1 SMP Thu Oct 5 21:22:16 UTC 2017 x86_64 SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQnUst -m HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 snmpEngineTime.0 hrSystemUptime.0] snmpEngineTime.0 = No Such Object available on this agent at this OID hrSystemUptime.0 = 69352423 Uptime seconds: 693524 RRD[update 10.20.18.123/uptime.rrd N:693524 --daemon unix:/var/run/rrdcached/rrdcached.sock] Uptime: 8 days, 38m 44s SQL[SELECT `lat`,`lng` FROM `locations` WHERE `location`='Unknown (edit /etc/snmp/snmpd.conf)' LIMIT 1] Google geocode engine being used Bad lat / lng received Modules status: Global- OS Device Module [ unix-agent ] disabled globally. Modules status: Global+ OS Device #### Load poller module os #### SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -m NET-SNMP-EXTEND-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 .1.3.6.1.4.1.8072.1.3.2.3.1.1.6.100.105.115.116.114.111] No Such Object available on this agent at this OID SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -m UCD-SNMP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 .1.3.6.1.4.1.2021.7890.1.3.1.1.6.100.105.115.116.114.111] No Such Object available on this agent at this OID SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -m UCD-SNMP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 .1.3.6.1.4.1.2021.7890.1.101.1] No Such Object available on this agent at this OID SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -m MIB-Dell-10892 -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 .1.3.6.1.4.1.674.10892.1.300.10.1.9.1] No Such Object available on this agent at this OID SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -m CPQSINFO-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell:/opt/librenms/mibs/hp udp:HOSTNAME:161 cpqSiProductName.0] No Such Object available on this agent at this OID SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 .1.3.6.1.4.1.2021.7890.2.4.1.2.8.104.97.114.100.119.97.114.101.1] No Such Object available on this agent at this OID SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 .1.3.6.1.4.1.2021.7890.2.101.1] No Such Object available on this agent at this OID SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 .1.3.6.1.4.1.2021.7890.3.4.1.2.12.109.97.110.117.102.97.99.116.117.114.101.114.1] No Such Object available on this agent at this OID SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 .1.3.6.1.4.1.2021.7890.3.101.1] No Such Object available on this agent at this OID SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -m MIB-Dell-10892 -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 .1.3.6.1.4.1.674.10892.1.300.10.1.11.1] No Such Object available on this agent at this OID SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 .1.3.6.1.4.1.2021.7890.4.4.1.2.6.115.101.114.105.97.108.1] No Such Object available on this agent at this OID Hardware: Generic x86 64-bit Version: 2.6.32-696.13.2.el6.x86_64 Features: Serial: >> Runtime for poller module 'os': 0.2889 seconds with 3984 bytes #### Unload poller module os #### RRD[update 10.20.18.123/poller-perf-os.rrd N:0.28893899917603 --daemon unix:/var/run/rrdcached/rrdcached.sock] Modules status: Global+ OS Device #### Load poller module ipmi #### SQL[SELECT * FROM sensors WHERE device_id = '4' AND poller_type='ipmi'] Array ( ) >> Runtime for poller module 'ipmi': 0.0009 seconds with 1320 bytes #### Unload poller module ipmi #### RRD[update 10.20.18.123/poller-perf-ipmi.rrd N:0.00089406967163086 --daemon unix:/var/run/rrdcached/rrdcached.sock] Modules status: Global+ OS Device #### Load poller module sensors #### SQL[SELECT `sensor_class` FROM `sensors` WHERE `device_id` = '4' GROUP BY `sensor_class`] >> Runtime for poller module 'sensors': 0.0004 seconds with 208 bytes #### Unload poller module sensors #### RRD[update 10.20.18.123/poller-perf-sensors.rrd N:0.00039410591125488 --daemon unix:/var/run/rrdcached/rrdcached.sock] Modules status: Global+ OS Device #### Load poller module processors #### SQL[SELECT * FROM processors WHERE device_id = '4'] >> Runtime for poller module 'processors': 0.0004 seconds with 600 bytes #### Unload poller module processors #### RRD[update 10.20.18.123/poller-perf-processors.rrd N:0.00041413307189941 --daemon unix:/var/run/rrdcached/rrdcached.sock] Modules status: Global+ OS Device #### Load poller module mempools #### SQL[SELECT * FROM mempools WHERE device_id = '4'] >> Runtime for poller module 'mempools': 0.0004 seconds with 632 bytes #### Unload poller module mempools #### RRD[update 10.20.18.123/poller-perf-mempools.rrd N:0.00040817260742188 --daemon unix:/var/run/rrdcached/rrdcached.sock] Modules status: Global+ OS Device #### Load poller module storage #### SQL[SELECT * FROM storage WHERE device_id = '4'] >> Runtime for poller module 'storage': 0.0004 seconds with 696 bytes #### Unload poller module storage #### RRD[update 10.20.18.123/poller-perf-storage.rrd N:0.00040102005004883 --daemon unix:/var/run/rrdcached/rrdcached.sock] Modules status: Global+ OS Device #### Load poller module netstats #### IPSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m IP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 IP-MIB::ipForwDatagrams.0 IP-MIB::ipInDelivers.0 IP-MIB::ipInReceives.0 IP-MIB::ipOutRequests.0 IP-MIB::ipInDiscards.0 IP-MIB::ipOutDiscards.0 IP-MIB::ipOutNoRoutes.0 IP-MIB::ipReasmReqds.0 IP-MIB::ipReasmOKs.0 IP-MIB::ipReasmFails.0 IP-MIB::ipFragOKs.0 IP-MIB::ipFragFails.0 IP-MIB::ipFragCreates.0 IP-MIB::ipInUnknownProtos.0 IP-MIB::ipInHdrErrors.0 IP-MIB::ipInAddrErrors.0] ipForwDatagrams.0 = No Such Object available on this agent at this OID ipInDelivers.0 = No Such Object available on this agent at this OID ipInReceives.0 = No Such Object available on this agent at this OID ipOutRequests.0 = No Such Object available on this agent at this OID ipInDiscards.0 = No Such Object available on this agent at this OID ipOutDiscards.0 = No Such Object available on this agent at this OID ipOutNoRoutes.0 = No Such Object available on this agent at this OID ipReasmReqds.0 = No Such Object available on this agent at this OID ipReasmOKs.0 = No Such Object available on this agent at this OID ipReasmFails.0 = No Such Object available on this agent at this OID ipFragOKs.0 = No Such Object available on this agent at this OID ipFragFails.0 = No Such Object available on this agent at this OID ipFragCreates.0 = No Such Object available on this agent at this OID ipInUnknownProtos.0 = No Such Object available on this agent at this OID ipInHdrErrors.0 = No Such Object available on this agent at this OID ipInAddrErrors.0 = No Such Object available on this agent at this OID TCPSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m TCP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 TCP-MIB::tcpActiveOpens.0 TCP-MIB::tcpPassiveOpens.0 TCP-MIB::tcpAttemptFails.0 TCP-MIB::tcpEstabResets.0 TCP-MIB::tcpCurrEstab.0 TCP-MIB::tcpInSegs.0 TCP-MIB::tcpOutSegs.0 TCP-MIB::tcpRetransSegs.0 TCP-MIB::tcpInErrs.0 TCP-MIB::tcpOutRsts.0 tcpHCInSegs.0 tcpHCOutSegs.0] tcpActiveOpens.0 = No Such Object available on this agent at this OID tcpPassiveOpens.0 = No Such Object available on this agent at this OID tcpAttemptFails.0 = No Such Object available on this agent at this OID tcpEstabResets.0 = No Such Object available on this agent at this OID tcpCurrEstab.0 = No Such Object available on this agent at this OID tcpInSegs.0 = No Such Object available on this agent at this OID tcpOutSegs.0 = No Such Object available on this agent at this OID tcpRetransSegs.0 = No Such Object available on this agent at this OID tcpInErrs.0 = No Such Object available on this agent at this OID tcpOutRsts.0 = No Such Object available on this agent at this OID tcpHCInSegs.0 = No Such Object available on this agent at this OID tcpHCOutSegs.0 = No Such Object available on this agent at this OID UDPSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m UDP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 UDP-MIB::udpInDatagrams.0 UDP-MIB::udpOutDatagrams.0 UDP-MIB::udpInErrors.0 UDP-MIB::udpNoPorts.0] udpInDatagrams.0 = No Such Object available on this agent at this OID udpOutDatagrams.0 = No Such Object available on this agent at this OID udpInErrors.0 = No Such Object available on this agent at this OID udpNoPorts.0 = No Such Object available on this agent at this OID ICMPSNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m IP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 icmp] icmp = No Such Object available on this agent at this OID SNMPSNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m SNMPv2-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 snmp] snmp = No Such Object available on this agent at this OID IP-FORWARDSNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQv -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 IP-FORWARD-MIB::ipCidrRouteNumber.0] No Such Object available on this agent at this OID >> Runtime for poller module 'netstats': 0.0705 seconds with 13680 bytes #### Unload poller module netstats #### RRD[update 10.20.18.123/poller-perf-netstats.rrd N:0.07046914100647 --daemon unix:/var/run/rrdcached/rrdcached.sock] Modules status: Global+ OS Device #### Load poller module hr-mib #### SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OUQs -m HOST-RESOURCES-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 hrSystemProcesses.0 hrSystemNumUsers.0] hrSystemProcesses.0 = No Such Object available on this agent at this OID hrSystemNumUsers.0 = No Such Object available on this agent at this OID >> Runtime for poller module 'hr-mib': 0.0100 seconds with 504 bytes #### Unload poller module hr-mib #### RRD[update 10.20.18.123/poller-perf-hr-mib.rrd N:0.0099639892578125 --daemon unix:/var/run/rrdcached/rrdcached.sock] Modules status: Global+ OS Device #### Load poller module ucd-mib #### SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 systemStats] systemStats = No more variables left in this MIB View (It is past the end of the MIB tree) SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 memTotalSwap.0 memAvailSwap.0 memTotalReal.0 memAvailReal.0 memTotalFree.0 memShared.0 memBuffer.0 memCached.0] memTotalSwap.0 = No Such Object available on this agent at this OID memAvailSwap.0 = No Such Object available on this agent at this OID memTotalReal.0 = No Such Object available on this agent at this OID memAvailReal.0 = No Such Object available on this agent at this OID memTotalFree.0 = No Such Object available on this agent at this OID memShared.0 = No Such Object available on this agent at this OID memBuffer.0 = No Such Object available on this agent at this OID memCached.0 = No Such Object available on this agent at this OID SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 laLoadInt.1 laLoadInt.2 laLoadInt.3] laLoadInt.1 = No Such Object available on this agent at this OID laLoadInt.2 = No Such Object available on this agent at this OID laLoadInt.3 = No Such Object available on this agent at this OID >> Runtime for poller module 'ucd-mib': 0.0255 seconds with 1664 bytes #### Unload poller module ucd-mib #### RRD[update 10.20.18.123/poller-perf-ucd-mib.rrd N:0.02551794052124 --daemon unix:/var/run/rrdcached/rrdcached.sock] Modules status: Global+ OS Device #### Load poller module ipSystemStats #### SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m IP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 ipSystemStats] ipSystemStatsTable = No Such Object available on this agent at this OID >> Runtime for poller module 'ipSystemStats': 0.0135 seconds with 792 bytes #### Unload poller module ipSystemStats #### RRD[update 10.20.18.123/poller-perf-ipSystemStats.rrd N:0.013512134552002 --daemon unix:/var/run/rrdcached/rrdcached.sock] Modules status: Global+ OS Device #### Load poller module ports #### Caching Oids: SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 ifXEntry] ifXEntry = No more variables left in this MIB View (It is past the end of the MIB tree) SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 ifEntry] ifEntry = No Such Object available on this agent at this OID dot3StatsDuplexStatusSNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m EtherLike-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 dot3StatsDuplexStatus] dot3StatsDuplexStatus = No Such Object available on this agent at this OID SQL[SELECT COUNT(*) FROM `ports` WHERE `device_id` = '4' AND `ifType` = 'adsl'] SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m Q-BRIDGE-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:HOSTNAME:161 dot1qPvid] dot1qPvid = No Such Object available on this agent at this OID Array ( ) SQL[SELECT `name` FROM `port_association_mode` WHERE pom_id = '1'] SQL[SELECT *, `ports_statistics`.`port_id` AS `ports_statistics_port_id`, `ports`.`port_id` AS `port_id` FROM `ports` LEFT OUTER JOIN `ports_statistics` ON `ports`.`port_id` = `ports_statistics`.`port_id` WHERE `ports`.`device_id` = '4' ORDER BY ports.port_id] >> Runtime for poller module 'ports': 0.0499 seconds with 22168 bytes #### Unload poller module ports #### RRD[update 10.20.18.123/poller-perf-ports.rrd N:0.049922943115234 --daemon unix:/var/run/rrdcached/rrdcached.sock] Modules status: Global+ OS- Device Module [ bgp-peers ] disabled on os. Modules status: Global- OS Device Module [ junose-atm-vp ] disabled globally. Modules status: Global- OS Device Module [ toner ] disabled globally. Modules status: Global+ OS Device #### Load poller module ucd-diskio #### SQL[SELECT * FROM `ucd_diskio` WHERE `device_id` = '4'] >> Runtime for poller module 'ucd-diskio': 0.0005 seconds with 488 bytes #### Unload poller module ucd-diskio #### RRD[update 10.20.18.123/poller-perf-ucd-diskio.rrd N:0.00050592422485352 --daemon unix:/var/run/rrdcached/rrdcached.sock] Modules status: Global- OS Device Module [ wifi ] disabled globally. Modules status: Global+ OS Device #### Load poller module wireless #### Attempting to initialize OS: linux SQL[SELECT * FROM `wireless_sensors` WHERE `device_id` = '4'] >> Runtime for poller module 'wireless': 0.0019 seconds with 111120 bytes #### Unload poller module wireless #### RRD[update 10.20.18.123/poller-perf-wireless.rrd N:0.0019018650054932 --daemon unix:/var/run/rrdcached/rrdcached.sock] Modules status: Global+ OS- Device Module [ ospf ] disabled on os. Modules status: Global- OS Device Module [ cisco-ipsec-flow-monitor ] disabled globally. Modules status: Global- OS Device Module [ cisco-remote-access-monitor ] disabled globally. Modules status: Global- OS Device Module [ cisco-cef ] disabled globally. Modules status: Global- OS Device Module [ cisco-sla ] disabled globally. Modules status: Global- OS Device Module [ cisco-mac-accounting ] disabled globally. Modules status: Global- OS Device Module [ cipsec-tunnels ] disabled globally. Modules status: Global- OS Device Module [ cisco-ace-loadbalancer ] disabled globally. Modules status: Global- OS Device Module [ cisco-ace-serverfarms ] disabled globally. Modules status: Global- OS Device Module [ cisco-asa-firewall ] disabled globally. Modules status: Global- OS Device Module [ cisco-voice ] disabled globally. Modules status: Global- OS Device Module [ cisco-cbqos ] disabled globally. Modules status: Global- OS Device Module [ cisco-otv ] disabled globally. Modules status: Global- OS Device Module [ cisco-vpdn ] disabled globally. Modules status: Global- OS Device Module [ netscaler-vsvr ] disabled globally. Modules status: Global- OS Device Module [ aruba-controller ] disabled globally. Modules status: Global+ OS Device #### Load poller module entity-physical #### SQL[SELECT * FROM `entPhysical_state` WHERE `device_id` = '4'] >> Runtime for poller module 'entity-physical': 0.0004 seconds with 960 bytes #### Unload poller module entity-physical #### RRD[update 10.20.18.123/poller-perf-entity-physical.rrd N:0.00042009353637695 --daemon unix:/var/run/rrdcached/rrdcached.sock] Modules status: Global+ OS Device #### Load poller module applications #### SQL[SELECT * FROM `applications` WHERE `device_id` = '4'] >> Runtime for poller module 'applications': 0.0004 seconds with 368 bytes #### Unload poller module applications #### RRD[update 10.20.18.123/poller-perf-applications.rrd N:0.00036191940307617 --daemon unix:/var/run/rrdcached/rrdcached.sock] Modules status: Global- OS Device Module [ mib ] disabled globally. Modules status: Global+ OS- Device Module [ stp ] disabled on os. Modules status: Global+ OS Device #### Load poller module ntp #### >> Runtime for poller module 'ntp': 0.0001 seconds with 192 bytes #### Unload poller module ntp #### RRD[update 10.20.18.123/poller-perf-ntp.rrd N:5.0067901611328E-5 --daemon unix:/var/run/rrdcached/rrdcached.sock] Modules status: Global+ OS Device #### Load poller module services #### >> Runtime for poller module 'services': 0.0000 seconds with 0 bytes #### Unload poller module services #### RRD[update 10.20.18.123/poller-perf-services.rrd N:3.0994415283203E-5 --daemon unix:/var/run/rrdcached/rrdcached.sock] Modules status: Global- OS Device Module [ loadbalancers ] disabled globally. Modules status: Global- OS Device Module [ mef ] disabled globally. ### Start Device Groups ### SQL[SELECT * FROM device_groups ORDER BY name] SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='4'] Groups Added: Groups Removed: ### End Device Groups ### SQL[SELECT `graph` FROM `device_graphs` WHERE `device_id` = '4'] uptime RRD[update 10.20.18.123/ping-perf.rrd N:0.50 --daemon unix:/var/run/rrdcached/rrdcached.sock] RRD[update 10.20.18.123/poller-perf.rrd N:6.642 --daemon unix:/var/run/rrdcached/rrdcached.sock] Polled in 6.642 seconds Updating 10.20.18.123 SQL[UPDATE `devices` set `uptime` ='693524',`last_ping` =NOW(),`last_ping_timetaken` ='0.50',`last_polled` =NOW(),`last_polled_timetaken` ='6.642' WHERE `device_id` = '4'] UPDATED! #### Start Alerts #### SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='4'] 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 = '4' ) && ((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(), '--%d') AND (end_recurring_dt >= date_format(NOW(), '--%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(), ''),'%') OR recurring_day is null or recurring_day = ''))) LIMIT 1] SQL[SELECT `device_group_id` FROM `device_group_device` WHERE `device_id`='4'] 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 = '4' ) || alert_map.target = '4' )] Rule #1 (Devices up/down): SQL[SELECT state FROM alerts WHERE rule_id = '1' && device_id = '4' ORDER BY id DESC LIMIT 1] SQL[SELECT * FROM devices WHERE (devices.device_id = '4') && (((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 = '4' ORDER BY id DESC LIMIT 1] SQL[SELECT * FROM devices WHERE (devices.device_id = '4') && (devices.uptime < "300" && ((devices.disabled = 0 && devices.ignore = 0)) = "1")] Status: NOCHG Rule #3 (BGP Session down): SQL[SELECT state FROM alerts WHERE rule_id = '3' && device_id = '4' ORDER BY id DESC LIMIT 1] SQL[SELECT * FROM bgpPeers,devices WHERE (( devices.device_id = bgpPeers.device_id ) && bgpPeers.device_id = '4') && (bgpPeers.bgpPeerState != "established" && ((devices.status = 1 && ((devices.disabled = 0 && devices.ignore = 0)))) = "1")] Status: NOCHG Rule #4 (BGP Session established): SQL[SELECT state FROM alerts WHERE rule_id = '4' && device_id = '4' ORDER BY id DESC LIMIT 1] SQL[SELECT * FROM bgpPeers WHERE (bgpPeers.device_id = '4') && (bgpPeers.bgpPeerFsmEstablishedTime < "300" && bgpPeers.bgpPeerState = "established")] Status: NOCHG Rule #5 (Port status up/down): SQL[SELECT state FROM alerts WHERE rule_id = '5' && device_id = '4' ORDER BY id DESC LIMIT 1] SQL[SELECT * FROM ports WHERE (ports.device_id = '4') && (((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 = '4' ORDER BY id DESC LIMIT 1] SQL[SELECT * FROM ports WHERE (ports.device_id = '4') && ((((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 = '4' ORDER BY id DESC LIMIT 1] SQL[SELECT * FROM sensors WHERE (sensors.device_id = '4') && (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 = '4' ORDER BY id DESC LIMIT 1] SQL[SELECT * FROM sensors WHERE (sensors.device_id = '4') && (sensors.sensor_current < sensors.sensor_limit_low && sensors.sensor_alert = "1")] Status: NOCHG #### End Alerts #### SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES ('poll','10.20.18.123','1511924834.3916','6.751','1','librenms')] ./poller.php 10.20.18.123 2017-11-29 03:07:21 - 1 devices polled in 6.751 secs SNMP 0.59s: Get[22/0.50s] Getnext [0/0.00s] Walk [8/0.09s] MySQL 0.04s: Cell[4/0.00s] Row[10/0.00s] Rows[25/0.01s] Column[3/0.00s] Update[1/0.01s] Insert[2/0.02s] Delete[0/0.00s] RRD 0.00s: Update [20/0.00s] Create [0/0.00s] Other [0/0.00s]