Librenms Poller

From Steven Gregg, 1 Year ago, written in Plain Text.
URL https://p.libren.ms/view/9b008a78
Embed
Download Paste or View Raw
  1. librenms@librenms:~$ ./poller.php -h 172.16.1.155 -d -f -m os
  2. LibreNMS Poller
  3. SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.36ms]
  4.  
  5. SQL[select count(*) as aggregate from `migrations` [] 0.3ms]
  6.  
  7. SQL[select version() [] 0.16ms]
  8.  
  9. ===========================================
  10. Component | Version
  11. --------- | -------
  12. LibreNMS  | 23.2.0-43-gae429d987 (2023-03-22T01:31:42+13:00)
  13. DB Schema | 2023_03_14_130653_migrate_empty_user_funcs_to_null (249)
  14. PHP       | 8.1.2
  15. Python    | 3.10.4
  16. Database  | MariaDB 10.6.7-MariaDB-2ubuntu1
  17. RRDTool   | 1.7.2
  18. SNMP      | 5.9.1
  19. ===========================================
  20. DEBUG!
  21. Updating os_def.cache
  22. Override poller modules: os
  23. Starting polling run:
  24.  
  25. SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '172.16.1.155' ORDER BY `device_id` ASC [] 0.65ms]
  26.  
  27. SQL[select * from `devices` where `device_id` = ? limit 1 [251] 0.24ms]
  28.  
  29. SQL[select * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [251] 0.25ms]
  30.  
  31. Attempting to initialize OS: ceraos
  32. OS initialized: LibreNMS\OS\Ceraos
  33. Hostname:    172.16.1.155
  34. Device ID:   251
  35. OS:          ceraos
  36.  
  37.  
  38. [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '1000' '-O' '0' '172.16.1.155'
  39.  
  40. response: xmt/rcv/%loss = 3/3/0%, min/avg/max = 1.93/1.99/2.04
  41. SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ceraos' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-t' '2' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0']
  42. SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::enterprises.22*.2.2
  43.  
  44.  
  45. SQL[insert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `debug`, `device_id`, `timestamp`) values (?, ?, ?, ?, ?, ?, ?, ?, ?) [1.93,2.04,1.99,3,3,0,"{\"poller_name\":\"librenms\"}",251,"2023-03-22 09:37:17"] 3.23ms]
  46.  
  47. SQL[update `devices` set `last_ping_timetaken` = ? where `device_id` = ? [1.99,251] 2.08ms]
  48.  
  49. RRD[update 172.16.1.155/ping-perf.rrd N:1.99 --daemon unix:/run/rrdcached.sock]
  50. SQL[select * 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 [251] 0.47ms]
  51.  
  52. Modules status: Global+
  53. OS
  54. Device
  55.  
  56. #### Load poller module core ####
  57. SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ceraos' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-On' '-t' '2' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysUpTime.0']
  58. .*.*.0 = 853891700
  59.  
  60.  
  61. SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ceraos' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-t' '2' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0']
  62. SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = No Such Object available on this agent at this OID
  63.  
  64.  
  65. SNMP['/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/ceraos' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-t' '2' 'udp:HOSTNAME:161' 'HOST-RESOURCES-MIB::hrSystemUptime.0']
  66. HOST-RESOURCES-MIB::hrSystemUptime.0 = No Such Object available on this agent at this OID
  67.  
  68.  
  69. Uptime seconds: 8538917
  70.  
  71. RRD[update 172.16.1.155/uptime.rrd N:8538917 --daemon unix:/run/rrdcached.sock]
  72. Uptime: 3 months 2 weeks 19 hours 55 minutes 17 seconds
  73. SQL[update `devices` set `uptime` = ? where `device_id` = ? [8538917,251] 2.24ms]
  74.  
  75.  
  76. >> Runtime for poller module 'core': 0.0463 seconds with 117224 bytes
  77. >> SNMP: [3/0.04s] MySQL: [1/0.02s] RRD: [1/0.00s]
  78. #### Unload poller module core ####
  79.  
  80. RRD[update 172.16.1.155/poller-perf-core.rrd N:0.046264886856079 --daemon unix:/run/rrdcached.sock]
  81. Modules status: Global+
  82. OS
  83. Device
  84.  
  85. #### Load poller module os ####
  86. Generic :(
  87. Location:
  88. Hardware: IP-20S
  89. OS Version: 12.0.0.0.0.366
  90. OS Features: 1 radios in unit
  91. Serial: E231320151
  92.  
  93. >> Runtime for poller module 'os': 0.0011 seconds with 116480 bytes
  94. >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [1/0.00s]
  95. #### Unload poller module os ####
  96.  
  97. RRD[update 172.16.1.155/poller-perf-os.rrd N:0.0010640621185303 --daemon unix:/run/rrdcached.sock]
  98. RRD[update 172.16.1.155/poller-perf.rrd N:1.086 --daemon unix:/run/rrdcached.sock]
  99.  
  100. Polled in 1.086 seconds
  101. ### Start Device Groups ###
  102. SQL[select * from `device_groups` [] 0.16ms]
  103.  
  104. SQL[select * from `device_group_device` where `device_group_device`.`device_id` = ? [251] 0.22ms]
  105.  
  106. Groups Added:
  107. Groups Removed:
  108. ### End Device Groups, runtime: 0.0021s ###
  109.  
  110. #### Start Alerts ####
  111. SQL[select `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` = ? [251] 0.36ms]
  112.  
  113. SQL[select 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` = ?))) as `exists` ["2023-03-21T20:37:17.229688Z","2023-03-21T20:37:17.229688Z",0,1,"20:37:17","20:37:17","20:37:17","20:37:17","%","device",251] 0.43ms]
  114.  
  115. SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [251] 0.3ms]
  116.  
  117. SQL[SELECT DISTINCT a.* FROM alert_rules a
  118.         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 = ?)
  119.         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 = ?))
  120.         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 = ?))
  121.         LEFT JOIN devices ld ON l.location_id=ld.location_id AND ld.device_id = ?
  122.         LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
  123.         WHERE a.disabled = 0 AND (
  124.             (d.device_id IS NULL AND g.group_id IS NULL AND l.location_id IS NULL)
  125.             OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=? OR ld.device_id=?))
  126.             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))
  127.         ) [251,251,251,251,251,251,251,251,251,251,251] 0.72ms]
  128.  
  129. Rule #1 (Devices up/down):
  130.  
  131. SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [251] 0.22ms]
  132.  
  133. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [1,251] 0.12ms]
  134.  
  135. Status: NOCHG
  136. Rule #2 (Device rebooted):
  137.  
  138. SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND devices.uptime < 300 xss=removed xss=removed xss=removed xss=removed xss=removed ports.ifOperStatus = "down" xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed>= "80"  &&  ((ports.ifOperStatus = "up"  &&  ports.ifAdminStatus = "up"  &&  ((ports.deleted = 0  &&  ports.ignore = 0  &&  ports.disabled = 0)))) = "1"  &&  ((ports.deleted = 0  &&  ports.ignore = 0  &&  ports.disabled = 0)) = "1") [251] 0.28ms]
  139.  
  140. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [6,251] 0.11ms]
  141.  
  142. Status: NOCHG
  143. Rule #7 (Sensor over limit):
  144.  
  145. SQL[SELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current > sensors.sensor_limit AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [251] 0.27ms]
  146.  
  147. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [7,251] 0.11ms]
  148.  
  149. Status: NOCHG
  150. Rule #8 (Sensor under limit):
  151.  
  152. SQL[SELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current < sensors xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed details`=? xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed>= customoids.customoid_limit AND customoids.customoid_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [251] 0.23ms]
  153.  
  154. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [14,251] 0.11ms]
  155.  
  156. Status: NOCHG
  157. Rule #15 (CustomOID under limit):
  158.  
  159. SQL[SELECT * FROM devices,customoids WHERE (devices.device_id = ? AND devices.device_id = customoids.device_id) AND customoids.customoid_current &lt;= customoids.customoid_limit_low AND customoids.customoid_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [251] 0.23ms]
  160.  
  161. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [15,251] 0.1ms]
  162.  
  163. Status: NOCHG
  164. #### End Alerts ####
  165. ./poller.php 172.16.1.155 2023-03-22 09:37:17 - 1 devices polled in 1.220 secs
  166.  
  167. SNMP [4/0.06s]: Snmpget[4/0.06s]
  168. SQL [39/0.18s]: Select[35/0.09s] Insert[1/0.03s] Update[3/0.06s]
  169. RRD [5/0.00s]: Update[5/0.00s]
  170.  


Reply to "Librenms Poller"