From robbert, 6 Years ago, written in Plain Text.
Embed
  1. LibreNMS Discovery
  2. ===================================
  3. Version info:
  4. Commit SHA: 89ff05ebeaf002bc9973a8449ada7eac15425545
  5. Commit Date: 1508240533
  6. DB Schema: 211
  7. PHP: 7.0.22-0ubuntu0.16.04.1
  8. MySQL: 5.7.19-0ubuntu0.16.04.1-log
  9. RRDTool: 1.5.5
  10. SNMP: NET-SNMP 5.7.3
  11. ==================================DEBUG!
  12. SQL[[0;33mSELECT * FROM `devices` WHERE status = 1 AND disabled = 0 AND `hostname` LIKE 'pi1.homeserv.lan' ORDER BY device_id DESC[0m]
  13. SQL[[0;33mSELECT * FROM devices_attribs WHERE `device_id` = '34'[0m]
  14. pi1.homeserv.lan 34 linux SQL[[0;33mINSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`)  VALUES ('3','3','0','0.37','0.45','0.40','34',NOW())[0m]
  15. SNMP Check response code: 0
  16. SQL[[0;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = '34' AND `attrib_type` = 'poll_mib' [0m]
  17.  
  18. Modules status: Global+ OS+ Device  
  19. #### Load disco module sensors ####
  20. Pre-cache linux: RaspberryPi SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c 'hslanread' -OQUs -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:pi1.homeserv.lan:161 .1.3.6.1.4.1.8072.1.3.2.4.1.2.9.114.97.115.112.98.101.114.114.121[0m]
  21. nsExtendOutLine."raspberry".1 = 56.4
  22. nsExtendOutLine."raspberry".2 = 1.3438
  23. nsExtendOutLine."raspberry".3 = 1.2000
  24. nsExtendOutLine."raspberry".4 = 1.2000
  25. nsExtendOutLine."raspberry".5 = 1.2250
  26. nsExtendOutLine."raspberry".6 = 1200000000
  27. nsExtendOutLine."raspberry".7 = 400000000
  28. nsExtendOutLine."raspberry".8 = disabled
  29. nsExtendOutLine."raspberry".9 = disabled
  30. nsExtendOutLine."raspberry".10 = disabled
  31. nsExtendOutLine."raspberry".11 = disabled
  32. nsExtendOutLine."raspberry".12 = disabled
  33. nsExtendOutLine."raspberry".13 = disabled
  34. nsExtendOutLine."raspberry".14 = H264=disabled
  35. nsExtendOutLine."raspberry".15 = MPG2=disabled
  36. nsExtendOutLine."raspberry".16 = WVC1=disabled
  37. nsExtendOutLine."raspberry".17 = MPG4=disabled
  38. nsExtendOutLine."raspberry".18 = MJPG=disabled
  39. nsExtendOutLine."raspberry".19 = WMV9=disabled
  40. nsExtendOutLine."raspberry".20 = WMV9=disabled
  41. nsExtendOutLine."raspberry".21 = H264=1
  42. nsExtendOutLine."raspberry".22 = MPG2=1
  43. nsExtendOutLine."raspberry".23 = WVC1=1
  44. nsExtendOutLine."raspberry".24 = MPG4=1
  45. nsExtendOutLine."raspberry".25 = MJPG=1
  46. nsExtendOutLine."raspberry".26 = WMV9=1
  47.  
  48.  
  49. Array
  50. (
  51.     [raspberry_pi_sensors] => Array
  52.         (
  53.             [raspberry.1] => Array
  54.                 (
  55.                     [nsExtendOutLine] => 56.4
  56.                 )
  57.  
  58.             [raspberry.2] => Array
  59.                 (
  60.                     [nsExtendOutLine] => 1.3438
  61.                 )
  62.  
  63.             [raspberry.3] => Array
  64.                 (
  65.                     [nsExtendOutLine] => 1.2000
  66.                 )
  67.  
  68.             [raspberry.4] => Array
  69.                 (
  70.                     [nsExtendOutLine] => 1.2000
  71.                 )
  72.  
  73.             [raspberry.5] => Array
  74.                 (
  75.                     [nsExtendOutLine] => 1.2250
  76.                 )
  77.  
  78.             [raspberry.6] => Array
  79.                 (
  80.                     [nsExtendOutLine] => 1200000000
  81.                 )
  82.  
  83.             [raspberry.7] => Array
  84.                 (
  85.                     [nsExtendOutLine] => 400000000
  86.                 )
  87.  
  88.             [raspberry.8] => Array
  89.                 (
  90.                     [nsExtendOutLine] => disabled
  91.                 )
  92.  
  93.             [raspberry.9] => Array
  94.                 (
  95.                     [nsExtendOutLine] => disabled
  96.                 )
  97.  
  98.             [raspberry.10] => Array
  99.                 (
  100.                     [nsExtendOutLine] => disabled
  101.                 )
  102.  
  103.             [raspberry.11] => Array
  104.                 (
  105.                     [nsExtendOutLine] => disabled
  106.                 )
  107.  
  108.             [raspberry.12] => Array
  109.                 (
  110.                     [nsExtendOutLine] => disabled
  111.                 )
  112.  
  113.             [raspberry.13] => Array
  114.                 (
  115.                     [nsExtendOutLine] => disabled
  116.                 )
  117.  
  118.             [raspberry.14] => Array
  119.                 (
  120.                     [nsExtendOutLine] => H264=disabled
  121.                 )
  122.  
  123.             [raspberry.15] => Array
  124.                 (
  125.                     [nsExtendOutLine] => MPG2=disabled
  126.                 )
  127.  
  128.             [raspberry.16] => Array
  129.                 (
  130.                     [nsExtendOutLine] => WVC1=disabled
  131.                 )
  132.  
  133.             [raspberry.17] => Array
  134.                 (
  135.                     [nsExtendOutLine] => MPG4=disabled
  136.                 )
  137.  
  138.             [raspberry.18] => Array
  139.                 (
  140.                     [nsExtendOutLine] => MJPG=disabled
  141.                 )
  142.  
  143.             [raspberry.19] => Array
  144.                 (
  145.                     [nsExtendOutLine] => WMV9=disabled
  146.                 )
  147.  
  148.             [raspberry.20] => Array
  149.                 (
  150.                     [nsExtendOutLine] => WMV9=disabled
  151.                 )
  152.  
  153.             [raspberry.21] => Array
  154.                 (
  155.                     [nsExtendOutLine] => H264=1
  156.                 )
  157.  
  158.             [raspberry.22] => Array
  159.                 (
  160.                     [nsExtendOutLine] => MPG2=1
  161.                 )
  162.  
  163.             [raspberry.23] => Array
  164.                 (
  165.                     [nsExtendOutLine] => WVC1=1
  166.                 )
  167.  
  168.             [raspberry.24] => Array
  169.                 (
  170.                     [nsExtendOutLine] => MPG4=1
  171.                 )
  172.  
  173.             [raspberry.25] => Array
  174.                 (
  175.                     [nsExtendOutLine] => MJPG=1
  176.                 )
  177.  
  178.             [raspberry.26] => Array
  179.                 (
  180.                     [nsExtendOutLine] => WMV9=1
  181.                 )
  182.  
  183.         )
  184.  
  185. )
  186.  ENTITY-SENSOR: Caching OIDs: entPhysicalDescrSNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c 'hslanread' -OQUs -m CISCO-ENTITY-SENSOR-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:pi1.homeserv.lan:161 entPhysicalDescr[0m]
  187. entPhysicalDescr = No Such Object available on this agent at this OID
  188.  
  189.  entPhysicalNameSNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c 'hslanread' -OQUs -m CISCO-ENTITY-SENSOR-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:pi1.homeserv.lan:161 entPhysicalName[0m]
  190. entPhysicalName = No Such Object available on this agent at this OID
  191.  
  192.  entPhySensorTypeSNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c 'hslanread' -OQUs -m ENTITY-SENSOR-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:pi1.homeserv.lan:161 entPhySensorType[0m]
  193. entPhySensorType = No Such Object available on this agent at this OID
  194.  
  195.  entPhySensorScaleSNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c 'hslanread' -OQUs -m ENTITY-SENSOR-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:pi1.homeserv.lan:161 entPhySensorScale[0m]
  196. entPhySensorScale = No Such Object available on this agent at this OID
  197.  
  198.  entPhySensorPrecisionSNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c 'hslanread' -OQUs -m ENTITY-SENSOR-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:pi1.homeserv.lan:161 entPhySensorPrecision[0m]
  199. entPhySensorPrecision = No Such Object available on this agent at this OID
  200.  
  201.  entPhySensorValueSNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c 'hslanread' -OQUs -m ENTITY-SENSOR-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:pi1.homeserv.lan:161 entPhySensorValue[0m]
  202. entPhySensorValue = No Such Object available on this agent at this OID
  203.  
  204.  
  205. SQL[[0;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = '34' AND `attrib_type` = 'ipmi_hostname' [0m]
  206. SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='voltage' AND S.device_id = D.device_id AND D.device_id = '34' AND S.poller_type = 'ipmi'[0m]
  207. SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='temperature' AND S.device_id = D.device_id AND D.device_id = '34' AND S.poller_type = 'ipmi'[0m]
  208. SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='fanspeed' AND S.device_id = D.device_id AND D.device_id = '34' AND S.poller_type = 'ipmi'[0m]
  209. SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='power' AND S.device_id = D.device_id AND D.device_id = '34' AND S.poller_type = 'ipmi'[0m]
  210. Airflow: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='airflow' AND S.device_id = D.device_id AND D.device_id = '34' AND S.poller_type = 'snmp'[0m]
  211.  
  212. Current: SNMP[[0;36m/usr/bin/snmpget -v2c -c 'hslanread' -Oqv -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:pi1.homeserv.lan:161 .1.3.6.1.2.1.1.1.0[0m]
  213. Linux pi1 4.9.54-v7+ #1042 SMP Wed Oct 11 23:18:56 BST 2017 armv7l
  214.  
  215. SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='current' AND S.device_id = D.device_id AND D.device_id = '34' AND S.poller_type = 'snmp'[0m]
  216.  
  217. Charge: SNMP[[0;36m/usr/bin/snmpget -v2c -c 'hslanread' -Oqv -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:pi1.homeserv.lan:161 .1.3.6.1.2.1.1.1.0[0m]
  218. Linux pi1 4.9.54-v7+ #1042 SMP Wed Oct 11 23:18:56 BST 2017 armv7l
  219.  
  220. SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='charge' AND S.device_id = D.device_id AND D.device_id = '34' AND S.poller_type = 'snmp'[0m]
  221.  
  222. Dbm: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='dbm' AND S.device_id = D.device_id AND D.device_id = '34' AND S.poller_type = 'snmp'[0m]
  223.  
  224. Fanspeed: SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c 'hslanread' -OsqnU -m LM-SENSORS-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:pi1.homeserv.lan:161 lmFanSensorsDevice[0m]
  225. .1.3.6.1.4.1.2021.13.16.3.1.2 No Such Instance currently exists at this OID
  226.  
  227.  
  228. SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='fanspeed' AND S.device_id = D.device_id AND D.device_id = '34' AND S.poller_type = 'snmp'[0m]
  229.  
  230. Frequency: Discover sensor: .1.3.6.1.4.1.8072.1.3.2.4.1.2.9.114.97.115.112.98.101.114.114.121.6, 6, raspberry_freq, ARM, snmp, 1, 1, , 1200000000
  231. SQL[[0;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'frequency' AND `device_id` = '34' AND sensor_type = 'raspberry_freq' AND `sensor_index` = '6'[0m]
  232. SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'frequency' AND `device_id` = '34' AND `sensor_type` = 'raspberry_freq' AND `sensor_index` = '6'[0m]
  233. .Discover sensor: .1.3.6.1.4.1.8072.1.3.2.4.1.2.9.114.97.115.112.98.101.114.114.121.7, 7, raspberry_freq, Core, snmp, 1, 1, , 400000000
  234. SQL[[0;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'frequency' AND `device_id` = '34' AND sensor_type = 'raspberry_freq' AND `sensor_index` = '7'[0m]
  235. SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'frequency' AND `device_id` = '34' AND `sensor_type` = 'raspberry_freq' AND `sensor_index` = '7'[0m]
  236. .SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='raspberry_freq' AND S.device_id = D.device_id AND D.device_id = '34' AND S.poller_type = 'snmp'[0m]
  237.  
  238. Humidity: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='humidity' AND S.device_id = D.device_id AND D.device_id = '34' AND S.poller_type = 'snmp'[0m]
  239.  
  240. Load: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='load' AND S.device_id = D.device_id AND D.device_id = '34' AND S.poller_type = 'snmp'[0m]
  241.  
  242. Power: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='power' AND S.device_id = D.device_id AND D.device_id = '34' AND S.poller_type = 'snmp'[0m]
  243.  
  244. Runtime: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='runtime' AND S.device_id = D.device_id AND D.device_id = '34' AND S.poller_type = 'snmp'[0m]
  245.  
  246. Signal: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='signal' AND S.device_id = D.device_id AND D.device_id = '34' AND S.poller_type = 'snmp'[0m]
  247.  
  248. State: SQL[[0;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = 'raspberry_codec' LIMIT 1[0m]
  249. SQL[[0;33mSELECT * FROM `state_translations` WHERE `state_index_id` = '11'[0m]
  250. Discover sensor: .1.3.6.1.4.1.8072.1.3.2.4.1.2.9.114.97.115.112.98.101.114.114.121.8, 8, raspberry_codec, H264 codec, snmp, 1, 1, 8, disabled
  251. SQL[[0;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'state' AND `device_id` = '34' AND sensor_type = 'raspberry_codec' AND `sensor_index` = '8'[0m]
  252. SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'state' AND `device_id` = '34' AND `sensor_type` = 'raspberry_codec' AND `sensor_index` = '8'[0m]
  253. .SQL[[0;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = 'state' AND `device_id` = '34' AND `sensor_type` = 'raspberry_codec' AND `sensor_index` = '8'[0m]
  254. SQL[[0;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = 'raspberry_codec'[0m]
  255. SQL[[0;33mINSERT INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`)  VALUES ('502','11')[0m]
  256. SQL[[0;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = 'raspberry_codec' LIMIT 1[0m]
  257. SQL[[0;33mSELECT * FROM `state_translations` WHERE `state_index_id` = '11'[0m]
  258. Discover sensor: .1.3.6.1.4.1.8072.1.3.2.4.1.2.9.114.97.115.112.98.101.114.114.121.9, 9, raspberry_codec, MPG2 codec, snmp, 1, 1, 9, disabled
  259. SQL[[0;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'state' AND `device_id` = '34' AND sensor_type = 'raspberry_codec' AND `sensor_index` = '9'[0m]
  260. SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'state' AND `device_id` = '34' AND `sensor_type` = 'raspberry_codec' AND `sensor_index` = '9'[0m]
  261. .SQL[[0;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = 'state' AND `device_id` = '34' AND `sensor_type` = 'raspberry_codec' AND `sensor_index` = '9'[0m]
  262. SQL[[0;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = 'raspberry_codec'[0m]
  263. SQL[[0;33mINSERT INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`)  VALUES ('503','11')[0m]
  264. SQL[[0;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = 'raspberry_codec' LIMIT 1[0m]
  265. SQL[[0;33mSELECT * FROM `state_translations` WHERE `state_index_id` = '11'[0m]
  266. Discover sensor: .1.3.6.1.4.1.8072.1.3.2.4.1.2.9.114.97.115.112.98.101.114.114.121.10, 10, raspberry_codec, WVC1 codec, snmp, 1, 1, 10, disabled
  267. SQL[[0;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'state' AND `device_id` = '34' AND sensor_type = 'raspberry_codec' AND `sensor_index` = '10'[0m]
  268. SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'state' AND `device_id` = '34' AND `sensor_type` = 'raspberry_codec' AND `sensor_index` = '10'[0m]
  269. .SQL[[0;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = 'state' AND `device_id` = '34' AND `sensor_type` = 'raspberry_codec' AND `sensor_index` = '10'[0m]
  270. SQL[[0;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = 'raspberry_codec'[0m]
  271. SQL[[0;33mINSERT INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`)  VALUES ('504','11')[0m]
  272. SQL[[0;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = 'raspberry_codec' LIMIT 1[0m]
  273. SQL[[0;33mSELECT * FROM `state_translations` WHERE `state_index_id` = '11'[0m]
  274. Discover sensor: .1.3.6.1.4.1.8072.1.3.2.4.1.2.9.114.97.115.112.98.101.114.114.121.11, 11, raspberry_codec, MPG4 codec, snmp, 1, 1, 11, disabled
  275. SQL[[0;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'state' AND `device_id` = '34' AND sensor_type = 'raspberry_codec' AND `sensor_index` = '11'[0m]
  276. SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'state' AND `device_id` = '34' AND `sensor_type` = 'raspberry_codec' AND `sensor_index` = '11'[0m]
  277. .SQL[[0;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = 'state' AND `device_id` = '34' AND `sensor_type` = 'raspberry_codec' AND `sensor_index` = '11'[0m]
  278. SQL[[0;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = 'raspberry_codec'[0m]
  279. SQL[[0;33mINSERT INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`)  VALUES ('505','11')[0m]
  280. SQL[[0;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = 'raspberry_codec' LIMIT 1[0m]
  281. SQL[[0;33mSELECT * FROM `state_translations` WHERE `state_index_id` = '11'[0m]
  282. Discover sensor: .1.3.6.1.4.1.8072.1.3.2.4.1.2.9.114.97.115.112.98.101.114.114.121.12, 12, raspberry_codec, MJPG codec, snmp, 1, 1, 12, disabled
  283. SQL[[0;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'state' AND `device_id` = '34' AND sensor_type = 'raspberry_codec' AND `sensor_index` = '12'[0m]
  284. SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'state' AND `device_id` = '34' AND `sensor_type` = 'raspberry_codec' AND `sensor_index` = '12'[0m]
  285. .SQL[[0;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = 'state' AND `device_id` = '34' AND `sensor_type` = 'raspberry_codec' AND `sensor_index` = '12'[0m]
  286. SQL[[0;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = 'raspberry_codec'[0m]
  287. SQL[[0;33mINSERT INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`)  VALUES ('506','11')[0m]
  288. SQL[[0;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = 'raspberry_codec' LIMIT 1[0m]
  289. SQL[[0;33mSELECT * FROM `state_translations` WHERE `state_index_id` = '11'[0m]
  290. Discover sensor: .1.3.6.1.4.1.8072.1.3.2.4.1.2.9.114.97.115.112.98.101.114.114.121.13, 13, raspberry_codec, WMV9 codec, snmp, 1, 1, 13, disabled
  291. SQL[[0;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'state' AND `device_id` = '34' AND sensor_type = 'raspberry_codec' AND `sensor_index` = '13'[0m]
  292. SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'state' AND `device_id` = '34' AND `sensor_type` = 'raspberry_codec' AND `sensor_index` = '13'[0m]
  293. .SQL[[0;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = 'state' AND `device_id` = '34' AND `sensor_type` = 'raspberry_codec' AND `sensor_index` = '13'[0m]
  294. SQL[[0;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = 'raspberry_codec'[0m]
  295. SQL[[0;33mINSERT INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`)  VALUES ('507','11')[0m]
  296. Array
  297. (
  298.     [raspberry_codec] => Array
  299.         (
  300.             [8] => 1
  301.             [9] => 1
  302.             [10] => 1
  303.             [11] => 1
  304.             [12] => 1
  305.             [13] => 1
  306.         )
  307.  
  308. )
  309. SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='state' AND S.device_id = D.device_id AND D.device_id = '34' AND S.poller_type = 'snmp'[0m]
  310. 8 -> raspberry_codec
  311. 9 -> raspberry_codec
  312. 10 -> raspberry_codec
  313. 11 -> raspberry_codec
  314. 12 -> raspberry_codec
  315. 13 -> raspberry_codec
  316.  
  317. Temperature: SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c 'hslanread' -Osqn -m LM-SENSORS-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:pi1.homeserv.lan:161 lmTempSensorsDevice[0m]
  318. .1.3.6.1.4.1.2021.13.16.2.1.2 No Such Instance currently exists at this OID
  319.  
  320.  
  321. SNMP[[0;36m/usr/bin/snmpget -v2c -c 'hslanread' -Oqve -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:pi1.homeserv.lan:161 .1.3.6.1.4.1.8072.1.3.2.4.1.2.9.114.97.115.112.98.101.114.114.121.1[0m]
  322. 56.4
  323.  
  324. Discover sensor: .1.3.6.1.4.1.8072.1.3.2.4.1.2.9.114.97.115.112.98.101.114.114.121.1, 1, raspberry_temp, CPU Temp, snmp, 1, 1, , 56.4
  325. SQL[[0;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'temperature' AND `device_id` = '34' AND sensor_type = 'raspberry_temp' AND `sensor_index` = '1'[0m]
  326. SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'temperature' AND `device_id` = '34' AND `sensor_type` = 'raspberry_temp' AND `sensor_index` = '1'[0m]
  327. .SNMP[[0;36m/usr/bin/snmpget -v2c -c 'hslanread' -Oqv -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:pi1.homeserv.lan:161 .1.3.6.1.2.1.1.1.0[0m]
  328. Linux pi1 4.9.54-v7+ #1042 SMP Wed Oct 11 23:18:56 BST 2017 armv7l
  329.  
  330. SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c 'hslanread' -Osqn -m SUPERMICRO-HEALTH-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:pi1.homeserv.lan:161 .1.3.6.1.4.1.10876.2.1.1.1.1.3[0m]
  331. .1.3.6.1.4.1.10876.2.1.1.1.1.3 No Such Object available on this agent at this OID
  332.  
  333. SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='raspberry_temp' AND S.device_id = D.device_id AND D.device_id = '34' AND S.poller_type = 'snmp'[0m]
  334.  
  335. Voltage: SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c 'hslanread' -OsqnU -m LM-SENSORS-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:pi1.homeserv.lan:161 lmVoltSensorsDevice[0m]
  336. .1.3.6.1.4.1.2021.13.16.4.1.2 No Such Instance currently exists at this OID
  337.  
  338.  
  339. Discover sensor: .1.3.6.1.4.1.8072.1.3.2.4.1.2.9.114.97.115.112.98.101.114.114.121.2, 2, rasbperry_volts, Core, snmp, 1, 1, , 1.3438
  340. SQL[[0;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '34' AND sensor_type = 'rasbperry_volts' AND `sensor_index` = '2'[0m]
  341. SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '34' AND `sensor_type` = 'rasbperry_volts' AND `sensor_index` = '2'[0m]
  342. .Discover sensor: .1.3.6.1.4.1.8072.1.3.2.4.1.2.9.114.97.115.112.98.101.114.114.121.3, 3, rasbperry_volts, SDRAMc, snmp, 1, 1, , 1.2000
  343. SQL[[0;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '34' AND sensor_type = 'rasbperry_volts' AND `sensor_index` = '3'[0m]
  344. SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '34' AND `sensor_type` = 'rasbperry_volts' AND `sensor_index` = '3'[0m]
  345. .Discover sensor: .1.3.6.1.4.1.8072.1.3.2.4.1.2.9.114.97.115.112.98.101.114.114.121.4, 4, rasbperry_volts, SDRAMi, snmp, 1, 1, , 1.2000
  346. SQL[[0;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '34' AND sensor_type = 'rasbperry_volts' AND `sensor_index` = '4'[0m]
  347. SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '34' AND `sensor_type` = 'rasbperry_volts' AND `sensor_index` = '4'[0m]
  348. .Discover sensor: .1.3.6.1.4.1.8072.1.3.2.4.1.2.9.114.97.115.112.98.101.114.114.121.5, 5, rasbperry_volts, SDRAMp, snmp, 1, 1, , 1.2250
  349. SQL[[0;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= 'snmp' AND `sensor_class` = 'voltage' AND `device_id` = '34' AND sensor_type = 'rasbperry_volts' AND `sensor_index` = '5'[0m]
  350. SQL[[0;33mSELECT * FROM `sensors` WHERE `sensor_class` = 'voltage' AND `device_id` = '34' AND `sensor_type` = 'rasbperry_volts' AND `sensor_index` = '5'[0m]
  351. .SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c 'hslanread' -OsqnU -m SUPERMICRO-HEALTH-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:pi1.homeserv.lan:161 .1.3.6.1.4.1.10876.2.1.1.1.1.3[0m]
  352. .1.3.6.1.4.1.10876.2.1.1.1.1.3 No Such Object available on this agent at this OID
  353.  
  354.  
  355. SNMP[[0;36m/usr/bin/snmpget -v2c -c 'hslanread' -Oqv -M /opt/librenms/mibs:/opt/librenms/mibs/supermicro:/opt/librenms/mibs/dell udp:pi1.homeserv.lan:161 .1.3.6.1.2.1.1.1.0[0m]
  356. Linux pi1 4.9.54-v7+ #1042 SMP Wed Oct 11 23:18:56 BST 2017 armv7l
  357.  
  358. SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='rasbperry_volts' AND S.device_id = D.device_id AND D.device_id = '34' AND S.poller_type = 'snmp'[0m]
  359.  
  360. Snr: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='snr' AND S.device_id = D.device_id AND D.device_id = '34' AND S.poller_type = 'snmp'[0m]
  361.  
  362. Pressure: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='pressure' AND S.device_id = D.device_id AND D.device_id = '34' AND S.poller_type = 'snmp'[0m]
  363.  
  364. Cooling: SQL[[0;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='cooling' AND S.device_id = D.device_id AND D.device_id = '34' AND S.poller_type = 'snmp'[0m]
  365.  
  366.  
  367. >> Runtime for discovery module 'sensors': 1.2960 seconds with 19096 bytes
  368. #### Unload disco module sensors ####
  369.  
  370. SQL[[0;33mSELECT attrib_value FROM devices_attribs WHERE `device_id` = '34' AND `attrib_type` = 'poll_mib' [0m]
  371. SQL[[0;33mUPDATE `devices` set `last_discovered` =NOW(),`last_discovered_timetaken` ='1.726' WHERE `device_id` = '34'[0m]
  372. Discovered in 1.726 seconds
  373.  
  374. SQL[[0;33mINSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`)  VALUES ('discover','pi1.homeserv.lan','1508251172.5642','1.757','1','mon1\n')[0m]
  375. /opt/librenms/discovery.php pi1.homeserv.lan 2017-10-17 16:39:34 - 1 devices discovered in 1.757 secs
  376. SNMP: Get[6/0.11s] Walk [12/1.16s]
  377. MySQL: Cell[21/0.01s] Row[28/0.01s] Rows[31/0.01s] Column[0/0.00s] Update[1/0.00s] Insert[8/0.02s] Delete[0/0.00s]
  378.