- LibreNMS Poller
- SQL[[1;33mselect `version` from `dbSchema` order by `version` desc limit 1 [0;33m[][0m 0.33ms]
- SQL[[1;33mSELECT version() [0;33m[][0m 0.11ms]
- ===================================
- Version info:
- Commit SHA: dd39a1ab03b743cb478b8c9eb51476a126b0b83e
- Commit Date: 1538863691
- DB Schema: 268
- PHP: 7.2.6
- MySQL: 5.5.56-MariaDB
- RRDTool: 1.4.8
- SNMP: NET-SNMP 5.7.2
- ==================================DEBUG!
- Updating os_def.cache... Done
- Starting polling run:
- SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '10.1.6.150' ORDER BY `device_id` ASC [0;33m[][0m 0.69ms]
- SQL[[1;33mSELECT * FROM devices_attribs WHERE `device_id` = ? [0;33m[236][0m 0.19ms]
- Hostname: 10.1.6.150
- Device ID: 236
- OS: audiocodes
- Warning: inet_pton(): Unrecognized address in /opt/librenms/includes/polling/functions.inc.php on line 248
- (audiocodes)
- [FPING] /usr/sbin/fping -e -q -c 3 -p 500 -t 500 10.1.6.150
- Array
- (
- [xmt] => 3
- [rcv] => 3
- [loss] => 0
- [min] => 0.34
- [max] => 0.37
- [avg] => 0.35
- [exitcode] => 0
- )
- SQL[[1;33mINSERT IGNORE INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`) VALUES (:xmt,:rcv,:loss,:min,:max,:avg,:device_id,NOW()) [0;33m{"xmt":"3","rcv":"3","loss":"0","min":"0.34","max":"0.37","avg":"0.35","device_id":236}[0m 1.16ms]
- SNMP Check response code: 0
- Modules status: Global+ OS Device
- #### Load poller module core ####
- SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OQnUt -m SNMPv2-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 sysUpTime.0 sysLocation.0 sysContact.0 sysName.0 sysObjectID.0 sysDescr.0[0m]
- .*.*.0 = 37868993
- .*.*.0 =
- .*.*.0 =
- .*.*.0 =
- .*.*.0 = .*.4.1.5*.71
- .*.*.0 = Product: MG 1K ESBC ;SW Version: 7.20A.158.012
- SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OQnUst -m HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 snmpEngineTime.0 hrSystemUptime.0[0m]
- snmpEngineTime.0 = 378689
- hrSystemUptime.0 = 37868993
- Uptime seconds: 378690
- RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/uptime.rrd N:378690[0m]
- [[0;31mRRD Disabled[0m]Uptime: 4 days, 9h 11m 30s
- >> Runtime for poller module 'core': 0.0334 seconds with 81304 bytes
- >> SNMP: [2/0.03s] MySQL: [0/0.00s] RRD: [0/0.00s]
- #### Unload poller module core ####
- RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/poller-perf-core.rrd N:0.033370018005371[0m]
- [[0;31mRRD Disabled[0m]Modules status: Global- OS Device Module [ unix-agent ] disabled globally.
- Modules status: Global+ OS Device
- #### Load poller module os ####
- Generic :(
- Hardware:
- Version:
- Features:
- Serial:
- >> Runtime for poller module 'os': 0.0002 seconds with 520 bytes
- >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
- #### Unload poller module os ####
- RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/poller-perf-os.rrd N:0.00016093254089355[0m]
- [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device
- #### Load poller module ipmi ####
- SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[236][0m 0.48ms]
- Array
- (
- )
- >> Runtime for poller module 'ipmi': 0.0007 seconds with 2512 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module ipmi ####
- RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/poller-perf-ipmi.rrd N:0.00074601173400879[0m]
- [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device
- #### Load poller module sensors ####
- SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[236][0m 0.23ms]
- >> Runtime for poller module 'sensors': 0.0004 seconds with 1464 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module sensors ####
- RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/poller-perf-sensors.rrd N:0.00036191940307617[0m]
- [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device
- #### Load poller module processors ####
- Attempting to initialize OS: audiocodes
- Attempting to initialize OS: audiocodes
- OS initilized as Generic
- SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[236][0m 0.23ms]
- SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OUQn -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 .1.3.6.1.2.1.25.3.3.1.2.1[0m]
- .*.*.* = 33
- Array
- (
- [.1.3.6.1.2.1.25.3.3.1.2.1] => 33
- )
- 33%
- RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/processor-hr-1.rrd N:33[0m]
- [[0;31mRRD Disabled[0m]SQL[[1;33mUPDATE `processors` set `processor_usage`=? WHERE `processor_id` = ? [0;33m[33,526][0m 1.2ms]
- >> Runtime for poller module 'processors': 0.0257 seconds with 99720 bytes
- >> SNMP: [1/0.02s] MySQL: [2/0.00s] RRD: [0/0.00s]
- #### Unload poller module processors ####
- RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/poller-perf-processors.rrd N:0.025662899017334[0m]
- [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device
- #### Load poller module mempools ####
- SQL[[1;33mSELECT * FROM mempools WHERE device_id = ? [0;33m[236][0m 0.34ms]
- Mempool Internal RAM: SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 hrStorageEntry[0m]
- hrStorageIndex.1 = 1
- hrStorageIndex.2 = 2
- hrStorageType.1 = hrStorageRam
- hrStorageType.2 = hrStorageFlashMemory
- hrStorageDescr.1 = Internal RAM
- hrStorageDescr.2 = Internal Flash
- hrStorageAllocationUnits.1 = 1
- hrStorageAllocationUnits.2 = 1
- hrStorageSize.1 = 512
- hrStorageSize.2 = 67108864
- hrStorageUsed.1 = 0
- hrStorageUsed.2 = 0
- hrStorageAllocationFailures.1 = 0
- hrStorageAllocationFailures.2 = 0
- Array
- (
- [hrstorage] => Array
- (
- [1] => Array
- (
- [hrStorageIndex] => 1
- [hrStorageType] => hrStorageRam
- [hrStorageDescr] => Internal RAM
- [hrStorageAllocationUnits] => 1
- [hrStorageSize] => 512
- [hrStorageUsed] => 0
- [hrStorageAllocationFailures] => 0
- )
- [2] => Array
- (
- [hrStorageIndex] => 2
- [hrStorageType] => hrStorageFlashMemory
- [hrStorageDescr] => Internal Flash
- [hrStorageAllocationUnits] => 1
- [hrStorageSize] => 67108864
- [hrStorageUsed] => 0
- [hrStorageAllocationFailures] => 0
- )
- )
- )
- 0% RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/mempool-hrstorage-1.rrd N:0:512[0m]
- [[0;31mRRD Disabled[0m]SQL[[1;33mUPDATE `mempools` set `mempool_used`=?,`mempool_perc`=?,`mempool_free`=?,`mempool_total`=? WHERE `mempool_id` = ? [0;33m[0,0,512,512,452][0m 1.11ms]
- >> Runtime for poller module 'mempools': 0.0290 seconds with 10864 bytes
- >> SNMP: [1/0.03s] MySQL: [2/0.00s] RRD: [0/0.00s]
- #### Unload poller module mempools ####
- RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/poller-perf-mempools.rrd N:0.028994083404541[0m]
- [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device
- #### Load poller module storage ####
- SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[236][0m 0.32ms]
- Storage Internal Flash: hrstorage
- Array
- (
- [storage_id] => 764
- [device_id] => 236
- [storage_mib] => hrstorage
- [storage_index] => 2
- [storage_type] => hrStorageFlashMemory
- [storage_descr] => Internal Flash
- [storage_size] => 67108864
- [storage_units] => 1
- [storage_used] => 0
- [storage_free] => 67108864
- [storage_perc] => 0
- [storage_perc_warn] => 60
- [storage_deleted] => 0
- [units] => 1
- [used] => 0
- [size] => 67108864
- [free] => 67108864
- )
- 0% RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/storage-hrstorage-Internal_Flash.rrd N:0:67108864[0m]
- [[0;31mRRD Disabled[0m]SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["0","67108864","67108864","1",0,764][0m 0.97ms]
- >> Runtime for poller module 'storage': 0.0018 seconds with 3160 bytes
- >> SNMP: [0/0.00s] MySQL: [2/0.00s] RRD: [0/0.00s]
- #### Unload poller module storage ####
- RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/poller-perf-storage.rrd N:0.0018379688262939[0m]
- [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device
- #### Load poller module netstats ####
- ICMPSNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m IP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 icmp[0m]
- icmpInMsgs.0 = 13550
- icmpInErrors.0 = 12277
- icmpInDestUnreachs.0 = 12295
- icmpInTimeExcds.0 = 0
- icmpInParmProbs.0 = 0
- icmpInSrcQuenchs.0 = 0
- icmpInRedirects.0 = 0
- icmpInEchos.0 = 1037
- icmpInEchoReps.0 = 218
- icmpInTimestamps.0 = 0
- icmpInTimestampReps.0 = 0
- icmpInAddrMasks.0 = 0
- icmpInAddrMaskReps.0 = 0
- icmpOutMsgs.0 = 1061
- icmpOutErrors.0 = 0
- icmpOutDestUnreachs.0 = 24
- icmpOutTimeExcds.0 = 0
- icmpOutParmProbs.0 = 0
- icmpOutSrcQuenchs.0 = 0
- icmpOutRedirects.0 = 0
- icmpOutEchos.0 = 0
- icmpOutEchoReps.0 = 1037
- icmpOutTimestamps.0 = 0
- icmpOutTimestampReps.0 = 0
- icmpOutAddrMasks.0 = 0
- icmpOutAddrMaskReps.0 = 0
- icmpStatsInMsgs.unknown = 2
- icmpStatsInMsgs.ipv4 = 2
- icmpStatsInErrors.unknown = 3
- icmpStatsInErrors.ipv4 = 3
- icmpStatsOutMsgs.unknown = 4
- icmpStatsOutMsgs.ipv4 = 4
- icmpStatsOutErrors.unknown = 5
- icmpStatsOutErrors.ipv4 = 5
- icmpMsgStatsInPkts.22.33 = 44
- icmpMsgStatsOutPkts.22.33 = 55
- RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/netstats-icmp.rrd N:13550:1061:12277:0:1037:0:218:1037:12295:24:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0[0m]
- [[0;31mRRD Disabled[0m] IPSNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m IP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 IP-MIB::ipForwDatagrams.0 IP-MIB::ipInDelivers.0 IP-MIB::ipInReceives.0 IP-MIB::ipOutRequests.0 IP-MIB::ipInDiscards.0 IP-MIB::ipOutDiscards.0 IP-MIB::ipOutNoRoutes.0 IP-MIB::ipReasmReqds.0 IP-MIB::ipReasmOKs.0 IP-MIB::ipReasmFails.0 IP-MIB::ipFragOKs.0 IP-MIB::ipFragFails.0 IP-MIB::ipFragCreates.0 IP-MIB::ipInUnknownProtos.0 IP-MIB::ipInHdrErrors.0 IP-MIB::ipInAddrErrors.0[0m]
- ipForwDatagrams.0 = 0
- ipInDelivers.0 = 380407
- ipInReceives.0 = 388566
- ipOutRequests.0 = 1967721
- ipInDiscards.0 = 0
- ipOutDiscards.0 = 0
- ipOutNoRoutes.0 = 0
- ipReasmReqds.0 = 0
- ipReasmOKs.0 = 0
- ipReasmFails.0 = 0
- ipFragOKs.0 = 0
- ipFragFails.0 = 0
- ipFragCreates.0 = 0
- ipInUnknownProtos.0 = 0
- ipInHdrErrors.0 = 0
- ipInAddrErrors.0 = 35
- RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/netstats-ip.rrd N:0:380407:388566:1967721:0:0:0:0:0:0:0:0:0:0:0:35[0m]
- [[0;31mRRD Disabled[0m] IP-FORWARDSNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OQv -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 IP-FORWARD-MIB::ipCidrRouteNumber.0[0m]
- No Such Instance currently exists at this OID
- SNMPSNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m SNMPv2-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 snmp[0m]
- snmpInPkts.0 = 12410
- snmpOutPkts.0 = 11974
- snmpInBadVersions.0 = 0
- snmpInBadCommunityNames.0 = 435
- snmpInBadCommunityUses.0 = 0
- snmpInASNParseErrs.0 = 0
- snmpInTooBigs.0 = 0
- snmpInNoSuchNames.0 = 0
- snmpInBadValues.0 = 0
- snmpInReadOnlys.0 = 0
- snmpInGenErrs.0 = 0
- snmpInTotalReqVars.0 = 3238
- snmpInTotalSetVars.0 = 0
- snmpInGetRequests.0 = 2284
- snmpInGetNexts.0 = 28
- snmpInSetRequests.0 = 0
- snmpInGetResponses.0 = 0
- snmpInTraps.0 = 0
- snmpOutTooBigs.0 = 0
- snmpOutNoSuchNames.0 = 0
- snmpOutBadValues.0 = 0
- snmpOutGenErrs.0 = 0
- snmpOutGetRequests.0 = 0
- snmpOutGetNexts.0 = 0
- snmpOutSetRequests.0 = 0
- snmpOutGetResponses.0 = 11976
- snmpOutTraps.0 = 0
- snmpEnableAuthenTraps.0 = enabled
- snmpSilentDrops.0 = 0
- snmpProxyDrops.0 = 0
- RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/netstats-snmp.rrd N:12410:11974:0:435:0:0:0:0:0:0:0:3238:0:2284:28:0:0:0:0:0:0:0:0:0:0:11976:0:0:0[0m]
- [[0;31mRRD Disabled[0m] TCPSNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m TCP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes 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 tcpHCInSegs.0 tcpHCOutSegs.0[0m]
- tcpActiveOpens.0 = 1
- tcpPassiveOpens.0 = 1209
- tcpAttemptFails.0 = 67
- tcpEstabResets.0 = 235
- tcpCurrEstab.0 = 280
- tcpInSegs.0 = 218946
- tcpOutSegs.0 = 376562
- tcpRetransSegs.0 = 4812
- tcpInErrs.0 = 0
- tcpOutRsts.0 = 97
- tcpHCInSegs.0 = 0
- tcpHCOutSegs.0 = 0
- RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/netstats-tcp.rrd N:1:1209:67:235:280:218946:376562:4812:0:97[0m]
- [[0;31mRRD Disabled[0m] UDPSNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m UDP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 UDP-MIB::udpInDatagrams.0 UDP-MIB::udpOutDatagrams.0 UDP-MIB::udpInErrors.0 UDP-MIB::udpNoPorts.0[0m]
- udpInDatagrams.0 = 113986
- udpOutDatagrams.0 = 1585068
- udpInErrors.0 = 0
- udpNoPorts.0 = 24
- RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/netstats-udp.rrd N:113986:1585068:0:24[0m]
- [[0;31mRRD Disabled[0m]
- >> Runtime for poller module 'netstats': 0.1608 seconds with 2664 bytes
- >> SNMP: [6/0.16s] MySQL: [0/0.00s] RRD: [0/0.00s]
- #### Unload poller module netstats ####
- RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/poller-perf-netstats.rrd N:0.16080594062805[0m]
- [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device
- #### Load poller module hr-mib ####
- SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OUQs -m HOST-RESOURCES-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 hrSystemProcesses.0 hrSystemNumUsers.0[0m]
- hrSystemProcesses.0 = 1
- hrSystemNumUsers.0 = 0
- RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/hr_processes.rrd N:1[0m]
- [[0;31mRRD Disabled[0m] ProcessesRRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/hr_users.rrd N:0[0m]
- [[0;31mRRD Disabled[0m] Users
- >> Runtime for poller module 'hr-mib': 0.0170 seconds with 3168 bytes
- >> SNMP: [1/0.02s] MySQL: [0/0.00s] RRD: [0/0.00s]
- #### Unload poller module hr-mib ####
- RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/poller-perf-hr-mib.rrd N:0.016960144042969[0m]
- [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device
- #### Load poller module ucd-mib ####
- SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 systemStats[0m]
- systemStats = No Such Object available on this agent at this OID
- SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 memTotalSwap.0 memAvailSwap.0 memTotalReal.0 memAvailReal.0 memTotalFree.0 memShared.0 memBuffer.0 memCached.0[0m]
- memTotalSwap.0 = No Such Object available on this agent at this OID
- memAvailSwap.0 = No Such Object available on this agent at this OID
- memTotalReal.0 = No Such Object available on this agent at this OID
- memAvailReal.0 = No Such Object available on this agent at this OID
- memTotalFree.0 = No Such Object available on this agent at this OID
- memShared.0 = No Such Object available on this agent at this OID
- memBuffer.0 = No Such Object available on this agent at this OID
- memCached.0 = No Such Object available on this agent at this OID
- SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 laLoadInt.1 laLoadInt.2 laLoadInt.3[0m]
- laLoadInt.1 = No Such Object available on this agent at this OID
- laLoadInt.2 = No Such Object available on this agent at this OID
- laLoadInt.3 = No Such Object available on this agent at this OID
- >> Runtime for poller module 'ucd-mib': 0.0380 seconds with 2352 bytes
- >> SNMP: [3/0.04s] MySQL: [0/0.00s] RRD: [0/0.00s]
- #### Unload poller module ucd-mib ####
- RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/poller-perf-ucd-mib.rrd N:0.037968873977661[0m]
- [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device
- #### Load poller module ipSystemStats ####
- SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m IP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 ipSystemStats[0m]
- >> Runtime for poller module 'ipSystemStats': 0.0103 seconds with 1920 bytes
- >> SNMP: [1/0.01s] MySQL: [0/0.00s] RRD: [0/0.00s]
- #### Unload poller module ipSystemStats ####
- RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/poller-perf-ipSystemStats.rrd N:0.010281801223755[0m]
- [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device
- #### Load poller module ports ####
- 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[236][0m 0.95ms]
- Caching Oids: Full ports polling SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 ifXEntry[0m]
- ifName.1141129729 = DS1 Port 1/1
- ifName.1141129730 = DS1 Port 1/2
- ifName.1141129731 = DS1 Port 1/3
- ifName.1141129732 = DS1 Port 1/4
- ifName.1142698753 = GigabitEthernet Port 0/1
- ifName.1142698754 = GigabitEthernet Port 0/2
- ifName.1142698755 = GigabitEthernet Port 0/3
- ifInMulticastPkts.1141129729 = 0
- ifInMulticastPkts.1141129730 = 0
- ifInMulticastPkts.1141129731 = 0
- ifInMulticastPkts.1141129732 = 0
- ifInMulticastPkts.1142698753 = 241559
- ifInMulticastPkts.1142698754 = 0
- ifInMulticastPkts.1142698755 = 0
- ifInBroadcastPkts.1141129729 = 0
- ifInBroadcastPkts.1141129730 = 0
- ifInBroadcastPkts.1141129731 = 0
- ifInBroadcastPkts.1141129732 = 0
- ifInBroadcastPkts.1142698753 = 480996
- ifInBroadcastPkts.1142698754 = 0
- ifInBroadcastPkts.1142698755 = 0
- ifOutMulticastPkts.1141129729 = 0
- ifOutMulticastPkts.1141129730 = 0
- ifOutMulticastPkts.1141129731 = 0
- ifOutMulticastPkts.1141129732 = 0
- ifOutMulticastPkts.1142698753 = 0
- ifOutMulticastPkts.1142698754 = 0
- ifOutMulticastPkts.1142698755 = 0
- ifOutBroadcastPkts.1141129729 = 0
- ifOutBroadcastPkts.1141129730 = 0
- ifOutBroadcastPkts.1141129731 = 0
- ifOutBroadcastPkts.1141129732 = 0
- ifOutBroadcastPkts.1142698753 = 244
- ifOutBroadcastPkts.1142698754 = 0
- ifOutBroadcastPkts.1142698755 = 0
- ifHCInOctets.1141129729 = 0
- ifHCInOctets.1141129730 = 0
- ifHCInOctets.1141129731 = 0
- ifHCInOctets.1141129732 = 0
- ifHCInOctets.1142698753 = 32192198654
- ifHCInOctets.1142698754 = 0
- ifHCInOctets.1142698755 = 0
- ifHCInUcastPkts.1141129729 = 0
- ifHCInUcastPkts.1141129730 = 0
- ifHCInUcastPkts.1141129731 = 0
- ifHCInUcastPkts.1141129732 = 0
- ifHCInUcastPkts.1142698753 = 143988014
- ifHCInUcastPkts.1142698754 = 0
- ifHCInUcastPkts.1142698755 = 0
- ifHCInMulticastPkts.1141129729 = 0
- ifHCInMulticastPkts.1141129730 = 0
- ifHCInMulticastPkts.1141129731 = 0
- ifHCInMulticastPkts.1141129732 = 0
- ifHCInMulticastPkts.1142698753 = 241559
- ifHCInMulticastPkts.1142698754 = 0
- ifHCInMulticastPkts.1142698755 = 0
- ifHCInBroadcastPkts.1141129729 = 0
- ifHCInBroadcastPkts.1141129730 = 0
- ifHCInBroadcastPkts.1141129731 = 0
- ifHCInBroadcastPkts.1141129732 = 0
- ifHCInBroadcastPkts.1142698753 = 480996
- ifHCInBroadcastPkts.1142698754 = 0
- ifHCInBroadcastPkts.1142698755 = 0
- ifHCOutOctets.1141129729 = 0
- ifHCOutOctets.1141129730 = 0
- ifHCOutOctets.1141129731 = 0
- ifHCOutOctets.1141129732 = 0
- ifHCOutOctets.1142698753 = 34475520321
- ifHCOutOctets.1142698754 = 0
- ifHCOutOctets.1142698755 = 0
- ifHCOutUcastPkts.1141129729 = 0
- ifHCOutUcastPkts.1141129730 = 0
- ifHCOutUcastPkts.1141129731 = 0
- ifHCOutUcastPkts.1141129732 = 0
- ifHCOutUcastPkts.1142698753 = 156554886
- ifHCOutUcastPkts.1142698754 = 0
- ifHCOutUcastPkts.1142698755 = 0
- ifHCOutMulticastPkts.1141129729 = 0
- ifHCOutMulticastPkts.1141129730 = 0
- ifHCOutMulticastPkts.1141129731 = 0
- ifHCOutMulticastPkts.1141129732 = 0
- ifHCOutMulticastPkts.1142698753 = 0
- ifHCOutMulticastPkts.1142698754 = 0
- ifHCOutMulticastPkts.1142698755 = 0
- ifHCOutBroadcastPkts.1141129729 = 0
- ifHCOutBroadcastPkts.1141129730 = 0
- ifHCOutBroadcastPkts.1141129731 = 0
- ifHCOutBroadcastPkts.1141129732 = 0
- ifHCOutBroadcastPkts.1142698753 = 244
- ifHCOutBroadcastPkts.1142698754 = 0
- ifHCOutBroadcastPkts.1142698755 = 0
- ifLinkUpDownTrapEnable.1141129729 = disabled
- ifLinkUpDownTrapEnable.1141129730 = disabled
- ifLinkUpDownTrapEnable.1141129731 = disabled
- ifLinkUpDownTrapEnable.1141129732 = disabled
- ifLinkUpDownTrapEnable.1142698753 = disabled
- ifLinkUpDownTrapEnable.1142698754 = disabled
- ifLinkUpDownTrapEnable.1142698755 = disabled
- ifHighSpeed.1141129729 = 2
- ifHighSpeed.1141129730 = 2
- ifHighSpeed.1141129731 = 2
- ifHighSpeed.1141129732 = 2
- ifHighSpeed.1142698753 = 1000
- ifHighSpeed.1142698754 = 100
- ifHighSpeed.1142698755 = 100
- ifPromiscuousMode.1141129729 = false
- ifPromiscuousMode.1141129730 = false
- ifPromiscuousMode.1141129731 = false
- ifPromiscuousMode.1141129732 = false
- ifPromiscuousMode.1142698753 = false
- ifPromiscuousMode.1142698754 = false
- ifPromiscuousMode.1142698755 = false
- ifConnectorPresent.1141129729 = true
- ifConnectorPresent.1141129730 = true
- ifConnectorPresent.1141129731 = true
- ifConnectorPresent.1141129732 = true
- ifConnectorPresent.1142698753 = true
- ifConnectorPresent.1142698754 = true
- ifConnectorPresent.1142698755 = true
- ifAlias.1141129729 = Interface Alias.
- ifAlias.1141129730 = Interface Alias.
- ifAlias.1141129731 = Interface Alias.
- ifAlias.1141129732 = Interface Alias.
- ifAlias.1142698753 = GigabitEthernet Port 0/1
- ifAlias.1142698754 = GigabitEthernet Port 0/2
- ifAlias.1142698755 = GigabitEthernet Port 0/3
- ifCounterDiscontinuityTime.1141129729 = 0:0:00:00.00
- ifCounterDiscontinuityTime.1141129730 = 0:0:00:00.00
- ifCounterDiscontinuityTime.1141129731 = 0:0:00:00.00
- ifCounterDiscontinuityTime.1141129732 = 0:0:00:00.00
- ifCounterDiscontinuityTime.1142698753 = 0:0:00:00.00
- ifCounterDiscontinuityTime.1142698754 = 0:0:00:00.00
- ifCounterDiscontinuityTime.1142698755 = 0:0:00:00.00
- ifDescr SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 ifDescr[0m]
- ifDescr.1141129729 = Digital DS1 interface 1/1
- ifDescr.1141129730 = Digital DS1 interface 1/2
- ifDescr.1141129731 = Digital DS1 interface 1/3
- ifDescr.1141129732 = Digital DS1 interface 1/4
- ifDescr.1142698753 = GigabitEthernet interface 0/1
- ifDescr.1142698754 = GigabitEthernet interface 0/2
- ifDescr.1142698755 = GigabitEthernet interface 0/3
- ifAdminStatus SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 ifAdminStatus[0m]
- ifAdminStatus.1141129729 = up
- ifAdminStatus.1141129730 = up
- ifAdminStatus.1141129731 = up
- ifAdminStatus.1141129732 = up
- ifAdminStatus.1142698753 = up
- ifAdminStatus.1142698754 = up
- ifAdminStatus.1142698755 = up
- ifOperStatus SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 ifOperStatus[0m]
- ifOperStatus.1141129729 = up
- ifOperStatus.1141129730 = down
- ifOperStatus.1141129731 = up
- ifOperStatus.1141129732 = up
- ifOperStatus.1142698753 = up
- ifOperStatus.1142698754 = down
- ifOperStatus.1142698755 = down
- ifLastChange SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 ifLastChange[0m]
- ifLastChange.1141129729 = 0
- ifLastChange.1141129730 = 0
- ifLastChange.1141129731 = 0
- ifLastChange.1141129732 = 0
- ifLastChange.1142698753 = 0
- ifLastChange.1142698754 = 0
- ifLastChange.1142698755 = 0
- ifType SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 ifType[0m]
- ifType.1141129729 = ds1
- ifType.1141129730 = ds1
- ifType.1141129731 = ds1
- ifType.1141129732 = ds1
- ifType.1142698753 = ethernetCsmacd
- ifType.1142698754 = ethernetCsmacd
- ifType.1142698755 = ethernetCsmacd
- ifPhysAddress SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 ifPhysAddress[0m]
- ifPhysAddress.1141129729 =
- ifPhysAddress.1141129730 =
- ifPhysAddress.1141129731 =
- ifPhysAddress.1141129732 =
- ifPhysAddress.1142698753 = 0:90:8f:a7:90:fb
- ifPhysAddress.1142698754 = 0:90:8f:a7:90:fb
- ifPhysAddress.1142698755 = 0:90:8f:a7:90:fb
- ifMtu SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 ifMtu[0m]
- ifMtu.1141129729 = 0
- ifMtu.1141129730 = 0
- ifMtu.1141129731 = 0
- ifMtu.1141129732 = 0
- ifMtu.1142698753 = 1500
- ifMtu.1142698754 = 1500
- ifMtu.1142698755 = 1500
- ifInErrors SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 ifInErrors[0m]
- ifInErrors.1141129729 = 0
- ifInErrors.1141129730 = 0
- ifInErrors.1141129731 = 0
- ifInErrors.1141129732 = 0
- ifInErrors.1142698753 = 0
- ifInErrors.1142698754 = 0
- ifInErrors.1142698755 = 0
- ifOutErrors SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 ifOutErrors[0m]
- ifOutErrors.1141129729 = 0
- ifOutErrors.1141129730 = 0
- ifOutErrors.1141129731 = 0
- ifOutErrors.1141129732 = 0
- ifOutErrors.1142698753 = 0
- ifOutErrors.1142698754 = 0
- ifOutErrors.1142698755 = 0
- ifInDiscards SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 ifInDiscards[0m]
- ifInDiscards.1141129729 = 0
- ifInDiscards.1141129730 = 0
- ifInDiscards.1141129731 = 0
- ifInDiscards.1141129732 = 0
- ifInDiscards.1142698753 = 42183
- ifInDiscards.1142698754 = 0
- ifInDiscards.1142698755 = 0
- ifOutDiscards SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUst -m IF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 ifOutDiscards[0m]
- ifOutDiscards.1141129729 = 0
- ifOutDiscards.1141129730 = 0
- ifOutDiscards.1141129731 = 0
- ifOutDiscards.1141129732 = 0
- ifOutDiscards.1142698753 = 0
- ifOutDiscards.1142698754 = 0
- ifOutDiscards.1142698755 = 0
- dot3StatsDuplexStatusSNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m EtherLike-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 dot3StatsDuplexStatus[0m]
- dot3StatsDuplexStatus = No Such Object available on this agent at this OID
- SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m Q-BRIDGE-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 dot1qPvid[0m]
- dot1qPvid = No Such Object available on this agent at this OID
- SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl') [0;33m[236][0m 0.89ms]
- Array
- (
- [1141129729] => Array
- (
- [ifName] => DS1 Port 1/1
- [ifInMulticastPkts] => 0
- [ifInBroadcastPkts] => 0
- [ifOutMulticastPkts] => 0
- [ifOutBroadcastPkts] => 0
- [ifHCInOctets] => 0
- [ifHCInUcastPkts] => 0
- [ifHCInMulticastPkts] => 0
- [ifHCInBroadcastPkts] => 0
- [ifHCOutOctets] => 0
- [ifHCOutUcastPkts] => 0
- [ifHCOutMulticastPkts] => 0
- [ifHCOutBroadcastPkts] => 0
- [ifLinkUpDownTrapEnable] => disabled
- [ifHighSpeed] => 2
- [ifPromiscuousMode] => false
- [ifConnectorPresent] => true
- [ifAlias] => Interface Alias.
- [ifCounterDiscontinuityTime] => 0:0:00:00.00
- [ifDescr] => Digital DS1 interface 1/1
- [ifAdminStatus] => up
- [ifOperStatus] => up
- [ifLastChange] => 0
- [ifType] => ds1
- [ifPhysAddress] =>
- [ifMtu] => 0
- [ifInErrors] => 0
- [ifOutErrors] => 0
- [ifInDiscards] => 0
- [ifOutDiscards] => 0
- )
- [1141129730] => Array
- (
- [ifName] => DS1 Port 1/2
- [ifInMulticastPkts] => 0
- [ifInBroadcastPkts] => 0
- [ifOutMulticastPkts] => 0
- [ifOutBroadcastPkts] => 0
- [ifHCInOctets] => 0
- [ifHCInUcastPkts] => 0
- [ifHCInMulticastPkts] => 0
- [ifHCInBroadcastPkts] => 0
- [ifHCOutOctets] => 0
- [ifHCOutUcastPkts] => 0
- [ifHCOutMulticastPkts] => 0
- [ifHCOutBroadcastPkts] => 0
- [ifLinkUpDownTrapEnable] => disabled
- [ifHighSpeed] => 2
- [ifPromiscuousMode] => false
- [ifConnectorPresent] => true
- [ifAlias] => Interface Alias.
- [ifCounterDiscontinuityTime] => 0:0:00:00.00
- [ifDescr] => Digital DS1 interface 1/2
- [ifAdminStatus] => up
- [ifOperStatus] => down
- [ifLastChange] => 0
- [ifType] => ds1
- [ifPhysAddress] =>
- [ifMtu] => 0
- [ifInErrors] => 0
- [ifOutErrors] => 0
- [ifInDiscards] => 0
- [ifOutDiscards] => 0
- )
- [1141129731] => Array
- (
- [ifName] => DS1 Port 1/3
- [ifInMulticastPkts] => 0
- [ifInBroadcastPkts] => 0
- [ifOutMulticastPkts] => 0
- [ifOutBroadcastPkts] => 0
- [ifHCInOctets] => 0
- [ifHCInUcastPkts] => 0
- [ifHCInMulticastPkts] => 0
- [ifHCInBroadcastPkts] => 0
- [ifHCOutOctets] => 0
- [ifHCOutUcastPkts] => 0
- [ifHCOutMulticastPkts] => 0
- [ifHCOutBroadcastPkts] => 0
- [ifLinkUpDownTrapEnable] => disabled
- [ifHighSpeed] => 2
- [ifPromiscuousMode] => false
- [ifConnectorPresent] => true
- [ifAlias] => Interface Alias.
- [ifCounterDiscontinuityTime] => 0:0:00:00.00
- [ifDescr] => Digital DS1 interface 1/3
- [ifAdminStatus] => up
- [ifOperStatus] => up
- [ifLastChange] => 0
- [ifType] => ds1
- [ifPhysAddress] =>
- [ifMtu] => 0
- [ifInErrors] => 0
- [ifOutErrors] => 0
- [ifInDiscards] => 0
- [ifOutDiscards] => 0
- )
- [1141129732] => Array
- (
- [ifName] => DS1 Port 1/4
- [ifInMulticastPkts] => 0
- [ifInBroadcastPkts] => 0
- [ifOutMulticastPkts] => 0
- [ifOutBroadcastPkts] => 0
- [ifHCInOctets] => 0
- [ifHCInUcastPkts] => 0
- [ifHCInMulticastPkts] => 0
- [ifHCInBroadcastPkts] => 0
- [ifHCOutOctets] => 0
- [ifHCOutUcastPkts] => 0
- [ifHCOutMulticastPkts] => 0
- [ifHCOutBroadcastPkts] => 0
- [ifLinkUpDownTrapEnable] => disabled
- [ifHighSpeed] => 2
- [ifPromiscuousMode] => false
- [ifConnectorPresent] => true
- [ifAlias] => Interface Alias.
- [ifCounterDiscontinuityTime] => 0:0:00:00.00
- [ifDescr] => Digital DS1 interface 1/4
- [ifAdminStatus] => up
- [ifOperStatus] => up
- [ifLastChange] => 0
- [ifType] => ds1
- [ifPhysAddress] =>
- [ifMtu] => 0
- [ifInErrors] => 0
- [ifOutErrors] => 0
- [ifInDiscards] => 0
- [ifOutDiscards] => 0
- )
- [1142698753] => Array
- (
- [ifName] => GigabitEthernet Port 0/1
- [ifInMulticastPkts] => 241559
- [ifInBroadcastPkts] => 480996
- [ifOutMulticastPkts] => 0
- [ifOutBroadcastPkts] => 244
- [ifHCInOctets] => 32192198654
- [ifHCInUcastPkts] => 143988014
- [ifHCInMulticastPkts] => 241559
- [ifHCInBroadcastPkts] => 480996
- [ifHCOutOctets] => 34475520321
- [ifHCOutUcastPkts] => 156554886
- [ifHCOutMulticastPkts] => 0
- [ifHCOutBroadcastPkts] => 244
- [ifLinkUpDownTrapEnable] => disabled
- [ifHighSpeed] => 1000
- [ifPromiscuousMode] => false
- [ifConnectorPresent] => true
- [ifAlias] => GigabitEthernet Port 0/1
- [ifCounterDiscontinuityTime] => 0:0:00:00.00
- [ifDescr] => GigabitEthernet interface 0/1
- [ifAdminStatus] => up
- [ifOperStatus] => up
- [ifLastChange] => 0
- [ifType] => ethernetCsmacd
- [ifPhysAddress] => 0:90:8f:a7:90:fb
- [ifMtu] => 1500
- [ifInErrors] => 0
- [ifOutErrors] => 0
- [ifInDiscards] => 42183
- [ifOutDiscards] => 0
- )
- [1142698754] => Array
- (
- [ifName] => GigabitEthernet Port 0/2
- [ifInMulticastPkts] => 0
- [ifInBroadcastPkts] => 0
- [ifOutMulticastPkts] => 0
- [ifOutBroadcastPkts] => 0
- [ifHCInOctets] => 0
- [ifHCInUcastPkts] => 0
- [ifHCInMulticastPkts] => 0
- [ifHCInBroadcastPkts] => 0
- [ifHCOutOctets] => 0
- [ifHCOutUcastPkts] => 0
- [ifHCOutMulticastPkts] => 0
- [ifHCOutBroadcastPkts] => 0
- [ifLinkUpDownTrapEnable] => disabled
- [ifHighSpeed] => 100
- [ifPromiscuousMode] => false
- [ifConnectorPresent] => true
- [ifAlias] => GigabitEthernet Port 0/2
- [ifCounterDiscontinuityTime] => 0:0:00:00.00
- [ifDescr] => GigabitEthernet interface 0/2
- [ifAdminStatus] => up
- [ifOperStatus] => down
- [ifLastChange] => 0
- [ifType] => ethernetCsmacd
- [ifPhysAddress] => 0:90:8f:a7:90:fb
- [ifMtu] => 1500
- [ifInErrors] => 0
- [ifOutErrors] => 0
- [ifInDiscards] => 0
- [ifOutDiscards] => 0
- )
- [1142698755] => Array
- (
- [ifName] => GigabitEthernet Port 0/3
- [ifInMulticastPkts] => 0
- [ifInBroadcastPkts] => 0
- [ifOutMulticastPkts] => 0
- [ifOutBroadcastPkts] => 0
- [ifHCInOctets] => 0
- [ifHCInUcastPkts] => 0
- [ifHCInMulticastPkts] => 0
- [ifHCInBroadcastPkts] => 0
- [ifHCOutOctets] => 0
- [ifHCOutUcastPkts] => 0
- [ifHCOutMulticastPkts] => 0
- [ifHCOutBroadcastPkts] => 0
- [ifLinkUpDownTrapEnable] => disabled
- [ifHighSpeed] => 100
- [ifPromiscuousMode] => false
- [ifConnectorPresent] => true
- [ifAlias] => GigabitEthernet Port 0/3
- [ifCounterDiscontinuityTime] => 0:0:00:00.00
- [ifDescr] => GigabitEthernet interface 0/3
- [ifAdminStatus] => up
- [ifOperStatus] => down
- [ifLastChange] => 0
- [ifType] => ethernetCsmacd
- [ifPhysAddress] => 0:90:8f:a7:90:fb
- [ifMtu] => 1500
- [ifInErrors] => 0
- [ifOutErrors] => 0
- [ifInDiscards] => 0
- [ifOutDiscards] => 0
- )
- )
- ignored by ifType: ds1 (matched: ds1 )
- SQL[[1;33mUPDATE `ports` set `deleted`=? WHERE `port_id` = ? [0;33m["1",null][0m 0.3ms]
- ignored by ifType: ds1 (matched: ds1 )
- ignored by ifType: ds1 (matched: ds1 )
- ignored by ifType: ds1 (matched: ds1 )
- valid valid valid
- Port GigabitEthernet Port 0/1: GigabitEthernet interface 0/1 (1142698753 / #13971) ifHCInOctets ifHCOutOctets ifHCInUcastPkts ifHCOutUcastPkts ifHCInBroadcastPkts ifHCOutBroadcastPkts ifHCInMulticastPkts ifOutMulticastPkts ifHighSpeed VLAN = GigabitEthernet Port 0/1
- ifInOctets (21711034 B) 223825.09278351 Bps 97 secs
- ifOutOctets (25435332 B) 262219.91752577 Bps 97 secs
- ifInErrors (0 B) 0 Bps 97 secs
- ifOutErrors (0 B) 0 Bps 97 secs
- ifInUcastPkts (91992 B) 948.37113402062 Bps 97 secs
- ifOutUcastPkts (116354 B) 1199.5257731959 Bps 97 secs
- ifInNUcastPkts (0 B) 0 Bps 97 secs
- ifOutNUcastPkts (0 B) 0 Bps 97 secs
- ifInDiscards (9 B) 0.092783505154639 Bps 97 secs
- ifOutDiscards (0 B) 0 Bps 97 secs
- ifInUnknownProtos (0 B) 0 Bps 97 secs
- ifInBroadcastPkts (118 B) 1.2164948453608 Bps 97 secs
- ifOutBroadcastPkts (0 B) 0 Bps 97 secs
- ifInMulticastPkts (61 B) 0.62886597938144 Bps 97 secs
- ifOutMulticastPkts (0 B) 0 Bps 97 secs
- bps(1.790Mbps/2.100Mbps)bytes(20.710MB/24.260MB)pkts(948.370pps/1.200kpps)RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/port-id13971.rrd N:32192198654:34475520321:0:0:143988014:156554886:U:U:42183:0:U:480996:244:241559:0[0m]
- [[0;31mRRD Disabled[0m]SQL[[1;33mUPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`ifLastChange`=?,`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`=? WHERE `port_id` = ? [0;33m[1539007440,1539007343,97,"0","32192198654",32170487620,223825.09278350516,21711034,"34475520321",34450084989,262219.91752577317,25435332,"0",0,0,0,"0",0,0,0,"143988014",143896022,948.37113402061857,91992,"156554886",156438532,1199.5257731958764,116354,13971][0m 0.99ms]
- 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,"42183",42174,0.092783505154639179,9,"0",0,0,0,0,0,0,0,"480996",480878,1.2164948453608246,118,"244",244,0,0,"241559",241498,0.62886597938144329,61,"0",0,0,0,13971][0m 0.79ms]
- 2 updated
- Port GigabitEthernet Port 0/2: GigabitEthernet interface 0/2 (1142698754 / #13972) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifHighSpeed VLAN = GigabitEthernet Port 0/2
- ifInOctets (0 B) 0 Bps 97 secs
- ifOutOctets (0 B) 0 Bps 97 secs
- ifInErrors (0 B) 0 Bps 97 secs
- ifOutErrors (0 B) 0 Bps 97 secs
- ifInUcastPkts (0 B) 0 Bps 97 secs
- ifOutUcastPkts (0 B) 0 Bps 97 secs
- ifInNUcastPkts (0 B) 0 Bps 97 secs
- ifOutNUcastPkts (0 B) 0 Bps 97 secs
- ifInDiscards (0 B) 0 Bps 97 secs
- ifOutDiscards (0 B) 0 Bps 97 secs
- ifInUnknownProtos (0 B) 0 Bps 97 secs
- ifInBroadcastPkts (0 B) 0 Bps 97 secs
- ifOutBroadcastPkts (0 B) 0 Bps 97 secs
- ifInMulticastPkts (0 B) 0 Bps 97 secs
- ifOutMulticastPkts (0 B) 0 Bps 97 secs
- bps(0.000bps/0.000bps)bytes(0.000B/0.000B)pkts(0.000pps/0.000pps)RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/port-id13972.rrd N:U:U:0:0:U:U:U:U:0:0:U:0:0:0:0[0m]
- [[0;31mRRD Disabled[0m]SQL[[1;33mUPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`ifLastChange`=?,`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`=? WHERE `port_id` = ? [0;33m[1539007440,1539007343,97,"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,13972][0m 0.9ms]
- 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,13972][0m 0.73ms]
- 1 updated
- Port GigabitEthernet Port 0/3: GigabitEthernet interface 0/3 (1142698755 / #13973) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifHighSpeed VLAN = GigabitEthernet Port 0/3
- ifInOctets (0 B) 0 Bps 97 secs
- ifOutOctets (0 B) 0 Bps 97 secs
- ifInErrors (0 B) 0 Bps 97 secs
- ifOutErrors (0 B) 0 Bps 97 secs
- ifInUcastPkts (0 B) 0 Bps 97 secs
- ifOutUcastPkts (0 B) 0 Bps 97 secs
- ifInNUcastPkts (0 B) 0 Bps 97 secs
- ifOutNUcastPkts (0 B) 0 Bps 97 secs
- ifInDiscards (0 B) 0 Bps 97 secs
- ifOutDiscards (0 B) 0 Bps 97 secs
- ifInUnknownProtos (0 B) 0 Bps 97 secs
- ifInBroadcastPkts (0 B) 0 Bps 97 secs
- ifOutBroadcastPkts (0 B) 0 Bps 97 secs
- ifInMulticastPkts (0 B) 0 Bps 97 secs
- ifOutMulticastPkts (0 B) 0 Bps 97 secs
- bps(0.000bps/0.000bps)bytes(0.000B/0.000B)pkts(0.000pps/0.000pps)RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/port-id13973.rrd N:U:U:0:0:U:U:U:U:0:0:U:0:0:0:0[0m]
- [[0;31mRRD Disabled[0m]SQL[[1;33mUPDATE `ports` set `poll_time`=?,`poll_prev`=?,`poll_period`=?,`ifLastChange`=?,`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`=? WHERE `port_id` = ? [0;33m[1539007440,1539007343,97,"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,13973][0m 0.7ms]
- 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,13973][0m 0.63ms]
- 1 updated
- >> Runtime for poller module 'ports': 0.5076 seconds with 43856 bytes
- >> SNMP: [14/0.49s] MySQL: [8/0.01s] RRD: [0/0.00s]
- #### Unload poller module ports ####
- RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/poller-perf-ports.rrd N:0.50758099555969[0m]
- [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device
- #### Load poller module bgp-peers ####
- SQL[[1;33mSELECT * FROM bgpPeers WHERE device_id = ? [0;33m[236][0m 0.35ms]
- >> Runtime for poller module 'bgp-peers': 0.0014 seconds with 10304 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module bgp-peers ####
- RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/poller-perf-bgp-peers.rrd N:0.0013630390167236[0m]
- [[0;31mRRD Disabled[0m]Modules status: Global- OS Device Module [ junose-atm-vp ] disabled globally.
- Modules status: Global- OS Device Module [ toner ] disabled globally.
- Modules status: Global+ OS Device
- #### Load poller module ucd-diskio ####
- SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id` = ? [0;33m[236][0m 0.21ms]
- >> Runtime for poller module 'ucd-diskio': 0.0004 seconds with 1824 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module ucd-diskio ####
- RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/poller-perf-ucd-diskio.rrd N:0.0003969669342041[0m]
- [[0;31mRRD Disabled[0m]Modules status: Global- OS Device Module [ wifi ] disabled globally.
- Modules status: Global+ OS Device
- #### Load poller module wireless ####
- Attempting to initialize OS: audiocodes
- Attempting to initialize OS: audiocodes
- OS initilized as Generic
- SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[236][0m 0.31ms]
- >> Runtime for poller module 'wireless': 0.0016 seconds with 101256 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module wireless ####
- RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/poller-perf-wireless.rrd N:0.0016369819641113[0m]
- [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device
- #### Load poller module ospf ####
- SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[236][0m 0.47ms]
- Processes: SNMP[[0;36m/usr/bin/snmpbulkwalk -v2c -c COMMUNITY -OQUs -m OSPF-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 OSPF-MIB::ospfGeneralGroup[0m]
- ospfGeneralGroup = No Such Object available on this agent at this OID
- Array
- (
- )
- SQL[[1;33mdelete from `ospf_instances` where (`device_id` = ? and `context_name` is null) and 1 = 1 [0;33m[236][0m 0.4ms]
- 0
- >> Runtime for poller module 'ospf': 0.0265 seconds with 133392 bytes
- >> SNMP: [1/0.02s] MySQL: [0/0.00s] RRD: [0/0.00s]
- #### Unload poller module ospf ####
- RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/poller-perf-ospf.rrd N:0.026541948318481[0m]
- [[0;31mRRD Disabled[0m]Modules status: Global- OS Device Module [ cisco-ipsec-flow-monitor ] disabled globally.
- Modules status: Global- OS Device Module [ cisco-remote-access-monitor ] disabled globally.
- Modules status: Global- OS Device Module [ cisco-cef ] disabled globally.
- Modules status: Global- OS Device Module [ cisco-sla ] disabled globally.
- Modules status: Global- OS Device Module [ cisco-mac-accounting ] disabled globally.
- Modules status: Global- OS Device Module [ cipsec-tunnels ] disabled globally.
- Modules status: Global- OS Device Module [ cisco-ace-loadbalancer ] disabled globally.
- Modules status: Global- OS Device Module [ cisco-ace-serverfarms ] disabled globally.
- Modules status: Global- OS Device Module [ cisco-asa-firewall ] disabled globally.
- Modules status: Global- OS Device Module [ cisco-voice ] disabled globally.
- Modules status: Global- OS Device Module [ cisco-cbqos ] disabled globally.
- Modules status: Global- OS Device Module [ cisco-otv ] disabled globally.
- Modules status: Global- OS Device Module [ cisco-vpdn ] disabled globally.
- Modules status: Global- OS Device Module [ netscaler-vsvr ] disabled globally.
- Modules status: Global- OS Device Module [ aruba-controller ] disabled globally.
- Modules status: Global+ OS Device
- #### Load poller module entity-physical ####
- SQL[[1;33mSELECT * FROM `entPhysical_state` WHERE `device_id` = ? [0;33m[236][0m 0.33ms]
- >> Runtime for poller module 'entity-physical': 0.0007 seconds with 1960 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module entity-physical ####
- RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/poller-perf-entity-physical.rrd N:0.00073099136352539[0m]
- [[0;31mRRD Disabled[0m]Modules status: Global- OS Device Module [ entity-state ] disabled globally.
- Modules status: Global+ OS Device
- #### Load poller module applications ####
- SQL[[1;33mSELECT * FROM `applications` WHERE `device_id` = ? [0;33m[236][0m 0.25ms]
- >> Runtime for poller module 'applications': 0.0004 seconds with 1512 bytes
- >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module applications ####
- RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/poller-perf-applications.rrd N:0.00041508674621582[0m]
- [[0;31mRRD Disabled[0m]Modules status: Global- OS Device Module [ mib ] disabled globally.
- Modules status: Global+ OS Device
- #### Load poller module stp ####
- SQL[[1;33mSELECT * FROM `stp` WHERE `device_id` = ? [0;33m[236][0m 0.26ms]
- SNMP[[0;36m/usr/bin/snmpget -v2c -c COMMUNITY -Oqv -m RSTP-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/audiocodes udp:HOSTNAME:161 dot1dStpProtocolSpecification.0[0m]
- No Such Object available on this agent at this OID
- >> Runtime for poller module 'stp': 0.0173 seconds with 5296 bytes
- >> SNMP: [1/0.02s] MySQL: [1/0.00s] RRD: [0/0.00s]
- #### Unload poller module stp ####
- RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/poller-perf-stp.rrd N:0.017297029495239[0m]
- [[0;31mRRD Disabled[0m]Modules status: Global+ OS Device
- #### Load poller module ntp ####
- >> Runtime for poller module 'ntp': 0.0002 seconds with 320 bytes
- >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s]
- #### Unload poller module ntp ####
- RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/poller-perf-ntp.rrd N:0.00016403198242188[0m]
- [[0;31mRRD Disabled[0m]Modules status: Global- OS Device Module [ loadbalancers ] disabled globally.
- Modules status: Global- OS Device Module [ mef ] disabled globally.
- ### Start Device Groups ###
- SQL[[1;33mSELECT * FROM device_groups ORDER BY name [0;33m[][0m 0.51ms]
- SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.sysName REGEXP "fmpavh" ) LIMIT 1 [0;33m[236][0m 0.24ms]
- SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.type = "Printer" && devices.location REGEXP "AR" ) LIMIT 1 [0;33m[236][0m 0.19ms]
- SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.type = "Network" || devices.type = "Firewall" ) LIMIT 1 [0;33m[236][0m 0.15ms]
- SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.type = "Printer" && devices.location REGEXP "BR" ) LIMIT 1 [0;33m[236][0m 0.19ms]
- SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.sysName REGEXP "vmpaeb" ) LIMIT 1 [0;33m[236][0m 0.15ms]
- SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.sysName REGEXP "vmp" ) LIMIT 1 [0;33m[236][0m 0.19ms]
- SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.sysName REGEXP "sb" ) LIMIT 1 [0;33m[236][0m 0.15ms]
- SQL[[1;33mSELECT DISTINCT(devices.device_id) FROM devices WHERE devices.device_id=? AND (devices.os REGEXP "Ubiquiti" ) LIMIT 1 [0;33m[236][0m 0.15ms]
- SQL[[1;33mSELECT `device_group_id` FROM `device_group_device` WHERE `device_id`=? [0;33m[236][0m 0.2ms]
- Groups Added: 1
- Groups Removed:
- SQL[[1;33minsert into `device_group_device` (`device_group_id`, `device_id`) values (?, ?) [0;33m[1,236][0m 9.94ms]
- ### End Device Groups ###
- Enabling graphs: SQL[[1;33mSELECT `graph` FROM `device_graphs` WHERE `device_id` = ? [0;33m[236][0m 0.43ms]
- uptime netstat_icmp netstat_icmp_info netstat_ip netstat_ip_frag netstat_snmp netstat_snmp_pkt netstat_tcp netstat_udp hr_processes hr_users
- RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/ping-perf.rrd N:0.35[0m]
- [[0;31mRRD Disabled[0m]RRD[[0;32mupdate /opt/librenms/rrd/10.1.6.150/poller-perf.rrd N:1.931[0m]
- [[0;31mRRD Disabled[0m]SQL[[1;33mUPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=?,`last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[378690,"0.35",1.931,236][0m 0.65ms]
- Updating 10.1.6.150
- Polled in 1.931 seconds
- #### Start Alerts ####
- SQL[[1;33mSELECT `device_group_id` FROM `device_group_device` WHERE `device_id`=? [0;33m[236][0m 0.17ms]
- SQL[[1;33mSELECT alert_schedule.schedule_id FROM alert_schedule LEFT JOIN alert_schedule_items ON alert_schedule.schedule_id=alert_schedule_items.schedule_id WHERE ( alert_schedule_items.target = ? || alert_schedule_items.target = ? ) && ((alert_schedule.recurring = 0 AND (NOW() BETWEEN alert_schedule.start AND alert_schedule.end)) OR (alert_schedule.recurring = 1 AND (alert_schedule.start_recurring_dt <= date_format(NOW(), '[1;33m-[0;35m-%d') AND (end_recurring_dt >= date_format(NOW(), '[1;33m-[0;35m-%d') OR end_recurring_dt is NULL OR end_recurring_dt = '0000-00-00' OR end_recurring_dt = '')) AND (date_format(now(), '%H:%i:%s') BETWEEN `start_recurring_hr` AND end_recurring_hr) AND (recurring_day LIKE CONCAT('%',date_format(now(), '[0;37m'),'%') OR recurring_day is null or recurring_day = ''))) LIMIT 1 [0;33m[236,"g1"][0m 0.34ms]
- SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a
- LEFT JOIN alert_device_map d ON a.id=d.rule_id
- LEFT JOIN alert_group_map g ON a.id=g.rule_id
- LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id
- WHERE a.disabled = 0 AND ((d.device_id IS NULL AND g.group_id IS NULL) OR d.device_id=? OR dg.device_id=?) [0;33m[236,236][0m 0.67ms]
- Rule [0;35m#1 (Devices up/down Network Criticos):[0m
- SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[236][0m 0.25ms]
- SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[1,236][0m 0.16ms]
- SQL[[1;33mINSERT IGNORE INTO `alert_log` (`state`,`device_id`,`rule_id`) VALUES (:state,:device_id,:rule_id) [0;33m{"state":0,"device_id":236,"rule_id":1}[0m 0.6ms]
- SQL[[1;33mINSERT IGNORE INTO `alerts` (`state`,`device_id`,`rule_id`,`open`,`alerted`) VALUES (:state,:device_id,:rule_id,:open,:alerted) [0;33m{"state":0,"device_id":236,"rule_id":1,"open":1,"alerted":0}[0m 0.56ms]
- Status: [0;32mOK[0m
- Rule [0;35m#13 (Device rebooted):[0m
- SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND devices.uptime < 300 AND (devices.disabled = 0 && devices.ignore = 0) = 1 AND devices.type != "Printer" [0;33m[236][0m 0.35ms]
- SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[13,236][0m 0.21ms]
- Status: [0;34mNOCHG[0m
- #### End Alerts ####
- SQL[[1;33mINSERT IGNORE INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES (:type,:doing,:start,:duration,:devices,:poller) [0;33m{"type":"poll","doing":"10.1.6.150","start":1539007438.137893,"duration":"2.053","devices":1,"poller":"librenms.ua.com.ar"}[0m 0.52ms]
- ./poller.php 10.1.6.150 2018-10-08 11:04:00 - 1 devices polled in 2.053 secs
- SNMP [32/0.86s]: Get[12/0.22s] Getnext[0/0.00s] Walk[20/0.64s]
- MySQL [35/0.03s]: Cell[13/0.00s] Row[-12/-0.00s] Rows[16/0.01s] Column[2/0.00s] Update[11/0.01s] Insert[5/0.01s] Delete[0/0.00s]
- RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]