From revolt112, 5 Months ago, written in Plain Text.
Embed
  1. LibreNMS Poller
  2. SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.32ms]
  3.  
  4. SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 0.28ms]
  5.  
  6. SQL[[1;33mselect version() [0;33m[][0m 0.12ms]
  7.  
  8. ===================================
  9. Version info:
  10. Commit SHA: 785b0bae537cd7fa6bcabee67b27bd8d4f35704f
  11. Commit Date: 1641303027
  12. DB Schema: 2021_11_29_165436_improve_ports_search_index (229)
  13. PHP: 7.4.6
  14. MySQL: 10.3.28-MariaDB
  15. RRDTool: 1.7.0
  16. 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.240.254.136' ORDER BY `device_id` ASC [0;33m[][0m 0.73ms]
  22.  
  23. SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[784][0m 0.38ms]
  24.  
  25. SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[784][0m 0.25ms]
  26.  
  27. Attempting to initialize OS: linux  
  28. Attempting to initialize Group OS: unix  
  29. OS initialized: LibreNMS\OS\Shared\Unix  
  30. Hostname:    10.240.254.136
  31. Device ID:   784
  32. OS:          linux
  33.  (unix)
  34.  
  35. [FPING] '/usr/sbin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '-O' '0' '10.240.254.136'
  36.  
  37. response: xmt/rcv/%loss = 3/3/0%, min/avg/max = 0.62/0.63/0.64  
  38. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/nms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'DES' '-X' 'PASSWORD' '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m]  
  39. SNMPv2-MIB::sysObjectID.0 = NET-SNMP-MIB::netSnmpAgentOIDs.10
  40.  
  41.  
  42. SQL[[1;33minsert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `device_id`, `timestamp`) values (?, ?, ?, ?, ?, ?, ?, ?) [0;33m[0.62,0.64,0.63,3,3,0,784,"2022-01-19 13:56:20"][0m 0.61ms]
  43.  
  44. SQL[[1;33mselect * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` is null order by `going_down` desc limit 1 [0;33m[784][0m 0.38ms]
  45.  
  46. Modules status: Global+  
  47. OS  
  48. Device  
  49.  
  50. #### Load poller module core ####
  51. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/nms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'DES' '-X' 'PASSWORD' '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' '-On' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysDescr.0' 'SNMPv2-MIB::sysObjectID.0' 'SNMPv2-MIB::sysUpTime.0' 'SNMPv2-MIB::sysName.0'[0m]  
  52. .*.*.0 = Linux MCU3000 4.19.100 #1 SMP Thu Nov 4 11:17:12 UTC 2021 armv7l
  53. .*.*.0 = .*.4.1.8*
  54. .*.*.0 = 276490
  55. .*.*.0 = sysName
  56.  
  57.  
  58. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/nms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'DES' '-X' 'PASSWORD' '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0'[0m]  
  59. SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = 2765
  60. HOST-RESOURCES-MIB::hrSystemUptime.0 = 354294115
  61.  
  62.  
  63. Uptime seconds: 3542941
  64.  
  65. Uptime:  41 days 9 minutes 1 second
  66. SQL[[1;33mupdate `devices` set `uptime` = ? where `device_id` = ? [0;33m[3542941,784][0m 0.62ms]
  67.  
  68.  
  69. >> Runtime for poller module 'core': 0.1015 seconds with 57912 bytes
  70. >> [0;36mSNMP[0m: [2/0.10s] [1;33mMySQL[0m: [1/0.01s]  
  71. #### Unload poller module core ####
  72.  
  73. Modules status: Global-  
  74. OS  
  75. Device  
  76. Module [ unix-agent ] disabled globally.
  77.  
  78. Modules status: Global+  
  79. OS  
  80. Device  
  81.  
  82. #### Load poller module os ####
  83. Generic :(
  84. SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[475][0m 0.44ms]
  85.  
  86. Location: sysLocation
  87. Hardware: Generic ARMv7
  88. OS Version: 4.19.100
  89. OS Features:
  90. Serial:
  91.  
  92. >> Runtime for poller module 'os': 0.0022 seconds with 173576 bytes
  93. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  94. #### Unload poller module os ####
  95.  
  96. Modules status: Global+  
  97. OS  
  98. Device  
  99.  
  100. #### Load poller module availability ####
  101. SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[784][0m 0.4ms]
  102.  
  103. Availability:
  104. SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[784][0m 0.38ms]
  105.  
  106. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[784,1642510581][0m 0.45ms]
  107.  
  108. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,3041][0m 0.24ms]
  109.  
  110. 1 day : 100%
  111. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[784,1641992181][0m 0.4ms]
  112.  
  113. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,3042][0m 0.19ms]
  114.  
  115. 7 days : 100%
  116. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[784,1640004981][0m 0.19ms]
  117.  
  118. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,3043][0m 0.12ms]
  119.  
  120. 30 days : 100%
  121. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[784,1611060981][0m 0.2ms]
  122.  
  123. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,3044][0m 0.11ms]
  124.  
  125. 365 days : 100%
  126.  
  127. >> Runtime for poller module 'availability': 0.0046 seconds with 12328 bytes
  128. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [10/0.03s]  
  129. #### Unload poller module availability ####
  130.  
  131. Modules status: Global+  
  132. OS  
  133. Device  
  134.  
  135. #### Load poller module ipmi ####
  136. SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[784][0m 0.27ms]
  137.  
  138. array (
  139. )  
  140.  
  141. >> Runtime for poller module 'ipmi': 0.0006 seconds with 1456 bytes
  142. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  143. #### Unload poller module ipmi ####
  144.  
  145. Modules status: Global+  
  146. OS  
  147. Device  
  148.  
  149. #### Load poller module sensors ####
  150. SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[784][0m 0.21ms]
  151.  
  152.  
  153. >> Runtime for poller module 'sensors': 0.0004 seconds with 456 bytes
  154. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  155. #### Unload poller module sensors ####
  156.  
  157. Modules status: Global+  
  158. OS  
  159. Device  
  160.  
  161. #### Load poller module processors ####
  162. Attempting to initialize OS: linux  
  163. Attempting to initialize Group OS: unix  
  164. OS initialized: LibreNMS\OS\Shared\Unix  
  165. SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[784][0m 0.28ms]
  166.  
  167. SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OUQn' '-M' '/opt/nms/mibs' '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]
  168. .*.*.*608 = 35
  169. .*.*.*609 = 32  
  170.  
  171. array (
  172.   '.1.3.6.1.2.1.25.3.3.1.2.196608' => '35',
  173.   '.1.3.6.1.2.1.25.3.3.1.2.196609' => '32',
  174. )  
  175. Processor: 35%
  176. SQL[[1;33mUPDATE `processors` set `processor_usage`=? WHERE `processor_id` = ? [0;33m[35,2540][0m 0.61ms]
  177.  
  178. Processor: 32%
  179. SQL[[1;33mUPDATE `processors` set `processor_usage`=? WHERE `processor_id` = ? [0;33m[32,2541][0m 0.36ms]
  180.  
  181.  
  182. >> Runtime for poller module 'processors': 0.0556 seconds with 59672 bytes
  183. >> [0;36mSNMP[0m: [1/0.05s] [1;33mMySQL[0m: [3/0.01s]  
  184. #### Unload poller module processors ####
  185.  
  186. Modules status: Global+  
  187. OS  
  188. Device  
  189.  
  190. #### Load poller module mempools ####
  191. SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[784][0m 0.81ms]
  192.  
  193. SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OUQn' '-M' '/opt/nms/mibs' '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'[0m]
  194. .*.*.* = 597420
  195. .*.*.* = 597420
  196. .*.*.* = 24544
  197. .*.*.* = 352916
  198. .*.*.* = 188128  
  199.  
  200. Free memory adjusted by availability calculation: 415.75 MiB -> 784.36 MiB
  201.  
  202. hrstorage [system]: Physical memory: 21!4.8 MiB / 999.17 MiB
  203. SQL[[1;33mupdate `mempools` set `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[225239040,822464512,3946][0m 0.45ms]
  204.  
  205. hrstorage [virtual]: Virtual memory: 58X3.42 MiB / 999.17 MiB
  206. SQL[[1;33mupdate `mempools` set `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[611758080,435945472,3947][0m 0.33ms]
  207.  
  208. hrstorage [buffers]: Memory buffers: 2#.97 MiB / 999.17 MiB
  209. hrstorage [cached]: Cached memory: 3444.64 MiB / 999.17 MiB
  210. SQL[[1;33mupdate `mempools` set `mempool_perc` = ?, `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[34,361385984,686317568,3949][0m 0.31ms]
  211.  
  212. hrstorage [shared]: Shared memory: 183.72 MiB / 999.17 MiB
  213. SQL[[1;33mupdate `mempools` set `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[192643072,855060480,3950][0m 0.28ms]
  214.  
  215.  
  216. >> Runtime for poller module 'mempools': 0.0606 seconds with 110464 bytes
  217. >> [0;36mSNMP[0m: [1/0.05s] [1;33mMySQL[0m: [5/0.02s]  
  218. #### Unload poller module mempools ####
  219.  
  220. Modules status: Global+  
  221. OS  
  222. Device  
  223.  
  224. #### Load poller module storage ####
  225. SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[784][0m 0.36ms]
  226.  
  227. Storage /: hrstorage
  228.  
  229.  
  230.  
  231. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUs' '-m' 'HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'hrStorageEntry'[0m]
  232. hrStorageIndex.1 = 1
  233. hrStorageIndex.3 = 3
  234. hrStorageIndex.6 = 6
  235. hrStorageIndex.7 = 7
  236. hrStorageIndex.8 = 8
  237. hrStorageIndex.10 = 10
  238. hrStorageIndex.31 = 31
  239. hrStorageIndex.36 = 36
  240. hrStorageIndex.37 = 37
  241. hrStorageIndex.38 = 38
  242. hrStorageIndex.39 = 39
  243. hrStorageIndex.40 = 40
  244. hrStorageIndex.41 = 41
  245. hrStorageType.1 = hrStorageRam
  246. hrStorageType.3 = hrStorageVirtualMemory
  247. hrStorageType.6 = hrStorageOther
  248. hrStorageType.7 = hrStorageOther
  249. hrStorageType.8 = hrStorageOther
  250. hrStorageType.10 = hrStorageVirtualMemory
  251. hrStorageType.31 = hrStorageFixedDisk
  252. hrStorageType.36 = hrStorageFixedDisk
  253. hrStorageType.37 = hrStorageFixedDisk
  254. hrStorageType.38 = hrStorageFixedDisk
  255. hrStorageType.39 = hrStorageFixedDisk
  256. hrStorageType.40 = hrStorageFixedDisk
  257. hrStorageType.41 = hrStorageFixedDisk
  258. hrStorageDescr.1 = Physical memory
  259. hrStorageDescr.3 = Virtual memory
  260. hrStorageDescr.6 = Memory buffers
  261. hrStorageDescr.7 = Cached memory
  262. hrStorageDescr.8 = Shared memory
  263. hrStorageDescr.10 = Swap space
  264. hrStorageDescr.31 = /
  265. hrStorageDescr.36 = /run
  266. hrStorageDescr.37 = /var/volatile
  267. hrStorageDescr.38 = /tmp
  268. hrStorageDescr.39 = /cache
  269. hrStorageDescr.40 = /data
  270. hrStorageDescr.41 = /dev/shm
  271. hrStorageAllocationUnits.1 = 1024
  272. hrStorageAllocationUnits.3 = 1024
  273. hrStorageAllocationUnits.6 = 1024
  274. hrStorageAllocationUnits.7 = 1024
  275. hrStorageAllocationUnits.8 = 1024
  276. hrStorageAllocationUnits.10 = 1024
  277. hrStorageAllocationUnits.31 = 4096
  278. hrStorageAllocationUnits.36 = 4096
  279. hrStorageAllocationUnits.37 = 4096
  280. hrStorageAllocationUnits.38 = 4096
  281. hrStorageAllocationUnits.39 = 1024
  282. hrStorageAllocationUnits.40 = 4096
  283. hrStorageAllocationUnits.41 = 4096
  284. hrStorageSize.1 = 1023148
  285. hrStorageSize.3 = 1023148
  286. hrStorageSize.6 = 1023148
  287. hrStorageSize.7 = 352916
  288. hrStorageSize.8 = 188128
  289. hrStorageSize.10 = 0
  290. hrStorageSize.31 = 124914
  291. hrStorageSize.36 = 127893
  292. hrStorageSize.37 = 157168
  293. hrStorageSize.38 = 65536
  294. hrStorageSize.39 = 245679
  295. hrStorageSize.40 = 157168
  296. hrStorageSize.41 = 127893
  297. hrStorageUsed.1 = 597420
  298. hrStorageUsed.3 = 597420
  299. hrStorageUsed.6 = 24544
  300. hrStorageUsed.7 = 352916
  301. hrStorageUsed.8 = 188128
  302. hrStorageUsed.10 = 0
  303. hrStorageUsed.31 = 82383
  304. hrStorageUsed.36 = 48
  305. hrStorageUsed.37 = 30338
  306. hrStorageUsed.38 = 23670
  307. hrStorageUsed.39 = 2052
  308. hrStorageUsed.40 = 30338
  309. hrStorageUsed.41 = 2529  
  310.  
  311. array (
  312.   'hrstorage' =>
  313.   array (
  314.     1 =>
  315.     array (
  316.       'hrStorageIndex' => '1',
  317.       'hrStorageType' => 'hrStorageRam',
  318.       'hrStorageDescr' => 'Physical memory',
  319.       'hrStorageAllocationUnits' => '1024',
  320.       'hrStorageSize' => '1023148',
  321.       'hrStorageUsed' => '597420',
  322.     ),
  323.     3 =>
  324.     array (
  325.       'hrStorageIndex' => '3',
  326.       'hrStorageType' => 'hrStorageVirtualMemory',
  327.       'hrStorageDescr' => 'Virtual memory',
  328.       'hrStorageAllocationUnits' => '1024',
  329.       'hrStorageSize' => '1023148',
  330.       'hrStorageUsed' => '597420',
  331.     ),
  332.     6 =>
  333.     array (
  334.       'hrStorageIndex' => '6',
  335.       'hrStorageType' => 'hrStorageOther',
  336.       'hrStorageDescr' => 'Memory buffers',
  337.       'hrStorageAllocationUnits' => '1024',
  338.       'hrStorageSize' => '1023148',
  339.       'hrStorageUsed' => '24544',
  340.     ),
  341.     7 =>
  342.     array (
  343.       'hrStorageIndex' => '7',
  344.       'hrStorageType' => 'hrStorageOther',
  345.       'hrStorageDescr' => 'Cached memory',
  346.       'hrStorageAllocationUnits' => '1024',
  347.       'hrStorageSize' => '352916',
  348.       'hrStorageUsed' => '352916',
  349.     ),
  350.     8 =>
  351.     array (
  352.       'hrStorageIndex' => '8',
  353.       'hrStorageType' => 'hrStorageOther',
  354.       'hrStorageDescr' => 'Shared memory',
  355.       'hrStorageAllocationUnits' => '1024',
  356.       'hrStorageSize' => '188128',
  357.       'hrStorageUsed' => '188128',
  358.     ),
  359.     10 =>
  360.     array (
  361.       'hrStorageIndex' => '10',
  362.       'hrStorageType' => 'hrStorageVirtualMemory',
  363.       'hrStorageDescr' => 'Swap space',
  364.       'hrStorageAllocationUnits' => '1024',
  365.       'hrStorageSize' => '0',
  366.       'hrStorageUsed' => '0',
  367.     ),
  368.     31 =>
  369.     array (
  370.       'hrStorageIndex' => '31',
  371.       'hrStorageType' => 'hrStorageFixedDisk',
  372.       'hrStorageDescr' => '/',
  373.       'hrStorageAllocationUnits' => '4096',
  374.       'hrStorageSize' => '124914',
  375.       'hrStorageUsed' => '82383',
  376.     ),
  377.     36 =>
  378.     array (
  379.       'hrStorageIndex' => '36',
  380.       'hrStorageType' => 'hrStorageFixedDisk',
  381.       'hrStorageDescr' => '/run',
  382.       'hrStorageAllocationUnits' => '4096',
  383.       'hrStorageSize' => '127893',
  384.       'hrStorageUsed' => '48',
  385.     ),
  386.     37 =>
  387.     array (
  388.       'hrStorageIndex' => '37',
  389.       'hrStorageType' => 'hrStorageFixedDisk',
  390.       'hrStorageDescr' => '/var/volatile',
  391.       'hrStorageAllocationUnits' => '4096',
  392.       'hrStorageSize' => '157168',
  393.       'hrStorageUsed' => '30338',
  394.     ),
  395.     38 =>
  396.     array (
  397.       'hrStorageIndex' => '38',
  398.       'hrStorageType' => 'hrStorageFixedDisk',
  399.       'hrStorageDescr' => '/tmp',
  400.       'hrStorageAllocationUnits' => '4096',
  401.       'hrStorageSize' => '65536',
  402.       'hrStorageUsed' => '23670',
  403.     ),
  404.     39 =>
  405.     array (
  406.       'hrStorageIndex' => '39',
  407.       'hrStorageType' => 'hrStorageFixedDisk',
  408.       'hrStorageDescr' => '/cache',
  409.       'hrStorageAllocationUnits' => '1024',
  410.       'hrStorageSize' => '245679',
  411.       'hrStorageUsed' => '2052',
  412.     ),
  413.     40 =>
  414.     array (
  415.       'hrStorageIndex' => '40',
  416.       'hrStorageType' => 'hrStorageFixedDisk',
  417.       'hrStorageDescr' => '/data',
  418.       'hrStorageAllocationUnits' => '4096',
  419.       'hrStorageSize' => '157168',
  420.       'hrStorageUsed' => '30338',
  421.     ),
  422.     41 =>
  423.     array (
  424.       'hrStorageIndex' => '41',
  425.       'hrStorageType' => 'hrStorageFixedDisk',
  426.       'hrStorageDescr' => '/dev/shm',
  427.       'hrStorageAllocationUnits' => '4096',
  428.       'hrStorageSize' => '127893',
  429.       'hrStorageUsed' => '2529',
  430.     ),
  431.   ),
  432. )  
  433. array (
  434.   'storage_id' => 1082,
  435.   'device_id' => 784,
  436.   'storage_mib' => 'hrstorage',
  437.   'storage_index' => '31',
  438.   'storage_type' => 'hrStorageFixedDisk',
  439.   'storage_descr' => '/',
  440.   'storage_size' => 511647744,
  441.   'storage_units' => 4096,
  442.   'storage_used' => 337440768,
  443.   'storage_free' => 174206976,
  444.   'storage_perc' => 66,
  445.   'storage_perc_warn' => 60,
  446.   'storage_deleted' => 0,
  447.   'units' => '4096',
  448.   'used' => 337440768,
  449.   'size' => 511647744,
  450.   'free' => 174206976,
  451. )  
  452. 66% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["337440768","174206976","511647744",4096,66,1082][0m 0.49ms]
  453.  
  454.  
  455. Storage /run: hrstorage
  456.  
  457.  
  458.  
  459. array (
  460.   'storage_id' => 1083,
  461.   'device_id' => 784,
  462.   'storage_mib' => 'hrstorage',
  463.   'storage_index' => '36',
  464.   'storage_type' => 'hrStorageFixedDisk',
  465.   'storage_descr' => '/run',
  466.   'storage_size' => 523849728,
  467.   'storage_units' => 4096,
  468.   'storage_used' => 196608,
  469.   'storage_free' => 523653120,
  470.   'storage_perc' => 0,
  471.   'storage_perc_warn' => 60,
  472.   'storage_deleted' => 0,
  473.   'units' => '4096',
  474.   'used' => 196608,
  475.   'size' => 523849728,
  476.   'free' => 523653120,
  477. )  
  478. 0% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["196608","523653120","523849728",4096,0,1083][0m 0.55ms]
  479.  
  480.  
  481. Storage /var/volatile: hrstorage
  482.  
  483.  
  484.  
  485. array (
  486.   'storage_id' => 1084,
  487.   'device_id' => 784,
  488.   'storage_mib' => 'hrstorage',
  489.   'storage_index' => '37',
  490.   'storage_type' => 'hrStorageFixedDisk',
  491.   'storage_descr' => '/var/volatile',
  492.   'storage_size' => 643760128,
  493.   'storage_units' => 4096,
  494.   'storage_used' => 124264448,
  495.   'storage_free' => 519495680,
  496.   'storage_perc' => 19,
  497.   'storage_perc_warn' => 60,
  498.   'storage_deleted' => 0,
  499.   'units' => '4096',
  500.   'used' => 124264448,
  501.   'size' => 643760128,
  502.   'free' => 519495680,
  503. )  
  504. 19% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["124264448","519495680","643760128",4096,19,1084][0m 0.55ms]
  505.  
  506.  
  507. Storage /tmp: hrstorage
  508.  
  509.  
  510.  
  511. array (
  512.   'storage_id' => 1085,
  513.   'device_id' => 784,
  514.   'storage_mib' => 'hrstorage',
  515.   'storage_index' => '38',
  516.   'storage_type' => 'hrStorageFixedDisk',
  517.   'storage_descr' => '/tmp',
  518.   'storage_size' => 268435456,
  519.   'storage_units' => 4096,
  520.   'storage_used' => 96952320,
  521.   'storage_free' => 171483136,
  522.   'storage_perc' => 36,
  523.   'storage_perc_warn' => 60,
  524.   'storage_deleted' => 0,
  525.   'units' => '4096',
  526.   'used' => 96952320,
  527.   'size' => 268435456,
  528.   'free' => 171483136,
  529. )  
  530. 36% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["96952320","171483136","268435456",4096,36,1085][0m 0.53ms]
  531.  
  532.  
  533. Storage /cache: hrstorage
  534.  
  535.  
  536.  
  537. array (
  538.   'storage_id' => 1086,
  539.   'device_id' => 784,
  540.   'storage_mib' => 'hrstorage',
  541.   'storage_index' => '39',
  542.   'storage_type' => 'hrStorageFixedDisk',
  543.   'storage_descr' => '/cache',
  544.   'storage_size' => 251575296,
  545.   'storage_units' => 1024,
  546.   'storage_used' => 2101248,
  547.   'storage_free' => 249474048,
  548.   'storage_perc' => 1,
  549.   'storage_perc_warn' => 60,
  550.   'storage_deleted' => 0,
  551.   'units' => '1024',
  552.   'used' => 2101248,
  553.   'size' => 251575296,
  554.   'free' => 249474048,
  555. )  
  556. 1% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["2101248","249474048","251575296",1024,1,1086][0m 0.44ms]
  557.  
  558.  
  559. Storage /data: hrstorage
  560.  
  561.  
  562.  
  563. array (
  564.   'storage_id' => 1087,
  565.   'device_id' => 784,
  566.   'storage_mib' => 'hrstorage',
  567.   'storage_index' => '40',
  568.   'storage_type' => 'hrStorageFixedDisk',
  569.   'storage_descr' => '/data',
  570.   'storage_size' => 643760128,
  571.   'storage_units' => 4096,
  572.   'storage_used' => 124264448,
  573.   'storage_free' => 519495680,
  574.   'storage_perc' => 19,
  575.   'storage_perc_warn' => 60,
  576.   'storage_deleted' => 0,
  577.   'units' => '4096',
  578.   'used' => 124264448,
  579.   'size' => 643760128,
  580.   'free' => 519495680,
  581. )  
  582. 19% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["124264448","519495680","643760128",4096,19,1087][0m 0.36ms]
  583.  
  584.  
  585. Storage /dev/shm: hrstorage
  586.  
  587.  
  588.  
  589. array (
  590.   'storage_id' => 1088,
  591.   'device_id' => 784,
  592.   'storage_mib' => 'hrstorage',
  593.   'storage_index' => '41',
  594.   'storage_type' => 'hrStorageFixedDisk',
  595.   'storage_descr' => '/dev/shm',
  596.   'storage_size' => 523849728,
  597.   'storage_units' => 4096,
  598.   'storage_used' => 10358784,
  599.   'storage_free' => 513490944,
  600.   'storage_perc' => 2,
  601.   'storage_perc_warn' => 60,
  602.   'storage_deleted' => 0,
  603.   'units' => '4096',
  604.   'used' => 10358784,
  605.   'size' => 523849728,
  606.   'free' => 513490944,
  607. )  
  608. 2% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["10358784","513490944","523849728",4096,2,1088][0m 0.31ms]
  609.  
  610.  
  611.  
  612. >> Runtime for poller module 'storage': 0.0756 seconds with 15072 bytes
  613. >> [0;36mSNMP[0m: [1/0.06s] [1;33mMySQL[0m: [8/0.04s]  
  614. #### Unload poller module storage ####
  615.  
  616. Modules status: Global+  
  617. OS  
  618. Device  
  619.  
  620. #### Load poller module netstats ####
  621. icmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/nms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'DES' '-X' 'PASSWORD' '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::icmpInMsgs.0' 'IP-MIB::icmpOutMsgs.0' 'IP-MIB::icmpInErrors.0' 'IP-MIB::icmpOutErrors.0' 'IP-MIB::icmpInEchos.0' 'IP-MIB::icmpOutEchos.0' 'IP-MIB::icmpInEchoReps.0' 'IP-MIB::icmpOutEchoReps.0' 'IP-MIB::icmpInDestUnreachs.0' 'IP-MIB::icmpOutDestUnreachs.0' 'IP-MIB::icmpInParmProbs.0' 'IP-MIB::icmpInTimeExcds.0' 'IP-MIB::icmpInSrcQuenchs.0' 'IP-MIB::icmpInRedirects.0' 'IP-MIB::icmpInTimestamps.0' 'IP-MIB::icmpInTimestampReps.0' 'IP-MIB::icmpInAddrMasks.0' 'IP-MIB::icmpInAddrMaskReps.0' 'IP-MIB::icmpOutTimeExcds.0' 'IP-MIB::icmpOutParmProbs.0' 'IP-MIB::icmpOutSrcQuenchs.0' 'IP-MIB::icmpOutRedirects.0' 'IP-MIB::icmpOutTimestamps.0' 'IP-MIB::icmpOutTimestampReps.0' 'IP-MIB::icmpOutAddrMasks.0' 'IP-MIB::icmpOutAddrMaskReps.0'[0m]  
  622. IP-MIB::icmpInMsgs.0 = 254
  623. IP-MIB::icmpOutMsgs.0 = 254
  624. IP-MIB::icmpInErrors.0 = 0
  625. IP-MIB::icmpOutErrors.0 = 0
  626. IP-MIB::icmpInEchos.0 = 250
  627. IP-MIB::icmpOutEchos.0 = 0
  628. IP-MIB::icmpInEchoReps.0 = 0
  629. IP-MIB::icmpOutEchoReps.0 = 250
  630. IP-MIB::icmpInDestUnreachs.0 = 4
  631. IP-MIB::icmpOutDestUnreachs.0 = 4
  632. IP-MIB::icmpInParmProbs.0 = 0
  633. IP-MIB::icmpInTimeExcds.0 = 0
  634. IP-MIB::icmpInSrcQuenchs.0 = 0
  635. IP-MIB::icmpInRedirects.0 = 0
  636. IP-MIB::icmpInTimestamps.0 = 0
  637. IP-MIB::icmpInTimestampReps.0 = 0
  638. IP-MIB::icmpInAddrMasks.0 = 0
  639. IP-MIB::icmpInAddrMaskReps.0 = 0
  640. IP-MIB::icmpOutTimeExcds.0 = 0
  641. IP-MIB::icmpOutParmProbs.0 = 0
  642. IP-MIB::icmpOutSrcQuenchs.0 = 0
  643. IP-MIB::icmpOutRedirects.0 = 0
  644. IP-MIB::icmpOutTimestamps.0 = 0
  645. IP-MIB::icmpOutTimestampReps.0 = 0
  646. IP-MIB::icmpOutAddrMasks.0 = 0
  647. IP-MIB::icmpOutAddrMaskReps.0 = 0
  648.  
  649.  
  650. ip SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/nms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'DES' '-X' 'PASSWORD' '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::ipForwDatagrams.0' 'IP-MIB::ipInDelivers.0' 'IP-MIB::ipInReceives.0' 'IP-MIB::ipOutRequests.0' 'IP-MIB::ipInDiscards.0' 'IP-MIB::ipOutDiscards.0' 'IP-MIB::ipOutNoRoutes.0' 'IP-MIB::ipReasmReqds.0' 'IP-MIB::ipReasmOKs.0' 'IP-MIB::ipReasmFails.0' 'IP-MIB::ipFragOKs.0' 'IP-MIB::ipFragFails.0' 'IP-MIB::ipFragCreates.0' 'IP-MIB::ipInUnknownProtos.0' 'IP-MIB::ipInHdrErrors.0' 'IP-MIB::ipInAddrErrors.0'[0m]  
  651. IP-MIB::ipForwDatagrams.0 = 0
  652. IP-MIB::ipInDelivers.0 = 178233513
  653. IP-MIB::ipInReceives.0 = 178233763
  654. IP-MIB::ipOutRequests.0 = 178218631
  655. IP-MIB::ipInDiscards.0 = 0
  656. IP-MIB::ipOutDiscards.0 = 0
  657. IP-MIB::ipOutNoRoutes.0 = 0
  658. IP-MIB::ipReasmReqds.0 = 0
  659. IP-MIB::ipReasmOKs.0 = 0
  660. IP-MIB::ipReasmFails.0 = 0
  661. IP-MIB::ipFragOKs.0 = 0
  662. IP-MIB::ipFragFails.0 = 0
  663. IP-MIB::ipFragCreates.0 = 0
  664. IP-MIB::ipInUnknownProtos.0 = 0
  665. IP-MIB::ipInHdrErrors.0 = 0
  666. IP-MIB::ipInAddrErrors.0 = 250
  667.  
  668.  
  669. ip_forward SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/nms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'DES' '-X' 'PASSWORD' '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m]  
  670. IP-FORWARD-MIB::ipCidrRouteNumber.0 = No Such Object available on this agent at this OID
  671.  
  672.  
  673. snmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/nms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'DES' '-X' 'PASSWORD' '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::snmpInPkts.0' 'SNMPv2-MIB::snmpOutPkts.0' 'SNMPv2-MIB::snmpInBadVersions.0' 'SNMPv2-MIB::snmpInBadCommunityNames.0' 'SNMPv2-MIB::snmpInBadCommunityUses.0' 'SNMPv2-MIB::snmpInASNParseErrs.0' 'SNMPv2-MIB::snmpInTooBigs.0' 'SNMPv2-MIB::snmpInNoSuchNames.0' 'SNMPv2-MIB::snmpInBadValues.0' 'SNMPv2-MIB::snmpInReadOnlys.0' 'SNMPv2-MIB::snmpInGenErrs.0' 'SNMPv2-MIB::snmpInTotalReqVars.0' 'SNMPv2-MIB::snmpInTotalSetVars.0' 'SNMPv2-MIB::snmpInGetRequests.0' 'SNMPv2-MIB::snmpInGetNexts.0' 'SNMPv2-MIB::snmpInSetRequests.0' 'SNMPv2-MIB::snmpInGetResponses.0' 'SNMPv2-MIB::snmpInTraps.0' 'SNMPv2-MIB::snmpOutTooBigs.0' 'SNMPv2-MIB::snmpOutNoSuchNames.0' 'SNMPv2-MIB::snmpOutBadValues.0' 'SNMPv2-MIB::snmpOutGenErrs.0' 'SNMPv2-MIB::snmpOutGetRequests.0' 'SNMPv2-MIB::snmpOutGetNexts.0' 'SNMPv2-MIB::snmpOutSetRequests.0' 'SNMPv2-MIB::snmpOutGetResponses.0' 'SNMPv2-MIB::snmpOutTraps.0' 'SNMPv2-MIB::snmpSilentDrops.0' 'SNMPv2-MIB::snmpProxyDrops.0'[0m]  
  674. SNMPv2-MIB::snmpInPkts.0 = 1941
  675. SNMPv2-MIB::snmpOutPkts.0 = 1327
  676. SNMPv2-MIB::snmpInBadVersions.0 = 0
  677. SNMPv2-MIB::snmpInBadCommunityNames.0 = 0
  678. SNMPv2-MIB::snmpInBadCommunityUses.0 = 0
  679. SNMPv2-MIB::snmpInASNParseErrs.0 = 0
  680. SNMPv2-MIB::snmpInTooBigs.0 = 0
  681. SNMPv2-MIB::snmpInNoSuchNames.0 = 0
  682. SNMPv2-MIB::snmpInBadValues.0 = 0
  683. SNMPv2-MIB::snmpInReadOnlys.0 = 0
  684. SNMPv2-MIB::snmpInGenErrs.0 = 0
  685. SNMPv2-MIB::snmpInTotalReqVars.0 = 10254
  686. SNMPv2-MIB::snmpInTotalSetVars.0 = 0
  687. SNMPv2-MIB::snmpInGetRequests.0 = 429
  688. SNMPv2-MIB::snmpInGetNexts.0 = 0
  689. SNMPv2-MIB::snmpInSetRequests.0 = 0
  690. SNMPv2-MIB::snmpInGetResponses.0 = 0
  691. SNMPv2-MIB::snmpInTraps.0 = 0
  692. SNMPv2-MIB::snmpOutTooBigs.0 = 0
  693. SNMPv2-MIB::snmpOutNoSuchNames.0 = 0
  694. SNMPv2-MIB::snmpOutBadValues.0 = 0
  695. SNMPv2-MIB::snmpOutGenErrs.0 = 0
  696. SNMPv2-MIB::snmpOutGetRequests.0 = 0
  697. SNMPv2-MIB::snmpOutGetNexts.0 = 0
  698. SNMPv2-MIB::snmpOutSetRequests.0 = 0
  699. SNMPv2-MIB::snmpOutGetResponses.0 = 1319
  700. SNMPv2-MIB::snmpOutTraps.0 = 0
  701. SNMPv2-MIB::snmpSilentDrops.0 = 0
  702. SNMPv2-MIB::snmpProxyDrops.0 = 0
  703.  
  704.  
  705. udp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/nms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'DES' '-X' 'PASSWORD' '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp:HOSTNAME:161' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0'[0m]  
  706. UDP-MIB::udpInDatagrams.0 = 15694996
  707. UDP-MIB::udpOutDatagrams.0 = 15694995
  708. UDP-MIB::udpInErrors.0 = 0
  709. UDP-MIB::udpNoPorts.0 = 0
  710.  
  711.  
  712. tcp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/nms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'DES' '-X' 'PASSWORD' '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' 'udp:HOSTNAME:161' 'TCP-MIB::tcpActiveOpens.0' 'TCP-MIB::tcpPassiveOpens.0' 'TCP-MIB::tcpAttemptFails.0' 'TCP-MIB::tcpEstabResets.0' 'TCP-MIB::tcpCurrEstab.0' 'TCP-MIB::tcpInSegs.0' 'TCP-MIB::tcpOutSegs.0' 'TCP-MIB::tcpRetransSegs.0' 'TCP-MIB::tcpInErrs.0' 'TCP-MIB::tcpOutRsts.0'[0m]  
  713. TCP-MIB::tcpActiveOpens.0 = 16236
  714. TCP-MIB::tcpPassiveOpens.0 = 16443
  715. TCP-MIB::tcpAttemptFails.0 = 4
  716. TCP-MIB::tcpEstabResets.0 = 798
  717. TCP-MIB::tcpCurrEstab.0 = 18
  718. TCP-MIB::tcpInSegs.0 = 162538156
  719. TCP-MIB::tcpOutSegs.0 = 162557843
  720. TCP-MIB::tcpRetransSegs.0 = 300
  721. TCP-MIB::tcpInErrs.0 = 0
  722. TCP-MIB::tcpOutRsts.0 = 1800
  723.  
  724.  
  725.  
  726.  
  727. >> Runtime for poller module 'netstats': 0.3006 seconds with 23624 bytes
  728. >> [0;36mSNMP[0m: [6/0.30s] [1;33mMySQL[0m: [0/0.00s]  
  729. #### Unload poller module netstats ####
  730.  
  731. Modules status: Global+  
  732. OS  
  733. Device  
  734.  
  735. #### Load poller module hr-mib ####
  736. SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'hrSystemMaxProcesses.0' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m]
  737. hrSystemMaxProcesses.0 = 0
  738. hrSystemProcesses.0 = 106
  739. hrSystemNumUsers.0 = 0  
  740.  
  741.  ProcessesSQL[[1;33mselect * from `hrSystem` where (`device_id` = ?) limit 1 [0;33m[784][0m 0.44ms]
  742.  
  743. SQL[[1;33mupdate `hrSystem` set `hrSystemProcesses` = ? where `hrSystem_id` = ? [0;33m["106",31][0m 0.36ms]
  744.  
  745.  Users
  746.  
  747. >> Runtime for poller module 'hr-mib': 0.0404 seconds with 33424 bytes
  748. >> [0;36mSNMP[0m: [1/0.04s] [1;33mMySQL[0m: [2/0.01s]  
  749. #### Unload poller module hr-mib ####
  750.  
  751. Modules status: Global+  
  752. OS  
  753. Device  
  754.  
  755. #### Load poller module ucd-mib ####
  756. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'systemStats'[0m]
  757. ssIndex.0 = 1
  758. ssErrorName.0 = systemStats
  759. ssSwapIn.0 = 0
  760. ssSwapOut.0 = 0
  761. ssIOSent.0 = 9
  762. ssIOReceive.0 = 0
  763. ssSysInterrupts.0 = 626
  764. ssSysContext.0 = 916
  765. ssCpuUser.0 = 28
  766. ssCpuSystem.0 = 4
  767. ssCpuIdle.0 = 67
  768. ssCpuRawUser.0 = 190456620
  769. ssCpuRawNice.0 = 302
  770. ssCpuRawSystem.0 = 29519856
  771. ssCpuRawIdle.0 = 477111477
  772. ssCpuRawWait.0 = 105437
  773. ssCpuRawKernel.0 = 0
  774. ssCpuRawInterrupt.0 = 0
  775. ssIORawSent.0 = 24203090
  776. ssIORawReceived.0 = 356074
  777. ssRawInterrupts.0 = 2206887318
  778. ssRawContexts.0 = 3233694453
  779. ssCpuRawSoftIRQ.0 = 950828
  780. ssRawSwapIn.0 = 0
  781. ssRawSwapOut.0 = 0
  782. ssCpuRawSteal.0 = 0
  783. ssCpuRawGuest.0 = 0
  784. ssCpuRawGuestNice.0 = 0
  785. ssCpuNumCpus.0 = 2  
  786.  
  787. SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m]
  788. laLoadInt.1 = 105
  789. laLoadInt.2 = 70
  790. laLoadInt.3 = 73  
  791.  
  792.  
  793. >> Runtime for poller module 'ucd-mib': 0.0811 seconds with 2672 bytes
  794. >> [0;36mSNMP[0m: [2/0.08s] [1;33mMySQL[0m: [0/0.00s]  
  795. #### Unload poller module ucd-mib ####
  796.  
  797. Modules status: Global+  
  798. OS  
  799. Device  
  800.  
  801. #### Load poller module ipSystemStats ####
  802. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'ipSystemStats'[0m]
  803. ipSystemStatsInReceives.ipv4 = 178233563
  804. ipSystemStatsInReceives.ipv6 = 0
  805. ipSystemStatsHCInReceives.ipv4 = 178233563
  806. ipSystemStatsHCInReceives.ipv6 = 0
  807. ipSystemStatsInOctets.ipv4 = 4208530181
  808. ipSystemStatsInOctets.ipv6 = 0
  809. ipSystemStatsHCInOctets.ipv4 = 42863235845
  810. ipSystemStatsHCInOctets.ipv6 = 0
  811. ipSystemStatsInHdrErrors.ipv4 = 0
  812. ipSystemStatsInHdrErrors.ipv6 = 0
  813. ipSystemStatsInNoRoutes.ipv4 = 0
  814. ipSystemStatsInNoRoutes.ipv6 = 0
  815. ipSystemStatsInAddrErrors.ipv4 = 250
  816. ipSystemStatsInAddrErrors.ipv6 = 0
  817. ipSystemStatsInUnknownProtos.ipv4 = 0
  818. ipSystemStatsInUnknownProtos.ipv6 = 0
  819. ipSystemStatsInTruncatedPkts.ipv4 = 0
  820. ipSystemStatsInTruncatedPkts.ipv6 = 0
  821. ipSystemStatsInForwDatagrams.ipv4 = 0
  822. ipSystemStatsInForwDatagrams.ipv6 = 0
  823. ipSystemStatsHCInForwDatagrams.ipv4 = 0
  824. ipSystemStatsHCInForwDatagrams.ipv6 = 0
  825. ipSystemStatsReasmReqds.ipv4 = 0
  826. ipSystemStatsReasmReqds.ipv6 = 0
  827. ipSystemStatsReasmOKs.ipv4 = 0
  828. ipSystemStatsReasmOKs.ipv6 = 0
  829. ipSystemStatsReasmFails.ipv4 = 0
  830. ipSystemStatsReasmFails.ipv6 = 0
  831. ipSystemStatsInDiscards.ipv4 = 0
  832. ipSystemStatsInDiscards.ipv6 = 0
  833. ipSystemStatsInDelivers.ipv4 = 178233313
  834. ipSystemStatsInDelivers.ipv6 = 0
  835. ipSystemStatsHCInDelivers.ipv4 = 178233313
  836. ipSystemStatsHCInDelivers.ipv6 = 0
  837. ipSystemStatsOutRequests.ipv4 = 178218432
  838. ipSystemStatsOutRequests.ipv6 = 0
  839. ipSystemStatsHCOutRequests.ipv4 = 178218432
  840. ipSystemStatsHCOutRequests.ipv6 = 0
  841. ipSystemStatsOutNoRoutes.ipv4 = 0
  842. ipSystemStatsOutNoRoutes.ipv6 = 0
  843. ipSystemStatsOutForwDatagrams.ipv4 = 0
  844. ipSystemStatsOutForwDatagrams.ipv6 = 0
  845. ipSystemStatsHCOutForwDatagrams.ipv4 = 0
  846. ipSystemStatsHCOutForwDatagrams.ipv6 = 0
  847. ipSystemStatsOutDiscards.ipv4 = 0
  848. ipSystemStatsOutDiscards.ipv6 = 0
  849. ipSystemStatsOutFragReqds.ipv4 = 0
  850. ipSystemStatsOutFragReqds.ipv6 = 0
  851. ipSystemStatsOutFragOKs.ipv4 = 0
  852. ipSystemStatsOutFragOKs.ipv6 = 0
  853. ipSystemStatsOutFragFails.ipv4 = 0
  854. ipSystemStatsOutFragFails.ipv6 = 0
  855. ipSystemStatsOutFragCreates.ipv4 = 0
  856. ipSystemStatsOutFragCreates.ipv6 = 0
  857. ipSystemStatsOutTransmits.ipv4 = 178218432
  858. ipSystemStatsOutTransmits.ipv6 = 0
  859. ipSystemStatsHCOutTransmits.ipv4 = 178218432
  860. ipSystemStatsHCOutTransmits.ipv6 = 0
  861. ipSystemStatsOutOctets.ipv4 = 4267580579
  862. ipSystemStatsOutOctets.ipv6 = 0
  863. ipSystemStatsHCOutOctets.ipv4 = 42922286243
  864. ipSystemStatsHCOutOctets.ipv6 = 0
  865. ipSystemStatsInMcastPkts.ipv4 = 0
  866. ipSystemStatsInMcastPkts.ipv6 = 0
  867. ipSystemStatsHCInMcastPkts.ipv4 = 0
  868. ipSystemStatsHCInMcastPkts.ipv6 = 0
  869. ipSystemStatsInMcastOctets.ipv4 = 0
  870. ipSystemStatsInMcastOctets.ipv6 = 0
  871. ipSystemStatsHCInMcastOctets.ipv4 = 0
  872. ipSystemStatsHCInMcastOctets.ipv6 = 0
  873. ipSystemStatsOutMcastPkts.ipv4 = 0
  874. ipSystemStatsOutMcastPkts.ipv6 = 0
  875. ipSystemStatsHCOutMcastPkts.ipv4 = 0
  876. ipSystemStatsHCOutMcastPkts.ipv6 = 0
  877. ipSystemStatsOutMcastOctets.ipv4 = 0
  878. ipSystemStatsOutMcastOctets.ipv6 = 0
  879. ipSystemStatsHCOutMcastOctets.ipv4 = 0
  880. ipSystemStatsHCOutMcastOctets.ipv6 = 0
  881. ipSystemStatsInBcastPkts.ipv4 = 123
  882. ipSystemStatsHCInBcastPkts.ipv4 = 123
  883. ipSystemStatsOutBcastPkts.ipv4 = 0
  884. ipSystemStatsHCOutBcastPkts.ipv4 = 0
  885. ipSystemStatsDiscontinuityTime.ipv4 = 0:0:00:00.00
  886. ipSystemStatsDiscontinuityTime.ipv6 = 0:0:00:00.00
  887. ipSystemStatsRefreshRate.ipv4 = 60000
  888. ipSystemStatsRefreshRate.ipv6 = 60000  
  889.  
  890. ipv4 ipv6
  891.  
  892. >> Runtime for poller module 'ipSystemStats': 0.1267 seconds with 16064 bytes
  893. >> [0;36mSNMP[0m: [1/0.13s] [1;33mMySQL[0m: [0/0.00s]  
  894. #### Unload poller module ipSystemStats ####
  895.  
  896. Modules status: Global+  
  897. OS  
  898. Device  
  899.  
  900. #### Load poller module ports ####
  901. 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[784][0m 0.83ms]
  902.  
  903. Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'ifXEntry'[0m]
  904. ifName.1 = lo
  905. ifName.2 = eth0
  906. ifName.3 = sit0
  907. ifInMulticastPkts.1 = 0
  908. ifInMulticastPkts.2 = 0
  909. ifInMulticastPkts.3 = 0
  910. ifInBroadcastPkts.1 = 0
  911. ifInBroadcastPkts.2 = 0
  912. ifInBroadcastPkts.3 = 0
  913. ifOutMulticastPkts.1 = 0
  914. ifOutMulticastPkts.2 = 0
  915. ifOutMulticastPkts.3 = 0
  916. ifOutBroadcastPkts.1 = 0
  917. ifOutBroadcastPkts.2 = 0
  918. ifOutBroadcastPkts.3 = 0
  919. ifHCInOctets.1 = 42859881055
  920. ifHCInOctets.2 = 4049624
  921. ifHCInOctets.3 = 0
  922. ifHCInUcastPkts.1 = 178203894
  923. ifHCInUcastPkts.2 = 30675
  924. ifHCInUcastPkts.3 = 0
  925. ifHCInMulticastPkts.1 = 0
  926. ifHCInMulticastPkts.2 = 0
  927. ifHCInMulticastPkts.3 = 0
  928. ifHCInBroadcastPkts.1 = 0
  929. ifHCInBroadcastPkts.2 = 0
  930. ifHCInBroadcastPkts.3 = 0
  931. ifHCOutOctets.1 = 42859881055
  932. ifHCOutOctets.2 = 62639058
  933. ifHCOutOctets.3 = 0
  934. ifHCOutUcastPkts.1 = 178203894
  935. ifHCOutUcastPkts.2 = 14717
  936. ifHCOutUcastPkts.3 = 0
  937. ifHCOutMulticastPkts.1 = 0
  938. ifHCOutMulticastPkts.2 = 0
  939. ifHCOutMulticastPkts.3 = 0
  940. ifHCOutBroadcastPkts.1 = 0
  941. ifHCOutBroadcastPkts.2 = 0
  942. ifHCOutBroadcastPkts.3 = 0
  943. ifHighSpeed.1 = 10
  944. ifHighSpeed.2 = 100
  945. ifHighSpeed.3 = 0
  946. ifPromiscuousMode.1 = false
  947. ifPromiscuousMode.2 = false
  948. ifPromiscuousMode.3 = false
  949. ifConnectorPresent.1 = false
  950. ifConnectorPresent.2 = true
  951. ifConnectorPresent.3 = true
  952. ifAlias.1 =
  953. ifAlias.2 =
  954. ifAlias.3 =
  955. ifCounterDiscontinuityTime.1 = 0:0:00:00.00
  956. ifCounterDiscontinuityTime.2 = 0:0:00:00.00
  957. ifCounterDiscontinuityTime.3 = 0:0:00:00.00  
  958.  
  959. ifDescr SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'ifDescr'[0m]
  960. ifDescr.1 = lo
  961. ifDescr.2 = eth0
  962. ifDescr.3 = sit0  
  963.  
  964. ifAdminStatus SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'ifAdminStatus'[0m]
  965. ifAdminStatus.1 = up
  966. ifAdminStatus.2 = up
  967. ifAdminStatus.3 = down  
  968.  
  969. ifOperStatus SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'ifOperStatus'[0m]
  970. ifOperStatus.1 = up
  971. ifOperStatus.2 = up
  972. ifOperStatus.3 = down  
  973.  
  974. ifLastChange SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'ifLastChange'[0m]
  975. ifLastChange.1 = 0
  976. ifLastChange.2 = 0
  977. ifLastChange.3 = 0  
  978.  
  979. ifType SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'ifType'[0m]
  980. ifType.1 = softwareLoopback
  981. ifType.2 = ethernetCsmacd
  982. ifType.3 = tunnel  
  983.  
  984. ifPhysAddress SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'ifPhysAddress'[0m]
  985. ifPhysAddress.1 =
  986. ifPhysAddress.2 = 50:2d:f4:1e:2:d1
  987. ifPhysAddress.3 =  
  988.  
  989. ifMtu SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'ifMtu'[0m]
  990. ifMtu.1 = 65536
  991. ifMtu.2 = 1500
  992. ifMtu.3 = 1480  
  993.  
  994. ifInErrors SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'ifInErrors'[0m]
  995. ifInErrors.1 = 0
  996. ifInErrors.2 = 0
  997. ifInErrors.3 = 0  
  998.  
  999. ifOutErrors SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'ifOutErrors'[0m]
  1000. ifOutErrors.1 = 0
  1001. ifOutErrors.2 = 0
  1002. ifOutErrors.3 = 0  
  1003.  
  1004. ifInDiscards SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'ifInDiscards'[0m]
  1005. ifInDiscards.1 = 0
  1006. ifInDiscards.2 = 0
  1007. ifInDiscards.3 = 0  
  1008.  
  1009. ifOutDiscards SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'ifOutDiscards'[0m]
  1010. ifOutDiscards.1 = 0
  1011. ifOutDiscards.2 = 0
  1012. ifOutDiscards.3 = 0  
  1013.  
  1014. dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m]
  1015. dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
  1016.  
  1017. Invalid snmp_walk() data = dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
  1018. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'MD5' '-A' 'PASSWORD' '-u' 'USER' '-x' 'DES' '-X' 'PASSWORD' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/nms/mibs' 'udp:HOSTNAME:161' 'dot1qPvid'[0m]
  1019. dot1qPvid = No Such Object available on this agent at this OID  
  1020.  
  1021. Invalid snmp_walk() data = dot1qPvid = No Such Object available on this agent at this OID  
  1022. SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl','vdsl2') [0;33m[784][0m 0.44ms]
  1023.  
  1024. array (
  1025.   1 =>
  1026.   array (
  1027.     'ifName' => 'lo',
  1028.     'ifInMulticastPkts' => '0',
  1029.     'ifInBroadcastPkts' => '0',
  1030.     'ifOutMulticastPkts' => '0',
  1031.     'ifOutBroadcastPkts' => '0',
  1032.     'ifHCInOctets' => '42859881055',
  1033.     'ifHCInUcastPkts' => '178203894',
  1034.     'ifHCInMulticastPkts' => '0',
  1035.     'ifHCInBroadcastPkts' => '0',
  1036.     'ifHCOutOctets' => '42859881055',
  1037.     'ifHCOutUcastPkts' => '178203894',
  1038.     'ifHCOutMulticastPkts' => '0',
  1039.     'ifHCOutBroadcastPkts' => '0',
  1040.     'ifHighSpeed' => '10',
  1041.     'ifPromiscuousMode' => 'false',
  1042.     'ifConnectorPresent' => 'false',
  1043.     'ifAlias' => '',
  1044.     'ifCounterDiscontinuityTime' => '0:0:00:00.00',
  1045.     'ifDescr' => 'lo',
  1046.     'ifAdminStatus' => 'up',
  1047.     'ifOperStatus' => 'up',
  1048.     'ifLastChange' => '0',
  1049.     'ifType' => 'softwareLoopback',
  1050.     'ifPhysAddress' => '',
  1051.     'ifMtu' => '65536',
  1052.     'ifInErrors' => '0',
  1053.     'ifOutErrors' => '0',
  1054.     'ifInDiscards' => '0',
  1055.     'ifOutDiscards' => '0',
  1056.   ),
  1057.   2 =>
  1058.   array (
  1059.     'ifName' => 'eth0',
  1060.     'ifInMulticastPkts' => '0',
  1061.     'ifInBroadcastPkts' => '0',
  1062.     'ifOutMulticastPkts' => '0',
  1063.     'ifOutBroadcastPkts' => '0',
  1064.     'ifHCInOctets' => '4049624',
  1065.     'ifHCInUcastPkts' => '30675',
  1066.     'ifHCInMulticastPkts' => '0',
  1067.     'ifHCInBroadcastPkts' => '0',
  1068.     'ifHCOutOctets' => '62639058',
  1069.     'ifHCOutUcastPkts' => '14717',
  1070.     'ifHCOutMulticastPkts' => '0',
  1071.     'ifHCOutBroadcastPkts' => '0',
  1072.     'ifHighSpeed' => '100',
  1073.     'ifPromiscuousMode' => 'false',
  1074.     'ifConnectorPresent' => 'true',
  1075.     'ifAlias' => '',
  1076.     'ifCounterDiscontinuityTime' => '0:0:00:00.00',
  1077.     'ifDescr' => 'eth0',
  1078.     'ifAdminStatus' => 'up',
  1079.     'ifOperStatus' => 'up',
  1080.     'ifLastChange' => '0',
  1081.     'ifType' => 'ethernetCsmacd',
  1082.     'ifPhysAddress' => '50:2d:f4:1e:2:d1',
  1083.     'ifMtu' => '1500',
  1084.     'ifInErrors' => '0',
  1085.     'ifOutErrors' => '0',
  1086.     'ifInDiscards' => '0',
  1087.     'ifOutDiscards' => '0',
  1088.   ),
  1089.   3 =>
  1090.   array (
  1091.     'ifName' => 'sit0',
  1092.     'ifInMulticastPkts' => '0',
  1093.     'ifInBroadcastPkts' => '0',
  1094.     'ifOutMulticastPkts' => '0',
  1095.     'ifOutBroadcastPkts' => '0',
  1096.     'ifHCInOctets' => '0',
  1097.     'ifHCInUcastPkts' => '0',
  1098.     'ifHCInMulticastPkts' => '0',
  1099.     'ifHCInBroadcastPkts' => '0',
  1100.     'ifHCOutOctets' => '0',
  1101.     'ifHCOutUcastPkts' => '0',
  1102.     'ifHCOutMulticastPkts' => '0',
  1103.     'ifHCOutBroadcastPkts' => '0',
  1104.     'ifHighSpeed' => '0',
  1105.     'ifPromiscuousMode' => 'false',
  1106.     'ifConnectorPresent' => 'true',
  1107.     'ifAlias' => '',
  1108.     'ifCounterDiscontinuityTime' => '0:0:00:00.00',
  1109.     'ifDescr' => 'sit0',
  1110.     'ifAdminStatus' => 'down',
  1111.     'ifOperStatus' => 'down',
  1112.     'ifLastChange' => '0',
  1113.     'ifType' => 'tunnel',
  1114.     'ifPhysAddress' => '',
  1115.     'ifMtu' => '1480',
  1116.     'ifInErrors' => '0',
  1117.     'ifOutErrors' => '0',
  1118.     'ifInDiscards' => '0',
  1119.     'ifOutDiscards' => '0',
  1120.   ),
  1121. )  
  1122.  valid  
  1123.  valid  
  1124.  valid  
  1125.  
  1126. Port lo: lo (1 / #2105985) ifHCInOctets  
  1127. ifHCOutOctets  
  1128. ifHCInUcastPkts  
  1129. ifHCOutUcastPkts  
  1130. ifInBroadcastPkts  
  1131. ifOutBroadcastPkts  
  1132. ifInMulticastPkts  
  1133. ifOutMulticastPkts  
  1134. ifHighSpeed (10)  
  1135. VLAN =   Using ifDescr as ifAlias  
  1136. lo
  1137.  ifInOctets (1059091 B) 11899.898876404 Bps 89 secs  
  1138.  
  1139.  ifOutOctets (1059091 B) 11899.898876404 Bps 89 secs  
  1140.  
  1141.  ifInErrors (0 B) 0 Bps 89 secs  
  1142.  
  1143.  ifOutErrors (0 B) 0 Bps 89 secs  
  1144.  
  1145.  ifInUcastPkts (4478 B) 50.314606741573 Bps 89 secs  
  1146.  
  1147.  ifOutUcastPkts (4478 B) 50.314606741573 Bps 89 secs  
  1148.  
  1149.  ifInNUcastPkts (0 B) 0 Bps 89 secs  
  1150.  
  1151.  ifOutNUcastPkts (0 B) 0 Bps 89 secs  
  1152.  
  1153.  ifInDiscards (0 B) 0 Bps 89 secs  
  1154.  
  1155.  ifOutDiscards (0 B) 0 Bps 89 secs  
  1156.  
  1157.  ifInUnknownProtos (0 B) 0 Bps 89 secs  
  1158.  
  1159.  ifInBroadcastPkts (0 B) 0 Bps 89 secs  
  1160.  
  1161.  ifOutBroadcastPkts (0 B) 0 Bps 89 secs  
  1162.  
  1163.  ifInMulticastPkts (0 B) 0 Bps 89 secs  
  1164.  
  1165.  ifOutMulticastPkts (0 B) 0 Bps 89 secs  
  1166. bps(95.2 Kbps/95.2 Kbps)bytes(1.01 MiB/1.01 MiB)pkts(50.31 pps/50.31 pps)SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["42859881055",42858821964,11899.898876404495,1059091,"42859881055",42858821964,11899.898876404495,1059091,"0",0,0,0,"0",0,0,0,"178203894",178199416,50.31460674157304,4478,"178203894",178199416,50.31460674157304,4478,1642596982,1642596893,89,2105985][0m 0.55ms]
  1167.  
  1168. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m[0,0,0,0,0,0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,2105985][0m 0.31ms]
  1169.  
  1170. 1 updated  
  1171.  
  1172. Port eth0: eth0 (2 / #2105986) ifHCInOctets  
  1173. ifHCOutOctets  
  1174. ifHCInUcastPkts  
  1175. ifHCOutUcastPkts  
  1176. ifInBroadcastPkts  
  1177. ifOutBroadcastPkts  
  1178. ifInMulticastPkts  
  1179. ifOutMulticastPkts  
  1180. ifHighSpeed (100)  
  1181. VLAN =   Using ifDescr as ifAlias  
  1182. eth0
  1183.  ifInOctets (134227 B) 1508.1685393258 Bps 89 secs  
  1184.  
  1185.  ifOutOctets (243283 B) 2733.5168539326 Bps 89 secs  
  1186.  
  1187.  ifInErrors (0 B) 0 Bps 89 secs  
  1188.  
  1189.  ifOutErrors (0 B) 0 Bps 89 secs  
  1190.  
  1191.  ifInUcastPkts (799 B) 8.9775280898876 Bps 89 secs  
  1192.  
  1193.  ifOutUcastPkts (709 B) 7.9662921348315 Bps 89 secs  
  1194.  
  1195.  ifInNUcastPkts (0 B) 0 Bps 89 secs  
  1196.  
  1197.  ifOutNUcastPkts (0 B) 0 Bps 89 secs  
  1198.  
  1199.  ifInDiscards (0 B) 0 Bps 89 secs  
  1200.  
  1201.  ifOutDiscards (0 B) 0 Bps 89 secs  
  1202.  
  1203.  ifInUnknownProtos (0 B) 0 Bps 89 secs  
  1204.  
  1205.  ifInBroadcastPkts (0 B) 0 Bps 89 secs  
  1206.  
  1207.  ifOutBroadcastPkts (0 B) 0 Bps 89 secs  
  1208.  
  1209.  ifInMulticastPkts (0 B) 0 Bps 89 secs  
  1210.  
  1211.  ifOutMulticastPkts (0 B) 0 Bps 89 secs  
  1212. bps(12.07 Kbps/21.87 Kbps)bytes(131.08 KiB/237.58 KiB)pkts(8.98 pps/7.97 pps)SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["4049624",3915397,1508.1685393258426,134227,"62639058",62395775,2733.516853932584,243283,"0",0,0,0,"0",0,0,0,"30675",29876,8.97752808988764,799,"14717",14008,7.966292134831461,709,1642596982,1642596893,89,2105986][0m 0.44ms]
  1213.  
  1214. SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m[0,0,0,0,0,0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,2105986][0m 0.28ms]
  1215.  
  1216. 1 updated  
  1217.  
  1218. Port sit0: sit0 (3 / #2105987) ifInOctets  
  1219. ifOutOctets  
  1220. ifInUcastPkts  
  1221. ifOutUcastPkts  
  1222. ifInBroadcastPkts  
  1223. ifOutBroadcastPkts  
  1224. ifInMulticastPkts  
  1225. ifOutMulticastPkts  
  1226. ifHighSpeed (0)  
  1227. VLAN =   Using ifDescr as ifAlias  
  1228. sit02105987 skipped because port is still down since last polling.  
  1229. SQL[[1;33mUPDATE `ports` set `ifSpeed_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["0000000",1642596982,1642596893,89,2105987][0m 0.29ms]
  1230.  
  1231. 1 updated  
  1232.  
  1233. SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1642596982,1642596893,null][0m 0.13ms]
  1234.  
  1235. 0 updated  
  1236.  
  1237. >> Runtime for poller module 'ports': 0.6502 seconds with 37472 bytes
  1238. >> [0;36mSNMP[0m: [14/0.64s] [1;33mMySQL[0m: [8/0.03s]  
  1239. #### Unload poller module ports ####
  1240.  
  1241. Modules status: Global+  
  1242. OS  
  1243. Device  
  1244.  
  1245. #### Load poller module customoid ####
  1246. SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[784][0m 0.3ms]
  1247.  
  1248.  
  1249. >> Runtime for poller module 'customoid': 0.0007 seconds with 1320 bytes
  1250. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  1251. #### Unload poller module customoid ####
  1252.  
  1253. Modules status: Global+  
  1254. OS-  
  1255. Device  
  1256. Module [ bgp-peers ] disabled on os.
  1257.  
  1258. Modules status: Global-  
  1259. OS  
  1260. Device  
  1261. Module [ junose-atm-vp ] disabled globally.
  1262.  
  1263. Modules status: Global-  
  1264. OS  
  1265. Device  
  1266. Module [ printer-supplies ] disabled globally.
  1267.  
  1268. Modules status: Global+  
  1269. OS  
  1270. Device  
  1271.  
  1272. #### Load poller module ucd-diskio ####
  1273. SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id`  = ? [0;33m[784][0m 0.18ms]
  1274.  
  1275.  
  1276. >> Runtime for poller module 'ucd-diskio': 0.0004 seconds with 816 bytes
  1277. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  1278. #### Unload poller module ucd-diskio ####
  1279.  
  1280. Modules status: Global+  
  1281. OS  
  1282. Device  
  1283.  
  1284. #### Load poller module wifi ####
  1285.  
  1286. >> Runtime for poller module 'wifi': 0.0001 seconds with 560 bytes
  1287. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
  1288. #### Unload poller module wifi ####
  1289.  
  1290. Modules status: Global+  
  1291. OS  
  1292. Device  
  1293.  
  1294. #### Load poller module wireless ####
  1295. Attempting to initialize OS: linux  
  1296. Attempting to initialize Group OS: unix  
  1297. OS initialized: LibreNMS\OS\Shared\Unix  
  1298. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[784][0m 0.21ms]
  1299.  
  1300.  
  1301. >> Runtime for poller module 'wireless': 0.0014 seconds with 103120 bytes
  1302. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  1303. #### Unload poller module wireless ####
  1304.  
  1305. Modules status: Global+  
  1306. OS-  
  1307. Device  
  1308. Module [ ospf ] disabled on os.
  1309.  
  1310. Modules status: Global-  
  1311. OS  
  1312. Device  
  1313. Module [ isis ] disabled globally.
  1314.  
  1315. Modules status: Global-  
  1316. OS  
  1317. Device  
  1318. Module [ cisco-ipsec-flow-monitor ] disabled globally.
  1319.  
  1320. Modules status: Global-  
  1321. OS  
  1322. Device  
  1323. Module [ cisco-remote-access-monitor ] disabled globally.
  1324.  
  1325. Modules status: Global-  
  1326. OS  
  1327. Device  
  1328. Module [ cisco-cef ] disabled globally.
  1329.  
  1330. Modules status: Global-  
  1331. OS  
  1332. Device  
  1333. Module [ slas ] disabled globally.
  1334.  
  1335. Modules status: Global-  
  1336. OS  
  1337. Device  
  1338. Module [ cisco-mac-accounting ] disabled globally.
  1339.  
  1340. Modules status: Global-  
  1341. OS  
  1342. Device  
  1343. Module [ cipsec-tunnels ] disabled globally.
  1344.  
  1345. Modules status: Global-  
  1346. OS  
  1347. Device  
  1348. Module [ cisco-ace-loadbalancer ] disabled globally.
  1349.  
  1350. Modules status: Global-  
  1351. OS  
  1352. Device  
  1353. Module [ cisco-ace-serverfarms ] disabled globally.
  1354.  
  1355. Modules status: Global-  
  1356. OS  
  1357. Device  
  1358. Module [ cisco-asa-firewall ] disabled globally.
  1359.  
  1360. Modules status: Global-  
  1361. OS  
  1362. Device  
  1363. Module [ cisco-voice ] disabled globally.
  1364.  
  1365. Modules status: Global-  
  1366. OS  
  1367. Device  
  1368. Module [ cisco-cbqos ] disabled globally.
  1369.  
  1370. Modules status: Global-  
  1371. OS  
  1372. Device  
  1373. Module [ cisco-otv ] disabled globally.
  1374.  
  1375. Modules status: Global-  
  1376. OS  
  1377. Device  
  1378. Module [ cisco-qfp ] disabled globally.
  1379.  
  1380. Modules status: Global-  
  1381. OS  
  1382. Device  
  1383. Module [ cisco-vpdn ] disabled globally.
  1384.  
  1385. Modules status: Global-  
  1386. OS  
  1387. Device  
  1388. Module [ nac ] disabled globally.
  1389.  
  1390. Modules status: Global-  
  1391. OS  
  1392. Device  
  1393. Module [ netscaler-vsvr ] disabled globally.
  1394.  
  1395. Modules status: Global-  
  1396. OS  
  1397. Device  
  1398. Module [ aruba-controller ] disabled globally.
  1399.  
  1400. Modules status: Global+  
  1401. OS  
  1402. Device  
  1403.  
  1404. #### Load poller module entity-physical ####
  1405.  
  1406. >> Runtime for poller module 'entity-physical': 0.0001 seconds with 520 bytes
  1407. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
  1408. #### Unload poller module entity-physical ####
  1409.  
  1410. Modules status: Global-  
  1411. OS  
  1412. Device  
  1413. Module [ entity-state ] disabled globally.
  1414.  
  1415. Modules status: Global+  
  1416. OS  
  1417. Device  
  1418.  
  1419. #### Load poller module applications ####
  1420. SQL[[1;33mSELECT * FROM `applications` WHERE `device_id`  = ? [0;33m[784][0m 0.17ms]
  1421.  
  1422.  
  1423. >> Runtime for poller module 'applications': 0.0003 seconds with 464 bytes
  1424. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  1425. #### Unload poller module applications ####
  1426.  
  1427. Modules status: Global+  
  1428. OS  
  1429. Device  
  1430.  
  1431. #### Load poller module mib ####
  1432.  
  1433. Warning: include(includes/polling/mib.inc.php): failed to open stream: No such file or directory in /opt/nms/includes/polling/functions.inc.php on line 329
  1434.  
  1435. Warning: include(): Failed opening 'includes/polling/mib.inc.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php') in /opt/nms/includes/polling/functions.inc.php on line 329
  1436.  
  1437. >> Runtime for poller module 'mib': 0.0000 seconds with 0 bytes
  1438. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
  1439. #### Unload poller module mib ####
  1440.  
  1441. Modules status: Global+  
  1442. OS-  
  1443. Device  
  1444. Module [ stp ] disabled on os.
  1445.  
  1446. Modules status: Global+  
  1447. OS  
  1448. Device  
  1449.  
  1450. #### Load poller module ntp ####
  1451.  
  1452. >> Runtime for poller module 'ntp': 0.0001 seconds with 368 bytes
  1453. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
  1454. #### Unload poller module ntp ####
  1455.  
  1456. Modules status: Global-  
  1457. OS  
  1458. Device  
  1459. Module [ loadbalancers ] disabled globally.
  1460.  
  1461. Modules status: Global-  
  1462. OS  
  1463. Device  
  1464. Module [ mef ] disabled globally.
  1465.  
  1466. Modules status: Global+  
  1467. OS  
  1468. Device  
  1469.  
  1470. #### Load poller module mpls ####
  1471.  
  1472. >> Runtime for poller module 'mpls': 0.0002 seconds with 24080 bytes
  1473. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
  1474. #### Unload poller module mpls ####
  1475.  
  1476. Enabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[784][0m 0.28ms]
  1477.  
  1478.  
  1479. SQL[[1;33mUPDATE `devices` set `last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[2.598,784][0m 0.33ms]
  1480.  
  1481. Updating 10.240.254.136  
  1482.  
  1483. Polled in 2.598 seconds
  1484. ### Start Device Groups ###
  1485. SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.21ms]
  1486.  
  1487. SQL[[1;33mselect `devices`.`device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id`, `device_group_device`.`device_id` as `pivot_device_id` from `devices` inner join `device_group_device` on `devices`.`device_id` = `device_group_device`.`device_id` where `device_group_device`.`device_group_id` in (2, 3, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 23) [0;33m[][0m 2.51ms]
  1488.  
  1489. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysName` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%Verw%",784][0m 0.23ms]
  1490.  
  1491. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysName` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[0;36mpe%",784][0m 0.13ms]
  1492.  
  1493. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["pfsense",784][0m 0.2ms]
  1494.  
  1495. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["gaia",784][0m 0.13ms]
  1496.  
  1497. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["linux",784][0m 0.13ms]
  1498.  
  1499. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["junos",784][0m 0.12ms]
  1500.  
  1501. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["sonicwall",784][0m 0.14ms]
  1502.  
  1503. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["netscaler",784][0m 0.13ms]
  1504.  
  1505. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["adva%",784][0m 0.12ms]
  1506.  
  1507. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["qnap",784][0m 0.13ms]
  1508.  
  1509. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%enexus%",784][0m 0.12ms]
  1510.  
  1511. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hardware` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[0mCS-55A2%",784][0m 0.13ms]
  1512.  
  1513. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysName` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[0;37mlc%",784][0m 0.17ms]
  1514.  
  1515. SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[784][0m 0.25ms]
  1516.  
  1517. Groups Added:  
  1518. Groups Removed:  
  1519. ### End Device Groups, runtime: 0.0244s ###
  1520.  
  1521. #### Start Alerts ####
  1522. 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[784][0m 0.28ms]
  1523.  
  1524. 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 `device_groups` inner join `alert_schedulables` on `device_groups`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` in (?)) or exists (select * from `locations` inner join `alert_schedulables` on `locations`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?))) as `exists` [0;33m["2022-01-19T12:56:22.467432Z","2022-01-19T12:56:22.467432Z",0,1,"12:56:22","12:56:22","12:56:22","12:56:22","[43m%","device",784,"device_group",14,"location",475][0m 0.64ms]
  1525.  
  1526. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[784][0m 0.33ms]
  1527.  
  1528. SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a
  1529.         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 = ?)
  1530.         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 = ?))
  1531.         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 = ?))
  1532.         LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
  1533.         WHERE a.disabled = 0 AND (
  1534.             (d.device_id IS NULL AND g.group_id IS NULL)
  1535.             OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=?))
  1536.             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))
  1537.         ) [0;33m[784,784,784,784,784,784,784,784][0m 1.39ms]
  1538.  
  1539. Rule [0;35m#1 (Devices up/down ):[0m  
  1540.  
  1541. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND devices.sysName NOT LIKE 'cpe%' AND devices.sysName NOT LIKE '%sdz216004%' AND devices.sysName NOT LIKE '[0mas0b92ca%' AND devices.sysName NOT LIKE 'rt%' [0;33m[784][0m 0.33ms]
  1542.  
  1543. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[1,784][0m 0.15ms]
  1544.  
  1545. Status: [0;34mNOCHG[0m  
  1546. Rule [0;35m#2 (Device rebooted):[0m  
  1547.  
  1548. 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 xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed bgpPeers.bgpPeerState = "established" xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed>ports.ifInOctets_rate, ports.ifOutOctets_rate, ports.ifInOctets_rate)*8) / ports.ifSpeed)*100) >= 80 AND (ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 AND (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0) = 1 [0;33m[784][0m 0.66ms]
  1549.  
  1550. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[6,784][0m 0.24ms]
  1551.  
  1552. Status: [0;34mNOCHG[0m  
  1553. Rule [0;35m#7 (Sensor over limit):[0m  
  1554.  
  1555. 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[784][0m 0.36ms]
  1556.  
  1557. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[7,784][0m 0.12ms]
  1558.  
  1559. Status: [0;34mNOCHG[0m  
  1560. Rule [0;35m#8 (Sensor under limit):[0m  
  1561.  
  1562. 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 xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed>ports.ifInOctets_rate, ports.ifOutOctets_rate, ports.ifInOctets_rate)*8) / ports.ifSpeed)*100) >= 45 AND (ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 AND ports.ifName = "TenGigE0/0/0/0" [0;33m[784][0m 0.57ms]
  1563.  
  1564. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[18,784][0m 0.13ms]
  1565.  
  1566. Status: [0;34mNOCHG[0m  
  1567. Rule [0;35m#19 (Port utilisation over threshold DDOS RT1-FRA):[0m  
  1568.  
  1569. SQL[[1;33mSELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND (((SELECT IF(ports.ifOutOctets_rate>ports.ifInOctets_rate, ports.ifOutOctets_rate, ports.ifInOctets_rate)*8) / ports.ifSpeed)*100) >= 45 AND (ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 AND ports.ifName = "TenGigE0/0/0/0" [0;33m[784][0m 0.54ms]
  1570.  
  1571. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[19,784][0m 0.15ms]
  1572.  
  1573. Status: [0;34mNOCHG[0m  
  1574. Rule [0;35m#20 (Port utilisation over threshold DDOS RT2-FRA):[0m  
  1575.  
  1576. SQL[[1;33mSELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND (((SELECT IF(ports.ifOutOctets_rate>ports.ifInOctets_rate, ports.ifOutOctets_rate, ports.ifInOctets_rate)*8) / ports.ifSpeed)*100) >= 45 AND (ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 AND ports.ifName = "TenGigE0/0/0/0" [0;33m[784][0m 0.55ms]
  1577.  
  1578. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[20,784][0m 0.15ms]
  1579.  
  1580. Status: [0;34mNOCHG[0m  
  1581. Rule [0;35m#21 (Port utilisation over threshold DDOS RT1-DUE):[0m  
  1582.  
  1583. SQL[[1;33mSELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND (((SELECT IF(ports.ifOutOctets_rate>ports.ifInOctets_rate, ports.ifOutOctets_rate, ports.ifInOctets_rate)*8) / ports.ifSpeed)*100) >= 45 AND (ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 AND ports.ifName = "TenGigE0/0/0/0" [0;33m[784][0m 0.55ms]
  1584.  
  1585. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[21,784][0m 0.12ms]
  1586.  
  1587. Status: [0;34mNOCHG[0m  
  1588. Rule [0;35m#22 (Interface error rate over limit):[0m  
  1589.  
  1590. SQL[[1;33mSELECT * FROM devices,ports WHERE (devices.device_id = ? AND devices.device_id = ports.device_id) AND ports.ifInErrors_rate >= 150 [0;33m[784][0m 0.44ms]
  1591.  
  1592. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[22,784][0m 0.12ms]
  1593.  
  1594. Status: [0;34mNOCHG[0m  
  1595. #### End Alerts ####
  1596.  
  1597. ./poller.php 10.240.254.136 2022-01-19 13:56:22 - 1 devices polled in 2.868 secs  
  1598.  
  1599. [0;36mSNMP[0m [30/1.50s]: Snmpget[13/0.63s] Snmpwalk[17/0.87s]  
  1600. [1;33mSQL[0m [117/0.41s]: Select[87/0.30s] Delete[3/0.01s] Insert[1/0.01s] Update[26/0.10s]  
  1601.