LibreNMS Pastebin service

ℹ️ Your data is safe here... unless you make the SNIP gods angry. And let's just say they have a really bad sense of humor.

Untitled

From librenms, 11 Months ago, written in Plain Text.
URL https://p.libren.ms/view/79d5e462
Embed
Download Paste or View Raw
  1. [1;31mWarning: poller.php is deprecated![0m Use [1mlnms device:poll[0m instead.
  2.  
  3. Override poller modules: unix-agent, core, os, availability, ipmi, sensors, processors, mempools, storage, netstats, hr-mib, ucd-mib, ipSystemStats, ports, xdsl, customoid, bgp-peers, junose-atm-vp, printer-supplies, ucd-diskio, vminfo, wifi, wireless, ospf, isis, cisco-ipsec-flow-monitor, cisco-remote-access-monitor, cisco-cef, slas, cisco-mac-accounting, cipsec-tunnels, cisco-ace-loadbalancer, cisco-ace-serverfarms, cisco-asa-firewall, cisco-voice, cisco-cbqos, cisco-otv, cisco-qfp, cisco-vpdn, nac, netscaler-vsvr, aruba-controller, entity-physical, entity-state, applications, stp, ntp, loadbalancers, mef, mpls  
  4. SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.89ms]
  5.  
  6. SQL[[1;33mselect count(*) as aggregate from `migrations` [0;33m[][0m 0.49ms]
  7.  
  8. SQL[[1;33mselect version() [0;33m[][0m 0.52ms]
  9.  
  10. ===========================================
  11. Component | Version
  12. --------- | -------
  13. LibreNMS  | 24.8.1 (2024-08-22T02:50:00+00:00)
  14. DB Schema | 2024_07_19_120719_update_ports_stack_table (296)
  15. PHP       | 8.1.2-1ubuntu2.18
  16. Python    | 3.10.12
  17. Database  | MariaDB 10.6.18-MariaDB-0ubuntu0.22.04.1
  18. RRDTool   | 1.7.2
  19. SNMP      | 5.9.1
  20. ===========================================
  21.  
  22. Updating os_def.cache  
  23. Starting polling run:
  24.  
  25. SQL[[1;33mselect `device_id` from `devices` where `hostname` = ? [0;33m["10.16.19.70"][0m 0.92ms]
  26.  
  27. SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[13][0m 0.79ms]
  28.  
  29. Hostname:  10.16.19.70
  30. ID:        13
  31. OS:        esphome
  32. IP:        10.16.19.70
  33.  
  34. Attempting to initialize OS: esphome  
  35. OS initialized as Generic (esphome)  
  36. SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[13][0m 9.11ms]
  37.  
  38. [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '-O' '0' '10.16.19.70'
  39.  
  40. response: 10.16.19.70 : xmt/rcv/%loss = 3/3/0%, min/avg/max = 17.3/38.1/77.4  
  41. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-Pu' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m]  
  42. SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::org.9999.32
  43.  
  44.  
  45. SQL[[1;33mupdate `devices` set `last_ping` = ?, `last_ping_timetaken` = ? where `device_id` = ? [0;33m["2024-09-27 23:01:01",38.1,13][0m 13.15ms]
  46.  
  47. SQL[[1;33mselect * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` is null order by `going_down` desc limit 1 [0;33m[13][0m 10.26ms]
  48.  
  49. #### Load poller module core ####
  50.  
  51. Module enabled: Global + | OS   | Device   | Manual    
  52. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-Pu' '-On' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysUpTime.0'[0m]  
  53. .*.*.0 = 0
  54.  
  55.  
  56. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-m' 'SNMPv2-TC:SNMPv2-MIB:IF-MIB:IP-MIB:TCP-MIB:UDP-MIB:NET-SNMP-VACM-MIB' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-Pu' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0'[0m]  
  57. SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = No Such Object available on this agent at this OID
  58. HOST-RESOURCES-MIB::hrSystemUptime.0 = 16440206
  59.  
  60.  
  61. Uptime seconds: 164402
  62.  
  63. Uptime: 1 day 21 hours 40 minutes 2 seconds  
  64. SQL[[1;33mupdate `devices` set `uptime` = ? where `device_id` = ? [0;33m[164402,13][0m 0.88ms]
  65.  
  66.  
  67. >> [0;36mSNMP[0m: [3/0.93s] [1;33mMySQL[0m: [4/0.33s]  
  68. >> Runtime for poller module 'core': 0.5378 seconds with 192648 bytes  
  69. #### Unload poller module core ####
  70.  
  71. #### Load poller module os ####
  72.  
  73. Module enabled: Global + | OS   | Device   | Manual    
  74. SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[3][0m 0.71ms]
  75.  
  76. Location: Living Room
  77. Hardware:
  78. OS Version:
  79. OS Features:
  80. Serial:
  81.  
  82. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
  83. >> Runtime for poller module 'os': 0.0064 seconds with 124272 bytes  
  84. #### Unload poller module os ####
  85.  
  86. #### Load poller module availability ####
  87.  
  88. Module enabled: Global + | OS   | Device   | Manual    
  89. SQL[[1;33mselect * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` >= ? order by `going_down` asc [0;33m[13,1727391662][0m 0.63ms]
  90.  
  91. SQL[[1;33mselect * from `availability` where (`device_id` = ? and `duration` = ?) limit 1 [0;33m[13,86400][0m 0.52ms]
  92.  
  93. SQL[[1;33mupdate `availability` set `availability_perc` = ? where `availability_id` = ? [0;33m[100,49][0m 0.4ms]
  94.  
  95. 1 day   : 100%  
  96. SQL[[1;33mselect * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` >= ? order by `going_down` asc [0;33m[13,1726873262][0m 0.5ms]
  97.  
  98. SQL[[1;33mselect * from `availability` where (`device_id` = ? and `duration` = ?) limit 1 [0;33m[13,604800][0m 0.48ms]
  99.  
  100. SQL[[1;33mupdate `availability` set `availability_perc` = ? where `availability_id` = ? [0;33m[100,50][0m 0.41ms]
  101.  
  102. 1 week  : 100%  
  103. SQL[[1;33mselect * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` >= ? order by `going_down` asc [0;33m[13,1724886062][0m 0.5ms]
  104.  
  105. SQL[[1;33mselect * from `availability` where (`device_id` = ? and `duration` = ?) limit 1 [0;33m[13,2592000][0m 0.45ms]
  106.  
  107. SQL[[1;33mupdate `availability` set `availability_perc` = ? where `availability_id` = ? [0;33m[100,51][0m 0.37ms]
  108.  
  109. 1 month : 100%  
  110. SQL[[1;33mselect * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` >= ? order by `going_down` asc [0;33m[13,1695942062][0m 1.95ms]
  111.  
  112. SQL[[1;33mselect * from `availability` where (`device_id` = ? and `duration` = ?) limit 1 [0;33m[13,31536000][0m 0.49ms]
  113.  
  114. SQL[[1;33mupdate `availability` set `availability_perc` = ? where `availability_id` = ? [0;33m[100,52][0m 0.44ms]
  115.  
  116. 1 year  : 100%  
  117. SQL[[1;33mdelete from `availability` where `availability`.`device_id` = ? and `availability`.`device_id` is not null and `availability_id` not in (?, ?, ?, ?) [0;33m[13,49,50,51,52][0m 0.43ms]
  118.  
  119.  
  120. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [13/0.08s]  
  121. >> Runtime for poller module 'availability': 0.0177 seconds with 71240 bytes  
  122. #### Unload poller module availability ####
  123.  
  124. #### Load poller module sensors ####
  125.  
  126. Module enabled: Global + | OS + | Device   | Manual    
  127. SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[13][0m 0.63ms]
  128.  
  129.  
  130. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
  131. >> Runtime for poller module 'sensors': 0.0020 seconds with 1960 bytes  
  132. #### Unload poller module sensors ####
  133.  
  134. #### Load poller module storage ####
  135.  
  136. Module enabled: Global + | OS   | Device   | Manual    
  137. SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[13][0m 0.62ms]
  138.  
  139. Storage FLASH: hrstorage
  140.  
  141.  
  142.  
  143. SNMP[[0;36m'/usr/bin/snmpwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'hrStorageEntry'[0m]
  144. hrStorageIndex.1 = 1
  145. hrStorageIndex.2 = 2
  146. hrStorageDescr.1 = FLASH
  147. hrStorageDescr.2 = SPI RAM
  148. hrStorageAllocationUnits.1 = 1
  149. hrStorageAllocationUnits.2 = 1
  150. hrStorageSize.1 = 4194304
  151. hrStorageSize.2 = 0
  152. hrStorageUsed.1 = 922048
  153. hrStorageUsed.2 = 0  
  154.  
  155. array (
  156.   'hrstorage' =>
  157.   array (
  158.     1 =>
  159.     array (
  160.       'hrStorageIndex' => '1',
  161.       'hrStorageDescr' => 'FLASH',
  162.       'hrStorageAllocationUnits' => '1',
  163.       'hrStorageSize' => '4194304',
  164.       'hrStorageUsed' => '922048',
  165.     ),
  166.     2 =>
  167.     array (
  168.       'hrStorageIndex' => '2',
  169.       'hrStorageDescr' => 'SPI RAM',
  170.       'hrStorageAllocationUnits' => '1',
  171.       'hrStorageSize' => '0',
  172.       'hrStorageUsed' => '0',
  173.     ),
  174.   ),
  175. )  
  176. array (
  177.   'storage_id' => 25,
  178.   'device_id' => 13,
  179.   'storage_mib' => 'hrstorage',
  180.   'storage_index' => '1',
  181.   'storage_type' => NULL,
  182.   'storage_descr' => 'FLASH',
  183.   'storage_size' => 4194304,
  184.   'storage_units' => 1,
  185.   'storage_used' => 922048,
  186.   'storage_free' => 3272256,
  187.   'storage_perc' => 22,
  188.   'storage_perc_warn' => 60,
  189.   'storage_deleted' => 0,
  190.   'units' => '1',
  191.   'used' => 922048,
  192.   'size' => 4194304,
  193.   'free' => 3272256,
  194. )  
  195. 22% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["922048","3272256","4194304",1,22,25][0m 0.78ms]
  196.  
  197.  
  198.  
  199. >> [0;36mSNMP[0m: [1/1.44s] [1;33mMySQL[0m: [2/0.01s]  
  200. >> Runtime for poller module 'storage': 1.4428 seconds with 54792 bytes  
  201. #### Unload poller module storage ####
  202.  
  203. SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[13][0m 0.68ms]
  204.  
  205. Enabled graphs (5): uptime poller_modules_perf availability poller_perf ping_perf
  206.  
  207.  
  208. SQL[[1;33mupdate `devices` set `last_polled` = ?, `last_polled_timetaken` = ? where `device_id` = ? [0;33m["2024-09-27 23:01:03",3.5671961307525635,13][0m 1.93ms]
  209.  
  210. #### Start Alerts ####  
  211. SQL[[1;33mselect `device_groups`.*, `device_group_device`.`device_id` as `pivot_device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id` from `device_groups` inner join `device_group_device` on `device_groups`.`id` = `device_group_device`.`device_group_id` where `device_group_device`.`device_id` = ? [0;33m[13][0m 0.66ms]
  212.  
  213. SQL[[1;33mselect exists(select * from `alert_schedule` where (`start` &lt;= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time xss=removed> ?) or (time(`start`) > time(`end`) and (time(`start`) &lt;= ? or time(`end`) > ?))) and (`recurring_day` like ? or `recurring_day` is null)))) and (exists (select * from `devices` inner join `alert_schedulables` on `devices`.`device_id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?) or exists (select * from `locations` inner join `alert_schedulables` on `locations`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?))) as `exists` [0;33m["2024-09-27T23:01:03.518075Z","2024-09-27T23:01:03.518075Z",0,1,"23:01:03","23:01:03","23:01:03","23:01:03","[45m%","device",13,"location",3][0m 1.11ms]
  214.  
  215. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[13][0m 0.68ms]
  216.  
  217. SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a
  218.         LEFT JOIN alert_device_map d ON a.id=d.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND d.device_id = ?)
  219.         LEFT JOIN alert_group_map g ON a.id=g.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND g.group_id IN (SELECT DISTINCT device_group_id FROM device_group_device WHERE device_id = ?))
  220.         LEFT JOIN alert_location_map l ON a.id=l.rule_id AND (a.invert_map = 0 OR a.invert_map = 1 AND l.location_id IN (SELECT DISTINCT location_id FROM devices WHERE device_id = ?))
  221.         LEFT JOIN devices ld ON l.location_id=ld.location_id AND ld.device_id = ?
  222.         LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
  223.         WHERE a.disabled = 0 AND (
  224.             (d.device_id IS NULL AND g.group_id IS NULL AND l.location_id IS NULL)
  225.             OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=? OR ld.device_id=?))
  226.             OR (a.invert_map = 1  AND (d.device_id != ? OR d.device_id IS NULL) AND (dg.device_id != ? OR dg.device_id IS NULL) AND (ld.device_id != ? OR ld.device_id IS NULL))
  227.         ) [0;33m[13,13,13,13,13,13,13,13,13,13,13][0m 1.96ms]
  228.  
  229. #### End Alerts (0.0174s) ####
  230.  
  231. ### Start Device Groups ###  
  232. SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.41ms]
  233.  
  234. SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[13][0m 0.44ms]
  235.  
  236. Groups Added:   Removed:  
  237. ### End Device Groups (0.0021s) ###
  238.  
  239.  
  240. >>> Polled 10.16.19.70 (13) in 3.567 seconds &lt;&lt;&lt;  
  241. [0;36mSNMP[0m [4/2.36s]: Snmpget[3/0.93s] Snmpwalk[1/1.44s]  
  242. [1;33mSQL[0m [35/0.56s]: Select[26/0.37s] Update[8/0.18s] Delete[1/0.00s]  
  243.  

Reply to "Untitled"

captcha