From Cute Mosquito, 3 Years ago, written in Plain Text.
Embed
  1. LibreNMS Poller
  2.  
  3. SQL[select `migration` from `migrations` order by `id` desc limit 1 [] 0.52ms]
  4.  
  5.  
  6. SQL[select count(*) as aggregate from `migrations` limit 1 [] 0.56ms]
  7.  
  8.  
  9. SQL[SELECT version() [] 0.41ms]
  10.  
  11.  
  12. ===================================
  13. Version info:
  14. Commit SHA:
  15. Commit Date:
  16. DB Schema: 2020_04_19_010532_eventlog_sensor_reference_cleanup (164)
  17. PHP: 7.3.14
  18. MySQL: 10.4.12-MariaDB-1:10.4.12+maria~bionic
  19. RRDTool: 1.7.2
  20. SNMP: NET-SNMP 5.8
  21. ==================================DEBUG!
  22.  
  23. Updating os_def.cache...  
  24.  
  25.  
  26. Warning: file_put_contents(/opt/librenms/cache/os_defs.cache): failed to open stream: Permission denied in /opt/librenms/includes/common.php on line 1448
  27.  
  28. Done  
  29.  
  30. Starting polling run:
  31.  
  32.  
  33. SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = 'erin-cd800.catgirls.dev' ORDER BY `device_id` ASC [] 1.3ms]
  34.  
  35.  
  36. SQL[select * from information_schema.tables where table_schema = ? and table_name = ? and table_type = 'BASE TABLE' ["librenms","migrations"] 1.2ms]
  37.  
  38.  
  39. SQL[select `migration` from `migrations` [] 1.41ms]
  40.  
  41.  
  42. SQL[select distinct `os` from `devices` [] 1.41ms]
  43.  
  44.  
  45. SQL[select * from `devices` where `device_id` = ? limit 1 [8] 1.09ms]
  46.  
  47.  
  48. SQL[select * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [8] 0.65ms]
  49.  
  50.  
  51. Hostname:    erin-cd800.catgirls.dev
  52. Device ID:   8
  53. OS:          generic
  54.  
  55. Resolved IP: 192.168.8.16
  56.  
  57.  
  58.  
  59. SQL[select `hostname`, `overwrite_ip` from `devices` where `hostname` = ? limit 1 ["erin-cd800.catgirls.dev"] 1.03ms]
  60.  
  61.  
  62. [FPING] '/usr/sbin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' 'erin-cd800.catgirls.dev'  
  63.  
  64. array (
  65.   'xmt' => 3,
  66.   'rcv' => 3,
  67.   'loss' => 0,
  68.   'min' => 47.1,
  69.   'max' => 276.0,
  70.   'avg' => 187.0,
  71.   'dup' => 0,
  72.   'exitcode' => 0,
  73. )  
  74.  
  75. SQL[INSERT IGNORE INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`,`debug`)  VALUES (:xmt,:rcv,:loss,:min,:max,:avg,:device_id,NOW(),:debug) {"xmt":3,"rcv":3,"loss":0,"min":47.1,"max":276,"avg":187,"device_id":8,"debug":"[]"} 1.37ms]
  76.  
  77.  
  78. SQL[UPDATE `devices` set `last_ping`=?,`last_ping_timetaken`=? WHERE device_id=? ["2020-05-11 16:57:29",187,8] 3.14ms]
  79.  
  80.  
  81.  
  82. #### Load poller module core ####
  83. SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUt' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'sysUpTime.0' 'sysLocation.0' 'sysContact.0' 'sysName.0' 'sysObjectID.0' 'sysDescr.0']
  84.  
  85. SNMP Check response code: 0  
  86. Modules status: Global+  
  87. OS  
  88. Device  
  89.  
  90. .*.*.0 = 167765175
  91. .*.*.0 = Entrust Datacard
  92. .*.*.0 = Entrust Datacard
  93. .*.*.0 = Datacard Printer
  94. .*.*.0 = .*.*.3.9.1
  95. .*.*.0 = Datacard CD800 C42970  
  96.  
  97.  
  98. SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUst' '-m' 'HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'snmpEngineTime.0' 'hrSystemUptime.0']
  99.  
  100. Uptime:  19 days 10 hours 52 seconds
  101.  
  102. snmpEngineTime.0 = 1677652
  103. hrSystemUptime.0 = No Such Object available on this agent at this OID  
  104.  
  105. Uptime seconds: 1677652  
  106.  
  107.  
  108. >> Runtime for poller module 'core': 1.0981 seconds with 109152 bytes
  109. >> SNMP: [2/1.09s] MySQL: [0/0.00s]
  110. #### Unload poller module core ####
  111.  
  112.  
  113. SQL[select * from `locations` where `locations`.`id` = ? limit 1 [1] 1.23ms]
  114.  
  115.  
  116. Module [ unix-agent ] disabled globally.
  117.  
  118.  
  119. #### Load poller module os ####
  120. Generic :(
  121. Location:
  122. Hardware:
  123. Version:
  124. Features:
  125. Serial:
  126.  
  127. >> Runtime for poller module 'os': 0.0032 seconds with 1456 bytes
  128. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
  129. #### Unload poller module os ####
  130.  
  131.  
  132. #### Load poller module ipmi ####
  133.  
  134. Modules status: Global-  
  135. OS  
  136. Device  
  137. Modules status: Global+  
  138. OS  
  139. Device  
  140. Modules status: Global+  
  141. OS  
  142. Device  
  143.  
  144.  
  145. >> Runtime for poller module 'ipmi': 0.0024 seconds with 1640 bytes
  146. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  147. #### Unload poller module ipmi ####
  148.  
  149.  
  150. #### Load poller module sensors ####
  151.  
  152. SQL[SELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [8] 1.29ms]
  153.  
  154. array (
  155. )  
  156. Modules status: Global+  
  157. OS  
  158. Device  
  159.  
  160. SQL[SELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [8] 0.96ms]
  161.  
  162.  
  163.  
  164. >> Runtime for poller module 'sensors': 0.0016 seconds with 1208 bytes
  165. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  166. #### Unload poller module sensors ####
  167.  
  168.  
  169.  
  170. #### Load poller module processors ####
  171.  
  172. Modules status: Global+  
  173. OS  
  174. Device  
  175.  
  176. Attempting to initialize OS: generic  
  177. OS initialized: LibreNMS\OS\Generic  
  178.  
  179. SQL[SELECT * FROM processors WHERE device_id=? [8] 1.09ms]
  180.  
  181.  
  182. SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQn' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.2021.11.11.0']
  183.  
  184. 3%
  185.  
  186. >> Runtime for poller module 'processors': 0.3407 seconds with 11128 bytes
  187. >> SNMP: [1/0.33s] MySQL: [1/0.00s]
  188. #### Unload poller module processors ####
  189.  
  190.  
  191. #### Load poller module mempools ####
  192.  
  193. .*.4.1.2* = 97  
  194.  
  195. array (
  196.   '.1.3.6.1.4.1.2021.11.11.0' => '97',
  197. )  
  198. Modules status: Global+  
  199. OS  
  200. Device  
  201.  
  202.  
  203. >> Runtime for poller module 'mempools': 0.0020 seconds with 1208 bytes
  204. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  205. #### Unload poller module mempools ####
  206.  
  207.  
  208. #### Load poller module storage ####
  209.  
  210. SQL[SELECT * FROM mempools WHERE device_id = ? [8] 1.15ms]
  211.  
  212. Modules status: Global+  
  213. OS  
  214. Device  
  215.  
  216.  
  217. >> Runtime for poller module 'storage': 0.0016 seconds with 1208 bytes
  218. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  219. #### Unload poller module storage ####
  220.  
  221.  
  222. #### Load poller module netstats ####
  223.  ICMPSNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'icmp']
  224.  
  225. SQL[SELECT * FROM storage WHERE device_id = ? [8] 0.91ms]
  226.  
  227. Modules status: Global+  
  228. OS  
  229. Device  
  230.  
  231. icmpInMsgs.0 = 32826
  232. icmpInErrors.0 = 0
  233. icmpInDestUnreachs.0 = 0
  234. icmpInTimeExcds.0 = 5660
  235. icmpInParmProbs.0 = 0
  236. icmpInSrcQuenchs.0 = 0
  237. icmpInRedirects.0 = 0
  238. icmpInEchos.0 = 0
  239. icmpInEchoReps.0 = 27166
  240. icmpInTimestamps.0 = 0
  241. icmpInTimestampReps.0 = 0
  242. icmpInAddrMasks.0 = 0
  243. icmpInAddrMaskReps.0 = 0
  244. icmpOutMsgs.0 = 0
  245. icmpOutErrors.0 = 27172
  246. icmpOutDestUnreachs.0 = 0
  247. icmpOutTimeExcds.0 = 6
  248. icmpOutParmProbs.0 = 0
  249. icmpOutSrcQuenchs.0 = 0
  250. icmpOutRedirects.0 = 0
  251. icmpOutEchos.0 = 0
  252. icmpOutEchoReps.0 = 0
  253. icmpOutTimestamps.0 = 27166
  254. icmpOutTimestampReps.0 = 0
  255. icmpOutAddrMasks.0 = 0
  256. icmpOutAddrMaskReps.0 = 0
  257. icmpStatsInMsgs.ipv4 = 32826
  258. icmpStatsInMsgs.ipv6 = 0
  259. icmpStatsInErrors.ipv4 = 0
  260. icmpStatsInErrors.ipv6 = 0
  261. icmpStatsOutMsgs.ipv4 = 0
  262. icmpStatsOutMsgs.ipv6 = 0
  263. icmpStatsOutErrors.ipv4 = 27172
  264. icmpStatsOutErrors.ipv6 = 0
  265. icmpMsgStatsInPkts.unknown.128 = 0
  266. icmpMsgStatsInPkts.unknown.130 = 0
  267. icmpMsgStatsInPkts.unknown.134 = 0
  268. icmpMsgStatsInPkts.ipv4.3 = 5660
  269. icmpMsgStatsInPkts.ipv4.8 = 27166
  270. icmpMsgStatsInPkts.ipv6.0 = 0
  271. icmpMsgStatsOutPkts.ipv4.0 = 27166
  272. icmpMsgStatsOutPkts.ipv4.3 = 6
  273. icmpMsgStatsOutPkts.ipv6.0 = 0  
  274.  
  275.  
  276.  IP
  277. SNMP['/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipForwDatagrams' 'ipInDelivers' 'ipInReceives' 'ipOutRequests' 'ipInDiscards' 'ipOutDiscards' 'ipOutNoRoutes' 'ipReasmReqds' 'ipReasmOKs' 'ipReasmFails' 'ipFragOKs' 'ipFragFails' 'ipFragCreates' 'ipInUnknownProtos' 'ipInHdrErrors' 'ipInAddrErrors']
  278.  
  279.  IP-FORWARDSNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQv' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0']
  280.  
  281. ipForwDatagrams.0 = 0
  282. ipInDelivers.0 = 6596332
  283. ipInReceives.0 = 22972254
  284. ipOutRequests.0 = 6543771
  285. ipInDiscards.0 = 0
  286. ipOutDiscards.0 = 0
  287. ipOutNoRoutes.0 = 0
  288. ipReasmReqds.0 = 259
  289. ipReasmOKs.0 = 129
  290. ipReasmFails.0 = 1
  291. ipFragOKs.0 = 0
  292. ipFragFails.0 = 0
  293. ipFragCreates.0 = 0
  294. ipInUnknownProtos.0 = 0
  295. ipInHdrErrors.0 = 0
  296. ipInAddrErrors.0 = 1399  
  297.  
  298.  
  299.  SNMPSNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'snmp']
  300.  
  301. No Such Object available on this agent at this OID  
  302.  
  303.  
  304.  TCPSNMP['/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'tcpActiveOpens' 'tcpPassiveOpens' 'tcpAttemptFails' 'tcpEstabResets' 'tcpCurrEstab' 'tcpInSegs' 'tcpOutSegs' 'tcpRetransSegs' 'tcpInErrs' 'tcpOutRsts']
  305.  
  306. snmpInPkts.0 = 568166
  307. snmpOutPkts.0 = 505955
  308. snmpInBadVersions.0 = 0
  309. snmpInBadCommunityNames.0 = 62208
  310. snmpInBadCommunityUses.0 = 0
  311. snmpInASNParseErrs.0 = 0
  312. snmpInTooBigs.0 = 0
  313. snmpInNoSuchNames.0 = 0
  314. snmpInBadValues.0 = 0
  315. snmpInReadOnlys.0 = 0
  316. snmpInGenErrs.0 = 0
  317. snmpInTotalReqVars.0 = 4216196
  318. snmpInTotalSetVars.0 = 0
  319. snmpInGetRequests.0 = 101486
  320. snmpInGetNexts.0 = 35978
  321. snmpInSetRequests.0 = 0
  322. snmpInGetResponses.0 = 0
  323. snmpInTraps.0 = 0
  324. snmpOutTooBigs.0 = 0
  325. snmpOutNoSuchNames.0 = 0
  326. snmpOutBadValues.0 = 0
  327. snmpOutGenErrs.0 = 0
  328. snmpOutGetRequests.0 = 0
  329. snmpOutGetNexts.0 = 0
  330. snmpOutSetRequests.0 = 0
  331. snmpOutGetResponses.0 = 505957
  332. snmpOutTraps.0 = 0
  333. snmpEnableAuthenTraps.0 = enabled
  334. snmpSilentDrops.0 = 0
  335. snmpProxyDrops.0 = 0  
  336.  
  337.  
  338. tcpActiveOpens.0 = 537842
  339. tcpPassiveOpens.0 = 544208
  340. tcpAttemptFails.0 = 38
  341. tcpEstabResets.0 = 4
  342. tcpCurrEstab.0 = 4
  343. tcpInSegs.0 = 5992991
  344. tcpOutSegs.0 = 5986575
  345. tcpRetransSegs.0 = 10010
  346. tcpInErrs.0 = 0
  347. tcpOutRsts.0 = 44  
  348.  
  349.  
  350.  TCPHC
  351. SNMP['/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'tcpHCInSegs.0' 'tcpHCOutSegs.0']
  352.  
  353.  UDPSNMP['/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UDP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'udpInDatagrams' 'udpOutDatagrams' 'udpInErrors' 'udpNoPorts']
  354.  
  355. tcpConnectionState.ipv4."*".57256.ipv4."*".9100 = timeWait
  356. tcpConnectionState.ipv4."*".57256.ipv4."*".9100 = timeWait  
  357.  
  358.  
  359.  
  360.  
  361. >> Runtime for poller module 'netstats': 1.8735 seconds with 2280 bytes
  362. >> SNMP: [7/1.87s] MySQL: [0/0.00s]
  363. #### Unload poller module netstats ####
  364.  
  365.  
  366. #### Load poller module hr-mib ####
  367. SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'hrSystemProcesses.0' 'hrSystemNumUsers.0']
  368.  
  369. udpInDatagrams.0 = 570681
  370. udpOutDatagrams.0 = 509492
  371. udpInErrors.0 = 0
  372. udpNoPorts.0 = 0  
  373.  
  374. Modules status: Global+  
  375. OS  
  376. Device  
  377.  
  378.  
  379.  
  380. >> Runtime for poller module 'hr-mib': 0.0475 seconds with 1208 bytes
  381. >> SNMP: [1/0.05s] MySQL: [0/0.00s]
  382. #### Unload poller module hr-mib ####
  383.  
  384.  
  385. #### Load poller module ucd-mib ####
  386. SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'systemStats']
  387.  
  388. hrSystemProcesses.0 = No Such Object available on this agent at this OID
  389. hrSystemNumUsers.0 = No Such Object available on this agent at this OID  
  390.  
  391. Modules status: Global+  
  392. OS  
  393. Device  
  394.  
  395. SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'memTotalSwap.0' 'memAvailSwap.0' 'memTotalReal.0' 'memAvailReal.0' 'memTotalFree.0' 'memShared.0' 'memBuffer.0' 'memCached.0']
  396.  
  397. ssIndex.0 = 1
  398. ssErrorName.0 = systemStats
  399. ssSwapIn.0 = 0
  400. ssSwapOut.0 = 0
  401. ssIOSent.0 = 0
  402. ssIOReceive.0 = 0
  403. ssSysInterrupts.0 = 936
  404. ssSysContext.0 = 55
  405. ssCpuUser.0 = 1
  406. ssCpuSystem.0 = 0
  407. ssCpuIdle.0 = 97
  408. ssCpuRawUser.0 = 5316127
  409. ssCpuRawNice.0 = 0
  410. ssCpuRawSystem.0 = 2231842
  411. ssCpuRawIdle.0 = 350042124
  412. ssCpuRawWait.0 = 751
  413. ssCpuRawKernel.0 = 0
  414. ssCpuRawInterrupt.0 = 6798
  415. ssIORawSent.0 = 38104
  416. ssIORawReceived.0 = 159160
  417. ssRawInterrupts.0 = 3725701421
  418. ssRawContexts.0 = 203539782
  419. ssCpuRawSoftIRQ.0 = 129419
  420. ssRawSwapIn.0 = 0
  421. ssRawSwapOut.0 = 0
  422. ssCpuRawSteal.0 = 0
  423. ssCpuRawGuest.0 = 0
  424. ssCpuRawGuestNice.0 = 0  
  425.  
  426.  
  427. SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3']
  428.  
  429. memTotalSwap.0 = 0
  430. memAvailSwap.0 = 0
  431. memTotalReal.0 = 246172
  432. memAvailReal.0 = 28652
  433. memTotalFree.0 = 28652
  434. memShared.0 = 23824
  435. memBuffer.0 = 38804
  436. memCached.0 = 135000  
  437.  
  438.  
  439.  
  440. >> Runtime for poller module 'ucd-mib': 0.3114 seconds with 4280 bytes
  441. >> SNMP: [3/0.31s] MySQL: [0/0.00s]
  442. #### Unload poller module ucd-mib ####
  443.  
  444.  
  445. #### Load poller module ipSystemStats ####
  446. SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipSystemStats']
  447.  
  448. laLoadInt.1 = 9
  449. laLoadInt.2 = 3
  450. laLoadInt.3 = 5  
  451.  
  452. Modules status: Global+  
  453. OS  
  454. Device  
  455.  
  456. ipv4 ipv6
  457.  
  458. >> Runtime for poller module 'ipSystemStats': 0.3695 seconds with 16304 bytes
  459. >> SNMP: [1/0.37s] MySQL: [0/0.00s]
  460. #### Unload poller module ipSystemStats ####
  461.  
  462.  
  463. #### Load poller module ports ####
  464.  
  465. ipSystemStatsInReceives.ipv4 = 22972093
  466. ipSystemStatsInReceives.ipv6 = 29041
  467. ipSystemStatsHCInReceives.ipv4 = 22972093
  468. ipSystemStatsHCInReceives.ipv6 = 29041
  469. ipSystemStatsInOctets.ipv6 = 3949760
  470. ipSystemStatsHCInOctets.ipv6 = 3949760
  471. ipSystemStatsInHdrErrors.ipv4 = 0
  472. ipSystemStatsInHdrErrors.ipv6 = 0
  473. ipSystemStatsInNoRoutes.ipv4 = 0
  474. ipSystemStatsInNoRoutes.ipv6 = 162
  475. ipSystemStatsInAddrErrors.ipv4 = 1399
  476. ipSystemStatsInAddrErrors.ipv6 = 0
  477. ipSystemStatsInUnknownProtos.ipv4 = 0
  478. ipSystemStatsInUnknownProtos.ipv6 = 0
  479. ipSystemStatsInTruncatedPkts.ipv4 = 0
  480. ipSystemStatsInTruncatedPkts.ipv6 = 0
  481. ipSystemStatsInForwDatagrams.ipv4 = 0
  482. ipSystemStatsInForwDatagrams.ipv6 = 162
  483. ipSystemStatsHCInForwDatagrams.ipv4 = 0
  484. ipSystemStatsHCInForwDatagrams.ipv6 = 162
  485. ipSystemStatsReasmReqds.ipv4 = 259
  486. ipSystemStatsReasmReqds.ipv6 = 0
  487. ipSystemStatsReasmOKs.ipv4 = 129
  488. ipSystemStatsReasmOKs.ipv6 = 0
  489. ipSystemStatsReasmFails.ipv4 = 1
  490. ipSystemStatsReasmFails.ipv6 = 0
  491. ipSystemStatsInDiscards.ipv4 = 0
  492. ipSystemStatsInDiscards.ipv6 = 28879
  493. ipSystemStatsInDelivers.ipv4 = 6596286
  494. ipSystemStatsInDelivers.ipv6 = 162
  495. ipSystemStatsHCInDelivers.ipv4 = 6596286
  496. ipSystemStatsHCInDelivers.ipv6 = 162
  497. ipSystemStatsOutRequests.ipv4 = 6543726
  498. ipSystemStatsOutRequests.ipv6 = 162
  499. ipSystemStatsHCOutRequests.ipv4 = 6543726
  500. ipSystemStatsHCOutRequests.ipv6 = 162
  501. ipSystemStatsOutNoRoutes.ipv4 = 0
  502. ipSystemStatsOutNoRoutes.ipv6 = 0
  503. ipSystemStatsOutForwDatagrams.ipv4 = 0
  504. ipSystemStatsOutForwDatagrams.ipv6 = 0
  505. ipSystemStatsHCOutForwDatagrams.ipv4 = 0
  506. ipSystemStatsHCOutForwDatagrams.ipv6 = 0
  507. ipSystemStatsOutDiscards.ipv4 = 0
  508. ipSystemStatsOutDiscards.ipv6 = 0
  509. ipSystemStatsOutFragReqds.ipv4 = 0
  510. ipSystemStatsOutFragReqds.ipv6 = 0
  511. ipSystemStatsOutFragOKs.ipv4 = 0
  512. ipSystemStatsOutFragOKs.ipv6 = 0
  513. ipSystemStatsOutFragFails.ipv4 = 0
  514. ipSystemStatsOutFragFails.ipv6 = 0
  515. ipSystemStatsOutFragCreates.ipv4 = 0
  516. ipSystemStatsOutFragCreates.ipv6 = 0
  517. ipSystemStatsOutTransmits.ipv4 = 6543726
  518. ipSystemStatsOutTransmits.ipv6 = 162
  519. ipSystemStatsHCOutTransmits.ipv4 = 6543726
  520. ipSystemStatsHCOutTransmits.ipv6 = 162
  521. ipSystemStatsOutOctets.ipv6 = 12078
  522. ipSystemStatsHCOutOctets.ipv6 = 12078
  523. ipSystemStatsInMcastPkts.ipv4 = 12385211
  524. ipSystemStatsInMcastPkts.ipv6 = 0
  525. ipSystemStatsHCInMcastPkts.ipv4 = 12385211
  526. ipSystemStatsHCInMcastPkts.ipv6 = 0
  527. ipSystemStatsInMcastOctets.ipv6 = 0
  528. ipSystemStatsHCInMcastOctets.ipv6 = 0
  529. ipSystemStatsOutMcastPkts.ipv4 = 239
  530. ipSystemStatsOutMcastPkts.ipv6 = 0
  531. ipSystemStatsHCOutMcastPkts.ipv4 = 239
  532. ipSystemStatsHCOutMcastPkts.ipv6 = 0
  533. ipSystemStatsOutMcastOctets.ipv6 = 0
  534. ipSystemStatsHCOutMcastOctets.ipv6 = 0
  535. ipSystemStatsInBcastPkts.ipv4 = 3985931
  536. ipSystemStatsHCInBcastPkts.ipv4 = 3985931
  537. ipSystemStatsOutBcastPkts.ipv4 = 0
  538. ipSystemStatsHCOutBcastPkts.ipv4 = 0
  539. ipSystemStatsDiscontinuityTime.ipv4 = 0:0:00:00.00
  540. ipSystemStatsDiscontinuityTime.ipv6 = 0:0:00:00.00
  541. ipSystemStatsRefreshRate.ipv4 = 60000
  542. ipSystemStatsRefreshRate.ipv6 = 60000  
  543.  
  544. Modules status: Global+  
  545. OS  
  546. Device  
  547.  
  548. Caching Oids: Full ports polling SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifXEntry']
  549.  
  550. SQL[SELECT *, `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 [8] 3.98ms]
  551.  
  552.  
  553. ifName.1 = lo
  554. ifName.2 = eth0
  555. ifName.3 = eth1
  556. ifName.4 = usb0
  557. ifInMulticastPkts.1 = 0
  558. ifInMulticastPkts.2 = 0
  559. ifInMulticastPkts.3 = 0
  560. ifInMulticastPkts.4 = 0
  561. ifInBroadcastPkts.1 = 0
  562. ifInBroadcastPkts.2 = 0
  563. ifInBroadcastPkts.3 = 0
  564. ifInBroadcastPkts.4 = 0
  565. ifOutMulticastPkts.1 = 0
  566. ifOutMulticastPkts.2 = 0
  567. ifOutMulticastPkts.3 = 0
  568. ifOutMulticastPkts.4 = 0
  569. ifOutBroadcastPkts.1 = 0
  570. ifOutBroadcastPkts.2 = 0
  571. ifOutBroadcastPkts.3 = 0
  572. ifOutBroadcastPkts.4 = 0
  573. ifHCInOctets.1 = 17123197006
  574. ifHCInOctets.2 = 1274350204
  575. ifHCInOctets.3 = 0
  576. ifHCInOctets.4 = 0
  577. ifHCInUcastPkts.1 = 5913154
  578. ifHCInUcastPkts.2 = 26450586
  579. ifHCInUcastPkts.3 = 0
  580. ifHCInUcastPkts.4 = 0
  581. ifHCInMulticastPkts.1 = 0
  582. ifHCInMulticastPkts.2 = 0
  583. ifHCInMulticastPkts.3 = 0
  584. ifHCInMulticastPkts.4 = 0
  585. ifHCInBroadcastPkts.1 = 0
  586. ifHCInBroadcastPkts.2 = 0
  587. ifHCInBroadcastPkts.3 = 0
  588. ifHCInBroadcastPkts.4 = 0
  589. ifHCOutOctets.1 = 17123197006
  590. ifHCOutOctets.2 = 197057920
  591. ifHCOutOctets.3 = 0
  592. ifHCOutOctets.4 = 0
  593. ifHCOutUcastPkts.1 = 5913154
  594. ifHCOutUcastPkts.2 = 696736
  595. ifHCOutUcastPkts.3 = 0
  596. ifHCOutUcastPkts.4 = 0
  597. ifHCOutMulticastPkts.1 = 0
  598. ifHCOutMulticastPkts.2 = 0
  599. ifHCOutMulticastPkts.3 = 0
  600. ifHCOutMulticastPkts.4 = 0
  601. ifHCOutBroadcastPkts.1 = 0
  602. ifHCOutBroadcastPkts.2 = 0
  603. ifHCOutBroadcastPkts.3 = 0
  604. ifHCOutBroadcastPkts.4 = 0
  605. ifHighSpeed.1 = 10
  606. ifHighSpeed.2 = 100
  607. ifHighSpeed.3 = 10
  608. ifHighSpeed.4 = 0
  609. ifPromiscuousMode.1 = false
  610. ifPromiscuousMode.2 = false
  611. ifPromiscuousMode.3 = false
  612. ifPromiscuousMode.4 = false
  613. ifConnectorPresent.1 = false
  614. ifConnectorPresent.2 = true
  615. ifConnectorPresent.3 = true
  616. ifConnectorPresent.4 = true
  617. ifAlias.1 =
  618. ifAlias.2 =
  619. ifAlias.3 =
  620. ifAlias.4 =
  621. ifCounterDiscontinuityTime.1 = 0:0:00:00.00
  622. ifCounterDiscontinuityTime.2 = 0:0:00:00.00
  623. ifCounterDiscontinuityTime.3 = 0:0:00:00.00
  624. ifCounterDiscontinuityTime.4 = 0:0:00:00.00  
  625.  
  626.  
  627. ifDescr SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifDescr']
  628.  
  629. ifAdminStatus SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifAdminStatus']
  630.  
  631. ifDescr.1 = lo
  632. ifDescr.2 = eth0
  633. ifDescr.3 = eth1
  634. ifDescr.4 = usb0  
  635.  
  636.  
  637. ifAdminStatus.1 = up
  638. ifAdminStatus.2 = up
  639. ifAdminStatus.3 = up
  640. ifAdminStatus.4 = up  
  641.  
  642.  
  643.  
  644. ifOperStatus
  645. SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifOperStatus']
  646.  
  647. ifLastChange SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifLastChange']
  648.  
  649. ifOperStatus.1 = up
  650. ifOperStatus.2 = up
  651. ifOperStatus.3 = down
  652. ifOperStatus.4 = down  
  653.  
  654.  
  655. ifType SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifType']
  656.  
  657. ifLastChange.1 = 0
  658. ifLastChange.2 = 0
  659. ifLastChange.3 = 0
  660. ifLastChange.4 = 0  
  661.  
  662.  
  663. ifPhysAddress SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifPhysAddress']
  664.  
  665. ifType.1 = softwareLoopback
  666. ifType.2 = ethernetCsmacd
  667. ifType.3 = ethernetCsmacd
  668. ifType.4 = ethernetCsmacd  
  669.  
  670.  
  671. ifMtu SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifMtu']
  672.  
  673. ifPhysAddress.1 =
  674. ifPhysAddress.2 = 0:2:4e:15:68:b6
  675. ifPhysAddress.3 = 0:2:4e:9:0:49
  676. ifPhysAddress.4 = 0:2:4e:16:68:b6  
  677.  
  678.  
  679. ifInErrors SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifInErrors']
  680.  
  681. ifMtu.1 = 65536
  682. ifMtu.2 = 1500
  683. ifMtu.3 = 1500
  684. ifMtu.4 = 1500  
  685.  
  686.  
  687. ifOutErrors SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifOutErrors']
  688.  
  689. ifInErrors.1 = 0
  690. ifInErrors.2 = 0
  691. ifInErrors.3 = 0
  692. ifInErrors.4 = 0  
  693.  
  694.  
  695. ifOutErrors.1 = 0
  696. ifOutErrors.2 = 0
  697. ifOutErrors.3 = 0
  698. ifOutErrors.4 = 0  
  699.  
  700.  
  701. ifInDiscards
  702. SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifInDiscards']
  703.  
  704. ifInDiscards.1 = 0
  705. ifInDiscards.2 = 10413
  706. ifInDiscards.3 = 0
  707. ifInDiscards.4 = 0  
  708.  
  709.  
  710. ifOutDiscards
  711. SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifOutDiscards']
  712.  
  713. dot3StatsDuplexStatus
  714. ifOutDiscards.1 = 0
  715. ifOutDiscards.2 = 0
  716. ifOutDiscards.3 = 0
  717. ifOutDiscards.4 = 0  
  718.  
  719.  
  720. SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus']
  721.  
  722. SNMP['/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1qPvid']
  723.  
  724. dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
  725.  
  726. Invalid snmp_walk() data = dot3StatsDuplexStatus = No Such Object available on this agent at this OID  
  727.  
  728. dot1qPvid = No Such Object available on this agent at this OID  
  729.  
  730. Invalid snmp_walk() data = dot1qPvid = No Such Object available on this agent at this OID  
  731.  
  732. SQL[SELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl') [8] 2.8ms]
  733.  
  734.  
  735. array (
  736.   1 =>
  737.   array (
  738.     'ifName' => 'lo',
  739.     'ifInMulticastPkts' => '0',
  740.     'ifInBroadcastPkts' => '0',
  741.     'ifOutMulticastPkts' => '0',
  742.     'ifOutBroadcastPkts' => '0',
  743.     'ifHCInOctets' => '17123197006',
  744.     'ifHCInUcastPkts' => '5913154',
  745.     'ifHCInMulticastPkts' => '0',
  746.     'ifHCInBroadcastPkts' => '0',
  747.     'ifHCOutOctets' => '17123197006',
  748.     'ifHCOutUcastPkts' => '5913154',
  749.     'ifHCOutMulticastPkts' => '0',
  750.     'ifHCOutBroadcastPkts' => '0',
  751.     'ifHighSpeed' => '10',
  752.     'ifPromiscuousMode' => 'false',
  753.     'ifConnectorPresent' => 'false',
  754.     'ifAlias' => '',
  755.     'ifCounterDiscontinuityTime' => '0:0:00:00.00',
  756.     'ifDescr' => 'lo',
  757.     'ifAdminStatus' => 'up',
  758.     'ifOperStatus' => 'up',
  759.     'ifLastChange' => '0',
  760.     'ifType' => 'softwareLoopback',
  761.     'ifPhysAddress' => '',
  762.     'ifMtu' => '65536',
  763.     'ifInErrors' => '0',
  764.     'ifOutErrors' => '0',
  765.     'ifInDiscards' => '0',
  766.     'ifOutDiscards' => '0',
  767.   ),
  768.   2 =>
  769.   array (
  770.     'ifName' => 'eth0',
  771.     'ifInMulticastPkts' => '0',
  772.     'ifInBroadcastPkts' => '0',
  773.     'ifOutMulticastPkts' => '0',
  774.     'ifOutBroadcastPkts' => '0',
  775.     'ifHCInOctets' => '1274350204',
  776.     'ifHCInUcastPkts' => '26450586',
  777.     'ifHCInMulticastPkts' => '0',
  778.     'ifHCInBroadcastPkts' => '0',
  779.     'ifHCOutOctets' => '197057920',
  780.     'ifHCOutUcastPkts' => '696736',
  781.     'ifHCOutMulticastPkts' => '0',
  782.     'ifHCOutBroadcastPkts' => '0',
  783.     'ifHighSpeed' => '100',
  784.     'ifPromiscuousMode' => 'false',
  785.     'ifConnectorPresent' => 'true',
  786.     'ifAlias' => '',
  787.     'ifCounterDiscontinuityTime' => '0:0:00:00.00',
  788.     'ifDescr' => 'eth0',
  789.     'ifAdminStatus' => 'up',
  790.     'ifOperStatus' => 'up',
  791.     'ifLastChange' => '0',
  792.     'ifType' => 'ethernetCsmacd',
  793.     'ifPhysAddress' => '0:2:4e:15:68:b6',
  794.     'ifMtu' => '1500',
  795.     'ifInErrors' => '0',
  796.     'ifOutErrors' => '0',
  797.     'ifInDiscards' => '10413',
  798.     'ifOutDiscards' => '0',
  799.   ),
  800.   3 =>
  801.   array (
  802.     'ifName' => 'eth1',
  803.     'ifInMulticastPkts' => '0',
  804.     'ifInBroadcastPkts' => '0',
  805.     'ifOutMulticastPkts' => '0',
  806.     'ifOutBroadcastPkts' => '0',
  807.     'ifHCInOctets' => '0',
  808.     'ifHCInUcastPkts' => '0',
  809.     'ifHCInMulticastPkts' => '0',
  810.     'ifHCInBroadcastPkts' => '0',
  811.     'ifHCOutOctets' => '0',
  812.     'ifHCOutUcastPkts' => '0',
  813.     'ifHCOutMulticastPkts' => '0',
  814.     'ifHCOutBroadcastPkts' => '0',
  815.     'ifHighSpeed' => '10',
  816.     'ifPromiscuousMode' => 'false',
  817.     'ifConnectorPresent' => 'true',
  818.     'ifAlias' => '',
  819.     'ifCounterDiscontinuityTime' => '0:0:00:00.00',
  820.     'ifDescr' => 'eth1',
  821.     'ifAdminStatus' => 'up',
  822.     'ifOperStatus' => 'down',
  823.     'ifLastChange' => '0',
  824.     'ifType' => 'ethernetCsmacd',
  825.     'ifPhysAddress' => '0:2:4e:9:0:49',
  826.     'ifMtu' => '1500',
  827.     'ifInErrors' => '0',
  828.     'ifOutErrors' => '0',
  829.     'ifInDiscards' => '0',
  830.     'ifOutDiscards' => '0',
  831.   ),
  832.   4 =>
  833.   array (
  834.     'ifName' => 'usb0',
  835.     'ifInMulticastPkts' => '0',
  836.     'ifInBroadcastPkts' => '0',
  837.     'ifOutMulticastPkts' => '0',
  838.     'ifOutBroadcastPkts' => '0',
  839.     'ifHCInOctets' => '0',
  840.     'ifHCInUcastPkts' => '0',
  841.     'ifHCInMulticastPkts' => '0',
  842.     'ifHCInBroadcastPkts' => '0',
  843.     'ifHCOutOctets' => '0',
  844.     'ifHCOutUcastPkts' => '0',
  845.     'ifHCOutMulticastPkts' => '0',
  846.     'ifHCOutBroadcastPkts' => '0',
  847.     'ifHighSpeed' => '0',
  848.     'ifPromiscuousMode' => 'false',
  849.     'ifConnectorPresent' => 'true',
  850.     'ifAlias' => '',
  851.     'ifCounterDiscontinuityTime' => '0:0:00:00.00',
  852.     'ifDescr' => 'usb0',
  853.     'ifAdminStatus' => 'up',
  854.     'ifOperStatus' => 'down',
  855.     'ifLastChange' => '0',
  856.     'ifType' => 'ethernetCsmacd',
  857.     'ifPhysAddress' => '0:2:4e:16:68:b6',
  858.     'ifMtu' => '1500',
  859.     'ifInErrors' => '0',
  860.     'ifOutErrors' => '0',
  861.     'ifInDiscards' => '0',
  862.     'ifOutDiscards' => '0',
  863.   ),
  864. )  
  865.  
  866.  valid  
  867.  
  868.  valid  
  869.  
  870.  valid  
  871.  
  872.  valid  
  873.  
  874.  
  875.  
  876. Port lo: lo (1 / #230)
  877. ifHCInOctets  
  878.  
  879. ifHCOutOctets  
  880.  
  881. ifHCInUcastPkts  
  882.  
  883. ifHCOutUcastPkts  
  884.  
  885. ifInBroadcastPkts  
  886.  
  887. ifOutBroadcastPkts  
  888.  
  889. ifInMulticastPkts  
  890.  
  891. ifOutMulticastPkts  
  892.  
  893. ifHighSpeed  
  894.  
  895. VLAN =  
  896.  Using ifDescr as ifAlias  
  897.  
  898. lo
  899.  
  900.  ifInOctets (92399 B) 3079.9666666667 Bps 30 secs  
  901.  
  902.  
  903.  ifOutOctets (92399 B) 3079.9666666667 Bps 30 secs  
  904.  
  905. bps(24.64 kbps/24.64 kbps)bytes(90.23 kB/90.23 kB)pkts(1.4 pps/1.4 pps)
  906.  
  907.  ifInErrors (0 B) 0 Bps 30 secs  
  908.  
  909.  ifOutErrors (0 B) 0 Bps 30 secs  
  910.  
  911.  ifInUcastPkts (42 B) 1.4 Bps 30 secs  
  912.  
  913.  ifOutUcastPkts (42 B) 1.4 Bps 30 secs  
  914.  
  915.  ifInNUcastPkts (0 B) 0 Bps 30 secs  
  916.  
  917.  ifOutNUcastPkts (0 B) 0 Bps 30 secs  
  918.  
  919.  ifInDiscards (0 B) 0 Bps 30 secs  
  920.  
  921.  ifOutDiscards (0 B) 0 Bps 30 secs  
  922.  
  923.  ifInUnknownProtos (0 B) 0 Bps 30 secs  
  924.  
  925.  ifInBroadcastPkts (0 B) 0 Bps 30 secs  
  926.  
  927.  ifOutBroadcastPkts (0 B) 0 Bps 30 secs  
  928.  
  929.  ifInMulticastPkts (0 B) 0 Bps 30 secs  
  930.  
  931.  ifOutMulticastPkts (0 B) 0 Bps 30 secs  
  932.  
  933. SQL[UPDATE `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` = ? ["17123197006",17123104607,3079.9666666666667,92399,"17123197006",17123104607,3079.9666666666667,92399,"0",0,0,0,"0",0,0,0,"5913154",5913112,1.4,42,"5913154",5913112,1.4,42,1589216255,1589216225,30,230] 3.03ms]
  934.  
  935.  
  936.  
  937. Port eth0: eth0 (2 / #231) VLAN =  eth0bps(16.33 kbps/4.37 kbps)bytes(59.8 kB/15.98 kB)pkts(11.27 pps/2.5 pps)
  938. SQL[UPDATE `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,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,230] 4.82ms]
  939.  
  940. 1 updated  
  941. ifHCInOctets  
  942. ifHCOutOctets  
  943. ifHCInUcastPkts  
  944. ifHCOutUcastPkts  
  945. ifInBroadcastPkts  
  946. ifOutBroadcastPkts  
  947. ifInMulticastPkts  
  948. ifOutMulticastPkts  
  949. ifHighSpeed  
  950.  Using ifDescr as ifAlias  
  951.  
  952.  ifInOctets (61238 B) 2041.2666666667 Bps 30 secs  
  953.  
  954.  ifOutOctets (16367 B) 545.56666666667 Bps 30 secs  
  955.  
  956.  ifInErrors (0 B) 0 Bps 30 secs  
  957.  
  958.  ifOutErrors (0 B) 0 Bps 30 secs  
  959.  
  960.  ifInUcastPkts (338 B) 11.266666666667 Bps 30 secs  
  961.  
  962.  ifOutUcastPkts (75 B) 2.5 Bps 30 secs  
  963.  
  964.  ifInNUcastPkts (0 B) 0 Bps 30 secs  
  965.  
  966.  ifOutNUcastPkts (0 B) 0 Bps 30 secs  
  967.  
  968.  ifInDiscards (0 B) 0 Bps 30 secs  
  969.  
  970.  ifOutDiscards (0 B) 0 Bps 30 secs  
  971.  
  972.  ifInUnknownProtos (0 B) 0 Bps 30 secs  
  973.  
  974.  ifInBroadcastPkts (0 B) 0 Bps 30 secs  
  975.  
  976.  ifOutBroadcastPkts (0 B) 0 Bps 30 secs  
  977.  
  978.  ifInMulticastPkts (0 B) 0 Bps 30 secs  
  979.  
  980.  ifOutMulticastPkts (0 B) 0 Bps 30 secs  
  981.  
  982. SQL[UPDATE `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` = ? ["1274350204",1274288966,2041.2666666666667,61238,"197057920",197041553,545.5666666666667,16367,"0",0,0,0,"0",0,0,0,"26450586",26450248,11.266666666666667,338,"696736",696661,2.5,75,1589216255,1589216225,30,231] 3.43ms]
  983.  
  984.  
  985.  
  986. Port eth1: eth1 (3 / #232) VLAN =  
  987. SQL[UPDATE `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,0,0,0,0,0,0,0,"10413",10413,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,231] 3.56ms]
  988.  
  989. 1 updated  
  990. ifInOctets  
  991. ifOutOctets  
  992. ifInUcastPkts  
  993. ifOutUcastPkts  
  994. ifInBroadcastPkts  
  995. ifOutBroadcastPkts  
  996. ifInMulticastPkts  
  997. ifOutMulticastPkts  
  998. ifHighSpeed  
  999.  
  1000.  Using ifDescr as ifAlias  
  1001.  
  1002. eth1
  1003. Port usb0: usb0 (4 / #233) VLAN =  usb0
  1004. 232 skipped because port is still down since last polling.  
  1005. ifInOctets  
  1006. ifOutOctets  
  1007. ifInUcastPkts  
  1008. ifOutUcastPkts  
  1009. ifInBroadcastPkts  
  1010. ifOutBroadcastPkts  
  1011. ifInMulticastPkts  
  1012. ifOutMulticastPkts  
  1013. ifHighSpeed  
  1014.  Using ifDescr as ifAlias  
  1015. 233 skipped because port is still down since last polling.  
  1016.  
  1017.  
  1018.  
  1019. SQL[UPDATE `ports` set `ifSpeed_prev`=?,`ifHighSpeed_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0,"0",1589216255,1589216225,30,233] 0.99ms]
  1020.  
  1021. 1 updated  
  1022.  
  1023.  
  1024. >> Runtime for poller module 'ports': 1.5519 seconds with 14600 bytes
  1025. >> SNMP: [14/1.51s] MySQL: [6/0.02s]
  1026. #### Unload poller module ports ####
  1027.  
  1028.  
  1029. #### Load poller module customoid ####
  1030.  
  1031. >> Runtime for poller module 'customoid': 0.0013 seconds with 1120 bytes
  1032. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  1033. #### Unload poller module customoid ####
  1034.  
  1035.  
  1036. SQL[update `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where `port_id` in (?) [1589216255,1589216225,1589216255,232] 0.69ms]
  1037.  
  1038. 1 updated  
  1039. Modules status: Global+  
  1040. OS  
  1041. Device  
  1042. SQL[SELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [8] 0.72ms]
  1043.  
  1044.  
  1045. Modules status: Global+  
  1046. OS  
  1047.  
  1048. Device  
  1049.  
  1050.  
  1051. #### Load poller module bgp-peers ####
  1052.  
  1053.  
  1054. >> Runtime for poller module 'bgp-peers': 0.0037 seconds with 1208 bytes
  1055. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  1056. #### Unload poller module bgp-peers ####
  1057.  
  1058. Module [ junose-atm-vp ] disabled globally.
  1059.  
  1060. Module [ toner ] disabled globally.
  1061.  
  1062.  
  1063. #### Load poller module ucd-diskio ####
  1064.  
  1065. SQL[SELECT * FROM `bgpPeers` AS B LEFT JOIN `vrfs` AS V ON `B`.`vrf_id` = `V`.`vrf_id` WHERE `B`.`device_id` = ? [8] 1.23ms]
  1066.  
  1067. Modules status: Global-  
  1068. OS  
  1069. Device  
  1070. Modules status: Global-  
  1071. OS  
  1072. Device  
  1073. Modules status: Global+  
  1074. OS  
  1075. Device  
  1076.  
  1077.  
  1078. >> Runtime for poller module 'ucd-diskio': 0.0014 seconds with 1208 bytes
  1079. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  1080. #### Unload poller module ucd-diskio ####
  1081.  
  1082. Module [ wifi ] disabled globally.
  1083.  
  1084.  
  1085. #### Load poller module wireless ####
  1086.  
  1087. SQL[SELECT * FROM `ucd_diskio` WHERE `device_id`  = ? [8] 0.66ms]
  1088.  
  1089. Modules status: Global-  
  1090. OS  
  1091. Device  
  1092. Modules status: Global+  
  1093. OS  
  1094. Device  
  1095.  
  1096. Attempting to initialize OS: generic  
  1097. OS initialized: LibreNMS\OS\Generic  
  1098.  
  1099.  
  1100. >> Runtime for poller module 'wireless': 0.0118 seconds with 86408 bytes
  1101. >> SNMP: [0/0.00s] MySQL: [1/0.01s]
  1102. #### Unload poller module wireless ####
  1103.  
  1104. Module [ ospf ] disabled on host.
  1105.  
  1106. Module [ cisco-ipsec-flow-monitor ] disabled globally.
  1107.  
  1108. Module [ cisco-remote-access-monitor ] disabled globally.
  1109.  
  1110. Module [ cisco-cef ] disabled globally.
  1111.  
  1112. Module [ cisco-sla ] disabled globally.
  1113.  
  1114. Module [ cisco-mac-accounting ] disabled globally.
  1115.  
  1116. Module [ cipsec-tunnels ] disabled globally.
  1117.  
  1118. Module [ cisco-ace-loadbalancer ] disabled globally.
  1119.  
  1120. Module [ cisco-ace-serverfarms ] disabled globally.
  1121.  
  1122. Module [ cisco-asa-firewall ] disabled globally.
  1123.  
  1124. Module [ cisco-voice ] disabled globally.
  1125.  
  1126. Module [ cisco-cbqos ] disabled globally.
  1127.  
  1128. Module [ cisco-otv ] disabled globally.
  1129.  
  1130. Module [ cisco-qfp ] disabled globally.
  1131.  
  1132. Module [ cisco-vpdn ] disabled globally.
  1133.  
  1134. Module [ nac ] disabled globally.
  1135.  
  1136. Module [ netscaler-vsvr ] disabled globally.
  1137.  
  1138. Module [ aruba-controller ] disabled globally.
  1139.  
  1140.  
  1141. #### Load poller module entity-physical ####
  1142.  
  1143. SQL[SELECT * FROM `wireless_sensors` WHERE `device_id` = ? [8] 6.52ms]
  1144.  
  1145. Modules status: Global+  
  1146. OS  
  1147. Device-  
  1148. Modules status: Global-  
  1149. OS  
  1150. Device  
  1151. Modules status: Global-  
  1152. OS  
  1153. Device  
  1154. Modules status: Global-  
  1155. OS  
  1156. Device  
  1157. Modules status: Global-  
  1158. OS  
  1159. Device  
  1160. Modules status: Global-  
  1161. OS  
  1162. Device  
  1163. Modules status: Global-  
  1164. OS  
  1165. Device  
  1166. Modules status: Global-  
  1167. OS  
  1168. Device  
  1169. Modules status: Global-  
  1170. OS  
  1171. Device  
  1172. Modules status: Global-  
  1173. OS  
  1174. Device  
  1175. Modules status: Global-  
  1176. OS  
  1177. Device  
  1178. Modules status: Global-  
  1179. OS  
  1180. Device  
  1181. Modules status: Global-  
  1182. OS  
  1183. Device  
  1184. Modules status: Global-  
  1185. OS  
  1186. Device  
  1187. Modules status: Global-  
  1188. OS  
  1189. Device  
  1190. Modules status: Global-  
  1191. OS  
  1192. Device  
  1193. Modules status: Global-  
  1194. OS  
  1195. Device  
  1196. Modules status: Global-  
  1197. OS  
  1198. Device  
  1199. Modules status: Global+  
  1200. OS  
  1201. Device  
  1202.  
  1203.  
  1204. >> Runtime for poller module 'entity-physical': 0.0017 seconds with 1304 bytes
  1205. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  1206. #### Unload poller module entity-physical ####
  1207.  
  1208. Module [ entity-state ] disabled globally.
  1209.  
  1210.  
  1211. #### Load poller module applications ####
  1212.  
  1213. SQL[SELECT * FROM `entPhysical_state` WHERE `device_id` = ? [8] 0.73ms]
  1214.  
  1215. Modules status: Global-  
  1216. OS  
  1217. Device  
  1218. Modules status: Global+  
  1219. OS  
  1220. Device  
  1221.  
  1222.  
  1223. >> Runtime for poller module 'applications': 0.0012 seconds with 1208 bytes
  1224. >> SNMP: [0/0.00s] MySQL: [1/0.00s]
  1225. #### Unload poller module applications ####
  1226.  
  1227. Module [ mib ] disabled globally.
  1228.  
  1229.  
  1230. #### Load poller module stp ####
  1231.  
  1232. SQL[SELECT * FROM `applications` WHERE `device_id`  = ? [8] 0.77ms]
  1233.  
  1234. Modules status: Global-  
  1235. OS  
  1236. Device  
  1237. Modules status: Global+  
  1238. OS  
  1239. Device  
  1240.  
  1241. SNMP['/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-m' 'RSTP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1dStpProtocolSpecification.0']
  1242.  
  1243. SQL[SELECT * FROM `stp` WHERE `device_id` = ? [8] 0.93ms]
  1244.  
  1245.  
  1246.  
  1247.  
  1248. >> Runtime for poller module 'stp': 0.2016 seconds with 2296 bytes
  1249. >> SNMP: [1/0.20s] MySQL: [1/0.00s]
  1250. #### Unload poller module stp ####
  1251.  
  1252.  
  1253. No Such Object available on this agent at this OID  
  1254.  
  1255.  
  1256. Module [ ntp ] disabled on host.
  1257.  
  1258. Module [ loadbalancers ] disabled globally.
  1259.  
  1260. Module [ mef ] disabled globally.
  1261.  
  1262.  
  1263. #### Load poller module mpls ####
  1264.  
  1265. >> Runtime for poller module 'mpls': 0.0015 seconds with 1392 bytes
  1266. >> SNMP: [0/0.00s] MySQL: [0/0.00s]
  1267. #### Unload poller module mpls ####
  1268.  
  1269. ### Start Device Groups ###
  1270.  
  1271. Modules status: Global+  
  1272. OS  
  1273. Device-  
  1274. Modules status: Global-  
  1275. OS  
  1276. Device  
  1277. Modules status: Global-  
  1278. OS  
  1279. Device  
  1280. Modules status: Global+  
  1281. OS  
  1282. Device  
  1283. Attempting to initialize OS: generic  
  1284. OS initialized: LibreNMS\OS\Generic  
  1285.  
  1286. SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [8] 1.57ms]
  1287.  
  1288.  
  1289. SQL[select * from `device_groups` [] 0.54ms]
  1290.  
  1291.  
  1292. SQL[select `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, 2) [] 1.28ms]
  1293.  
  1294.  
  1295. SQL[select exists(select * from `devices` left join `locations` on `locations`.`id` = `devices`.`location_id` where (`locations`.`location` LIKE ?) and `devices`.`device_id` = ?) as `exists` ["640 NE 20th%",8] 1.13ms]
  1296.  
  1297.  
  1298. SQL[select exists(select * from `devices` left join `locations` on `locations`.`id` = `devices`.`location_id` where (`locations`.`location` LIKE ?) and `devices`.`device_id` = ?) as `exists` ["estin Building%",8] 0.85ms]
  1299.  
  1300.  
  1301. SQL[select * from `device_group_device` where `device_id` = ? [8] 0.8ms]
  1302.  
  1303.  
  1304. Groups Added:  
  1305.  
  1306. Groups Removed:  
  1307.  
  1308. ### End Device Groups, runtime: 0.024s ###
  1309.  
  1310. Enabling graphs:
  1311. uptime netstat_icmp netstat_icmp_info netstat_ip netstat_ip_frag netstat_snmp netstat_snmp_pkt netstat_tcp netstat_udp ucd_cpu ucd_swap_io ucd_io ucd_contexts ucd_interrupts ucd_io_wait ucd_cpu_steal ucd_memory ucd_load ipsystemstats_ipv4 ipsystemstats_ipv4_frag ipsystemstats_ipv6 ipsystemstats_ipv6_frag
  1312.  
  1313. SQL[SELECT `graph` FROM `device_graphs` WHERE `device_id` = ? [8] 0.87ms]
  1314.  
  1315.  
  1316.  
  1317. Polled in 7.012 seconds
  1318. #### Start Alerts ####
  1319.  
  1320. SQL[UPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=?,`last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [1677652,187,7.012,8] 0.99ms]
  1321.  
  1322. Updating erin-cd800.catgirls.dev  
  1323.  
  1324. SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [8] 1.37ms]
  1325.  
  1326.  
  1327. SQL[select `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` = ? [8] 6.39ms]
  1328.  
  1329.  
  1330. SQL[select * from `locations` where `locations`.`id` = ? limit 1 [1] 1.01ms]
  1331.  
  1332.  
  1333. SQL[select exists(select * from `alert_schedule` inner join `alert_schedulables` on `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` where ((`recurring` = ? and `start` <= NOW() and `end` >= NOW()) or (`recurring` = ? and (`start_recurring_dt` <= date_format(NOW(), '--%d') and (`end_recurring_dt` >= date_format(NOW(), '--%d') or `end_recurring_dt` is null or `end_recurring_dt` = ? or `end_recurring_dt` = ?)) and `start_recurring_hr` <= date_format(NOW(), '%H:%i:%s') and `end_recurring_hr` >= date_format(NOW(), '%H:%i:%s') and (`recurring_day` like CONCAT('%', date_format(NOW(), ''), '%') or `recurring_day` is null or `recurring_day` = ?))) and ((`alert_schedulable_type` = ? and `alert_schedulable_id` = ?) or (`alert_schedulable_type` = ? and `alert_schedulable_id` in (?)) or (`alert_schedulable_type` = ? and `alert_schedulable_id` = ?))) as `exists` [0,1,"0000-00-00","","","device",8,"device_group",1,"location",1] 1.24ms]
  1334.  
  1335.  
  1336. SQL[select * from `devices` where `devices`.`device_id` = ? limit 1 [8] 0.94ms]
  1337.  
  1338.  
  1339. Rule #1 (Device Down! Due to no ICMP response.):
  1340. SQL[SELECT DISTINCT a.* FROM alert_rules a
  1341.         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 = ?)
  1342.         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 = ?))
  1343.         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 = ?))
  1344.         LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ?
  1345.         WHERE a.disabled = 0 AND (
  1346.             (d.device_id IS NULL AND g.group_id IS NULL)
  1347.             OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=?))
  1348.             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))
  1349.         ) [8,8,8,8,8,8,8,8] 3.47ms]
  1350.  
  1351.  
  1352.  
  1353. SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND devices.status_reason = "icmp" [8] 1.07ms]
  1354.  
  1355.  
  1356. Status: NOCHG
  1357. Rule #2 (SNMP not responding on Device - Check on SNMP Service - Device marked Down!):
  1358. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [1,8] 0.68ms]
  1359.  
  1360.  
  1361.  
  1362. SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND devices.status_reason = "snmp" [8] 1.09ms]
  1363.  
  1364.  
  1365. Status: NOCHG
  1366. Rule #3 (Device rebooted):
  1367. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [2,8] 0.62ms]
  1368.  
  1369.  
  1370.  
  1371. SQL[SELECT * FROM devices WHERE (devices.device_id = ?) AND devices.uptime < 300 xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed bgpPeers.bgpPeerState = "established" xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed>ports.ifInOctets_rate, ports.ifOutOctets_rate, ports.ifInOctets_rate)*8) / ports.ifSpeed)*100) >= 80 AND (ports.ifOperStatus = "up" && ports.ifAdminStatus = "up" && (ports.deleted = 0 && ports.ignore = 0 && ports.disabled = 0)) = 1 [8] 1.83ms]
  1372.  
  1373.  
  1374. Status: NOCHG
  1375. Rule #9 (Sensor over limit - Check Device Health Settings):
  1376. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [8,8] 1.3ms]
  1377.  
  1378.  
  1379.  
  1380. SQL[SELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current > sensors.sensor_limit AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [8] 1.54ms]
  1381.  
  1382.  
  1383. Status: NOCHG
  1384. Rule #10 (Sensor under limit - Check Device Health Settings):
  1385. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [9,8] 0.67ms]
  1386.  
  1387.  
  1388.  
  1389. SQL[SELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current < sensors xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed>= customoids.customoid_limit AND customoids.customoid_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [8] 1.31ms]
  1390.  
  1391.  
  1392. Status: NOCHG
  1393. Rule #16 (CustomOID under limit):
  1394. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [15,8] 0.59ms]
  1395.  
  1396.  
  1397.  
  1398. SQL[SELECT * FROM devices,customoids WHERE (devices.device_id = ? AND devices.device_id = customoids.device_id) AND customoids.customoid_current &lt;= customoids.customoid_limit_low AND customoids.customoid_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [8] 1.98ms]
  1399.  
  1400.  
  1401. Status: NOCHG
  1402. Rule #17 (CustomOID over warning limit):
  1403. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [16,8] 0.6ms]
  1404.  
  1405.  
  1406.  
  1407. SQL[SELECT * FROM devices,customoids WHERE (devices.device_id = ? AND devices.device_id = customoids.device_id) AND customoids.customoid_current >= customoids.customoid_limit_warn AND customoids.customoid_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [8] 1.21ms]
  1408.  
  1409.  
  1410. Status: NOCHG
  1411. Rule #18 (CustomOID under warning limit):
  1412. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [17,8] 0.59ms]
  1413.  
  1414.  
  1415.  
  1416. SQL[SELECT * FROM devices,customoids WHERE (devices.device_id = ? AND devices.device_id = customoids.device_id) AND customoids.customoid_current &lt;= customoids.customoid_limit_low_warn AND customoids.customoid_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [8] 1.26ms]
  1417.  
  1418.  
  1419. Status: NOCHG
  1420. Rule #19 (Swap above 256MB):
  1421. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [18,8] 0.59ms]
  1422.  
  1423.  
  1424.  
  1425. SQL[SELECT * FROM devices,mempools WHERE (devices.device_id = ? AND devices.device_id = mempools.device_id) AND mempools.mempool_descr = "Swap space" AND mempools.mempool_used >= 268435456 [8] 1.17ms]
  1426.  
  1427.  
  1428. Status: NOCHG
  1429. Rule #38 (Swap above 1GB):
  1430. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [19,8] 0.62ms]
  1431.  
  1432.  
  1433.  
  1434. SQL[SELECT * FROM devices,mempools WHERE (devices.device_id = ? AND devices.device_id = mempools.device_id) AND mempools.mempool_descr = "Swap space" AND mempools.mempool_used >= 1073741824 [8] 0.96ms]
  1435.  
  1436.  
  1437. Status: NOCHG
  1438. #### End Alerts ####
  1439.  
  1440. SQL[SELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [38,8] 0.49ms]
  1441.  
  1442.  
  1443. SNMP [31/5.79s]: Get[9/1.98s] Getnext[4/0.41s] Walk[18/3.39s]
  1444. MySQL [41/0.08s]: Cell[18/0.02s] Row[-17/-0.02s] Rows[31/0.06s] Column[0/0.00s] Update[7/0.02s] Insert[2/0.00s] Delete[0/0.00s]
  1445.  
  1446. SQL[INSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`)  VALUES (:type,:doing,:start,:duration,:devices,:poller) {"type":"poll","doing":"erin-cd800.catgirls.dev","start":1589216248.322053,"duration":"7.325","devices":1,"poller":"\/"} 0.65ms]
  1447.  
  1448. /opt/librenms/poller.php erin-cd800.catgirls.dev 2020-05-11 16:57:35 - 1 devices polled in 7.325 secs  
  1449.  
  1450.