From librenms, 9 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.46ms]
  3.  
  4. SQL[[1;33mselect count(*) as aggregate from `migrations` [0;33m[][0m 0.4ms]
  5.  
  6. SQL[[1;33mselect version() [0;33m[][0m 0.32ms]
  7.  
  8. ===========================================
  9. Component | Version
  10. --------- | -------
  11. LibreNMS  | 23.7.0-14-ge966855 (2023-07-21T18:55:48+02:00)
  12. DB Schema | 2023_06_02_230406_create_vendor_oui_table (253)
  13. PHP       | 8.1.11
  14. Python    | 3.6.8
  15. Database  | MariaDB 10.5.9-MariaDB
  16. RRDTool   | 1.4.8
  17. SNMP      | 5.7.2
  18. ===========================================
  19. DEBUG!
  20. Updating os_def.cache  
  21. Starting polling run:
  22.  
  23. SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '193.203.13.217' ORDER BY `device_id` ASC [0;33m[][0m 0.83ms]
  24.  
  25. SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[224][0m 0.48ms]
  26.  
  27. SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[224][0m 0.38ms]
  28.  
  29. Attempting to initialize OS: generic  
  30. OS initialized: LibreNMS\OS\Generic  
  31. Hostname:    193.203.13.217
  32. Device ID:   224
  33. OS:          generic
  34.  
  35.  
  36. [FPING] '/usr/sbin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '-O' '0' '193.203.13.217'
  37.  
  38. response: xmt/rcv/%loss = 3/3/0%, min/avg/max = 0.34/1.1/2.6  
  39. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m]  
  40. SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::enterprises.23*.1.4
  41.  
  42.  
  43. SQL[[1;33minsert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `debug`, `device_id`, `timestamp`) values (?, ?, ?, ?, ?, ?, ?, ?, ?) [0;33m[0.34,2.6,1.1,3,3,0,"{\"poller_name\":\"lnms\"}",224,"2023-07-24 09:49:10"][0m 1.21ms]
  44.  
  45. SQL[[1;33mupdate `devices` set `last_ping_timetaken` = ? where `device_id` = ? [0;33m[1.1,224][0m 1.02ms]
  46.  
  47. 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[224][0m 0.96ms]
  48.  
  49. Modules status: Global+  
  50. OS  
  51. Device  
  52.  
  53. #### Load poller module core ####
  54. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-On' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysUpTime.0'[0m]  
  55. .*.*.0 = 59520
  56.  
  57.  
  58. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0'[0m]  
  59. SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = 594
  60. HOST-RESOURCES-MIB::hrSystemUptime.0 = No Such Instance currently exists at this OID
  61.  
  62.  
  63. Uptime seconds: 595
  64.  
  65. Uptime: 9 minutes 55 seconds
  66. SQL[[1;33mupdate `devices` set `uptime` = ? where `device_id` = ? [0;33m[595,224][0m 1.09ms]
  67.  
  68.  
  69. >> Runtime for poller module 'core': 0.1216 seconds with 119728 bytes
  70. >> [0;36mSNMP[0m: [2/0.11s] [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[103][0m 0.74ms]
  85.  
  86. Location: ED K./EFP
  87. Hardware:
  88. OS Version:
  89. OS Features:
  90. Serial:
  91.  
  92. >> Runtime for poller module 'os': 0.0057 seconds with 121360 bytes
  93. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
  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[224][0m 0.71ms]
  102.  
  103. Availability:
  104. SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[224][0m 0.68ms]
  105.  
  106. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[224,1690098551][0m 0.79ms]
  107.  
  108. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[9.536,745][0m 0.82ms]
  109.  
  110. 1 day : 9.536%
  111. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[224,1689580151][0m 0.74ms]
  112.  
  113. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[62.55,746][0m 0.51ms]
  114.  
  115. 1 week : 62.55%
  116. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[224,1687592951][0m 0.75ms]
  117.  
  118. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[91.262,747][0m 0.52ms]
  119.  
  120. 1 month : 91.262%
  121. SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[224,1658648951][0m 0.76ms]
  122.  
  123. SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.282,748][0m 0.5ms]
  124.  
  125. 1 year : 99.282%
  126.  
  127. >> Runtime for poller module 'availability': 0.0151 seconds with 25480 bytes
  128. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [10/0.07s]  
  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[224][0m 0.87ms]
  137.  
  138. array (
  139. )  
  140.  
  141. >> Runtime for poller module 'ipmi': 0.0019 seconds with 2944 bytes
  142. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
  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[224][0m 0.74ms]
  151.  
  152.  
  153. >> Runtime for poller module 'sensors': 0.0014 seconds with 1088 bytes
  154. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
  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: generic  
  163. OS initialized: LibreNMS\OS\Generic  
  164. SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[224][0m 0.7ms]
  165.  
  166.  
  167. >> Runtime for poller module 'processors': 0.0033 seconds with 124696 bytes
  168. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
  169. #### Unload poller module processors ####
  170.  
  171. Modules status: Global+  
  172. OS  
  173. Device  
  174.  
  175. #### Load poller module mempools ####
  176. SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[224][0m 0.8ms]
  177.  
  178. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQn' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' '.1.3.6.1.2.1.25.2.3.1.6.1'[0m]
  179. .*.*.* = 3072  
  180.  
  181. hrstorage [system]: Allocated memory for Printer: 100%  3 MiB / 3 MiB
  182.  
  183. >> Runtime for poller module 'mempools': 0.0609 seconds with 87224 bytes
  184. >> [0;36mSNMP[0m: [1/0.06s] [1;33mMySQL[0m: [1/0.01s]  
  185. #### Unload poller module mempools ####
  186.  
  187. Modules status: Global+  
  188. OS  
  189. Device  
  190.  
  191. #### Load poller module storage ####
  192. SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[224][0m 0.77ms]
  193.  
  194.  
  195. >> Runtime for poller module 'storage': 0.0017 seconds with 1424 bytes
  196. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
  197. #### Unload poller module storage ####
  198.  
  199. Modules status: Global+  
  200. OS  
  201. Device  
  202.  
  203. #### Load poller module netstats ####
  204. icmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-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'[0m]  
  205. IP-MIB::icmpInMsgs.0 = 21
  206. IP-MIB::icmpOutMsgs.0 = 17
  207. IP-MIB::icmpInErrors.0 = 4
  208. IP-MIB::icmpOutErrors.0 = 0
  209. IP-MIB::icmpInEchos.0 = 15
  210. IP-MIB::icmpOutEchos.0 = 0
  211. IP-MIB::icmpInEchoReps.0 = 0
  212. IP-MIB::icmpOutEchoReps.0 = 15
  213. IP-MIB::icmpInDestUnreachs.0 = 2
  214. IP-MIB::icmpOutDestUnreachs.0 = 2
  215.  
  216.  
  217. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' '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'[0m]  
  218. IP-MIB::icmpInParmProbs.0 = 0
  219. IP-MIB::icmpInTimeExcds.0 = 0
  220. IP-MIB::icmpInSrcQuenchs.0 = 0
  221. IP-MIB::icmpInRedirects.0 = 0
  222. IP-MIB::icmpInTimestamps.0 = 0
  223. IP-MIB::icmpInTimestampReps.0 = 0
  224. IP-MIB::icmpInAddrMasks.0 = 0
  225. IP-MIB::icmpInAddrMaskReps.0 = 0
  226. IP-MIB::icmpOutTimeExcds.0 = 0
  227. IP-MIB::icmpOutParmProbs.0 = 0
  228.  
  229.  
  230. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' '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]  
  231. IP-MIB::icmpOutSrcQuenchs.0 = 0
  232. IP-MIB::icmpOutRedirects.0 = 0
  233. IP-MIB::icmpOutTimestamps.0 = 0
  234. IP-MIB::icmpOutTimestampReps.0 = 0
  235. IP-MIB::icmpOutAddrMasks.0 = 0
  236. IP-MIB::icmpOutAddrMaskReps.0 = 0
  237.  
  238.  
  239. ip SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-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'[0m]  
  240. IP-MIB::ipForwDatagrams.0 = 0
  241. IP-MIB::ipInDelivers.0 = 6253
  242. IP-MIB::ipInReceives.0 = 9096
  243. IP-MIB::ipOutRequests.0 = 4972
  244. IP-MIB::ipInDiscards.0 = 0
  245. IP-MIB::ipOutDiscards.0 = 0
  246. IP-MIB::ipOutNoRoutes.0 = 0
  247. IP-MIB::ipReasmReqds.0 = 0
  248. IP-MIB::ipReasmOKs.0 = 0
  249. IP-MIB::ipReasmFails.0 = 0
  250.  
  251.  
  252. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' '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]  
  253. IP-MIB::ipFragOKs.0 = 0
  254. IP-MIB::ipFragFails.0 = 0
  255. IP-MIB::ipFragCreates.0 = 0
  256. IP-MIB::ipInUnknownProtos.0 = 0
  257. IP-MIB::ipInHdrErrors.0 = 0
  258. IP-MIB::ipInAddrErrors.0 = 638
  259.  
  260.  
  261. ip_forward SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m]  
  262. IP-FORWARD-MIB::ipCidrRouteNumber.0 = No Such Object available on this agent at this OID
  263.  
  264.  
  265. snmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-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'[0m]  
  266. SNMPv2-MIB::snmpInPkts.0 = 220
  267. SNMPv2-MIB::snmpOutPkts.0 = 219
  268. SNMPv2-MIB::snmpInBadVersions.0 = 0
  269. SNMPv2-MIB::snmpInBadCommunityNames.0 = 0
  270. SNMPv2-MIB::snmpInBadCommunityUses.0 = 0
  271. SNMPv2-MIB::snmpInASNParseErrs.0 = 0
  272. SNMPv2-MIB::snmpInTooBigs.0 = 0
  273. SNMPv2-MIB::snmpInNoSuchNames.0 = 0
  274. SNMPv2-MIB::snmpInBadValues.0 = 0
  275. SNMPv2-MIB::snmpInReadOnlys.0 = 0
  276.  
  277.  
  278. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' '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'[0m]  
  279. SNMPv2-MIB::snmpInGenErrs.0 = 0
  280. SNMPv2-MIB::snmpInTotalReqVars.0 = 349
  281. SNMPv2-MIB::snmpInTotalSetVars.0 = 0
  282. SNMPv2-MIB::snmpInGetRequests.0 = 133
  283. SNMPv2-MIB::snmpInGetNexts.0 = 4
  284. SNMPv2-MIB::snmpInSetRequests.0 = 0
  285. SNMPv2-MIB::snmpInGetResponses.0 = 0
  286. SNMPv2-MIB::snmpInTraps.0 = 0
  287. SNMPv2-MIB::snmpOutTooBigs.0 = 0
  288. SNMPv2-MIB::snmpOutNoSuchNames.0 = 0
  289.  
  290.  
  291. SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' '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]  
  292. SNMPv2-MIB::snmpOutBadValues.0 = 0
  293. SNMPv2-MIB::snmpOutGenErrs.0 = 0
  294. SNMPv2-MIB::snmpOutGetRequests.0 = 0
  295. SNMPv2-MIB::snmpOutGetNexts.0 = 0
  296. SNMPv2-MIB::snmpOutSetRequests.0 = 0
  297. SNMPv2-MIB::snmpOutGetResponses.0 = 221
  298. SNMPv2-MIB::snmpOutTraps.0 = 0
  299. SNMPv2-MIB::snmpSilentDrops.0 = No Such Object available on this agent at this OID
  300. SNMPv2-MIB::snmpProxyDrops.0 = No Such Object available on this agent at this OID
  301.  
  302.  
  303. udp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0'[0m]  
  304. UDP-MIB::udpInDatagrams.0 = 1470
  305. UDP-MIB::udpOutDatagrams.0 = 245
  306. UDP-MIB::udpInErrors.0 = 0
  307. UDP-MIB::udpNoPorts.0 = 2
  308.  
  309.  
  310. tcp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-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]  
  311. TCP-MIB::tcpActiveOpens.0 = 2
  312. TCP-MIB::tcpPassiveOpens.0 = 3
  313. TCP-MIB::tcpAttemptFails.0 = 0
  314. TCP-MIB::tcpEstabResets.0 = 0
  315. TCP-MIB::tcpCurrEstab.0 = 4
  316. TCP-MIB::tcpInSegs.0 = 4715
  317. TCP-MIB::tcpOutSegs.0 = 4707
  318. TCP-MIB::tcpRetransSegs.0 = 1
  319. TCP-MIB::tcpInErrs.0 = 0
  320. TCP-MIB::tcpOutRsts.0 = 0
  321.  
  322.  
  323.  
  324.  
  325. >> Runtime for poller module 'netstats': 0.6720 seconds with 38856 bytes
  326. >> [0;36mSNMP[0m: [11/0.67s] [1;33mMySQL[0m: [0/0.00s]  
  327. #### Unload poller module netstats ####
  328.  
  329. Modules status: Global+  
  330. OS  
  331. Device  
  332.  
  333. #### Load poller module hr-mib ####
  334. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'hrSystemMaxProcesses.0' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m]
  335. hrSystemMaxProcesses.0 = No Such Instance currently exists at this OID
  336. hrSystemProcesses.0 = No Such Instance currently exists at this OID
  337. hrSystemNumUsers.0 = No Such Instance currently exists at this OID  
  338.  
  339.  
  340.  
  341. >> Runtime for poller module 'hr-mib': 0.0318 seconds with 1216 bytes
  342. >> [0;36mSNMP[0m: [1/0.03s] [1;33mMySQL[0m: [0/0.00s]  
  343. #### Unload poller module hr-mib ####
  344.  
  345. Modules status: Global+  
  346. OS  
  347. Device  
  348.  
  349. #### Load poller module ucd-mib ####
  350. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'systemStats'[0m]
  351. systemStats = No Such Object available on this agent at this OID  
  352.  
  353. Invalid snmp_walk() data = systemStats = No Such Object available on this agent at this OID  
  354. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m]
  355. laLoadInt.1 = No Such Object available on this agent at this OID
  356. laLoadInt.2 = No Such Object available on this agent at this OID
  357. laLoadInt.3 = No Such Object available on this agent at this OID  
  358.  
  359.  
  360. >> Runtime for poller module 'ucd-mib': 0.0597 seconds with 9792 bytes
  361. >> [0;36mSNMP[0m: [2/0.06s] [1;33mMySQL[0m: [0/0.00s]  
  362. #### Unload poller module ucd-mib ####
  363.  
  364. Modules status: Global+  
  365. OS  
  366. Device  
  367.  
  368. #### Load poller module ipSystemStats ####
  369. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipSystemStats'[0m]
  370. ipSystemStatsTable = No Such Object available on this agent at this OID  
  371.  
  372. Invalid snmp_walk() data = ipSystemStatsTable = No Such Object available on this agent at this OID  
  373.  
  374.  
  375. >> Runtime for poller module 'ipSystemStats': 0.0396 seconds with 1736 bytes
  376. >> [0;36mSNMP[0m: [1/0.04s] [1;33mMySQL[0m: [0/0.00s]  
  377. #### Unload poller module ipSystemStats ####
  378.  
  379. Modules status: Global+  
  380. OS  
  381. Device  
  382.  
  383. #### Load poller module ports ####
  384. 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[224][0m 1.99ms]
  385.  
  386. Caching Oids: Full ports polling Reporting disabled by user setting  
  387. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifXEntry'[0m]
  388. ifXEntry = No Such Object available on this agent at this OID  
  389.  
  390. Invalid snmp_walk() data = ifXEntry = No Such Object available on this agent at this OID  
  391. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifEntry'[0m]
  392. ifIndex.1 = 1
  393. ifIndex.2 = 2
  394. ifDescr.1 = eth0
  395. ifDescr.2 = lo
  396. ifType.1 = ethernetCsmacd
  397. ifType.2 = softwareLoopback
  398. ifMtu.1 = 1500
  399. ifMtu.2 = 65536
  400. ifSpeed.1 = 1000000000
  401. ifSpeed.2 = 0
  402. ifPhysAddress.1 = ac:a8:8e:f7:df:9b
  403. ifPhysAddress.2 =
  404. ifAdminStatus.1 = up
  405. ifAdminStatus.2 = up
  406. ifOperStatus.1 = up
  407. ifOperStatus.2 = up
  408. ifLastChange.1 = 309
  409. ifLastChange.2 = 0
  410. ifInOctets.1 = 2245802
  411. ifInOctets.2 = 2829488
  412. ifInUcastPkts.1 = 18144
  413. ifInUcastPkts.2 = 4686
  414. ifInNUcastPkts.1 = 4534
  415. ifInNUcastPkts.2 = 0
  416. ifInDiscards.1 = 0
  417. ifInDiscards.2 = 0
  418. ifInErrors.1 = 0
  419. ifInErrors.2 = 0
  420. ifInUnknownProtos.1 = 0
  421. ifInUnknownProtos.2 = 0
  422. ifOutOctets.1 = 62969
  423. ifOutOctets.2 = 2829488
  424. ifOutUcastPkts.1 = 362
  425. ifOutUcastPkts.2 = 4686
  426. ifOutNUcastPkts.1 = 0
  427. ifOutNUcastPkts.2 = 0
  428. ifOutDiscards.1 = 0
  429. ifOutDiscards.2 = 0
  430. ifOutErrors.1 = 0
  431. ifOutErrors.2 = 0
  432. ifOutQLen.1 = 0
  433. ifOutQLen.2 = 0
  434. ifSpecific.1 = zeroDotZero
  435. ifSpecific.2 = zeroDotZero  
  436.  
  437. dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m]
  438. dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
  439.  
  440. Invalid snmp_walk() data = dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
  441. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1qPvid'[0m]
  442. dot1qPvid = No Such Object available on this agent at this OID  
  443.  
  444. Invalid snmp_walk() data = dot1qPvid = No Such Object available on this agent at this OID  
  445. array (
  446.   1 =>
  447.   array (
  448.     'ifIndex' => '1',
  449.     'ifDescr' => 'eth0',
  450.     'ifType' => 'ethernetCsmacd',
  451.     'ifMtu' => '1500',
  452.     'ifSpeed' => '1000000000',
  453.     'ifPhysAddress' => 'ac:a8:8e:f7:df:9b',
  454.     'ifAdminStatus' => 'up',
  455.     'ifOperStatus' => 'up',
  456.     'ifLastChange' => '309',
  457.     'ifInOctets' => '2245802',
  458.     'ifInUcastPkts' => '18144',
  459.     'ifInNUcastPkts' => '4534',
  460.     'ifInDiscards' => '0',
  461.     'ifInErrors' => '0',
  462.     'ifInUnknownProtos' => '0',
  463.     'ifOutOctets' => '62969',
  464.     'ifOutUcastPkts' => '362',
  465.     'ifOutNUcastPkts' => '0',
  466.     'ifOutDiscards' => '0',
  467.     'ifOutErrors' => '0',
  468.     'ifOutQLen' => '0',
  469.     'ifSpecific' => 'zeroDotZero',
  470.   ),
  471.   2 =>
  472.   array (
  473.     'ifIndex' => '2',
  474.     'ifDescr' => 'lo',
  475.     'ifType' => 'softwareLoopback',
  476.     'ifMtu' => '65536',
  477.     'ifSpeed' => '0',
  478.     'ifPhysAddress' => '',
  479.     'ifAdminStatus' => 'up',
  480.     'ifOperStatus' => 'up',
  481.     'ifLastChange' => '0',
  482.     'ifInOctets' => '2829488',
  483.     'ifInUcastPkts' => '4686',
  484.     'ifInNUcastPkts' => '0',
  485.     'ifInDiscards' => '0',
  486.     'ifInErrors' => '0',
  487.     'ifInUnknownProtos' => '0',
  488.     'ifOutOctets' => '2829488',
  489.     'ifOutUcastPkts' => '4686',
  490.     'ifOutNUcastPkts' => '0',
  491.     'ifOutDiscards' => '0',
  492.     'ifOutErrors' => '0',
  493.     'ifOutQLen' => '0',
  494.     'ifSpecific' => 'zeroDotZero',
  495.   ),
  496. )  
  497.  valid  
  498.  valid  
  499.  
  500. Port eth0: eth0 (1 / #104129) ifInOctets  
  501. ifOutOctets  
  502. ifInUcastPkts  
  503. ifOutUcastPkts  
  504. ifInBroadcastPkts  
  505. ifOutBroadcastPkts  
  506. ifInMulticastPkts  
  507. ifOutMulticastPkts  
  508. ifSpeed (1000000000)  
  509. VLAN = ?  Using ifDescr as ifAlias  
  510.  Using ifDescr as ifName  
  511. eth0
  512.  ifInOctets (665095 B) 4963.3955223881 Bps 134 secs  
  513.  
  514.  ifOutOctets (20452 B) 152.62686567164 Bps 134 secs  
  515.  
  516.  ifInErrors (0 B) 0 Bps 134 secs  
  517.  
  518.  ifOutErrors (0 B) 0 Bps 134 secs  
  519.  
  520.  ifInUcastPkts (4403 B) 32.858208955224 Bps 134 secs  
  521.  
  522.  ifOutUcastPkts (137 B) 1.0223880597015 Bps 134 secs  
  523.  
  524.  ifInNUcastPkts (947 B) 7.0671641791045 Bps 134 secs  
  525.  
  526.  ifOutNUcastPkts (0 B) 0 Bps 134 secs  
  527.  
  528.  ifInDiscards (0 B) 0 Bps 134 secs  
  529.  
  530.  ifOutDiscards (0 B) 0 Bps 134 secs  
  531.  
  532.  ifInUnknownProtos (0 B) 0 Bps 134 secs  
  533.  
  534.  ifInBroadcastPkts (0 B) 0 Bps 134 secs  
  535.  
  536.  ifOutBroadcastPkts (0 B) 0 Bps 134 secs  
  537.  
  538.  ifInMulticastPkts (0 B) 0 Bps 134 secs  
  539.  
  540.  ifOutMulticastPkts (0 B) 0 Bps 134 secs  
  541. bps(39.71 kbps/1.22 kbps)bytes(649.51 KiB/19.97 KiB)pkts(32.86 pps/1.02 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["2245802",1580707,4963.395522388059,665095,"62969",42517,152.62686567164178,20452,"0",0,0,0,"0",0,0,0,"18144",13741,32.85820895522388,4403,"362",225,1.0223880597014925,137,1690184952,1690184818,134,104129][0m 1.48ms]
  542.  
  543. 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["4534",3587,7.067164179104478,947,"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,104129][0m 1.07ms]
  544.  
  545. 2 updated  
  546.  
  547. Port lo: lo (2 / #104130) ifInOctets  
  548. ifOutOctets  
  549. ifInUcastPkts  
  550. ifOutUcastPkts  
  551. ifInBroadcastPkts  
  552. ifOutBroadcastPkts  
  553. ifInMulticastPkts  
  554. ifOutMulticastPkts  
  555. ifSpeed (0)  
  556. VLAN = ?  Using ifDescr as ifAlias  
  557.  Using ifDescr as ifName  
  558. lo
  559.  ifInOctets (1392 B) 10.388059701493 Bps 134 secs  
  560.  
  561.  ifOutOctets (1392 B) 10.388059701493 Bps 134 secs  
  562.  
  563.  ifInErrors (0 B) 0 Bps 134 secs  
  564.  
  565.  ifOutErrors (0 B) 0 Bps 134 secs  
  566.  
  567.  ifInUcastPkts (24 B) 0.17910447761194 Bps 134 secs  
  568.  
  569.  ifOutUcastPkts (24 B) 0.17910447761194 Bps 134 secs  
  570.  
  571.  ifInNUcastPkts (0 B) 0 Bps 134 secs  
  572.  
  573.  ifOutNUcastPkts (0 B) 0 Bps 134 secs  
  574.  
  575.  ifInDiscards (0 B) 0 Bps 134 secs  
  576.  
  577.  ifOutDiscards (0 B) 0 Bps 134 secs  
  578.  
  579.  ifInUnknownProtos (0 B) 0 Bps 134 secs  
  580.  
  581.  ifInBroadcastPkts (0 B) 0 Bps 134 secs  
  582.  
  583.  ifOutBroadcastPkts (0 B) 0 Bps 134 secs  
  584.  
  585.  ifInMulticastPkts (0 B) 0 Bps 134 secs  
  586.  
  587.  ifOutMulticastPkts (0 B) 0 Bps 134 secs  
  588. bps(83 bps/83 bps)bytes(1.36 KiB/1.36 KiB)pkts(0.18 pps/0.18 pps)SQL[[1;33mUPDATE `ports` set `ifSpeed_prev`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["0","2829488",2828096,10.388059701492537,1392,"2829488",2828096,10.388059701492537,1392,"0",0,0,0,"0",0,0,0,"4686",4662,0.1791044776119403,24,"4686",4662,0.1791044776119403,24,1690184952,1690184818,134,104130][0m 1.02ms]
  589.  
  590. 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,104130][0m 0.76ms]
  591.  
  592. 1 updated  
  593.  
  594. SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1690184952,1690184818,null][0m 0.48ms]
  595.  
  596. 0 updated  
  597.  
  598. >> Runtime for poller module 'ports': 0.1690 seconds with 85544 bytes
  599. >> [0;36mSNMP[0m: [4/0.15s] [1;33mMySQL[0m: [6/0.07s]  
  600. #### Unload poller module ports ####
  601.  
  602. Modules status: Global-  
  603. OS  
  604. Device  
  605. Module [ xdsl ] disabled globally.
  606.  
  607. Modules status: Global+  
  608. OS  
  609. Device  
  610.  
  611. #### Load poller module customoid ####
  612. SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[224][0m 0.8ms]
  613.  
  614.  
  615. >> Runtime for poller module 'customoid': 0.0016 seconds with 1496 bytes
  616. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
  617. #### Unload poller module customoid ####
  618.  
  619. Modules status: Global+  
  620. OS  
  621. Device  
  622.  
  623. #### Load poller module bgp-peers ####
  624. SQL[[1;33mSELECT * FROM `bgpPeers` AS B LEFT JOIN `vrfs` AS V ON `B`.`vrf_id` = `V`.`vrf_id` WHERE `B`.`device_id` = ? [0;33m[224][0m 0.94ms]
  625.  
  626.  
  627. >> Runtime for poller module 'bgp-peers': 0.0045 seconds with 13176 bytes
  628. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
  629. #### Unload poller module bgp-peers ####
  630.  
  631. Modules status: Global-  
  632. OS  
  633. Device  
  634. Module [ junose-atm-vp ] disabled globally.
  635.  
  636. Modules status: Global-  
  637. OS  
  638. Device  
  639. Module [ printer-supplies ] disabled globally.
  640.  
  641. Modules status: Global+  
  642. OS  
  643. Device  
  644.  
  645. #### Load poller module ucd-diskio ####
  646. SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id`  = ? [0;33m[224][0m 0.66ms]
  647.  
  648.  
  649. >> Runtime for poller module 'ucd-diskio': 0.0014 seconds with 960 bytes
  650. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
  651. #### Unload poller module ucd-diskio ####
  652.  
  653. Modules status: Global-  
  654. OS  
  655. Device  
  656. Module [ wifi ] disabled globally.
  657.  
  658. Modules status: Global+  
  659. OS  
  660. Device  
  661.  
  662. #### Load poller module wireless ####
  663. Attempting to initialize OS: generic  
  664. OS initialized: LibreNMS\OS\Generic  
  665. SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[224][0m 0.82ms]
  666.  
  667.  
  668. >> Runtime for poller module 'wireless': 0.0038 seconds with 103800 bytes
  669. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
  670. #### Unload poller module wireless ####
  671.  
  672. Modules status: Global+  
  673. OS  
  674. Device  
  675.  
  676. #### Load poller module ospf ####
  677. SQL[[1;33mselect * from `vrf_lite_cisco` where `vrf_lite_cisco`.`device_id` = ? and `vrf_lite_cisco`.`device_id` is not null [0;33m[224][0m 0.73ms]
  678.  
  679.  Processes: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUt' '-Os' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfGeneralGroup'[0m]  
  680. ospfGeneralGroup = No Such Object available on this agent at this OID
  681.  
  682.  
  683. SQL[[1;33mdelete from `ospf_instances` where `ospf_instances`.`device_id` = ? and `ospf_instances`.`device_id` is not null and `context_name` = ? and 1 = 1 [0;33m[224,""][0m 0.61ms]
  684.  
  685. 0
  686. >> Runtime for poller module 'ospf': 0.0668 seconds with 103648 bytes
  687. >> [0;36mSNMP[0m: [1/0.06s] [1;33mMySQL[0m: [2/0.01s]  
  688. #### Unload poller module ospf ####
  689.  
  690. Modules status: Global-  
  691. OS  
  692. Device  
  693. Module [ isis ] disabled globally.
  694.  
  695. Modules status: Global-  
  696. OS  
  697. Device  
  698. Module [ cisco-ipsec-flow-monitor ] disabled globally.
  699.  
  700. Modules status: Global-  
  701. OS  
  702. Device  
  703. Module [ cisco-remote-access-monitor ] disabled globally.
  704.  
  705. Modules status: Global-  
  706. OS  
  707. Device  
  708. Module [ cisco-cef ] disabled globally.
  709.  
  710. Modules status: Global-  
  711. OS  
  712. Device  
  713. Module [ slas ] disabled globally.
  714.  
  715. Modules status: Global-  
  716. OS  
  717. Device  
  718. Module [ cisco-mac-accounting ] disabled globally.
  719.  
  720. Modules status: Global-  
  721. OS  
  722. Device  
  723. Module [ cipsec-tunnels ] disabled globally.
  724.  
  725. Modules status: Global-  
  726. OS  
  727. Device  
  728. Module [ cisco-ace-loadbalancer ] disabled globally.
  729.  
  730. Modules status: Global-  
  731. OS  
  732. Device  
  733. Module [ cisco-ace-serverfarms ] disabled globally.
  734.  
  735. Modules status: Global-  
  736. OS  
  737. Device  
  738. Module [ cisco-asa-firewall ] disabled globally.
  739.  
  740. Modules status: Global-  
  741. OS  
  742. Device  
  743. Module [ cisco-voice ] disabled globally.
  744.  
  745. Modules status: Global-  
  746. OS  
  747. Device  
  748. Module [ cisco-cbqos ] disabled globally.
  749.  
  750. Modules status: Global-  
  751. OS  
  752. Device  
  753. Module [ cisco-otv ] disabled globally.
  754.  
  755. Modules status: Global-  
  756. OS  
  757. Device  
  758. Module [ cisco-qfp ] disabled globally.
  759.  
  760. Modules status: Global-  
  761. OS  
  762. Device  
  763. Module [ cisco-vpdn ] disabled globally.
  764.  
  765. Modules status: Global-  
  766. OS  
  767. Device  
  768. Module [ nac ] disabled globally.
  769.  
  770. Modules status: Global-  
  771. OS  
  772. Device  
  773. Module [ netscaler-vsvr ] disabled globally.
  774.  
  775. Modules status: Global-  
  776. OS  
  777. Device  
  778. Module [ aruba-controller ] disabled globally.
  779.  
  780. Modules status: Global+  
  781. OS  
  782. Device  
  783.  
  784. #### Load poller module entity-physical ####
  785.  
  786. >> Runtime for poller module 'entity-physical': 0.0002 seconds with 392 bytes
  787. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
  788. #### Unload poller module entity-physical ####
  789.  
  790. Modules status: Global-  
  791. OS  
  792. Device  
  793. Module [ entity-state ] disabled globally.
  794.  
  795. Modules status: Global+  
  796. OS  
  797. Device  
  798.  
  799. #### Load poller module applications ####
  800. SQL[[1;33mselect * from `applications` where `applications`.`device_id` = ? and `applications`.`device_id` is not null [0;33m[224][0m 0.84ms]
  801.  
  802.  
  803. >> Runtime for poller module 'applications': 0.0025 seconds with 28368 bytes
  804. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s]  
  805. #### Unload poller module applications ####
  806.  
  807. Modules status: Global+  
  808. OS  
  809. Device  
  810.  
  811. #### Load poller module stp ####
  812. Instances: SQL[[1;33mselect * from `stp` where `stp`.`device_id` = ? and `stp`.`device_id` is not null [0;33m[224][0m 0.83ms]
  813.  
  814.  
  815. Ports: SQL[[1;33mselect * from `ports_stp` where `ports_stp`.`device_id` = ? and `ports_stp`.`device_id` is not null [0;33m[224][0m 0.8ms]
  816.  
  817.  
  818. >> Runtime for poller module 'stp': 0.0049 seconds with 72904 bytes
  819. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [2/0.02s]  
  820. #### Unload poller module stp ####
  821.  
  822. Modules status: Global+  
  823. OS  
  824. Device  
  825.  
  826. #### Load poller module ntp ####
  827.  
  828. >> Runtime for poller module 'ntp': 0.0002 seconds with 320 bytes
  829. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
  830. #### Unload poller module ntp ####
  831.  
  832. Modules status: Global-  
  833. OS  
  834. Device  
  835. Module [ loadbalancers ] disabled globally.
  836.  
  837. Modules status: Global-  
  838. OS  
  839. Device  
  840. Module [ mef ] disabled globally.
  841.  
  842. Modules status: Global+  
  843. OS  
  844. Device  
  845.  
  846. #### Load poller module mpls ####
  847.  
  848. >> Runtime for poller module 'mpls': 0.0009 seconds with 36712 bytes
  849. >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s]  
  850. #### Unload poller module mpls ####
  851.  
  852. Enabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[224][0m 0.9ms]
  853.  
  854.  
  855. SQL[[1;33mUPDATE `devices` set `last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[2.394,224][0m 1.08ms]
  856.  
  857. Updating 193.203.13.217  
  858.  
  859. Polled in 2.394 seconds
  860. ### Start Device Groups ###
  861. SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.67ms]
  862.  
  863. 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 (3, 4, 5, 6, 7) [0;33m[][0m 1.22ms]
  864.  
  865. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`location_id` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["33",224][0m 0.77ms]
  866.  
  867. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`location_id` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["32",224][0m 0.65ms]
  868.  
  869. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`location_id` = ? OR `devices`.`location_id` = ? OR `devices`.`location_id` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["39","36","37",224][0m 0.74ms]
  870.  
  871. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["10.31.10.250","10.31.10.1","10.38.1.2","193.203.13.242","193.203.13.234","193.203.13.241","10.0.1.3","10.0.2.3","10.0.3.3","10.0.4.3","10.0.5.3","10.0.6.3","10.31.10.2","10.31.10.3",224][0m 0.83ms]
  872.  
  873. SQL[[1;33mselect exists(select * from `devices` where (`devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ? OR `devices`.`hostname` = ?) and `devices`.`device_id` = ?) as `exists` [0;33m["10.33.128.11","10.33.128.12","10.33.128.13","10.33.128.14","10.33.128.15","10.33.128.15","10.33.160.11","10.33.160.12","10.33.160.13",224][0m 0.7ms]
  874.  
  875. SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[224][0m 0.65ms]
  876.  
  877. Groups Added:  
  878. Groups Removed:  
  879. ### End Device Groups, runtime: 0.0255s ###
  880.  
  881. #### Start Alerts ####
  882. 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[224][0m 0.82ms]
  883.  
  884. 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 `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-07-24T07:49:12.271068Z","2023-07-24T07:49:12.271068Z",0,1,"07:49:12","07:49:12","07:49:12","07:49:12","[41m%","device",224,"location",103][0m 1.94ms]
  885.  
  886. SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[224][0m 1.03ms]
  887.  
  888. SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a
  889.         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 = ?)
  890.         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 = ?))
  891.         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 = ?))
  892.         LEFT JOIN devices ld ON l.location_id=ld.location_id AND ld.device_id = ?
  893.         LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
  894.         WHERE a.disabled = 0 AND (
  895.             (d.device_id IS NULL AND g.group_id IS NULL AND l.location_id IS NULL)
  896.             OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=? OR ld.device_id=?))
  897.             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))
  898.         ) [0;33m[224,224,224,224,224,224,224,224,224,224,224][0m 3.22ms]
  899.  
  900. #### End Alerts ####
  901. ./poller.php 193.203.13.217 2023-07-24 09:49:12 - 1 devices polled in 2.839 secs  
  902.  
  903. [0;36mSNMP[0m [24/1.24s]: Snmpget[17/0.96s] Snmpwalk[7/0.28s]  
  904. [1;33mSQL[0m [56/0.48s]: Select[42/0.36s] Insert[1/0.01s] Update[12/0.10s] Delete[1/0.01s]  
  905.