Untitled

From librenms, 2 Years ago, written in Plain Text.
URL https://p.libren.ms/view/3803e4da
Embed
Download Paste or View Raw
  1. LibreNMS Poller
  2. SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.27ms]
  3.  
  4. SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 0.23ms]
  5.  
  6. SQL[[1;33mselect version() [0;33m[][0m 0.28ms]
  7.  
  8. ===================================
  9. Version info:
  10. Commit SHA: 34de9dd77df4bf7bb3f30c89c93cb86620f8b780
  11. Commit Date: 1631578375
  12. DB Schema: 2021_08_26_093522_config_value_to_medium_text (217)
  13. PHP: 7.4.13
  14. MySQL: 10.3.31-MariaDB-0ubuntu0.20.04.1
  15. RRDTool: 1.7.2
  16. SNMP: NET-SNMP 5.8
  17. ==================================DEBUG!
  18. Updating os_def.cache  
  19. Starting polling run:
  20.  
  21. SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '10.180.7.1' ORDER BY `device_id` ASC [0;33m[][0m 0.86ms]
  22.  
  23. SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[61][0m 0.83ms]
  24.  
  25. SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[61][0m 0.29ms]
  26.  
  27. Attempting to initialize OS: sophos-xg  
  28. Attempting to initialize OS: sophos  
  29. OS initialized as Generic  
  30. Hostname:    10.180.7.1
  31. Device ID:   61
  32. OS:          sophos-xg
  33.  (sophos)
  34.  
  35. Created directory : /opt/librenms/rrd/10.180.7.1/
  36. SQL[[1;33mselect `hostname`, `overwrite_ip` from `devices` where `hostname` = ? limit 1 [0;33m["10.180.7.1"][0m 1.12ms]
  37.  
  38. [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '10.180.7.1'
  39.  
  40. response:  {"xmt":3,"rcv":3,"loss":0,"min":68.0,"max":74.1,"avg":70.4,"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[61][0m 0.39ms]
  42.  
  43. SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[3][0m 0.31ms]
  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-09-14T10:24:03.678568Z","2021-09-14T10:24:03.678568Z",0,1,"10:24:03","10:24:03","10:24:03","10:24:03","[42m%","device",61,"location",3][0m 1.07ms]
  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":68,"max":74.1,"avg":70.4,"device_id":61,"debug":"[]"}[0m 34.4ms]
  48.  
  49. SQL[[1;33mUPDATE `devices` set `last_ping`=?,`last_ping_timetaken`=? WHERE device_id=? [0;33m["2021-09-14 15:54:03",70.4,61][0m 99.64ms]
  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' '-v2c' '-c' 'COMMUNITY' '-OQnUt' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'sysUpTime.0' 'sysName.0' 'sysObjectID.0' 'sysDescr.0'[0m]
  58. .*.*.0 = 1565873195
  59. .*.*.0 = RSIL_Gurgoan_HUB
  60. .*.*.0 = .*.4.1.2604.5
  61. .*.*.0 = Linux localhost 4.14.38 #2 SMP Sun Dec 6 01:19:34 UTC 2020 x86_64  
  62.  
  63. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUst' '-m' 'HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'snmpEngineTime.0' 'hrSystemUptime.0'[0m]
  64. snmpEngineTime.0 = 15658732
  65. hrSystemUptime.0 = 1565885856  
  66.  
  67. Uptime seconds: 15658859  
  68. Uptime:  181 days 5 hours 40 minutes 59 seconds
  69.  
  70. >> Runtime for poller module 'core': 0.2067 seconds with 25496 bytes
  71. >> SNMP: [2/0.20s] 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[61][0m 0.48ms]
  80.  
  81. SQL[[1;33mINSERT IGNORE INTO `availability` (`device_id`,`duration`)  VALUES (:device_id,:duration) [0;33m{"device_id":61,"duration":"86400"}[0m 95.05ms]
  82.  
  83. SQL[[1;33mINSERT IGNORE INTO `availability` (`device_id`,`duration`)  VALUES (:device_id,:duration) [0;33m{"device_id":61,"duration":"604800"}[0m 33.17ms]
  84.  
  85. SQL[[1;33mINSERT IGNORE INTO `availability` (`device_id`,`duration`)  VALUES (:device_id,:duration) [0;33m{"device_id":61,"duration":"2592000"}[0m 66.82ms]
  86.  
  87. SQL[[1;33mINSERT IGNORE INTO `availability` (`device_id`,`duration`)  VALUES (:device_id,:duration) [0;33m{"device_id":61,"duration":"31536000"}[0m 32.8ms]
  88.  
  89. Availability:
  90. SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[61][0m 0.38ms]
  91.  
  92. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[61,1631528644][0m 0.45ms]
  93.  
  94. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,5][0m 31.15ms]
  95.  
  96. 1 day : 100%
  97. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[61,1631010244][0m 0.4ms]
  98.  
  99. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,6][0m 32.31ms]
  100.  
  101. 7 days : 100%
  102. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[61,1629023044][0m 0.4ms]
  103.  
  104. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,7][0m 32.28ms]
  105.  
  106. 30 days : 100%
  107. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[61,1600079044][0m 0.4ms]
  108.  
  109. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,8][0m 32.27ms]
  110.  
  111. 365 days : 100%
  112.  
  113. >> Runtime for poller module 'availability': 0.3807 seconds with 104688 bytes
  114. >> SNMP: [0/0.00s] MySQL: [9/0.36s]
  115. #### Unload poller module availability ####
  116.  
  117. Modules status: Global-  
  118. OS  
  119. Device  
  120. Module [ unix-agent ] disabled globally.
  121.  
  122. Modules status: Global+  
  123. OS  
  124. Device  
  125.  
  126. #### Load poller module os ####
  127. Generic :(
  128. Location: Gurgoan
  129. Hardware: XG106_XN01_SFOS
  130. OS Version: 18.0.4 MR-4
  131. OS Features:
  132. Serial: C1C0B9KBJJ89785
  133.  
  134. >> Runtime for poller module 'os': 0.0123 seconds with 98440 bytes
  135. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
  136. #### Unload poller module os ####
  137.  
  138. Modules status: Global+  
  139. OS  
  140. Device  
  141.  
  142. #### Load poller module ipmi ####
  143. SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[61][0m 0.55ms]
  144.  
  145. array (
  146. )  
  147.  
  148. >> Runtime for poller module 'ipmi': 0.0102 seconds with 2992 bytes
  149. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  150. #### Unload poller module ipmi ####
  151.  
  152. Modules status: Global+  
  153. OS  
  154. Device  
  155.  
  156. #### Load poller module sensors ####
  157. SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[61][0m 0.48ms]
  158.  
  159.  
  160. >> Runtime for poller module 'sensors': 0.0110 seconds with 1584 bytes
  161. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  162. #### Unload poller module sensors ####
  163.  
  164. Modules status: Global+  
  165. OS  
  166. Device  
  167.  
  168. #### Load poller module processors ####
  169. Attempting to initialize OS: sophos-xg  
  170. Attempting to initialize OS: sophos  
  171. OS initialized as Generic  
  172. SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[61][0m 0.49ms]
  173.  
  174. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQn' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' '.1.3.6.1.2.1.25.3.3.1.2.196608' '.1.3.6.1.2.1.25.3.3.1.2.196609'[0m]
  175. .*.*.*608 = 78
  176. .*.*.*609 = 35  
  177.  
  178. array (
  179.   '.1.3.6.1.2.1.25.3.3.1.2.196608' => '78',
  180.   '.1.3.6.1.2.1.25.3.3.1.2.196609' => '35',
  181. )  
  182. Intel Atom Processor E3930 @ 1.30GHz: 78%
  183. SQL[[1;33mUPDATE `processors` set `processor_usage`=? WHERE `processor_id` = ? [0;33m[78,53][0m 43.55ms]
  184.  
  185. Intel Atom Processor E3930 @ 1.30GHz: 35%
  186. SQL[[1;33mUPDATE `processors` set `processor_usage`=? WHERE `processor_id` = ? [0;33m[35,54][0m 33.04ms]
  187.  
  188.  
  189. >> Runtime for poller module 'processors': 0.1656 seconds with 62384 bytes
  190. >> SNMP: [1/0.08s] MySQL: [3/0.08s]
  191. #### Unload poller module processors ####
  192.  
  193. Modules status: Global+  
  194. OS  
  195. Device  
  196.  
  197. #### Load poller module mempools ####
  198. SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[61][0m 0.75ms]
  199.  
  200. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQn' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' '.1.3.6.1.2.1.25.2.3.1.6.1' '.1.3.6.1.2.1.25.2.3.1.6.3' '.1.3.6.1.2.1.25.2.3.1.6.6' '.1.3.6.1.2.1.25.2.3.1.6.7' '.1.3.6.1.2.1.25.2.3.1.6.8' '.1.3.6.1.2.1.25.2.3.1.6.10'[0m]
  201. .*.*.* = 3576472
  202. .*.*.* = 4319896
  203. .*.*.* = 160088
  204. .*.*.* = 1096656
  205. .*.*.* = 144276
  206. .*.*.* = 743424  
  207.  
  208. Free memory adjusted by availability calculation: 302.25 MiiB -> 1.49 GiiB
  209.  
  210. hrstorage [system]: Physical memory: 60%  2.21 GiiB / 3.71 GiiB
  211. SQL[[1;33mupdate `mempools` set `mempool_perc` = ?, `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[60,2375401472,1603842048,92][0m 63.18ms]
  212.  
  213. hrstorage [virtual]: Virtual memory: 75%  4.12 GiiB / 5.53 GiiB
  214. SQL[[1;33mupdate `mempools` set `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[4423573504,1513693184,93][0m 65.93ms]
  215.  
  216. hrstorage [buffers]: Memory buffers: 46.34 MiiB / 3.71 GiiB
  217. SQL[[1;33mupdate `mempools` set `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[163930112,3815313408,94][0m 66.01ms]
  218.  
  219. hrstorage [cached]: Cached memory: 28%  1.05 GiiB / 3.71 GiiB
  220. SQL[[1;33mupdate `mempools` set `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[1122975744,2856267776,95][0m 66.15ms]
  221.  
  222. hrstorage [shared]: Shared memory: 40.89 MiiB / 3.71 GiiB
  223. SQL[[1;33mupdate `mempools` set `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[147738624,3831504896,96][0m 57.73ms]
  224.  
  225. hrstorage [swap]: Swap space: 39r6 MiiB / 1.82 GiiB
  226.  
  227. >> Runtime for poller module 'mempools': 0.4253 seconds with 121464 bytes
  228. >> SNMP: [1/0.08s] MySQL: [0/0.00s]
  229. #### Unload poller module mempools ####
  230.  
  231. Modules status: Global+  
  232. OS  
  233. Device  
  234.  
  235. #### Load poller module storage ####
  236. SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[61][0m 0.55ms]
  237.  
  238. Storage /: hrstorage
  239.  
  240.  
  241.  
  242. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'hrStorageEntry'[0m]
  243. hrStorageIndex.1 = 1
  244. hrStorageIndex.3 = 3
  245. hrStorageIndex.6 = 6
  246. hrStorageIndex.7 = 7
  247. hrStorageIndex.8 = 8
  248. hrStorageIndex.10 = 10
  249. hrStorageIndex.31 = 31
  250. hrStorageIndex.32 = 32
  251. hrStorageIndex.33 = 33
  252. hrStorageIndex.34 = 34
  253. hrStorageIndex.35 = 35
  254. hrStorageIndex.36 = 36
  255. hrStorageType.1 = hrStorageRam
  256. hrStorageType.3 = hrStorageVirtualMemory
  257. hrStorageType.6 = hrStorageOther
  258. hrStorageType.7 = hrStorageOther
  259. hrStorageType.8 = hrStorageOther
  260. hrStorageType.10 = hrStorageVirtualMemory
  261. hrStorageType.31 = hrStorageFixedDisk
  262. hrStorageType.32 = hrStorageFixedDisk
  263. hrStorageType.33 = hrStorageFixedDisk
  264. hrStorageType.34 = hrStorageFixedDisk
  265. hrStorageType.35 = hrStorageFixedDisk
  266. hrStorageType.36 = hrStorageFixedDisk
  267. hrStorageDescr.1 = Physical memory
  268. hrStorageDescr.3 = Virtual memory
  269. hrStorageDescr.6 = Memory buffers
  270. hrStorageDescr.7 = Cached memory
  271. hrStorageDescr.8 = Shared memory
  272. hrStorageDescr.10 = Swap space
  273. hrStorageDescr.31 = /
  274. hrStorageDescr.32 = /boot
  275. hrStorageDescr.33 = /conf
  276. hrStorageDescr.34 = /content
  277. hrStorageDescr.35 = /var
  278. hrStorageDescr.36 = /cfs
  279. hrStorageAllocationUnits.1 = 1024
  280. hrStorageAllocationUnits.3 = 1024
  281. hrStorageAllocationUnits.6 = 1024
  282. hrStorageAllocationUnits.7 = 1024
  283. hrStorageAllocationUnits.8 = 1024
  284. hrStorageAllocationUnits.10 = 1024
  285. hrStorageAllocationUnits.31 = 4096
  286. hrStorageAllocationUnits.32 = 1024
  287. hrStorageAllocationUnits.33 = 1024
  288. hrStorageAllocationUnits.34 = 1024
  289. hrStorageAllocationUnits.35 = 4096
  290. hrStorageAllocationUnits.36 = 512
  291. hrStorageSize.1 = 3885980
  292. hrStorageSize.3 = 5798112
  293. hrStorageSize.6 = 3885980
  294. hrStorageSize.7 = 1096656
  295. hrStorageSize.8 = 144276
  296. hrStorageSize.10 = 1912132
  297. hrStorageSize.31 = 164828
  298. hrStorageSize.32 = 130769
  299. hrStorageSize.33 = 573765
  300. hrStorageSize.34 = 5665198
  301. hrStorageSize.35 = 11923219
  302. hrStorageSize.36 = 0
  303. hrStorageUsed.1 = 3576472
  304. hrStorageUsed.3 = 4319896
  305. hrStorageUsed.6 = 160088
  306. hrStorageUsed.7 = 1096656
  307. hrStorageUsed.8 = 144276
  308. hrStorageUsed.10 = 743424
  309. hrStorageUsed.31 = 897
  310. hrStorageUsed.32 = 33354
  311. hrStorageUsed.33 = 76994
  312. hrStorageUsed.34 = 491251
  313. hrStorageUsed.35 = 4137715
  314. hrStorageUsed.36 = 0  
  315.  
  316. array (
  317.   'hrstorage' =>
  318.   array (
  319.     1 =>
  320.     array (
  321.       'hrStorageIndex' => '1',
  322.       'hrStorageType' => 'hrStorageRam',
  323.       'hrStorageDescr' => 'Physical memory',
  324.       'hrStorageAllocationUnits' => '1024',
  325.       'hrStorageSize' => '3885980',
  326.       'hrStorageUsed' => '3576472',
  327.     ),
  328.     3 =>
  329.     array (
  330.       'hrStorageIndex' => '3',
  331.       'hrStorageType' => 'hrStorageVirtualMemory',
  332.       'hrStorageDescr' => 'Virtual memory',
  333.       'hrStorageAllocationUnits' => '1024',
  334.       'hrStorageSize' => '5798112',
  335.       'hrStorageUsed' => '4319896',
  336.     ),
  337.     6 =>
  338.     array (
  339.       'hrStorageIndex' => '6',
  340.       'hrStorageType' => 'hrStorageOther',
  341.       'hrStorageDescr' => 'Memory buffers',
  342.       'hrStorageAllocationUnits' => '1024',
  343.       'hrStorageSize' => '3885980',
  344.       'hrStorageUsed' => '160088',
  345.     ),
  346.     7 =>
  347.     array (
  348.       'hrStorageIndex' => '7',
  349.       'hrStorageType' => 'hrStorageOther',
  350.       'hrStorageDescr' => 'Cached memory',
  351.       'hrStorageAllocationUnits' => '1024',
  352.       'hrStorageSize' => '1096656',
  353.       'hrStorageUsed' => '1096656',
  354.     ),
  355.     8 =>
  356.     array (
  357.       'hrStorageIndex' => '8',
  358.       'hrStorageType' => 'hrStorageOther',
  359.       'hrStorageDescr' => 'Shared memory',
  360.       'hrStorageAllocationUnits' => '1024',
  361.       'hrStorageSize' => '144276',
  362.       'hrStorageUsed' => '144276',
  363.     ),
  364.     10 =>
  365.     array (
  366.       'hrStorageIndex' => '10',
  367.       'hrStorageType' => 'hrStorageVirtualMemory',
  368.       'hrStorageDescr' => 'Swap space',
  369.       'hrStorageAllocationUnits' => '1024',
  370.       'hrStorageSize' => '1912132',
  371.       'hrStorageUsed' => '743424',
  372.     ),
  373.     31 =>
  374.     array (
  375.       'hrStorageIndex' => '31',
  376.       'hrStorageType' => 'hrStorageFixedDisk',
  377.       'hrStorageDescr' => '/',
  378.       'hrStorageAllocationUnits' => '4096',
  379.       'hrStorageSize' => '164828',
  380.       'hrStorageUsed' => '897',
  381.     ),
  382.     32 =>
  383.     array (
  384.       'hrStorageIndex' => '32',
  385.       'hrStorageType' => 'hrStorageFixedDisk',
  386.       'hrStorageDescr' => '/boot',
  387.       'hrStorageAllocationUnits' => '1024',
  388.       'hrStorageSize' => '130769',
  389.       'hrStorageUsed' => '33354',
  390.     ),
  391.     33 =>
  392.     array (
  393.       'hrStorageIndex' => '33',
  394.       'hrStorageType' => 'hrStorageFixedDisk',
  395.       'hrStorageDescr' => '/conf',
  396.       'hrStorageAllocationUnits' => '1024',
  397.       'hrStorageSize' => '573765',
  398.       'hrStorageUsed' => '76994',
  399.     ),
  400.     34 =>
  401.     array (
  402.       'hrStorageIndex' => '34',
  403.       'hrStorageType' => 'hrStorageFixedDisk',
  404.       'hrStorageDescr' => '/content',
  405.       'hrStorageAllocationUnits' => '1024',
  406.       'hrStorageSize' => '5665198',
  407.       'hrStorageUsed' => '491251',
  408.     ),
  409.     35 =>
  410.     array (
  411.       'hrStorageIndex' => '35',
  412.       'hrStorageType' => 'hrStorageFixedDisk',
  413.       'hrStorageDescr' => '/var',
  414.       'hrStorageAllocationUnits' => '4096',
  415.       'hrStorageSize' => '11923219',
  416.       'hrStorageUsed' => '4137715',
  417.     ),
  418.     36 =>
  419.     array (
  420.       'hrStorageIndex' => '36',
  421.       'hrStorageType' => 'hrStorageFixedDisk',
  422.       'hrStorageDescr' => '/cfs',
  423.       'hrStorageAllocationUnits' => '512',
  424.       'hrStorageSize' => '0',
  425.       'hrStorageUsed' => '0',
  426.     ),
  427.   ),
  428. )  
  429. array (
  430.   'storage_id' => 16,
  431.   'device_id' => 61,
  432.   'storage_mib' => 'hrstorage',
  433.   'storage_index' => '31',
  434.   'storage_type' => 'hrStorageFixedDisk',
  435.   'storage_descr' => '/',
  436.   'storage_size' => 675135488,
  437.   'storage_units' => 4096,
  438.   'storage_used' => 3674112,
  439.   'storage_free' => 0,
  440.   'storage_perc' => 0,
  441.   'storage_perc_warn' => 60,
  442.   'storage_deleted' => 0,
  443.   'units' => '4096',
  444.   'used' => 3674112,
  445.   'size' => 675135488,
  446.   'free' => 671461376,
  447. )  
  448. 1% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["3674112","671461376","675135488","4096",1,16][0m 64.6ms]
  449.  
  450.  
  451. Storage /boot: hrstorage
  452.  
  453.  
  454.  
  455. array (
  456.   'storage_id' => 17,
  457.   'device_id' => 61,
  458.   'storage_mib' => 'hrstorage',
  459.   'storage_index' => '32',
  460.   'storage_type' => 'hrStorageFixedDisk',
  461.   'storage_descr' => '/boot',
  462.   'storage_size' => 133907456,
  463.   'storage_units' => 1024,
  464.   'storage_used' => 34154496,
  465.   'storage_free' => 0,
  466.   'storage_perc' => 0,
  467.   'storage_perc_warn' => 60,
  468.   'storage_deleted' => 0,
  469.   'units' => '1024',
  470.   'used' => 34154496,
  471.   'size' => 133907456,
  472.   'free' => 99752960,
  473. )  
  474. 26% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["34154496","99752960","133907456","1024",26,17][0m 66.03ms]
  475.  
  476.  
  477. Storage /conf: hrstorage
  478.  
  479.  
  480.  
  481. array (
  482.   'storage_id' => 18,
  483.   'device_id' => 61,
  484.   'storage_mib' => 'hrstorage',
  485.   'storage_index' => '33',
  486.   'storage_type' => 'hrStorageFixedDisk',
  487.   'storage_descr' => '/conf',
  488.   'storage_size' => 587535360,
  489.   'storage_units' => 1024,
  490.   'storage_used' => 78972928,
  491.   'storage_free' => 0,
  492.   'storage_perc' => 0,
  493.   'storage_perc_warn' => 60,
  494.   'storage_deleted' => 0,
  495.   'units' => '1024',
  496.   'used' => 78841856,
  497.   'size' => 587535360,
  498.   'free' => 508693504,
  499. )  
  500. 13% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["78841856","508693504","587535360","1024",13,18][0m 41.16ms]
  501.  
  502.  
  503. Storage /content: hrstorage
  504.  
  505.  
  506.  
  507. array (
  508.   'storage_id' => 19,
  509.   'device_id' => 61,
  510.   'storage_mib' => 'hrstorage',
  511.   'storage_index' => '34',
  512.   'storage_type' => 'hrStorageFixedDisk',
  513.   'storage_descr' => '/content',
  514.   'storage_size' => 5801162752,
  515.   'storage_units' => 1024,
  516.   'storage_used' => 503591936,
  517.   'storage_free' => 0,
  518.   'storage_perc' => 0,
  519.   'storage_perc_warn' => 60,
  520.   'storage_deleted' => 0,
  521.   'units' => '1024',
  522.   'used' => 503041024,
  523.   'size' => 5801162752,
  524.   'free' => 5298121728,
  525. )  
  526. 9% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["503041024","5298121728","5801162752","1024",9,19][0m 32.85ms]
  527.  
  528.  
  529. Storage /var: hrstorage
  530.  
  531.  
  532.  
  533. array (
  534.   'storage_id' => 20,
  535.   'device_id' => 61,
  536.   'storage_mib' => 'hrstorage',
  537.   'storage_index' => '35',
  538.   'storage_type' => 'hrStorageFixedDisk',
  539.   'storage_descr' => '/var',
  540.   'storage_size' => 48837505024,
  541.   'storage_units' => 4096,
  542.   'storage_used' => 16630874112,
  543.   'storage_free' => 0,
  544.   'storage_perc' => 0,
  545.   'storage_perc_warn' => 60,
  546.   'storage_deleted' => 0,
  547.   'units' => '4096',
  548.   'used' => 16948080640,
  549.   'size' => 48837505024,
  550.   'free' => 31889424384,
  551. )  
  552. 35% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["16948080640","31889424384","48837505024","4096",35,20][0m 32.86ms]
  553.  
  554.  
  555.  
  556. >> Runtime for poller module 'storage': 0.8742 seconds with 16408 bytes
  557. >> SNMP: [1/0.61s] MySQL: [6/0.24s]
  558. #### Unload poller module storage ####
  559.  
  560. Modules status: Global+  
  561. OS  
  562. Device  
  563.  
  564. #### Load poller module netstats ####
  565.  ICMPSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'icmp'[0m]
  566. icmpInMsgs.0 = 4156402
  567. icmpInErrors.0 = 118
  568. icmpInDestUnreachs.0 = 34463
  569. icmpInTimeExcds.0 = 3398
  570. icmpInParmProbs.0 = 0
  571. icmpInSrcQuenchs.0 = 0
  572. icmpInRedirects.0 = 741
  573. icmpInEchos.0 = 3594919
  574. icmpInEchoReps.0 = 522881
  575. icmpInTimestamps.0 = 0
  576. icmpInTimestampReps.0 = 0
  577. icmpInAddrMasks.0 = 0
  578. icmpInAddrMaskReps.0 = 0
  579. icmpOutMsgs.0 = 4464915
  580. icmpOutErrors.0 = 0
  581. icmpOutDestUnreachs.0 = 341118
  582. icmpOutTimeExcds.0 = 3421
  583. icmpOutParmProbs.0 = 0
  584. icmpOutSrcQuenchs.0 = 0
  585. icmpOutRedirects.0 = 29
  586. icmpOutEchos.0 = 525442
  587. icmpOutEchoReps.0 = 3594905
  588. icmpOutTimestamps.0 = 0
  589. icmpOutTimestampReps.0 = 0
  590. icmpOutAddrMasks.0 = 0
  591. icmpOutAddrMaskReps.0 = 0
  592. icmpStatsInMsgs.ipv4 = 4156402
  593. icmpStatsInMsgs.ipv6 = 112685
  594. icmpStatsInErrors.ipv4 = 118
  595. icmpStatsInErrors.ipv6 = 0
  596. icmpStatsOutMsgs.ipv4 = 4464915
  597. icmpStatsOutMsgs.ipv6 = 86
  598. icmpStatsOutErrors.ipv4 = 0
  599. icmpStatsOutErrors.ipv6 = 0
  600. icmpMsgStatsInPkts.ipv4.0 = 522881
  601. icmpMsgStatsInPkts.ipv4.3 = 34463
  602. icmpMsgStatsInPkts.ipv4.4 = 0
  603. icmpMsgStatsInPkts.ipv4.5 = 741
  604. icmpMsgStatsInPkts.ipv4.8 = 3594919
  605. icmpMsgStatsInPkts.ipv4.11 = 3398
  606. icmpMsgStatsInPkts.ipv4.12 = 0
  607. icmpMsgStatsInPkts.ipv4.13 = 0
  608. icmpMsgStatsInPkts.ipv4.14 = 0
  609. icmpMsgStatsInPkts.ipv4.17 = 0
  610. icmpMsgStatsInPkts.ipv4.18 = 0
  611. icmpMsgStatsInPkts.ipv6.128 = 2
  612. icmpMsgStatsInPkts.ipv6.132 = 151
  613. icmpMsgStatsInPkts.ipv6.133 = 88751
  614. icmpMsgStatsInPkts.ipv6.135 = 2
  615. icmpMsgStatsInPkts.ipv6.136 = 23779
  616. icmpMsgStatsOutPkts.ipv4.0 = 3594905
  617. icmpMsgStatsOutPkts.ipv4.3 = 341118
  618. icmpMsgStatsOutPkts.ipv4.4 = 0
  619. icmpMsgStatsOutPkts.ipv4.5 = 29
  620. icmpMsgStatsOutPkts.ipv4.8 = 525442
  621. icmpMsgStatsOutPkts.ipv4.11 = 3421
  622. icmpMsgStatsOutPkts.ipv4.12 = 0
  623. icmpMsgStatsOutPkts.ipv4.13 = 0
  624. icmpMsgStatsOutPkts.ipv4.14 = 0
  625. icmpMsgStatsOutPkts.ipv4.17 = 0
  626. icmpMsgStatsOutPkts.ipv4.18 = 0
  627. icmpMsgStatsOutPkts.ipv6.129 = 2
  628. icmpMsgStatsOutPkts.ipv6.133 = 2
  629. icmpMsgStatsOutPkts.ipv6.135 = 4
  630. icmpMsgStatsOutPkts.ipv6.136 = 2
  631. icmpMsgStatsOutPkts.ipv6.143 = 76  
  632.  
  633.  IPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'ipForwDatagrams' 'ipInDelivers' 'ipInReceives' 'ipOutRequests' 'ipInDiscards' 'ipOutDiscards' 'ipOutNoRoutes' 'ipReasmReqds' 'ipReasmOKs' 'ipReasmFails' 'ipFragOKs' 'ipFragFails' 'ipFragCreates' 'ipInUnknownProtos' 'ipInHdrErrors' 'ipInAddrErrors'[0m]
  634. ipForwDatagrams.0 = 1988288292
  635. ipInDelivers.0 = 1457738991
  636. ipInReceives.0 = 0
  637. ipOutRequests.0 = 2147483647
  638. ipInDiscards.0 = 0
  639. ipOutDiscards.0 = 2007
  640. ipOutNoRoutes.0 = 4443
  641. ipReasmReqds.0 = 725965
  642. ipReasmOKs.0 = 360025
  643. ipReasmFails.0 = 1130
  644. ipFragOKs.0 = 325887
  645. ipFragFails.0 = 250
  646. ipFragCreates.0 = 656429
  647. ipInUnknownProtos.0 = 0
  648. ipInHdrErrors.0 = 2778
  649. ipInAddrErrors.0 = 0  
  650.  
  651.  IP-FORWARDSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQv' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m]
  652. No Such Object available on this agent at this OID  
  653.  
  654.  SNMPSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'snmp'[0m]
  655. snmpInPkts.0 = 106454957
  656. snmpOutPkts.0 = 106455487
  657. snmpInBadVersions.0 = 0
  658. snmpInBadCommunityNames.0 = 177
  659. snmpInBadCommunityUses.0 = 0
  660. snmpInASNParseErrs.0 = 0
  661. snmpInTooBigs.0 = 0
  662. snmpInNoSuchNames.0 = 0
  663. snmpInBadValues.0 = 0
  664. snmpInReadOnlys.0 = 0
  665. snmpInGenErrs.0 = 0
  666. snmpInTotalReqVars.0 = 106460492
  667. snmpInTotalSetVars.0 = 0
  668. snmpInGetRequests.0 = 6262673
  669. snmpInGetNexts.0 = 100191525
  670. snmpInSetRequests.0 = 0
  671. snmpInGetResponses.0 = 0
  672. snmpInTraps.0 = 0
  673. snmpOutTooBigs.0 = 0
  674. snmpOutNoSuchNames.0 = 0
  675. snmpOutBadValues.0 = 0
  676. snmpOutGenErrs.0 = 0
  677. snmpOutGetRequests.0 = 0
  678. snmpOutGetNexts.0 = 0
  679. snmpOutSetRequests.0 = 0
  680. snmpOutGetResponses.0 = 106454781
  681. snmpOutTraps.0 = 708
  682. snmpEnableAuthenTraps.0 = enabled
  683. snmpSilentDrops.0 = 0
  684. snmpProxyDrops.0 = 0  
  685.  
  686.  TCPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'tcpActiveOpens' 'tcpPassiveOpens' 'tcpAttemptFails' 'tcpEstabResets' 'tcpCurrEstab' 'tcpInSegs' 'tcpOutSegs' 'tcpRetransSegs' 'tcpInErrs' 'tcpOutRsts'[0m]
  687. tcpActiveOpens.0 = 11649725
  688. tcpPassiveOpens.0 = 17063892
  689. tcpAttemptFails.0 = 152738
  690. tcpEstabResets.0 = 4213944
  691. tcpCurrEstab.0 = 414
  692. tcpInSegs.0 = 970144492
  693. tcpOutSegs.0 = 934669352
  694. tcpRetransSegs.0 = 3863592
  695. tcpInErrs.0 = 52628
  696. tcpOutRsts.0 = 2942560  
  697.  
  698.  TCPHCSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'tcpHCInSegs.0' 'tcpHCOutSegs.0'[0m]
  699. tcpConnectionState.ipv4."*".2712.ipv4."*".34851 = established
  700. tcpConnectionState.ipv4."*".2712.ipv4."*".34851 = established  
  701.  
  702.  UDPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UDP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'udpInDatagrams' 'udpOutDatagrams' 'udpInErrors' 'udpNoPorts'[0m]
  703. udpInDatagrams.0 = 379065365
  704. udpOutDatagrams.0 = 378853608
  705. udpInErrors.0 = 1073227
  706. udpNoPorts.0 = 24842  
  707.  
  708.  
  709.  
  710. >> Runtime for poller module 'netstats': 1.5558 seconds with 3248 bytes
  711. >> SNMP: [7/1.51s] MySQL: [0/0.00s]
  712. #### Unload poller module netstats ####
  713.  
  714. Modules status: Global+  
  715. OS  
  716. Device  
  717.  
  718. #### Load poller module hr-mib ####
  719. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m]
  720. hrSystemProcesses.0 = No Such Instance currently exists at this OID
  721. hrSystemNumUsers.0 = 0  
  722.  
  723.  Users
  724.  
  725. >> Runtime for poller module 'hr-mib': 0.1047 seconds with 3256 bytes
  726. >> SNMP: [1/0.09s] MySQL: [0/0.00s]
  727. #### Unload poller module hr-mib ####
  728.  
  729. Modules status: Global+  
  730. OS  
  731. Device  
  732.  
  733. #### Load poller module ucd-mib ####
  734. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'systemStats'[0m]
  735.  
  736.  
  737. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m]
  738. Exitcode: 1  
  739. Timeout: No Response from udp:10.180.7.1:161.  
  740.  
  741. Timeout: No Response from udp:10.180.7.1:161.  
  742.  
  743. >> Runtime for poller module 'ucd-mib': 17.3317 seconds with 1936 bytes
  744. >> SNMP: [2/17.30s] MySQL: [0/0.00s]
  745. #### Unload poller module ucd-mib ####
  746.  
  747. Modules status: Global+  
  748. OS  
  749. Device  
  750.  
  751. #### Load poller module ipSystemStats ####
  752. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'ipSystemStats'[0m]
  753. Exitcode: 1  
  754. Timeout: No Response from udp:10.180.7.1:161  
  755.  
  756. Timeout: No Response from udp:10.180.7.1:161  
  757.  
  758.  
  759. >> Runtime for poller module 'ipSystemStats': 6.0286 seconds with 1976 bytes
  760. >> SNMP: [1/6.03s] MySQL: [0/0.00s]
  761. #### Unload poller module ipSystemStats ####
  762.  
  763. Modules status: Global+  
  764. OS  
  765. Device  
  766.  
  767. #### Load poller module ports ####
  768. 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[61][0m 1.8ms]
  769.  
  770. Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'ifXEntry'[0m]
  771. Exitcode: 1  
  772. Timeout: No Response from udp:10.180.7.1:161  
  773.  
  774. Timeout: No Response from udp:10.180.7.1:161  
  775. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'ifEntry'[0m]
  776. ifIndex.1 = 1
  777. ifIndex.2 = 2
  778. ifIndex.3 = 3
  779. ifIndex.4 = 4
  780. ifIndex.5 = 5
  781. ifIndex.6 = 6
  782. ifIndex.7 = 7
  783. ifIndex.8 = 8
  784. ifIndex.9 = 9
  785. ifIndex.11 = 11
  786. ifIndex.12 = 12
  787. ifIndex.13 = 13
  788. ifIndex.14 = 14
  789. ifIndex.15 = 15
  790. ifIndex.99 = 99
  791. ifDescr.1 = lo
  792. ifDescr.2 = ipsec0
  793. ifDescr.3 = sit0
  794. ifDescr.4 = ip6tnl0
  795. ifDescr.5 = Port4
  796. ifDescr.6 = Port1
  797. ifDescr.7 = Port2
  798. ifDescr.8 = Port3
  799. ifDescr.9 = ifb0
  800. ifDescr.11 = gre0
  801. ifDescr.12 = gretap0
  802. ifDescr.13 = erspan0
  803. ifDescr.14 = host0
  804. ifDescr.15 = host1
  805. ifDescr.99 = spq
  806. ifType.1 = softwareLoopback
  807. ifType.2 = ethernetCsmacd
  808. ifType.3 = tunnel
  809. ifType.4 = tunnel
  810. ifType.5 = ethernetCsmacd
  811. ifType.6 = ethernetCsmacd
  812. ifType.7 = ethernetCsmacd
  813. ifType.8 = ethernetCsmacd
  814. ifType.9 = ethernetCsmacd
  815. ifType.11 = tunnel
  816. ifType.12 = ethernetCsmacd
  817. ifType.13 = ethernetCsmacd
  818. ifType.14 = ethernetCsmacd
  819. ifType.15 = ethernetCsmacd
  820. ifType.99 = ethernetCsmacd
  821. ifMtu.1 = 65536
  822. ifMtu.2 = 16260
  823. ifMtu.3 = 1480
  824. ifMtu.4 = 1452
  825. ifMtu.5 = 1500
  826. ifMtu.6 = 1500
  827. ifMtu.7 = 1500
  828. ifMtu.8 = 1500
  829. ifMtu.9 = 1500
  830. ifMtu.11 = 1476
  831. ifMtu.12 = 1462
  832. ifMtu.13 = 1450
  833. ifMtu.14 = 1500
  834. ifMtu.15 = 1500
  835. ifMtu.99 = 1500
  836. ifSpeed.1 = 10000000
  837. ifSpeed.2 = 0
  838. ifSpeed.3 = 0
  839. ifSpeed.4 = 0
  840. ifSpeed.5 = 0
  841. ifSpeed.6 = 1000000000
  842. ifSpeed.7 = 100000000
  843. ifSpeed.8 = 100000000
  844. ifSpeed.9 = 0
  845. ifSpeed.11 = 0
  846. ifSpeed.12 = 0
  847. ifSpeed.13 = 0
  848. ifSpeed.14 = 0
  849. ifSpeed.15 = 0
  850. ifSpeed.99 = 0
  851. ifPhysAddress.1 =
  852. ifPhysAddress.2 = 42:b1:fa:bb:7d:a2
  853. ifPhysAddress.3 =
  854. ifPhysAddress.4 =
  855. ifPhysAddress.5 = 7c:5a:1c:d8:cb:63
  856. ifPhysAddress.6 = 7c:5a:1c:d8:cb:60
  857. ifPhysAddress.7 = 7c:5a:1c:d8:cb:61
  858. ifPhysAddress.8 = 7c:5a:1c:d8:cb:62
  859. ifPhysAddress.9 = 76:10:4e:a6:67:bb
  860. ifPhysAddress.11 =
  861. ifPhysAddress.12 =
  862. ifPhysAddress.13 =
  863. ifPhysAddress.14 = e2:98:4b:8a:7a:ae
  864. ifPhysAddress.15 = 5e:e9:7b:59:a5:2c
  865. ifPhysAddress.99 = 6:94:f:2:ee:18
  866. ifAdminStatus.1 = up
  867. ifAdminStatus.2 = up
  868. ifAdminStatus.3 = down
  869. ifAdminStatus.4 = down
  870. ifAdminStatus.5 = down
  871. ifAdminStatus.6 = up
  872. ifAdminStatus.7 = up
  873. ifAdminStatus.8 = up
  874. ifAdminStatus.9 = up
  875. ifAdminStatus.11 = down
  876. ifAdminStatus.12 = down
  877. ifAdminStatus.13 = down
  878. ifAdminStatus.14 = down
  879. ifAdminStatus.15 = down
  880. ifAdminStatus.99 = down
  881. ifOperStatus.1 = up
  882. ifOperStatus.2 = up
  883. ifOperStatus.3 = down
  884. ifOperStatus.4 = down
  885. ifOperStatus.5 = down
  886. ifOperStatus.6 = up
  887. ifOperStatus.7 = up
  888. ifOperStatus.8 = up
  889. ifOperStatus.9 = up
  890. ifOperStatus.11 = down
  891. ifOperStatus.12 = down
  892. ifOperStatus.13 = down
  893. ifOperStatus.14 = down
  894. ifOperStatus.15 = down
  895. ifOperStatus.99 = down
  896. ifLastChange.1 = 0
  897. ifLastChange.2 = 0
  898. ifLastChange.3 = 0
  899. ifLastChange.4 = 0
  900. ifLastChange.5 = 0
  901. ifLastChange.6 = 19641746
  902. ifLastChange.7 = 1402107491
  903. ifLastChange.8 = 1152479208
  904. ifLastChange.9 = 0
  905. ifLastChange.11 = 0
  906. ifLastChange.12 = 0
  907. ifLastChange.13 = 0
  908. ifLastChange.14 = 0
  909. ifLastChange.15 = 0
  910. ifLastChange.99 = 1556561242
  911. ifInOctets.1 = 2250756416
  912. ifInOctets.2 = 0
  913. ifInOctets.3 = 0
  914. ifInOctets.4 = 0
  915. ifInOctets.5 = 0
  916. ifInOctets.6 = 54416364
  917. ifInOctets.7 = 110949207
  918. ifInOctets.8 = 3927296175
  919. ifInOctets.9 = 639744849
  920. ifInOctets.11 = 0
  921. ifInOctets.12 = 0
  922. ifInOctets.13 = 0
  923. ifInOctets.14 = 0
  924. ifInOctets.15 = 0
  925. ifInOctets.99 = 0
  926. ifInUcastPkts.1 = 612848820
  927. ifInUcastPkts.2 = 0
  928. ifInUcastPkts.3 = 0
  929. ifInUcastPkts.4 = 0
  930. ifInUcastPkts.5 = 0
  931. ifInUcastPkts.6 = 879247321
  932. ifInUcastPkts.7 = 1721348769
  933. ifInUcastPkts.8 = 244818714
  934. ifInUcastPkts.9 = 2617134357
  935. ifInUcastPkts.11 = 0
  936. ifInUcastPkts.12 = 0
  937. ifInUcastPkts.13 = 0
  938. ifInUcastPkts.14 = 0
  939. ifInUcastPkts.15 = 0
  940. ifInUcastPkts.99 = 0
  941. ifInNUcastPkts.1 = 0
  942. ifInNUcastPkts.2 = 0
  943. ifInNUcastPkts.3 = 0
  944. ifInNUcastPkts.4 = 0
  945. ifInNUcastPkts.5 = 0
  946. ifInNUcastPkts.6 = 1498943
  947. ifInNUcastPkts.7 = 1
  948. ifInNUcastPkts.8 = 66918
  949. ifInNUcastPkts.9 = 0
  950. ifInNUcastPkts.11 = 0
  951. ifInNUcastPkts.12 = 0
  952. ifInNUcastPkts.13 = 0
  953. ifInNUcastPkts.14 = 0
  954. ifInNUcastPkts.15 = 0
  955. ifInNUcastPkts.99 = 0
  956. ifInDiscards.1 = 0
  957. ifInDiscards.2 = 0
  958. ifInDiscards.3 = 0
  959. ifInDiscards.4 = 0
  960. ifInDiscards.5 = 0
  961. ifInDiscards.6 = 0
  962. ifInDiscards.7 = 1
  963. ifInDiscards.8 = 0
  964. ifInDiscards.9 = 0
  965. ifInDiscards.11 = 0
  966. ifInDiscards.12 = 0
  967. ifInDiscards.13 = 0
  968. ifInDiscards.14 = 0
  969. ifInDiscards.15 = 0
  970. ifInDiscards.99 = 0
  971. ifInErrors.1 = 0
  972. ifInErrors.2 = 0
  973. ifInErrors.3 = 0
  974. ifInErrors.4 = 0
  975. ifInErrors.5 = 0
  976. ifInErrors.6 = 0
  977. ifInErrors.7 = 0
  978. ifInErrors.8 = 7
  979. ifInErrors.9 = 0
  980. ifInErrors.11 = 0
  981. ifInErrors.12 = 0
  982. ifInErrors.13 = 0
  983. ifInErrors.14 = 0
  984. ifInErrors.15 = 0
  985. ifInErrors.99 = 0
  986. ifInUnknownProtos.1 = 0
  987. ifInUnknownProtos.2 = 0
  988. ifInUnknownProtos.3 = 0
  989. ifInUnknownProtos.4 = 0
  990. ifInUnknownProtos.5 = 0
  991. ifInUnknownProtos.6 = 0
  992. ifInUnknownProtos.7 = 0
  993. ifInUnknownProtos.8 = 0
  994. ifInUnknownProtos.9 = 0
  995. ifInUnknownProtos.11 = 0
  996. ifInUnknownProtos.12 = 0
  997. ifInUnknownProtos.13 = 0
  998. ifInUnknownProtos.14 = 0
  999. ifInUnknownProtos.15 = 0
  1000. ifInUnknownProtos.99 = 0
  1001. ifOutOctets.1 = 2250756416
  1002. ifOutOctets.2 = 0
  1003. ifOutOctets.3 = 0
  1004. ifOutOctets.4 = 0
  1005. ifOutOctets.5 = 0
  1006. ifOutOctets.6 = 1463792792
  1007. ifOutOctets.7 = 4060966186
  1008. ifOutOctets.8 = 1216287765
  1009. ifOutOctets.9 = 639744849
  1010. ifOutOctets.11 = 0
  1011. ifOutOctets.12 = 0
  1012. ifOutOctets.13 = 0
  1013. ifOutOctets.14 = 0
  1014. ifOutOctets.15 = 0
  1015. ifOutOctets.99 = 0
  1016. ifOutUcastPkts.1 = 612848820
  1017. ifOutUcastPkts.2 = 0
  1018. ifOutUcastPkts.3 = 0
  1019. ifOutUcastPkts.4 = 0
  1020. ifOutUcastPkts.5 = 0
  1021. ifOutUcastPkts.6 = 1211928728
  1022. ifOutUcastPkts.7 = 1046423805
  1023. ifOutUcastPkts.8 = 438787220
  1024. ifOutUcastPkts.9 = 2617134357
  1025. ifOutUcastPkts.11 = 0
  1026. ifOutUcastPkts.12 = 0
  1027. ifOutUcastPkts.13 = 0
  1028. ifOutUcastPkts.14 = 0
  1029. ifOutUcastPkts.15 = 0
  1030. ifOutUcastPkts.99 = 0
  1031. ifOutNUcastPkts.1 = 0
  1032. ifOutNUcastPkts.2 = 0
  1033. ifOutNUcastPkts.3 = 0
  1034. ifOutNUcastPkts.4 = 0
  1035. ifOutNUcastPkts.5 = 0
  1036. ifOutNUcastPkts.6 = 0
  1037. ifOutNUcastPkts.7 = 0
  1038. ifOutNUcastPkts.8 = 0
  1039. ifOutNUcastPkts.9 = 0
  1040. ifOutNUcastPkts.11 = 0
  1041. ifOutNUcastPkts.12 = 0
  1042. ifOutNUcastPkts.13 = 0
  1043. ifOutNUcastPkts.14 = 0
  1044. ifOutNUcastPkts.15 = 0
  1045. ifOutNUcastPkts.99 = 0
  1046. ifOutDiscards.1 = 0
  1047. ifOutDiscards.2 = 0
  1048. ifOutDiscards.3 = 0
  1049. ifOutDiscards.4 = 0
  1050. ifOutDiscards.5 = 0
  1051. ifOutDiscards.6 = 0
  1052. ifOutDiscards.7 = 0
  1053. ifOutDiscards.8 = 0
  1054. ifOutDiscards.9 = 0
  1055. ifOutDiscards.11 = 0
  1056. ifOutDiscards.12 = 0
  1057. ifOutDiscards.13 = 0
  1058. ifOutDiscards.14 = 0
  1059. ifOutDiscards.15 = 0
  1060. ifOutDiscards.99 = 0
  1061. ifOutErrors.1 = 0
  1062. ifOutErrors.2 = 0
  1063. ifOutErrors.3 = 0
  1064. ifOutErrors.4 = 0
  1065. ifOutErrors.5 = 0
  1066. ifOutErrors.6 = 0
  1067. ifOutErrors.7 = 0
  1068. ifOutErrors.8 = 0
  1069. ifOutErrors.9 = 0
  1070. ifOutErrors.11 = 0
  1071. ifOutErrors.12 = 0
  1072. ifOutErrors.13 = 0
  1073. ifOutErrors.14 = 0
  1074. ifOutErrors.15 = 0
  1075. ifOutErrors.99 = 0
  1076. ifOutQLen.1 = 0
  1077. ifOutQLen.2 = 0
  1078. ifOutQLen.3 = 0
  1079. ifOutQLen.4 = 0
  1080. ifOutQLen.5 = 0
  1081. ifOutQLen.6 = 0
  1082. ifOutQLen.7 = 0
  1083. ifOutQLen.8 = 0
  1084. ifOutQLen.9 = 0
  1085. ifOutQLen.11 = 0
  1086. ifOutQLen.12 = 0
  1087. ifOutQLen.13 = 0
  1088. ifOutQLen.14 = 0
  1089. ifOutQLen.15 = 0
  1090. ifOutQLen.99 = 0
  1091. ifSpecific.1 = zeroDotZero
  1092. ifSpecific.2 = zeroDotZero
  1093. ifSpecific.3 = zeroDotZero
  1094. ifSpecific.4 = zeroDotZero
  1095. ifSpecific.5 = zeroDotZero
  1096. ifSpecific.6 = zeroDotZero
  1097. ifSpecific.7 = zeroDotZero
  1098. ifSpecific.8 = zeroDotZero
  1099. ifSpecific.9 = zeroDotZero
  1100. ifSpecific.11 = zeroDotZero
  1101. ifSpecific.12 = zeroDotZero
  1102. ifSpecific.13 = zeroDotZero
  1103. ifSpecific.14 = zeroDotZero
  1104. ifSpecific.15 = zeroDotZero
  1105. ifSpecific.99 = zeroDotZero  
  1106.  
  1107. dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m]
  1108. dot3StatsDuplexStatus.1.1.3 = *
  1109. dot3StatsDuplexStatus.1.1.4 = *
  1110. dot3StatsDuplexStatus.1.2.3 = *
  1111. dot3StatsDuplexStatus.1.2.4 = *
  1112. dot3StatsDuplexStatus.1.3.3 = halfDuplex
  1113. dot3StatsDuplexStatus.1.3.4 = halfDuplex
  1114. dot3StatsDuplexStatus.1.4.3 = 64
  1115. dot3StatsDuplexStatus.1.4.4 = 0
  1116. dot3StatsDuplexStatus.1.5.3 = unknown
  1117. dot3StatsDuplexStatus.1.5.4 = unknown
  1118. dot3StatsDuplexStatus.1.6.3 = 0
  1119. dot3StatsDuplexStatus.1.6.4 = 0  
  1120.  
  1121. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'dot1qPvid'[0m]
  1122. dot1qPvid = No Such Object available on this agent at this OID  
  1123.  
  1124. Invalid snmp_walk() data = dot1qPvid = No Such Object available on this agent at this OID  
  1125. SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl') [0;33m[61][0m 0.97ms]
  1126.  
  1127. array (
  1128.   1 =>
  1129.   array (
  1130.     'ifIndex' => '1',
  1131.     'ifDescr' => 'lo',
  1132.     'ifType' => 'softwareLoopback',
  1133.     'ifMtu' => '65536',
  1134.     'ifSpeed' => '10000000',
  1135.     'ifPhysAddress' => '',
  1136.     'ifAdminStatus' => 'up',
  1137.     'ifOperStatus' => 'up',
  1138.     'ifLastChange' => '0',
  1139.     'ifInOctets' => '2250756416',
  1140.     'ifInUcastPkts' => '612848820',
  1141.     'ifInNUcastPkts' => '0',
  1142.     'ifInDiscards' => '0',
  1143.     'ifInErrors' => '0',
  1144.     'ifInUnknownProtos' => '0',
  1145.     'ifOutOctets' => '2250756416',
  1146.     'ifOutUcastPkts' => '612848820',
  1147.     'ifOutNUcastPkts' => '0',
  1148.     'ifOutDiscards' => '0',
  1149.     'ifOutErrors' => '0',
  1150.     'ifOutQLen' => '0',
  1151.     'ifSpecific' => 'zeroDotZero',
  1152.   ),
  1153.   2 =>
  1154.   array (
  1155.     'ifIndex' => '2',
  1156.     'ifDescr' => 'ipsec0',
  1157.     'ifType' => 'ethernetCsmacd',
  1158.     'ifMtu' => '16260',
  1159.     'ifSpeed' => '0',
  1160.     'ifPhysAddress' => '42:b1:fa:bb:7d:a2',
  1161.     'ifAdminStatus' => 'up',
  1162.     'ifOperStatus' => 'up',
  1163.     'ifLastChange' => '0',
  1164.     'ifInOctets' => '0',
  1165.     'ifInUcastPkts' => '0',
  1166.     'ifInNUcastPkts' => '0',
  1167.     'ifInDiscards' => '0',
  1168.     'ifInErrors' => '0',
  1169.     'ifInUnknownProtos' => '0',
  1170.     'ifOutOctets' => '0',
  1171.     'ifOutUcastPkts' => '0',
  1172.     'ifOutNUcastPkts' => '0',
  1173.     'ifOutDiscards' => '0',
  1174.     'ifOutErrors' => '0',
  1175.     'ifOutQLen' => '0',
  1176.     'ifSpecific' => 'zeroDotZero',
  1177.   ),
  1178.   3 =>
  1179.   array (
  1180.     'ifIndex' => '3',
  1181.     'ifDescr' => 'sit0',
  1182.     'ifType' => 'tunnel',
  1183.     'ifMtu' => '1480',
  1184.     'ifSpeed' => '0',
  1185.     'ifPhysAddress' => '',
  1186.     'ifAdminStatus' => 'down',
  1187.     'ifOperStatus' => 'down',
  1188.     'ifLastChange' => '0',
  1189.     'ifInOctets' => '0',
  1190.     'ifInUcastPkts' => '0',
  1191.     'ifInNUcastPkts' => '0',
  1192.     'ifInDiscards' => '0',
  1193.     'ifInErrors' => '0',
  1194.     'ifInUnknownProtos' => '0',
  1195.     'ifOutOctets' => '0',
  1196.     'ifOutUcastPkts' => '0',
  1197.     'ifOutNUcastPkts' => '0',
  1198.     'ifOutDiscards' => '0',
  1199.     'ifOutErrors' => '0',
  1200.     'ifOutQLen' => '0',
  1201.     'ifSpecific' => 'zeroDotZero',
  1202.   ),
  1203.   4 =>
  1204.   array (
  1205.     'ifIndex' => '4',
  1206.     'ifDescr' => 'ip6tnl0',
  1207.     'ifType' => 'tunnel',
  1208.     'ifMtu' => '1452',
  1209.     'ifSpeed' => '0',
  1210.     'ifPhysAddress' => '',
  1211.     'ifAdminStatus' => 'down',
  1212.     'ifOperStatus' => 'down',
  1213.     'ifLastChange' => '0',
  1214.     'ifInOctets' => '0',
  1215.     'ifInUcastPkts' => '0',
  1216.     'ifInNUcastPkts' => '0',
  1217.     'ifInDiscards' => '0',
  1218.     'ifInErrors' => '0',
  1219.     'ifInUnknownProtos' => '0',
  1220.     'ifOutOctets' => '0',
  1221.     'ifOutUcastPkts' => '0',
  1222.     'ifOutNUcastPkts' => '0',
  1223.     'ifOutDiscards' => '0',
  1224.     'ifOutErrors' => '0',
  1225.     'ifOutQLen' => '0',
  1226.     'ifSpecific' => 'zeroDotZero',
  1227.   ),
  1228.   5 =>
  1229.   array (
  1230.     'ifIndex' => '5',
  1231.     'ifDescr' => 'Port4',
  1232.     'ifType' => 'ethernetCsmacd',
  1233.     'ifMtu' => '1500',
  1234.     'ifSpeed' => '0',
  1235.     'ifPhysAddress' => '7c:5a:1c:d8:cb:63',
  1236.     'ifAdminStatus' => 'down',
  1237.     'ifOperStatus' => 'down',
  1238.     'ifLastChange' => '0',
  1239.     'ifInOctets' => '0',
  1240.     'ifInUcastPkts' => '0',
  1241.     'ifInNUcastPkts' => '0',
  1242.     'ifInDiscards' => '0',
  1243.     'ifInErrors' => '0',
  1244.     'ifInUnknownProtos' => '0',
  1245.     'ifOutOctets' => '0',
  1246.     'ifOutUcastPkts' => '0',
  1247.     'ifOutNUcastPkts' => '0',
  1248.     'ifOutDiscards' => '0',
  1249.     'ifOutErrors' => '0',
  1250.     'ifOutQLen' => '0',
  1251.     'ifSpecific' => 'zeroDotZero',
  1252.   ),
  1253.   6 =>
  1254.   array (
  1255.     'ifIndex' => '6',
  1256.     'ifDescr' => 'Port1',
  1257.     'ifType' => 'ethernetCsmacd',
  1258.     'ifMtu' => '1500',
  1259.     'ifSpeed' => '1000000000',
  1260.     'ifPhysAddress' => '7c:5a:1c:d8:cb:60',
  1261.     'ifAdminStatus' => 'up',
  1262.     'ifOperStatus' => 'up',
  1263.     'ifLastChange' => '19641746',
  1264.     'ifInOctets' => '54416364',
  1265.     'ifInUcastPkts' => '879247321',
  1266.     'ifInNUcastPkts' => '1498943',
  1267.     'ifInDiscards' => '0',
  1268.     'ifInErrors' => '0',
  1269.     'ifInUnknownProtos' => '0',
  1270.     'ifOutOctets' => '1463792792',
  1271.     'ifOutUcastPkts' => '1211928728',
  1272.     'ifOutNUcastPkts' => '0',
  1273.     'ifOutDiscards' => '0',
  1274.     'ifOutErrors' => '0',
  1275.     'ifOutQLen' => '0',
  1276.     'ifSpecific' => 'zeroDotZero',
  1277.   ),
  1278.   7 =>
  1279.   array (
  1280.     'ifIndex' => '7',
  1281.     'ifDescr' => 'Port2',
  1282.     'ifType' => 'ethernetCsmacd',
  1283.     'ifMtu' => '1500',
  1284.     'ifSpeed' => '100000000',
  1285.     'ifPhysAddress' => '7c:5a:1c:d8:cb:61',
  1286.     'ifAdminStatus' => 'up',
  1287.     'ifOperStatus' => 'up',
  1288.     'ifLastChange' => '1402107491',
  1289.     'ifInOctets' => '110949207',
  1290.     'ifInUcastPkts' => '1721348769',
  1291.     'ifInNUcastPkts' => '1',
  1292.     'ifInDiscards' => '1',
  1293.     'ifInErrors' => '0',
  1294.     'ifInUnknownProtos' => '0',
  1295.     'ifOutOctets' => '4060966186',
  1296.     'ifOutUcastPkts' => '1046423805',
  1297.     'ifOutNUcastPkts' => '0',
  1298.     'ifOutDiscards' => '0',
  1299.     'ifOutErrors' => '0',
  1300.     'ifOutQLen' => '0',
  1301.     'ifSpecific' => 'zeroDotZero',
  1302.   ),
  1303.   8 =>
  1304.   array (
  1305.     'ifIndex' => '8',
  1306.     'ifDescr' => 'Port3',
  1307.     'ifType' => 'ethernetCsmacd',
  1308.     'ifMtu' => '1500',
  1309.     'ifSpeed' => '100000000',
  1310.     'ifPhysAddress' => '7c:5a:1c:d8:cb:62',
  1311.     'ifAdminStatus' => 'up',
  1312.     'ifOperStatus' => 'up',
  1313.     'ifLastChange' => '1152479208',
  1314.     'ifInOctets' => '3927296175',
  1315.     'ifInUcastPkts' => '244818714',
  1316.     'ifInNUcastPkts' => '66918',
  1317.     'ifInDiscards' => '0',
  1318.     'ifInErrors' => '7',
  1319.     'ifInUnknownProtos' => '0',
  1320.     'ifOutOctets' => '1216287765',
  1321.     'ifOutUcastPkts' => '438787220',
  1322.     'ifOutNUcastPkts' => '0',
  1323.     'ifOutDiscards' => '0',
  1324.     'ifOutErrors' => '0',
  1325.     'ifOutQLen' => '0',
  1326.     'ifSpecific' => 'zeroDotZero',
  1327.   ),
  1328.   9 =>
  1329.   array (
  1330.     'ifIndex' => '9',
  1331.     'ifDescr' => 'ifb0',
  1332.     'ifType' => 'ethernetCsmacd',
  1333.     'ifMtu' => '1500',
  1334.     'ifSpeed' => '0',
  1335.     'ifPhysAddress' => '76:10:4e:a6:67:bb',
  1336.     'ifAdminStatus' => 'up',
  1337.     'ifOperStatus' => 'up',
  1338.     'ifLastChange' => '0',
  1339.     'ifInOctets' => '639744849',
  1340.     'ifInUcastPkts' => '2617134357',
  1341.     'ifInNUcastPkts' => '0',
  1342.     'ifInDiscards' => '0',
  1343.     'ifInErrors' => '0',
  1344.     'ifInUnknownProtos' => '0',
  1345.     'ifOutOctets' => '639744849',
  1346.     'ifOutUcastPkts' => '2617134357',
  1347.     'ifOutNUcastPkts' => '0',
  1348.     'ifOutDiscards' => '0',
  1349.     'ifOutErrors' => '0',
  1350.     'ifOutQLen' => '0',
  1351.     'ifSpecific' => 'zeroDotZero',
  1352.   ),
  1353.   11 =>
  1354.   array (
  1355.     'ifIndex' => '11',
  1356.     'ifDescr' => 'gre0',
  1357.     'ifType' => 'tunnel',
  1358.     'ifMtu' => '1476',
  1359.     'ifSpeed' => '0',
  1360.     'ifPhysAddress' => '',
  1361.     'ifAdminStatus' => 'down',
  1362.     'ifOperStatus' => 'down',
  1363.     'ifLastChange' => '0',
  1364.     'ifInOctets' => '0',
  1365.     'ifInUcastPkts' => '0',
  1366.     'ifInNUcastPkts' => '0',
  1367.     'ifInDiscards' => '0',
  1368.     'ifInErrors' => '0',
  1369.     'ifInUnknownProtos' => '0',
  1370.     'ifOutOctets' => '0',
  1371.     'ifOutUcastPkts' => '0',
  1372.     'ifOutNUcastPkts' => '0',
  1373.     'ifOutDiscards' => '0',
  1374.     'ifOutErrors' => '0',
  1375.     'ifOutQLen' => '0',
  1376.     'ifSpecific' => 'zeroDotZero',
  1377.   ),
  1378.   12 =>
  1379.   array (
  1380.     'ifIndex' => '12',
  1381.     'ifDescr' => 'gretap0',
  1382.     'ifType' => 'ethernetCsmacd',
  1383.     'ifMtu' => '1462',
  1384.     'ifSpeed' => '0',
  1385.     'ifPhysAddress' => '',
  1386.     'ifAdminStatus' => 'down',
  1387.     'ifOperStatus' => 'down',
  1388.     'ifLastChange' => '0',
  1389.     'ifInOctets' => '0',
  1390.     'ifInUcastPkts' => '0',
  1391.     'ifInNUcastPkts' => '0',
  1392.     'ifInDiscards' => '0',
  1393.     'ifInErrors' => '0',
  1394.     'ifInUnknownProtos' => '0',
  1395.     'ifOutOctets' => '0',
  1396.     'ifOutUcastPkts' => '0',
  1397.     'ifOutNUcastPkts' => '0',
  1398.     'ifOutDiscards' => '0',
  1399.     'ifOutErrors' => '0',
  1400.     'ifOutQLen' => '0',
  1401.     'ifSpecific' => 'zeroDotZero',
  1402.   ),
  1403.   13 =>
  1404.   array (
  1405.     'ifIndex' => '13',
  1406.     'ifDescr' => 'erspan0',
  1407.     'ifType' => 'ethernetCsmacd',
  1408.     'ifMtu' => '1450',
  1409.     'ifSpeed' => '0',
  1410.     'ifPhysAddress' => '',
  1411.     'ifAdminStatus' => 'down',
  1412.     'ifOperStatus' => 'down',
  1413.     'ifLastChange' => '0',
  1414.     'ifInOctets' => '0',
  1415.     'ifInUcastPkts' => '0',
  1416.     'ifInNUcastPkts' => '0',
  1417.     'ifInDiscards' => '0',
  1418.     'ifInErrors' => '0',
  1419.     'ifInUnknownProtos' => '0',
  1420.     'ifOutOctets' => '0',
  1421.     'ifOutUcastPkts' => '0',
  1422.     'ifOutNUcastPkts' => '0',
  1423.     'ifOutDiscards' => '0',
  1424.     'ifOutErrors' => '0',
  1425.     'ifOutQLen' => '0',
  1426.     'ifSpecific' => 'zeroDotZero',
  1427.   ),
  1428.   14 =>
  1429.   array (
  1430.     'ifIndex' => '14',
  1431.     'ifDescr' => 'host0',
  1432.     'ifType' => 'ethernetCsmacd',
  1433.     'ifMtu' => '1500',
  1434.     'ifSpeed' => '0',
  1435.     'ifPhysAddress' => 'e2:98:4b:8a:7a:ae',
  1436.     'ifAdminStatus' => 'down',
  1437.     'ifOperStatus' => 'down',
  1438.     'ifLastChange' => '0',
  1439.     'ifInOctets' => '0',
  1440.     'ifInUcastPkts' => '0',
  1441.     'ifInNUcastPkts' => '0',
  1442.     'ifInDiscards' => '0',
  1443.     'ifInErrors' => '0',
  1444.     'ifInUnknownProtos' => '0',
  1445.     'ifOutOctets' => '0',
  1446.     'ifOutUcastPkts' => '0',
  1447.     'ifOutNUcastPkts' => '0',
  1448.     'ifOutDiscards' => '0',
  1449.     'ifOutErrors' => '0',
  1450.     'ifOutQLen' => '0',
  1451.     'ifSpecific' => 'zeroDotZero',
  1452.   ),
  1453.   15 =>
  1454.   array (
  1455.     'ifIndex' => '15',
  1456.     'ifDescr' => 'host1',
  1457.     'ifType' => 'ethernetCsmacd',
  1458.     'ifMtu' => '1500',
  1459.     'ifSpeed' => '0',
  1460.     'ifPhysAddress' => '5e:e9:7b:59:a5:2c',
  1461.     'ifAdminStatus' => 'down',
  1462.     'ifOperStatus' => 'down',
  1463.     'ifLastChange' => '0',
  1464.     'ifInOctets' => '0',
  1465.     'ifInUcastPkts' => '0',
  1466.     'ifInNUcastPkts' => '0',
  1467.     'ifInDiscards' => '0',
  1468.     'ifInErrors' => '0',
  1469.     'ifInUnknownProtos' => '0',
  1470.     'ifOutOctets' => '0',
  1471.     'ifOutUcastPkts' => '0',
  1472.     'ifOutNUcastPkts' => '0',
  1473.     'ifOutDiscards' => '0',
  1474.     'ifOutErrors' => '0',
  1475.     'ifOutQLen' => '0',
  1476.     'ifSpecific' => 'zeroDotZero',
  1477.   ),
  1478.   99 =>
  1479.   array (
  1480.     'ifIndex' => '99',
  1481.     'ifDescr' => 'spq',
  1482.     'ifType' => 'ethernetCsmacd',
  1483.     'ifMtu' => '1500',
  1484.     'ifSpeed' => '0',
  1485.     'ifPhysAddress' => '6:94:f:2:ee:18',
  1486.     'ifAdminStatus' => 'down',
  1487.     'ifOperStatus' => 'down',
  1488.     'ifLastChange' => '1556561242',
  1489.     'ifInOctets' => '0',
  1490.     'ifInUcastPkts' => '0',
  1491.     'ifInNUcastPkts' => '0',
  1492.     'ifInDiscards' => '0',
  1493.     'ifInErrors' => '0',
  1494.     'ifInUnknownProtos' => '0',
  1495.     'ifOutOctets' => '0',
  1496.     'ifOutUcastPkts' => '0',
  1497.     'ifOutNUcastPkts' => '0',
  1498.     'ifOutDiscards' => '0',
  1499.     'ifOutErrors' => '0',
  1500.     'ifOutQLen' => '0',
  1501.     'ifSpecific' => 'zeroDotZero',
  1502.   ),
  1503.   '1.1.3' =>
  1504.   array (
  1505.     'dot3StatsDuplexStatus' => '0.0.0.0',
  1506.   ),
  1507.   '1.1.4' =>
  1508.   array (
  1509.     'dot3StatsDuplexStatus' => '0.0.0.0',
  1510.   ),
  1511.   '1.2.3' =>
  1512.   array (
  1513.     'dot3StatsDuplexStatus' => '0.0.0.0',
  1514.   ),
  1515.   '1.2.4' =>
  1516.   array (
  1517.     'dot3StatsDuplexStatus' => '0.0.0.0',
  1518.   ),
  1519.   '1.3.3' =>
  1520.   array (
  1521.     'dot3StatsDuplexStatus' => 'halfDuplex',
  1522.   ),
  1523.   '1.3.4' =>
  1524.   array (
  1525.     'dot3StatsDuplexStatus' => 'halfDuplex',
  1526.   ),
  1527.   '1.4.3' =>
  1528.   array (
  1529.     'dot3StatsDuplexStatus' => '64',
  1530.   ),
  1531.   '1.4.4' =>
  1532.   array (
  1533.     'dot3StatsDuplexStatus' => '0',
  1534.   ),
  1535.   '1.5.3' =>
  1536.   array (
  1537.     'dot3StatsDuplexStatus' => 'unknown',
  1538.   ),
  1539.   '1.5.4' =>
  1540.   array (
  1541.     'dot3StatsDuplexStatus' => 'unknown',
  1542.   ),
  1543.   '1.6.3' =>
  1544.   array (
  1545.     'dot3StatsDuplexStatus' => '0',
  1546.   ),
  1547.   '1.6.4' =>
  1548.   array (
  1549.     'dot3StatsDuplexStatus' => '0',
  1550.   ),
  1551. )  
  1552.  valid  
  1553. SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":1131}[0m 35.31ms]
  1554.  
  1555.  valid  
  1556. SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":1132}[0m 32.96ms]
  1557.  
  1558.  valid  
  1559. SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":1133}[0m 33.05ms]
  1560.  
  1561.  valid  
  1562. SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":1134}[0m 116.46ms]
  1563.  
  1564.  valid  
  1565. SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":1135}[0m 74.57ms]
  1566.  
  1567.  valid  
  1568. SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":1136}[0m 33.04ms]
  1569.  
  1570.  valid  
  1571. SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":1137}[0m 33.02ms]
  1572.  
  1573.  valid  
  1574. SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":1138}[0m 32.98ms]
  1575.  
  1576.  valid  
  1577. SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":1139}[0m 32.99ms]
  1578.  
  1579.  valid  
  1580. SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":1140}[0m 32.95ms]
  1581.  
  1582.  valid  
  1583. SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":1141}[0m 33.01ms]
  1584.  
  1585.  valid  
  1586. SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":1142}[0m 32.94ms]
  1587.  
  1588.  valid  
  1589. SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":1143}[0m 33.01ms]
  1590.  
  1591.  valid  
  1592. SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":1144}[0m 41.38ms]
  1593.  
  1594.  valid  
  1595. SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`)  VALUES (:port_id) [0;33m{"port_id":1214}[0m 32.96ms]
  1596.  
  1597. ignored: empty ifDescr, ifAlias and ifName  
  1598. SQL[[1;33mUPDATE `ports` set `deleted`=? WHERE `port_id` = ? [0;33m["1",null][0m 0.22ms]
  1599.  
  1600. ignored: empty ifDescr, ifAlias and ifName  
  1601. ignored: empty ifDescr, ifAlias and ifName  
  1602. ignored: empty ifDescr, ifAlias and ifName  
  1603. ignored: empty ifDescr, ifAlias and ifName  
  1604. ignored: empty ifDescr, ifAlias and ifName  
  1605. ignored: empty ifDescr, ifAlias and ifName  
  1606. ignored: empty ifDescr, ifAlias and ifName  
  1607. ignored: empty ifDescr, ifAlias and ifName  
  1608. ignored: empty ifDescr, ifAlias and ifName  
  1609. ignored: empty ifDescr, ifAlias and ifName  
  1610. ignored: empty ifDescr, ifAlias and ifName  
  1611.  
  1612. Port lo: lo (1 / #1131) ifInOctets  
  1613. ifOutOctets  
  1614. ifInUcastPkts  
  1615. ifOutUcastPkts  
  1616. ifInBroadcastPkts  
  1617. ifOutBroadcastPkts  
  1618. ifInMulticastPkts  
  1619. ifOutMulticastPkts  
  1620. ifSpeed (10000000)  
  1621. VLAN =   Using ifDescr as ifAlias  
  1622.  Using ifDescr as ifName  
  1623. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1131,"interface","2021-09-14 15:54:43",3,"ifAdminStatus:  -> up",""][0m 36.24ms]
  1624.  
  1625. ifAdminStatus:  -> up  
  1626. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1131,"interface","2021-09-14 15:54:43",3,"ifMtu:  -> 65536",""][0m 32.82ms]
  1627.  
  1628. ifMtu:  -> 65536  
  1629. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1131,"interface","2021-09-14 15:54:43",3,"ifSpeed: 0 bps -> 10 Mbps",""][0m 32.78ms]
  1630.  
  1631. ifSpeed: 0 bps -> 10 Mbps  
  1632. lobps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)RRD[[0;32mtune /opt/librenms/rrd/10.180.7.1/port-id1131.rrd --maximum INOCTETS:1250000 --maximum OUTOCTETS:1250000 --maximum INERRORS:1250000 --maximum OUTERRORS:1250000 --maximum INUCASTPKTS:1250000 --maximum OUTUCASTPKTS:1250000 --maximum INNUCASTPKTS:1250000 --maximum OUTNUCASTPKTS:1250000 --maximum INDISCARDS:1250000 --maximum OUTDISCARDS:1250000 --maximum INUNKNOWNPROTOS:1250000 --maximum INBROADCASTPKTS:1250000 --maximum OUTBROADCASTPKTS:1250000 --maximum INMULTICASTPKTS:1250000 --maximum OUTMULTICASTPKTS:1250000[0m]  
  1633. SQL[[1;33mUPDATE `ports` set `ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["up","up","65536","10000000","2250756416",0,"2250756416",0,"0",0,"0",0,"612848820",0,"612848820",0,1631615082,null,1631615082,1131][0m 102.54ms]
  1634.  
  1635. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["0",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1131][0m 33.1ms]
  1636.  
  1637. 2 updated  
  1638.  
  1639. Port ipsec0: ipsec0 (2 / #1132) ifInOctets  
  1640. ifOutOctets  
  1641. ifInUcastPkts  
  1642. ifOutUcastPkts  
  1643. ifInBroadcastPkts  
  1644. ifOutBroadcastPkts  
  1645. ifInMulticastPkts  
  1646. ifOutMulticastPkts  
  1647. ifSpeed (0)  
  1648. VLAN =   Using ifDescr as ifAlias  
  1649.  Using ifDescr as ifName  
  1650. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1132,"interface","2021-09-14 15:54:43",3,"ifAdminStatus:  -> up",""][0m 32.44ms]
  1651.  
  1652. ifAdminStatus:  -> up  
  1653. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1132,"interface","2021-09-14 15:54:43",3,"ifMtu:  -> 16260",""][0m 32.85ms]
  1654.  
  1655. ifMtu:  -> 16260  
  1656. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1132,"interface","2021-09-14 15:54:43",3,"ifSpeed: 0 bps -> 0 bps",""][0m 32.86ms]
  1657.  
  1658. ifSpeed: 0 bps -> 0 bps  
  1659. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1132,"interface","2021-09-14 15:54:43",3,"ifPhysAddress:  -> 42b1fabb7da2",""][0m 32.83ms]
  1660.  
  1661. ifPhysAddress:  -> 42b1fabb7da2  
  1662. ipsec0bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifPhysAddress`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["up","up","16260","0","42b1fabb7da2","0",0,"0",0,"0",0,"0",0,"0",0,"0",0,1631615082,null,1631615082,1132][0m 32.48ms]
  1663.  
  1664. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["0",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1132][0m 33.2ms]
  1665.  
  1666. 2 updated  
  1667.  
  1668. Port sit0: sit0 (3 / #1133) ifInOctets  
  1669. ifOutOctets  
  1670. ifInUcastPkts  
  1671. ifOutUcastPkts  
  1672. ifInBroadcastPkts  
  1673. ifOutBroadcastPkts  
  1674. ifInMulticastPkts  
  1675. ifOutMulticastPkts  
  1676. ifSpeed (0)  
  1677. VLAN =   Using ifDescr as ifAlias  
  1678.  Using ifDescr as ifName  
  1679. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1133,"interface","2021-09-14 15:54:44",3,"ifAdminStatus:  -> down",""][0m 82.53ms]
  1680.  
  1681. ifAdminStatus:  -> down  
  1682. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1133,"interface","2021-09-14 15:54:44",3,"ifMtu:  -> 1480",""][0m 91.17ms]
  1683.  
  1684. ifMtu:  -> 1480  
  1685. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1133,"interface","2021-09-14 15:54:44",3,"ifSpeed: 0 bps -> 0 bps",""][0m 32.83ms]
  1686.  
  1687. ifSpeed: 0 bps -> 0 bps  
  1688. sit0bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["down","down","1480","0","0",0,"0",0,"0",0,"0",0,"0",0,"0",0,1631615082,null,1631615082,1133][0m 32.57ms]
  1689.  
  1690. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["0",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1133][0m 33.09ms]
  1691.  
  1692. 2 updated  
  1693.  
  1694. Port ip6tnl0: ip6tnl0 (4 / #1134) ifInOctets  
  1695. ifOutOctets  
  1696. ifInUcastPkts  
  1697. ifOutUcastPkts  
  1698. ifInBroadcastPkts  
  1699. ifOutBroadcastPkts  
  1700. ifInMulticastPkts  
  1701. ifOutMulticastPkts  
  1702. ifSpeed (0)  
  1703. VLAN =   Using ifDescr as ifAlias  
  1704.  Using ifDescr as ifName  
  1705. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1134,"interface","2021-09-14 15:54:44",3,"ifAdminStatus:  -> down",""][0m 32.49ms]
  1706.  
  1707. ifAdminStatus:  -> down  
  1708. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1134,"interface","2021-09-14 15:54:44",3,"ifMtu:  -> 1452",""][0m 32.8ms]
  1709.  
  1710. ifMtu:  -> 1452  
  1711. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1134,"interface","2021-09-14 15:54:44",3,"ifSpeed: 0 bps -> 0 bps",""][0m 24.57ms]
  1712.  
  1713. ifSpeed: 0 bps -> 0 bps  
  1714. ip6tnl0bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["down","down","1452","0","0",0,"0",0,"0",0,"0",0,"0",0,"0",0,1631615082,null,1631615082,1134][0m 24.2ms]
  1715.  
  1716. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["0",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1134][0m 24.73ms]
  1717.  
  1718. 2 updated  
  1719.  
  1720. Port Port4: Port4 (5 / #1135) ifInOctets  
  1721. ifOutOctets  
  1722. ifInUcastPkts  
  1723. ifOutUcastPkts  
  1724. ifInBroadcastPkts  
  1725. ifOutBroadcastPkts  
  1726. ifInMulticastPkts  
  1727. ifOutMulticastPkts  
  1728. ifSpeed (0)  
  1729. VLAN =   Using ifDescr as ifAlias  
  1730.  Using ifDescr as ifName  
  1731. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1135,"interface","2021-09-14 15:54:44",3,"ifAdminStatus:  -> down",""][0m 24.15ms]
  1732.  
  1733. ifAdminStatus:  -> down  
  1734. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1135,"interface","2021-09-14 15:54:44",3,"ifMtu:  -> 1500",""][0m 24.54ms]
  1735.  
  1736. ifMtu:  -> 1500  
  1737. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1135,"interface","2021-09-14 15:54:44",3,"ifSpeed: 0 bps -> 0 bps",""][0m 24.53ms]
  1738.  
  1739. ifSpeed: 0 bps -> 0 bps  
  1740. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1135,"interface","2021-09-14 15:54:44",3,"ifPhysAddress:  -> 7c5a1cd8cb63",""][0m 24.47ms]
  1741.  
  1742. ifPhysAddress:  -> 7c5a1cd8cb63  
  1743. Port4bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifPhysAddress`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["down","down","1500","0","7c5a1cd8cb63","0",0,"0",0,"0",0,"0",0,"0",0,"0",0,1631615082,null,1631615082,1135][0m 24.17ms]
  1744.  
  1745. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["0",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1135][0m 24.8ms]
  1746.  
  1747. 2 updated  
  1748.  
  1749. Port Port1: Port1 (6 / #1136) ifInOctets  
  1750. ifOutOctets  
  1751. ifInUcastPkts  
  1752. ifOutUcastPkts  
  1753. ifInBroadcastPkts  
  1754. ifOutBroadcastPkts  
  1755. ifInMulticastPkts  
  1756. ifOutMulticastPkts  
  1757. ifSpeed (1000000000)  
  1758. VLAN =   Using ifDescr as ifAlias  
  1759.  Using ifDescr as ifName  
  1760. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1136,"interface","2021-09-14 15:54:44",3,"ifAdminStatus:  -> up",""][0m 24.13ms]
  1761.  
  1762. ifAdminStatus:  -> up  
  1763. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1136,"interface","2021-09-14 15:54:44",3,"ifMtu:  -> 1500",""][0m 141.05ms]
  1764.  
  1765. ifMtu:  -> 1500  
  1766. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1136,"interface","2021-09-14 15:54:44",3,"ifSpeed: 0 bps -> 1 Gbps",""][0m 141.04ms]
  1767.  
  1768. ifSpeed: 0 bps -> 1 Gbps  
  1769. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1136,"interface","2021-09-14 15:54:44",3,"ifPhysAddress:  -> 7c5a1cd8cb60",""][0m 24.52ms]
  1770.  
  1771. ifPhysAddress:  -> 7c5a1cd8cb60  
  1772. Port1bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)RRD[[0;32mtune /opt/librenms/rrd/10.180.7.1/port-id1136.rrd --maximum INOCTETS:125000000 --maximum OUTOCTETS:125000000 --maximum INERRORS:125000000 --maximum OUTERRORS:125000000 --maximum INUCASTPKTS:125000000 --maximum OUTUCASTPKTS:125000000 --maximum INNUCASTPKTS:125000000 --maximum OUTNUCASTPKTS:125000000 --maximum INDISCARDS:125000000 --maximum OUTDISCARDS:125000000 --maximum INUNKNOWNPROTOS:125000000 --maximum INBROADCASTPKTS:125000000 --maximum OUTBROADCASTPKTS:125000000 --maximum INMULTICASTPKTS:125000000 --maximum OUTMULTICASTPKTS:125000000[0m]  
  1773. SQL[[1;33mUPDATE `ports` set `ifLastChange`=?,`ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifPhysAddress`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["19641746","up","up","1500","1000000000","7c5a1cd8cb60","54416364",0,"1463792792",0,"0",0,"0",0,"879247321",0,"1211928728",0,1631615082,null,1631615082,1136][0m 24.06ms]
  1774.  
  1775. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["1498943",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1136][0m 24.75ms]
  1776.  
  1777. 2 updated  
  1778.  
  1779. Port Port2: Port2 (7 / #1137) ifInOctets  
  1780. ifOutOctets  
  1781. ifInUcastPkts  
  1782. ifOutUcastPkts  
  1783. ifInBroadcastPkts  
  1784. ifOutBroadcastPkts  
  1785. ifInMulticastPkts  
  1786. ifOutMulticastPkts  
  1787. ifSpeed (100000000)  
  1788. VLAN =   Using ifDescr as ifAlias  
  1789.  Using ifDescr as ifName  
  1790. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1137,"interface","2021-09-14 15:54:44",3,"ifAdminStatus:  -> up",""][0m 24.11ms]
  1791.  
  1792. ifAdminStatus:  -> up  
  1793. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1137,"interface","2021-09-14 15:54:44",3,"ifMtu:  -> 1500",""][0m 24.53ms]
  1794.  
  1795. ifMtu:  -> 1500  
  1796. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1137,"interface","2021-09-14 15:54:45",3,"ifSpeed: 0 bps -> 100 Mbps",""][0m 24.5ms]
  1797.  
  1798. ifSpeed: 0 bps -> 100 Mbps  
  1799. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1137,"interface","2021-09-14 15:54:45",3,"ifPhysAddress:  -> 7c5a1cd8cb61",""][0m 24.57ms]
  1800.  
  1801. ifPhysAddress:  -> 7c5a1cd8cb61  
  1802. Port2bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)RRD[[0;32mtune /opt/librenms/rrd/10.180.7.1/port-id1137.rrd --maximum INOCTETS:12500000 --maximum OUTOCTETS:12500000 --maximum INERRORS:12500000 --maximum OUTERRORS:12500000 --maximum INUCASTPKTS:12500000 --maximum OUTUCASTPKTS:12500000 --maximum INNUCASTPKTS:12500000 --maximum OUTNUCASTPKTS:12500000 --maximum INDISCARDS:12500000 --maximum OUTDISCARDS:12500000 --maximum INUNKNOWNPROTOS:12500000 --maximum INBROADCASTPKTS:12500000 --maximum OUTBROADCASTPKTS:12500000 --maximum INMULTICASTPKTS:12500000 --maximum OUTMULTICASTPKTS:12500000[0m]  
  1803. SQL[[1;33mUPDATE `ports` set `ifLastChange`=?,`ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifPhysAddress`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["1402107491","up","up","1500","100000000","7c5a1cd8cb61","110949207",0,"4060966186",0,"0",0,"0",0,"1721348769",0,"1046423805",0,1631615082,null,1631615082,1137][0m 24.06ms]
  1804.  
  1805. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["1",0,"0",0,"1",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1137][0m 26.08ms]
  1806.  
  1807. 2 updated  
  1808.  
  1809. Port Port3: Port3 (8 / #1138) ifInOctets  
  1810. ifOutOctets  
  1811. ifInUcastPkts  
  1812. ifOutUcastPkts  
  1813. ifInBroadcastPkts  
  1814. ifOutBroadcastPkts  
  1815. ifInMulticastPkts  
  1816. ifOutMulticastPkts  
  1817. ifSpeed (100000000)  
  1818. VLAN =   Using ifDescr as ifAlias  
  1819.  Using ifDescr as ifName  
  1820. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1138,"interface","2021-09-14 15:54:45",3,"ifAdminStatus:  -> up",""][0m 24.04ms]
  1821.  
  1822. ifAdminStatus:  -> up  
  1823. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1138,"interface","2021-09-14 15:54:45",3,"ifMtu:  -> 1500",""][0m 24.53ms]
  1824.  
  1825. ifMtu:  -> 1500  
  1826. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1138,"interface","2021-09-14 15:54:45",3,"ifSpeed: 0 bps -> 100 Mbps",""][0m 49.56ms]
  1827.  
  1828. ifSpeed: 0 bps -> 100 Mbps  
  1829. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1138,"interface","2021-09-14 15:54:45",3,"ifPhysAddress:  -> 7c5a1cd8cb62",""][0m 24.6ms]
  1830.  
  1831. ifPhysAddress:  -> 7c5a1cd8cb62  
  1832. Port3bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)RRD[[0;32mtune /opt/librenms/rrd/10.180.7.1/port-id1138.rrd --maximum INOCTETS:12500000 --maximum OUTOCTETS:12500000 --maximum INERRORS:12500000 --maximum OUTERRORS:12500000 --maximum INUCASTPKTS:12500000 --maximum OUTUCASTPKTS:12500000 --maximum INNUCASTPKTS:12500000 --maximum OUTNUCASTPKTS:12500000 --maximum INDISCARDS:12500000 --maximum OUTDISCARDS:12500000 --maximum INUNKNOWNPROTOS:12500000 --maximum INBROADCASTPKTS:12500000 --maximum OUTBROADCASTPKTS:12500000 --maximum INMULTICASTPKTS:12500000 --maximum OUTMULTICASTPKTS:12500000[0m]  
  1833. SQL[[1;33mUPDATE `ports` set `ifLastChange`=?,`ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifPhysAddress`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["1152479208","up","up","1500","100000000","7c5a1cd8cb62","3927296175",0,"1216287765",0,"7",0,"0",0,"244818714",0,"438787220",0,1631615082,null,1631615082,1138][0m 24.01ms]
  1834.  
  1835. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["66918",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1138][0m 24.76ms]
  1836.  
  1837. 2 updated  
  1838.  
  1839. Port ifb0: ifb0 (9 / #1139) ifInOctets  
  1840. ifOutOctets  
  1841. ifInUcastPkts  
  1842. ifOutUcastPkts  
  1843. ifInBroadcastPkts  
  1844. ifOutBroadcastPkts  
  1845. ifInMulticastPkts  
  1846. ifOutMulticastPkts  
  1847. ifSpeed (0)  
  1848. VLAN =   Using ifDescr as ifAlias  
  1849.  Using ifDescr as ifName  
  1850. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1139,"interface","2021-09-14 15:54:45",3,"ifAdminStatus:  -> up",""][0m 32.48ms]
  1851.  
  1852. ifAdminStatus:  -> up  
  1853. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1139,"interface","2021-09-14 15:54:45",3,"ifMtu:  -> 1500",""][0m 24.5ms]
  1854.  
  1855. ifMtu:  -> 1500  
  1856. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1139,"interface","2021-09-14 15:54:45",3,"ifSpeed: 0 bps -> 0 bps",""][0m 32.81ms]
  1857.  
  1858. ifSpeed: 0 bps -> 0 bps  
  1859. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1139,"interface","2021-09-14 15:54:45",3,"ifPhysAddress:  -> 76104ea667bb",""][0m 32.87ms]
  1860.  
  1861. ifPhysAddress:  -> 76104ea667bb  
  1862. ifb0bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifPhysAddress`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["up","up","1500","0","76104ea667bb","639744849",0,"639744849",0,"0",0,"0",0,"2617134357",0,"2617134357",0,1631615082,null,1631615082,1139][0m 32.5ms]
  1863.  
  1864. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["0",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1139][0m 33.09ms]
  1865.  
  1866. 2 updated  
  1867.  
  1868. Port gre0: gre0 (11 / #1140) ifInOctets  
  1869. ifOutOctets  
  1870. ifInUcastPkts  
  1871. ifOutUcastPkts  
  1872. ifInBroadcastPkts  
  1873. ifOutBroadcastPkts  
  1874. ifInMulticastPkts  
  1875. ifOutMulticastPkts  
  1876. ifSpeed (0)  
  1877. VLAN =   Using ifDescr as ifAlias  
  1878.  Using ifDescr as ifName  
  1879. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1140,"interface","2021-09-14 15:54:45",3,"ifAdminStatus:  -> down",""][0m 32.38ms]
  1880.  
  1881. ifAdminStatus:  -> down  
  1882. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1140,"interface","2021-09-14 15:54:45",3,"ifMtu:  -> 1476",""][0m 32.82ms]
  1883.  
  1884. ifMtu:  -> 1476  
  1885. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1140,"interface","2021-09-14 15:54:45",3,"ifSpeed: 0 bps -> 0 bps",""][0m 32.86ms]
  1886.  
  1887. ifSpeed: 0 bps -> 0 bps  
  1888. gre0bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["down","down","1476","0","0",0,"0",0,"0",0,"0",0,"0",0,"0",0,1631615082,null,1631615082,1140][0m 32.5ms]
  1889.  
  1890. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["0",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1140][0m 33.11ms]
  1891.  
  1892. 2 updated  
  1893.  
  1894. Port gretap0: gretap0 (12 / #1141) ifInOctets  
  1895. ifOutOctets  
  1896. ifInUcastPkts  
  1897. ifOutUcastPkts  
  1898. ifInBroadcastPkts  
  1899. ifOutBroadcastPkts  
  1900. ifInMulticastPkts  
  1901. ifOutMulticastPkts  
  1902. ifSpeed (0)  
  1903. VLAN =   Using ifDescr as ifAlias  
  1904.  Using ifDescr as ifName  
  1905. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1141,"interface","2021-09-14 15:54:45",3,"ifAdminStatus:  -> down",""][0m 32.4ms]
  1906.  
  1907. ifAdminStatus:  -> down  
  1908. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1141,"interface","2021-09-14 15:54:45",3,"ifMtu:  -> 1462",""][0m 32.87ms]
  1909.  
  1910. ifMtu:  -> 1462  
  1911. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1141,"interface","2021-09-14 15:54:45",3,"ifSpeed: 0 bps -> 0 bps",""][0m 32.78ms]
  1912.  
  1913. ifSpeed: 0 bps -> 0 bps  
  1914. gretap0bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["down","down","1462","0","0",0,"0",0,"0",0,"0",0,"0",0,"0",0,1631615082,null,1631615082,1141][0m 32.47ms]
  1915.  
  1916. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["0",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1141][0m 33.13ms]
  1917.  
  1918. 2 updated  
  1919.  
  1920. Port erspan0: erspan0 (13 / #1142) ifInOctets  
  1921. ifOutOctets  
  1922. ifInUcastPkts  
  1923. ifOutUcastPkts  
  1924. ifInBroadcastPkts  
  1925. ifOutBroadcastPkts  
  1926. ifInMulticastPkts  
  1927. ifOutMulticastPkts  
  1928. ifSpeed (0)  
  1929. VLAN =   Using ifDescr as ifAlias  
  1930.  Using ifDescr as ifName  
  1931. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1142,"interface","2021-09-14 15:54:45",3,"ifAdminStatus:  -> down",""][0m 32.33ms]
  1932.  
  1933. ifAdminStatus:  -> down  
  1934. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1142,"interface","2021-09-14 15:54:45",3,"ifMtu:  -> 1450",""][0m 32.86ms]
  1935.  
  1936. ifMtu:  -> 1450  
  1937. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1142,"interface","2021-09-14 15:54:45",3,"ifSpeed: 0 bps -> 0 bps",""][0m 32.86ms]
  1938.  
  1939. ifSpeed: 0 bps -> 0 bps  
  1940. erspan0bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["down","down","1450","0","0",0,"0",0,"0",0,"0",0,"0",0,"0",0,1631615082,null,1631615082,1142][0m 32.39ms]
  1941.  
  1942. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["0",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1142][0m 33.11ms]
  1943.  
  1944. 2 updated  
  1945.  
  1946. Port host0: host0 (14 / #1143) ifInOctets  
  1947. ifOutOctets  
  1948. ifInUcastPkts  
  1949. ifOutUcastPkts  
  1950. ifInBroadcastPkts  
  1951. ifOutBroadcastPkts  
  1952. ifInMulticastPkts  
  1953. ifOutMulticastPkts  
  1954. ifSpeed (0)  
  1955. VLAN =   Using ifDescr as ifAlias  
  1956.  Using ifDescr as ifName  
  1957. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1143,"interface","2021-09-14 15:54:45",3,"ifAdminStatus:  -> down",""][0m 32.45ms]
  1958.  
  1959. ifAdminStatus:  -> down  
  1960. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1143,"interface","2021-09-14 15:54:46",3,"ifMtu:  -> 1500",""][0m 32.83ms]
  1961.  
  1962. ifMtu:  -> 1500  
  1963. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1143,"interface","2021-09-14 15:54:46",3,"ifSpeed: 0 bps -> 0 bps",""][0m 32.84ms]
  1964.  
  1965. ifSpeed: 0 bps -> 0 bps  
  1966. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1143,"interface","2021-09-14 15:54:46",3,"ifPhysAddress:  -> e2984b8a7aae",""][0m 32.89ms]
  1967.  
  1968. ifPhysAddress:  -> e2984b8a7aae  
  1969. host0bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifPhysAddress`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["down","down","1500","0","e2984b8a7aae","0",0,"0",0,"0",0,"0",0,"0",0,"0",0,1631615082,null,1631615082,1143][0m 32.48ms]
  1970.  
  1971. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["0",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1143][0m 33.11ms]
  1972.  
  1973. 2 updated  
  1974.  
  1975. Port host1: host1 (15 / #1144) ifInOctets  
  1976. ifOutOctets  
  1977. ifInUcastPkts  
  1978. ifOutUcastPkts  
  1979. ifInBroadcastPkts  
  1980. ifOutBroadcastPkts  
  1981. ifInMulticastPkts  
  1982. ifOutMulticastPkts  
  1983. ifSpeed (0)  
  1984. VLAN =   Using ifDescr as ifAlias  
  1985.  Using ifDescr as ifName  
  1986. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1144,"interface","2021-09-14 15:54:46",3,"ifAdminStatus:  -> down",""][0m 32.47ms]
  1987.  
  1988. ifAdminStatus:  -> down  
  1989. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1144,"interface","2021-09-14 15:54:46",3,"ifMtu:  -> 1500",""][0m 66.23ms]
  1990.  
  1991. ifMtu:  -> 1500  
  1992. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1144,"interface","2021-09-14 15:54:46",3,"ifSpeed: 0 bps -> 0 bps",""][0m 32.84ms]
  1993.  
  1994. ifSpeed: 0 bps -> 0 bps  
  1995. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1144,"interface","2021-09-14 15:54:46",3,"ifPhysAddress:  -> 5ee97b59a52c",""][0m 32.84ms]
  1996.  
  1997. ifPhysAddress:  -> 5ee97b59a52c  
  1998. host1bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifPhysAddress`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["down","down","1500","0","5ee97b59a52c","0",0,"0",0,"0",0,"0",0,"0",0,"0",0,1631615082,null,1631615082,1144][0m 32.54ms]
  1999.  
  2000. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["0",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1144][0m 33.13ms]
  2001.  
  2002. 2 updated  
  2003.  
  2004. SQL[[1;33mUPDATE `ports` set `deleted`=? WHERE `device_id` = ? AND `port_id` = ? [0;33m["1",61,1145][0m 33.06ms]
  2005.  
  2006. Port spq: spq (96 / #1145) deleted.
  2007. Port spq: spq (99 / #1214) ifInOctets  
  2008. ifOutOctets  
  2009. ifInUcastPkts  
  2010. ifOutUcastPkts  
  2011. ifInBroadcastPkts  
  2012. ifOutBroadcastPkts  
  2013. ifInMulticastPkts  
  2014. ifOutMulticastPkts  
  2015. ifSpeed (0)  
  2016. VLAN =   Using ifDescr as ifAlias  
  2017.  Using ifDescr as ifName  
  2018. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1214,"interface","2021-09-14 15:54:46",3,"ifAdminStatus:  -> down",""][0m 257.29ms]
  2019.  
  2020. ifAdminStatus:  -> down  
  2021. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1214,"interface","2021-09-14 15:54:46",3,"ifMtu:  -> 1500",""][0m 32.76ms]
  2022.  
  2023. ifMtu:  -> 1500  
  2024. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1214,"interface","2021-09-14 15:54:46",3,"ifSpeed: 0 bps -> 0 bps",""][0m 32.84ms]
  2025.  
  2026. ifSpeed: 0 bps -> 0 bps  
  2027. SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1214,"interface","2021-09-14 15:54:46",3,"ifPhysAddress:  -> 06940f02ee18",""][0m 32.9ms]
  2028.  
  2029. ifPhysAddress:  -> 06940f02ee18  
  2030. spqbps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifLastChange`=?,`ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifPhysAddress`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["1556561242","down","down","1500","0","06940f02ee18","0",0,"0",0,"0",0,"0",0,"0",0,"0",0,1631615082,null,1631615082,1214][0m 31.99ms]
  2031.  
  2032. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["0",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1214][0m 33.1ms]
  2033.  
  2034. 2 updated  
  2035.  
  2036. SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1631615082,null,1631615082][0m 0.21ms]
  2037.  
  2038. 0 updated  
  2039.  
  2040. >> Runtime for poller module 'ports': 15.8551 seconds with 394808 bytes
  2041. >> SNMP: [4/11.87s] MySQL: [48/1.65s]
  2042. #### Unload poller module ports ####
  2043.  
  2044. Modules status: Global+  
  2045. OS  
  2046. Device  
  2047.  
  2048. #### Load poller module customoid ####
  2049. SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[61][0m 0.44ms]
  2050.  
  2051.  
  2052. >> Runtime for poller module 'customoid': 0.0152 seconds with 2448 bytes
  2053. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  2054. #### Unload poller module customoid ####
  2055.  
  2056. Modules status: Global+  
  2057. OS  
  2058. Device  
  2059.  
  2060. #### Load poller module bgp-peers ####
  2061. 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[61][0m 0.58ms]
  2062.  
  2063.  
  2064. >> Runtime for poller module 'bgp-peers': 0.0070 seconds with 15152 bytes
  2065. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  2066. #### Unload poller module bgp-peers ####
  2067.  
  2068. Modules status: Global-  
  2069. OS  
  2070. Device  
  2071. Module [ junose-atm-vp ] disabled globally.
  2072.  
  2073. Modules status: Global-  
  2074. OS  
  2075. Device  
  2076. Module [ printer-supplies ] disabled globally.
  2077.  
  2078. Modules status: Global+  
  2079. OS  
  2080. Device  
  2081.  
  2082. #### Load poller module ucd-diskio ####
  2083. SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id`  = ? [0;33m[61][0m 0.51ms]
  2084.  
  2085.  
  2086. >> Runtime for poller module 'ucd-diskio': 0.0101 seconds with 1944 bytes
  2087. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  2088. #### Unload poller module ucd-diskio ####
  2089.  
  2090. Modules status: Global-  
  2091. OS  
  2092. Device  
  2093. Module [ wifi ] disabled globally.
  2094.  
  2095. Modules status: Global+  
  2096. OS  
  2097. Device  
  2098.  
  2099. #### Load poller module wireless ####
  2100. Attempting to initialize OS: sophos-xg  
  2101. Attempting to initialize OS: sophos  
  2102. OS initialized as Generic  
  2103. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[61][0m 0.7ms]
  2104.  
  2105.  
  2106. >> Runtime for poller module 'wireless': 0.0052 seconds with 104248 bytes
  2107. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  2108. #### Unload poller module wireless ####
  2109.  
  2110. Modules status: Global+  
  2111. OS  
  2112. Device  
  2113.  
  2114. #### Load poller module ospf ####
  2115. SQL[[1;33mselect * from `vrf_lite_cisco` where `vrf_lite_cisco`.`device_id` = ? and `vrf_lite_cisco`.`device_id` is not null [0;33m[61][0m 0.28ms]
  2116.  
  2117.  Processes: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'OSPF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfGeneralGroup'[0m]
  2118. ospfGeneralGroup = No Such Object available on this agent at this OID  
  2119.  
  2120. Invalid snmp_walk() data = ospfGeneralGroup = No Such Object available on this agent at this OID  
  2121. array (
  2122. )  
  2123. SQL[[1;33mdelete from `ospf_instances` where (`device_id` = ? and `context_name` = ?) and 1 = 1 [0;33m[61,""][0m 0.54ms]
  2124.  
  2125. 0
  2126. >> Runtime for poller module 'ospf': 0.1734 seconds with 55400 bytes
  2127. >> SNMP: [1/0.16s] MySQL: [0/0.00s]
  2128. #### Unload poller module ospf ####
  2129.  
  2130. Modules status: Global-  
  2131. OS  
  2132. Device  
  2133. Module [ isis ] disabled globally.
  2134.  
  2135. Modules status: Global-  
  2136. OS  
  2137. Device  
  2138. Module [ cisco-ipsec-flow-monitor ] disabled globally.
  2139.  
  2140. Modules status: Global-  
  2141. OS  
  2142. Device  
  2143. Module [ cisco-remote-access-monitor ] disabled globally.
  2144.  
  2145. Modules status: Global-  
  2146. OS  
  2147. Device  
  2148. Module [ cisco-cef ] disabled globally.
  2149.  
  2150. Modules status: Global-  
  2151. OS  
  2152. Device  
  2153. Module [ slas ] disabled globally.
  2154.  
  2155. Modules status: Global-  
  2156. OS  
  2157. Device  
  2158. Module [ cisco-mac-accounting ] disabled globally.
  2159.  
  2160. Modules status: Global-  
  2161. OS  
  2162. Device  
  2163. Module [ cipsec-tunnels ] disabled globally.
  2164.  
  2165. Modules status: Global-  
  2166. OS  
  2167. Device  
  2168. Module [ cisco-ace-loadbalancer ] disabled globally.
  2169.  
  2170. Modules status: Global-  
  2171. OS  
  2172. Device  
  2173. Module [ cisco-ace-serverfarms ] disabled globally.
  2174.  
  2175. Modules status: Global-  
  2176. OS  
  2177. Device  
  2178. Module [ cisco-asa-firewall ] disabled globally.
  2179.  
  2180. Modules status: Global-  
  2181. OS  
  2182. Device  
  2183. Module [ cisco-voice ] disabled globally.
  2184.  
  2185. Modules status: Global-  
  2186. OS  
  2187. Device  
  2188. Module [ cisco-cbqos ] disabled globally.
  2189.  
  2190. Modules status: Global-  
  2191. OS  
  2192. Device  
  2193. Module [ cisco-otv ] disabled globally.
  2194.  
  2195. Modules status: Global-  
  2196. OS  
  2197. Device  
  2198. Module [ cisco-qfp ] disabled globally.
  2199.  
  2200. Modules status: Global-  
  2201. OS  
  2202. Device  
  2203. Module [ cisco-vpdn ] disabled globally.
  2204.  
  2205. Modules status: Global-  
  2206. OS  
  2207. Device  
  2208. Module [ nac ] disabled globally.
  2209.  
  2210. Modules status: Global-  
  2211. OS  
  2212. Device  
  2213. Module [ netscaler-vsvr ] disabled globally.
  2214.  
  2215. Modules status: Global-  
  2216. OS  
  2217. Device  
  2218. Module [ aruba-controller ] disabled globally.
  2219.  
  2220. Modules status: Global+  
  2221. OS  
  2222. Device  
  2223.  
  2224. #### Load poller module entity-physical ####
  2225. SQL[[1;33mSELECT * FROM `entPhysical_state` WHERE `device_id` = ? [0;33m[61][0m 0.49ms]
  2226.  
  2227.  
  2228. >> Runtime for poller module 'entity-physical': 0.0216 seconds with 2152 bytes
  2229. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  2230. #### Unload poller module entity-physical ####
  2231.  
  2232. Modules status: Global-  
  2233. OS  
  2234. Device  
  2235. Module [ entity-state ] disabled globally.
  2236.  
  2237. Modules status: Global+  
  2238. OS  
  2239. Device  
  2240.  
  2241. #### Load poller module applications ####
  2242. SQL[[1;33mSELECT * FROM `applications` WHERE `device_id`  = ? [0;33m[61][0m 0.44ms]
  2243.  
  2244.  
  2245. >> Runtime for poller module 'applications': 0.0054 seconds with 1592 bytes
  2246. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  2247. #### Unload poller module applications ####
  2248.  
  2249. Modules status: Global-  
  2250. OS  
  2251. Device  
  2252. Module [ mib ] disabled globally.
  2253.  
  2254. Modules status: Global+  
  2255. OS  
  2256. Device  
  2257.  
  2258. #### Load poller module stp ####
  2259. SQL[[1;33mSELECT * FROM `stp` WHERE `device_id` = ? [0;33m[61][0m 0.27ms]
  2260.  
  2261. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-m' 'RSTP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'dot1dStpProtocolSpecification.0'[0m]
  2262. No Such Object available on this agent at this OID  
  2263.  
  2264.  
  2265.  
  2266. >> Runtime for poller module 'stp': 0.0944 seconds with 5400 bytes
  2267. >> SNMP: [1/0.08s] MySQL: [1/0.00s]
  2268. #### Unload poller module stp ####
  2269.  
  2270. Modules status: Global+  
  2271. OS  
  2272. Device  
  2273.  
  2274. #### Load poller module ntp ####
  2275.  
  2276. >> Runtime for poller module 'ntp': 0.0443 seconds with 400 bytes
  2277. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
  2278. #### Unload poller module ntp ####
  2279.  
  2280. Modules status: Global-  
  2281. OS  
  2282. Device  
  2283. Module [ loadbalancers ] disabled globally.
  2284.  
  2285. Modules status: Global-  
  2286. OS  
  2287. Device  
  2288. Module [ mef ] disabled globally.
  2289.  
  2290. Modules status: Global+  
  2291. OS  
  2292. Device  
  2293.  
  2294. #### Load poller module mpls ####
  2295.  
  2296. >> Runtime for poller module 'mpls': 0.0054 seconds with 89648 bytes
  2297. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
  2298. #### Unload poller module mpls ####
  2299.  
  2300. Enabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[61][0m 0.66ms]
  2301.  
  2302. SQL[[1;33minsert into `device_graphs` (`graph`, `device_id`) values (?, ?) [0;33m["uptime",61][0m 108.38ms]
  2303.  
  2304. +SQL[[1;33minsert into `device_graphs` (`graph`, `device_id`) values (?, ?) [0;33m["poller_perf",61][0m 66.21ms]
  2305.  
  2306. +SQL[[1;33minsert into `device_graphs` (`graph`, `device_id`) values (?, ?) [0;33m["availability",61][0m 49.61ms]
  2307.  
  2308. +SQL[[1;33minsert into `device_graphs` (`graph`, `device_id`) values (?, ?) [0;33m["netstat_icmp",61][0m 32.88ms]
  2309.  
  2310. +SQL[[1;33minsert into `device_graphs` (`graph`, `device_id`) values (?, ?) [0;33m["netstat_icmp_info",61][0m 66.24ms]
  2311.  
  2312. +SQL[[1;33minsert into `device_graphs` (`graph`, `device_id`) values (?, ?) [0;33m["netstat_ip",61][0m 33.07ms]
  2313.  
  2314. +SQL[[1;33minsert into `device_graphs` (`graph`, `device_id`) values (?, ?) [0;33m["netstat_ip_frag",61][0m 91.22ms]
  2315.  
  2316. +SQL[[1;33minsert into `device_graphs` (`graph`, `device_id`) values (?, ?) [0;33m["netstat_snmp",61][0m 49.56ms]
  2317.  
  2318. +SQL[[1;33minsert into `device_graphs` (`graph`, `device_id`) values (?, ?) [0;33m["netstat_snmp_pkt",61][0m 49.67ms]
  2319.  
  2320. +SQL[[1;33minsert into `device_graphs` (`graph`, `device_id`) values (?, ?) [0;33m["netstat_tcp",61][0m 57.91ms]
  2321.  
  2322. +SQL[[1;33minsert into `device_graphs` (`graph`, `device_id`) values (?, ?) [0;33m["netstat_udp",61][0m 91.22ms]
  2323.  
  2324. +SQL[[1;33minsert into `device_graphs` (`graph`, `device_id`) values (?, ?) [0;33m["hr_users",61][0m 57.91ms]
  2325.  
  2326. +SQL[[1;33minsert into `device_graphs` (`graph`, `device_id`) values (?, ?) [0;33m["ping_perf",61][0m 24.62ms]
  2327.  
  2328. +SQL[[1;33minsert into `device_graphs` (`graph`, `device_id`) values (?, ?) [0;33m["poller_modules_perf",61][0m 24.66ms]
  2329.  
  2330. +
  2331. SQL[[1;33mUPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=?,`last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[15658859,70.4,44.684,61][0m 24.74ms]
  2332.  
  2333. Updating 10.180.7.1  
  2334.  
  2335. Polled in 44.684 seconds
  2336. ### Start Device Groups ###
  2337. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[61][0m 50.14ms]
  2338.  
  2339. SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.2ms]
  2340.  
  2341. SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[61][0m 0.36ms]
  2342.  
  2343. Groups Added:  
  2344. Groups Removed:  
  2345. ### End Device Groups, runtime: 0.0521s ###
  2346.  
  2347. #### Start Alerts ####
  2348. 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-09-14T10:24:48.156378Z","2021-09-14T10:24:48.156378Z",0,1,"10:24:48","10:24:48","10:24:48","10:24:48","[42m%","device",61,"location",3][0m 1.1ms]
  2349.  
  2350. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[61][0m 0.36ms]
  2351.  
  2352. SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a
  2353.         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 = ?)
  2354.         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 = ?))
  2355.         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 = ?))
  2356.         LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
  2357.         WHERE a.disabled = 0 AND (
  2358.             (d.device_id IS NULL AND g.group_id IS NULL)
  2359.             OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=?))
  2360.             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))
  2361.         ) [0;33m[61,61,61,61,61,61,61,61][0m 1.83ms]
  2362.  
  2363. Rule [0;35m#7 (Device Down! Due to no ICMP response.):[0m  
  2364. 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" [0;33m[61][0m 0.56ms]
  2365.  
  2366. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[7,61][0m 0.31ms]
  2367.  
  2368. SQL[[1;33mINSERT IGNORE INTO `alert_log` (`state`,`device_id`,`rule_id`)  VALUES (:state,:device_id,:rule_id) [0;33m{"state":0,"device_id":61,"rule_id":7}[0m 23.6ms]
  2369.  
  2370. SQL[[1;33mINSERT IGNORE INTO `alerts` (`state`,`device_id`,`rule_id`,`open`,`alerted`)  VALUES (:state,:device_id,:rule_id,:open,:alerted) [0;33m{"state":0,"device_id":61,"rule_id":7,"open":1,"alerted":0}[0m 24.83ms]
  2371.  
  2372.  
  2373. Status: [0;32mOK[0m
  2374. Rule [0;35m#8 (SNMP not responding on Device - Check on SNMP Service - Device marked Down!):[0m  
  2375. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND devices.status_reason = "snmp" [0;33m[61][0m 0.6ms]
  2376.  
  2377. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[8,61][0m 0.34ms]
  2378.  
  2379. SQL[[1;33mINSERT IGNORE INTO `alert_log` (`state`,`device_id`,`rule_id`)  VALUES (:state,:device_id,:rule_id) [0;33m{"state":0,"device_id":61,"rule_id":8}[0m 23.37ms]
  2380.  
  2381. SQL[[1;33mINSERT IGNORE INTO `alerts` (`state`,`device_id`,`rule_id`,`open`,`alerted`)  VALUES (:state,:device_id,:rule_id,:open,:alerted) [0;33m{"state":0,"device_id":61,"rule_id":8,"open":1,"alerted":0}[0m 149.7ms]
  2382.  
  2383.  
  2384. Status: [0;32mOK[0m
  2385. Rule [0;35m#9 (Device rebooted):[0m  
  2386. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND devices.uptime < 300 xss=removed 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> 10 [0;33m[61][0m 0.63ms]
  2387.  
  2388. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[11,61][0m 0.28ms]
  2389.  
  2390. SQL[[1;33mINSERT IGNORE INTO `alert_log` (`state`,`device_id`,`rule_id`,`details`)  VALUES (:state,:device_id,:rule_id,:details) [0;33m[0m 23.15ms]
  2391.  
  2392. SQL[[1;33mINSERT IGNORE INTO `alerts` (`state`,`device_id`,`rule_id`,`open`,`alerted`)  VALUES (:state,:device_id,:rule_id,:open,:alerted) [0;33m{"state":1,"device_id":61,"rule_id":11,"open":1,"alerted":0}[0m 24.85ms]
  2393.  
  2394.  
  2395. Status: [0;31mALERT[0m
  2396. Rule [0;35m#13 (Sensor over limit - Check Device Health Settings):[0m  
  2397. SQL[[1;33mSELECT * 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 [0;33m[61][0m 0.78ms]
  2398.  
  2399. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[13,61][0m 0.29ms]
  2400.  
  2401. SQL[[1;33mINSERT IGNORE INTO `alert_log` (`state`,`device_id`,`rule_id`)  VALUES (:state,:device_id,:rule_id) [0;33m{"state":0,"device_id":61,"rule_id":13}[0m 23.23ms]
  2402.  
  2403. SQL[[1;33mINSERT IGNORE INTO `alerts` (`state`,`device_id`,`rule_id`,`open`,`alerted`)  VALUES (:state,:device_id,:rule_id,:open,:alerted) [0;33m{"state":0,"device_id":61,"rule_id":13,"open":1,"alerted":0}[0m 24.8ms]
  2404.  
  2405.  
  2406. Status: [0;32mOK[0m
  2407. Rule [0;35m#14 (Sensor under limit - Check Device Health Settings):[0m  
  2408. SQL[[1;33mSELECT * 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 xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed>= wireless_sensors.sensor_limit AND wireless_sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[61][0m 0.77ms]
  2409.  
  2410. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[16,61][0m 0.28ms]
  2411.  
  2412. SQL[[1;33mINSERT IGNORE INTO `alert_log` (`state`,`device_id`,`rule_id`)  VALUES (:state,:device_id,:rule_id) [0;33m{"state":0,"device_id":61,"rule_id":16}[0m 23.22ms]
  2413.  
  2414. SQL[[1;33mINSERT IGNORE INTO `alerts` (`state`,`device_id`,`rule_id`,`open`,`alerted`)  VALUES (:state,:device_id,:rule_id,:open,:alerted) [0;33m{"state":0,"device_id":61,"rule_id":16,"open":1,"alerted":0}[0m 34.45ms]
  2415.  
  2416.  
  2417. Status: [0;32mOK[0m
  2418. Rule [0;35m#17 (Wireless Sensor under limit):[0m  
  2419. SQL[[1;33mSELECT * FROM devices,wireless_sensors WHERE (devices.device_id = ? AND devices.device_id = wireless_sensors.device_id) AND wireless_sensors.sensor_current &lt;= wireless_sensors.sensor_limit_low AND wireless_sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[61][0m 0.76ms]
  2420.  
  2421. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[17,61][0m 0.33ms]
  2422.  
  2423. SQL[[1;33mINSERT IGNORE INTO `alert_log` (`state`,`device_id`,`rule_id`)  VALUES (:state,:device_id,:rule_id) [0;33m{"state":0,"device_id":61,"rule_id":17}[0m 31.59ms]
  2424.  
  2425. SQL[[1;33mINSERT IGNORE INTO `alerts` (`state`,`device_id`,`rule_id`,`open`,`alerted`)  VALUES (:state,:device_id,:rule_id,:open,:alerted) [0;33m{"state":0,"device_id":61,"rule_id":17,"open":1,"alerted":0}[0m 33.12ms]
  2426.  
  2427.  
  2428. Status: [0;32mOK[0m
  2429. Rule [0;35m#18 (State Sensor Critical):[0m  
  2430. SQL[[1;33mSELECT * FROM devices,sensors,sensors_to_state_indexes,state_indexes,state_translations WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id AND sensors.sensor_id = sensors_to_state_indexes.sensor_id AND sensors_to_state_indexes.state_index_id = state_indexes.state_index_id AND state_indexes.state_index_id = state_translations.state_index_id) AND (sensors.sensor_current = state_translations.state_value && state_translations.state_generic_value = 2) = 1 AND sensors.sensor_alert = 1 [0;33m[61][0m 0.92ms]
  2431.  
  2432. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[18,61][0m 0.31ms]
  2433.  
  2434. SQL[[1;33mINSERT IGNORE INTO `alert_log` (`state`,`device_id`,`rule_id`)  VALUES (:state,:device_id,:rule_id) [0;33m{"state":0,"device_id":61,"rule_id":18}[0m 31.31ms]
  2435.  
  2436. SQL[[1;33mINSERT IGNORE INTO `alerts` (`state`,`device_id`,`rule_id`,`open`,`alerted`)  VALUES (:state,:device_id,:rule_id,:open,:alerted) [0;33m{"state":0,"device_id":61,"rule_id":18,"open":1,"alerted":0}[0m 33.16ms]
  2437.  
  2438.  
  2439. Status: [0;32mOK[0m
  2440. #### End Alerts ####
  2441. ./poller.php 10.180.7.1 2021-09-14 15:54:49 - 1 devices polled in 46.73 secs  
  2442. SNMP [23/38.10s]: Get[9/6.74s] Getnext[4/0.53s] Walk[10/30.82s]
  2443. MySQL [113/3.36s]: Cell[12/0.01s] Row[-11/-0.01s] Rows[24/0.17s] Column[1/0.00s] Update[45/1.58s] Insert[42/1.60s] Delete[0/0.00s]
  2444.  


Reply to "Untitled"