-bash-4.2$ ./poller.php -h tlups1 -r -f -d | ./pbin.sh Paste endpoint: https://p.libren.ms/api/create SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.58ms] SQL[select count(*) as aggregate from `migrations` limit 1 [] 0.46ms] SQL[SELECT version() [] 0.31ms] Updating os_def.cache... Done SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'tlups1' ORDER BY `device_id` ASC [] 4.78ms] SQL[select * from `devices` where `device_id` = ? limit 1 [30] 0.75ms] SQL[select * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [30] 0.58ms] [FPING] '/usr/sbin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' 'tlups1' array ( 'xmt' => 3, 'rcv' => 3, 'loss' => 0, 'min' => 1.39, 'max' => 1.79, 'avg' => 1.56, '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":1.39,"max":1.79,"avg":1.56,"device_id":30,"debug":"[]"} 1.21ms] SNMP Check response code: 0 Modules status: Global+ OS Device .*.*.0 = 54961 .*.*.0 = 1111 W. 35th St., Chicago IL, 60609 .*.*.0 = www.tripplite.com .*.*.0 = tlup1.int.dittman.net .*.*.0 = .*.4.1.850.1 .*.*.0 = POWERALERT 12 snmpEngineTime.0 = No Such Object available on this agent at this OID hrSystemUptime.0 = No Such Object available on this agent at this OID Uptime seconds: 550 SQL[select * from `locations` where (`location` = ?) limit 1 ["1111 W. 35th St., Chicago IL, 60609"] 0.67ms] Modules status: Global- OS Device Modules status: Global+ OS Device SU1500RTXL2Ua "home" tlups1 9725AY0AC699600158 12.04.0047 Modules status: Global+ OS Device SQL[SELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [30] 0.96ms] array ( ) Modules status: Global+ OS Device SQL[SELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [30] 0.75ms] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? ["charge",30] 0.74ms] .*.*.2.4.0 = 100 SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? ["frequency",30] 1.09ms] .*.*.*.1 = 600 .*.*.4.2.0 = 600 .*.*.5.1.0 = 600 SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? ["load",30] 1.01ms] .*.*.*.1 = 24 SQL[UPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [24,25,"Load",35] 1.34ms] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? ["runtime",30] 0.91ms] .*.*.2.2.0 = 0 .*.*.2.3.0 = 31 SQL[UPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [31,28,"Runtime",37] 1.36ms] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? ["state",30] 0.87ms] .*.*.2.1.0 = 2 .*.*.4.1.0 = 3 SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? ["temperature",30] 1.17ms] .*.*.2.7.0 = 42 SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? ["voltage",30] 1.06ms] .*.*.2.5.0 = 540 .*.*.*.1 = 120 .*.*.*.1 = 124 .*.*.*.1 = 124 Modules status: Global+ OS Device Attempting to initialize OS: poweralert OS initialized as Generic SQL[SELECT * FROM processors WHERE device_id=? [30] 0.71ms] Modules status: Global+ OS Device SQL[SELECT * FROM mempools WHERE device_id = ? [30] 0.55ms] Modules status: Global+ OS Device SQL[SELECT * FROM storage WHERE device_id = ? [30] 0.58ms] Modules status: Global+ OS Device icmpInMsgs.0 = 172 icmpInErrors.0 = 0 icmpInDestUnreachs.0 = 1 icmpInTimeExcds.0 = 0 icmpInParmProbs.0 = 0 icmpInSrcQuenchs.0 = 0 icmpInRedirects.0 = 0 icmpInEchos.0 = 171 icmpInEchoReps.0 = 0 icmpInTimestamps.0 = 0 icmpInTimestampReps.0 = 0 icmpInAddrMasks.0 = 0 icmpInAddrMaskReps.0 = 0 icmpOutMsgs.0 = 171 icmpOutErrors.0 = 0 icmpOutDestUnreachs.0 = 0 icmpOutTimeExcds.0 = 0 icmpOutParmProbs.0 = 0 icmpOutSrcQuenchs.0 = 0 icmpOutRedirects.0 = 0 icmpOutEchos.0 = 0 icmpOutEchoReps.0 = 171 icmpOutTimestamps.0 = 0 icmpOutTimestampReps.0 = 0 icmpOutAddrMasks.0 = 0 icmpOutAddrMaskReps.0 = 0 ipForwDatagrams.0 = 0 ipInDelivers.0 = 42625 ipInReceives.0 = 42759 ipOutRequests.0 = 3567 ipInDiscards.0 = 0 ipOutDiscards.0 = 0 ipOutNoRoutes.0 = 0 ipReasmReqds.0 = 0 ipReasmOKs.0 = 0 ipReasmFails.0 = 0 ipFragOKs.0 = 0 ipFragFails.0 = 0 ipFragCreates.0 = 0 ipInUnknownProtos.0 = 0 ipInHdrErrors.0 = 0 ipInAddrErrors.0 = 134 No Such Object available on this agent at this OID snmpInPkts.0 = 3394 snmpOutPkts.0 = 3393 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 = 9574 snmpInTotalSetVars.0 = 0 snmpInGetRequests.0 = 2274 snmpInGetNexts.0 = 636 snmpInSetRequests.0 = 0 snmpInGetResponses.0 = 0 snmpInTraps.0 = 0 snmpOutTooBigs.0 = 0 snmpOutNoSuchNames.0 = 503 snmpOutBadValues.0 = 0 snmpOutGenErrs.0 = 0 snmpOutGetRequests.0 = 0 snmpOutGetNexts.0 = 0 snmpOutSetRequests.0 = 0 snmpOutGetResponses.0 = 3395 snmpOutTraps.0 = 0 snmpEnableAuthenTraps.0 = enabled snmpSilentDrops.0 = 0 snmpProxyDrops.0 = 0 tcpActiveOpens.0 = 0 tcpPassiveOpens.0 = 0 tcpAttemptFails.0 = 0 tcpEstabResets.0 = 0 tcpCurrEstab.0 = 0 tcpInSegs.0 = 0 tcpOutSegs.0 = 0 tcpRetransSegs.0 = 0 tcpInErrs.0 = 0 tcpOutRsts.0 = 0 mib-* = 42412 mib-* = 42412 udpInDatagrams.0 = 42413 udpOutDatagrams.0 = 3404 udpInErrors.0 = 0 udpNoPorts.0 = 39011 Modules status: Global+ OS Device hrSystemProcesses.0 = No Such Object available on this agent at this OID hrSystemNumUsers.0 = No Such Object available on this agent at this OID Modules status: Global+ OS Device systemStats = No Such Object available on this agent at this OID 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 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 Modules status: Global+ OS Device ipSystemStatsTable = No Such Object available on this agent at this OID Modules status: Global+ OS Device 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 [30] 1.98ms] ifXEntry = No Such Object available on this agent at this OID ifIndex.1 = 1 ifIndex.2 = 2 ifIndex.3 = 3 ifIndex.4 = 4 ifDescr.1 = lo ifDescr.2 = eth0 ifDescr.3 = ppp0 ifDescr.4 = ppp1 ifType.1 = other ifType.2 = iso88023Csmacd ifType.3 = ppp ifType.4 = ppp ifMtu.1 = 1500 ifMtu.2 = 1500 ifMtu.3 = 1500 ifMtu.4 = 1500 ifSpeed.1 = 0 ifSpeed.2 = 100000000 ifSpeed.3 = 9600 ifSpeed.4 = 9600 ifPhysAddress.1 = 0 ifPhysAddress.2 = 0:6:67:21:54:b1 ifPhysAddress.3 = 0 ifPhysAddress.4 = 0 ifAdminStatus.1 = up ifAdminStatus.2 = up ifAdminStatus.3 = down ifAdminStatus.4 = down ifOperStatus.1 = up ifOperStatus.2 = up ifOperStatus.3 = down ifOperStatus.4 = down ifLastChange.1 = 0 ifLastChange.2 = 0 ifLastChange.3 = 0 ifLastChange.4 = 0 ifInOctets.1 = 0 ifInOctets.2 = 6944560 ifInOctets.3 = 0 ifInOctets.4 = 0 ifInUcastPkts.1 = 0 ifInUcastPkts.2 = 3649 ifInUcastPkts.3 = 0 ifInUcastPkts.4 = 0 ifInNUcastPkts.1 = 0 ifInNUcastPkts.2 = 53419 ifInNUcastPkts.3 = 0 ifInNUcastPkts.4 = 0 ifInDiscards.1 = 0 ifInDiscards.2 = 0 ifInDiscards.3 = 0 ifInDiscards.4 = 0 ifInErrors.1 = 0 ifInErrors.2 = 8246 ifInErrors.3 = 0 ifInErrors.4 = 0 ifInUnknownProtos.1 = 0 ifInUnknownProtos.2 = 0 ifInUnknownProtos.3 = 0 ifInUnknownProtos.4 = 0 ifOutOctets.1 = 0 ifOutOctets.2 = 439251 ifOutOctets.3 = 0 ifOutOctets.4 = 0 ifOutUcastPkts.1 = 0 ifOutUcastPkts.2 = 3648 ifOutUcastPkts.3 = 0 ifOutUcastPkts.4 = 0 ifOutNUcastPkts.1 = 0 ifOutNUcastPkts.2 = 4 ifOutNUcastPkts.3 = 0 ifOutNUcastPkts.4 = 0 ifOutDiscards.1 = 0 ifOutDiscards.2 = 0 ifOutDiscards.3 = 0 ifOutDiscards.4 = 0 ifOutErrors.1 = 0 ifOutErrors.2 = 0 ifOutErrors.3 = 0 ifOutErrors.4 = 0 ifOutQLen.1 = 0 ifOutQLen.2 = 0 ifOutQLen.3 = 0 ifOutQLen.4 = 0 ifSpecific.1 = zeroDotZero ifSpecific.2 = zeroDotZero ifSpecific.3 = zeroDotZero ifSpecific.4 = zeroDotZero dot3StatsDuplexStatus = No Such Object available on this agent at this OID dot1qPvid = No Such Object available on this agent at this OID SQL[SELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl') [30] 0.87ms] array ( 1 => array ( 'ifIndex' => '1', 'ifDescr' => 'lo', 'ifType' => 'other', 'ifMtu' => '1500', 'ifSpeed' => '0', 'ifPhysAddress' => '0', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '0', 'ifInOctets' => '0', 'ifInUcastPkts' => '0', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '0', 'ifOutUcastPkts' => '0', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 2 => array ( 'ifIndex' => '2', 'ifDescr' => 'eth0', 'ifType' => 'iso88023Csmacd', 'ifMtu' => '1500', 'ifSpeed' => '100000000', 'ifPhysAddress' => '0:6:67:21:54:b1', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '0', 'ifInOctets' => '6944560', 'ifInUcastPkts' => '3649', 'ifInNUcastPkts' => '53419', 'ifInDiscards' => '0', 'ifInErrors' => '8246', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '439251', 'ifOutUcastPkts' => '3648', 'ifOutNUcastPkts' => '4', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 3 => array ( 'ifIndex' => '3', 'ifDescr' => 'ppp0', 'ifType' => 'ppp', 'ifMtu' => '1500', 'ifSpeed' => '9600', 'ifPhysAddress' => '0', 'ifAdminStatus' => 'down', 'ifOperStatus' => 'down', 'ifLastChange' => '0', 'ifInOctets' => '0', 'ifInUcastPkts' => '0', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '0', 'ifOutUcastPkts' => '0', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 4 => array ( 'ifIndex' => '4', 'ifDescr' => 'ppp1', 'ifType' => 'ppp', 'ifMtu' => '1500', 'ifSpeed' => '9600', 'ifPhysAddress' => '0', 'ifAdminStatus' => 'down', 'ifOperStatus' => 'down', 'ifLastChange' => '0', 'ifInOctets' => '0', 'ifInUcastPkts' => '0', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '0', 'ifOutUcastPkts' => '0', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), ) valid valid valid valid ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed Using ifDescr as ifAlias Using ifDescr as ifName ifInOctets (0 B) 0 Bps 225 secs ifOutOctets (0 B) 0 Bps 225 secs ifInErrors (0 B) 0 Bps 225 secs ifOutErrors (0 B) 0 Bps 225 secs ifInUcastPkts (0 B) 0 Bps 225 secs ifOutUcastPkts (0 B) 0 Bps 225 secs ifInNUcastPkts (0 B) 0 Bps 225 secs ifOutNUcastPkts (0 B) 0 Bps 225 secs ifInDiscards (0 B) 0 Bps 225 secs ifOutDiscards (0 B) 0 Bps 225 secs ifInUnknownProtos (0 B) 0 Bps 225 secs ifInBroadcastPkts (0 B) 0 Bps 225 secs ifOutBroadcastPkts (0 B) 0 Bps 225 secs ifInMulticastPkts (0 B) 0 Bps 225 secs ifOutMulticastPkts (0 B) 0 Bps 225 secs SQL[UPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`ifLastChange`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=? WHERE `port_id` = ? [1577149455,1577149230,225,"0","0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,188] 1.26ms] SQL[UPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? ["0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,188] 1.15ms] 1 updated ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed Using ifDescr as ifAlias Using ifDescr as ifName ifInOctets (324989 B) 1444.3955555556 Bps 225 secs ifOutOctets (35777 B) 159.00888888889 Bps 225 secs ifInErrors (231 B) 1.0266666666667 Bps 225 secs ifOutErrors (0 B) 0 Bps 225 secs ifInUcastPkts (257 B) 1.1422222222222 Bps 225 secs ifOutUcastPkts (257 B) 1.1422222222222 Bps 225 secs ifInNUcastPkts (2602 B) 11.564444444444 Bps 225 secs ifOutNUcastPkts (0 B) 0 Bps 225 secs ifInDiscards (0 B) 0 Bps 225 secs ifOutDiscards (0 B) 0 Bps 225 secs ifInUnknownProtos (0 B) 0 Bps 225 secs ifInBroadcastPkts (0 B) 0 Bps 225 secs ifOutBroadcastPkts (0 B) 0 Bps 225 secs ifInMulticastPkts (0 B) 0 Bps 225 secs ifOutMulticastPkts (0 B) 0 Bps 225 secs SQL[UPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`ifLastChange`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=? WHERE `port_id` = ? [1577149455,1577149230,225,"0","6944560",6619571,1444.3955555555556,324989,"439251",403474,159.0088888888889,35777,"8246",8015,1.0266666666666666,231,"0",0,0,0,"3649",3392,1.1422222222222222,257,"3648",3391,1.1422222222222222,257,189] 1.12ms] SQL[UPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? ["53419",50817,11.564444444444444,2602,"4",4,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,189] 1.03ms] 2 updated ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed Using ifDescr as ifAlias Using ifDescr as ifName ifInOctets (0 B) 0 Bps 225 secs ifOutOctets (0 B) 0 Bps 225 secs ifInErrors (0 B) 0 Bps 225 secs ifOutErrors (0 B) 0 Bps 225 secs ifInUcastPkts (0 B) 0 Bps 225 secs ifOutUcastPkts (0 B) 0 Bps 225 secs ifInNUcastPkts (0 B) 0 Bps 225 secs ifOutNUcastPkts (0 B) 0 Bps 225 secs ifInDiscards (0 B) 0 Bps 225 secs ifOutDiscards (0 B) 0 Bps 225 secs ifInUnknownProtos (0 B) 0 Bps 225 secs ifInBroadcastPkts (0 B) 0 Bps 225 secs ifOutBroadcastPkts (0 B) 0 Bps 225 secs ifInMulticastPkts (0 B) 0 Bps 225 secs ifOutMulticastPkts (0 B) 0 Bps 225 secs SQL[UPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`ifLastChange`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=? WHERE `port_id` = ? [1577149455,1577149230,225,"0","0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,190] 1.12ms] SQL[UPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? ["0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,190] 1.01ms] 1 updated ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed Using ifDescr as ifAlias Using ifDescr as ifName ifInOctets (0 B) 0 Bps 225 secs ifOutOctets (0 B) 0 Bps 225 secs ifInErrors (0 B) 0 Bps 225 secs ifOutErrors (0 B) 0 Bps 225 secs ifInUcastPkts (0 B) 0 Bps 225 secs ifOutUcastPkts (0 B) 0 Bps 225 secs ifInNUcastPkts (0 B) 0 Bps 225 secs ifOutNUcastPkts (0 B) 0 Bps 225 secs ifInDiscards (0 B) 0 Bps 225 secs ifOutDiscards (0 B) 0 Bps 225 secs ifInUnknownProtos (0 B) 0 Bps 225 secs ifInBroadcastPkts (0 B) 0 Bps 225 secs ifOutBroadcastPkts (0 B) 0 Bps 225 secs ifInMulticastPkts (0 B) 0 Bps 225 secs ifOutMulticastPkts (0 B) 0 Bps 225 secs SQL[UPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`ifLastChange`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=? WHERE `port_id` = ? [1577149455,1577149230,225,"0","0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,191] 1.17ms] SQL[UPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? ["0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,191] 1ms] 1 updated Modules status: Global+ OS Device SQL[SELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [30] 0.67ms] Modules status: Global+ OS Device SQL[SELECT * FROM `bgpPeers` AS B LEFT JOIN `vrfs` AS V ON `B`.`vrf_id` = `V`.`vrf_id` WHERE `B`.`device_id` = ? [30] 0.71ms] Modules status: Global- OS Device Modules status: Global- OS Device Modules status: Global+ OS Device SQL[SELECT * FROM `ucd_diskio` WHERE `device_id` = ? [30] 0.49ms] Modules status: Global- OS Device Modules status: Global+ OS Device Attempting to initialize OS: poweralert OS initialized as Generic SQL[SELECT * FROM `wireless_sensors` WHERE `device_id` = ? [30] 0.69ms] Modules status: Global+ OS Device SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [30] 0.7ms] ospfGeneralGroup = No Such Object available on this agent at this OID array ( ) SQL[delete from `ospf_instances` where (`device_id` = ? and `context_name` is null) and 1 = 1 [30] 0.63ms] Modules status: Global- OS Device Modules status: Global- OS Device Modules status: Global- OS Device Modules status: Global- OS Device Modules status: Global- OS Device Modules status: Global- OS Device Modules status: Global- OS Device Modules status: Global- OS Device Modules status: Global- OS Device Modules status: Global- OS Device Modules status: Global- OS Device Modules status: Global- OS Device Modules status: Global- OS Device Modules status: Global- OS Device Modules status: Global- OS Device Modules status: Global- OS Device Modules status: Global- OS Device Modules status: Global+ OS Device SQL[SELECT * FROM `entPhysical_state` WHERE `device_id` = ? [30] 0.61ms] Modules status: Global- OS Device Modules status: Global+ OS Device SQL[SELECT * FROM `applications` WHERE `device_id` = ? [30] 0.63ms] Modules status: Global- OS Device Modules status: Global+ OS Device SQL[SELECT * FROM `stp` WHERE `device_id` = ? [30] 0.61ms] No Such Object available on this agent at this OID Modules status: Global+ OS Device Modules status: Global- OS Device Modules status: Global- OS Device Modules status: Global+ OS Device Attempting to initialize OS: poweralert OS initialized as Generic SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [30] 1.01ms] SQL[select * from `device_groups` [] 0.6ms] SQL[select * from `device_group_device` where `device_id` = ? [30] 0.48ms] Groups Added: Groups Removed: SQL[SELECT `graph` FROM `device_graphs` WHERE `device_id` = ? [30] 0.58ms] SQL[UPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=?,`last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [550,1.56,3.974,30] 1.3ms] Updating tlups1 SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [30] 0.71ms] 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` = ? [30] 0.61ms] SQL[select exists(select * from `alert_schedule` inner join `alert_schedulables` on `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` where ((`recurring` = ? and `start` <= NOW() and `end` >= NOW()) or (`recurring` = ? and (`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` = ? or `end_recurring_dt` = ?)) and `start_recurring_hr` <= date_format(NOW(), '%H:%i:%s') and `end_recurring_hr` >= date_format(NOW(), '%H:%i:%s') and (`recurring_day` like CONCAT('%', date_format(NOW(), ''), '%') or `recurring_day` is null or `recurring_day` = ?))) and ((`alert_schedulable_type` = ? and `alert_schedulable_id` = ?) or (`alert_schedulable_type` = ? and 0 = 1))) as `exists` [0,1,"0000-00-00","","","device",30,"device_group"] 1.02ms] SQL[SELECT 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=?) [30,30] 2.12ms] SQL[INSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES (:type,:doing,:start,:duration,:devices,:poller) {"type":"poll","doing":"tlups1","start":1577149451.081733,"duration":"4.470","devices":1,"poller":null} 7.49ms] ./poller.php tlups1 2019-12-23 19:04:15 - 1 devices polled in 4.470 secs title: name: librenms private: 1 expire: 0 https://p.libren.ms/view/f7f10dc0