API tools faq
paste
Advertisement
Guest User

Discovery

a guest
Sep 9th, 2018
19
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 33.00 KB | None | 0 0
raw download clone embed print report
  1. -bash-4.2$ ./discovery.php -d -h 265 -m sensors
  2. LibreNMS Discovery
  3. SQL[select `version` from `dbSchema` order by `version` desc limit 1 [] 0.63ms]
  4. SQL[SELECT version() [] 0.24ms]
  5. ===================================
  6. Version info:
  7. Commit SHA: d17eb4faaadbc0f58eeddf03da948a276a717a7a
  8. Commit Date: 1535957734
  9. DB Schema: 266
  10. PHP: 7.2.8
  11. MySQL: 5.5.56-MariaDB
  12. RRDTool: 1.4.8
  13. SNMP: NET-SNMP 5.7.2
  14. ==================================DEBUG!
  15. Updating os_def.cache... Done
  16. Override discovery modules: sensors
  17. SQL[SELECT * FROM `devices` WHERE disabled = 0 AND snmp_disable = 0 AND `device_id` = '265' ORDER BY device_id DESC [] 1.03ms]
  18. SQL[SELECT * FROM devices_attribs WHERE `device_id` = ? [265] 0.54ms]
  19. gw6420-tor-1.hostname 265 gw-eydfa [FPING] /usr/sbin/fping -e -q -c 10 -p 500 -t 500 gw6420-tor-1.hostname
  20. Array
  21. (
  22. [xmt] => 10
  23. [rcv] => 10
  24. [loss] => 0
  25. [min] => 0.31
  26. [max] => 0.50
  27. [avg] => 0.42
  28. [exitcode] => 0
  29. )
  30. SQL[INSERT IGNORE INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`) VALUES (:xmt,:rcv,:loss,:min,:max,:avg,:device_id,NOW()) {"xmt":"10","rcv":"10","loss":"0","min":"0.31","max":"0.50","avg":"0.42","device_id":265} 0.77ms]
  31. SNMP Check response code: 0
  32. SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = ? AND `attrib_type` = ? [265,"poll_mib"] 0.73ms]
  33. MIB: registering
  34.  
  35. Attempting to initialize OS: gw-eydfa
  36. OS initilized as Generic
  37.  
  38. Modules status: Global+ OS Device
  39. #### Load disco module core ####
  40. SNMP[/usr/bin/snmpget -v2c -c COMMUNITY -OUQn -m SNMPv2-MIB -M /opt/dev_librenms/mibs:/opt/dev_librenms/mibs/glassway -t 2 -r 5 udp:HOSTNAME:161 sysName.0 sysObjectID.0 sysDescr.0]
  41. .*.*.0 = HFC-OA
  42. .*.*.0 = .*.4.1.17409.1.11
  43. .*.*.0 = GW-6420-WDM
  44.  
  45.  
  46. >> Runtime for discovery module 'core': 0.0240 seconds with 984 bytes
  47. >> SNMP: [2/0.08s] MySQL: [4/0.00s] RRD: [0/0.00s]
  48. #### Unload disco module core ####
  49.  
  50. Modules status: Global+ OS+ Device
  51. #### Load disco module sensors ####
  52. Caching data: sensors SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OteQUs -Ih -m NSCRTV-HFCEMS-PROPERTY-MIB:NSCRTV-HFCEMS-OPTICALAMPLIFIER-MIB:NSCRTV-HFCEMS-COMMON-MIB -M /opt/dev_librenms/mibs:/opt/dev_librenms/mibs/glassway -t 2 -r 5 udp:HOSTNAME:161 oaOutputOpticalPower]
  53. oaOutputOpticalPower.0 = 203
  54.  
  55. SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OteQUs -Ih -m NSCRTV-HFCEMS-PROPERTY-MIB:NSCRTV-HFCEMS-OPTICALAMPLIFIER-MIB:NSCRTV-HFCEMS-COMMON-MIB -M /opt/dev_librenms/mibs:/opt/dev_librenms/mibs/glassway -t 2 -r 5 udp:HOSTNAME:161 oaInputOpticalPower]
  56. oaInputOpticalPower.0 = 35
  57.  
  58. SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OteQUs -Ih -m NSCRTV-HFCEMS-PROPERTY-MIB:NSCRTV-HFCEMS-OPTICALAMPLIFIER-MIB:NSCRTV-HFCEMS-COMMON-MIB -M /opt/dev_librenms/mibs:/opt/dev_librenms/mibs/glassway -t 2 -r 5 udp:HOSTNAME:161 commonDeviceInternalTemperature]
  59. commonDeviceInternalTemperature.1 = 47
  60.  
  61. SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OteQUs -Ih -m NSCRTV-HFCEMS-PROPERTY-MIB:NSCRTV-HFCEMS-OPTICALAMPLIFIER-MIB:NSCRTV-HFCEMS-COMMON-MIB -M /opt/dev_librenms/mibs:/opt/dev_librenms/mibs/glassway -t 2 -r 5 udp:HOSTNAME:161 oaPumpTable]
  62. oaPumpIndex.1 = 1
  63. oaPumpIndex.2 = 2
  64. oaPumpBIAS.1 = 541
  65. oaPumpBIAS.2 = 8240
  66. oaPumpTEC.1 = 28
  67. oaPumpTEC.2 = 0
  68. oaPumpTemp.1 = 253
  69. oaPumpTemp.2 = 0
  70.  
  71. SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OteQUs -Ih -m NSCRTV-HFCEMS-PROPERTY-MIB:NSCRTV-HFCEMS-OPTICALAMPLIFIER-MIB:NSCRTV-HFCEMS-COMMON-MIB -M /opt/dev_librenms/mibs:/opt/dev_librenms/mibs/glassway -t 2 -r 5 udp:HOSTNAME:161 oaDCPowerTable]
  72. oaDCPowerIndex.1 = 1
  73. oaDCPowerVoltage.1 = 48
  74. oaDCPowerCurrent.1 = 0
  75. oaDCPowerName.1 = "DC +5V"
  76.  
  77. SNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OteQUs -Ih -m NSCRTV-HFCEMS-PROPERTY-MIB:NSCRTV-HFCEMS-OPTICALAMPLIFIER-MIB:NSCRTV-HFCEMS-COMMON-MIB -M /opt/dev_librenms/mibs:/opt/dev_librenms/mibs/glassway -t 2 -r 5 udp:HOSTNAME:161 discreteAlarmState]
  78. discreteAlarmState.*.**.0.2 = 1
  79. discreteAlarmState.*.**.0.2 = 1
  80.  
  81.  
  82. ENTITY-SENSOR: Caching OIDs: entPhysicalDescrSNMP[/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m ENTITY-MIB -M /opt/dev_librenms/mibs:/opt/dev_librenms/mibs/glassway -t 2 -r 5 udp:HOSTNAME:161 entPhysicalDescr]
  83. entPhysicalDescr = No Such Object available on this agent at this OID
  84.  
  85.  
  86. SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = ? AND `attrib_type` = ? [265,"ipmi_hostname"] 0.63ms]
  87. 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",265,"ipmi"] 1.06ms]
  88. 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",265,"ipmi"] 0.78ms]
  89. 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",265,"ipmi"] 0.71ms]
  90. 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",265,"ipmi"] 0.71ms]
  91. Airflow: 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",265,"snmp"] 0.69ms]
  92.  
  93. Current: Dynamic Discovery (current): Array
  94. (
  95. [options] => Array
  96. (
  97. [skip_values] => 0
  98. )
  99.  
  100. [data] => Array
  101. (
  102. [0] => Array
  103. (
  104. [oid] => oaPumpTable
  105. [num_oid] => .1.3.6.1.4.1.17409.1.11.4.1.2.
  106. [descr] => BIAS Pump - {{ $index }}
  107. [index] => oaPumpBIAS.{{ $index }}
  108. [value] => oaPumpBIAS
  109. [divisor] => 1000
  110. )
  111.  
  112. [1] => Array
  113. (
  114. [oid] => oaPumpTable
  115. [num_oid] => .1.3.6.1.4.1.17409.1.11.4.1.3.
  116. [descr] => TEC Pump - {{ $index }}
  117. [index] => oaPumpTEC.{{ $index }}
  118. [value] => oaPumpTEC
  119. [divisor] => 100
  120. )
  121.  
  122. )
  123.  
  124. )
  125. Data oaPumpTable: Array
  126. (
  127. [1] => Array
  128. (
  129. [oaPumpIndex] => 1
  130. [oaPumpBIAS] => 541
  131. [oaPumpTEC] => 28
  132. [oaPumpTemp] => 253
  133. )
  134.  
  135. [2] => Array
  136. (
  137. [oaPumpIndex] => 2
  138. [oaPumpBIAS] => 8240
  139. [oaPumpTEC] => 0
  140. [oaPumpTemp] => 0
  141. )
  142.  
  143. )
  144. Final sensor value: 541
  145. Cur 541, Low: null, Low Warn: null, Warn: null, High: null
  146. Discover sensor: .1.3.6.1.4.1.17409.1.11.4.1.2.1, oaPumpBIAS.1, gw-eydfa, BIAS Pump - 1, snmp, 1000, 1, , 0.541
  147. SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","current",265,"gw-eydfa","oaPumpBIAS.1"] 0.6ms]
  148. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["current",265,"gw-eydfa","oaPumpBIAS.1"] 0.59ms]
  149. .Final sensor value: 8240
  150. Cur 8240, Low: null, Low Warn: null, Warn: null, High: null
  151. Discover sensor: .1.3.6.1.4.1.17409.1.11.4.1.2.2, oaPumpBIAS.2, gw-eydfa, BIAS Pump - 2, snmp, 1000, 1, , 8.24
  152. SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","current",265,"gw-eydfa","oaPumpBIAS.2"] 0.48ms]
  153. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["current",265,"gw-eydfa","oaPumpBIAS.2"] 0.58ms]
  154. .Data oaPumpTable: Array
  155. (
  156. [1] => Array
  157. (
  158. [oaPumpIndex] => 1
  159. [oaPumpBIAS] => 541
  160. [oaPumpTEC] => 28
  161. [oaPumpTemp] => 253
  162. )
  163.  
  164. [2] => Array
  165. (
  166. [oaPumpIndex] => 2
  167. [oaPumpBIAS] => 8240
  168. [oaPumpTEC] => 0
  169. [oaPumpTemp] => 0
  170. )
  171.  
  172. )
  173. Final sensor value: 28
  174. Cur 28, Low: null, Low Warn: null, Warn: null, High: null
  175. Discover sensor: .1.3.6.1.4.1.17409.1.11.4.1.3.1, oaPumpTEC.1, gw-eydfa, TEC Pump - 1, snmp, 100, 1, , 0.28
  176. SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","current",265,"gw-eydfa","oaPumpTEC.1"] 0.47ms]
  177. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["current",265,"gw-eydfa","oaPumpTEC.1"] 0.62ms]
  178. .Final sensor value: 0
  179. Array
  180. (
  181. [gw-eydfa] => Array
  182. (
  183. [oaPumpBIAS.1] => 1
  184. [oaPumpBIAS.2] => 1
  185. [oaPumpTEC.1] => 1
  186. )
  187.  
  188. )
  189. 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",265,"snmp"] 0.87ms]
  190. oaPumpBIAS.1 -> gw-eydfa
  191. oaPumpBIAS.2 -> gw-eydfa
  192. oaPumpTEC.1 -> gw-eydfa
  193.  
  194. Charge: 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",265,"snmp"] 0.7ms]
  195.  
  196. Dbm: Dynamic Discovery (dbm): Array
  197. (
  198. [data] => Array
  199. (
  200. [0] => Array
  201. (
  202. [oid] => oaOutputOpticalPower
  203. [num_oid] => .1.3.6.1.4.1.17409.1.11.2.
  204. [descr] => Per Output Power
  205. [index] => oaOutputOpticalPower.{{ $index }}
  206. [value] => oaOutputOpticalPower
  207. [divisor] => 10
  208. [low_limit] => analogAlarmLOLO.11.1.3.6.1.4.1.17409.1.11.2.0
  209. [low_warn_limit] => analogAlarmLO.11.1.3.6.1.4.1.17409.1.11.2.0
  210. [warn_limit] => analogAlarmHI.11.1.3.6.1.4.1.17409.1.11.2.0
  211. [high_limit] => analogAlarmHIHI.11.1.3.6.1.4.1.17409.1.11.2.0
  212. )
  213.  
  214. [1] => Array
  215. (
  216. [oid] => oaInputOpticalPower
  217. [num_oid] => .1.3.6.1.4.1.17409.1.11.3.
  218. [descr] => Input Power
  219. [index] => oaInputOpticalPower.{{ $index }}
  220. [divisor] => 10
  221. [low_limit] => analogAlarmLOLO.11.1.3.6.1.4.1.17409.1.11.3.0
  222. [low_warn_limit] => analogAlarmLO.11.1.3.6.1.4.1.17409.1.11.3.0
  223. [warn_limit] => analogAlarmHI.11.1.3.6.1.4.1.17409.1.11.3.0
  224. [high_limit] => analogAlarmHIHI.11.1.3.6.1.4.1.17409.1.11.3.0
  225. )
  226.  
  227. )
  228.  
  229. )
  230. Data oaOutputOpticalPower: Array
  231. (
  232. [0] => Array
  233. (
  234. [oaOutputOpticalPower] => 203
  235. )
  236.  
  237. )
  238. Final sensor value: 203
  239. Cur 203, Low: null, Low Warn: null, Warn: null, High: null
  240. Discover sensor: .1.3.6.1.4.1.17409.1.11.2.0, oaOutputOpticalPower.0, gw-eydfa, Per Output Power, snmp, 10, 1, , 20.3
  241. SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","dbm",265,"gw-eydfa","oaOutputOpticalPower.0"] 0.48ms]
  242. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["dbm",265,"gw-eydfa","oaOutputOpticalPower.0"] 0.56ms]
  243. .Data oaInputOpticalPower: Array
  244. (
  245. [0] => Array
  246. (
  247. [oaInputOpticalPower] => 35
  248. )
  249.  
  250. )
  251. Final sensor value: 35
  252. Cur 35, Low: null, Low Warn: null, Warn: null, High: null
  253. Discover sensor: .1.3.6.1.4.1.17409.1.11.3.0, oaInputOpticalPower.0, gw-eydfa, Input Power, snmp, 10, 1, , 3.5
  254. SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","dbm",265,"gw-eydfa","oaInputOpticalPower.0"] 0.47ms]
  255. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["dbm",265,"gw-eydfa","oaInputOpticalPower.0"] 0.59ms]
  256. .Array
  257. (
  258. [gw-eydfa] => Array
  259. (
  260. [oaOutputOpticalPower.0] => 1
  261. [oaInputOpticalPower.0] => 1
  262. )
  263.  
  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 = ? ["dbm",265,"snmp"] 0.78ms]
  266. oaOutputOpticalPower.0 -> gw-eydfa
  267. oaInputOpticalPower.0 -> gw-eydfa
  268.  
  269. Fanspeed: 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",265,"snmp"] 0.76ms]
  270.  
  271. Frequency: 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",265,"snmp"] 0.72ms]
  272.  
  273. Humidity: 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",265,"snmp"] 0.71ms]
  274.  
  275. Load: 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",265,"snmp"] 0.69ms]
  276.  
  277. Power: 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",265,"snmp"] 0.71ms]
  278.  
  279. Runtime: 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",265,"snmp"] 0.71ms]
  280.  
  281. Signal: 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",265,"snmp"] 0.67ms]
  282.  
  283. State: Dynamic Discovery (state): Array
  284. (
  285. [data] => Array
  286. (
  287. [0] => Array
  288. (
  289. [oid] => discreteAlarmState
  290. [num_oid] => .1.3.6.1.4.1.17409.1.1.2.1.4.
  291. [descr] => Power Supply 1
  292. [index] => PowerSupply1
  293. [state_name] => PowerSupplyState
  294. [states] => Array
  295. (
  296. [0] => Array
  297. (
  298. [value] => 1
  299. [generic] => 0
  300. [graph] => 0
  301. [descr] => normal
  302. )
  303.  
  304. [1] => Array
  305. (
  306. [value] => 7
  307. [generic] => 1
  308. [graph] => 0
  309. [descr] => warning
  310. )
  311.  
  312. [2] => Array
  313. (
  314. [value] => 6
  315. [generic] => 2
  316. [graph] => 0
  317. [descr] => critical
  318. )
  319.  
  320. )
  321.  
  322. )
  323.  
  324. [1] => Array
  325. (
  326. [oid] => discreteAlarmState
  327. [num_oid] => .1.3.6.1.4.1.17409.1.1.2.1.4.
  328. [descr] => Power Supply 2
  329. [index] => PowerSupply2
  330. [state_name] => PowerSupplyState
  331. [states] => Array
  332. (
  333. [0] => Array
  334. (
  335. [value] => 1
  336. [generic] => 0
  337. [graph] => 0
  338. [descr] => normal
  339. )
  340.  
  341. [1] => Array
  342. (
  343. [value] => 7
  344. [generic] => 1
  345. [graph] => 0
  346. [descr] => warning
  347. )
  348.  
  349. [2] => Array
  350. (
  351. [value] => 6
  352. [generic] => 2
  353. [graph] => 0
  354. [descr] => critical
  355. )
  356.  
  357. )
  358.  
  359. )
  360.  
  361. )
  362.  
  363. )
  364. Data discreteAlarmState: Array
  365. (
  366. [11.1.3.6.1.4.1.17409.1.11.100.0.2] => Array
  367. (
  368. [discreteAlarmState] => 1
  369. )
  370.  
  371. [11.1.3.6.1.4.1.17409.1.11.101.0.2] => Array
  372. (
  373. [discreteAlarmState] => 1
  374. )
  375.  
  376. )
  377. Final sensor value: 1
  378. Cur 1, Low: null, Low Warn: null, Warn: null, High: null
  379. SQL[SELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 ["PowerSupplyState"] 0.4ms]
  380. SQL[SELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [146] 0.44ms]
  381. Discover sensor: .1.3.6.1.4.1.17409.1.1.2.1.4.11.1.3.6.1.4.1.17409.1.11.100.0.2, PowerSupply1, PowerSupplyState, Power Supply 1, snmp, 1, 1, , 1
  382. SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","state",265,"PowerSupplyState","PowerSupply1"] 0.5ms]
  383. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["state",265,"PowerSupplyState","PowerSupply1"] 0.58ms]
  384. SQL[UPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=? WHERE `sensor_id` = ? [".1.3.6.1.4.1.17409.1.1.2.1.4.11.1.3.6.1.4.1.17409.1.11.100.0.2","Power Supply 1",1,1,null,null,null,1636] 0.47ms]
  385. USQL[INSERT IGNORE INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`) VALUES (:host,:device_id,:reference,:type,NOW(),:severity,:message,:username) {"host":265,"device_id":265,"reference":"NULL","type":"sensor","severity":3,"message":"Sensor Updated: state PowerSupplyState PowerSupply1 Power Supply 1","username":""} 0.58ms]
  386. ( 1 updated )
  387. SQL[SELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["state",265,"PowerSupplyState","PowerSupply1"] 0.51ms]
  388. SQL[SELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? ["PowerSupplyState"] 0.34ms]
  389. SQL[INSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) {"sensor_id":1636,"state_index_id":146} 0.46ms]
  390. Final sensor value: 1
  391. Cur 1, Low: null, Low Warn: null, Warn: null, High: null
  392. SQL[SELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 ["PowerSupplyState"] 0.33ms]
  393. SQL[SELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [146] 0.38ms]
  394. Discover sensor: .1.3.6.1.4.1.17409.1.1.2.1.4.11.1.3.6.1.4.1.17409.1.11.101.0.2, PowerSupply1, PowerSupplyState, Power Supply 1, snmp, 1, 1, , 1
  395. SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","state",265,"PowerSupplyState","PowerSupply1"] 0.46ms]
  396. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["state",265,"PowerSupplyState","PowerSupply1"] 0.56ms]
  397. SQL[UPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=? WHERE `sensor_id` = ? [".1.3.6.1.4.1.17409.1.1.2.1.4.11.1.3.6.1.4.1.17409.1.11.101.0.2","Power Supply 1",1,1,null,null,null,1636] 0.36ms]
  398. USQL[INSERT IGNORE INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`) VALUES (:host,:device_id,:reference,:type,NOW(),:severity,:message,:username) {"host":265,"device_id":265,"reference":"NULL","type":"sensor","severity":3,"message":"Sensor Updated: state PowerSupplyState PowerSupply1 Power Supply 1","username":""} 0.31ms]
  399. ( 1 updated )
  400. SQL[SELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["state",265,"PowerSupplyState","PowerSupply1"] 0.47ms]
  401. SQL[SELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? ["PowerSupplyState"] 0.31ms]
  402. SQL[INSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) {"sensor_id":1636,"state_index_id":146} 0.31ms]
  403. Data discreteAlarmState: Array
  404. (
  405. [11.1.3.6.1.4.1.17409.1.11.100.0.2] => Array
  406. (
  407. [discreteAlarmState] => 1
  408. )
  409.  
  410. [11.1.3.6.1.4.1.17409.1.11.101.0.2] => Array
  411. (
  412. [discreteAlarmState] => 1
  413. )
  414.  
  415. )
  416. Final sensor value: 1
  417. Cur 1, Low: null, Low Warn: null, Warn: null, High: null
  418. SQL[SELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 ["PowerSupplyState"] 0.31ms]
  419. SQL[SELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [146] 0.34ms]
  420. Discover sensor: .1.3.6.1.4.1.17409.1.1.2.1.4.11.1.3.6.1.4.1.17409.1.11.100.0.2, PowerSupply2, PowerSupplyState, Power Supply 2, snmp, 1, 1, , 1
  421. SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","state",265,"PowerSupplyState","PowerSupply2"] 0.47ms]
  422. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["state",265,"PowerSupplyState","PowerSupply2"] 0.57ms]
  423. SQL[UPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=? WHERE `sensor_id` = ? [".1.3.6.1.4.1.17409.1.1.2.1.4.11.1.3.6.1.4.1.17409.1.11.100.0.2","Power Supply 2",1,1,null,null,null,1637] 0.34ms]
  424. USQL[INSERT IGNORE INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`) VALUES (:host,:device_id,:reference,:type,NOW(),:severity,:message,:username) {"host":265,"device_id":265,"reference":"NULL","type":"sensor","severity":3,"message":"Sensor Updated: state PowerSupplyState PowerSupply2 Power Supply 2","username":""} 0.35ms]
  425. ( 1 updated )
  426. SQL[SELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["state",265,"PowerSupplyState","PowerSupply2"] 0.46ms]
  427. SQL[SELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? ["PowerSupplyState"] 0.32ms]
  428. SQL[INSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) {"sensor_id":1637,"state_index_id":146} 0.29ms]
  429. Final sensor value: 1
  430. Cur 1, Low: null, Low Warn: null, Warn: null, High: null
  431. SQL[SELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 ["PowerSupplyState"] 0.32ms]
  432. SQL[SELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [146] 0.36ms]
  433. Discover sensor: .1.3.6.1.4.1.17409.1.1.2.1.4.11.1.3.6.1.4.1.17409.1.11.101.0.2, PowerSupply2, PowerSupplyState, Power Supply 2, snmp, 1, 1, , 1
  434. SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","state",265,"PowerSupplyState","PowerSupply2"] 0.48ms]
  435. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["state",265,"PowerSupplyState","PowerSupply2"] 0.55ms]
  436. SQL[UPDATE `sensors` set `sensor_oid`=?,`sensor_descr`=?,`sensor_multiplier`=?,`sensor_divisor`=?,`entPhysicalIndex`=?,`entPhysicalIndex_measured`=?,`user_func`=? WHERE `sensor_id` = ? [".1.3.6.1.4.1.17409.1.1.2.1.4.11.1.3.6.1.4.1.17409.1.11.101.0.2","Power Supply 2",1,1,null,null,null,1637] 0.36ms]
  437. USQL[INSERT IGNORE INTO `eventlog` (`host`,`device_id`,`reference`,`type`,`datetime`,`severity`,`message`,`username`) VALUES (:host,:device_id,:reference,:type,NOW(),:severity,:message,:username) {"host":265,"device_id":265,"reference":"NULL","type":"sensor","severity":3,"message":"Sensor Updated: state PowerSupplyState PowerSupply2 Power Supply 2","username":""} 0.31ms]
  438. ( 1 updated )
  439. SQL[SELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["state",265,"PowerSupplyState","PowerSupply2"] 0.46ms]
  440. SQL[SELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? ["PowerSupplyState"] 0.31ms]
  441. SQL[INSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) {"sensor_id":1637,"state_index_id":146} 0.32ms]
  442. Array
  443. (
  444. [PowerSupplyState] => Array
  445. (
  446. [PowerSupply1] => 1
  447. [PowerSupply2] => 1
  448. )
  449.  
  450. )
  451. 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",265,"snmp"] 0.83ms]
  452. PowerSupply1 -> PowerSupplyState
  453. PowerSupply2 -> PowerSupplyState
  454.  
  455. Temperature: Dynamic Discovery (temperature): Array
  456. (
  457. [options] => Array
  458. (
  459. [skip_values] => 0
  460. )
  461.  
  462. [data] => Array
  463. (
  464. [0] => Array
  465. (
  466. [oid] => commonDeviceInternalTemperature
  467. [num_oid] => .1.3.6.1.4.1.17409.1.3.3.2.2.1.12.
  468. [descr] => Internal Temperature
  469. [index] => commonDeviceInternalTemperature.{{ $index }}
  470. [value] => commonDeviceInternalTemperature
  471. [low_limit] => analogAlarmLOLO.12.1.3.6.1.4.1.17409.1.3.1.13.0
  472. [low_warn_limit] => analogAlarmLO.12.1.3.6.1.4.1.17409.1.3.1.13.0
  473. [warn_limit] => analogAlarmHI.12.1.3.6.1.4.1.17409.1.3.1.13.0
  474. [high_limit] => analogAlarmHIHI.12.1.3.6.1.4.1.17409.1.3.1.13.0
  475. )
  476.  
  477. [1] => Array
  478. (
  479. [oid] => oaPumpTable
  480. [num_oid] => .1.3.6.1.4.1.17409.1.11.4.1.4.
  481. [value] => oaPumpTemp
  482. [descr] => Pump Temperature
  483. [index] => oaPumpTemp.{{ $index }}
  484. [divisor] => 10
  485. )
  486.  
  487. )
  488.  
  489. )
  490. Data commonDeviceInternalTemperature: Array
  491. (
  492. [1] => Array
  493. (
  494. [commonDeviceInternalTemperature] => 47
  495. )
  496.  
  497. )
  498. Final sensor value: 47
  499. Cur 47, Low: null, Low Warn: null, Warn: null, High: null
  500. Discover sensor: .1.3.6.1.4.1.17409.1.3.3.2.2.1.12.1, commonDeviceInternalTemperature.1, gw-eydfa, Internal Temperature, snmp, 1, 1, , 47
  501. SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","temperature",265,"gw-eydfa","commonDeviceInternalTemperature.1"] 0.51ms]
  502. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["temperature",265,"gw-eydfa","commonDeviceInternalTemperature.1"] 0.62ms]
  503. .Data oaPumpTable: Array
  504. (
  505. [1] => Array
  506. (
  507. [oaPumpIndex] => 1
  508. [oaPumpBIAS] => 541
  509. [oaPumpTEC] => 28
  510. [oaPumpTemp] => 253
  511. )
  512.  
  513. [2] => Array
  514. (
  515. [oaPumpIndex] => 2
  516. [oaPumpBIAS] => 8240
  517. [oaPumpTEC] => 0
  518. [oaPumpTemp] => 0
  519. )
  520.  
  521. )
  522. Final sensor value: 253
  523. Cur 253, Low: null, Low Warn: null, Warn: null, High: null
  524. Discover sensor: .1.3.6.1.4.1.17409.1.11.4.1.4.1, oaPumpTemp.1, gw-eydfa, Pump Temperature, snmp, 10, 1, , 25.3
  525. SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","temperature",265,"gw-eydfa","oaPumpTemp.1"] 0.52ms]
  526. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["temperature",265,"gw-eydfa","oaPumpTemp.1"] 0.63ms]
  527. .Final sensor value: 0
  528. Array
  529. (
  530. [gw-eydfa] => Array
  531. (
  532. [commonDeviceInternalTemperature.1] => 1
  533. [oaPumpTemp.1] => 1
  534. )
  535.  
  536. )
  537. 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",265,"snmp"] 0.83ms]
  538. oaPumpTemp.1 -> gw-eydfa
  539. commonDeviceInternalTemperature.1 -> gw-eydfa
  540.  
  541. Voltage: Dynamic Discovery (voltage): Array
  542. (
  543. [data] => Array
  544. (
  545. [0] => Array
  546. (
  547. [oid] => oaDCPowerTable
  548. [num_oid] => .1.3.6.1.4.1.17409.1.11.7.1.2.
  549. [descr] => oaDCPowerName
  550. [index] => oaDCPowerVoltage.{{ $index }}
  551. [value] => oaDCPowerVoltage
  552. [divisor] => 10
  553. )
  554.  
  555. )
  556.  
  557. )
  558. Data oaDCPowerTable: Array
  559. (
  560. [1] => Array
  561. (
  562. [oaDCPowerIndex] => 1
  563. [oaDCPowerVoltage] => 48
  564. [oaDCPowerCurrent] => 0
  565. [oaDCPowerName] => DC +5V
  566. )
  567.  
  568. )
  569. Final sensor value: 48
  570. Cur 48, Low: null, Low Warn: null, Warn: null, High: null
  571. Discover sensor: .1.3.6.1.4.1.17409.1.11.7.1.2.1, oaDCPowerVoltage.1, gw-eydfa, DC +5V, snmp, 10, 1, , 4.8
  572. SQL[SELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? ["snmp","voltage",265,"gw-eydfa","oaDCPowerVoltage.1"] 0.51ms]
  573. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? ["voltage",265,"gw-eydfa","oaDCPowerVoltage.1"] 0.71ms]
  574. .Array
  575. (
  576. [gw-eydfa] => Array
  577. (
  578. [oaDCPowerVoltage.1] => 1
  579. )
  580.  
  581. )
  582. 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",265,"snmp"] 0.97ms]
  583. oaDCPowerVoltage.1 -> gw-eydfa
  584.  
  585. Snr: 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",265,"snmp"] 0.73ms]
  586.  
  587. Pressure: 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",265,"snmp"] 0.76ms]
  588.  
  589. Cooling: 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",265,"snmp"] 0.74ms]
  590.  
  591. Delay: 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",265,"snmp"] 0.77ms]
  592.  
  593. Quality_factor: 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",265,"snmp"] 0.79ms]
  594.  
  595. Chromatic_dispersion: 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",265,"snmp"] 0.75ms]
  596.  
  597. Ber: 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",265,"snmp"] 0.71ms]
  598.  
  599. Eer: 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",265,"snmp"] 0.77ms]
  600.  
  601. Waterflow: 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",265,"snmp"] 0.77ms]
  602.  
  603.  
  604. >> Runtime for discovery module 'sensors': 0.2280 seconds with 55096 bytes
  605. >> SNMP: [7/0.17s] MySQL: [64/0.04s] RRD: [0/0.00s]
  606. #### Unload disco module sensors ####
  607.  
  608. SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = ? AND `attrib_type` = ? [265,"poll_mib"] 0.4ms]
  609. SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = ? AND `attrib_type` = ? [265,"poll_mib"] 0.41ms]
  610. MIB: registering
  611. SNMP[snmptranslate -M /opt/dev_librenms/mibs:/opt/dev_librenms/mibs/glassway -IR -m all .1.3.6.1.4.1.17409.1.11 2>/dev/null]
  612.  
  613. This doesn't look like a MIB:
  614. MIB: Could not find all::.1.3.6.1.4.1.17409.1.11
  615.  
  616. SQL[UPDATE `devices` set `last_discovered`=NOW(),`last_discovered_timetaken`=? WHERE `device_id` = ? [5.4009999999999998,265] 0.76ms]
  617. Discovered in 5.401 seconds
  618.  
  619. SQL[INSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES (:type,:doing,:start,:duration,:devices,:poller) {"type":"discover","doing":"265","start":1536484488.267612,"duration":"5.649","devices":1,"poller":"librenms.tvt-datos.es"} 0.51ms]
  620. ./discovery.php 265 2018-09-09 11:14:53 - 1 devices discovered in 5.649 secs
  621. SNMP [9/0.24s]: Get[2/0.08s] Getnext[0/0.00s] Walk[7/0.17s]
  622. MySQL [72/0.05s]: Cell[17/0.01s] Row[7/0.01s] Rows[33/0.03s] Column[0/0.00s] Update[5/0.00s] Insert[10/0.01s] Delete[0/0.00s]
  623. RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!