validate for older card

From dittman, 4 Years ago, written in Plain Text.
URL https://p.libren.ms/view/1d2d1ea0
Embed
Download Paste or View Raw
  1. -bash-4.2$ ./discovery.php -h tlups1 -d | ./pbin.sh
  2. Paste endpoint: https://p.libren.ms/api/create
  3. SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.92ms]
  4.  
  5. SQL[select count(*) as aggregate from `migrations` limit 1 [] 0.51ms]
  6.  
  7. SQL[SELECT version() [] 0.4ms]
  8.  
  9. Updating os_def.cache...  
  10. Done  
  11. SQL[SELECT * FROM `devices` WHERE disabled = 0 AND snmp_disable = 0 AND `hostname` LIKE 'tlups1' ORDER BY device_id DESC [] 4.36ms]
  12.  
  13. SQL[select * from `devices` where `device_id` = ? limit 1 [30] 3.22ms]
  14.  
  15. SQL[select * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [30] 1.95ms]
  16.  
  17. [FPING] '/usr/sbin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' 'tlups1'  
  18. array (
  19.   'xmt' => 3,
  20.   'rcv' => 3,
  21.   'loss' => 0,
  22.   'min' => 1.31,
  23.   'max' => 10.8,
  24.   'avg' => 4.59,
  25.   'dup' => 0,
  26.   'exitcode' => 0,
  27. )  
  28. 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]
  29.  
  30. SNMP Check response code: 0  
  31. Attempting to initialize OS: poweralert  
  32. OS initialized as Generic  
  33. Modules status: Global+  
  34. OS  
  35. Device  
  36. .*.*.0 = tlup1.int.dittman.net
  37. .*.*.0 = .*.4.1.850.1
  38. .*.*.0 = POWERALERT 12  
  39.  
  40. Modules status: Global+  
  41. OS+  
  42. Device  
  43. POWERALERT 12  
  44.  
  45. .*.4.1.850.1  
  46.  
  47. | POWERALERT 12 | .1.3.6.1.4.1.850.1 |  
  48. No Such Object available on this agent at this OID  
  49.  
  50. No Such Object available on this agent at this OID  
  51.  
  52. No Such Object available on this agent at this OID  
  53.  
  54. No Such Object available on this agent at this OID  
  55.  
  56. No Such Instance currently exists at this OID  
  57.  
  58. Modules status: Global+  
  59. OS+  
  60. Device  
  61. ifDescr.1 = lo
  62. ifDescr.2 = eth0
  63. ifDescr.3 = ppp0
  64. ifDescr.4 = ppp1  
  65.  
  66. ifName = No Such Object available on this agent at this OID  
  67.  
  68. ifAlias = No Such Object available on this agent at this OID  
  69.  
  70. ifType.1 = other
  71. ifType.2 = iso88023Csmacd
  72. ifType.3 = ppp
  73. ifType.4 = ppp  
  74.  
  75. array (
  76.   1 =>
  77.   array (
  78.     'ifDescr' => 'lo',
  79.     'ifType' => 'other',
  80.   ),
  81.   2 =>
  82.   array (
  83.     'ifDescr' => 'eth0',
  84.     'ifType' => 'iso88023Csmacd',
  85.   ),
  86.   3 =>
  87.   array (
  88.     'ifDescr' => 'ppp0',
  89.     'ifType' => 'ppp',
  90.   ),
  91.   4 =>
  92.   array (
  93.     'ifDescr' => 'ppp1',
  94.     'ifType' => 'ppp',
  95.   ),
  96. )  
  97. SQL[SELECT * FROM `ports` WHERE `device_id` = ? ORDER BY port_id [30] 1.38ms]
  98.  
  99.  Using ifDescr as ifAlias  
  100.  Using ifDescr as ifName  
  101. SQL[UPDATE `ports` set `ifDescr`=?,`ifType`=?,`ifIndex`=?,`ifAlias`=?,`ifName`=? WHERE `port_id` = ? ["lo","other",1,"lo","lo",188] 9.14ms]
  102.  
  103.  Using ifDescr as ifAlias  
  104.  Using ifDescr as ifName  
  105. SQL[UPDATE `ports` set `ifDescr`=?,`ifType`=?,`ifIndex`=?,`ifAlias`=?,`ifName`=? WHERE `port_id` = ? ["eth0","iso88023Csmacd",2,"eth0","eth0",189] 7.39ms]
  106.  
  107.  Using ifDescr as ifAlias  
  108.  Using ifDescr as ifName  
  109. SQL[UPDATE `ports` set `ifDescr`=?,`ifType`=?,`ifIndex`=?,`ifAlias`=?,`ifName`=? WHERE `port_id` = ? ["ppp0","ppp",3,"ppp0","ppp0",190] 1.01ms]
  110.  
  111.  Using ifDescr as ifAlias  
  112.  Using ifDescr as ifName  
  113. SQL[UPDATE `ports` set `ifDescr`=?,`ifType`=?,`ifIndex`=?,`ifAlias`=?,`ifName`=? WHERE `port_id` = ? ["ppp1","ppp",4,"ppp1","ppp1",191] 0.96ms]
  114.  
  115. Modules status: Global+  
  116. OS+  
  117. Device  
  118. SQL[SELECT * FROM `ports_stack` WHERE `device_id` = '30' [] 0.5ms]
  119.  
  120. ifStackStatus = No Such Object available on this agent at this OID  
  121.  
  122. Modules status: Global+  
  123. OS+  
  124. Device  
  125. entPhysicalEntry = No Such Object available on this agent at this OID  
  126.  
  127. SQL[SELECT * FROM `entPhysical` WHERE `device_id` = ? [30] 0.91ms]
  128.  
  129. Modules status: Global-  
  130. OS-  
  131. Device  
  132. Modules status: Global+  
  133. OS+  
  134. Device  
  135. No YAML Discovery data.  
  136. hrProcessorLoad = No Such Object available on this agent at this OID  
  137.  
  138. SQL[select * from `locations` where `locations`.`id` = ? limit 1 [5] 0.62ms]
  139.  
  140. SQL[select * from `vrf_lite_cisco` where `vrf_lite_cisco`.`device_id` = ? and `vrf_lite_cisco`.`device_id` is not null [30] 0.78ms]
  141.  
  142. No Such Object available on this agent at this OID  
  143.  
  144. SQL[SELECT * FROM `processors` WHERE `device_id`=? [30] 0.87ms]
  145.  
  146. SQL[DELETE T FROM `processors` T LEFT JOIN `devices` ON `devices`.`device_id` = T.`device_id` WHERE `devices`.`device_id` IS NULL [] 0.7ms]
  147.  
  148. Modules status: Global+  
  149. OS+  
  150. Device  
  151. SQL[SELECT COUNT(*) FROM `mempools` WHERE `device_id` = ? AND `mempool_type` = 'cemp' [30] 0.52ms]
  152.  
  153. dellNetCpuUtilTable = No Such Object available on this agent at this OID  
  154.  
  155. dellNetProcessorEntry = No Such Object available on this agent at this OID  
  156.  
  157. hpLocalMem = No Such Object available on this agent at this OID  
  158.  
  159. hpGlobalMem = No Such Object available on this agent at this OID  
  160.  
  161. hrStorageEntry = No Such Object available on this agent at this OID  
  162.  
  163. memoryUsageTable = No Such Object available on this agent at this OID  
  164.  
  165. memStatsTable = No Such Object available on this agent at this OID  
  166.  
  167.  
  168. SQL[SELECT * FROM `mempools` WHERE `device_id`  = '30' [] 0.97ms]
  169.  
  170. Modules status: Global+  
  171. OS+  
  172. Device  
  173. SQL[SELECT * FROM vrf_lite_cisco WHERE device_id = ?  [30] 0.47ms]
  174.  
  175. Modules status: Global-  
  176. OS-  
  177. Device  
  178. Modules status: Global-  
  179. OS-  
  180. Device  
  181. Modules status: Global-  
  182. OS-  
  183. Device  
  184. Modules status: Global-  
  185. OS-  
  186. Device  
  187. Modules status: Global-  
  188. OS-  
  189. Device  
  190. Modules status: Global-  
  191. OS-  
  192. Device  
  193. Modules status: Global-  
  194. OS-  
  195. Device  
  196. Modules status: Global-  
  197. OS-  
  198. Device  
  199. Modules status: Global+  
  200. OS+  
  201. Device  
  202. ipAdEntIfIndex.* 1
  203. ipAdEntIfIndex.* 2  
  204.  
  205. *  
  206.  
  207. SQL[SELECT COUNT(*) FROM `ports` WHERE device_id = ? AND `ifIndex` = ? [30,"1"] 0.88ms]
  208.  
  209. SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [30,"1"] 0.62ms]
  210.  
  211. SQL[SELECT COUNT(*) FROM `ipv4_networks` WHERE `ipv4_network` = ? ["127.0.0.0\/8"] 0.59ms]
  212.  
  213. SQL[UPDATE `ipv4_networks` set `context_name`=? WHERE `ipv4_network` = ? [null,"127.0.0.0\/8"] 11.43ms]
  214.  
  215. SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = ? ["127.0.0.0\/8"] 0.55ms]
  216.  
  217. SQL[SELECT COUNT(*) FROM `ipv4_addresses` WHERE `ipv4_address` = ? AND `ipv4_prefixlen` = ? AND `port_id` = ?  ["127.0.0.1",8,188] 0.56ms]
  218.  
  219. 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]
  220.  
  221. *  
  222.  
  223. SQL[SELECT COUNT(*) FROM `ports` WHERE device_id = ? AND `ifIndex` = ? [30,"2"] 0.77ms]
  224.  
  225. SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [30,"2"] 0.56ms]
  226.  
  227. SQL[SELECT COUNT(*) FROM `ipv4_networks` WHERE `ipv4_network` = ? ["192.94.152.0\/24"] 0.53ms]
  228.  
  229. SQL[UPDATE `ipv4_networks` set `context_name`=? WHERE `ipv4_network` = ? [null,"192.94.152.0\/24"] 1.12ms]
  230.  
  231. SQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = ? ["192.94.152.0\/24"] 0.55ms]
  232.  
  233. SQL[SELECT COUNT(*) FROM `ipv4_addresses` WHERE `ipv4_address` = ? AND `ipv4_prefixlen` = ? AND `port_id` = ?  ["192.94.152.251",24,189] 0.62ms]
  234.  
  235. 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]
  236.  
  237. 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]
  238.  
  239. Modules status: Global+  
  240. OS+  
  241. Device  
  242. ipAddressIfIndex.ipv6 No Such Object available on this agent at this OID  
  243.  
  244. .*.*.8.1.2 No Such Object available on this agent at this OID  
  245.  
  246. 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]
  247.  
  248. Modules status: Global-  
  249. OS-  
  250. Device  
  251. Modules status: Global+  
  252. OS+  
  253. Device  
  254. 9725AY0AC699600158  
  255.  
  256. array (
  257.   'poweralert_serial' => '9725AY0AC699600158',
  258. )  
  259. entPhysicalDescr = No Such Instance currently exists at this OID  
  260.  
  261. 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]
  262.  
  263. 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]
  264.  
  265. 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]
  266.  
  267. 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]
  268.  
  269.  
  270. 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]
  271.  
  272. No Such Instance currently exists at this OID  
  273.  
  274. upsOutputCurrent[1] = No Such Instance currently exists at this OID  
  275.  
  276. upsInputCurrent[1] = No Such Instance currently exists at this OID  
  277.  
  278. upsBypassCurrent[1] = No Such Instance currently exists at this OID  
  279.  
  280.  
  281. 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]
  282.  
  283. 100  
  284.  
  285. 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)  
  286. 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]
  287.  
  288. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["charge",30,"rfc1628","500"] 0.77ms]
  289.  
  290. array (
  291.   'rfc1628' =>
  292.   array (
  293.     500 => 1,
  294.   ),
  295. )  
  296. 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]
  297.  
  298. 500 -> rfc1628  
  299.  
  300. 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]
  301.  
  302.  
  303. 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]
  304.  
  305. upsInputFrequency[1] = 600  
  306.  
  307. 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: )  
  308. 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]
  309.  
  310. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["frequency",30,"rfc1628","3.2.0.1"] 1ms]
  311.  
  312. 600  
  313.  
  314. 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: )  
  315. 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]
  316.  
  317. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["frequency",30,"rfc1628","4.2.0"] 0.93ms]
  318.  
  319. 600  
  320.  
  321. 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: )  
  322. 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]
  323.  
  324. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["frequency",30,"rfc1628","5.1.0"] 0.92ms]
  325.  
  326. array (
  327.   'rfc1628' =>
  328.   array (
  329.     '3.2.0.1' => 1,
  330.     '4.2.0' => 1,
  331.     '5.1.0' => 1,
  332.   ),
  333. )  
  334. 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]
  335.  
  336. 3.2.0.1 -> rfc1628  
  337. 4.2.0 -> rfc1628  
  338. 5.1.0 -> rfc1628  
  339.  
  340. 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]
  341.  
  342. upsOutputPercentLoad[1] = 25  
  343.  
  344. 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: )  
  345. 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]
  346.  
  347. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["load",30,"rfc1628","501"] 0.81ms]
  348.  
  349. array (
  350.   'rfc1628' =>
  351.   array (
  352.     501 => 1,
  353.   ),
  354. )  
  355. 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]
  356.  
  357. 501 -> rfc1628  
  358. upsOutputPower[1] = No Such Instance currently exists at this OID  
  359.  
  360. upsInputTruePower[1] = No Such Instance currently exists at this OID  
  361.  
  362. upsBypassPower[1] = No Such Instance currently exists at this OID  
  363.  
  364.  
  365. 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]
  366.  
  367.  
  368. 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]
  369.  
  370.  
  371. 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]
  372.  
  373. 0  
  374.  
  375. 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)  
  376. 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]
  377.  
  378. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["runtime",30,"rfc1628","100"] 0.82ms]
  379.  
  380. 30  
  381.  
  382. 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)  
  383. 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]
  384.  
  385. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["runtime",30,"rfc1628","200"] 0.87ms]
  386.  
  387. array (
  388.   'rfc1628' =>
  389.   array (
  390.     100 => 1,
  391.     200 => 1,
  392.   ),
  393. )  
  394. 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]
  395.  
  396. 100 -> rfc1628  
  397. 200 -> rfc1628  
  398.  
  399. 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]
  400.  
  401. 2  
  402.  
  403. SQL[SELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 ["upsBatteryStatusState"] 0.79ms]
  404.  
  405. 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]
  406.  
  407. 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: )  
  408. 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]
  409.  
  410. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["state",30,"upsBatteryStatusState","0"] 0.86ms]
  411.  
  412. SQL[SELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["state",30,"upsBatteryStatusState",0] 0.75ms]
  413.  
  414. SQL[SELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? ["upsBatteryStatusState"] 0.6ms]
  415.  
  416. 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]
  417.  
  418. 3  
  419.  
  420. SQL[SELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 ["upsOutputSourceState"] 0.77ms]
  421.  
  422. 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]
  423.  
  424. 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: )  
  425. 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]
  426.  
  427. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["state",30,"upsOutputSourceState","0"] 0.86ms]
  428.  
  429. SQL[SELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["state",30,"upsOutputSourceState",0] 0.74ms]
  430.  
  431. SQL[SELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? ["upsOutputSourceState"] 0.58ms]
  432.  
  433. 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]
  434.  
  435. array (
  436.   'upsBatteryStatusState' =>
  437.   array (
  438.     0 => 1,
  439.   ),
  440.   'upsOutputSourceState' =>
  441.   array (
  442.     0 => 1,
  443.   ),
  444. )  
  445. 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]
  446.  
  447. 0 -> upsBatteryStatusState  
  448. 0 -> upsOutputSourceState  
  449.  
  450. 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]
  451.  
  452. 42  
  453.  
  454. 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: )  
  455. 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]
  456.  
  457. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["temperature",30,"rfc1628","0"] 0.94ms]
  458.  
  459. array (
  460.   'rfc1628' =>
  461.   array (
  462.     0 => 1,
  463.   ),
  464. )  
  465. 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]
  466.  
  467. 0 -> rfc1628  
  468. 540  
  469.  
  470. 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: )  
  471. 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]
  472.  
  473. 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]
  474.  
  475. upsOutputVoltage[1] = 119  
  476.  
  477. 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: )  
  478. 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]
  479.  
  480. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["voltage",30,"rfc1628","1"] 0.93ms]
  481.  
  482. upsInputVoltage[1] = 124  
  483.  
  484. 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: )  
  485. 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]
  486.  
  487. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["voltage",30,"rfc1628","101"] 0.89ms]
  488.  
  489. upsBypassVoltage[1] = 124  
  490.  
  491. 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: )  
  492. 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]
  493.  
  494. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["voltage",30,"rfc1628","201"] 0.83ms]
  495.  
  496. array (
  497.   'rfc1628' =>
  498.   array (
  499.     '1.2.5.0' => 1,
  500.     1 => 1,
  501.     101 => 1,
  502.     201 => 1,
  503.   ),
  504. )  
  505. 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]
  506.  
  507. 1.2.5.0 -> rfc1628  
  508. 1 -> rfc1628  
  509. 101 -> rfc1628  
  510. 201 -> rfc1628  
  511.  
  512. 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]
  513.  
  514.  
  515. 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]
  516.  
  517.  
  518. 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]
  519.  
  520.  
  521. 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]
  522.  
  523.  
  524. 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]
  525.  
  526.  
  527. 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]
  528.  
  529.  
  530. 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]
  531.  
  532.  
  533. 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]
  534.  
  535.  
  536. 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]
  537.  
  538. Modules status: Global+  
  539. OS+  
  540. Device  
  541.  
  542. MIB search path: /opt/librenms/mibs:/opt/librenms/mibs/poweralert
  543. Cannot find module (IBM-AIX-MIB): At line 1 in (none)
  544. aixFsTableEntry: Unknown Object Identifier (Sub-id not found: (top) -> aixFsTableEntry)  
  545. SQL[SELECT `storage_descr` FROM `storage` WHERE `device_id`  = '30' AND `storage_type` != 'aixFileSystem' [] 0.73ms]
  546.  
  547. fileSystemSpaceTable = No Such Object available on this agent at this OID  
  548.  
  549. hrStorageEntry = No Such Object available on this agent at this OID  
  550.  
  551. dskTable = No Such Object available on this agent at this OID  
  552.  
  553. SQL[SELECT `storage_descr` FROM `storage` WHERE `device_id`  = '30' AND `storage_type` != 'dsk' [] 0.74ms]
  554.  
  555.  
  556. SQL[SELECT * FROM `storage` WHERE `device_id`  = '30' [] 0.55ms]
  557.  
  558. Modules status: Global+  
  559. OS+  
  560. Device  
  561.  
  562. hrDeviceEntry = No Such Object available on this agent at this OID  
  563.  
  564. hrProcessorEntry = No Such Object available on this agent at this OID  
  565.  
  566. array (
  567. )  
  568. SQL[SELECT * FROM `hrDevice` WHERE `device_id`  = '30' [] 0.82ms]
  569.  
  570. Modules status: Global+  
  571. OS+  
  572. Device  
  573. cdpCache = No Such Object available on this agent at this OID  
  574.  
  575. lldpRemTable = No Such Object available on this agent at this OID  
  576.  
  577. SQL[SELECT DISTINCT(`ospfNbrIpAddr`),`device_id` FROM `ospf_nbrs` WHERE `device_id`=? [30] 0.81ms]
  578.  
  579.  
  580. SQL[SELECT * FROM `links` AS L, `ports` AS I WHERE L.local_port_id = I.port_id AND I.device_id = ? [30] 1.11ms]
  581.  
  582. 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]
  583.  
  584.  0 orphaned links deleted  
  585. Modules status: Global+  
  586. OS+  
  587. Device  
  588. ipNetToPhysicalPhysAddress = No Such Object available on this agent at this OID  
  589.  
  590. ipNetToMediaPhysAddress = No Such Instance currently exists at this OID  
  591.  
  592. SQL[SELECT * from `ipv4_mac` WHERE `device_id`=? AND `context_name`=? [30,""] 1.35ms]
  593.  
  594. 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]
  595.  
  596. Modules status: Global-  
  597. OS-  
  598. Device  
  599. Modules status: Global-  
  600. OS-  
  601. Device  
  602. Modules status: Global+  
  603. OS+  
  604. Device  
  605. "Tripp Lite"  
  606.  
  607. Peers :  
  608. SQL[DELETE FROM `bgpPeers` WHERE device_id=? AND context_name=? [30,""] 0.57ms]
  609.  
  610. SQL[DELETE FROM `bgpPeers_cbgp` WHERE device_id=? AND context_name=? [30,""] 0.44ms]
  611.  
  612. SQL[SELECT DISTINCT context_name FROM bgpPeers WHERE device_id=? [30] 0.61ms]
  613.  
  614. Modules status: Global+  
  615. OS+  
  616. Device  
  617. SQL[SELECT * FROM `vlans` WHERE `device_id` = ? [30] 0.55ms]
  618.  
  619. dot1dBasePortIfIndex = No Such Object available on this agent at this OID  
  620.  
  621. No Such Object available on this agent at this OID  
  622.  
  623. Modules status: Global-  
  624. OS-  
  625. Device  
  626. Modules status: Global-  
  627. OS-  
  628. Device  
  629. Modules status: Global-  
  630. OS-  
  631. Device  
  632. Modules status: Global+  
  633. OS+  
  634. Device  
  635. diskIOEntry = No Such Object available on this agent at this OID  
  636.  
  637. array (
  638. )  
  639. SQL[SELECT * FROM `ucd_diskio` where `device_id`  = '30' [] 0.65ms]
  640.  
  641. Modules status: Global-  
  642. OS-  
  643. Device  
  644. Modules status: Global+  
  645. OS+  
  646. Device  
  647. Modules status: Global+  
  648. OS+  
  649. Device  
  650. SQL[SELECT * FROM `stp` WHERE `device_id` = ? [30] 0.53ms]
  651.  
  652. No Such Object available on this agent at this OID  
  653.  
  654. Modules status: Global+  
  655. OS+  
  656. Device  
  657. Modules status: Global-  
  658. OS-  
  659. Device  
  660. Modules status: Global-  
  661. OS-  
  662. Device  
  663. Modules status: Global+  
  664. OS+  
  665. Device  
  666. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"ap-count"] 0.95ms]
  667.  
  668. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"clients"] 0.64ms]
  669.  
  670. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"quality"] 0.67ms]
  671.  
  672. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"capacity"] 0.65ms]
  673.  
  674. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"utilization"] 0.65ms]
  675.  
  676. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"rate"] 0.65ms]
  677.  
  678. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"ccq"] 0.78ms]
  679.  
  680. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"snr"] 0.72ms]
  681.  
  682. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"sinr"] 0.7ms]
  683.  
  684. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"rsrp"] 0.73ms]
  685.  
  686. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"rsrq"] 0.7ms]
  687.  
  688. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"ssr"] 0.7ms]
  689.  
  690. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"mse"] 0.7ms]
  691.  
  692. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"xpi"] 0.69ms]
  693.  
  694. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"rssi"] 0.75ms]
  695.  
  696. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"power"] 0.68ms]
  697.  
  698. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"noise-floor"] 0.66ms]
  699.  
  700. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"errors"] 0.66ms]
  701.  
  702. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"error-ratio"] 0.59ms]
  703.  
  704. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"error-rate"] 0.67ms]
  705.  
  706. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"frequency"] 0.67ms]
  707.  
  708. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`=? AND `sensor_class`=? [30,"distance"] 0.7ms]
  709.  
  710. Modules status: Global+  
  711. OS+  
  712. Device  
  713. SQL[SELECT `vlan_id`, `vlan_vlan` from `vlans` WHERE `device_id` = ? [30] 0.49ms]
  714.  
  715. SQL[SELECT * FROM `ports_fdb` WHERE `device_id` = ? [30] 0.53ms]
  716.  
  717. dot1qTpFdbPort = No Such Object available on this agent at this OID  
  718.  
  719. dot1dTpFdbPort = No Such Object available on this agent at this OID  
  720.  
  721. Modules status: Global+  
  722. OS+  
  723. Device  
  724. SQL[UPDATE `devices` set `last_discovered`=NOW(),`last_discovered_timetaken`=? WHERE `device_id` = ? [7.143,30] 1.43ms]
  725.  
  726. 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]
  727.  
  728. ./discovery.php tlups1 2019-12-23 19:01:08 - 1 devices discovered in 7.682 secs  
  729. title:
  730. name: librenms
  731. private: 1
  732. expire: 0
  733. https://p.libren.ms/view/8265e217
  734.  


Reply to "validate for older card"