-bash-4.2$ ./discovery.php -h tlups1 -d | ./pbin.sh Paste endpoint: https://p.libren.ms/api/create SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.92ms] SQL[select count(*) as aggregate from `migrations` limit 1 [] 0.51ms] SQL[SELECT version() [] 0.4ms] Updating os_def.cache... Done SQL[SELECT * FROM `devices` WHERE disabled = 0 AND snmp_disable = 0 AND `hostname` LIKE 'tlups1' ORDER BY device_id DESC [] 4.36ms] SQL[select * from `devices` where `device_id` = ? limit 1 [30] 3.22ms] SQL[select * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [30] 1.95ms] [FPING] '/usr/sbin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' 'tlups1' array ( 'xmt' => 3, 'rcv' => 3, 'loss' => 0, 'min' => 1.31, 'max' => 10.8, 'avg' => 4.59, '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.31,"max":10.8,"avg":4.59,"device_id":30,"debug":"[]"} 1.53ms] SNMP Check response code: 0 Attempting to initialize OS: poweralert OS initialized as Generic Modules status: Global+ OS Device .*.*.0 = tlup1.int.dittman.net .*.*.0 = .*.4.1.850.1 .*.*.0 = POWERALERT 12 Modules status: Global+ OS+ Device POWERALERT 12 .*.4.1.850.1 | POWERALERT 12 | .1.3.6.1.4.1.850.1 | No Such Object available on this agent at this OID No Such Object available on this agent at this OID No Such Object available on this agent at this OID No Such Object available on this agent at this OID No Such Instance currently exists at this OID Modules status: Global+ OS+ Device ifDescr.1 = lo ifDescr.2 = eth0 ifDescr.3 = ppp0 ifDescr.4 = ppp1 ifName = No Such Object available on this agent at this OID ifAlias = No Such Object available on this agent at this OID ifType.1 = other ifType.2 = iso88023Csmacd ifType.3 = ppp ifType.4 = ppp array ( 1 => array ( 'ifDescr' => 'lo', 'ifType' => 'other', ), 2 => array ( 'ifDescr' => 'eth0', 'ifType' => 'iso88023Csmacd', ), 3 => array ( 'ifDescr' => 'ppp0', 'ifType' => 'ppp', ), 4 => array ( 'ifDescr' => 'ppp1', 'ifType' => 'ppp', ), ) SQL[SELECT * FROM `ports` WHERE `device_id` = ? ORDER BY port_id [30] 1.38ms] Using ifDescr as ifAlias Using ifDescr as ifName SQL[UPDATE `ports` set `ifDescr`=?,`ifType`=?,`ifIndex`=?,`ifAlias`=?,`ifName`=? WHERE `port_id` = ? ["lo","other",1,"lo","lo",188] 9.14ms] Using ifDescr as ifAlias Using ifDescr as ifName SQL[UPDATE `ports` set `ifDescr`=?,`ifType`=?,`ifIndex`=?,`ifAlias`=?,`ifName`=? WHERE `port_id` = ? ["eth0","iso88023Csmacd",2,"eth0","eth0",189] 7.39ms] Using ifDescr as ifAlias Using ifDescr as ifName SQL[UPDATE `ports` set `ifDescr`=?,`ifType`=?,`ifIndex`=?,`ifAlias`=?,`ifName`=? WHERE `port_id` = ? ["ppp0","ppp",3,"ppp0","ppp0",190] 1.01ms] Using ifDescr as ifAlias Using ifDescr as ifName SQL[UPDATE `ports` set `ifDescr`=?,`ifType`=?,`ifIndex`=?,`ifAlias`=?,`ifName`=? WHERE `port_id` = ? ["ppp1","ppp",4,"ppp1","ppp1",191] 0.96ms] Modules status: Global+ OS+ Device SQL[SELECT * FROM `ports_stack` WHERE `device_id` = '30' [] 0.5ms] ifStackStatus = No Such Object available on this agent at this OID Modules status: Global+ OS+ Device entPhysicalEntry = No Such Object available on this agent at this OID SQL[SELECT * FROM `entPhysical` WHERE `device_id` = ? [30] 0.91ms] Modules status: Global- OS- Device Modules status: Global+ OS+ Device No YAML Discovery data. hrProcessorLoad = No Such Object available on this agent at this OID SQL[select * from `locations` where `locations`.`id` = ? limit 1 [5] 0.62ms] SQL[select * from `vrf_lite_cisco` where `vrf_lite_cisco`.`device_id` = ? and `vrf_lite_cisco`.`device_id` is not null [30] 0.78ms] No Such Object available on this agent at this OID SQL[SELECT * FROM `processors` WHERE `device_id`=? [30] 0.87ms] SQL[DELETE T FROM `processors` T LEFT JOIN `devices` ON `devices`.`device_id` = T.`device_id` WHERE `devices`.`device_id` IS NULL [] 0.7ms] Modules status: Global+ OS+ Device SQL[SELECT COUNT(*) FROM `mempools` WHERE `device_id` = ? AND `mempool_type` = 'cemp' [30] 0.52ms] dellNetCpuUtilTable = No Such Object available on this agent at this OID dellNetProcessorEntry = No Such Object available on this agent at this OID hpLocalMem = No Such Object available on this agent at this OID hpGlobalMem = No Such Object available on this agent at this OID hrStorageEntry = No Such Object available on this agent at this OID memoryUsageTable = No Such Object available on this agent at this OID memStatsTable = No Such Object available on this agent at this OID SQL[SELECT * FROM `mempools` WHERE `device_id` = '30' [] 0.97ms] Modules status: Global+ OS+ Device SQL[SELECT * FROM vrf_lite_cisco WHERE device_id = ? [30] 0.47ms] 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 ipAdEntIfIndex.* 1 ipAdEntIfIndex.* 2 * SQL[SELECT COUNT(*) FROM `ports` WHERE device_id = ? AND `ifIndex` = ? [30,"1"] 0.88ms] SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [30,"1"] 0.62ms] SQL[SELECT COUNT(*) FROM `ipv4_networks` WHERE `ipv4_network` = ? ["127.0.0.0\/8"] 0.59ms] SQL[UPDATE `ipv4_networks` set `context_name`=? WHERE `ipv4_network` = ? [null,"127.0.0.0\/8"] 11.43ms] SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = ? ["127.0.0.0\/8"] 0.55ms] SQL[SELECT COUNT(*) FROM `ipv4_addresses` WHERE `ipv4_address` = ? AND `ipv4_prefixlen` = ? AND `port_id` = ? ["127.0.0.1",8,188] 0.56ms] SQL[UPDATE `ipv4_addresses` set `context_name`=? WHERE `ipv4_address` = ? AND `ipv4_prefixlen` = ? AND `port_id` = ? [null,"127.0.0.1",8,188] 6.21ms] * SQL[SELECT COUNT(*) FROM `ports` WHERE device_id = ? AND `ifIndex` = ? [30,"2"] 0.77ms] SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [30,"2"] 0.56ms] SQL[SELECT COUNT(*) FROM `ipv4_networks` WHERE `ipv4_network` = ? ["192.94.152.0\/24"] 0.53ms] SQL[UPDATE `ipv4_networks` set `context_name`=? WHERE `ipv4_network` = ? [null,"192.94.152.0\/24"] 1.12ms] SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = ? ["192.94.152.0\/24"] 0.55ms] SQL[SELECT COUNT(*) FROM `ipv4_addresses` WHERE `ipv4_address` = ? AND `ipv4_prefixlen` = ? AND `port_id` = ? ["192.94.152.251",24,189] 0.62ms] SQL[UPDATE `ipv4_addresses` set `context_name`=? WHERE `ipv4_address` = ? AND `ipv4_prefixlen` = ? AND `port_id` = ? [null,"192.94.152.251",24,189] 0.97ms] SQL[SELECT `ipv4_addresses`.*, `ports`.`device_id`, `ports`.`ifIndex` FROM `ipv4_addresses` LEFT JOIN `ports` ON `ipv4_addresses`.`port_id` = `ports`.`port_id` WHERE `ports`.device_id = ? OR `ports`.`device_id` IS NULL [30] 0.93ms] Modules status: Global+ OS+ Device ipAddressIfIndex.ipv6 No Such Object available on this agent at this OID .*.*.8.1.2 No Such Object available on this agent at this OID SQL[SELECT `ipv6_addresses`.*, `ports`.`device_id`, `ports`.`ifIndex` FROM `ipv6_addresses` LEFT JOIN `ports` ON `ipv6_addresses`.`port_id` = `ports`.`port_id` WHERE `ports`.device_id = ? OR `ports`.`device_id` IS NULL [30] 0.96ms] Modules status: Global- OS- Device Modules status: Global+ OS+ Device 9725AY0AC699600158 array ( 'poweralert_serial' => '9725AY0AC699600158', ) entPhysicalDescr = No Such Instance currently exists at this OID SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["voltage",30,"ipmi"] 1.98ms] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["temperature",30,"ipmi"] 1.15ms] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["fanspeed",30,"ipmi"] 1.01ms] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["power",30,"ipmi"] 1.02ms] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["airflow",30,"snmp"] 0.98ms] No Such Instance currently exists at this OID upsOutputCurrent[1] = No Such Instance currently exists at this OID upsInputCurrent[1] = No Such Instance currently exists at this OID upsBypassCurrent[1] = No Such Instance currently exists at this OID SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["current",30,"snmp"] 1.42ms] 100 Discover sensor: .1.3.6.1.2.1.33.1.2.4.0, 500, rfc1628, Battery charge remaining, snmp, 1, 1, , 100, (limits: LL: 15, LW: 50, W: , H: 101) SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","charge",30,"rfc1628","500"] 0.93ms] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["charge",30,"rfc1628","500"] 0.77ms] array ( 'rfc1628' => array ( 500 => 1, ), ) SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["charge",30,"snmp"] 1.09ms] 500 -> rfc1628 SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["dbm",30,"snmp"] 0.96ms] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["fanspeed",30,"snmp"] 0.97ms] upsInputFrequency[1] = 600 Discover sensor: .1.3.6.1.2.1.33.1.3.3.1.2.1, 3.2.0.1, rfc1628, Input, snmp, 10, 1, , 60, (limits: LL: , LW: , W: , H: ) SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","frequency",30,"rfc1628","3.2.0.1"] 1.17ms] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["frequency",30,"rfc1628","3.2.0.1"] 1ms] 600 Discover sensor: .1.3.6.1.2.1.33.1.4.2.0, 4.2.0, rfc1628, Output, snmp, 10, 1, , 60, (limits: LL: , LW: , W: , H: ) SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","frequency",30,"rfc1628","4.2.0"] 1.07ms] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["frequency",30,"rfc1628","4.2.0"] 0.93ms] 600 Discover sensor: .1.3.6.1.2.1.33.1.5.1.0, 5.1.0, rfc1628, Bypass, snmp, 10, 1, , 60, (limits: LL: , LW: , W: , H: ) SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","frequency",30,"rfc1628","5.1.0"] 1.1ms] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["frequency",30,"rfc1628","5.1.0"] 0.92ms] array ( 'rfc1628' => array ( '3.2.0.1' => 1, '4.2.0' => 1, '5.1.0' => 1, ), ) SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["frequency",30,"snmp"] 1.31ms] 3.2.0.1 -> rfc1628 4.2.0 -> rfc1628 5.1.0 -> rfc1628 SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["humidity",30,"snmp"] 1.1ms] upsOutputPercentLoad[1] = 25 Discover sensor: .1.3.6.1.2.1.33.1.4.4.1.5.1, 501, rfc1628, Percentage load, snmp, 1, 1, , 25, (limits: LL: , LW: , W: , H: ) SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","load",30,"rfc1628","501"] 0.89ms] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["load",30,"rfc1628","501"] 0.81ms] array ( 'rfc1628' => array ( 501 => 1, ), ) SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["load",30,"snmp"] 1.11ms] 501 -> rfc1628 upsOutputPower[1] = No Such Instance currently exists at this OID upsInputTruePower[1] = No Such Instance currently exists at this OID upsBypassPower[1] = No Such Instance currently exists at this OID SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["power",30,"snmp"] 1.36ms] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["power_consumed",30,"snmp"] 1.05ms] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["power_factor",30,"snmp"] 1.06ms] 0 Discover sensor: .1.3.6.1.2.1.33.1.2.2.0, 100, rfc1628, Time on battery, snmp, 60, 1, , 0, (limits: LL: 0, LW: 0, W: 1, H: 2) SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","runtime",30,"rfc1628","100"] 0.92ms] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["runtime",30,"rfc1628","100"] 0.82ms] 30 Discover sensor: .1.3.6.1.2.1.33.1.2.3.0, 200, rfc1628, Estimated battery time remaining, snmp, 1, 1, , 30, (limits: LL: 5, LW: 10, W: , H: 10000) SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","runtime",30,"rfc1628","200"] 1.02ms] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["runtime",30,"rfc1628","200"] 0.87ms] array ( 'rfc1628' => array ( 100 => 1, 200 => 1, ), ) SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["runtime",30,"snmp"] 1.2ms] 100 -> rfc1628 200 -> rfc1628 SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["signal",30,"snmp"] 0.95ms] 2 SQL[SELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 ["upsBatteryStatusState"] 0.79ms] SQL[SELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [43] 0.72ms] Discover sensor: .1.3.6.1.2.1.33.1.2.1.0, 0, upsBatteryStatusState, Battery Status, snmp, 1, 1, 0, 2, (limits: LL: , LW: , W: , H: ) SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","state",30,"upsBatteryStatusState","0"] 0.76ms] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["state",30,"upsBatteryStatusState","0"] 0.86ms] SQL[SELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["state",30,"upsBatteryStatusState",0] 0.75ms] SQL[SELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? ["upsBatteryStatusState"] 0.6ms] SQL[INSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) {"sensor_id":38,"state_index_id":43} 1.28ms] 3 SQL[SELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 ["upsOutputSourceState"] 0.77ms] SQL[SELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [44] 0.71ms] Discover sensor: .1.3.6.1.2.1.33.1.4.1.0, 0, upsOutputSourceState, Output Source, snmp, 1, 1, 0, 3, (limits: LL: , LW: , W: , H: ) SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","state",30,"upsOutputSourceState","0"] 0.77ms] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["state",30,"upsOutputSourceState","0"] 0.86ms] SQL[SELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["state",30,"upsOutputSourceState",0] 0.74ms] SQL[SELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? ["upsOutputSourceState"] 0.58ms] SQL[INSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) {"sensor_id":39,"state_index_id":44} 1.24ms] array ( 'upsBatteryStatusState' => array ( 0 => 1, ), 'upsOutputSourceState' => array ( 0 => 1, ), ) SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["state",30,"snmp"] 1.23ms] 0 -> upsBatteryStatusState 0 -> upsOutputSourceState SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["count",30,"snmp"] 0.95ms] 42 Discover sensor: .1.3.6.1.2.1.33.1.2.7.0, 0, rfc1628, Battery, snmp, 1, 1, , 42, (limits: LL: , LW: , W: , H: ) SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","temperature",30,"rfc1628","0"] 1.03ms] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["temperature",30,"rfc1628","0"] 0.94ms] array ( 'rfc1628' => array ( 0 => 1, ), ) SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["temperature",30,"snmp"] 1.18ms] 0 -> rfc1628 540 Discover sensor: .1.3.6.1.2.1.33.1.2.5.0, 1.2.5.0, rfc1628, Battery, snmp, 10, 1, , 54, (limits: LL: , LW: , W: , H: ) SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","voltage",30,"rfc1628","1.2.5.0"] 1.01ms] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["voltage",30,"rfc1628","1.2.5.0"] 0.93ms] upsOutputVoltage[1] = 119 Discover sensor: .1.3.6.1.2.1.33.1.4.4.1.2.1, 1, rfc1628, Output, snmp, 1, 1, , 119, (limits: LL: , LW: , W: , H: ) SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","voltage",30,"rfc1628","1"] 1.08ms] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["voltage",30,"rfc1628","1"] 0.93ms] upsInputVoltage[1] = 124 Discover sensor: .1.3.6.1.2.1.33.1.3.3.1.3.1, 101, rfc1628, Input, snmp, 1, 1, , 124, (limits: LL: , LW: , W: , H: ) SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","voltage",30,"rfc1628","101"] 1.06ms] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["voltage",30,"rfc1628","101"] 0.89ms] upsBypassVoltage[1] = 124 Discover sensor: .1.3.6.1.2.1.33.1.5.3.1.2.1, 201, rfc1628, Bypass, snmp, 1, 1, , 124, (limits: LL: , LW: , W: , H: ) SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","voltage",30,"rfc1628","201"] 0.97ms] SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["voltage",30,"rfc1628","201"] 0.83ms] array ( 'rfc1628' => array ( '1.2.5.0' => 1, 1 => 1, 101 => 1, 201 => 1, ), ) SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["voltage",30,"snmp"] 1.2ms] 1.2.5.0 -> rfc1628 1 -> rfc1628 101 -> rfc1628 201 -> rfc1628 SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["snr",30,"snmp"] 0.97ms] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["pressure",30,"snmp"] 0.99ms] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["cooling",30,"snmp"] 0.95ms] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["delay",30,"snmp"] 0.9ms] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["quality_factor",30,"snmp"] 0.91ms] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["chromatic_dispersion",30,"snmp"] 0.9ms] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["ber",30,"snmp"] 0.9ms] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["eer",30,"snmp"] 0.9ms] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? ["waterflow",30,"snmp"] 1ms] Modules status: Global+ OS+ Device MIB search path: /opt/librenms/mibs:/opt/librenms/mibs/poweralert Cannot find module (IBM-AIX-MIB): At line 1 in (none) aixFsTableEntry: Unknown Object Identifier (Sub-id not found: (top) -> aixFsTableEntry) SQL[SELECT `storage_descr` FROM `storage` WHERE `device_id` = '30' AND `storage_type` != 'aixFileSystem' [] 0.73ms] fileSystemSpaceTable = No Such Object available on this agent at this OID hrStorageEntry = No Such Object available on this agent at this OID dskTable = No Such Object available on this agent at this OID SQL[SELECT `storage_descr` FROM `storage` WHERE `device_id` = '30' AND `storage_type` != 'dsk' [] 0.74ms] SQL[SELECT * FROM `storage` WHERE `device_id` = '30' [] 0.55ms] Modules status: Global+ OS+ Device hrDeviceEntry = No Such Object available on this agent at this OID hrProcessorEntry = No Such Object available on this agent at this OID array ( ) SQL[SELECT * FROM `hrDevice` WHERE `device_id` = '30' [] 0.82ms] Modules status: Global+ OS+ Device cdpCache = No Such Object available on this agent at this OID lldpRemTable = No Such Object available on this agent at this OID SQL[SELECT DISTINCT(`ospfNbrIpAddr`),`device_id` FROM `ospf_nbrs` WHERE `device_id`=? [30] 0.81ms] SQL[SELECT * FROM `links` AS L, `ports` AS I WHERE L.local_port_id = I.port_id AND I.device_id = ? [30] 1.11ms] SQL[DELETE T FROM `links` T LEFT JOIN `devices` ON `devices`.`device_id` = T.`local_device_id` WHERE `devices`.`device_id` IS NULL [] 0.52ms] 0 orphaned links deleted Modules status: Global+ OS+ Device ipNetToPhysicalPhysAddress = No Such Object available on this agent at this OID ipNetToMediaPhysAddress = No Such Instance currently exists at this OID SQL[SELECT * from `ipv4_mac` WHERE `device_id`=? AND `context_name`=? [30,""] 1.35ms] SQL[DELETE T FROM `ipv4_mac` T LEFT JOIN `ports` ON `ports`.`port_id` = T.`port_id` LEFT JOIN `devices` ON `devices`.`device_id` = T.`device_id` WHERE `ports`.`port_id` IS NULL AND `devices`.`device_id` IS NULL [] 1.44ms] Modules status: Global- OS- Device Modules status: Global- OS- Device Modules status: Global+ OS+ Device "Tripp Lite" Peers : SQL[DELETE FROM `bgpPeers` WHERE device_id=? AND context_name=? [30,""] 0.57ms] SQL[DELETE FROM `bgpPeers_cbgp` WHERE device_id=? AND context_name=? [30,""] 0.44ms] SQL[SELECT DISTINCT context_name FROM bgpPeers WHERE device_id=? [30] 0.61ms] Modules status: Global+ OS+ Device SQL[SELECT * FROM `vlans` WHERE `device_id` = ? [30] 0.55ms] dot1dBasePortIfIndex = No Such Object available on this agent at this OID 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 diskIOEntry = No Such Object available on this agent at this OID array ( ) SQL[SELECT * FROM `ucd_diskio` where `device_id` = '30' [] 0.65ms] Modules status: Global- OS- Device Modules status: Global+ OS+ Device Modules status: Global+ OS+ Device SQL[SELECT * FROM `stp` WHERE `device_id` = ? [30] 0.53ms] 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 SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"ap-count"] 0.95ms] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"clients"] 0.64ms] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"quality"] 0.67ms] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"capacity"] 0.65ms] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"utilization"] 0.65ms] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"rate"] 0.65ms] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"ccq"] 0.78ms] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"snr"] 0.72ms] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"sinr"] 0.7ms] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"rsrp"] 0.73ms] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"rsrq"] 0.7ms] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"ssr"] 0.7ms] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"mse"] 0.7ms] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"xpi"] 0.69ms] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"rssi"] 0.75ms] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"power"] 0.68ms] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"noise-floor"] 0.66ms] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"errors"] 0.66ms] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"error-ratio"] 0.59ms] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"error-rate"] 0.67ms] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"frequency"] 0.67ms] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"distance"] 0.7ms] Modules status: Global+ OS+ Device SQL[SELECT `vlan_id`, `vlan_vlan` from `vlans` WHERE `device_id` = ? [30] 0.49ms] SQL[SELECT * FROM `ports_fdb` WHERE `device_id` = ? [30] 0.53ms] dot1qTpFdbPort = No Such Object available on this agent at this OID dot1dTpFdbPort = No Such Object available on this agent at this OID Modules status: Global+ OS+ Device SQL[UPDATE `devices` set `last_discovered`=NOW(),`last_discovered_timetaken`=? WHERE `device_id` = ? [7.143,30] 1.43ms] SQL[INSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES (:type,:doing,:start,:duration,:devices,:poller) {"type":"discover","doing":"tlups1","start":1577149261.115333,"duration":"7.682","devices":1,"poller":"librenms.int.dittman.net"} 0.92ms] ./discovery.php tlups1 2019-12-23 19:01:08 - 1 devices discovered in 7.682 secs title: name: librenms private: 1 expire: 0 https://p.libren.ms/view/8265e217