ℹ️ 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.

From librenms, 4 Years ago, written in Plain Text.
Embed
  1. LibreNMS Poller
  2. SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.62ms]
  3.  
  4. SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 0.45ms]
  5.  
  6. SQL[[1;33mSELECT version() [0;33m[][0m 0.33ms]
  7.  
  8. ===================================
  9. Version info:
  10. Commit SHA: e782bdbe02a21858a5df6e0a1ee4da5c8da6c71f
  11. Commit Date: 1621297073
  12. DB Schema: 2021_04_08_151101_add_foreign_keys_to_port_group_port_table (208)
  13. PHP: 7.4.12
  14. MySQL: 10.5.9-MariaDB
  15. RRDTool: 1.4.8
  16. SNMP: NET-SNMP 5.7.2
  17. ==================================DEBUG!
  18. Updating os_def.cache  
  19. Starting polling run:
  20.  
  21. SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '[REMOVED]' ORDER BY `device_id` ASC [0;33m[][0m 0.96ms]
  22.  
  23. SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[240][0m 0.5ms]
  24.  
  25. SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[240][0m 0.35ms]
  26.  
  27. Attempting to initialize OS: vertiv-pdu  
  28. Attempting to initialize OS: vertiv  
  29. OS initialized as Generic  
  30. Hostname:    [REMOVED]
  31. Device ID:   240
  32. OS:          vertiv-pdu
  33. Resolved IP: [REMOVED]
  34.  (vertiv)
  35.  
  36. SQL[[1;33mselect `hostname`, `overwrite_ip` from `devices` where `hostname` = ? limit 1 [0;33m["[REMOVED]"][0m 0.42ms]
  37.  
  38. [FPING] '/usr/sbin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '[REMOVED]'
  39.  
  40. response:  {"xmt":3,"rcv":3,"loss":0,"min":0.55000000000000004,"max":2.23,"avg":1.1200000000000001,"dup":0,"exitcode":0}
  41. 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[240][0m 0.67ms]
  42.  
  43. SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[132][0m 0.36ms]
  44.  
  45. 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(`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 `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["2021-05-19T12:28:32.064425Z","2021-05-19T12:28:32.064425Z",0,1,"12:28:32","12:28:32","12:28:32","12:28:32","[43m%","device",240,"location",132][0m 1.21ms]
  46.  
  47. SQL[[1;33mINSERT 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) [0;33m{"xmt":3,"rcv":3,"loss":0,"min":0.55000000000000004,"max":2.23,"avg":1.1200000000000001,"device_id":240,"debug":"[]"}[0m 0.94ms]
  48.  
  49. SQL[[1;33mUPDATE `devices` set `last_ping`=?,`last_ping_timetaken`=? WHERE device_id=? [0;33m["2021-05-19 08:28:32",1.1200000000000001,240][0m 0.77ms]
  50.  
  51. SNMP Check response code: 0  
  52. Modules status: Global+  
  53. OS  
  54. Device  
  55.  
  56. #### Load poller module core ####
  57. SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQnUt' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'sysUpTime.0' 'sysName.0' 'sysObjectID.0' 'sysDescr.0'[0m]
  58. .*.*.0 = 260505890
  59. .*.*.0 = [REMOVED]
  60. .*.*.0 = .*.4.1.21*
  61. .*.*.0 = [REMOVED]  
  62.  
  63. SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQnUst' '-m' 'HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'snmpEngineTime.0' 'hrSystemUptime.0'[0m]
  64. snmpEngineTime.0 = 2605059
  65. hrSystemUptime.0 = No Such Object available on this agent at this OID  
  66.  
  67. Uptime seconds: 2605059  
  68. Uptime:  30 days 3 hours 37 minutes 39 seconds
  69.  
  70. >> Runtime for poller module 'core': 0.1102 seconds with 25496 bytes
  71. >> SNMP: [2/0.11s] MySQL: [0/0.00s]
  72. #### Unload poller module core ####
  73.  
  74. Modules status: Global+  
  75. OS  
  76. Device  
  77.  
  78. #### Load poller module availability ####
  79. SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[240][0m 0.65ms]
  80.  
  81. Availability:
  82. SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[240][0m 0.36ms]
  83.  
  84. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[240,1621340912][0m 0.41ms]
  85.  
  86. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,857][0m 0.28ms]
  87.  
  88. 1 day : 100%
  89. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[240,1620822512][0m 0.38ms]
  90.  
  91. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,858][0m 0.26ms]
  92.  
  93. 7 days : 100%
  94. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[240,1618835312][0m 0.39ms]
  95.  
  96. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,859][0m 0.26ms]
  97.  
  98. 30 days : 100%
  99. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[240,1589891312][0m 0.39ms]
  100.  
  101. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,860][0m 0.25ms]
  102.  
  103. 365 days : 100%
  104.  
  105. >> Runtime for poller module 'availability': 0.0067 seconds with 39112 bytes
  106. >> SNMP: [0/0.00s] MySQL: [5/0.00s]
  107. #### Unload poller module availability ####
  108.  
  109. Modules status: Global-  
  110. OS  
  111. Device  
  112. Module [ unix-agent ] disabled globally.
  113.  
  114. Modules status: Global+  
  115. OS  
  116. Device  
  117.  
  118. #### Load poller module os ####
  119. Generic :(
  120. Location: [REMOVED]
  121. Hardware: MN03EDR1-15P3B8-6PS15D0H10-S
  122. OS Version: 5.6.1
  123. OS Features:
  124. Serial: [REMOVED]
  125.  
  126. >> Runtime for poller module 'os': 0.0019 seconds with 92608 bytes
  127. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
  128. #### Unload poller module os ####
  129.  
  130. Modules status: Global+  
  131. OS  
  132. Device  
  133.  
  134. #### Load poller module ipmi ####
  135. SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[240][0m 0.5ms]
  136.  
  137. array (
  138. )  
  139.  
  140. >> Runtime for poller module 'ipmi': 0.0009 seconds with 2992 bytes
  141. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  142. #### Unload poller module ipmi ####
  143.  
  144. Modules status: Global+  
  145. OS  
  146. Device  
  147.  
  148. #### Load poller module sensors ####
  149. SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[240][0m 0.54ms]
  150.  
  151. SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["current",240][0m 0.47ms]
  152.  
  153. SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.21239.5.2.3.2.1.8.1' '.1.3.6.1.4.1.21239.5.2.3.2.1.8.2' '.1.3.6.1.4.1.21239.5.2.3.2.1.8.3' '.1.3.6.1.4.1.21239.5.2.3.3.1.4.4' '.1.3.6.1.4.1.21239.5.2.3.3.1.4.5' '.1.3.6.1.4.1.21239.5.2.3.3.1.4.6'[0m]
  154. .*.4.1.21*.* = 732
  155. .*.4.1.21*.* = 730
  156. .*.4.1.21*.* = 727
  157. .*.4.1.21*.* = 257
  158. .*.4.1.21*.* = 254
  159. .*.4.1.21*.* = 252  
  160.  
  161. Checking (snmp) current Phase AB...
  162. Checking (snmp) current Phase BC...
  163. Checking (snmp) current Phase CA...
  164. Checking (snmp) current Circuit 4 - Phase AB...
  165. Checking (snmp) current Circuit 5 - Phase BC...
  166. Checking (snmp) current Circuit 6 - Phase CA...
  167. 7.32 A
  168. SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[7.3200000000000003,7.2599999999999998,"current",11302][0m 1.2ms]
  169.  
  170. 7.3 A
  171. SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[7.2999999999999998,7.2400000000000002,"current",11303][0m 0.78ms]
  172.  
  173. 7.27 A
  174. SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[7.2699999999999996,7.2300000000000004,"current",11304][0m 0.79ms]
  175.  
  176. 2.57 A
  177. SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[2.5699999999999998,2.5800000000000001,"current",11305][0m 0.88ms]
  178.  
  179. 2.54 A
  180. SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[2.54,2.5600000000000001,"current",11306][0m 0.75ms]
  181.  
  182. 2.52 A
  183. SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[2.52,2.5800000000000001,"current",11307][0m 0.8ms]
  184.  
  185. SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? [0;33m["voltage",240][0m 0.54ms]
  186.  
  187. SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OUQnte' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.21239.5.2.3.2.1.4.1' '.1.3.6.1.4.1.21239.5.2.3.2.1.4.2' '.1.3.6.1.4.1.21239.5.2.3.2.1.4.3'[0m]
  188. .*.4.1.21*.* = 2068
  189. .*.4.1.21*.* = 2078
  190. .*.4.1.21*.* = 2062  
  191.  
  192. Checking (snmp) voltage Phase AB...
  193. Checking (snmp) voltage Phase BC...
  194. Checking (snmp) voltage Phase CA...
  195. 20.68 V
  196. 20.78 V
  197. 20.62 V
  198. SQL[[1;33mUPDATE `sensors` set `sensor_current`=?,`sensor_prev`=?,`lastupdate`=NOW() WHERE `sensor_class` = ? AND `sensor_id` = ? [0;33m[20.620000000000001,20.629999999999999,"voltage",11310][0m 1.2ms]
  199.  
  200.  
  201. >> Runtime for poller module 'sensors': 0.1409 seconds with 14488 bytes
  202. >> SNMP: [2/0.13s] MySQL: [10/0.01s]
  203. #### Unload poller module sensors ####
  204.  
  205. Modules status: Global+  
  206. OS  
  207. Device  
  208.  
  209. #### Load poller module processors ####
  210. Attempting to initialize OS: vertiv-pdu  
  211. Attempting to initialize OS: vertiv  
  212. OS initialized as Generic  
  213. SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[240][0m 0.51ms]
  214.  
  215.  
  216. >> Runtime for poller module 'processors': 0.0023 seconds with 125880 bytes
  217. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  218. #### Unload poller module processors ####
  219.  
  220. Modules status: Global+  
  221. OS  
  222. Device  
  223.  
  224. #### Load poller module mempools ####
  225. SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[240][0m 0.41ms]
  226.  
  227.  
  228. >> Runtime for poller module 'mempools': 0.0017 seconds with 75592 bytes
  229. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
  230. #### Unload poller module mempools ####
  231.  
  232. Modules status: Global+  
  233. OS  
  234. Device  
  235.  
  236. #### Load poller module storage ####
  237. SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[240][0m 0.35ms]
  238.  
  239.  
  240. >> Runtime for poller module 'storage': 0.0006 seconds with 2032 bytes
  241. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  242. #### Unload poller module storage ####
  243.  
  244. Modules status: Global+  
  245. OS  
  246. Device  
  247.  
  248. #### Load poller module netstats ####
  249.  ICMPSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'icmp'[0m]
  250. icmp = No Such Object available on this agent at this OID  
  251.  
  252. Invalid snmp_walk() data = icmp = No Such Object available on this agent at this OID  
  253.  IPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'ipForwDatagrams' 'ipInDelivers' 'ipInReceives' 'ipOutRequests' 'ipInDiscards' 'ipOutDiscards' 'ipOutNoRoutes' 'ipReasmReqds' 'ipReasmOKs' 'ipReasmFails' 'ipFragOKs' 'ipFragFails' 'ipFragCreates' 'ipInUnknownProtos' 'ipInHdrErrors' 'ipInAddrErrors'[0m]
  254. ifTableLastChange.0 = 0:0:00:00.00
  255. ifTableLastChange.0 = 0:0:00:00.00
  256. ifTableLastChange.0 = 0:0:00:00.00
  257. ifTableLastChange.0 = 0:0:00:00.00
  258. ifTableLastChange.0 = 0:0:00:00.00
  259. ifTableLastChange.0 = 0:0:00:00.00
  260. ifTableLastChange.0 = 0:0:00:00.00
  261. ifTableLastChange.0 = 0:0:00:00.00
  262. ifTableLastChange.0 = 0:0:00:00.00
  263. ifTableLastChange.0 = 0:0:00:00.00
  264. ifTableLastChange.0 = 0:0:00:00.00
  265. ifTableLastChange.0 = 0:0:00:00.00
  266. ifTableLastChange.0 = 0:0:00:00.00
  267. ifTableLastChange.0 = 0:0:00:00.00
  268. ifTableLastChange.0 = 0:0:00:00.00
  269. ifTableLastChange.0 = 0:0:00:00.00  
  270.  
  271.  IP-FORWARDSNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQv' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m]
  272. No Such Object available on this agent at this OID  
  273.  
  274.  SNMPSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'snmp'[0m]
  275. snmp = No Such Object available on this agent at this OID  
  276.  
  277. Invalid snmp_walk() data = snmp = No Such Object available on this agent at this OID  
  278.  TCPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'tcpActiveOpens' 'tcpPassiveOpens' 'tcpAttemptFails' 'tcpEstabResets' 'tcpCurrEstab' 'tcpInSegs' 'tcpOutSegs' 'tcpRetransSegs' 'tcpInErrs' 'tcpOutRsts'[0m]
  279. mib-*.0 = 0:0:00:00.00
  280. mib-*.0 = 0:0:00:00.00
  281. mib-*.0 = 0:0:00:00.00
  282. mib-*.0 = 0:0:00:00.00
  283. mib-*.0 = 0:0:00:00.00
  284. mib-*.0 = 0:0:00:00.00
  285. mib-*.0 = 0:0:00:00.00
  286. mib-*.0 = 0:0:00:00.00
  287. mib-*.0 = 0:0:00:00.00
  288. mib-*.0 = 0:0:00:00.00  
  289.  
  290.  TCPHCSNMP[[0;36m'/usr/bin/snmpgetnext' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'tcpHCInSegs.0' 'tcpHCOutSegs.0'[0m]
  291. mib-*.0 = 0:0:00:00.00
  292. mib-*.0 = 0:0:00:00.00  
  293.  
  294.  UDPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'UDP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'udpInDatagrams' 'udpOutDatagrams' 'udpInErrors' 'udpNoPorts'[0m]
  295. mib-*.0 = 0:0:00:00.00
  296. mib-*.0 = 0:0:00:00.00
  297. mib-*.0 = 0:0:00:00.00
  298. mib-*.0 = 0:0:00:00.00  
  299.  
  300.  
  301.  
  302. >> Runtime for poller module 'netstats': 0.3800 seconds with 3856 bytes
  303. >> SNMP: [7/0.38s] MySQL: [0/0.00s]
  304. #### Unload poller module netstats ####
  305.  
  306. Modules status: Global+  
  307. OS  
  308. Device  
  309.  
  310. #### Load poller module hr-mib ####
  311. SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m]
  312. hrSystemProcesses.0 = No Such Object available on this agent at this OID
  313. hrSystemNumUsers.0 = No Such Object available on this agent at this OID  
  314.  
  315.  
  316.  
  317. >> Runtime for poller module 'hr-mib': 0.0708 seconds with 1640 bytes
  318. >> SNMP: [1/0.07s] MySQL: [0/0.00s]
  319. #### Unload poller module hr-mib ####
  320.  
  321. Modules status: Global+  
  322. OS  
  323. Device  
  324.  
  325. #### Load poller module ucd-mib ####
  326. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'systemStats'[0m]
  327. systemStats = No Such Object available on this agent at this OID  
  328.  
  329. Invalid snmp_walk() data = systemStats = No Such Object available on this agent at this OID  
  330. SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m]
  331. laLoadInt.1 = No Such Object available on this agent at this OID
  332. laLoadInt.2 = No Such Object available on this agent at this OID
  333. laLoadInt.3 = No Such Object available on this agent at this OID  
  334.  
  335.  
  336. >> Runtime for poller module 'ucd-mib': 0.1110 seconds with 1936 bytes
  337. >> SNMP: [2/0.11s] MySQL: [0/0.00s]
  338. #### Unload poller module ucd-mib ####
  339.  
  340. Modules status: Global+  
  341. OS  
  342. Device  
  343.  
  344. #### Load poller module ipSystemStats ####
  345. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'ipSystemStats'[0m]
  346. ipSystemStatsTable = No Such Object available on this agent at this OID  
  347.  
  348. Invalid snmp_walk() data = ipSystemStatsTable = No Such Object available on this agent at this OID  
  349.  
  350.  
  351. >> Runtime for poller module 'ipSystemStats': 0.0882 seconds with 1976 bytes
  352. >> SNMP: [1/0.09s] MySQL: [0/0.00s]
  353. #### Unload poller module ipSystemStats ####
  354.  
  355. Modules status: Global+  
  356. OS  
  357. Device  
  358.  
  359. #### Load poller module ports ####
  360. SQL[[1;33mSELECT *, `ports_statistics`.`port_id` AS `ports_statistics_port_id`, `ports`.`port_id` AS `port_id` FROM `ports` LEFT OUTER JOIN `ports_statistics` ON `ports`.`port_id` = `ports_statistics`.`port_id` WHERE `ports`.`device_id` = ? ORDER BY ports.port_id [0;33m[240][0m 1.14ms]
  361.  
  362. Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'ifXEntry'[0m]
  363. ifXEntry = No Such Object available on this agent at this OID  
  364.  
  365. Invalid snmp_walk() data = ifXEntry = No Such Object available on this agent at this OID  
  366. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'ifEntry'[0m]
  367. ifIndex.1 = 1
  368. ifIndex.2 = 2
  369. ifIndex.3 = 3
  370. ifIndex.4 = 4
  371. ifIndex.12 = 12
  372. ifDescr.1 = lo
  373. ifDescr.2 = eth0
  374. ifDescr.3 = port1
  375. ifDescr.4 = port2
  376. ifDescr.12 = br0
  377. ifType.1 = softwareLoopback
  378. ifType.2 = ethernetCsmacd
  379. ifType.3 = ethernetCsmacd
  380. ifType.4 = ethernetCsmacd
  381. ifType.12 = ethernetCsmacd
  382. ifMtu.1 = 65536
  383. ifMtu.2 = 1500
  384. ifMtu.3 = 1500
  385. ifMtu.4 = 1500
  386. ifMtu.12 = 1500
  387. ifSpeed.1 = 10000000
  388. ifSpeed.2 = 100000000
  389. ifSpeed.3 = 100000000
  390. ifSpeed.4 = 10000000
  391. ifSpeed.12 = 0
  392. ifPhysAddress.1 =
  393. ifPhysAddress.2 = 0:19:85:a:dd:9d
  394. ifPhysAddress.3 = 0:19:85:a:dd:9d
  395. ifPhysAddress.4 = 0:19:85:a:dd:9d
  396. ifPhysAddress.12 = 0:19:85:a:dd:9d
  397. ifAdminStatus.1 = up
  398. ifAdminStatus.2 = up
  399. ifAdminStatus.3 = up
  400. ifAdminStatus.4 = up
  401. ifAdminStatus.12 = up
  402. ifOperStatus.1 = up
  403. ifOperStatus.2 = up
  404. ifOperStatus.3 = up
  405. ifOperStatus.4 = down
  406. ifOperStatus.12 = up
  407. ifLastChange.1 = 0
  408. ifLastChange.2 = 0
  409. ifLastChange.3 = 0
  410. ifLastChange.4 = 0
  411. ifLastChange.12 = 0
  412. ifInOctets.1 = 4229453885
  413. ifInOctets.2 = 1896870382
  414. ifInOctets.3 = 1713656182
  415. ifInOctets.4 = 0
  416. ifInOctets.12 = 1473122135
  417. ifInUcastPkts.1 = 632194334
  418. ifInUcastPkts.2 = 45803550
  419. ifInUcastPkts.3 = 45803550
  420. ifInUcastPkts.4 = 0
  421. ifInUcastPkts.12 = 17197608
  422. ifInNUcastPkts.1 = 0
  423. ifInNUcastPkts.2 = 0
  424. ifInNUcastPkts.3 = 0
  425. ifInNUcastPkts.4 = 0
  426. ifInNUcastPkts.12 = 0
  427. ifInDiscards.1 = 0
  428. ifInDiscards.2 = 0
  429. ifInDiscards.3 = 183727
  430. ifInDiscards.4 = 0
  431. ifInDiscards.12 = 7841
  432. ifInErrors.1 = 0
  433. ifInErrors.2 = 481
  434. ifInErrors.3 = 0
  435. ifInErrors.4 = 0
  436. ifInErrors.12 = 0
  437. ifInUnknownProtos.1 = 0
  438. ifInUnknownProtos.2 = 0
  439. ifInUnknownProtos.3 = 0
  440. ifInUnknownProtos.4 = 0
  441. ifInUnknownProtos.12 = 0
  442. ifOutOctets.1 = 4229453885
  443. ifOutOctets.2 = 1157762642
  444. ifOutOctets.3 = 1135564786
  445. ifOutOctets.4 = 0
  446. ifOutOctets.12 = 1130639924
  447. ifOutUcastPkts.1 = 632194334
  448. ifOutUcastPkts.2 = 5470417
  449. ifOutUcastPkts.3 = 5465635
  450. ifOutUcastPkts.4 = 0
  451. ifOutUcastPkts.12 = 5456916
  452. ifOutNUcastPkts.1 = 0
  453. ifOutNUcastPkts.2 = 0
  454. ifOutNUcastPkts.3 = 0
  455. ifOutNUcastPkts.4 = 0
  456. ifOutNUcastPkts.12 = 0
  457. ifOutDiscards.1 = 0
  458. ifOutDiscards.2 = 0
  459. ifOutDiscards.3 = 0
  460. ifOutDiscards.4 = 0
  461. ifOutDiscards.12 = 0
  462. ifOutErrors.1 = 0
  463. ifOutErrors.2 = 0
  464. ifOutErrors.3 = 0
  465. ifOutErrors.4 = 0
  466. ifOutErrors.12 = 0
  467. ifOutQLen.1 = 0
  468. ifOutQLen.2 = 0
  469. ifOutQLen.3 = 0
  470. ifOutQLen.4 = 0
  471. ifOutQLen.12 = 0
  472. ifSpecific.1 = zeroDotZero
  473. ifSpecific.2 = zeroDotZero
  474. ifSpecific.3 = zeroDotZero
  475. ifSpecific.4 = zeroDotZero
  476. ifSpecific.12 = zeroDotZero  
  477.  
  478. dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m]
  479. dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
  480.  
  481. Invalid snmp_walk() data = dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
  482. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'dot1qPvid'[0m]
  483. dot1qPvid = No Such Object available on this agent at this OID  
  484.  
  485. Invalid snmp_walk() data = dot1qPvid = No Such Object available on this agent at this OID  
  486. SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl') [0;33m[240][0m 0.66ms]
  487.  
  488. array (
  489.   1 =>
  490.   array (
  491.     'ifIndex' => '1',
  492.     'ifDescr' => 'lo',
  493.     'ifType' => 'softwareLoopback',
  494.     'ifMtu' => '65536',
  495.     'ifSpeed' => '10000000',
  496.     'ifPhysAddress' => '',
  497.     'ifAdminStatus' => 'up',
  498.     'ifOperStatus' => 'up',
  499.     'ifLastChange' => '0',
  500.     'ifInOctets' => '4229453885',
  501.     'ifInUcastPkts' => '632194334',
  502.     'ifInNUcastPkts' => '0',
  503.     'ifInDiscards' => '0',
  504.     'ifInErrors' => '0',
  505.     'ifInUnknownProtos' => '0',
  506.     'ifOutOctets' => '4229453885',
  507.     'ifOutUcastPkts' => '632194334',
  508.     'ifOutNUcastPkts' => '0',
  509.     'ifOutDiscards' => '0',
  510.     'ifOutErrors' => '0',
  511.     'ifOutQLen' => '0',
  512.     'ifSpecific' => 'zeroDotZero',
  513.   ),
  514.   2 =>
  515.   array (
  516.     'ifIndex' => '2',
  517.     'ifDescr' => 'eth0',
  518.     'ifType' => 'ethernetCsmacd',
  519.     'ifMtu' => '1500',
  520.     'ifSpeed' => '100000000',
  521.     'ifPhysAddress' => '0:19:85:a:dd:9d',
  522.     'ifAdminStatus' => 'up',
  523.     'ifOperStatus' => 'up',
  524.     'ifLastChange' => '0',
  525.     'ifInOctets' => '1896870382',
  526.     'ifInUcastPkts' => '45803550',
  527.     'ifInNUcastPkts' => '0',
  528.     'ifInDiscards' => '0',
  529.     'ifInErrors' => '481',
  530.     'ifInUnknownProtos' => '0',
  531.     'ifOutOctets' => '1157762642',
  532.     'ifOutUcastPkts' => '5470417',
  533.     'ifOutNUcastPkts' => '0',
  534.     'ifOutDiscards' => '0',
  535.     'ifOutErrors' => '0',
  536.     'ifOutQLen' => '0',
  537.     'ifSpecific' => 'zeroDotZero',
  538.   ),
  539.   3 =>
  540.   array (
  541.     'ifIndex' => '3',
  542.     'ifDescr' => 'port1',
  543.     'ifType' => 'ethernetCsmacd',
  544.     'ifMtu' => '1500',
  545.     'ifSpeed' => '100000000',
  546.     'ifPhysAddress' => '0:19:85:a:dd:9d',
  547.     'ifAdminStatus' => 'up',
  548.     'ifOperStatus' => 'up',
  549.     'ifLastChange' => '0',
  550.     'ifInOctets' => '1713656182',
  551.     'ifInUcastPkts' => '45803550',
  552.     'ifInNUcastPkts' => '0',
  553.     'ifInDiscards' => '183727',
  554.     'ifInErrors' => '0',
  555.     'ifInUnknownProtos' => '0',
  556.     'ifOutOctets' => '1135564786',
  557.     'ifOutUcastPkts' => '5465635',
  558.     'ifOutNUcastPkts' => '0',
  559.     'ifOutDiscards' => '0',
  560.     'ifOutErrors' => '0',
  561.     'ifOutQLen' => '0',
  562.     'ifSpecific' => 'zeroDotZero',
  563.   ),
  564.   4 =>
  565.   array (
  566.     'ifIndex' => '4',
  567.     'ifDescr' => 'port2',
  568.     'ifType' => 'ethernetCsmacd',
  569.     'ifMtu' => '1500',
  570.     'ifSpeed' => '10000000',
  571.     'ifPhysAddress' => '0:19:85:a:dd:9d',
  572.     'ifAdminStatus' => 'up',
  573.     'ifOperStatus' => 'down',
  574.     'ifLastChange' => '0',
  575.     'ifInOctets' => '0',
  576.     'ifInUcastPkts' => '0',
  577.     'ifInNUcastPkts' => '0',
  578.     'ifInDiscards' => '0',
  579.     'ifInErrors' => '0',
  580.     'ifInUnknownProtos' => '0',
  581.     'ifOutOctets' => '0',
  582.     'ifOutUcastPkts' => '0',
  583.     'ifOutNUcastPkts' => '0',
  584.     'ifOutDiscards' => '0',
  585.     'ifOutErrors' => '0',
  586.     'ifOutQLen' => '0',
  587.     'ifSpecific' => 'zeroDotZero',
  588.   ),
  589.   12 =>
  590.   array (
  591.     'ifIndex' => '12',
  592.     'ifDescr' => 'br0',
  593.     'ifType' => 'ethernetCsmacd',
  594.     'ifMtu' => '1500',
  595.     'ifSpeed' => '0',
  596.     'ifPhysAddress' => '0:19:85:a:dd:9d',
  597.     'ifAdminStatus' => 'up',
  598.     'ifOperStatus' => 'up',
  599.     'ifLastChange' => '0',
  600.     'ifInOctets' => '1473122135',
  601.     'ifInUcastPkts' => '17197608',
  602.     'ifInNUcastPkts' => '0',
  603.     'ifInDiscards' => '7841',
  604.     'ifInErrors' => '0',
  605.     'ifInUnknownProtos' => '0',
  606.     'ifOutOctets' => '1130639924',
  607.     'ifOutUcastPkts' => '5456916',
  608.     'ifOutNUcastPkts' => '0',
  609.     'ifOutDiscards' => '0',
  610.     'ifOutErrors' => '0',
  611.     'ifOutQLen' => '0',
  612.     'ifSpecific' => 'zeroDotZero',
  613.   ),
  614. )  
  615.  valid  
  616.  valid  
  617.  valid  
  618.  valid  
  619.  valid  
  620.  
  621. Port lo: lo (1 / #12274) ifInOctets  
  622. ifOutOctets  
  623. ifInUcastPkts  
  624. ifOutUcastPkts  
  625. ifInBroadcastPkts  
  626. ifOutBroadcastPkts  
  627. ifInMulticastPkts  
  628. ifOutMulticastPkts  
  629. ifSpeed  
  630. VLAN =   Using ifDescr as ifAlias  
  631.  Using ifDescr as ifName  
  632. lo
  633.  ifInOctets (371537 B) 6405.8103448276 Bps 58 secs  
  634.  
  635.  ifOutOctets (371537 B) 6405.8103448276 Bps 58 secs  
  636.  
  637.  ifInErrors (0 B) 0 Bps 58 secs  
  638.  
  639.  ifOutErrors (0 B) 0 Bps 58 secs  
  640.  
  641.  ifInUcastPkts (1610 B) 27.758620689655 Bps 58 secs  
  642.  
  643.  ifOutUcastPkts (1610 B) 27.758620689655 Bps 58 secs  
  644.  
  645.  ifInNUcastPkts (0 B) 0 Bps 58 secs  
  646.  
  647.  ifOutNUcastPkts (0 B) 0 Bps 58 secs  
  648.  
  649.  ifInDiscards (0 B) 0 Bps 58 secs  
  650.  
  651.  ifOutDiscards (0 B) 0 Bps 58 secs  
  652.  
  653.  ifInUnknownProtos (0 B) 0 Bps 58 secs  
  654.  
  655.  ifInBroadcastPkts (0 B) 0 Bps 58 secs  
  656.  
  657.  ifOutBroadcastPkts (0 B) 0 Bps 58 secs  
  658.  
  659.  ifInMulticastPkts (0 B) 0 Bps 58 secs  
  660.  
  661.  ifOutMulticastPkts (0 B) 0 Bps 58 secs  
  662. bps(51.25 Kbps/51.25 Kbps)bytes(362.83 KiB/362.83 KiB)pkts(27.76 pps/27.76 pps)SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["4229453885",4229082348,6405.8103448275861,371537,"4229453885",4229082348,6405.8103448275861,371537,"0",0,0,0,"0",0,0,0,"632194334",632192724,27.758620689655171,1610,"632194334",632192724,27.758620689655171,1610,1621427313,1621427255,58,12274][0m 1.15ms]
  663.  
  664. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m["0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,12274][0m 0.6ms]
  665.  
  666. 1 updated  
  667.  
  668. Port eth0: eth0 (2 / #12275) ifInOctets  
  669. ifOutOctets  
  670. ifInUcastPkts  
  671. ifOutUcastPkts  
  672. ifInBroadcastPkts  
  673. ifOutBroadcastPkts  
  674. ifInMulticastPkts  
  675. ifOutMulticastPkts  
  676. ifSpeed  
  677. VLAN =   Using ifDescr as ifAlias  
  678.  Using ifDescr as ifName  
  679. eth0
  680.  ifInOctets (38392 B) 661.93103448276 Bps 58 secs  
  681.  
  682.  ifOutOctets (69725 B) 1202.1551724138 Bps 58 secs  
  683.  
  684.  ifInErrors (0 B) 0 Bps 58 secs  
  685.  
  686.  ifOutErrors (0 B) 0 Bps 58 secs  
  687.  
  688.  ifInUcastPkts (348 B) 6 Bps 58 secs  
  689.  
  690.  ifOutUcastPkts (171 B) 2.948275862069 Bps 58 secs  
  691.  
  692.  ifInNUcastPkts (0 B) 0 Bps 58 secs  
  693.  
  694.  ifOutNUcastPkts (0 B) 0 Bps 58 secs  
  695.  
  696.  ifInDiscards (0 B) 0 Bps 58 secs  
  697.  
  698.  ifOutDiscards (0 B) 0 Bps 58 secs  
  699.  
  700.  ifInUnknownProtos (0 B) 0 Bps 58 secs  
  701.  
  702.  ifInBroadcastPkts (0 B) 0 Bps 58 secs  
  703.  
  704.  ifOutBroadcastPkts (0 B) 0 Bps 58 secs  
  705.  
  706.  ifInMulticastPkts (0 B) 0 Bps 58 secs  
  707.  
  708.  ifOutMulticastPkts (0 B) 0 Bps 58 secs  
  709. bps(5.3 Kbps/9.62 Kbps)bytes(37.49 KiB/68.09 KiB)pkts(6 pps/2.95 pps)SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["1896870382",1896831990,661.93103448275861,38392,"1157762642",1157692917,1202.155172413793,69725,"481",481,0,0,"0",0,0,0,"45803550",45803202,6,348,"5470417",5470246,2.9482758620689653,171,1621427313,1621427255,58,12275][0m 0.78ms]
  710.  
  711. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m["0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,12275][0m 0.34ms]
  712.  
  713. 1 updated  
  714.  
  715. Port port1: port1 (3 / #12276) ifInOctets  
  716. ifOutOctets  
  717. ifInUcastPkts  
  718. ifOutUcastPkts  
  719. ifInBroadcastPkts  
  720. ifOutBroadcastPkts  
  721. ifInMulticastPkts  
  722. ifOutMulticastPkts  
  723. ifSpeed  
  724. VLAN =   Using ifDescr as ifAlias  
  725.  Using ifDescr as ifName  
  726. port1
  727.  ifInOctets (37000 B) 637.93103448276 Bps 58 secs  
  728.  
  729.  ifOutOctets (69041 B) 1190.3620689655 Bps 58 secs  
  730.  
  731.  ifInErrors (0 B) 0 Bps 58 secs  
  732.  
  733.  ifOutErrors (0 B) 0 Bps 58 secs  
  734.  
  735.  ifInUcastPkts (348 B) 6 Bps 58 secs  
  736.  
  737.  ifOutUcastPkts (171 B) 2.948275862069 Bps 58 secs  
  738.  
  739.  ifInNUcastPkts (0 B) 0 Bps 58 secs  
  740.  
  741.  ifOutNUcastPkts (0 B) 0 Bps 58 secs  
  742.  
  743.  ifInDiscards (2 B) 0.03448275862069 Bps 58 secs  
  744.  
  745.  ifOutDiscards (0 B) 0 Bps 58 secs  
  746.  
  747.  ifInUnknownProtos (0 B) 0 Bps 58 secs  
  748.  
  749.  ifInBroadcastPkts (0 B) 0 Bps 58 secs  
  750.  
  751.  ifOutBroadcastPkts (0 B) 0 Bps 58 secs  
  752.  
  753.  ifInMulticastPkts (0 B) 0 Bps 58 secs  
  754.  
  755.  ifOutMulticastPkts (0 B) 0 Bps 58 secs  
  756. bps(5.1 Kbps/9.52 Kbps)bytes(36.13 KiB/67.42 KiB)pkts(6 pps/2.95 pps)SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["1713656182",1713619182,637.93103448275861,37000,"1135564786",1135495745,1190.3620689655172,69041,"0",0,0,0,"0",0,0,0,"45803550",45803202,6,348,"5465635",5465464,2.9482758620689653,171,1621427313,1621427255,58,12276][0m 0.87ms]
  757.  
  758. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m["0",0,0,0,"0",0,0,0,"183727",183725,0.034482758620689655,2,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,12276][0m 0.78ms]
  759.  
  760. 2 updated  
  761.  
  762. Port port2: port2 (4 / #12277) ifInOctets  
  763. ifOutOctets  
  764. ifInUcastPkts  
  765. ifOutUcastPkts  
  766. ifInBroadcastPkts  
  767. ifOutBroadcastPkts  
  768. ifInMulticastPkts  
  769. ifOutMulticastPkts  
  770. ifSpeed  
  771. VLAN =   Using ifDescr as ifAlias  
  772.  Using ifDescr as ifName  
  773. port212277 skipped because port is still down since last polling.  
  774.  
  775. Port br0: br0 (12 / #12278) ifInOctets  
  776. ifOutOctets  
  777. ifInUcastPkts  
  778. ifOutUcastPkts  
  779. ifInBroadcastPkts  
  780. ifOutBroadcastPkts  
  781. ifInMulticastPkts  
  782. ifOutMulticastPkts  
  783. ifSpeed  
  784. VLAN =   Using ifDescr as ifAlias  
  785.  Using ifDescr as ifName  
  786. br0
  787.  ifInOctets (31202 B) 537.96551724138 Bps 58 secs  
  788.  
  789.  ifOutOctets (69041 B) 1190.3620689655 Bps 58 secs  
  790.  
  791.  ifInErrors (0 B) 0 Bps 58 secs  
  792.  
  793.  ifOutErrors (0 B) 0 Bps 58 secs  
  794.  
  795.  ifInUcastPkts (296 B) 5.1034482758621 Bps 58 secs  
  796.  
  797.  ifOutUcastPkts (171 B) 2.948275862069 Bps 58 secs  
  798.  
  799.  ifInNUcastPkts (0 B) 0 Bps 58 secs  
  800.  
  801.  ifOutNUcastPkts (0 B) 0 Bps 58 secs  
  802.  
  803.  ifInDiscards (0 B) 0 Bps 58 secs  
  804.  
  805.  ifOutDiscards (0 B) 0 Bps 58 secs  
  806.  
  807.  ifInUnknownProtos (0 B) 0 Bps 58 secs  
  808.  
  809.  ifInBroadcastPkts (0 B) 0 Bps 58 secs  
  810.  
  811.  ifOutBroadcastPkts (0 B) 0 Bps 58 secs  
  812.  
  813.  ifInMulticastPkts (0 B) 0 Bps 58 secs  
  814.  
  815.  ifOutMulticastPkts (0 B) 0 Bps 58 secs  
  816. bps(4.3 Kbps/9.52 Kbps)bytes(30.47 KiB/67.42 KiB)pkts(5.1 pps/2.95 pps)SQL[[1;33mUPDATE `ports` set `ifSpeed_prev`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["0","1473122135",1473090933,537.9655172413793,31202,"1130639924",1130570883,1190.3620689655172,69041,"0",0,0,0,"0",0,0,0,"17197608",17197312,5.1034482758620694,296,"5456916",5456745,2.9482758620689653,171,1621427313,1621427255,58,12278][0m 0.77ms]
  817.  
  818. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m["0",0,0,0,"0",0,0,0,"7841",7841,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,12278][0m 0.35ms]
  819.  
  820. 1 updated  
  821.  
  822. SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where `port_id` in (?) [0;33m[1621427313,1621427255,null,12277][0m 0.81ms]
  823.  
  824. 1 updated  
  825.  
  826. >> Runtime for poller module 'ports': 0.3557 seconds with 47800 bytes
  827. >> SNMP: [4/0.33s] MySQL: [9/0.01s]
  828. #### Unload poller module ports ####
  829.  
  830. Modules status: Global+  
  831. OS  
  832. Device  
  833.  
  834. #### Load poller module customoid ####
  835. SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[240][0m 0.44ms]
  836.  
  837.  
  838. >> Runtime for poller module 'customoid': 0.0008 seconds with 2400 bytes
  839. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  840. #### Unload poller module customoid ####
  841.  
  842. Modules status: Global+  
  843. OS  
  844. Device  
  845.  
  846. #### Load poller module bgp-peers ####
  847. SQL[[1;33mSELECT * FROM `bgpPeers` AS B LEFT JOIN `vrfs` AS V ON `B`.`vrf_id` = `V`.`vrf_id` WHERE `B`.`device_id` = ? [0;33m[240][0m 0.47ms]
  848.  
  849.  
  850. >> Runtime for poller module 'bgp-peers': 0.0021 seconds with 15320 bytes
  851. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  852. #### Unload poller module bgp-peers ####
  853.  
  854. Modules status: Global-  
  855. OS  
  856. Device  
  857. Module [ junose-atm-vp ] disabled globally.
  858.  
  859. Modules status: Global-  
  860. OS  
  861. Device  
  862. Module [ printer-supplies ] disabled globally.
  863.  
  864. Modules status: Global+  
  865. OS  
  866. Device  
  867.  
  868. #### Load poller module ucd-diskio ####
  869. SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id`  = ? [0;33m[240][0m 0.42ms]
  870.  
  871.  
  872. >> Runtime for poller module 'ucd-diskio': 0.0008 seconds with 1944 bytes
  873. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  874. #### Unload poller module ucd-diskio ####
  875.  
  876. Modules status: Global-  
  877. OS  
  878. Device  
  879. Module [ wifi ] disabled globally.
  880.  
  881. Modules status: Global+  
  882. OS  
  883. Device  
  884.  
  885. #### Load poller module wireless ####
  886. Attempting to initialize OS: vertiv-pdu  
  887. Attempting to initialize OS: vertiv  
  888. OS initialized as Generic  
  889. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[240][0m 0.39ms]
  890.  
  891.  
  892. >> Runtime for poller module 'wireless': 0.0018 seconds with 104168 bytes
  893. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  894. #### Unload poller module wireless ####
  895.  
  896. Modules status: Global+  
  897. OS  
  898. Device  
  899.  
  900. #### Load poller module ospf ####
  901.  Processes: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'OSPF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfGeneralGroup'[0m]
  902. ospfGeneralGroup = No Such Object available on this agent at this OID  
  903.  
  904. Invalid snmp_walk() data = ospfGeneralGroup = No Such Object available on this agent at this OID  
  905. array (
  906. )  
  907. SQL[[1;33mdelete from `ospf_instances` where (`device_id` = ? and `context_name` is null) and 1 = 1 [0;33m[240][0m 0.47ms]
  908.  
  909. 0
  910. >> Runtime for poller module 'ospf': 0.0656 seconds with 31392 bytes
  911. >> SNMP: [1/0.06s] MySQL: [0/0.00s]
  912. #### Unload poller module ospf ####
  913.  
  914. Modules status: Global-  
  915. OS  
  916. Device  
  917. Module [ cisco-ipsec-flow-monitor ] disabled globally.
  918.  
  919. Modules status: Global-  
  920. OS  
  921. Device  
  922. Module [ cisco-remote-access-monitor ] disabled globally.
  923.  
  924. Modules status: Global-  
  925. OS  
  926. Device  
  927. Module [ cisco-cef ] disabled globally.
  928.  
  929. Modules status: Global-  
  930. OS  
  931. Device  
  932. Module [ cisco-sla ] disabled globally.
  933.  
  934. Modules status: Global-  
  935. OS  
  936. Device  
  937. Module [ cisco-mac-accounting ] disabled globally.
  938.  
  939. Modules status: Global-  
  940. OS  
  941. Device  
  942. Module [ cipsec-tunnels ] disabled globally.
  943.  
  944. Modules status: Global-  
  945. OS  
  946. Device  
  947. Module [ cisco-ace-loadbalancer ] disabled globally.
  948.  
  949. Modules status: Global-  
  950. OS  
  951. Device  
  952. Module [ cisco-ace-serverfarms ] disabled globally.
  953.  
  954. Modules status: Global-  
  955. OS  
  956. Device  
  957. Module [ cisco-asa-firewall ] disabled globally.
  958.  
  959. Modules status: Global-  
  960. OS  
  961. Device  
  962. Module [ cisco-voice ] disabled globally.
  963.  
  964. Modules status: Global-  
  965. OS  
  966. Device  
  967. Module [ cisco-cbqos ] disabled globally.
  968.  
  969. Modules status: Global-  
  970. OS  
  971. Device  
  972. Module [ cisco-otv ] disabled globally.
  973.  
  974. Modules status: Global-  
  975. OS  
  976. Device  
  977. Module [ cisco-qfp ] disabled globally.
  978.  
  979. Modules status: Global-  
  980. OS  
  981. Device  
  982. Module [ cisco-vpdn ] disabled globally.
  983.  
  984. Modules status: Global-  
  985. OS  
  986. Device  
  987. Module [ nac ] disabled globally.
  988.  
  989. Modules status: Global-  
  990. OS  
  991. Device  
  992. Module [ netscaler-vsvr ] disabled globally.
  993.  
  994. Modules status: Global-  
  995. OS  
  996. Device  
  997. Module [ aruba-controller ] disabled globally.
  998.  
  999. Modules status: Global+  
  1000. OS  
  1001. Device  
  1002.  
  1003. #### Load poller module entity-physical ####
  1004. SQL[[1;33mSELECT * FROM `entPhysical_state` WHERE `device_id` = ? [0;33m[240][0m 0.38ms]
  1005.  
  1006.  
  1007. >> Runtime for poller module 'entity-physical': 0.0008 seconds with 2152 bytes
  1008. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  1009. #### Unload poller module entity-physical ####
  1010.  
  1011. Modules status: Global-  
  1012. OS  
  1013. Device  
  1014. Module [ entity-state ] disabled globally.
  1015.  
  1016. Modules status: Global+  
  1017. OS  
  1018. Device  
  1019.  
  1020. #### Load poller module applications ####
  1021. SQL[[1;33mSELECT * FROM `applications` WHERE `device_id`  = ? [0;33m[240][0m 0.33ms]
  1022.  
  1023.  
  1024. >> Runtime for poller module 'applications': 0.0005 seconds with 1592 bytes
  1025. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  1026. #### Unload poller module applications ####
  1027.  
  1028. Modules status: Global-  
  1029. OS  
  1030. Device  
  1031. Module [ mib ] disabled globally.
  1032.  
  1033. Modules status: Global+  
  1034. OS  
  1035. Device  
  1036.  
  1037. #### Load poller module stp ####
  1038. SQL[[1;33mSELECT * FROM `stp` WHERE `device_id` = ? [0;33m[240][0m 0.34ms]
  1039.  
  1040. SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-Oqv' '-m' 'RSTP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/vertiv' 'udp:HOSTNAME:161' 'dot1dStpProtocolSpecification.0'[0m]
  1041. No Such Object available on this agent at this OID  
  1042.  
  1043.  
  1044.  
  1045. >> Runtime for poller module 'stp': 0.0509 seconds with 5784 bytes
  1046. >> SNMP: [1/0.05s] MySQL: [1/0.00s]
  1047. #### Unload poller module stp ####
  1048.  
  1049. Modules status: Global+  
  1050. OS  
  1051. Device  
  1052.  
  1053. #### Load poller module ntp ####
  1054.  
  1055. >> Runtime for poller module 'ntp': 0.0001 seconds with 400 bytes
  1056. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
  1057. #### Unload poller module ntp ####
  1058.  
  1059. Modules status: Global-  
  1060. OS  
  1061. Device  
  1062. Module [ loadbalancers ] disabled globally.
  1063.  
  1064. Modules status: Global-  
  1065. OS  
  1066. Device  
  1067. Module [ mef ] disabled globally.
  1068.  
  1069. Modules status: Global+  
  1070. OS  
  1071. Device  
  1072.  
  1073. #### Load poller module mpls ####
  1074.  
  1075. >> Runtime for poller module 'mpls': 0.0004 seconds with 24080 bytes
  1076. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
  1077. #### Unload poller module mpls ####
  1078.  
  1079. Enabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[240][0m 0.59ms]
  1080.  
  1081.  
  1082. SQL[[1;33mUPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=?,`last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[2605059,1.1200000000000001,2.516,240][0m 0.84ms]
  1083.  
  1084. Updating [REMOVED]  
  1085.  
  1086. Polled in 2.516 seconds
  1087. ### Start Device Groups ###
  1088. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[240][0m 0.67ms]
  1089.  
  1090. SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.37ms]
  1091.  
  1092. SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[240][0m 0.39ms]
  1093.  
  1094. Groups Added:  
  1095. Groups Removed:  
  1096. ### End Device Groups, runtime: 0.0029s ###
  1097.  
  1098. #### Start Alerts ####
  1099. 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(`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 `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["2021-05-19T12:28:33.568591Z","2021-05-19T12:28:33.568591Z",0,1,"12:28:33","12:28:33","12:28:33","12:28:33","[43m%","device",240,"location",132][0m 1.1ms]
  1100.  
  1101. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[240][0m 0.65ms]
  1102.  
  1103. SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a
  1104.         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 = ?)
  1105.         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 = ?))
  1106.         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 = ?))
  1107.         LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
  1108.         WHERE a.disabled = 0 AND (
  1109.             (d.device_id IS NULL AND g.group_id IS NULL)
  1110.             OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=?))
  1111.             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))
  1112.         ) [0;33m[240,240,240,240,240,240,240,240][0m 2.1ms]
  1113.  
  1114. Rule [0;35m#5 (Device Down! Due to no ICMP response.):[0m  
  1115. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND devices.status_reason = "icmp" AND devices.ignore = 0 AND devices.disabled = 0 [0;33m[240][0m 0.67ms]
  1116.  
  1117. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[5,240][0m 0.41ms]
  1118.  
  1119. Status: [0;34mNOCHG[0m
  1120. #### End Alerts ####
  1121. ./poller.php [REMOVED] 2021-05-19 08:28:33 - 1 devices polled in 2.775 secs  
  1122. SNMP [22/1.42s]: Get[9/0.56s] Getnext[4/0.20s] Walk[9/0.66s]
  1123. MySQL [40/0.03s]: Cell[3/0.00s] Row[-2/-0.00s] Rows[16/0.01s] Column[1/0.00s] Update[21/0.02s] Insert[1/0.00s] Delete[0/0.00s]
  1124.  
captcha