From Sphinx, 6 Months ago, written in Plain Text.
Embed
  1. [librenms@librenms ~]$ ./poller.php -h shdslmodem01 -r -f -d -m sensors
  2. LibreNMS Poller
  3. SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 4.67ms]
  4.  
  5. SQL[select count(*) as aggregate from `migrations` limit 1 [] 0.36ms]
  6.  
  7. SQL[SELECT version() [] 0.22ms]
  8.  
  9. ===================================
  10. Version info:
  11. Commit SHA: 70023c0b59d1ed0cbe68f91fdd868051f9027f53
  12. Commit Date: 1622552286
  13. DB Schema: 2021_04_08_151101_add_foreign_keys_to_port_group_port_table (208)
  14. PHP: 7.4.16
  15. MySQL: 10.3.28-MariaDB
  16. RRDTool: 1.7.0
  17. SNMP: NET-SNMP 5.8
  18. ==================================DEBUG!
  19. Updating os_def.cache  
  20. Override poller modules: sensors  
  21. Starting polling run:
  22.  
  23. SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'shdslmodem01' ORDER BY `device_id` ASC [] 0.93ms]
  24.  
  25. SQL[select * from `devices` where `device_id` = ? limit 1 [93] 0.61ms]
  26.  
  27. SQL[select * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [93] 0.77ms]
  28.  
  29. Attempting to initialize OS: weos  
  30. Attempting to initialize OS: westermo  
  31. OS initialized as Generic  
  32. Hostname:    shdslmodem01
  33. Device ID:   93
  34. OS:          weos
  35. Resolved IP: 192.168.20.20
  36.  (westermo)
  37.  
  38. SQL[select `hostname`, `overwrite_ip` from `devices` where `hostname` = ? limit 1 ["shdslmodem01"] 0.74ms]
  39.  
  40. [FPING] '/usr/sbin/fping' '-e' '-q' '-c' '1' '-p' '300' '-t' '300' 'shdslmodem01'
  41.  
  42. response:  {"xmt":1,"rcv":1,"loss":0,"min":4.56,"max":4.56,"avg":4.56,"dup":0,"exitcode":0}
  43. 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` = ? [93] 5.65ms]
  44.  
  45. SQL[select * from `locations` where `locations`.`id` = ? limit 1 [65] 9.88ms]
  46.  
  47. 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(`end`) &lt;= ? or time(`start`) > ?))) 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 `device_groups` inner join `alert_schedulables` on `device_groups`.`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` in (?)) 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` ["2021-06-03T08:01:15.682221Z","2021-06-03T08:01:15.682221Z",0,1,"08:01:15","08:01:15","08:01:15","08:01:15","%","device",93,"device_group",4,"location",65] 11.42ms]
  48.  
  49. 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":1,"rcv":1,"loss":0,"min":4.56,"max":4.56,"avg":4.56,"device_id":93,"debug":"[]"} 3.38ms]
  50.  
  51. SQL[UPDATE `devices` set `last_ping`=?,`last_ping_timetaken`=? WHERE device_id=? ["2021-06-03 10:01:15",4.56,93] 0.86ms]
  52.  
  53. SNMP Check response code: 0  
  54. Modules status: Global+  
  55. OS  
  56. Device  
  57.  
  58. #### Load poller module core ####
  59. SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUt' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/westermo' 'udp:HOSTNAME:161' 'sysUpTime.0' 'sysName.0' 'sysObjectID.0' 'sysDescr.0']
  60. .*.*.0 = 375168901
  61. .*.*.0 = shdslmodem01
  62. .*.*.0 = .*.4.1.16177
  63. .*.*.0 = Westermo Wolverine, primary: v4.13.4, backup: v4.13.4, bootloader: v4.07  
  64.  
  65. SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUst' '-m' 'HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/westermo' 'udp:HOSTNAME:161' 'snmpEngineTime.0' 'hrSystemUptime.0']
  66. snmpEngineTime.0 = 175550366
  67. hrSystemUptime.0 = No Such Object available on this agent at this OID  
  68.  
  69. Uptime seconds: 175550366  
  70. Uptime:  5 years 206 days 19 hours 59 minutes 26 seconds
  71.  
  72. >> Runtime for poller module 'core': 0.5470 seconds with 4400 bytes
  73. >> SNMP: [2/0.54s] MySQL: [0/0.00s]
  74. #### Unload poller module core ####
  75.  
  76. Modules status: Global+  
  77. OS  
  78. Device  
  79.  
  80. #### Load poller module availability ####
  81. SQL[SELECT duration FROM availability WHERE device_id = ? [93] 9.17ms]
  82.  
  83. Availability:
  84. SQL[SELECT * FROM availability WHERE device_id = ? [93] 6.73ms]
  85.  
  86. SQL[select * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [93,1622620876] 1.49ms]
  87.  
  88. SQL[UPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [100,369] 1.32ms]
  89.  
  90. 1 day : 100%
  91. SQL[select * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [93,1622102476] 2.94ms]
  92.  
  93. SQL[UPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [100,370] 0.15ms]
  94.  
  95. 7 days : 100%
  96. SQL[select * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [93,1620115276] 0.19ms]
  97.  
  98. SQL[UPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [100,371] 0.11ms]
  99.  
  100. 30 days : 100%
  101. SQL[select * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [93,1591171276] 0.16ms]
  102.  
  103. SQL[UPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [100,372] 1.32ms]
  104.  
  105. 365 days : 100%
  106.  
  107. >> Runtime for poller module 'availability': 0.0302 seconds with 29160 bytes
  108. >> SNMP: [0/0.00s] MySQL: [5/0.01s]
  109. #### Unload poller module availability ####
  110.  
  111. Modules status: Global+  
  112. OS+  
  113. Device  
  114.  
  115. #### Load poller module sensors ####
  116. SQL[SELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [93] 1.23ms]
  117.  
  118. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? ["snr",93] 0.39ms]
  119.  
  120. SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/westermo' 'udp:HOSTNAME:161' '.1.3.6.1.2.1.10.48.1.5.1.2.4096.0.0.wirePair1' '.1.3.6.1.2.1.10.48.1.5.1.2.4097.xtuC.0.wirePair1']
  121. Exitcode: 1  
  122. .1.3.6.1.2.1.10.48.1.5.1.2.4096.0.0.wirePair1: Unknown Object Identifier (Sub-id not found: transmission -> wirePair1)
  123. .1.3.6.1.2.1.10.48.1.5.1.2.4097.xtuC.0.wirePair1: Unknown Object Identifier (Sub-id not found: transmission -> xtuC.0.wirePair1)  
  124.  
  125. .1.3.6.1.2.1.10.48.1.5.1.2.4096.0.0.wirePair1: Unknown Object Identifier (Sub-id not found: transmission -> wirePair1)
  126. .1.3.6.1.2.1.10.48.1.5.1.2.4097.xtuC.0.wirePair1: Unknown Object Identifier (Sub-id not found: transmission -> xtuC.0.wirePair1)  
  127. Checking (snmp) snr Port 1/1...
  128. Checking (snmp) snr Port 1/2...
  129. 0 SNR
  130. 0 SNR
  131. SQL[SELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? ["temperature",93] 6.76ms]
  132.  
  133. SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/westermo' 'udp:HOSTNAME:161' '.1.3.6.1.2.1.99.1.1.1.4.1000']
  134. .*.*.*0 = 32  
  135.  
  136. Checking (snmp) temperature T1...
  137. 32 C
  138.  
  139. >> Runtime for poller module 'sensors': 0.4691 seconds with 2448 bytes
  140. >> SNMP: [2/0.45s] MySQL: [3/0.01s]
  141. #### Unload poller module sensors ####
  142.  
  143. SQL[UPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=? WHERE `device_id` = ? ["175550366",4.56,93] 14.41ms]
  144.  
  145. Updating shdslmodem01  
  146.  
  147. Polled in 1.615 seconds
  148. ### Start Device Groups ###
  149. SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [93] 5ms]
  150.  
  151. SQL[select * from `device_groups` [] 0.39ms]
  152.  
  153. SQL[select `devices`.`device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id`, `device_group_device`.`device_id` as `pivot_device_id` from `devices` inner join `device_group_device` on `devices`.`device_id` = `device_group_device`.`device_id` where `device_group_device`.`device_group_id` in (1, 2, 3, 4) [] 0.78ms]
  154.  
  155. SQL[select exists(select * from `devices` where (`devices`.`os` = ?) and `devices`.`device_id` = ?) as `exists` ["weos",93] 0.43ms]
  156.  
  157. SQL[select * from `device_group_device` where `device_group_device`.`device_id` = ? [93] 0.35ms]
  158.  
  159. Groups Added:  
  160. Groups Removed:  
  161. ### End Device Groups, runtime: 0.0153s ###
  162.  
  163. #### Start Alerts ####
  164. 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(`end`) &lt;= ? or time(`start`) > ?))) 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 `device_groups` inner join `alert_schedulables` on `device_groups`.`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` in (?)) 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` ["2021-06-03T08:01:17.235922Z","2021-06-03T08:01:17.235922Z",0,1,"08:01:17","08:01:17","08:01:17","08:01:17","%","device",93,"device_group",4,"location",65] 0.74ms]
  165.  
  166. SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [93] 0.44ms]
  167.  
  168. SQL[SELECT DISTINCT a.* FROM alert_rules a
  169.         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 = ?)
  170.         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 = ?))
  171.         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 = ?))
  172.         LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
  173.         WHERE a.disabled = 0 AND (
  174.             (d.device_id IS NULL AND g.group_id IS NULL)
  175.             OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=?))
  176.             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))
  177.         ) [93,93,93,93,93,93,93,93] 2.31ms]
  178.  
  179. #### End Alerts ####
  180. ./poller.php shdslmodem01 2021-06-03 10:01:17 - 1 devices polled in 2.698 secs  
  181. SNMP [5/1.40s]: Get[5/1.40s] Getnext[0/0.00s] Walk[0/0.00s]
  182. MySQL [13/0.04s]: Cell[1/0.00s] Row[-1/-0.00s] Rows[5/0.01s] Column[1/0.01s] Update[6/0.02s] Insert[1/0.00s] Delete[0/0.00s]
  183.