From administrator, 1 Year 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.49ms]
  3.  
  4. SQL[[1;33mselect count(*) as aggregate from `migrations` [0;33m[][0m 0.28ms]
  5.  
  6. SQL[[1;33mselect version() [0;33m[][0m 0.23ms]
  7.  
  8. ===========================================
  9. Component | Version
  10. --------- | -------
  11. LibreNMS  | 23.1.0 (2023-01-25T00:15:05+01:00)
  12. DB Schema | 2022_08_15_084507_add_rrd_type_to_wireless_sensors_table (248)
  13. PHP       | 8.1.2-1ubuntu2.10
  14. Python    | 3.10.6
  15. Database  | MariaDB 10.6.11-MariaDB-0ubuntu0.22.04.1
  16. RRDTool   | 1.7.2
  17. SNMP      | 5.9.1
  18. ===========================================
  19. DEBUG!
  20. Updating os_def.cache  
  21. Reporting disabled by user setting  
  22. Starting polling run:
  23.  
  24. SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '10.32.32.147' ORDER BY `device_id` ASC [0;33m[][0m 0.79ms]
  25.  
  26. SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[124][0m 0.42ms]
  27.  
  28. SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[124][0m 0.32ms]
  29.  
  30. Attempting to initialize OS: linux  
  31. Attempting to initialize Group OS: unix  
  32. OS initialized: LibreNMS\OS\Shared\Unix  
  33. Hostname:    10.32.32.147
  34. Device ID:   124
  35. OS:          linux
  36.  (unix)
  37.  
  38. [FPING] '/usr/bin/fping' '-e' '-q' '-c' '4' '-p' '1000' '-t' '1000' '-O' '0' '10.32.32.147'
  39.  
  40. response: xmt/rcv/%loss = 4/4/0%, min/avg/max = 0.621/1.07/1.72  
  41. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' '-t' '10' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m]  
  42. SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::enterprises.8*
  43.  
  44.  
  45. SQL[[1;33minsert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `debug`, `device_id`, `timestamp`) values (?, ?, ?, ?, ?, ?, ?, ?, ?) [0;33m[0.621,1.72,1.07,4,4,0,"{\"poller_name\":\"FR-LME-SR-LNMS1\"}",124,"2023-02-02 16:53:58"][0m 1.84ms]
  46.  
  47. SQL[[1;33mupdate `devices` set `last_ping_timetaken` = ? where `device_id` = ? [0;33m[1.07,124][0m 1.38ms]
  48.  
  49. 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[124][0m 0.69ms]
  50.  
  51. Modules status: Global+  
  52. OS  
  53. Device  
  54.  
  55. #### Load poller module core ####
  56. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' '-On' '-t' '10' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysUpTime.0'[0m]  
  57. .*.*.0 = 199467567
  58.  
  59.  
  60. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' '-t' '10' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0'[0m]  
  61. SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = 1994676
  62. HOST-RESOURCES-MIB::hrSystemUptime.0 = No Such Object available on this agent at this OID
  63.  
  64.  
  65. Uptime seconds: 1994676
  66.  
  67. Uptime: 3 weeks 2 days 2 hours 4 minutes 36 seconds
  68. SQL[[1;33mupdate `devices` set `uptime` = ? where `device_id` = ? [0;33m[1994676,124][0m 1.48ms]
  69.  
  70.  
  71. >> Runtime for poller module 'core': 0.0840 seconds with 110112 bytes
  72. >> [0;36mSNMP[0m: [2/0.08s] [1;33mMySQL[0m: [1/0.01s]  
  73. #### Unload poller module core ####
  74.  
  75. Modules status: Global-  
  76. OS  
  77. Device  
  78. Module [ unix-agent ] disabled globally.
  79.  
  80. Modules status: Global+  
  81. OS  
  82. Device  
  83.  
  84. #### Load poller module os ####
  85. Generic :(
  86. SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[192][0m 0.39ms]
  87.  
  88. Location: ACI - Guardhouse
  89. Hardware:
  90. OS Version:
  91. OS Features:
  92. Serial:
  93.  
  94. >> Runtime for poller module 'os': 0.0024 seconds with 118304 bytes
  95. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  96. #### Unload poller module os ####
  97.  
  98. Modules status: Global+  
  99. OS  
  100. Device  
  101.  
  102. #### Load poller module availability ####
  103. SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[124][0m 0.36ms]
  104.  
  105. Availability:
  106. SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[124][0m 0.29ms]
  107.  
  108. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[124,1675266838][0m 0.31ms]
  109.  
  110. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,489][0m 0.21ms]
  111.  
  112. 1 day : 100%
  113. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[124,1674748438][0m 0.31ms]
  114.  
  115. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,490][0m 0.16ms]
  116.  
  117. 1 week : 100%
  118. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[124,1672761238][0m 0.24ms]
  119.  
  120. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,491][0m 0.15ms]
  121.  
  122. 1 month : 100%
  123. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[124,1643817238][0m 0.24ms]
  124.  
  125. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.983,492][0m 0.16ms]
  126.  
  127. 1 year : 99.983%
  128.  
  129. >> Runtime for poller module 'availability': 0.0052 seconds with 19816 bytes
  130. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [10/0.02s]  
  131. #### Unload poller module availability ####
  132.  
  133. Modules status: Global+  
  134. OS  
  135. Device  
  136.  
  137. #### Load poller module ipmi ####
  138. SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[124][0m 0.32ms]
  139.  
  140. array (
  141. )  
  142.  
  143. >> Runtime for poller module 'ipmi': 0.0007 seconds with 1984 bytes
  144. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  145. #### Unload poller module ipmi ####
  146.  
  147. Modules status: Global+  
  148. OS  
  149. Device  
  150.  
  151. #### Load poller module sensors ####
  152. SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[124][0m 0.27ms]
  153.  
  154.  
  155. >> Runtime for poller module 'sensors': 0.0005 seconds with 992 bytes
  156. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  157. #### Unload poller module sensors ####
  158.  
  159. Modules status: Global+  
  160. OS  
  161. Device  
  162.  
  163. #### Load poller module processors ####
  164. Attempting to initialize OS: linux  
  165. Attempting to initialize Group OS: unix  
  166. OS initialized: LibreNMS\OS\Shared\Unix  
  167. SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[124][0m 0.23ms]
  168.  
  169.  
  170. >> Runtime for poller module 'processors': 0.0011 seconds with 59360 bytes
  171. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  172. #### Unload poller module processors ####
  173.  
  174. Modules status: Global+  
  175. OS  
  176. Device  
  177.  
  178. #### Load poller module mempools ####
  179. SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[124][0m 0.38ms]
  180.  
  181.  
  182. >> Runtime for poller module 'mempools': 0.0013 seconds with 79824 bytes
  183. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  184. #### Unload poller module mempools ####
  185.  
  186. Modules status: Global+  
  187. OS  
  188. Device  
  189.  
  190. #### Load poller module storage ####
  191. SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[124][0m 0.25ms]
  192.  
  193.  
  194. >> Runtime for poller module 'storage': 0.0005 seconds with 1328 bytes
  195. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  196. #### Unload poller module storage ####
  197.  
  198. Modules status: Global+  
  199. OS  
  200. Device  
  201.  
  202. #### Load poller module netstats ####
  203. icmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' '-t' '10' '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]  
  204. IP-MIB::icmpInMsgs.0 = No Such Object available on this agent at this OID
  205. IP-MIB::icmpOutMsgs.0 = No Such Object available on this agent at this OID
  206. IP-MIB::icmpInErrors.0 = No Such Object available on this agent at this OID
  207. IP-MIB::icmpOutErrors.0 = No Such Object available on this agent at this OID
  208. IP-MIB::icmpInEchos.0 = No Such Object available on this agent at this OID
  209. IP-MIB::icmpOutEchos.0 = No Such Object available on this agent at this OID
  210. IP-MIB::icmpInEchoReps.0 = No Such Object available on this agent at this OID
  211. IP-MIB::icmpOutEchoReps.0 = No Such Object available on this agent at this OID
  212. IP-MIB::icmpInDestUnreachs.0 = No Such Object available on this agent at this OID
  213. IP-MIB::icmpOutDestUnreachs.0 = No Such Object available on this agent at this OID
  214. IP-MIB::icmpInParmProbs.0 = No Such Object available on this agent at this OID
  215. IP-MIB::icmpInTimeExcds.0 = No Such Object available on this agent at this OID
  216. IP-MIB::icmpInSrcQuenchs.0 = No Such Object available on this agent at this OID
  217. IP-MIB::icmpInRedirects.0 = No Such Object available on this agent at this OID
  218. IP-MIB::icmpInTimestamps.0 = No Such Object available on this agent at this OID
  219. IP-MIB::icmpInTimestampReps.0 = No Such Object available on this agent at this OID
  220. IP-MIB::icmpInAddrMasks.0 = No Such Object available on this agent at this OID
  221. IP-MIB::icmpInAddrMaskReps.0 = No Such Object available on this agent at this OID
  222. IP-MIB::icmpOutTimeExcds.0 = No Such Object available on this agent at this OID
  223. IP-MIB::icmpOutParmProbs.0 = No Such Object available on this agent at this OID
  224. IP-MIB::icmpOutSrcQuenchs.0 = No Such Object available on this agent at this OID
  225. IP-MIB::icmpOutRedirects.0 = No Such Object available on this agent at this OID
  226. IP-MIB::icmpOutTimestamps.0 = No Such Object available on this agent at this OID
  227. IP-MIB::icmpOutTimestampReps.0 = No Such Object available on this agent at this OID
  228. IP-MIB::icmpOutAddrMasks.0 = No Such Object available on this agent at this OID
  229. IP-MIB::icmpOutAddrMaskReps.0 = No Such Object available on this agent at this OID
  230.  
  231.  
  232. ip SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' '-t' '10' '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]  
  233. IP-MIB::ipForwDatagrams.0 = No Such Object available on this agent at this OID
  234. IP-MIB::ipInDelivers.0 = No Such Object available on this agent at this OID
  235. IP-MIB::ipInReceives.0 = No Such Object available on this agent at this OID
  236. IP-MIB::ipOutRequests.0 = No Such Object available on this agent at this OID
  237. IP-MIB::ipInDiscards.0 = No Such Object available on this agent at this OID
  238. IP-MIB::ipOutDiscards.0 = No Such Object available on this agent at this OID
  239. IP-MIB::ipOutNoRoutes.0 = No Such Object available on this agent at this OID
  240. IP-MIB::ipReasmReqds.0 = No Such Object available on this agent at this OID
  241. IP-MIB::ipReasmOKs.0 = No Such Object available on this agent at this OID
  242. IP-MIB::ipReasmFails.0 = No Such Object available on this agent at this OID
  243. IP-MIB::ipFragOKs.0 = No Such Object available on this agent at this OID
  244. IP-MIB::ipFragFails.0 = No Such Object available on this agent at this OID
  245. IP-MIB::ipFragCreates.0 = No Such Object available on this agent at this OID
  246. IP-MIB::ipInUnknownProtos.0 = No Such Object available on this agent at this OID
  247. IP-MIB::ipInHdrErrors.0 = No Such Object available on this agent at this OID
  248. IP-MIB::ipInAddrErrors.0 = No Such Object available on this agent at this OID
  249.  
  250.  
  251. ip_forward SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' '-t' '10' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m]  
  252. IP-FORWARD-MIB::ipCidrRouteNumber.0 = No Such Object available on this agent at this OID
  253.  
  254.  
  255. snmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' '-t' '10' '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]  
  256. SNMPv2-MIB::snmpInPkts.0 = 515077
  257. SNMPv2-MIB::snmpOutPkts.0 = 253997
  258. SNMPv2-MIB::snmpInBadVersions.0 = 0
  259. SNMPv2-MIB::snmpInBadCommunityNames.0 = 1667
  260. SNMPv2-MIB::snmpInBadCommunityUses.0 = 0
  261. SNMPv2-MIB::snmpInASNParseErrs.0 = 66617
  262. SNMPv2-MIB::snmpInTooBigs.0 = 0
  263. SNMPv2-MIB::snmpInNoSuchNames.0 = 0
  264. SNMPv2-MIB::snmpInBadValues.0 = 0
  265. SNMPv2-MIB::snmpInReadOnlys.0 = 0
  266. SNMPv2-MIB::snmpInGenErrs.0 = 0
  267. SNMPv2-MIB::snmpInTotalReqVars.0 = 2118911
  268. SNMPv2-MIB::snmpInTotalSetVars.0 = 0
  269. SNMPv2-MIB::snmpInGetRequests.0 = 109165
  270. SNMPv2-MIB::snmpInGetNexts.0 = 620
  271. SNMPv2-MIB::snmpInSetRequests.0 = 0
  272. SNMPv2-MIB::snmpInGetResponses.0 = 0
  273. SNMPv2-MIB::snmpInTraps.0 = 0
  274. SNMPv2-MIB::snmpOutTooBigs.0 = 0
  275. SNMPv2-MIB::snmpOutNoSuchNames.0 = 0
  276. SNMPv2-MIB::snmpOutBadValues.0 = 0
  277. SNMPv2-MIB::snmpOutGenErrs.0 = 0
  278. SNMPv2-MIB::snmpOutGetRequests.0 = 0
  279. SNMPv2-MIB::snmpOutGetNexts.0 = 0
  280. SNMPv2-MIB::snmpOutSetRequests.0 = 0
  281. SNMPv2-MIB::snmpOutGetResponses.0 = 253993
  282. SNMPv2-MIB::snmpOutTraps.0 = 4
  283. SNMPv2-MIB::snmpSilentDrops.0 = 0
  284. SNMPv2-MIB::snmpProxyDrops.0 = 0
  285.  
  286.  
  287. udp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' '-t' '10' 'udp:HOSTNAME:161' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0'[0m]  
  288. UDP-MIB::udpInDatagrams.0 = No Such Object available on this agent at this OID
  289. UDP-MIB::udpOutDatagrams.0 = No Such Object available on this agent at this OID
  290. UDP-MIB::udpInErrors.0 = No Such Object available on this agent at this OID
  291. UDP-MIB::udpNoPorts.0 = No Such Object available on this agent at this OID
  292.  
  293.  
  294. tcp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v3' '-l' 'authPriv' '-n' "" '-x' 'AES' '-X' 'PASSWORD' '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-OQXUte' '-t' '10' '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]  
  295. TCP-MIB::tcpActiveOpens.0 = No Such Object available on this agent at this OID
  296. TCP-MIB::tcpPassiveOpens.0 = No Such Object available on this agent at this OID
  297. TCP-MIB::tcpAttemptFails.0 = No Such Object available on this agent at this OID
  298. TCP-MIB::tcpEstabResets.0 = No Such Object available on this agent at this OID
  299. TCP-MIB::tcpCurrEstab.0 = No Such Object available on this agent at this OID
  300. TCP-MIB::tcpInSegs.0 = No Such Object available on this agent at this OID
  301. TCP-MIB::tcpOutSegs.0 = No Such Object available on this agent at this OID
  302. TCP-MIB::tcpRetransSegs.0 = No Such Object available on this agent at this OID
  303. TCP-MIB::tcpInErrs.0 = No Such Object available on this agent at this OID
  304. TCP-MIB::tcpOutRsts.0 = No Such Object available on this agent at this OID
  305.  
  306.  
  307.  
  308.  
  309. >> Runtime for poller module 'netstats': 0.2144 seconds with 24232 bytes
  310. >> [0;36mSNMP[0m: [6/0.21s] [1;33mMySQL[0m: [0/0.00s]  
  311. #### Unload poller module netstats ####
  312.  
  313. Modules status: Global+  
  314. OS  
  315. Device  
  316.  
  317. #### Load poller module hr-mib ####
  318. SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs' '-t' '10' 'udp:HOSTNAME:161' 'hrSystemMaxProcesses.0' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m]
  319. hrSystemMaxProcesses.0 = No Such Object available on this agent at this OID
  320. hrSystemProcesses.0 = No Such Object available on this agent at this OID
  321. hrSystemNumUsers.0 = No Such Object available on this agent at this OID  
  322.  
  323.  
  324.  
  325. >> Runtime for poller module 'hr-mib': 0.0354 seconds with 544 bytes
  326. >> [0;36mSNMP[0m: [1/0.04s] [1;33mMySQL[0m: [0/0.00s]  
  327. #### Unload poller module hr-mib ####
  328.  
  329. Modules status: Global+  
  330. OS  
  331. Device  
  332.  
  333. #### Load poller module ucd-mib ####
  334. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' '-t' '10' 'udp:HOSTNAME:161' 'systemStats'[0m]
  335. systemStats = No Such Object available on this agent at this OID  
  336.  
  337. Invalid snmp_walk() data = systemStats = No Such Object available on this agent at this OID  
  338. SNMP[[0;36m'/usr/bin/snmpget' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' '-t' '10' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m]
  339. laLoadInt.1 = No Such Object available on this agent at this OID
  340. laLoadInt.2 = No Such Object available on this agent at this OID
  341. laLoadInt.3 = No Such Object available on this agent at this OID  
  342.  
  343.  
  344. >> Runtime for poller module 'ucd-mib': 0.3877 seconds with 65568 bytes
  345. >> [0;36mSNMP[0m: [2/0.39s] [1;33mMySQL[0m: [0/0.00s]  
  346. #### Unload poller module ucd-mib ####
  347.  
  348. Modules status: Global+  
  349. OS  
  350. Device  
  351.  
  352. #### Load poller module ipSystemStats ####
  353. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' '-t' '10' 'udp:HOSTNAME:161' 'ipSystemStats'[0m]
  354. ipSystemStatsTable = No Such Object available on this agent at this OID  
  355.  
  356. Invalid snmp_walk() data = ipSystemStatsTable = No Such Object available on this agent at this OID  
  357.  
  358.  
  359. >> Runtime for poller module 'ipSystemStats': 0.0392 seconds with 808 bytes
  360. >> [0;36mSNMP[0m: [1/0.04s] [1;33mMySQL[0m: [0/0.00s]  
  361. #### Unload poller module ipSystemStats ####
  362.  
  363. Modules status: Global+  
  364. OS  
  365. Device  
  366.  
  367. #### Load poller module ports ####
  368. 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[124][0m 1.08ms]
  369.  
  370. Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' '-t' '10' 'udp:HOSTNAME:161' 'ifXEntry'[0m]
  371. ifName.1 = lo
  372. ifName.2 = eth0
  373. ifName.3 = sit0
  374. ifInMulticastPkts.1 = 0
  375. ifInMulticastPkts.2 = 0
  376. ifInMulticastPkts.3 = 0
  377. ifInBroadcastPkts.1 = 0
  378. ifInBroadcastPkts.2 = 0
  379. ifInBroadcastPkts.3 = 0
  380. ifOutMulticastPkts.1 = 0
  381. ifOutMulticastPkts.2 = 0
  382. ifOutMulticastPkts.3 = 0
  383. ifOutBroadcastPkts.1 = 0
  384. ifOutBroadcastPkts.2 = 0
  385. ifOutBroadcastPkts.3 = 0
  386. ifHCInOctets.1 = 716463327
  387. ifHCInOctets.2 = 1323838463537
  388. ifHCInOctets.3 = 0
  389. ifHCInUcastPkts.1 = 4239083
  390. ifHCInUcastPkts.2 = 1449292013
  391. ifHCInUcastPkts.3 = 0
  392. ifHCInMulticastPkts.1 = 0
  393. ifHCInMulticastPkts.2 = 0
  394. ifHCInMulticastPkts.3 = 0
  395. ifHCInBroadcastPkts.1 = 0
  396. ifHCInBroadcastPkts.2 = 0
  397. ifHCInBroadcastPkts.3 = 0
  398. ifHCOutOctets.1 = 716463327
  399. ifHCOutOctets.2 = 153578870107
  400. ifHCOutOctets.3 = 0
  401. ifHCOutUcastPkts.1 = 4239083
  402. ifHCOutUcastPkts.2 = 124304421
  403. ifHCOutUcastPkts.3 = 0
  404. ifHCOutMulticastPkts.1 = 0
  405. ifHCOutMulticastPkts.2 = 0
  406. ifHCOutMulticastPkts.3 = 0
  407. ifHCOutBroadcastPkts.1 = 0
  408. ifHCOutBroadcastPkts.2 = 0
  409. ifHCOutBroadcastPkts.3 = 0
  410. ifHighSpeed.1 = 10
  411. ifHighSpeed.2 = 100
  412. ifHighSpeed.3 = 0
  413. ifPromiscuousMode.1 = false
  414. ifPromiscuousMode.2 = false
  415. ifPromiscuousMode.3 = false
  416. ifConnectorPresent.1 = false
  417. ifConnectorPresent.2 = true
  418. ifConnectorPresent.3 = true
  419. ifAlias.1 =
  420. ifAlias.2 =
  421. ifAlias.3 =
  422. ifCounterDiscontinuityTime.1 = 0:0:00:00.00
  423. ifCounterDiscontinuityTime.2 = 0:0:00:00.00
  424. ifCounterDiscontinuityTime.3 = 0:0:00:00.00  
  425.  
  426. ifDescr SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' '-t' '10' 'udp:HOSTNAME:161' 'ifDescr'[0m]
  427. ifDescr.1 = lo
  428. ifDescr.2 = eth0
  429. ifDescr.3 = sit0  
  430.  
  431. ifAdminStatus SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' '-t' '10' 'udp:HOSTNAME:161' 'ifAdminStatus'[0m]
  432. ifAdminStatus.1 = up
  433. ifAdminStatus.2 = up
  434. ifAdminStatus.3 = down  
  435.  
  436. ifOperStatus SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' '-t' '10' 'udp:HOSTNAME:161' 'ifOperStatus'[0m]
  437. ifOperStatus.1 = up
  438. ifOperStatus.2 = up
  439. ifOperStatus.3 = down  
  440.  
  441. ifLastChange SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' '-t' '10' 'udp:HOSTNAME:161' 'ifLastChange'[0m]
  442. ifLastChange.1 = 0
  443. ifLastChange.2 = 0
  444. ifLastChange.3 = 0  
  445.  
  446. ifType SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' '-t' '10' 'udp:HOSTNAME:161' 'ifType'[0m]
  447. ifType.1 = softwareLoopback
  448. ifType.2 = ethernetCsmacd
  449. ifType.3 = tunnel  
  450.  
  451. ifPhysAddress SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' '-t' '10' 'udp:HOSTNAME:161' 'ifPhysAddress'[0m]
  452. ifPhysAddress.1 =
  453. ifPhysAddress.2 = bc:32:5f:0:11:e0
  454. ifPhysAddress.3 =  
  455.  
  456. ifMtu SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' '-t' '10' 'udp:HOSTNAME:161' 'ifMtu'[0m]
  457. ifMtu.1 = 65536
  458. ifMtu.2 = 1500
  459. ifMtu.3 = 1480  
  460.  
  461. ifInErrors SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' '-t' '10' 'udp:HOSTNAME:161' 'ifInErrors'[0m]
  462. ifInErrors.1 = 0
  463. ifInErrors.2 = 0
  464. ifInErrors.3 = 0  
  465.  
  466. ifOutErrors SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' '-t' '10' 'udp:HOSTNAME:161' 'ifOutErrors'[0m]
  467. ifOutErrors.1 = 0
  468. ifOutErrors.2 = 0
  469. ifOutErrors.3 = 0  
  470.  
  471. ifInDiscards SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' '-t' '10' 'udp:HOSTNAME:161' 'ifInDiscards'[0m]
  472. ifInDiscards.1 = 0
  473. ifInDiscards.2 = 2072536
  474. ifInDiscards.3 = 0  
  475.  
  476. ifOutDiscards SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' '-t' '10' 'udp:HOSTNAME:161' 'ifOutDiscards'[0m]
  477. ifOutDiscards.1 = 0
  478. ifOutDiscards.2 = 0
  479. ifOutDiscards.3 = 0  
  480.  
  481. dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs' '-t' '10' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m]
  482. dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
  483.  
  484. Invalid snmp_walk() data = dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
  485. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v3' '-l' 'authPriv' '-n' "" '-a' 'SHA' '-A' 'PASSWORD' '-u' 'USER' '-x' 'AES' '-X' 'PASSWORD' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs' '-t' '10' 'udp:HOSTNAME:161' 'dot1qPvid'[0m]
  486. dot1qPvid = No Such Object available on this agent at this OID  
  487.  
  488. Invalid snmp_walk() data = dot1qPvid = No Such Object available on this agent at this OID  
  489. array (
  490.   1 =>
  491.   array (
  492.     'ifName' => 'lo',
  493.     'ifInMulticastPkts' => '0',
  494.     'ifInBroadcastPkts' => '0',
  495.     'ifOutMulticastPkts' => '0',
  496.     'ifOutBroadcastPkts' => '0',
  497.     'ifHCInOctets' => '716463327',
  498.     'ifHCInUcastPkts' => '4239083',
  499.     'ifHCInMulticastPkts' => '0',
  500.     'ifHCInBroadcastPkts' => '0',
  501.     'ifHCOutOctets' => '716463327',
  502.     'ifHCOutUcastPkts' => '4239083',
  503.     'ifHCOutMulticastPkts' => '0',
  504.     'ifHCOutBroadcastPkts' => '0',
  505.     'ifHighSpeed' => '10',
  506.     'ifPromiscuousMode' => 'false',
  507.     'ifConnectorPresent' => 'false',
  508.     'ifAlias' => '',
  509.     'ifCounterDiscontinuityTime' => '0:0:00:00.00',
  510.     'ifDescr' => 'lo',
  511.     'ifAdminStatus' => 'up',
  512.     'ifOperStatus' => 'up',
  513.     'ifLastChange' => '0',
  514.     'ifType' => 'softwareLoopback',
  515.     'ifPhysAddress' => '',
  516.     'ifMtu' => '65536',
  517.     'ifInErrors' => '0',
  518.     'ifOutErrors' => '0',
  519.     'ifInDiscards' => '0',
  520.     'ifOutDiscards' => '0',
  521.   ),
  522.   2 =>
  523.   array (
  524.     'ifName' => 'eth0',
  525.     'ifInMulticastPkts' => '0',
  526.     'ifInBroadcastPkts' => '0',
  527.     'ifOutMulticastPkts' => '0',
  528.     'ifOutBroadcastPkts' => '0',
  529.     'ifHCInOctets' => '1323838463537',
  530.     'ifHCInUcastPkts' => '1449292013',
  531.     'ifHCInMulticastPkts' => '0',
  532.     'ifHCInBroadcastPkts' => '0',
  533.     'ifHCOutOctets' => '153578870107',
  534.     'ifHCOutUcastPkts' => '124304421',
  535.     'ifHCOutMulticastPkts' => '0',
  536.     'ifHCOutBroadcastPkts' => '0',
  537.     'ifHighSpeed' => '100',
  538.     'ifPromiscuousMode' => 'false',
  539.     'ifConnectorPresent' => 'true',
  540.     'ifAlias' => '',
  541.     'ifCounterDiscontinuityTime' => '0:0:00:00.00',
  542.     'ifDescr' => 'eth0',
  543.     'ifAdminStatus' => 'up',
  544.     'ifOperStatus' => 'up',
  545.     'ifLastChange' => '0',
  546.     'ifType' => 'ethernetCsmacd',
  547.     'ifPhysAddress' => 'bc:32:5f:0:11:e0',
  548.     'ifMtu' => '1500',
  549.     'ifInErrors' => '0',
  550.     'ifOutErrors' => '0',
  551.     'ifInDiscards' => '2072536',
  552.     'ifOutDiscards' => '0',
  553.   ),
  554.   3 =>
  555.   array (
  556.     'ifName' => 'sit0',
  557.     'ifInMulticastPkts' => '0',
  558.     'ifInBroadcastPkts' => '0',
  559.     'ifOutMulticastPkts' => '0',
  560.     'ifOutBroadcastPkts' => '0',
  561.     'ifHCInOctets' => '0',
  562.     'ifHCInUcastPkts' => '0',
  563.     'ifHCInMulticastPkts' => '0',
  564.     'ifHCInBroadcastPkts' => '0',
  565.     'ifHCOutOctets' => '0',
  566.     'ifHCOutUcastPkts' => '0',
  567.     'ifHCOutMulticastPkts' => '0',
  568.     'ifHCOutBroadcastPkts' => '0',
  569.     'ifHighSpeed' => '0',
  570.     'ifPromiscuousMode' => 'false',
  571.     'ifConnectorPresent' => 'true',
  572.     'ifAlias' => '',
  573.     'ifCounterDiscontinuityTime' => '0:0:00:00.00',
  574.     'ifDescr' => 'sit0',
  575.     'ifAdminStatus' => 'down',
  576.     'ifOperStatus' => 'down',
  577.     'ifLastChange' => '0',
  578.     'ifType' => 'tunnel',
  579.     'ifPhysAddress' => '',
  580.     'ifMtu' => '1480',
  581.     'ifInErrors' => '0',
  582.     'ifOutErrors' => '0',
  583.     'ifInDiscards' => '0',
  584.     'ifOutDiscards' => '0',
  585.   ),
  586. )  
  587.  valid  
  588.  valid  
  589.  valid  
  590.  
  591. Port lo: lo (1 / #7557) ifHCInOctets  
  592. ifHCOutOctets  
  593. ifHCInUcastPkts  
  594. ifHCOutUcastPkts  
  595. ifInBroadcastPkts  
  596. ifOutBroadcastPkts  
  597. ifInMulticastPkts  
  598. ifOutMulticastPkts  
  599. ifHighSpeed (10)  
  600. VLAN = ?  Using ifDescr as ifAlias  
  601. lo
  602.  ifInOctets (1467707 B) 8684.6568047337 Bps 169 secs  
  603.  
  604.  ifOutOctets (1467707 B) 8684.6568047337 Bps 169 secs  
  605.  
  606.  ifInErrors (0 B) 0 Bps 169 secs  
  607.  
  608.  ifOutErrors (0 B) 0 Bps 169 secs  
  609.  
  610.  ifInUcastPkts (8434 B) 49.905325443787 Bps 169 secs  
  611.  
  612.  ifOutUcastPkts (8434 B) 49.905325443787 Bps 169 secs  
  613.  
  614.  ifInNUcastPkts (0 B) 0 Bps 169 secs  
  615.  
  616.  ifOutNUcastPkts (0 B) 0 Bps 169 secs  
  617.  
  618.  ifInDiscards (0 B) 0 Bps 169 secs  
  619.  
  620.  ifOutDiscards (0 B) 0 Bps 169 secs  
  621.  
  622.  ifInUnknownProtos (0 B) 0 Bps 169 secs  
  623.  
  624.  ifInBroadcastPkts (0 B) 0 Bps 169 secs  
  625.  
  626.  ifOutBroadcastPkts (0 B) 0 Bps 169 secs  
  627.  
  628.  ifInMulticastPkts (0 B) 0 Bps 169 secs  
  629.  
  630.  ifOutMulticastPkts (0 B) 0 Bps 169 secs  
  631. bps(69.48 kbps/69.48 kbps)bytes(1.4 MiB/1.4 MiB)pkts(49.91 pps/49.91 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["716463327",714995620,8684.656804733728,1467707,"716463327",714995620,8684.656804733728,1467707,"0",0,0,0,"0",0,0,0,"4239083",4230649,49.905325443786985,8434,"4239083",4230649,49.905325443786985,8434,1675353240,1675353071,169,7557][0m 1.84ms]
  632.  
  633. 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,7557][0m 0.4ms]
  634.  
  635. 1 updated  
  636.  
  637. Port eth0: eth0 (2 / #7558) ifHCInOctets  
  638. ifHCOutOctets  
  639. ifHCInUcastPkts  
  640. ifHCOutUcastPkts  
  641. ifInBroadcastPkts  
  642. ifOutBroadcastPkts  
  643. ifInMulticastPkts  
  644. ifOutMulticastPkts  
  645. ifHighSpeed (100)  
  646. VLAN = ?  Using ifDescr as ifAlias  
  647. eth0
  648.  ifInOctets (564249364 B) 3338753.6331361 Bps 169 secs  
  649.  
  650.  ifOutOctets (16876023 B) 99858.124260355 Bps 169 secs  
  651.  
  652.  ifInErrors (0 B) 0 Bps 169 secs  
  653.  
  654.  ifOutErrors (0 B) 0 Bps 169 secs  
  655.  
  656.  ifInUcastPkts (554660 B) 3282.0118343195 Bps 169 secs  
  657.  
  658.  ifOutUcastPkts (9825 B) 58.136094674556 Bps 169 secs  
  659.  
  660.  ifInNUcastPkts (0 B) 0 Bps 169 secs  
  661.  
  662.  ifOutNUcastPkts (0 B) 0 Bps 169 secs  
  663.  
  664.  ifInDiscards (174 B) 1.0295857988166 Bps 169 secs  
  665.  
  666.  ifOutDiscards (0 B) 0 Bps 169 secs  
  667.  
  668.  ifInUnknownProtos (0 B) 0 Bps 169 secs  
  669.  
  670.  ifInBroadcastPkts (0 B) 0 Bps 169 secs  
  671.  
  672.  ifOutBroadcastPkts (0 B) 0 Bps 169 secs  
  673.  
  674.  ifInMulticastPkts (0 B) 0 Bps 169 secs  
  675.  
  676.  ifOutMulticastPkts (0 B) 0 Bps 169 secs  
  677. bps(26.71 Mbps/798.87 kbps)bytes(538.11 MiB/16.09 MiB)pkts(3.28 kpps/58.14 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["1323838463537",1323274214173,3338753.6331360945,564249364,"153578870107",153561994084,99858.12426035503,16876023,"0",0,0,0,"0",0,0,0,"1449292013",1448737353,3282.0118343195268,554660,"124304421",124294596,58.13609467455621,9825,1675353240,1675353071,169,7558][0m 1.18ms]
  678.  
  679. 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,"2072536",2072362,1.029585798816568,174,"0",0,0,0,0,0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,"0",0,0,0,7558][0m 1.05ms]
  680.  
  681. 2 updated  
  682.  
  683. Port sit0: sit0 (3 / #7559) ifInOctets  
  684. ifOutOctets  
  685. ifInUcastPkts  
  686. ifOutUcastPkts  
  687. ifInBroadcastPkts  
  688. ifOutBroadcastPkts  
  689. ifInMulticastPkts  
  690. ifOutMulticastPkts  
  691. ifHighSpeed (0)  
  692. VLAN = ?  Using ifDescr as ifAlias  
  693. sit07559 skipped because port is still down since last polling.  
  694. SQL[[1;33mUPDATE `ports` set `ifSpeed_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["0000000",1675353240,1675353071,169,7559][0m 0.96ms]
  695.  
  696. 1 updated  
  697.  
  698. SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1675353240,1675353071,null][0m 0.17ms]
  699.  
  700. 0 updated  
  701.  
  702. >> Runtime for poller module 'ports': 0.6898 seconds with 60608 bytes
  703. >> [0;36mSNMP[0m: [14/0.68s] [1;33mMySQL[0m: [7/0.07s]  
  704. #### Unload poller module ports ####
  705.  
  706. Modules status: Global-  
  707. OS  
  708. Device  
  709. Module [ xdsl ] disabled globally.
  710.  
  711. Modules status: Global+  
  712. OS  
  713. Device  
  714.  
  715. #### Load poller module customoid ####
  716. SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[124][0m 0.34ms]
  717.  
  718.  
  719. >> Runtime for poller module 'customoid': 0.0007 seconds with 1744 bytes
  720. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  721. #### Unload poller module customoid ####
  722.  
  723. Modules status: Global+  
  724. OS-  
  725. Device  
  726. Module [ bgp-peers ] disabled on os.
  727.  
  728. Modules status: Global-  
  729. OS  
  730. Device  
  731. Module [ junose-atm-vp ] disabled globally.
  732.  
  733. Modules status: Global-  
  734. OS  
  735. Device  
  736. Module [ printer-supplies ] disabled globally.
  737.  
  738. Modules status: Global+  
  739. OS  
  740. Device  
  741.  
  742. #### Load poller module ucd-diskio ####
  743. SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id`  = ? [0;33m[124][0m 0.24ms]
  744.  
  745.  
  746. >> Runtime for poller module 'ucd-diskio': 0.0005 seconds with 1208 bytes
  747. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  748. #### Unload poller module ucd-diskio ####
  749.  
  750. Modules status: Global-  
  751. OS  
  752. Device  
  753. Module [ wifi ] disabled globally.
  754.  
  755. Modules status: Global+  
  756. OS  
  757. Device  
  758.  
  759. #### Load poller module wireless ####
  760. Attempting to initialize OS: linux  
  761. Attempting to initialize Group OS: unix  
  762. OS initialized: LibreNMS\OS\Shared\Unix  
  763. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[124][0m 0.29ms]
  764.  
  765.  
  766. >> Runtime for poller module 'wireless': 0.0015 seconds with 103448 bytes
  767. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  768. #### Unload poller module wireless ####
  769.  
  770. Modules status: Global+  
  771. OS-  
  772. Device  
  773. Module [ ospf ] disabled on os.
  774.  
  775. Modules status: Global-  
  776. OS  
  777. Device  
  778. Module [ isis ] disabled globally.
  779.  
  780. Modules status: Global-  
  781. OS  
  782. Device  
  783. Module [ cisco-ipsec-flow-monitor ] disabled globally.
  784.  
  785. Modules status: Global-  
  786. OS  
  787. Device  
  788. Module [ cisco-remote-access-monitor ] disabled globally.
  789.  
  790. Modules status: Global-  
  791. OS  
  792. Device  
  793. Module [ cisco-cef ] disabled globally.
  794.  
  795. Modules status: Global-  
  796. OS  
  797. Device  
  798. Module [ slas ] disabled globally.
  799.  
  800. Modules status: Global-  
  801. OS  
  802. Device  
  803. Module [ cisco-mac-accounting ] disabled globally.
  804.  
  805. Modules status: Global-  
  806. OS  
  807. Device  
  808. Module [ cipsec-tunnels ] disabled globally.
  809.  
  810. Modules status: Global-  
  811. OS  
  812. Device  
  813. Module [ cisco-ace-loadbalancer ] disabled globally.
  814.  
  815. Modules status: Global-  
  816. OS  
  817. Device  
  818. Module [ cisco-ace-serverfarms ] disabled globally.
  819.  
  820. Modules status: Global-  
  821. OS  
  822. Device  
  823. Module [ cisco-asa-firewall ] disabled globally.
  824.  
  825. Modules status: Global-  
  826. OS  
  827. Device  
  828. Module [ cisco-voice ] disabled globally.
  829.  
  830. Modules status: Global-  
  831. OS  
  832. Device  
  833. Module [ cisco-cbqos ] disabled globally.
  834.  
  835. Modules status: Global-  
  836. OS  
  837. Device  
  838. Module [ cisco-otv ] disabled globally.
  839.  
  840. Modules status: Global-  
  841. OS  
  842. Device  
  843. Module [ cisco-qfp ] disabled globally.
  844.  
  845. Modules status: Global-  
  846. OS  
  847. Device  
  848. Module [ cisco-vpdn ] disabled globally.
  849.  
  850. Modules status: Global-  
  851. OS  
  852. Device  
  853. Module [ nac ] disabled globally.
  854.  
  855. Modules status: Global-  
  856. OS  
  857. Device  
  858. Module [ netscaler-vsvr ] disabled globally.
  859.  
  860. Modules status: Global-  
  861. OS  
  862. Device  
  863. Module [ aruba-controller ] disabled globally.
  864.  
  865. Modules status: Global+  
  866. OS  
  867. Device  
  868.  
  869. #### Load poller module entity-physical ####
  870.  
  871. >> Runtime for poller module 'entity-physical': 0.0001 seconds with 392 bytes
  872. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
  873. #### Unload poller module entity-physical ####
  874.  
  875. Modules status: Global-  
  876. OS  
  877. Device  
  878. Module [ entity-state ] disabled globally.
  879.  
  880. Modules status: Global+  
  881. OS  
  882. Device  
  883.  
  884. #### Load poller module applications ####
  885. SQL[[1;33mselect * from `applications` where `applications`.`device_id` = ? and `applications`.`device_id` is not null [0;33m[124][0m 0.26ms]
  886.  
  887.  
  888. >> Runtime for poller module 'applications': 0.0010 seconds with 28360 bytes
  889. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.00s]  
  890. #### Unload poller module applications ####
  891.  
  892. Modules status: Global+  
  893. OS-  
  894. Device  
  895. Module [ stp ] disabled on os.
  896.  
  897. Modules status: Global+  
  898. OS  
  899. Device  
  900.  
  901. #### Load poller module ntp ####
  902.  
  903. >> Runtime for poller module 'ntp': 0.0001 seconds with 320 bytes
  904. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
  905. #### Unload poller module ntp ####
  906.  
  907. Modules status: Global-  
  908. OS  
  909. Device  
  910. Module [ loadbalancers ] disabled globally.
  911.  
  912. Modules status: Global-  
  913. OS  
  914. Device  
  915. Module [ mef ] disabled globally.
  916.  
  917. Modules status: Global+  
  918. OS  
  919. Device  
  920.  
  921. #### Load poller module mpls ####
  922.  
  923. >> Runtime for poller module 'mpls': 0.0003 seconds with 36872 bytes
  924. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
  925. #### Unload poller module mpls ####
  926.  
  927. Enabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[124][0m 0.29ms]
  928.  
  929.  
  930. SQL[[1;33mUPDATE `devices` set `last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[4.535,124][0m 1.18ms]
  931.  
  932. Updating 10.32.32.147  
  933.  
  934. Polled in 4.535 seconds
  935. ### Start Device Groups ###
  936. SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.27ms]
  937.  
  938. 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 (1, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13) [0;33m[][0m 0.98ms]
  939.  
  940. SQL[[1;33mselect exists(select * from `devices` left join `ports` on `devices`.`device_id` = `ports`.`device_id` left join `ipv4_addresses` on `ports`.`port_id` = `ipv4_addresses`.`port_id` where (`ipv4_addresses`.`ipv4_address` LIKE ? AND `devices`.`os` LIKE ? AND (`devices`.`notes` NOT LIKE ? OR `devices`.`notes` is null)) and `devices`.`device_id` = ?) as `exists` [0;33m["[41m0.32.1.%","[0;35mrocurve%","[0mewPwd = 1%",124][0m 0.43ms]
  941.  
  942. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`sysName` != ?) and `devices`.`device_id` = ?) as `exists` [0;33m["",124][0m 0.24ms]
  943.  
  944. SQL[[1;33mselect exists(select * from `devices` left join `ports` on `devices`.`device_id` = `ports`.`device_id` left join `ipv4_addresses` on `ports`.`port_id` = `ipv4_addresses`.`port_id` where (`ipv4_addresses`.`ipv4_address` LIKE ? AND `devices`.`os` LIKE ? AND (`devices`.`notes` NOT LIKE ? OR `devices`.`notes` is null)) and `devices`.`device_id` = ?) as `exists` [0;33m["[41m0.32.1.%","%ios%","[0mewPwd = 1%",124][0m 0.31ms]
  945.  
  946. SQL[[1;33mselect exists(select * from `devices` left join `ports` on `devices`.`device_id` = `ports`.`device_id` left join `ipv4_addresses` on `ports`.`port_id` = `ipv4_addresses`.`port_id` where (`ipv4_addresses`.`ipv4_address` LIKE ? AND `devices`.`os` LIKE ? AND `devices`.`notes` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[41m0.32.1.%","%ios%","[0mewPwd = 1%",124][0m 0.28ms]
  947.  
  948. SQL[[1;33mselect exists(select * from `devices` left join `ports` on `devices`.`device_id` = `ports`.`device_id` left join `ipv4_addresses` on `ports`.`port_id` = `ipv4_addresses`.`port_id` where (`ipv4_addresses`.`ipv4_address` LIKE ? AND `devices`.`os` LIKE ? AND `devices`.`notes` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[41m0.32.1.%","[0;35mrocurve%","[0mewPwd = 1%",124][0m 0.31ms]
  949.  
  950. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[1;37mindows%",124][0m 0.21ms]
  951.  
  952. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`os` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["%Linux%",124][0m 0.23ms]
  953.  
  954. SQL[[1;33mselect exists(select * from `devices` left join `ports` on `devices`.`device_id` = `ports`.`device_id` left join `ipv4_addresses` on `ports`.`port_id` = `ipv4_addresses`.`port_id` where (`ipv4_addresses`.`ipv4_address` LIKE ? AND `ipv4_addresses`.`ipv4_address` NOT LIKE ? AND `ipv4_addresses`.`ipv4_address` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["10.32.10.%","[41m0.32.10.252%","[41m0.32.10.253%",124][0m 0.34ms]
  955.  
  956. SQL[[1;33mselect exists(select * from `devices` left join `ports` on `devices`.`device_id` = `ports`.`device_id` left join `ipv4_addresses` on `ports`.`port_id` = `ipv4_addresses`.`port_id` where ((`ipv4_addresses`.`ipv4_address` LIKE ? AND `ipv4_addresses`.`ipv4_address` NOT LIKE ? AND `ipv4_addresses`.`ipv4_address` NOT LIKE ? AND `ipv4_addresses`.`ipv4_address` NOT LIKE ?) OR (`ipv4_addresses`.`ipv4_address` LIKE ?) OR (`ipv4_addresses`.`ipv4_address` LIKE ? AND `ipv4_addresses`.`ipv4_address` NOT LIKE ? AND `ipv4_addresses`.`ipv4_address` NOT LIKE ? AND `ipv4_addresses`.`ipv4_address` NOT LIKE ?) OR (`devices`.`display` LIKE ? OR `devices`.`display` LIKE ?) OR (`ipv4_addresses`.`ipv4_address` LIKE ? AND `ipv4_addresses`.`ipv4_address` NOT LIKE ? AND `ipv4_addresses`.`ipv4_address` NOT LIKE ? AND `ipv4_addresses`.`ipv4_address` NOT LIKE ?) OR (`ipv4_addresses`.`ipv4_address` LIKE ? AND `ipv4_addresses`.`ipv4_address` NOT LIKE ? AND `ipv4_addresses`.`ipv4_address` NOT LIKE ? AND `ipv4_addresses`.`ipv4_address` NOT LIKE ?)) and `devices`.`device_id` = ?) as `exists` [0;33m["10.32.5.%","%.252%","%.253%","%.254%","10.32.30.%","10.32.31.%","%.252","%.253","%.254","[1;36mAM-LME-ACI%","[1;36mAM-ACI%","10.32.33.%","%.252","%.253","%.254","10.32.34.%","%.252","%.253","%.254%",124][0m 0.5ms]
  957.  
  958. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`snmpver` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[43m%",124][0m 0.22ms]
  959.  
  960. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`snmpver` NOT LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[43m%",124][0m 0.24ms]
  961.  
  962. SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[124][0m 0.25ms]
  963.  
  964. Groups Added:  
  965. Groups Removed:  
  966. ### End Device Groups, runtime: 0.0196s ###
  967.  
  968. #### Start Alerts ####
  969. 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[124][0m 0.34ms]
  970.  
  971. 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(`start`) &lt;= ? or time(`end`) > ?))) and (`recurring_day` like ? or `recurring_day` is null)))) and (exists (select * from `devices` inner join `alert_schedulables` on `devices`.`device_id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?) 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 (3, 8, 10, 11)) 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["2023-02-02T15:54:00.114689Z","2023-02-02T15:54:00.114689Z",0,1,"15:54:00","15:54:00","15:54:00","15:54:00","[44m%","device",124,"device_group","location",192][0m 0.79ms]
  972.  
  973. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[124][0m 0.37ms]
  974.  
  975. SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a
  976.         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 = ?)
  977.         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 = ?))
  978.         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 = ?))
  979.         LEFT JOIN devices ld ON l.location_id=ld.location_id AND ld.device_id = ?
  980.         LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
  981.         WHERE a.disabled = 0 AND (
  982.             (d.device_id IS NULL AND g.group_id IS NULL AND l.location_id IS NULL)
  983.             OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=? OR ld.device_id=?))
  984.             OR (a.invert_map = 1  AND (d.device_id != ? OR d.device_id IS NULL) AND (dg.device_id != ? OR dg.device_id IS NULL) AND (ld.device_id != ? OR ld.device_id IS NULL))
  985.         ) [0;33m[124,124,124,124,124,124,124,124,124,124,124][0m 1.35ms]
  986.  
  987. Rule [0;35m#1 (Device Down! Due to no ICMP response.):[0m  
  988.  
  989. 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[124][0m 0.32ms]
  990.  
  991. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[1,124][0m 0.22ms]
  992.  
  993. Status: [0;34mNOCHG[0m  
  994. Rule [0;35m#2 (SNMP not responding on Device - Check on SNMP Service - Device marked Down!):[0m  
  995.  
  996. 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[124][0m 0.3ms]
  997.  
  998. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[2,124][0m 0.2ms]
  999.  
  1000. Status: [0;34mNOCHG[0m  
  1001. Rule [0;35m#3 (Device rebooted):[0m  
  1002.  
  1003. SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND devices.uptime < 300 xss=removed xss=removed xss=removed xss=removed xss=removed> 50 [0;33m[124][0m 0.28ms]
  1004.  
  1005. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[5,124][0m 0.18ms]
  1006.  
  1007. Status: [0;34mNOCHG[0m  
  1008. Rule [0;35m#6 (Port utilisation over threshold):[0m  
  1009.  
  1010. 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) >= 80 AND (ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 [0;33m[124][0m 0.65ms]
  1011.  
  1012. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[6,124][0m 0.18ms]
  1013.  
  1014. Status: [0;34mNOCHG[0m  
  1015. Rule [0;35m#9 (Service up/down):[0m  
  1016.  
  1017. SQL[[1;33mSELECT * FROM devices,services WHERE (devices.device_id = ? AND devices.device_id = services.device_id) AND services.service_status != 0 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[124][0m 0.4ms]
  1018.  
  1019. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[9,124][0m 0.18ms]
  1020.  
  1021. Status: [0;34mNOCHG[0m  
  1022. Rule [0;35m#10 (Wireless Sensor over limit):[0m  
  1023.  
  1024. SQL[[1;33mSELECT * FROM devices,wireless_sensors WHERE (devices.device_id = ? AND devices.device_id = wireless_sensors.device_id) AND wireless_sensors.sensor_current >= wireless_sensors.sensor_limit AND wireless_sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[124][0m 0.4ms]
  1025.  
  1026. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[10,124][0m 0.19ms]
  1027.  
  1028. Status: [0;34mNOCHG[0m  
  1029. Rule [0;35m#11 (Wireless Sensor under limit):[0m  
  1030.  
  1031. 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[124][0m 0.4ms]
  1032.  
  1033. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[11,124][0m 0.18ms]
  1034.  
  1035. Status: [0;34mNOCHG[0m  
  1036. Rule [0;35m#25 (LME - CIV Optic Fiber down):[0m  
  1037.  
  1038. SQL[[1;33mSELECT * FROM devices,ports,port_group_port,port_groups WHERE (devices.device_id = ? AND devices.device_id = ports.device_id AND ports.port_id = port_group_port.port_id AND port_group_port.port_group_id = port_groups.id) AND port_groups.name = "LME-CIV" AND (ports.ifOperStatus = "down" && ports.ifAdminStatus != "down" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 [0;33m[124][0m 0.6ms]
  1039.  
  1040. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[25,124][0m 0.18ms]
  1041.  
  1042. Status: [0;34mNOCHG[0m  
  1043. Rule [0;35m#28 (Port BLOCKED by Spanning-Tree):[0m  
  1044.  
  1045. SQL[[1;33mSELECT * FROM devices,ports_stp WHERE (devices.device_id = ? AND devices.device_id = ports_stp.device_id) AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND ports_stp.state LIKE '[1;34mlocked%' [0;33m[124][0m 0.51ms]
  1046.  
  1047. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[28,124][0m 0.24ms]
  1048.  
  1049. Status: [0;34mNOCHG[0m  
  1050. Rule [0;35m#29 ( acc-lam-sst1_b2-1  - Interface 20 down):[0m  
  1051.  
  1052. SQL[[1;33mSELECT * FROM devices,ports,ipv4_addresses WHERE (devices.device_id = ? AND devices.device_id = ports.device_id AND ports.port_id = ipv4_addresses.port_id) AND ipv4_addresses.ipv4_address = "10.32.4.2" AND (ports.ifOperStatus = "down" && ports.ifAdminStatus != "down" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 AND devices.port = 20 [0;33m[124][0m 0.46ms]
  1053.  
  1054. SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[29,124][0m 0.18ms]
  1055.  
  1056. Status: [0;34mNOCHG[0m  
  1057. #### End Alerts ####
  1058. ./poller.php 10.32.32.147 2023-02-02 16:54:00 - 1 devices polled in 4.734 secs  
  1059.  
  1060. [0;36mSNMP[0m [27/1.47s]: Snmpget[11/0.40s] Snmpwalk[16/1.07s]  
  1061. [1;33mSQL[0m [80/0.36s]: Select[66/0.24s] Insert[1/0.02s] Update[13/0.10s]  
  1062.  
  1063. In StreamHandler.php line 146:
  1064.                                                                                                                                      
  1065.   The stream or file "/opt/librenms/logs/librenms.log" could not be opened in append mode: Failed to open stream: Permission denied  
  1066.   The exception occurred while attempting to log: fputs(): Argument #1 ($stream) must be of type resource, bool given                
  1067.   Context: {"exception":{}}                                                                                                          
  1068.                                                                                                                                      
  1069.