LibreNMS Poller SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.58ms] SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 0.48ms] SQL[[1;33mselect version() [0;33m[][0m 0.52ms] =================================== Version info: Commit SHA: 2d57e49cafffd2982c393ef0ffefab763b387b8c Commit Date: 1641662228 DB Schema: 2021_11_29_165436_improve_ports_search_index (229) PHP: 7.3.31-1~deb10u1 MySQL: 10.3.31-MariaDB-0+deb10u1 RRDTool: 1.7.1 SNMP: 5.7.3 ==================================DEBUG! Updating os_def.cache Starting polling run: SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '192.168.1.1' ORDER BY `device_id` ASC [0;33m[][0m 1.75ms] SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[2][0m 1.43ms] SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[2][0m 0.56ms] Attempting to initialize OS: edgeos OS initialized: LibreNMS\OS\Edgeos Hostname: 192.168.1.1 Device ID: 2 OS: edgeos [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '-O' '0' '192.168.1.1' response: xmt/rcv/%loss = 3/3/0%, min/avg/max = 0.14/0.16/0.18 SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m] SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::enterprises.41112.1.5 SQL[[1;33minsert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `device_id`, `timestamp`) values (?, ?, ?, ?, ?, ?, ?, ?) [0;33m[0.14,0.18,0.16,3,3,0,2,"2022-01-09 12:22:30"][0m 9.21ms] SQL[[1;33mupdate `devices` set `last_ping_timetaken` = ? where `device_id` = ? [0;33m[0.16,2][0m 5.58ms] SQL[[1;33mselect * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` is null order by `going_down` desc limit 1 [0;33m[2][0m 0.9ms] Modules status: Global+ OS Device #### Load poller module core #### SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-On' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysDescr.0' 'SNMPv2-MIB::sysObjectID.0' 'SNMPv2-MIB::sysUpTime.0' 'SNMPv2-MIB::sysName.0'[0m] .*.*.0 = EdgeOS v*49062.211020.0832 .*.*.0 = .*.4.1.41112.1.5 .*.*.0 = 4795245 .*.*.0 = ubnt SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0'[0m] SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = 47952 HOST-RESOURCES-MIB::hrSystemUptime.0 = 4803363 Uptime seconds: 48034 Uptime: 13 hours 20 minutes 34 seconds SQL[[1;33mupdate `devices` set `uptime` = ? where `device_id` = ? [0;33m[48034,2][0m 6.81ms] >> Runtime for poller module 'core': 0.1270 seconds with 53056 bytes >> [0;36mSNMP[0m: [2/0.11s] [1;33mMySQL[0m: [1/0.07s] #### Unload poller module core #### Modules status: Global- OS Device Module [ unix-agent ] disabled globally. Modules status: Global+ OS Device #### Load poller module os #### Generic :( SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[3][0m 0.61ms] Location: Unknown Hardware: UniFi-Gateway-4 OS Version: 4.4.56 OS Features: Serial: >> Runtime for poller module 'os': 0.0092 seconds with 88696 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] #### Unload poller module os #### Modules status: Global+ OS Device #### Load poller module availability #### SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[2][0m 0.5ms] Availability: SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[2][0m 0.44ms] SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[2,1641640950][0m 1.31ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,13][0m 0.78ms] 1 day : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[2,1641122550][0m 1.23ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,16][0m 0.78ms] 7 days : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[2,1639135350][0m 1.27ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[99.966,18][0m 0.8ms] 30 days : 99.966% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[2,1610191350][0m 1.35ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[-137.952,20][0m 0.82ms] 365 days : -137.952% >> Runtime for poller module 'availability': 0.0202 seconds with 10608 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [10/0.09s] #### Unload poller module availability #### Modules status: Global+ OS Device #### Load poller module ipmi #### SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[2][0m 1.29ms] array ( ) >> Runtime for poller module 'ipmi': 0.0027 seconds with 1224 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] #### Unload poller module ipmi #### 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[2][0m 1.1ms] >> Runtime for poller module 'sensors': 0.0020 seconds with 344 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] #### Unload poller module sensors #### Modules status: Global+ OS Device #### Load poller module processors #### Attempting to initialize OS: edgeos OS initialized: LibreNMS\OS\Edgeos SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[2][0m 1.14ms] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQn' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' '.1.3.6.1.2.1.25.3.3.1.2.196608' '.1.3.6.1.2.1.25.3.3.1.2.196609'[0m] .*.*.*608 = 2 .*.*.*609 = 1 array ( '.1.3.6.1.2.1.25.3.3.1.2.196608' => '2', '.1.3.6.1.2.1.25.3.3.1.2.196609' => '1', ) Processor: 2% SQL[[1;33mUPDATE `processors` set `processor_usage`=? WHERE `processor_id` = ? [0;33m[2,72][0m 6.05ms] Processor: 1% SQL[[1;33mUPDATE `processors` set `processor_usage`=? WHERE `processor_id` = ? [0;33m[1,73][0m 1.69ms] >> Runtime for poller module 'processors': 0.0464 seconds with 48928 bytes >> [0;36mSNMP[0m: [1/0.03s] [1;33mMySQL[0m: [3/0.09s] #### Unload poller module processors #### Modules status: Global+ OS Device #### Load poller module mempools #### SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[2][0m 1.38ms] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQn' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' '.1.3.6.1.2.1.25.2.3.1.6.1' '.1.3.6.1.2.1.25.2.3.1.6.3' '.1.3.6.1.2.1.25.2.3.1.6.6' '.1.3.6.1.2.1.25.2.3.1.6.7' '.1.3.6.1.2.1.25.2.3.1.6.8'[0m] .*.*.* = 277896 .*.*.* = 277896 .*.*.* = 28872 .*.*.* = 126732 .*.*.* = 19080 Free memory adjusted by availability calculation: 1.68 GiB -> 1.83 GiB hrstorage [system]: Physical memory: 69.43 MiB / 1.95 GiB SQL[[1;33mupdate `mempools` set `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[125227008,1964290048,65][0m 6.23ms] hrstorage [virtual]: Virtual memory: 14'1.38 MiB / 1.95 GiB SQL[[1;33mupdate `mempools` set `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[284565504,1804951552,66][0m 4.27ms] hrstorage [buffers]: Memory buffers: 1(.2 MiB / 1.95 GiB hrstorage [cached]: Cached memory: 63.76 MiB / 1.95 GiB SQL[[1;33mupdate `mempools` set `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[129773568,1959743488,68][0m 3.55ms] hrstorage [shared]: Shared memory: 1.63 MiB / 1.95 GiB SQL[[1;33mupdate `mempools` set `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[19537920,2069979136,69][0m 4.58ms] >> Runtime for poller module 'mempools': 0.0681 seconds with 91496 bytes >> [0;36mSNMP[0m: [1/0.03s] [1;33mMySQL[0m: [5/0.20s] #### Unload poller module mempools #### Modules status: Global+ OS Device #### Load poller module storage #### SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[2][0m 1.1ms] Storage /root.dev: hrstorage SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'hrStorageEntry'[0m] hrStorageIndex.1 = 1 hrStorageIndex.3 = 3 hrStorageIndex.6 = 6 hrStorageIndex.7 = 7 hrStorageIndex.8 = 8 hrStorageIndex.10 = 10 hrStorageIndex.32 = 32 hrStorageIndex.35 = 35 hrStorageIndex.36 = 36 hrStorageIndex.37 = 37 hrStorageIndex.39 = 39 hrStorageIndex.40 = 40 hrStorageIndex.42 = 42 hrStorageType.1 = hrStorageRam hrStorageType.3 = hrStorageVirtualMemory hrStorageType.6 = hrStorageOther hrStorageType.7 = hrStorageOther hrStorageType.8 = hrStorageOther hrStorageType.10 = hrStorageVirtualMemory hrStorageType.32 = hrStorageFixedDisk hrStorageType.35 = hrStorageFixedDisk hrStorageType.36 = hrStorageFixedDisk hrStorageType.37 = hrStorageFixedDisk hrStorageType.39 = hrStorageFixedDisk hrStorageType.40 = hrStorageFixedDisk hrStorageType.42 = hrStorageFixedDisk hrStorageDescr.1 = Physical memory hrStorageDescr.3 = Virtual memory hrStorageDescr.6 = Memory buffers hrStorageDescr.7 = Cached memory hrStorageDescr.8 = Shared memory hrStorageDescr.10 = Swap space hrStorageDescr.32 = /root.dev hrStorageDescr.35 = /run hrStorageDescr.36 = /var/log hrStorageDescr.37 = /dev/shm hrStorageDescr.39 = /tmp hrStorageDescr.40 = /opt/vyatta/config hrStorageDescr.42 = /root.dev/ugw hrStorageAllocationUnits.1 = 1024 hrStorageAllocationUnits.3 = 1024 hrStorageAllocationUnits.6 = 1024 hrStorageAllocationUnits.7 = 1024 hrStorageAllocationUnits.8 = 1024 hrStorageAllocationUnits.10 = 1024 hrStorageAllocationUnits.32 = 4096 hrStorageAllocationUnits.35 = 4096 hrStorageAllocationUnits.36 = 4096 hrStorageAllocationUnits.37 = 4096 hrStorageAllocationUnits.39 = 4096 hrStorageAllocationUnits.40 = 4096 hrStorageAllocationUnits.42 = 4096 hrStorageSize.1 = 2040544 hrStorageSize.3 = 2040544 hrStorageSize.6 = 2040544 hrStorageSize.7 = 126732 hrStorageSize.8 = 19080 hrStorageSize.10 = 0 hrStorageSize.32 = 420546 hrStorageSize.35 = 255068 hrStorageSize.36 = 255068 hrStorageSize.37 = 255068 hrStorageSize.39 = 255068 hrStorageSize.40 = 255068 hrStorageSize.42 = 456570 hrStorageUsed.1 = 277896 hrStorageUsed.3 = 277896 hrStorageUsed.6 = 28872 hrStorageUsed.7 = 126732 hrStorageUsed.8 = 19080 hrStorageUsed.10 = 0 hrStorageUsed.32 = 116785 hrStorageUsed.35 = 53 hrStorageUsed.36 = 4364 hrStorageUsed.37 = 0 hrStorageUsed.39 = 2 hrStorageUsed.40 = 352 hrStorageUsed.42 = 8885 array ( 'hrstorage' => array ( 1 => array ( 'hrStorageIndex' => '1', 'hrStorageType' => 'hrStorageRam', 'hrStorageDescr' => 'Physical memory', 'hrStorageAllocationUnits' => '1024', 'hrStorageSize' => '2040544', 'hrStorageUsed' => '277896', ), 3 => array ( 'hrStorageIndex' => '3', 'hrStorageType' => 'hrStorageVirtualMemory', 'hrStorageDescr' => 'Virtual memory', 'hrStorageAllocationUnits' => '1024', 'hrStorageSize' => '2040544', 'hrStorageUsed' => '277896', ), 6 => array ( 'hrStorageIndex' => '6', 'hrStorageType' => 'hrStorageOther', 'hrStorageDescr' => 'Memory buffers', 'hrStorageAllocationUnits' => '1024', 'hrStorageSize' => '2040544', 'hrStorageUsed' => '28872', ), 7 => array ( 'hrStorageIndex' => '7', 'hrStorageType' => 'hrStorageOther', 'hrStorageDescr' => 'Cached memory', 'hrStorageAllocationUnits' => '1024', 'hrStorageSize' => '126732', 'hrStorageUsed' => '126732', ), 8 => array ( 'hrStorageIndex' => '8', 'hrStorageType' => 'hrStorageOther', 'hrStorageDescr' => 'Shared memory', 'hrStorageAllocationUnits' => '1024', 'hrStorageSize' => '19080', 'hrStorageUsed' => '19080', ), 10 => array ( 'hrStorageIndex' => '10', 'hrStorageType' => 'hrStorageVirtualMemory', 'hrStorageDescr' => 'Swap space', 'hrStorageAllocationUnits' => '1024', 'hrStorageSize' => '0', 'hrStorageUsed' => '0', ), 32 => array ( 'hrStorageIndex' => '32', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/root.dev', 'hrStorageAllocationUnits' => '4096', 'hrStorageSize' => '420546', 'hrStorageUsed' => '116785', ), 35 => array ( 'hrStorageIndex' => '35', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/run', 'hrStorageAllocationUnits' => '4096', 'hrStorageSize' => '255068', 'hrStorageUsed' => '53', ), 36 => array ( 'hrStorageIndex' => '36', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/var/log', 'hrStorageAllocationUnits' => '4096', 'hrStorageSize' => '255068', 'hrStorageUsed' => '4364', ), 37 => array ( 'hrStorageIndex' => '37', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/dev/shm', 'hrStorageAllocationUnits' => '4096', 'hrStorageSize' => '255068', 'hrStorageUsed' => '0', ), 39 => array ( 'hrStorageIndex' => '39', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/tmp', 'hrStorageAllocationUnits' => '4096', 'hrStorageSize' => '255068', 'hrStorageUsed' => '2', ), 40 => array ( 'hrStorageIndex' => '40', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/opt/vyatta/config', 'hrStorageAllocationUnits' => '4096', 'hrStorageSize' => '255068', 'hrStorageUsed' => '352', ), 42 => array ( 'hrStorageIndex' => '42', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/root.dev/ugw', 'hrStorageAllocationUnits' => '4096', 'hrStorageSize' => '456570', 'hrStorageUsed' => '8885', ), ), ) array ( 'storage_id' => 172, 'device_id' => 2, 'storage_mib' => 'hrstorage', 'storage_index' => '32', 'storage_type' => 'hrStorageFixedDisk', 'storage_descr' => '/root.dev', 'storage_size' => 1722556416, 'storage_units' => 4096, 'storage_used' => 478351360, 'storage_free' => 1244205056, 'storage_perc' => 28, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '4096', 'used' => 478351360, 'size' => 1722556416, 'free' => 1244205056, ) 28% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["478351360","1244205056","1722556416",4096,28,172][0m 0.86ms] Storage /var/log: hrstorage array ( 'storage_id' => 173, 'device_id' => 2, 'storage_mib' => 'hrstorage', 'storage_index' => '36', 'storage_type' => 'hrStorageFixedDisk', 'storage_descr' => '/var/log', 'storage_size' => 1044758528, 'storage_units' => 4096, 'storage_used' => 17772544, 'storage_free' => 1026985984, 'storage_perc' => 2, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '4096', 'used' => 17874944, 'size' => 1044758528, 'free' => 1026883584, ) 2% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["17874944","1026883584","1044758528",4096,2,173][0m 5.94ms] Storage /dev/shm: hrstorage array ( 'storage_id' => 174, 'device_id' => 2, 'storage_mib' => 'hrstorage', 'storage_index' => '37', 'storage_type' => 'hrStorageFixedDisk', 'storage_descr' => '/dev/shm', 'storage_size' => 1044758528, 'storage_units' => 4096, 'storage_used' => 0, 'storage_free' => 1044758528, 'storage_perc' => 0, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '4096', 'used' => 0, 'size' => 1044758528, 'free' => 1044758528, ) 0% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["0","1044758528","1044758528",4096,0,174][0m 0.76ms] Storage /tmp: hrstorage array ( 'storage_id' => 175, 'device_id' => 2, 'storage_mib' => 'hrstorage', 'storage_index' => '39', 'storage_type' => 'hrStorageFixedDisk', 'storage_descr' => '/tmp', 'storage_size' => 1044758528, 'storage_units' => 4096, 'storage_used' => 8192, 'storage_free' => 1044750336, 'storage_perc' => 0, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '4096', 'used' => 8192, 'size' => 1044758528, 'free' => 1044750336, ) 0% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["8192","1044750336","1044758528",4096,0,175][0m 0.7ms] Storage /opt/vyatta/config: hrstorage array ( 'storage_id' => 176, 'device_id' => 2, 'storage_mib' => 'hrstorage', 'storage_index' => '40', 'storage_type' => 'hrStorageFixedDisk', 'storage_descr' => '/opt/vyatta/config', 'storage_size' => 1044758528, 'storage_units' => 4096, 'storage_used' => 1441792, 'storage_free' => 1043316736, 'storage_perc' => 0, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '4096', 'used' => 1441792, 'size' => 1044758528, 'free' => 1043316736, ) 0% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["1441792","1043316736","1044758528",4096,0,176][0m 0.69ms] Storage /root.dev/ugw: hrstorage array ( 'storage_id' => 177, 'device_id' => 2, 'storage_mib' => 'hrstorage', 'storage_index' => '42', 'storage_type' => 'hrStorageFixedDisk', 'storage_descr' => '/root.dev/ugw', 'storage_size' => 1870110720, 'storage_units' => 4096, 'storage_used' => 36392960, 'storage_free' => 1833717760, 'storage_perc' => 2, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '4096', 'used' => 36392960, 'size' => 1870110720, 'free' => 1833717760, ) 2% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["36392960","1833717760","1870110720",4096,2,177][0m 0.69ms] >> Runtime for poller module 'storage': 0.0677 seconds with 12072 bytes >> [0;36mSNMP[0m: [1/0.05s] [1;33mMySQL[0m: [7/0.11s] #### Unload poller module storage #### Modules status: Global+ OS Device #### Load poller module netstats #### icmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::icmpInMsgs.0' 'IP-MIB::icmpOutMsgs.0' 'IP-MIB::icmpInErrors.0' 'IP-MIB::icmpOutErrors.0' 'IP-MIB::icmpInEchos.0' 'IP-MIB::icmpOutEchos.0' 'IP-MIB::icmpInEchoReps.0' 'IP-MIB::icmpOutEchoReps.0' 'IP-MIB::icmpInDestUnreachs.0' 'IP-MIB::icmpOutDestUnreachs.0' 'IP-MIB::icmpInParmProbs.0' 'IP-MIB::icmpInTimeExcds.0' 'IP-MIB::icmpInSrcQuenchs.0' 'IP-MIB::icmpInRedirects.0' 'IP-MIB::icmpInTimestamps.0' 'IP-MIB::icmpInTimestampReps.0' 'IP-MIB::icmpInAddrMasks.0' 'IP-MIB::icmpInAddrMaskReps.0' 'IP-MIB::icmpOutTimeExcds.0' 'IP-MIB::icmpOutParmProbs.0' 'IP-MIB::icmpOutSrcQuenchs.0' 'IP-MIB::icmpOutRedirects.0' 'IP-MIB::icmpOutTimestamps.0' 'IP-MIB::icmpOutTimestampReps.0' 'IP-MIB::icmpOutAddrMasks.0' 'IP-MIB::icmpOutAddrMaskReps.0'[0m] IP-MIB::icmpInMsgs.0 = 9676 IP-MIB::icmpOutMsgs.0 = 0 IP-MIB::icmpInErrors.0 = 0 IP-MIB::icmpOutErrors.0 = 12249 IP-MIB::icmpInEchos.0 = 0 IP-MIB::icmpOutEchos.0 = 0 IP-MIB::icmpInEchoReps.0 = 7313 IP-MIB::icmpOutEchoReps.0 = 2319 IP-MIB::icmpInDestUnreachs.0 = 0 IP-MIB::icmpOutDestUnreachs.0 = 0 IP-MIB::icmpInParmProbs.0 = 0 IP-MIB::icmpInTimeExcds.0 = 44 IP-MIB::icmpInSrcQuenchs.0 = 0 IP-MIB::icmpInRedirects.0 = 0 IP-MIB::icmpInTimestamps.0 = 2319 IP-MIB::icmpInTimestampReps.0 = 0 IP-MIB::icmpInAddrMasks.0 = 0 IP-MIB::icmpInAddrMaskReps.0 = 0 IP-MIB::icmpOutTimeExcds.0 = 2613 IP-MIB::icmpOutParmProbs.0 = 4 IP-MIB::icmpOutSrcQuenchs.0 = 0 IP-MIB::icmpOutRedirects.0 = 0 IP-MIB::icmpOutTimestamps.0 = 7313 IP-MIB::icmpOutTimestampReps.0 = 0 IP-MIB::icmpOutAddrMasks.0 = 0 IP-MIB::icmpOutAddrMaskReps.0 = 0 ip SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::ipForwDatagrams.0' 'IP-MIB::ipInDelivers.0' 'IP-MIB::ipInReceives.0' 'IP-MIB::ipOutRequests.0' 'IP-MIB::ipInDiscards.0' 'IP-MIB::ipOutDiscards.0' 'IP-MIB::ipOutNoRoutes.0' 'IP-MIB::ipReasmReqds.0' 'IP-MIB::ipReasmOKs.0' 'IP-MIB::ipReasmFails.0' '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] IP-MIB::ipForwDatagrams.0 = 339771 IP-MIB::ipInDelivers.0 = 1374565 IP-MIB::ipInReceives.0 = 1741026 IP-MIB::ipOutRequests.0 = 1976132 IP-MIB::ipInDiscards.0 = 0 IP-MIB::ipOutDiscards.0 = 20 IP-MIB::ipOutNoRoutes.0 = 3000 IP-MIB::ipReasmReqds.0 = 214 IP-MIB::ipReasmOKs.0 = 101 IP-MIB::ipReasmFails.0 = 0 IP-MIB::ipFragOKs.0 = 101 IP-MIB::ipFragFails.0 = 0 IP-MIB::ipFragCreates.0 = 214 IP-MIB::ipInUnknownProtos.0 = 0 IP-MIB::ipInHdrErrors.0 = 4 IP-MIB::ipInAddrErrors.0 = 0 ip_forward SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m] IP-FORWARD-MIB::ipCidrRouteNumber.0 = No Such Object available on this agent at this OID snmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::snmpInPkts.0' 'SNMPv2-MIB::snmpOutPkts.0' 'SNMPv2-MIB::snmpInBadVersions.0' 'SNMPv2-MIB::snmpInBadCommunityNames.0' 'SNMPv2-MIB::snmpInBadCommunityUses.0' 'SNMPv2-MIB::snmpInASNParseErrs.0' 'SNMPv2-MIB::snmpInTooBigs.0' 'SNMPv2-MIB::snmpInNoSuchNames.0' 'SNMPv2-MIB::snmpInBadValues.0' 'SNMPv2-MIB::snmpInReadOnlys.0' 'SNMPv2-MIB::snmpInGenErrs.0' 'SNMPv2-MIB::snmpInTotalReqVars.0' 'SNMPv2-MIB::snmpInTotalSetVars.0' 'SNMPv2-MIB::snmpInGetRequests.0' 'SNMPv2-MIB::snmpInGetNexts.0' 'SNMPv2-MIB::snmpInSetRequests.0' 'SNMPv2-MIB::snmpInGetResponses.0' 'SNMPv2-MIB::snmpInTraps.0' 'SNMPv2-MIB::snmpOutTooBigs.0' 'SNMPv2-MIB::snmpOutNoSuchNames.0' 'SNMPv2-MIB::snmpOutBadValues.0' 'SNMPv2-MIB::snmpOutGenErrs.0' 'SNMPv2-MIB::snmpOutGetRequests.0' 'SNMPv2-MIB::snmpOutGetNexts.0' 'SNMPv2-MIB::snmpOutSetRequests.0' 'SNMPv2-MIB::snmpOutGetResponses.0' 'SNMPv2-MIB::snmpOutTraps.0' 'SNMPv2-MIB::snmpSilentDrops.0' 'SNMPv2-MIB::snmpProxyDrops.0'[0m] SNMPv2-MIB::snmpInPkts.0 = 181354 SNMPv2-MIB::snmpOutPkts.0 = 181353 SNMPv2-MIB::snmpInBadVersions.0 = 0 SNMPv2-MIB::snmpInBadCommunityNames.0 = 0 SNMPv2-MIB::snmpInBadCommunityUses.0 = 0 SNMPv2-MIB::snmpInASNParseErrs.0 = 0 SNMPv2-MIB::snmpInTooBigs.0 = 0 SNMPv2-MIB::snmpInNoSuchNames.0 = 0 SNMPv2-MIB::snmpInBadValues.0 = 0 SNMPv2-MIB::snmpInReadOnlys.0 = 0 SNMPv2-MIB::snmpInGenErrs.0 = 0 SNMPv2-MIB::snmpInTotalReqVars.0 = 335307 SNMPv2-MIB::snmpInTotalSetVars.0 = 0 SNMPv2-MIB::snmpInGetRequests.0 = 2880 SNMPv2-MIB::snmpInGetNexts.0 = 163035 SNMPv2-MIB::snmpInSetRequests.0 = 0 SNMPv2-MIB::snmpInGetResponses.0 = 0 SNMPv2-MIB::snmpInTraps.0 = 0 SNMPv2-MIB::snmpOutTooBigs.0 = 0 SNMPv2-MIB::snmpOutNoSuchNames.0 = 0 SNMPv2-MIB::snmpOutBadValues.0 = 0 SNMPv2-MIB::snmpOutGenErrs.0 = 0 SNMPv2-MIB::snmpOutGetRequests.0 = 0 SNMPv2-MIB::snmpOutGetNexts.0 = 0 SNMPv2-MIB::snmpOutSetRequests.0 = 0 SNMPv2-MIB::snmpOutGetResponses.0 = 181353 SNMPv2-MIB::snmpOutTraps.0 = 0 SNMPv2-MIB::snmpSilentDrops.0 = 0 SNMPv2-MIB::snmpProxyDrops.0 = 0 udp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0'[0m] UDP-MIB::udpInDatagrams.0 = 87284 UDP-MIB::udpOutDatagrams.0 = 214392 UDP-MIB::udpInErrors.0 = 0 UDP-MIB::udpNoPorts.0 = 731 tcp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'TCP-MIB::tcpActiveOpens.0' 'TCP-MIB::tcpPassiveOpens.0' 'TCP-MIB::tcpAttemptFails.0' 'TCP-MIB::tcpEstabResets.0' 'TCP-MIB::tcpCurrEstab.0' 'TCP-MIB::tcpInSegs.0' 'TCP-MIB::tcpOutSegs.0' 'TCP-MIB::tcpRetransSegs.0' 'TCP-MIB::tcpInErrs.0' 'TCP-MIB::tcpOutRsts.0'[0m] TCP-MIB::tcpActiveOpens.0 = 1620 TCP-MIB::tcpPassiveOpens.0 = 5 TCP-MIB::tcpAttemptFails.0 = 0 TCP-MIB::tcpEstabResets.0 = 8 TCP-MIB::tcpCurrEstab.0 = 0 TCP-MIB::tcpInSegs.0 = 1281351 TCP-MIB::tcpOutSegs.0 = 1435662 TCP-MIB::tcpRetransSegs.0 = 304 TCP-MIB::tcpInErrs.0 = 0 TCP-MIB::tcpOutRsts.0 = 745 >> Runtime for poller module 'netstats': 0.2436 seconds with 18016 bytes >> [0;36mSNMP[0m: [6/0.24s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module netstats #### 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' 'udp:HOSTNAME:161' 'hrSystemMaxProcesses.0' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m] hrSystemMaxProcesses.0 = 0 hrSystemProcesses.0 = 43 hrSystemNumUsers.0 = 0 ProcessesSQL[[1;33mselect * from `hrSystem` where (`device_id` = ?) limit 1 [0;33m[2][0m 1.12ms] Users >> Runtime for poller module 'hr-mib': 0.0651 seconds with 22320 bytes >> [0;36mSNMP[0m: [1/0.06s] [1;33mMySQL[0m: [1/0.01s] #### Unload poller module hr-mib #### 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' 'udp:HOSTNAME:161' 'systemStats'[0m] ssIndex.0 = 1 ssErrorName.0 = systemStats ssSwapIn.0 = 0 ssSwapOut.0 = 0 ssIOSent.0 = 0 ssIOReceive.0 = 0 ssSysInterrupts.0 = 647 ssSysContext.0 = 120 ssCpuUser.0 = 0 ssCpuSystem.0 = 0 ssCpuIdle.0 = 98 ssCpuRawUser.0 = 65132 ssCpuRawNice.0 = 0 ssCpuRawSystem.0 = 68321 ssCpuRawIdle.0 = 9415612 ssCpuRawWait.0 = 2616 ssCpuRawKernel.0 = 0 ssCpuRawInterrupt.0 = 0 ssIORawSent.0 = 8448 ssIORawReceived.0 = 178940 ssRawInterrupts.0 = 74465539 ssRawContexts.0 = 8150292 ssCpuRawSoftIRQ.0 = 55103 ssRawSwapIn.0 = 0 ssRawSwapOut.0 = 0 ssCpuRawSteal.0 = 0 ssCpuRawGuest.0 = 0 ssCpuRawGuestNice.0 = 0 SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m] laLoadInt.1 = 0 laLoadInt.2 = 1 laLoadInt.3 = 5 >> Runtime for poller module 'ucd-mib': 0.0755 seconds with 2128 bytes >> [0;36mSNMP[0m: [2/0.07s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module ucd-mib #### 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' 'udp:HOSTNAME:161' 'ipSystemStats'[0m] ipSystemStatsInReceives.ipv4 = 1740881 ipSystemStatsInReceives.ipv6 = 38372 ipSystemStatsHCInReceives.ipv4 = 1740881 ipSystemStatsHCInReceives.ipv6 = 38372 ipSystemStatsInOctets.ipv6 = 10183893 ipSystemStatsHCInOctets.ipv6 = 10183893 ipSystemStatsInHdrErrors.ipv4 = 4 ipSystemStatsInHdrErrors.ipv6 = 0 ipSystemStatsInNoRoutes.ipv4 = 626 ipSystemStatsInNoRoutes.ipv6 = 0 ipSystemStatsInAddrErrors.ipv4 = 0 ipSystemStatsInAddrErrors.ipv6 = 0 ipSystemStatsInUnknownProtos.ipv4 = 0 ipSystemStatsInUnknownProtos.ipv6 = 0 ipSystemStatsInTruncatedPkts.ipv4 = 0 ipSystemStatsInTruncatedPkts.ipv6 = 0 ipSystemStatsInForwDatagrams.ipv4 = 340335 ipSystemStatsInForwDatagrams.ipv6 = 0 ipSystemStatsHCInForwDatagrams.ipv4 = 340335 ipSystemStatsHCInForwDatagrams.ipv6 = 0 ipSystemStatsReasmReqds.ipv4 = 214 ipSystemStatsReasmReqds.ipv6 = 0 ipSystemStatsReasmOKs.ipv4 = 101 ipSystemStatsReasmOKs.ipv6 = 0 ipSystemStatsReasmFails.ipv4 = 0 ipSystemStatsReasmFails.ipv6 = 0 ipSystemStatsInDiscards.ipv4 = 0 ipSystemStatsInDiscards.ipv6 = 0 ipSystemStatsInDelivers.ipv4 = 1374488 ipSystemStatsInDelivers.ipv6 = 17319 ipSystemStatsHCInDelivers.ipv4 = 1374488 ipSystemStatsHCInDelivers.ipv6 = 17319 ipSystemStatsOutRequests.ipv4 = 1975952 ipSystemStatsOutRequests.ipv6 = 27155 ipSystemStatsHCOutRequests.ipv4 = 1975952 ipSystemStatsHCOutRequests.ipv6 = 27155 ipSystemStatsOutNoRoutes.ipv4 = 3000 ipSystemStatsOutNoRoutes.ipv6 = 8 ipSystemStatsOutForwDatagrams.ipv4 = 339709 ipSystemStatsOutForwDatagrams.ipv6 = 0 ipSystemStatsHCOutForwDatagrams.ipv4 = 339709 ipSystemStatsHCOutForwDatagrams.ipv6 = 0 ipSystemStatsOutDiscards.ipv4 = 20 ipSystemStatsOutDiscards.ipv6 = 0 ipSystemStatsOutFragReqds.ipv4 = 101 ipSystemStatsOutFragReqds.ipv6 = 0 ipSystemStatsOutFragOKs.ipv4 = 101 ipSystemStatsOutFragOKs.ipv6 = 0 ipSystemStatsOutFragFails.ipv4 = 0 ipSystemStatsOutFragFails.ipv6 = 0 ipSystemStatsOutFragCreates.ipv4 = 214 ipSystemStatsOutFragCreates.ipv6 = 0 ipSystemStatsOutTransmits.ipv4 = 2312754 ipSystemStatsOutTransmits.ipv6 = 27147 ipSystemStatsHCOutTransmits.ipv4 = 2312754 ipSystemStatsHCOutTransmits.ipv6 = 27147 ipSystemStatsOutOctets.ipv6 = 7142384 ipSystemStatsHCOutOctets.ipv6 = 7142384 ipSystemStatsInMcastPkts.ipv4 = 77179 ipSystemStatsInMcastPkts.ipv6 = 38372 ipSystemStatsHCInMcastPkts.ipv4 = 77179 ipSystemStatsHCInMcastPkts.ipv6 = 38372 ipSystemStatsInMcastOctets.ipv6 = 10183893 ipSystemStatsHCInMcastOctets.ipv6 = 10183893 ipSystemStatsOutMcastPkts.ipv4 = 57959 ipSystemStatsOutMcastPkts.ipv6 = 27155 ipSystemStatsHCOutMcastPkts.ipv4 = 57959 ipSystemStatsHCOutMcastPkts.ipv6 = 27155 ipSystemStatsOutMcastOctets.ipv6 = 7142384 ipSystemStatsHCOutMcastOctets.ipv6 = 7142384 ipSystemStatsInBcastPkts.ipv4 = 3049 ipSystemStatsHCInBcastPkts.ipv4 = 3049 ipSystemStatsOutBcastPkts.ipv4 = 1 ipSystemStatsHCOutBcastPkts.ipv4 = 1 ipSystemStatsDiscontinuityTime.ipv4 = 0:0:00:00.00 ipSystemStatsDiscontinuityTime.ipv6 = 0:0:00:00.00 ipSystemStatsRefreshRate.ipv4 = 60000 ipSystemStatsRefreshRate.ipv6 = 60000 ipv4 ipv6 >> Runtime for poller module 'ipSystemStats': 0.0585 seconds with 12520 bytes >> [0;36mSNMP[0m: [1/0.06s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module ipSystemStats #### 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[2][0m 2.81ms] Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifXEntry'[0m] ifName.1 = lo ifName.2 = eth0 ifName.3 = eth1 ifName.4 = eth2 ifName.5 = eth3 ifName.6 = npi0 ifName.7 = npi1 ifName.8 = npi2 ifName.9 = npi3 ifName.10 = loop0 ifName.11 = loop1 ifName.12 = loop2 ifName.13 = loop3 ifName.14 = imq0 ifName.15 = eth3.2 ifName.16 = eth2.102 ifInMulticastPkts.1 = 0 ifInMulticastPkts.2 = 0 ifInMulticastPkts.3 = 0 ifInMulticastPkts.4 = 86812 ifInMulticastPkts.5 = 92213 ifInMulticastPkts.6 = 0 ifInMulticastPkts.7 = 0 ifInMulticastPkts.8 = 0 ifInMulticastPkts.9 = 0 ifInMulticastPkts.10 = 0 ifInMulticastPkts.11 = 0 ifInMulticastPkts.12 = 0 ifInMulticastPkts.13 = 0 ifInMulticastPkts.14 = 0 ifInMulticastPkts.15 = 2389 ifInMulticastPkts.16 = 6 ifInBroadcastPkts.1 = 0 ifInBroadcastPkts.2 = 0 ifInBroadcastPkts.3 = 0 ifInBroadcastPkts.4 = 0 ifInBroadcastPkts.5 = 0 ifInBroadcastPkts.6 = 0 ifInBroadcastPkts.7 = 0 ifInBroadcastPkts.8 = 0 ifInBroadcastPkts.9 = 0 ifInBroadcastPkts.10 = 0 ifInBroadcastPkts.11 = 0 ifInBroadcastPkts.12 = 0 ifInBroadcastPkts.13 = 0 ifInBroadcastPkts.14 = 0 ifInBroadcastPkts.15 = 0 ifInBroadcastPkts.16 = 0 ifOutMulticastPkts.1 = 0 ifOutMulticastPkts.2 = 0 ifOutMulticastPkts.3 = 0 ifOutMulticastPkts.4 = 0 ifOutMulticastPkts.5 = 0 ifOutMulticastPkts.6 = 0 ifOutMulticastPkts.7 = 0 ifOutMulticastPkts.8 = 0 ifOutMulticastPkts.9 = 0 ifOutMulticastPkts.10 = 0 ifOutMulticastPkts.11 = 0 ifOutMulticastPkts.12 = 0 ifOutMulticastPkts.13 = 0 ifOutMulticastPkts.14 = 0 ifOutMulticastPkts.15 = 0 ifOutMulticastPkts.16 = 0 ifOutBroadcastPkts.1 = 0 ifOutBroadcastPkts.2 = 0 ifOutBroadcastPkts.3 = 0 ifOutBroadcastPkts.4 = 0 ifOutBroadcastPkts.5 = 0 ifOutBroadcastPkts.6 = 0 ifOutBroadcastPkts.7 = 0 ifOutBroadcastPkts.8 = 0 ifOutBroadcastPkts.9 = 0 ifOutBroadcastPkts.10 = 0 ifOutBroadcastPkts.11 = 0 ifOutBroadcastPkts.12 = 0 ifOutBroadcastPkts.13 = 0 ifOutBroadcastPkts.14 = 0 ifOutBroadcastPkts.15 = 0 ifOutBroadcastPkts.16 = 0 ifHCInOctets.1 = 177532 ifHCInOctets.2 = 0 ifHCInOctets.3 = 0 ifHCInOctets.4 = 66783604700 ifHCInOctets.5 = 14156138082 ifHCInOctets.6 = 0 ifHCInOctets.7 = 0 ifHCInOctets.8 = 0 ifHCInOctets.9 = 0 ifHCInOctets.10 = 0 ifHCInOctets.11 = 0 ifHCInOctets.12 = 0 ifHCInOctets.13 = 0 ifHCInOctets.14 = 0 ifHCInOctets.15 = 151442 ifHCInOctets.16 = 1570580520 ifHCInUcastPkts.1 = 1812 ifHCInUcastPkts.2 = 0 ifHCInUcastPkts.3 = 0 ifHCInUcastPkts.4 = 47311589 ifHCInUcastPkts.5 = 24021902 ifHCInUcastPkts.6 = 0 ifHCInUcastPkts.7 = 0 ifHCInUcastPkts.8 = 0 ifHCInUcastPkts.9 = 0 ifHCInUcastPkts.10 = 0 ifHCInUcastPkts.11 = 0 ifHCInUcastPkts.12 = 0 ifHCInUcastPkts.13 = 0 ifHCInUcastPkts.14 = 0 ifHCInUcastPkts.15 = 0 ifHCInUcastPkts.16 = 1429052 ifHCInMulticastPkts.1 = 0 ifHCInMulticastPkts.2 = 0 ifHCInMulticastPkts.3 = 0 ifHCInMulticastPkts.4 = 86812 ifHCInMulticastPkts.5 = 92213 ifHCInMulticastPkts.6 = 0 ifHCInMulticastPkts.7 = 0 ifHCInMulticastPkts.8 = 0 ifHCInMulticastPkts.9 = 0 ifHCInMulticastPkts.10 = 0 ifHCInMulticastPkts.11 = 0 ifHCInMulticastPkts.12 = 0 ifHCInMulticastPkts.13 = 0 ifHCInMulticastPkts.14 = 0 ifHCInMulticastPkts.15 = 2389 ifHCInMulticastPkts.16 = 6 ifHCInBroadcastPkts.1 = 0 ifHCInBroadcastPkts.2 = 0 ifHCInBroadcastPkts.3 = 0 ifHCInBroadcastPkts.4 = 0 ifHCInBroadcastPkts.5 = 0 ifHCInBroadcastPkts.6 = 0 ifHCInBroadcastPkts.7 = 0 ifHCInBroadcastPkts.8 = 0 ifHCInBroadcastPkts.9 = 0 ifHCInBroadcastPkts.10 = 0 ifHCInBroadcastPkts.11 = 0 ifHCInBroadcastPkts.12 = 0 ifHCInBroadcastPkts.13 = 0 ifHCInBroadcastPkts.14 = 0 ifHCInBroadcastPkts.15 = 0 ifHCInBroadcastPkts.16 = 0 ifHCOutOctets.1 = 177532 ifHCOutOctets.2 = 0 ifHCOutOctets.3 = 0 ifHCOutOctets.4 = 15702445082 ifHCOutOctets.5 = 64892656523 ifHCOutOctets.6 = 0 ifHCOutOctets.7 = 0 ifHCOutOctets.8 = 0 ifHCOutOctets.9 = 0 ifHCOutOctets.10 = 0 ifHCOutOctets.11 = 0 ifHCOutOctets.12 = 0 ifHCOutOctets.13 = 0 ifHCOutOctets.14 = 0 ifHCOutOctets.15 = 5028229 ifHCOutOctets.16 = 1598054959 ifHCOutUcastPkts.1 = 1812 ifHCOutUcastPkts.2 = 0 ifHCOutUcastPkts.3 = 0 ifHCOutUcastPkts.4 = 25383690 ifHCOutUcastPkts.5 = 46283888 ifHCOutUcastPkts.6 = 0 ifHCOutUcastPkts.7 = 0 ifHCOutUcastPkts.8 = 0 ifHCOutUcastPkts.9 = 0 ifHCOutUcastPkts.10 = 0 ifHCOutUcastPkts.11 = 0 ifHCOutUcastPkts.12 = 0 ifHCOutUcastPkts.13 = 0 ifHCOutUcastPkts.14 = 0 ifHCOutUcastPkts.15 = 19246 ifHCOutUcastPkts.16 = 1636041 ifHCOutMulticastPkts.1 = 0 ifHCOutMulticastPkts.2 = 0 ifHCOutMulticastPkts.3 = 0 ifHCOutMulticastPkts.4 = 0 ifHCOutMulticastPkts.5 = 0 ifHCOutMulticastPkts.6 = 0 ifHCOutMulticastPkts.7 = 0 ifHCOutMulticastPkts.8 = 0 ifHCOutMulticastPkts.9 = 0 ifHCOutMulticastPkts.10 = 0 ifHCOutMulticastPkts.11 = 0 ifHCOutMulticastPkts.12 = 0 ifHCOutMulticastPkts.13 = 0 ifHCOutMulticastPkts.14 = 0 ifHCOutMulticastPkts.15 = 0 ifHCOutMulticastPkts.16 = 0 ifHCOutBroadcastPkts.1 = 0 ifHCOutBroadcastPkts.2 = 0 ifHCOutBroadcastPkts.3 = 0 ifHCOutBroadcastPkts.4 = 0 ifHCOutBroadcastPkts.5 = 0 ifHCOutBroadcastPkts.6 = 0 ifHCOutBroadcastPkts.7 = 0 ifHCOutBroadcastPkts.8 = 0 ifHCOutBroadcastPkts.9 = 0 ifHCOutBroadcastPkts.10 = 0 ifHCOutBroadcastPkts.11 = 0 ifHCOutBroadcastPkts.12 = 0 ifHCOutBroadcastPkts.13 = 0 ifHCOutBroadcastPkts.14 = 0 ifHCOutBroadcastPkts.15 = 0 ifHCOutBroadcastPkts.16 = 0 ifHighSpeed.1 = 10 ifHighSpeed.2 = 10 ifHighSpeed.3 = 10 ifHighSpeed.4 = 1000 ifHighSpeed.5 = 1000 ifHighSpeed.6 = 0 ifHighSpeed.7 = 0 ifHighSpeed.8 = 0 ifHighSpeed.9 = 0 ifHighSpeed.10 = 0 ifHighSpeed.11 = 0 ifHighSpeed.12 = 0 ifHighSpeed.13 = 0 ifHighSpeed.14 = 0 ifHighSpeed.15 = 1000 ifHighSpeed.16 = 1000 ifPromiscuousMode.1 = false ifPromiscuousMode.2 = false ifPromiscuousMode.3 = false ifPromiscuousMode.4 = false ifPromiscuousMode.5 = false ifPromiscuousMode.6 = false ifPromiscuousMode.7 = false ifPromiscuousMode.8 = false ifPromiscuousMode.9 = false ifPromiscuousMode.10 = false ifPromiscuousMode.11 = false ifPromiscuousMode.12 = false ifPromiscuousMode.13 = false ifPromiscuousMode.14 = false ifPromiscuousMode.15 = false ifPromiscuousMode.16 = false ifConnectorPresent.1 = false ifConnectorPresent.2 = true ifConnectorPresent.3 = true ifConnectorPresent.4 = true ifConnectorPresent.5 = true ifConnectorPresent.6 = true ifConnectorPresent.7 = true ifConnectorPresent.8 = true ifConnectorPresent.9 = true ifConnectorPresent.10 = true ifConnectorPresent.11 = true ifConnectorPresent.12 = true ifConnectorPresent.13 = true ifConnectorPresent.14 = true ifConnectorPresent.15 = true ifConnectorPresent.16 = true ifAlias.1 = lo ifAlias.2 = eth0 ifAlias.3 = eth1 ifAlias.4 = WAN ifAlias.5 = LAN ifAlias.6 = npi0 ifAlias.7 = npi1 ifAlias.8 = npi2 ifAlias.9 = npi3 ifAlias.10 = loop0 ifAlias.11 = loop1 ifAlias.12 = loop2 ifAlias.13 = loop3 ifAlias.14 = imq0 ifAlias.15 = eth3.2@eth3 ifAlias.16 = WAN ifCounterDiscontinuityTime.1 = 0:0:00:00.00 ifCounterDiscontinuityTime.2 = 0:0:00:00.00 ifCounterDiscontinuityTime.3 = 0:0:00:00.00 ifCounterDiscontinuityTime.4 = 0:0:00:00.00 ifCounterDiscontinuityTime.5 = 0:0:00:00.00 ifCounterDiscontinuityTime.6 = 0:0:00:00.00 ifCounterDiscontinuityTime.7 = 0:0:00:00.00 ifCounterDiscontinuityTime.8 = 0:0:00:00.00 ifCounterDiscontinuityTime.9 = 0:0:00:00.00 ifCounterDiscontinuityTime.10 = 0:0:00:00.00 ifCounterDiscontinuityTime.11 = 0:0:00:00.00 ifCounterDiscontinuityTime.12 = 0:0:00:00.00 ifCounterDiscontinuityTime.13 = 0:0:00:00.00 ifCounterDiscontinuityTime.14 = 0:0:00:00.00 ifCounterDiscontinuityTime.15 = 0:0:00:00.00 ifCounterDiscontinuityTime.16 = 0:0:00:00.00 ifDescr SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifDescr'[0m] ifDescr.1 = lo ifDescr.2 = eth0 ifDescr.3 = eth1 ifDescr.4 = eth2 ifDescr.5 = eth3 ifDescr.6 = npi0 ifDescr.7 = npi1 ifDescr.8 = npi2 ifDescr.9 = npi3 ifDescr.10 = loop0 ifDescr.11 = loop1 ifDescr.12 = loop2 ifDescr.13 = loop3 ifDescr.14 = imq0 ifDescr.15 = eth3.2 ifDescr.16 = eth2.102 ifAdminStatus SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifAdminStatus'[0m] ifAdminStatus.1 = up ifAdminStatus.2 = down ifAdminStatus.3 = down ifAdminStatus.4 = up ifAdminStatus.5 = up ifAdminStatus.6 = down ifAdminStatus.7 = down ifAdminStatus.8 = down ifAdminStatus.9 = down ifAdminStatus.10 = down ifAdminStatus.11 = down ifAdminStatus.12 = down ifAdminStatus.13 = down ifAdminStatus.14 = up ifAdminStatus.15 = up ifAdminStatus.16 = up ifOperStatus SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifOperStatus'[0m] ifOperStatus.1 = up ifOperStatus.2 = down ifOperStatus.3 = down ifOperStatus.4 = up ifOperStatus.5 = up ifOperStatus.6 = down ifOperStatus.7 = down ifOperStatus.8 = down ifOperStatus.9 = down ifOperStatus.10 = down ifOperStatus.11 = down ifOperStatus.12 = down ifOperStatus.13 = down ifOperStatus.14 = up ifOperStatus.15 = up ifOperStatus.16 = up ifLastChange SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifLastChange'[0m] ifLastChange.1 = 0 ifLastChange.2 = 0 ifLastChange.3 = 0 ifLastChange.4 = 0 ifLastChange.5 = 0 ifLastChange.6 = 0 ifLastChange.7 = 0 ifLastChange.8 = 0 ifLastChange.9 = 0 ifLastChange.10 = 0 ifLastChange.11 = 0 ifLastChange.12 = 0 ifLastChange.13 = 0 ifLastChange.14 = 0 ifLastChange.15 = 0 ifLastChange.16 = 0 ifType SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifType'[0m] ifType.1 = softwareLoopback ifType.2 = ethernetCsmacd ifType.3 = ethernetCsmacd ifType.4 = ethernetCsmacd ifType.5 = ethernetCsmacd ifType.6 = ethernetCsmacd ifType.7 = ethernetCsmacd ifType.8 = ethernetCsmacd ifType.9 = ethernetCsmacd ifType.10 = ethernetCsmacd ifType.11 = ethernetCsmacd ifType.12 = ethernetCsmacd ifType.13 = ethernetCsmacd ifType.14 = other ifType.15 = ethernetCsmacd ifType.16 = ethernetCsmacd ifPhysAddress SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifPhysAddress'[0m] ifPhysAddress.1 = ifPhysAddress.2 = 80:2a:a8:cd:65:25 ifPhysAddress.3 = 80:2a:a8:cd:65:26 ifPhysAddress.4 = 80:2a:a8:cd:65:27 ifPhysAddress.5 = 80:2a:a8:cd:65:28 ifPhysAddress.6 = b2:ab:27:14:d0:44 ifPhysAddress.7 = 3a:eb:dd:a9:63:96 ifPhysAddress.8 = 66:37:c5:dc:ad:1 ifPhysAddress.9 = 1a:d0:74:18:9d:0 ifPhysAddress.10 = d6:f9:4c:a8:2f:9a ifPhysAddress.11 = 6e:ea:a2:27:77:40 ifPhysAddress.12 = 5a:eb:24:79:49:c6 ifPhysAddress.13 = a2:fd:a1:a7:dc:e8 ifPhysAddress.14 = ifPhysAddress.15 = 80:2a:a8:cd:65:28 ifPhysAddress.16 = 80:2a:a8:cd:65:27 ifMtu SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifMtu'[0m] ifMtu.1 = 65536 ifMtu.2 = 1500 ifMtu.3 = 1500 ifMtu.4 = 1500 ifMtu.5 = 1500 ifMtu.6 = 1500 ifMtu.7 = 1500 ifMtu.8 = 1500 ifMtu.9 = 1500 ifMtu.10 = 1500 ifMtu.11 = 1500 ifMtu.12 = 1500 ifMtu.13 = 1500 ifMtu.14 = 16000 ifMtu.15 = 1500 ifMtu.16 = 1500 ifInErrors SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifInErrors'[0m] ifInErrors.1 = 0 ifInErrors.2 = 0 ifInErrors.3 = 0 ifInErrors.4 = 0 ifInErrors.5 = 0 ifInErrors.6 = 0 ifInErrors.7 = 0 ifInErrors.8 = 0 ifInErrors.9 = 0 ifInErrors.10 = 0 ifInErrors.11 = 0 ifInErrors.12 = 0 ifInErrors.13 = 0 ifInErrors.14 = 0 ifInErrors.15 = 0 ifInErrors.16 = 0 ifOutErrors SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifOutErrors'[0m] ifOutErrors.1 = 0 ifOutErrors.2 = 0 ifOutErrors.3 = 0 ifOutErrors.4 = 0 ifOutErrors.5 = 0 ifOutErrors.6 = 0 ifOutErrors.7 = 0 ifOutErrors.8 = 0 ifOutErrors.9 = 0 ifOutErrors.10 = 0 ifOutErrors.11 = 0 ifOutErrors.12 = 0 ifOutErrors.13 = 0 ifOutErrors.14 = 0 ifOutErrors.15 = 0 ifOutErrors.16 = 0 ifInDiscards SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifInDiscards'[0m] ifInDiscards.1 = 0 ifInDiscards.2 = 0 ifInDiscards.3 = 0 ifInDiscards.4 = 39 ifInDiscards.5 = 0 ifInDiscards.6 = 0 ifInDiscards.7 = 0 ifInDiscards.8 = 0 ifInDiscards.9 = 0 ifInDiscards.10 = 0 ifInDiscards.11 = 0 ifInDiscards.12 = 0 ifInDiscards.13 = 0 ifInDiscards.14 = 0 ifInDiscards.15 = 0 ifInDiscards.16 = 0 ifOutDiscards SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifOutDiscards'[0m] ifOutDiscards.1 = 0 ifOutDiscards.2 = 0 ifOutDiscards.3 = 0 ifOutDiscards.4 = 0 ifOutDiscards.5 = 0 ifOutDiscards.6 = 0 ifOutDiscards.7 = 0 ifOutDiscards.8 = 0 ifOutDiscards.9 = 0 ifOutDiscards.10 = 0 ifOutDiscards.11 = 0 ifOutDiscards.12 = 0 ifOutDiscards.13 = 0 ifOutDiscards.14 = 0 ifOutDiscards.15 = 0 ifOutDiscards.16 = 0 dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m] dot3StatsDuplexStatus = No Such Instance currently exists at this OID Invalid snmp_walk() data = dot3StatsDuplexStatus = No Such Instance currently exists at this OID SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1qPvid'[0m] dot1qPvid = No Such Object available on this agent at this OID Invalid snmp_walk() data = 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','vdsl2') [0;33m[2][0m 1.26ms] array ( 1 => array ( 'ifName' => 'lo', 'ifInMulticastPkts' => '0', 'ifInBroadcastPkts' => '0', 'ifOutMulticastPkts' => '0', 'ifOutBroadcastPkts' => '0', 'ifHCInOctets' => '177532', 'ifHCInUcastPkts' => '1812', 'ifHCInMulticastPkts' => '0', 'ifHCInBroadcastPkts' => '0', 'ifHCOutOctets' => '177532', 'ifHCOutUcastPkts' => '1812', 'ifHCOutMulticastPkts' => '0', 'ifHCOutBroadcastPkts' => '0', 'ifHighSpeed' => '10', 'ifPromiscuousMode' => 'false', 'ifConnectorPresent' => 'false', 'ifAlias' => 'lo', 'ifCounterDiscontinuityTime' => '0:0:00:00.00', 'ifDescr' => 'lo', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '0', 'ifType' => 'softwareLoopback', 'ifPhysAddress' => '', 'ifMtu' => '65536', 'ifInErrors' => '0', 'ifOutErrors' => '0', 'ifInDiscards' => '0', 'ifOutDiscards' => '0', ), 2 => array ( 'ifName' => 'eth0', 'ifInMulticastPkts' => '0', 'ifInBroadcastPkts' => '0', 'ifOutMulticastPkts' => '0', 'ifOutBroadcastPkts' => '0', 'ifHCInOctets' => '0', 'ifHCInUcastPkts' => '0', 'ifHCInMulticastPkts' => '0', 'ifHCInBroadcastPkts' => '0', 'ifHCOutOctets' => '0', 'ifHCOutUcastPkts' => '0', 'ifHCOutMulticastPkts' => '0', 'ifHCOutBroadcastPkts' => '0', 'ifHighSpeed' => '10', 'ifPromiscuousMode' => 'false', 'ifConnectorPresent' => 'true', 'ifAlias' => 'eth0', 'ifCounterDiscontinuityTime' => '0:0:00:00.00', 'ifDescr' => 'eth0', 'ifAdminStatus' => 'down', 'ifOperStatus' => 'down', 'ifLastChange' => '0', 'ifType' => 'ethernetCsmacd', 'ifPhysAddress' => '80:2a:a8:cd:65:25', 'ifMtu' => '1500', 'ifInErrors' => '0', 'ifOutErrors' => '0', 'ifInDiscards' => '0', 'ifOutDiscards' => '0', ), 3 => array ( 'ifName' => 'eth1', 'ifInMulticastPkts' => '0', 'ifInBroadcastPkts' => '0', 'ifOutMulticastPkts' => '0', 'ifOutBroadcastPkts' => '0', 'ifHCInOctets' => '0', 'ifHCInUcastPkts' => '0', 'ifHCInMulticastPkts' => '0', 'ifHCInBroadcastPkts' => '0', 'ifHCOutOctets' => '0', 'ifHCOutUcastPkts' => '0', 'ifHCOutMulticastPkts' => '0', 'ifHCOutBroadcastPkts' => '0', 'ifHighSpeed' => '10', 'ifPromiscuousMode' => 'false', 'ifConnectorPresent' => 'true', 'ifAlias' => 'eth1', 'ifCounterDiscontinuityTime' => '0:0:00:00.00', 'ifDescr' => 'eth1', 'ifAdminStatus' => 'down', 'ifOperStatus' => 'down', 'ifLastChange' => '0', 'ifType' => 'ethernetCsmacd', 'ifPhysAddress' => '80:2a:a8:cd:65:26', 'ifMtu' => '1500', 'ifInErrors' => '0', 'ifOutErrors' => '0', 'ifInDiscards' => '0', 'ifOutDiscards' => '0', ), 4 => array ( 'ifName' => 'eth2', 'ifInMulticastPkts' => '86812', 'ifInBroadcastPkts' => '0', 'ifOutMulticastPkts' => '0', 'ifOutBroadcastPkts' => '0', 'ifHCInOctets' => '66783604700', 'ifHCInUcastPkts' => '47311589', 'ifHCInMulticastPkts' => '86812', 'ifHCInBroadcastPkts' => '0', 'ifHCOutOctets' => '15702445082', 'ifHCOutUcastPkts' => '25383690', 'ifHCOutMulticastPkts' => '0', 'ifHCOutBroadcastPkts' => '0', 'ifHighSpeed' => '1000', 'ifPromiscuousMode' => 'false', 'ifConnectorPresent' => 'true', 'ifAlias' => 'WAN', 'ifCounterDiscontinuityTime' => '0:0:00:00.00', 'ifDescr' => 'eth2', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '0', 'ifType' => 'ethernetCsmacd', 'ifPhysAddress' => '80:2a:a8:cd:65:27', 'ifMtu' => '1500', 'ifInErrors' => '0', 'ifOutErrors' => '0', 'ifInDiscards' => '39', 'ifOutDiscards' => '0', ), 5 => array ( 'ifName' => 'eth3', 'ifInMulticastPkts' => '92213', 'ifInBroadcastPkts' => '0', 'ifOutMulticastPkts' => '0', 'ifOutBroadcastPkts' => '0', 'ifHCInOctets' => '14156138082', 'ifHCInUcastPkts' => '24021902', 'ifHCInMulticastPkts' => '92213', 'ifHCInBroadcastPkts' => '0', 'ifHCOutOctets' => '64892656523', 'ifHCOutUcastPkts' => '46283888', 'ifHCOutMulticastPkts' => '0', 'ifHCOutBroadcastPkts' => '0', 'ifHighSpeed' => '1000', 'ifPromiscuousMode' => 'false', 'ifConnectorPresent' => 'true', 'ifAlias' => 'LAN', 'ifCounterDiscontinuityTime' => '0:0:00:00.00', 'ifDescr' => 'eth3', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '0', 'ifType' => 'ethernetCsmacd', 'ifPhysAddress' => '80:2a:a8:cd:65:28', 'ifMtu' => '1500', 'ifInErrors' => '0', 'ifOutErrors' => '0', 'ifInDiscards' => '0', 'ifOutDiscards' => '0', ), 6 => array ( 'ifName' => 'npi0', 'ifInMulticastPkts' => '0', 'ifInBroadcastPkts' => '0', 'ifOutMulticastPkts' => '0', 'ifOutBroadcastPkts' => '0', 'ifHCInOctets' => '0', 'ifHCInUcastPkts' => '0', 'ifHCInMulticastPkts' => '0', 'ifHCInBroadcastPkts' => '0', 'ifHCOutOctets' => '0', 'ifHCOutUcastPkts' => '0', 'ifHCOutMulticastPkts' => '0', 'ifHCOutBroadcastPkts' => '0', 'ifHighSpeed' => '0', 'ifPromiscuousMode' => 'false', 'ifConnectorPresent' => 'true', 'ifAlias' => 'npi0', 'ifCounterDiscontinuityTime' => '0:0:00:00.00', 'ifDescr' => 'npi0', 'ifAdminStatus' => 'down', 'ifOperStatus' => 'down', 'ifLastChange' => '0', 'ifType' => 'ethernetCsmacd', 'ifPhysAddress' => 'b2:ab:27:14:d0:44', 'ifMtu' => '1500', 'ifInErrors' => '0', 'ifOutErrors' => '0', 'ifInDiscards' => '0', 'ifOutDiscards' => '0', ), 7 => array ( 'ifName' => 'npi1', 'ifInMulticastPkts' => '0', 'ifInBroadcastPkts' => '0', 'ifOutMulticastPkts' => '0', 'ifOutBroadcastPkts' => '0', 'ifHCInOctets' => '0', 'ifHCInUcastPkts' => '0', 'ifHCInMulticastPkts' => '0', 'ifHCInBroadcastPkts' => '0', 'ifHCOutOctets' => '0', 'ifHCOutUcastPkts' => '0', 'ifHCOutMulticastPkts' => '0', 'ifHCOutBroadcastPkts' => '0', 'ifHighSpeed' => '0', 'ifPromiscuousMode' => 'false', 'ifConnectorPresent' => 'true', 'ifAlias' => 'npi1', 'ifCounterDiscontinuityTime' => '0:0:00:00.00', 'ifDescr' => 'npi1', 'ifAdminStatus' => 'down', 'ifOperStatus' => 'down', 'ifLastChange' => '0', 'ifType' => 'ethernetCsmacd', 'ifPhysAddress' => '3a:eb:dd:a9:63:96', 'ifMtu' => '1500', 'ifInErrors' => '0', 'ifOutErrors' => '0', 'ifInDiscards' => '0', 'ifOutDiscards' => '0', ), 8 => array ( 'ifName' => 'npi2', 'ifInMulticastPkts' => '0', 'ifInBroadcastPkts' => '0', 'ifOutMulticastPkts' => '0', 'ifOutBroadcastPkts' => '0', 'ifHCInOctets' => '0', 'ifHCInUcastPkts' => '0', 'ifHCInMulticastPkts' => '0', 'ifHCInBroadcastPkts' => '0', 'ifHCOutOctets' => '0', 'ifHCOutUcastPkts' => '0', 'ifHCOutMulticastPkts' => '0', 'ifHCOutBroadcastPkts' => '0', 'ifHighSpeed' => '0', 'ifPromiscuousMode' => 'false', 'ifConnectorPresent' => 'true', 'ifAlias' => 'npi2', 'ifCounterDiscontinuityTime' => '0:0:00:00.00', 'ifDescr' => 'npi2', 'ifAdminStatus' => 'down', 'ifOperStatus' => 'down', 'ifLastChange' => '0', 'ifType' => 'ethernetCsmacd', 'ifPhysAddress' => '66:37:c5:dc:ad:1', 'ifMtu' => '1500', 'ifInErrors' => '0', 'ifOutErrors' => '0', 'ifInDiscards' => '0', 'ifOutDiscards' => '0', ), 9 => array ( 'ifName' => 'npi3', 'ifInMulticastPkts' => '0', 'ifInBroadcastPkts' => '0', 'ifOutMulticastPkts' => '0', 'ifOutBroadcastPkts' => '0', 'ifHCInOctets' => '0', 'ifHCInUcastPkts' => '0', 'ifHCInMulticastPkts' => '0', 'ifHCInBroadcastPkts' => '0', 'ifHCOutOctets' => '0', 'ifHCOutUcastPkts' => '0', 'ifHCOutMulticastPkts' => '0', 'ifHCOutBroadcastPkts' => '0', 'ifHighSpeed' => '0', 'ifPromiscuousMode' => 'false', 'ifConnectorPresent' => 'true', 'ifAlias' => 'npi3', 'ifCounterDiscontinuityTime' => '0:0:00:00.00', 'ifDescr' => 'npi3', 'ifAdminStatus' => 'down', 'ifOperStatus' => 'down', 'ifLastChange' => '0', 'ifType' => 'ethernetCsmacd', 'ifPhysAddress' => '1a:d0:74:18:9d:0', 'ifMtu' => '1500', 'ifInErrors' => '0', 'ifOutErrors' => '0', 'ifInDiscards' => '0', 'ifOutDiscards' => '0', ), 10 => array ( 'ifName' => 'loop0', 'ifInMulticastPkts' => '0', 'ifInBroadcastPkts' => '0', 'ifOutMulticastPkts' => '0', 'ifOutBroadcastPkts' => '0', 'ifHCInOctets' => '0', 'ifHCInUcastPkts' => '0', 'ifHCInMulticastPkts' => '0', 'ifHCInBroadcastPkts' => '0', 'ifHCOutOctets' => '0', 'ifHCOutUcastPkts' => '0', 'ifHCOutMulticastPkts' => '0', 'ifHCOutBroadcastPkts' => '0', 'ifHighSpeed' => '0', 'ifPromiscuousMode' => 'false', 'ifConnectorPresent' => 'true', 'ifAlias' => 'loop0', 'ifCounterDiscontinuityTime' => '0:0:00:00.00', 'ifDescr' => 'loop0', 'ifAdminStatus' => 'down', 'ifOperStatus' => 'down', 'ifLastChange' => '0', 'ifType' => 'ethernetCsmacd', 'ifPhysAddress' => 'd6:f9:4c:a8:2f:9a', 'ifMtu' => '1500', 'ifInErrors' => '0', 'ifOutErrors' => '0', 'ifInDiscards' => '0', 'ifOutDiscards' => '0', ), 11 => array ( 'ifName' => 'loop1', 'ifInMulticastPkts' => '0', 'ifInBroadcastPkts' => '0', 'ifOutMulticastPkts' => '0', 'ifOutBroadcastPkts' => '0', 'ifHCInOctets' => '0', 'ifHCInUcastPkts' => '0', 'ifHCInMulticastPkts' => '0', 'ifHCInBroadcastPkts' => '0', 'ifHCOutOctets' => '0', 'ifHCOutUcastPkts' => '0', 'ifHCOutMulticastPkts' => '0', 'ifHCOutBroadcastPkts' => '0', 'ifHighSpeed' => '0', 'ifPromiscuousMode' => 'false', 'ifConnectorPresent' => 'true', 'ifAlias' => 'loop1', 'ifCounterDiscontinuityTime' => '0:0:00:00.00', 'ifDescr' => 'loop1', 'ifAdminStatus' => 'down', 'ifOperStatus' => 'down', 'ifLastChange' => '0', 'ifType' => 'ethernetCsmacd', 'ifPhysAddress' => '6e:ea:a2:27:77:40', 'ifMtu' => '1500', 'ifInErrors' => '0', 'ifOutErrors' => '0', 'ifInDiscards' => '0', 'ifOutDiscards' => '0', ), 12 => array ( 'ifName' => 'loop2', 'ifInMulticastPkts' => '0', 'ifInBroadcastPkts' => '0', 'ifOutMulticastPkts' => '0', 'ifOutBroadcastPkts' => '0', 'ifHCInOctets' => '0', 'ifHCInUcastPkts' => '0', 'ifHCInMulticastPkts' => '0', 'ifHCInBroadcastPkts' => '0', 'ifHCOutOctets' => '0', 'ifHCOutUcastPkts' => '0', 'ifHCOutMulticastPkts' => '0', 'ifHCOutBroadcastPkts' => '0', 'ifHighSpeed' => '0', 'ifPromiscuousMode' => 'false', 'ifConnectorPresent' => 'true', 'ifAlias' => 'loop2', 'ifCounterDiscontinuityTime' => '0:0:00:00.00', 'ifDescr' => 'loop2', 'ifAdminStatus' => 'down', 'ifOperStatus' => 'down', 'ifLastChange' => '0', 'ifType' => 'ethernetCsmacd', 'ifPhysAddress' => '5a:eb:24:79:49:c6', 'ifMtu' => '1500', 'ifInErrors' => '0', 'ifOutErrors' => '0', 'ifInDiscards' => '0', 'ifOutDiscards' => '0', ), 13 => array ( 'ifName' => 'loop3', 'ifInMulticastPkts' => '0', 'ifInBroadcastPkts' => '0', 'ifOutMulticastPkts' => '0', 'ifOutBroadcastPkts' => '0', 'ifHCInOctets' => '0', 'ifHCInUcastPkts' => '0', 'ifHCInMulticastPkts' => '0', 'ifHCInBroadcastPkts' => '0', 'ifHCOutOctets' => '0', 'ifHCOutUcastPkts' => '0', 'ifHCOutMulticastPkts' => '0', 'ifHCOutBroadcastPkts' => '0', 'ifHighSpeed' => '0', 'ifPromiscuousMode' => 'false', 'ifConnectorPresent' => 'true', 'ifAlias' => 'loop3', 'ifCounterDiscontinuityTime' => '0:0:00:00.00', 'ifDescr' => 'loop3', 'ifAdminStatus' => 'down', 'ifOperStatus' => 'down', 'ifLastChange' => '0', 'ifType' => 'ethernetCsmacd', 'ifPhysAddress' => 'a2:fd:a1:a7:dc:e8', 'ifMtu' => '1500', 'ifInErrors' => '0', 'ifOutErrors' => '0', 'ifInDiscards' => '0', 'ifOutDiscards' => '0', ), 14 => array ( 'ifName' => 'imq0', 'ifInMulticastPkts' => '0', 'ifInBroadcastPkts' => '0', 'ifOutMulticastPkts' => '0', 'ifOutBroadcastPkts' => '0', 'ifHCInOctets' => '0', 'ifHCInUcastPkts' => '0', 'ifHCInMulticastPkts' => '0', 'ifHCInBroadcastPkts' => '0', 'ifHCOutOctets' => '0', 'ifHCOutUcastPkts' => '0', 'ifHCOutMulticastPkts' => '0', 'ifHCOutBroadcastPkts' => '0', 'ifHighSpeed' => '0', 'ifPromiscuousMode' => 'false', 'ifConnectorPresent' => 'true', 'ifAlias' => 'imq0', 'ifCounterDiscontinuityTime' => '0:0:00:00.00', 'ifDescr' => 'imq0', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '0', 'ifType' => 'other', 'ifPhysAddress' => '', 'ifMtu' => '16000', 'ifInErrors' => '0', 'ifOutErrors' => '0', 'ifInDiscards' => '0', 'ifOutDiscards' => '0', ), 15 => array ( 'ifName' => 'eth3.2', 'ifInMulticastPkts' => '2389', 'ifInBroadcastPkts' => '0', 'ifOutMulticastPkts' => '0', 'ifOutBroadcastPkts' => '0', 'ifHCInOctets' => '151442', 'ifHCInUcastPkts' => '0', 'ifHCInMulticastPkts' => '2389', 'ifHCInBroadcastPkts' => '0', 'ifHCOutOctets' => '5028229', 'ifHCOutUcastPkts' => '19246', 'ifHCOutMulticastPkts' => '0', 'ifHCOutBroadcastPkts' => '0', 'ifHighSpeed' => '1000', 'ifPromiscuousMode' => 'false', 'ifConnectorPresent' => 'true', 'ifAlias' => 'eth3.2@eth3', 'ifCounterDiscontinuityTime' => '0:0:00:00.00', 'ifDescr' => 'eth3.2', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '0', 'ifType' => 'ethernetCsmacd', 'ifPhysAddress' => '80:2a:a8:cd:65:28', 'ifMtu' => '1500', 'ifInErrors' => '0', 'ifOutErrors' => '0', 'ifInDiscards' => '0', 'ifOutDiscards' => '0', ), 16 => array ( 'ifName' => 'eth2.102', 'ifInMulticastPkts' => '6', 'ifInBroadcastPkts' => '0', 'ifOutMulticastPkts' => '0', 'ifOutBroadcastPkts' => '0', 'ifHCInOctets' => '1570580520', 'ifHCInUcastPkts' => '1429052', 'ifHCInMulticastPkts' => '6', 'ifHCInBroadcastPkts' => '0', 'ifHCOutOctets' => '1598054959', 'ifHCOutUcastPkts' => '1636041', 'ifHCOutMulticastPkts' => '0', 'ifHCOutBroadcastPkts' => '0', 'ifHighSpeed' => '1000', 'ifPromiscuousMode' => 'false', 'ifConnectorPresent' => 'true', 'ifAlias' => 'WAN', 'ifCounterDiscontinuityTime' => '0:0:00:00.00', 'ifDescr' => 'eth2.102', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '0', 'ifType' => 'ethernetCsmacd', 'ifPhysAddress' => '80:2a:a8:cd:65:27', 'ifMtu' => '1500', 'ifInErrors' => '0', 'ifOutErrors' => '0', 'ifInDiscards' => '0', 'ifOutDiscards' => '0', ), ) valid valid valid valid valid ignored by ifDescr: npi0 (matched: /^npi[0-9]/) SQL[[1;33mUPDATE `ports` set `deleted`=? WHERE `port_id` = ? [0;33m["1",null][0m 0.5ms] ignored by ifDescr: npi1 (matched: /^npi[0-9]/) ignored by ifDescr: npi2 (matched: /^npi[0-9]/) ignored by ifDescr: npi3 (matched: /^npi[0-9]/) ignored by ifDescr: loop0 (matched: /^loop[0-9]/) ignored by ifDescr: loop1 (matched: /^loop[0-9]/) ignored by ifDescr: loop2 (matched: /^loop[0-9]/) ignored by ifDescr: loop3 (matched: /^loop[0-9]/) valid valid valid Port lo: lo (1 / #23) disabled. Port eth0: eth0 (2 / #24) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifHighSpeed (10) VLAN = eth024 skipped because port is still down since last polling. Port eth1: eth1 (3 / #25) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifHighSpeed (10) VLAN = eth125 skipped because port is still down since last polling. Port eth2: eth2 (4 / #26) disabled. Port eth3: eth3 (5 / #27) disabled. Port imq0: imq0 (14 / #141) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifHighSpeed (0) VLAN = imq0 ifInOctets (0 B) 0 Bps 141 secs ifOutOctets (0 B) 0 Bps 141 secs ifInErrors (0 B) 0 Bps 141 secs ifOutErrors (0 B) 0 Bps 141 secs ifInUcastPkts (0 B) 0 Bps 141 secs ifOutUcastPkts (0 B) 0 Bps 141 secs ifInNUcastPkts (0 B) 0 Bps 141 secs ifOutNUcastPkts (0 B) 0 Bps 141 secs ifInDiscards (0 B) 0 Bps 141 secs ifOutDiscards (0 B) 0 Bps 141 secs ifInUnknownProtos (0 B) 0 Bps 141 secs ifInBroadcastPkts (0 B) 0 Bps 141 secs ifOutBroadcastPkts (0 B) 0 Bps 141 secs ifInMulticastPkts (0 B) 0 Bps 141 secs ifOutMulticastPkts (0 B) 0 Bps 141 secs bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifSpeed_prev`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["0000000",0,0,0,0,0,0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,1641727352,1641727211,141,141][0m 5.67ms] 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,141][0m 0.94ms] 1 updated Port eth3.2: eth3.2 (15 / #159) ifHCInOctets ifHCOutOctets ifInUcastPkts ifHCOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifHCInMulticastPkts ifOutMulticastPkts ifHighSpeed (1000) VLAN = eth3.2@eth3 ifInOctets (426 B) 3.0212765957447 Bps 141 secs ifOutOctets (12868 B) 91.262411347518 Bps 141 secs ifInErrors (0 B) 0 Bps 141 secs ifOutErrors (0 B) 0 Bps 141 secs ifInUcastPkts (0 B) 0 Bps 141 secs ifOutUcastPkts (72 B) 0.51063829787234 Bps 141 secs ifInNUcastPkts (0 B) 0 Bps 141 secs ifOutNUcastPkts (0 B) 0 Bps 141 secs ifInDiscards (0 B) 0 Bps 141 secs ifOutDiscards (0 B) 0 Bps 141 secs ifInUnknownProtos (0 B) 0 Bps 141 secs ifInBroadcastPkts (0 B) 0 Bps 141 secs ifOutBroadcastPkts (0 B) 0 Bps 141 secs ifInMulticastPkts (7 B) 0.049645390070922 Bps 141 secs ifOutMulticastPkts (0 B) 0 Bps 141 secs bps(24 bps/730 bps)bytes(426 B/12.57 KiB)pkts(0 pps/0.51 pps)SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["151442",151016,3.021276595744681,426,"5028229",5015361,91.26241134751773,12868,"0",0,0,0,"0",0,0,0,0,0,0,0,"19246",19174,0.5106382978723404,72,1641727352,1641727211,141,159][0m 5.57ms] 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,"2389",2382,0.04964539007092199,7,"0",0,0,0,159][0m 5.65ms] 2 updated Port eth2.102: eth2.102 (16 / #235) ifHCInOctets ifHCOutOctets ifHCInUcastPkts ifHCOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifHCInMulticastPkts ifOutMulticastPkts ifHighSpeed (1000) VLAN = WAN ifInOctets (75473 B) 535.2695035461 Bps 141 secs ifOutOctets (90352 B) 640.79432624113 Bps 141 secs ifInErrors (0 B) 0 Bps 141 secs ifOutErrors (0 B) 0 Bps 141 secs ifInUcastPkts (493 B) 3.4964539007092 Bps 141 secs ifOutUcastPkts (566 B) 4.0141843971631 Bps 141 secs ifInNUcastPkts (0 B) 0 Bps 141 secs ifOutNUcastPkts (0 B) 0 Bps 141 secs ifInDiscards (0 B) 0 Bps 141 secs ifOutDiscards (0 B) 0 Bps 141 secs ifInUnknownProtos (0 B) 0 Bps 141 secs ifInBroadcastPkts (0 B) 0 Bps 141 secs ifOutBroadcastPkts (0 B) 0 Bps 141 secs ifInMulticastPkts (0 B) 0 Bps 141 secs ifOutMulticastPkts (0 B) 0 Bps 141 secs bps(4.28 Kbps/5.13 Kbps)bytes(73.7 KiB/88.23 KiB)pkts(3.5 pps/4.01 pps)SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["1570580520",1570505047,535.2695035460993,75473,"1598054959",1597964607,640.7943262411347,90352,"0",0,0,0,"0",0,0,0,"1429052",1428559,3.49645390070922,493,"1636041",1635475,4.01418439716312,566,1641727352,1641727211,141,235][0m 4.02ms] 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,"6",6,0,0,"0",0,0,0,235][0m 0.95ms] 1 updated SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where `port_id` in (?, ?) [0;33m[1641727352,1641727211,null,24,25][0m 1.83ms] 2 updated >> Runtime for poller module 'ports': 1.4049 seconds with 28648 bytes >> [0;36mSNMP[0m: [14/1.33s] [1;33mMySQL[0m: [10/0.29s] #### Unload poller module ports #### Modules status: Global+ OS Device #### Load poller module customoid #### SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[2][0m 0.62ms] >> Runtime for poller module 'customoid': 0.0016 seconds with 1064 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] #### Unload poller module customoid #### Modules status: Global- OS Device Module [ bgp-peers ] disabled globally. Modules status: Global- OS Device Module [ junose-atm-vp ] disabled globally. Modules status: Global- OS Device Module [ printer-supplies ] disabled globally. Modules status: Global+ OS Device #### Load poller module ucd-diskio #### SQL[[1;33mSELECT * FROM `ucd_diskio` WHERE `device_id` = ? [0;33m[2][0m 0.5ms] SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-DISKIO-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'diskIOEntry'[0m] diskIOIndex.1 = 1 diskIOIndex.2 = 2 diskIOIndex.3 = 3 diskIOIndex.4 = 4 diskIOIndex.5 = 5 diskIOIndex.6 = 6 diskIOIndex.7 = 7 diskIOIndex.8 = 8 diskIOIndex.9 = 9 diskIOIndex.10 = 10 diskIOIndex.11 = 11 diskIOIndex.12 = 12 diskIOIndex.13 = 13 diskIOIndex.14 = 14 diskIOIndex.15 = 15 diskIOIndex.16 = 16 diskIOIndex.17 = 17 diskIOIndex.18 = 18 diskIOIndex.19 = 19 diskIODevice.1 = loop0 diskIODevice.2 = loop1 diskIODevice.3 = loop2 diskIODevice.4 = loop3 diskIODevice.5 = loop4 diskIODevice.6 = loop5 diskIODevice.7 = loop6 diskIODevice.8 = loop7 diskIODevice.9 = mtdblock0 diskIODevice.10 = mtdblock1 diskIODevice.11 = mtdblock2 diskIODevice.12 = mmcblk0 diskIODevice.13 = mmcblk0p1 diskIODevice.14 = mmcblk0p2 diskIODevice.15 = mmcblk0p3 diskIODevice.16 = mmcblk0rpmb diskIODevice.17 = mmcblk0boot1 diskIODevice.18 = mmcblk0boot0 diskIODevice.19 = loop8 diskIONRead.1 = 0 diskIONRead.2 = 0 diskIONRead.3 = 0 diskIONRead.4 = 0 diskIONRead.5 = 0 diskIONRead.6 = 0 diskIONRead.7 = 0 diskIONRead.8 = 0 diskIONRead.9 = 0 diskIONRead.10 = 0 diskIONRead.11 = 18612224 diskIONRead.12 = 46225408 diskIONRead.13 = 0 diskIONRead.14 = 45687808 diskIONRead.15 = 533504 diskIONRead.16 = 0 diskIONRead.17 = 4096 diskIONRead.18 = 4096 diskIONRead.19 = 0 diskIONWritten.1 = 0 diskIONWritten.2 = 0 diskIONWritten.3 = 0 diskIONWritten.4 = 0 diskIONWritten.5 = 0 diskIONWritten.6 = 0 diskIONWritten.7 = 0 diskIONWritten.8 = 0 diskIONWritten.9 = 0 diskIONWritten.10 = 0 diskIONWritten.11 = 0 diskIONWritten.12 = 4325376 diskIONWritten.13 = 0 diskIONWritten.14 = 4308992 diskIONWritten.15 = 16384 diskIONWritten.16 = 0 diskIONWritten.17 = 0 diskIONWritten.18 = 0 diskIONWritten.19 = 0 diskIOReads.1 = 0 diskIOReads.2 = 0 diskIOReads.3 = 0 diskIOReads.4 = 0 diskIOReads.5 = 0 diskIOReads.6 = 0 diskIOReads.7 = 0 diskIOReads.8 = 0 diskIOReads.9 = 0 diskIOReads.10 = 0 diskIOReads.11 = 284 diskIOReads.12 = 1566 diskIOReads.13 = 0 diskIOReads.14 = 1474 diskIOReads.15 = 91 diskIOReads.16 = 0 diskIOReads.17 = 1 diskIOReads.18 = 1 diskIOReads.19 = 0 diskIOWrites.1 = 0 diskIOWrites.2 = 0 diskIOWrites.3 = 0 diskIOWrites.4 = 0 diskIOWrites.5 = 0 diskIOWrites.6 = 0 diskIOWrites.7 = 0 diskIOWrites.8 = 0 diskIOWrites.9 = 0 diskIOWrites.10 = 0 diskIOWrites.11 = 0 diskIOWrites.12 = 370 diskIOWrites.13 = 0 diskIOWrites.14 = 365 diskIOWrites.15 = 4 diskIOWrites.16 = 0 diskIOWrites.17 = 0 diskIOWrites.18 = 0 diskIOWrites.19 = 0 diskIOLA1.1 = 0 diskIOLA1.2 = 0 diskIOLA1.3 = 0 diskIOLA1.4 = 0 diskIOLA1.5 = 0 diskIOLA1.6 = 0 diskIOLA1.7 = 0 diskIOLA1.8 = 0 diskIOLA1.9 = 0 diskIOLA1.10 = 0 diskIOLA1.11 = 0 diskIOLA1.12 = 0 diskIOLA1.13 = 0 diskIOLA1.14 = 0 diskIOLA1.15 = 0 diskIOLA1.16 = 0 diskIOLA1.17 = 0 diskIOLA1.18 = 0 diskIOLA1.19 = 0 diskIOLA5.1 = 0 diskIOLA5.2 = 0 diskIOLA5.3 = 0 diskIOLA5.4 = 0 diskIOLA5.5 = 0 diskIOLA5.6 = 0 diskIOLA5.7 = 0 diskIOLA5.8 = 0 diskIOLA5.9 = 0 diskIOLA5.10 = 0 diskIOLA5.11 = 0 diskIOLA5.12 = 0 diskIOLA5.13 = 0 diskIOLA5.14 = 0 diskIOLA5.15 = 0 diskIOLA5.16 = 0 diskIOLA5.17 = 0 diskIOLA5.18 = 0 diskIOLA5.19 = 0 diskIOLA15.1 = 0 diskIOLA15.2 = 0 diskIOLA15.3 = 0 diskIOLA15.4 = 0 diskIOLA15.5 = 0 diskIOLA15.6 = 0 diskIOLA15.7 = 0 diskIOLA15.8 = 0 diskIOLA15.9 = 0 diskIOLA15.10 = 0 diskIOLA15.11 = 0 diskIOLA15.12 = 0 diskIOLA15.13 = 0 diskIOLA15.14 = 0 diskIOLA15.15 = 0 diskIOLA15.16 = 0 diskIOLA15.17 = 0 diskIOLA15.18 = 0 diskIOLA15.19 = 0 diskIONReadX.1 = 0 diskIONReadX.2 = 0 diskIONReadX.3 = 0 diskIONReadX.4 = 0 diskIONReadX.5 = 0 diskIONReadX.6 = 0 diskIONReadX.7 = 0 diskIONReadX.8 = 0 diskIONReadX.9 = 0 diskIONReadX.10 = 0 diskIONReadX.11 = 18612224 diskIONReadX.12 = 46225408 diskIONReadX.13 = 0 diskIONReadX.14 = 45687808 diskIONReadX.15 = 533504 diskIONReadX.16 = 0 diskIONReadX.17 = 4096 diskIONReadX.18 = 4096 diskIONReadX.19 = 0 diskIONWrittenX.1 = 0 diskIONWrittenX.2 = 0 diskIONWrittenX.3 = 0 diskIONWrittenX.4 = 0 diskIONWrittenX.5 = 0 diskIONWrittenX.6 = 0 diskIONWrittenX.7 = 0 diskIONWrittenX.8 = 0 diskIONWrittenX.9 = 0 diskIONWrittenX.10 = 0 diskIONWrittenX.11 = 0 diskIONWrittenX.12 = 4325376 diskIONWrittenX.13 = 0 diskIONWrittenX.14 = 4308992 diskIONWrittenX.15 = 16384 diskIONWrittenX.16 = 0 diskIONWrittenX.17 = 0 diskIONWrittenX.18 = 0 diskIONWrittenX.19 = 0 mtdblock2 array ( 'diskIOIndex' => '11', 'diskIODevice' => 'mtdblock2', 'diskIONRead' => '18612224', 'diskIONWritten' => '0', 'diskIOReads' => '284', 'diskIOWrites' => '0', 'diskIOLA1' => '0', 'diskIOLA5' => '0', 'diskIOLA15' => '0', 'diskIONReadX' => '18612224', 'diskIONWrittenX' => '0', ) mmcblk0 array ( 'diskIOIndex' => '12', 'diskIODevice' => 'mmcblk0', 'diskIONRead' => '46225408', 'diskIONWritten' => '4325376', 'diskIOReads' => '1566', 'diskIOWrites' => '370', 'diskIOLA1' => '0', 'diskIOLA5' => '0', 'diskIOLA15' => '0', 'diskIONReadX' => '46225408', 'diskIONWrittenX' => '4325376', ) mmcblk0p2 array ( 'diskIOIndex' => '14', 'diskIODevice' => 'mmcblk0p2', 'diskIONRead' => '45687808', 'diskIONWritten' => '4308992', 'diskIOReads' => '1474', 'diskIOWrites' => '365', 'diskIOLA1' => '0', 'diskIOLA5' => '0', 'diskIOLA15' => '0', 'diskIONReadX' => '45687808', 'diskIONWrittenX' => '4308992', ) mmcblk0p3 array ( 'diskIOIndex' => '15', 'diskIODevice' => 'mmcblk0p3', 'diskIONRead' => '533504', 'diskIONWritten' => '16384', 'diskIOReads' => '91', 'diskIOWrites' => '4', 'diskIOLA1' => '0', 'diskIOLA5' => '0', 'diskIOLA15' => '0', 'diskIONReadX' => '533504', 'diskIONWrittenX' => '16384', ) mmcblk0boot1 array ( 'diskIOIndex' => '17', 'diskIODevice' => 'mmcblk0boot1', 'diskIONRead' => '4096', 'diskIONWritten' => '0', 'diskIOReads' => '1', 'diskIOWrites' => '0', 'diskIOLA1' => '0', 'diskIOLA5' => '0', 'diskIOLA15' => '0', 'diskIONReadX' => '4096', 'diskIONWrittenX' => '0', ) mmcblk0boot0 array ( 'diskIOIndex' => '18', 'diskIODevice' => 'mmcblk0boot0', 'diskIONRead' => '4096', 'diskIONWritten' => '0', 'diskIOReads' => '1', 'diskIOWrites' => '0', 'diskIOLA1' => '0', 'diskIOLA5' => '0', 'diskIOLA15' => '0', 'diskIONReadX' => '4096', 'diskIONWrittenX' => '0', ) >> Runtime for poller module 'ucd-diskio': 0.0540 seconds with 4328 bytes >> [0;36mSNMP[0m: [1/0.05s] [1;33mMySQL[0m: [1/0.01s] #### Unload poller module ucd-diskio #### Modules status: Global+ OS Device #### Load poller module wifi #### >> Runtime for poller module 'wifi': 0.0003 seconds with 480 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module wifi #### Modules status: Global+ OS Device #### Load poller module wireless #### Attempting to initialize OS: edgeos OS initialized: LibreNMS\OS\Edgeos SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[2][0m 0.69ms] >> Runtime for poller module 'wireless': 0.0049 seconds with 83232 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] #### Unload poller module wireless #### Modules status: Global+ OS Device #### Load poller module ospf #### SQL[[1;33mselect * from `vrf_lite_cisco` where `vrf_lite_cisco`.`device_id` = ? and `vrf_lite_cisco`.`device_id` is not null [0;33m[2][0m 0.58ms] Processes: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUt' '-Os' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfGeneralGroup'[0m] ospfGeneralGroup = No Such Object available on this agent at this OID SQL[[1;33mdelete from `ospf_instances` where `ospf_instances`.`device_id` = ? and `ospf_instances`.`device_id` is not null and `context_name` = ? and 1 = 1 [0;33m[2,""][0m 0.85ms] 0 >> Runtime for poller module 'ospf': 0.0498 seconds with 77232 bytes >> [0;36mSNMP[0m: [1/0.04s] [1;33mMySQL[0m: [2/0.01s] #### Unload poller module ospf #### Modules status: Global- OS Device Module [ isis ] disabled globally. 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 [ slas ] 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-qfp ] disabled globally. Modules status: Global- OS Device Module [ cisco-vpdn ] disabled globally. Modules status: Global- OS Device Module [ nac ] 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 #### >> Runtime for poller module 'entity-physical': 0.0004 seconds with 456 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module entity-physical #### 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[2][0m 0.54ms] >> Runtime for poller module 'applications': 0.0014 seconds with 488 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] #### Unload poller module applications #### Modules status: Global+ OS Device #### Load poller module mib #### Warning: include(includes/polling/mib.inc.php): failed to open stream: No such file or directory in /opt/librenms/includes/polling/functions.inc.php on line 329 Warning: include(): Failed opening 'includes/polling/mib.inc.php' for inclusion (include_path='.:/usr/share/php') in /opt/librenms/includes/polling/functions.inc.php on line 329 >> Runtime for poller module 'mib': 0.0001 seconds with 0 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module mib #### Modules status: Global+ OS Device #### Load poller module stp #### SQL[[1;33mSELECT * FROM `stp` WHERE `device_id` = ? [0;33m[2][0m 0.57ms] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-m' 'RSTP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1dStpProtocolSpecification.0'[0m] No Such Object available on this agent at this OID >> Runtime for poller module 'stp': 0.0405 seconds with 2584 bytes >> [0;36mSNMP[0m: [1/0.04s] [1;33mMySQL[0m: [1/0.01s] #### Unload poller module stp #### Modules status: Global+ OS Device #### Load poller module ntp #### >> Runtime for poller module 'ntp': 0.0003 seconds with 328 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module ntp #### Modules status: Global- OS Device Module [ loadbalancers ] disabled globally. Modules status: Global- OS Device Module [ mef ] disabled globally. Modules status: Global+ OS Device #### Load poller module mpls #### >> Runtime for poller module 'mpls': 0.0011 seconds with 23136 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] #### Unload poller module mpls #### Enabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[2][0m 0.66ms] SQL[[1;33mUPDATE `devices` set `last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[3.552,2][0m 6.42ms] Updating 192.168.1.1 Polled in 3.552 seconds ### Start Device Groups ### SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.76ms] SQL[[1;33mselect `devices`.`device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id`, `device_group_device`.`device_id` as `pivot_device_id` from `devices` inner join `device_group_device` on `devices`.`device_id` = `device_group_device`.`device_id` where `device_group_device`.`device_group_id` in (1, 2, 3) [0;33m[][0m 1.75ms] SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[2][0m 0.76ms] Groups Added: Groups Removed: ### End Device Groups, runtime: 0.0287s ### #### Start Alerts #### SQL[[1;33mselect `device_groups`.*, `device_group_device`.`device_id` as `pivot_device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id` from `device_groups` inner join `device_group_device` on `device_groups`.`id` = `device_group_device`.`device_group_id` where `device_group_device`.`device_id` = ? [0;33m[2][0m 0.88ms] SQL[[1;33mselect exists(select * from `alert_schedule` where (`start` <= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time xss=removed> ?) or (time(`start`) > time(`end`) and (time(`end`) <= ? or time(`start`) > ?))) and (`recurring_day` like ? or `recurring_day` is null)))) and (exists (select * from `devices` inner join `alert_schedulables` on `devices`.`device_id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?) or exists (select * from `device_groups` inner join `alert_schedulables` on `device_groups`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` in (?)) or exists (select * from `locations` inner join `alert_schedulables` on `locations`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?))) as `exists` [0;33m["2022-01-09T11:22:32.598408Z","2022-01-09T11:22:32.598408Z",0,1,"11:22:32","11:22:32","11:22:32","11:22:32","[47m%","device",2,"device_group",2,"location",3][0m 3.29ms] SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[2][0m 2.02ms] SQL[[1;33mSELECT DISTINCT a.* FROM alert_rules a 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 = ?) 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 = ?)) 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 = ?)) LEFT JOIN device_group_device dg ON g.group_id=dg.device_group_id AND dg.device_id = ? WHERE a.disabled = 0 AND ( (d.device_id IS NULL AND g.group_id IS NULL) OR (a.invert_map = 0 AND (d.device_id=? OR dg.device_id=?)) 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)) ) [0;33m[2,2,2,2,2,2,2,2][0m 5.96ms] Rule [0;35m#2 (Device rebooted):[0m SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND devices.uptime < 100 xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed ports.ifOperStatus = "down" 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 [0;33m[2][0m 3.68ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[6,2][0m 0.71ms] Status: [0;34mNOCHG[0m Rule [0;35m#7 (Sensor over limit - Check Device Health Settings):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND sensors.sensor_current > sensors.sensor_limit AND sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[2][0m 2.52ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[7,2][0m 0.76ms] Status: [0;34mNOCHG[0m Rule [0;35m#9 (Service up/down):[0m SQL[[1;33mSELECT * FROM devices,services WHERE (devices.device_id = ? AND devices.device_id = services.device_id) AND services.service_status != 0 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[2][0m 2.33ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[9,2][0m 0.75ms] Status: [0;34mNOCHG[0m Rule [0;35m#15 (Synology NAS has a bad disk status):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND devices.os = "dsm" AND sensors.sensor_type = "diskStatusState" AND sensors.sensor_current = "[4-5]" [0;33m[2][0m 1.53ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[15,2][0m 0.49ms] Status: [0;34mNOCHG[0m Rule [0;35m#16 (Synology NAS has a failed status):[0m SQL[[1;33mSELECT * FROM devices,sensors WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id) AND devices.os = "dsm" AND sensors.sensor_type = "systemStatusState" AND sensors.sensor_current = 2 [0;33m[2][0m 1.52ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[16,2][0m 0.49ms] Status: [0;34mNOCHG[0m Rule [0;35m#17 (SSH Connections To):[0m SQL[[1;33mSELECT * FROM devices,applications WHERE (devices.device_id = ? AND devices.device_id = applications.device_id) AND applications.app_type = "'portactivity'" AND devices.device_id > 1 [0;33m[2][0m 1.47ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[17,2][0m 0.48ms] Status: [0;34mNOCHG[0m Rule [0;35m#21 (Device Down! Due to no ICMP response.):[0m SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND devices.status_reason = "icmp" [0;33m[2][0m 1.31ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[21,2][0m 0.48ms] Status: [0;34mNOCHG[0m #### End Alerts #### ./poller.php 192.168.1.1 2022-01-09 12:22:32 - 1 devices polled in 4.613 secs [0;36mSNMP[0m [33/2.19s]: Snmpget[14/0.62s] Snmpwalk[19/1.57s] [1;33mSQL[0m [86/1.70s]: Select[57/0.76s] Insert[1/0.09s] Update[27/0.83s] Delete[1/0.01s]