LibreNMS Poller SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.27ms] SQL[select count(*) as aggregate from `migrations` limit 1 [] 0.22ms] SQL[SELECT version() [] 0.26ms] =================================== Version info: Commit SHA: Commit Date: DB Schema: 2020_08_28_212054_drop_uptime_column_outages (173) PHP: 7.3.21 MySQL: 10.4.14-MariaDB-1:10.4.14+maria~focal RRDTool: 1.7.2 SNMP: NET-SNMP 5.8 ==================================DEBUG! Updating os_def.cache Starting polling run: SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'switch.j.local' ORDER BY `device_id` ASC [] 0.96ms] SQL[select * from `devices` where `device_id` = ? limit 1 [6] 0.46ms] SQL[select * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [6] 0.96ms] Attempting to initialize OS: linux Attempting to initialize OS: unix OS initialized as Generic Hostname: switch.j.local Device ID: 6 OS: linux Resolved IP: 192.168.70.22 (unix) SQL[select `hostname`, `overwrite_ip` from `devices` where `hostname` = ? limit 1 ["switch.j.local"] 0.58ms] [FPING] '/usr/sbin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' 'switch.j.local' response: {"xmt":3,"rcv":3,"loss":0,"min":0.51,"max":0.68,"avg":0.6,"dup":0,"exitcode":0} SQL[INSERT IGNORE INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`,`debug`) VALUES (:xmt,:rcv,:loss,:min,:max,:avg,:device_id,NOW(),:debug) {"xmt":3,"rcv":3,"loss":0,"min":0.51,"max":0.68,"avg":0.6,"device_id":6,"debug":"[]"} 1.12ms] SQL[UPDATE `devices` set `last_ping`=?,`last_ping_timetaken`=? WHERE device_id=? ["2020-09-20 16:49:40",0.6,6] 7.17ms] SNMP Check response code: 0 Modules status: Global+ OS Device #### Load poller module core #### SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUt' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell' 'udp:HOSTNAME:161' 'sysUpTime.0' 'sysContact.0' 'sysName.0' 'sysObjectID.0' 'sysDescr.0'] .*.*.0 = 136477926 .*.*.0 = Default .*.*.0 = Switch .*.*.0 = .*.4.1.8* .*.*.0 = Linux Garderoben 3.18.24 #0 Thu Aug 30 12:10:54 2018 mips 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 = 1364779 hrSystemUptime.0 = No Such Object available on this agent at this OID Uptime seconds: 1364779 Uptime: 15 days 19 hours 6 minutes 19 seconds >> Runtime for poller module 'core': 0.0215 seconds with 5056 bytes >> SNMP: [2/0.02s] MySQL: [0/0.00s] #### Unload poller module core #### Modules status: Global+ OS Device #### Load poller module availability #### SQL[SELECT duration FROM availability WHERE device_id = ? [6] 0.35ms] Availability: SQL[SELECT * FROM availability WHERE device_id = ? [6] 0.22ms] SQL[select * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [6,1600526980] 0.42ms] SQL[UPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [100,17] 0.25ms] 1 day : 100% SQL[select * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [6,1600008580] 0.32ms] SQL[UPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [100,18] 0.23ms] 7 days : 100% SQL[select * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [6,1598021380] 0.35ms] SQL[UPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [100,19] 0.23ms] 30 days : 100% SQL[select * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [6,1569077380] 0.31ms] SQL[UPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [100,20] 0.21ms] 365 days : 100% >> Runtime for poller module 'availability': 0.0059 seconds with 111368 bytes >> SNMP: [0/0.00s] MySQL: [5/0.00s] #### Unload poller module availability #### 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 SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Ovq' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell' 'udp:HOSTNAME:161' 'sysLocation.0'] Default SQL[select * from `locations` where (`location` = ?) limit 1 ["Default"] 0.43ms] Location: Default Hardware: Generic MIPS OS Version: 3.18.24 OS Features: Serial: >> Runtime for poller module 'os': 0.2038 seconds with 42192 bytes >> SNMP: [12/0.20s] MySQL: [0/0.00s] #### Unload poller module os #### Modules status: Global+ OS Device #### Load poller module ipmi #### SQL[SELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [6] 0.32ms] array ( ) >> Runtime for poller module 'ipmi': 0.0010 seconds with 1640 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module ipmi #### Modules status: Global+ OS Device #### Load poller module sensors #### SQL[SELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [6] 0.21ms] >> Runtime for poller module 'sensors': 0.0005 seconds with 1208 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module sensors #### Modules status: Global+ OS Device #### Load poller module processors #### Attempting to initialize OS: linux Attempting to initialize OS: unix OS initialized as Generic SQL[SELECT * FROM processors WHERE device_id=? [6] 0.23ms] SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQn' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell' 'udp:HOSTNAME:161' '.1.3.6.1.2.1.25.3.3.1.2.196608'] .*.*.*608 = 25 array ( '.1.3.6.1.2.1.25.3.3.1.2.196608' => '25', ) 25% SQL[UPDATE `processors` set `processor_usage`=? WHERE `processor_id` = ? [25,8] 1.11ms] >> Runtime for poller module 'processors': 0.0241 seconds with 6936 bytes >> SNMP: [1/0.02s] MySQL: [2/0.00s] #### Unload poller module processors #### Modules status: Global+ OS Device #### Load poller module mempools #### SQL[SELECT * FROM mempools WHERE device_id = ? [6] 0.49ms] >> Runtime for poller module 'mempools': 0.0016 seconds with 1160 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module mempools #### Modules status: Global+ OS Device #### Load poller module storage #### SQL[SELECT * FROM storage WHERE device_id = ? [6] 0.55ms] >> Runtime for poller module 'storage': 0.0018 seconds with 1208 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module storage #### Modules status: Global+ OS Device #### Load poller module netstats #### 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 Invalid snmp_walk() data = icmp = No Such Object available on this agent at this OID IPSNMP['/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell' 'udp:HOSTNAME:161' 'ipForwDatagrams' 'ipInDelivers' 'ipInReceives' 'ipOutRequests' 'ipInDiscards' 'ipOutDiscards' 'ipOutNoRoutes' 'ipReasmReqds' 'ipReasmOKs' 'ipReasmFails' 'ipFragOKs' 'ipFragFails' 'ipFragCreates' 'ipInUnknownProtos' 'ipInHdrErrors' 'ipInAddrErrors'] snmpInPkts.0 = 194239 snmpInPkts.0 = 194239 snmpInPkts.0 = 194239 snmpInPkts.0 = 194239 snmpInPkts.0 = 194239 snmpInPkts.0 = 194239 snmpInPkts.0 = 194239 snmpInPkts.0 = 194239 snmpInPkts.0 = 194239 snmpInPkts.0 = 194239 snmpInPkts.0 = 194239 snmpInPkts.0 = 194239 snmpInPkts.0 = 194239 snmpInPkts.0 = 194239 snmpInPkts.0 = 194239 snmpInPkts.0 = 194239 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 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'] snmpInPkts.0 = 194241 snmpOutPkts.0 = 194240 snmpInBadVersions.0 = 0 snmpInBadCommunityNames.0 = 0 snmpInBadCommunityUses.0 = 0 snmpInASNParseErrs.0 = 0 snmpInTooBigs.0 = 0 snmpInNoSuchNames.0 = 0 snmpInBadValues.0 = 0 snmpInReadOnlys.0 = 0 snmpInGenErrs.0 = 0 snmpInTotalReqVars.0 = 849126 snmpInTotalSetVars.0 = 0 snmpInGetRequests.0 = 124934 snmpInGetNexts.0 = 17701 snmpInSetRequests.0 = 0 snmpInGetResponses.0 = 0 snmpInTraps.0 = 0 snmpOutTooBigs.0 = 0 snmpOutNoSuchNames.0 = 0 snmpOutBadValues.0 = 0 snmpOutGenErrs.0 = 0 snmpOutGetRequests.0 = 0 snmpOutGetNexts.0 = 0 snmpOutSetRequests.0 = 0 snmpOutGetResponses.0 = 194242 snmpOutTraps.0 = 0 snmpEnableAuthenTraps.0 = disabled snmpSilentDrops.0 = 0 snmpProxyDrops.0 = 0 TCPSNMP['/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell' 'udp:HOSTNAME:161' 'tcpActiveOpens' 'tcpPassiveOpens' 'tcpAttemptFails' 'tcpEstabResets' 'tcpCurrEstab' 'tcpInSegs' 'tcpOutSegs' 'tcpRetransSegs' 'tcpInErrs' 'tcpOutRsts'] mib-* = 194245 mib-* = 194245 mib-* = 194245 mib-* = 194245 mib-* = 194245 mib-* = 194245 mib-* = 194245 mib-* = 194245 mib-* = 194245 mib-* = 194245 TCPHCSNMP['/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell' 'udp:HOSTNAME:161' 'tcpHCInSegs.0' 'tcpHCOutSegs.0'] mib-* = 194246 mib-* = 194246 UDPSNMP['/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UDP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell' 'udp:HOSTNAME:161' 'udpInDatagrams' 'udpOutDatagrams' 'udpInErrors' 'udpNoPorts'] mib-* = 194247 mib-* = 194247 mib-* = 194247 mib-* = 194247 >> Runtime for poller module 'netstats': 0.1301 seconds with 42088 bytes >> SNMP: [7/0.13s] MySQL: [0/0.00s] #### Unload poller module netstats #### 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.0132 seconds with 1208 bytes >> SNMP: [1/0.01s] MySQL: [0/0.00s] #### Unload poller module hr-mib #### 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 Such Object available on this agent at this OID Invalid snmp_walk() data = systemStats = 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' 'memTotalSwap.0' 'memAvailSwap.0' 'memTotalReal.0' 'memAvailReal.0' 'memTotalFree.0' 'memShared.0' 'memBuffer.0' 'memCached.0'] memTotalSwap.0 = 0 memAvailSwap.0 = 0 memTotalReal.0 = 126884 memAvailReal.0 = 62156 memTotalFree.0 = 62156 memShared.0 = 1180 memBuffer.0 = 0 memCached.0 = 27352 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 = 161 laLoadInt.2 = 147 laLoadInt.3 = 147 >> Runtime for poller module 'ucd-mib': 0.0258 seconds with 3264 bytes >> SNMP: [3/0.03s] MySQL: [0/0.00s] #### Unload poller module ucd-mib #### 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 Invalid snmp_walk() data = ipSystemStatsTable = No Such Object available on this agent at this OID >> Runtime for poller module 'ipSystemStats': 0.0209 seconds with 1208 bytes >> SNMP: [1/0.02s] MySQL: [0/0.00s] #### Unload poller module ipSystemStats #### Modules status: Global+ OS Device #### Load poller module ports #### 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` = ? ORDER BY ports.port_id [6] 0.98ms] Caching Oids: Full ports polling 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 Such Object available on this agent at this OID Invalid snmp_walk() data = ifXEntry = No Such Object available on this agent at this OID 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 Invalid snmp_walk() data = 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 Invalid snmp_walk() data = dot3StatsDuplexStatus = No Such Object available on this agent at this OID 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 Invalid snmp_walk() data = dot1qPvid = No Such Object available on this agent at this OID SQL[SELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl') [6] 0.72ms] array ( ) Warning: max(): Array must contain at least one element in /opt/librenms/includes/polling/ports.inc.php on line 519 SQL[update `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [1600613381,false,1600613381] 0.36ms] 0 updated >> Runtime for poller module 'ports': 0.0719 seconds with 12520 bytes >> SNMP: [4/0.06s] MySQL: [1/0.00s] #### Unload poller module ports #### Modules status: Global+ OS Device #### Load poller module customoid #### SQL[SELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [6] 0.45ms] >> Runtime for poller module 'customoid': 0.0016 seconds with 1208 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module customoid #### 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` = ? [6] 0.22ms] >> Runtime for poller module 'ucd-diskio': 0.0007 seconds with 1208 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module ucd-diskio #### Modules status: Global- OS Device Module [ wifi ] disabled globally. Modules status: Global+ OS Device #### Load poller module wireless #### Attempting to initialize OS: linux Attempting to initialize OS: unix OS initialized as Generic SQL[SELECT * FROM `wireless_sensors` WHERE `device_id` = ? [6] 0.27ms] >> Runtime for poller module 'wireless': 0.0030 seconds with 90552 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module wireless #### 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-qfp ] disabled globally. Modules status: Global- OS Device Module [ cisco-vpdn ] disabled globally. Modules status: Global- OS Device Module [ nac ] 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` = ? [6] 0.22ms] >> Runtime for poller module 'entity-physical': 0.0008 seconds with 1304 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module entity-physical #### Modules status: Global- OS Device Module [ entity-state ] disabled globally. Modules status: Global+ OS Device #### Load poller module applications #### SQL[SELECT * FROM `applications` WHERE `device_id` = ? [6] 0.26ms] >> Runtime for poller module 'applications': 0.0005 seconds with 1208 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module applications #### 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 80 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] #### Unload poller module ntp #### Modules status: Global- OS Device Module [ loadbalancers ] disabled globally. Modules status: Global- OS Device Module [ mef ] disabled globally. Modules status: Global+ OS Device #### Load poller module mpls #### >> Runtime for poller module 'mpls': 0.0007 seconds with 880 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] #### Unload poller module mpls #### Enabling graphs: SQL[select * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [6] 0.26ms] SQL[UPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=?,`last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [1364779,0.6,1.788,6] 0.85ms] Updating switch.j.local Polled in 1.788 seconds ### Start Device Groups ### SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [6] 8.61ms] SQL[select * from `device_groups` [] 0.29ms] SQL[select * from `device_group_device` where `device_id` = ? [6] 0.33ms] Groups Added: Groups Removed: ### End Device Groups, runtime: 0.017s ### #### Start Alerts #### SQL[select `device_groups`.*, `device_group_device`.`device_id` as `pivot_device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id` from `device_groups` inner join `device_group_device` on `device_groups`.`id` = `device_group_device`.`device_group_id` where `device_group_device`.`device_id` = ? [6] 0.37ms] SQL[select exists(select * from `alert_schedule` where (`start` <= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time xss=removed> ?) or (time(`start`) > time(`end`) and (time(`end`) <= ? or time(`start`) > ?))) and (`recurring_day` like ? or `recurring_day` is null)))) and (exists (select * from `devices` inner join `alert_schedulables` on `devices`.`device_id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?) or exists (select * from `device_groups` inner join `alert_schedulables` on `device_groups`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and 0 = 1) or exists (select * from `locations` inner join `alert_schedulables` on `locations`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?))) as `exists` ["2020-09-20T14:49:41.410240Z","2020-09-20T14:49:41.410240Z",0,1,"14:49:41","14:49:41","14:49:41","14:49:41","%","device",6,"device_group","location",4] 1.01ms] SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [6] 0.42ms] SQL[SELECT DISTINCT a.* FROM alert_rules a LEFT JOIN alert_device_map d ON a.id=d.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND d.device_id = ?) LEFT JOIN alert_group_map g ON a.id=g.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND g.group_id IN (SELECT DISTINCT device_group_id FROM device_group_device WHERE device_id = ?)) LEFT JOIN alert_location_map l ON a.id=l.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND l.location_id IN (SELECT DISTINCT location_id FROM devices WHERE device_id = ?)) LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ? WHERE a.disabled = 0 AND ( (d.device_id IS NULL AND g.group_id IS NULL) OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=?)) OR (a.invert_map = 1 AND (d.device_id != ? OR d.device_id IS NULL) AND (dg.device_id != ? OR dg.device_id IS NULL)) ) [6,6,6,6,6,6,6,6] 1.18ms] #### End Alerts #### SQL[INSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES (:type,:doing,:start,:duration,:devices,:poller) {"type":"poll","doing":"switch.j.local","start":1600613379.432573,"duration":"1.984","devices":1,"poller":"\/"} 0.98ms] ./poller.php switch.j.local 2020-09-20 16:49:41 - 1 devices polled in 1.984 secs SNMP [32/0.70s]: Get[20/0.51s] Getnext[4/0.04s] Walk[8/0.16s] MySQL [23/0.02s]: Cell[2/0.00s] Row[-2/-0.00s] Rows[13/0.01s] Column[1/0.00s] Update[7/0.01s] Insert[2/0.00s] Delete[0/0.00s] bash-5.0#