LibreNMS Poller SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.27ms] SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 0.23ms] SQL[[1;33mselect version() [0;33m[][0m 0.28ms] =================================== Version info: Commit SHA: 34de9dd77df4bf7bb3f30c89c93cb86620f8b780 Commit Date: 1631578375 DB Schema: 2021_08_26_093522_config_value_to_medium_text (217) PHP: 7.4.13 MySQL: 10.3.31-MariaDB-0ubuntu0.20.04.1 RRDTool: 1.7.2 SNMP: NET-SNMP 5.8 ==================================DEBUG! Updating os_def.cache Starting polling run: SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '10.180.7.1' ORDER BY `device_id` ASC [0;33m[][0m 0.86ms] SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[61][0m 0.83ms] SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[61][0m 0.29ms] Attempting to initialize OS: sophos-xg Attempting to initialize OS: sophos OS initialized as Generic Hostname: 10.180.7.1 Device ID: 61 OS: sophos-xg (sophos) Created directory : /opt/librenms/rrd/10.180.7.1/ SQL[[1;33mselect `hostname`, `overwrite_ip` from `devices` where `hostname` = ? limit 1 [0;33m["10.180.7.1"][0m 1.12ms] [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '10.180.7.1' response: {"xmt":3,"rcv":3,"loss":0,"min":68.0,"max":74.1,"avg":70.4,"dup":0,"exitcode":0} 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[61][0m 0.39ms] SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[3][0m 0.31ms] 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 `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["2021-09-14T10:24:03.678568Z","2021-09-14T10:24:03.678568Z",0,1,"10:24:03","10:24:03","10:24:03","10:24:03","[42m%","device",61,"location",3][0m 1.07ms] SQL[[1;33mINSERT IGNORE INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`,`debug`) VALUES (:xmt,:rcv,:loss,:min,:max,:avg,:device_id,NOW(),:debug) [0;33m{"xmt":3,"rcv":3,"loss":0,"min":68,"max":74.1,"avg":70.4,"device_id":61,"debug":"[]"}[0m 34.4ms] SQL[[1;33mUPDATE `devices` set `last_ping`=?,`last_ping_timetaken`=? WHERE device_id=? [0;33m["2021-09-14 15:54:03",70.4,61][0m 99.64ms] 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/sophos' 'udp:HOSTNAME:161' 'sysUpTime.0' 'sysName.0' 'sysObjectID.0' 'sysDescr.0'[0m] .*.*.0 = 1565873195 .*.*.0 = RSIL_Gurgoan_HUB .*.*.0 = .*.4.1.2604.5 .*.*.0 = Linux localhost 4.14.38 #2 SMP Sun Dec 6 01:19:34 UTC 2020 x86_64 SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQnUst' '-m' 'HOST-RESOURCES-MIB:SNMP-FRAMEWORK-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'snmpEngineTime.0' 'hrSystemUptime.0'[0m] snmpEngineTime.0 = 15658732 hrSystemUptime.0 = 1565885856 Uptime seconds: 15658859 Uptime: 181 days 5 hours 40 minutes 59 seconds >> Runtime for poller module 'core': 0.2067 seconds with 25496 bytes >> SNMP: [2/0.20s] MySQL: [0/0.00s] #### Unload poller module core #### Modules status: Global+ OS Device #### Load poller module availability #### SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[61][0m 0.48ms] SQL[[1;33mINSERT IGNORE INTO `availability` (`device_id`,`duration`) VALUES (:device_id,:duration) [0;33m{"device_id":61,"duration":"86400"}[0m 95.05ms] SQL[[1;33mINSERT IGNORE INTO `availability` (`device_id`,`duration`) VALUES (:device_id,:duration) [0;33m{"device_id":61,"duration":"604800"}[0m 33.17ms] SQL[[1;33mINSERT IGNORE INTO `availability` (`device_id`,`duration`) VALUES (:device_id,:duration) [0;33m{"device_id":61,"duration":"2592000"}[0m 66.82ms] SQL[[1;33mINSERT IGNORE INTO `availability` (`device_id`,`duration`) VALUES (:device_id,:duration) [0;33m{"device_id":61,"duration":"31536000"}[0m 32.8ms] Availability: SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[61][0m 0.38ms] SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[61,1631528644][0m 0.45ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,5][0m 31.15ms] 1 day : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[61,1631010244][0m 0.4ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,6][0m 32.31ms] 7 days : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[61,1629023044][0m 0.4ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,7][0m 32.28ms] 30 days : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[61,1600079044][0m 0.4ms] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,8][0m 32.27ms] 365 days : 100% >> Runtime for poller module 'availability': 0.3807 seconds with 104688 bytes >> SNMP: [0/0.00s] MySQL: [9/0.36s] #### Unload poller module availability #### Modules status: Global- OS Device Module [ unix-agent ] disabled globally. Modules status: Global+ OS Device #### Load poller module os #### Generic :( Location: Gurgoan Hardware: XG106_XN01_SFOS OS Version: 18.0.4 MR-4 OS Features: Serial: C1C0B9KBJJ89785 >> Runtime for poller module 'os': 0.0123 seconds with 98440 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] #### Unload poller module os #### Modules status: Global+ OS Device #### Load poller module ipmi #### SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[61][0m 0.55ms] array ( ) >> Runtime for poller module 'ipmi': 0.0102 seconds with 2992 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### 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[61][0m 0.48ms] >> Runtime for poller module 'sensors': 0.0110 seconds with 1584 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module sensors #### Modules status: Global+ OS Device #### Load poller module processors #### Attempting to initialize OS: sophos-xg Attempting to initialize OS: sophos OS initialized as Generic SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[61][0m 0.49ms] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQn' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' '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 = 78 .*.*.*609 = 35 array ( '.1.3.6.1.2.1.25.3.3.1.2.196608' => '78', '.1.3.6.1.2.1.25.3.3.1.2.196609' => '35', ) Intel Atom Processor E3930 @ 1.30GHz: 78% SQL[[1;33mUPDATE `processors` set `processor_usage`=? WHERE `processor_id` = ? [0;33m[78,53][0m 43.55ms] Intel Atom Processor E3930 @ 1.30GHz: 35% SQL[[1;33mUPDATE `processors` set `processor_usage`=? WHERE `processor_id` = ? [0;33m[35,54][0m 33.04ms] >> Runtime for poller module 'processors': 0.1656 seconds with 62384 bytes >> SNMP: [1/0.08s] MySQL: [3/0.08s] #### 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[61][0m 0.75ms] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQn' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' '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' '.1.3.6.1.2.1.25.2.3.1.6.10'[0m] .*.*.* = 3576472 .*.*.* = 4319896 .*.*.* = 160088 .*.*.* = 1096656 .*.*.* = 144276 .*.*.* = 743424 Free memory adjusted by availability calculation: 302.25 MiiB -> 1.49 GiiB hrstorage [system]: Physical memory: 60% 2.21 GiiB / 3.71 GiiB SQL[[1;33mupdate `mempools` set `mempool_perc` = ?, `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[60,2375401472,1603842048,92][0m 63.18ms] hrstorage [virtual]: Virtual memory: 75% 4.12 GiiB / 5.53 GiiB SQL[[1;33mupdate `mempools` set `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[4423573504,1513693184,93][0m 65.93ms] hrstorage [buffers]: Memory buffers: 46.34 MiiB / 3.71 GiiB SQL[[1;33mupdate `mempools` set `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[163930112,3815313408,94][0m 66.01ms] hrstorage [cached]: Cached memory: 28% 1.05 GiiB / 3.71 GiiB SQL[[1;33mupdate `mempools` set `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[1122975744,2856267776,95][0m 66.15ms] hrstorage [shared]: Shared memory: 40.89 MiiB / 3.71 GiiB SQL[[1;33mupdate `mempools` set `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[147738624,3831504896,96][0m 57.73ms] hrstorage [swap]: Swap space: 39r6 MiiB / 1.82 GiiB >> Runtime for poller module 'mempools': 0.4253 seconds with 121464 bytes >> SNMP: [1/0.08s] MySQL: [0/0.00s] #### Unload poller module mempools #### Modules status: Global+ OS Device #### Load poller module storage #### SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[61][0m 0.55ms] Storage /: hrstorage SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'hrStorageEntry'[0m] hrStorageIndex.1 = 1 hrStorageIndex.3 = 3 hrStorageIndex.6 = 6 hrStorageIndex.7 = 7 hrStorageIndex.8 = 8 hrStorageIndex.10 = 10 hrStorageIndex.31 = 31 hrStorageIndex.32 = 32 hrStorageIndex.33 = 33 hrStorageIndex.34 = 34 hrStorageIndex.35 = 35 hrStorageIndex.36 = 36 hrStorageType.1 = hrStorageRam hrStorageType.3 = hrStorageVirtualMemory hrStorageType.6 = hrStorageOther hrStorageType.7 = hrStorageOther hrStorageType.8 = hrStorageOther hrStorageType.10 = hrStorageVirtualMemory hrStorageType.31 = hrStorageFixedDisk hrStorageType.32 = hrStorageFixedDisk hrStorageType.33 = hrStorageFixedDisk hrStorageType.34 = hrStorageFixedDisk hrStorageType.35 = hrStorageFixedDisk hrStorageType.36 = 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.31 = / hrStorageDescr.32 = /boot hrStorageDescr.33 = /conf hrStorageDescr.34 = /content hrStorageDescr.35 = /var hrStorageDescr.36 = /cfs hrStorageAllocationUnits.1 = 1024 hrStorageAllocationUnits.3 = 1024 hrStorageAllocationUnits.6 = 1024 hrStorageAllocationUnits.7 = 1024 hrStorageAllocationUnits.8 = 1024 hrStorageAllocationUnits.10 = 1024 hrStorageAllocationUnits.31 = 4096 hrStorageAllocationUnits.32 = 1024 hrStorageAllocationUnits.33 = 1024 hrStorageAllocationUnits.34 = 1024 hrStorageAllocationUnits.35 = 4096 hrStorageAllocationUnits.36 = 512 hrStorageSize.1 = 3885980 hrStorageSize.3 = 5798112 hrStorageSize.6 = 3885980 hrStorageSize.7 = 1096656 hrStorageSize.8 = 144276 hrStorageSize.10 = 1912132 hrStorageSize.31 = 164828 hrStorageSize.32 = 130769 hrStorageSize.33 = 573765 hrStorageSize.34 = 5665198 hrStorageSize.35 = 11923219 hrStorageSize.36 = 0 hrStorageUsed.1 = 3576472 hrStorageUsed.3 = 4319896 hrStorageUsed.6 = 160088 hrStorageUsed.7 = 1096656 hrStorageUsed.8 = 144276 hrStorageUsed.10 = 743424 hrStorageUsed.31 = 897 hrStorageUsed.32 = 33354 hrStorageUsed.33 = 76994 hrStorageUsed.34 = 491251 hrStorageUsed.35 = 4137715 hrStorageUsed.36 = 0 array ( 'hrstorage' => array ( 1 => array ( 'hrStorageIndex' => '1', 'hrStorageType' => 'hrStorageRam', 'hrStorageDescr' => 'Physical memory', 'hrStorageAllocationUnits' => '1024', 'hrStorageSize' => '3885980', 'hrStorageUsed' => '3576472', ), 3 => array ( 'hrStorageIndex' => '3', 'hrStorageType' => 'hrStorageVirtualMemory', 'hrStorageDescr' => 'Virtual memory', 'hrStorageAllocationUnits' => '1024', 'hrStorageSize' => '5798112', 'hrStorageUsed' => '4319896', ), 6 => array ( 'hrStorageIndex' => '6', 'hrStorageType' => 'hrStorageOther', 'hrStorageDescr' => 'Memory buffers', 'hrStorageAllocationUnits' => '1024', 'hrStorageSize' => '3885980', 'hrStorageUsed' => '160088', ), 7 => array ( 'hrStorageIndex' => '7', 'hrStorageType' => 'hrStorageOther', 'hrStorageDescr' => 'Cached memory', 'hrStorageAllocationUnits' => '1024', 'hrStorageSize' => '1096656', 'hrStorageUsed' => '1096656', ), 8 => array ( 'hrStorageIndex' => '8', 'hrStorageType' => 'hrStorageOther', 'hrStorageDescr' => 'Shared memory', 'hrStorageAllocationUnits' => '1024', 'hrStorageSize' => '144276', 'hrStorageUsed' => '144276', ), 10 => array ( 'hrStorageIndex' => '10', 'hrStorageType' => 'hrStorageVirtualMemory', 'hrStorageDescr' => 'Swap space', 'hrStorageAllocationUnits' => '1024', 'hrStorageSize' => '1912132', 'hrStorageUsed' => '743424', ), 31 => array ( 'hrStorageIndex' => '31', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/', 'hrStorageAllocationUnits' => '4096', 'hrStorageSize' => '164828', 'hrStorageUsed' => '897', ), 32 => array ( 'hrStorageIndex' => '32', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/boot', 'hrStorageAllocationUnits' => '1024', 'hrStorageSize' => '130769', 'hrStorageUsed' => '33354', ), 33 => array ( 'hrStorageIndex' => '33', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/conf', 'hrStorageAllocationUnits' => '1024', 'hrStorageSize' => '573765', 'hrStorageUsed' => '76994', ), 34 => array ( 'hrStorageIndex' => '34', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/content', 'hrStorageAllocationUnits' => '1024', 'hrStorageSize' => '5665198', 'hrStorageUsed' => '491251', ), 35 => array ( 'hrStorageIndex' => '35', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/var', 'hrStorageAllocationUnits' => '4096', 'hrStorageSize' => '11923219', 'hrStorageUsed' => '4137715', ), 36 => array ( 'hrStorageIndex' => '36', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/cfs', 'hrStorageAllocationUnits' => '512', 'hrStorageSize' => '0', 'hrStorageUsed' => '0', ), ), ) array ( 'storage_id' => 16, 'device_id' => 61, 'storage_mib' => 'hrstorage', 'storage_index' => '31', 'storage_type' => 'hrStorageFixedDisk', 'storage_descr' => '/', 'storage_size' => 675135488, 'storage_units' => 4096, 'storage_used' => 3674112, 'storage_free' => 0, 'storage_perc' => 0, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '4096', 'used' => 3674112, 'size' => 675135488, 'free' => 671461376, ) 1% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["3674112","671461376","675135488","4096",1,16][0m 64.6ms] Storage /boot: hrstorage array ( 'storage_id' => 17, 'device_id' => 61, 'storage_mib' => 'hrstorage', 'storage_index' => '32', 'storage_type' => 'hrStorageFixedDisk', 'storage_descr' => '/boot', 'storage_size' => 133907456, 'storage_units' => 1024, 'storage_used' => 34154496, 'storage_free' => 0, 'storage_perc' => 0, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '1024', 'used' => 34154496, 'size' => 133907456, 'free' => 99752960, ) 26% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["34154496","99752960","133907456","1024",26,17][0m 66.03ms] Storage /conf: hrstorage array ( 'storage_id' => 18, 'device_id' => 61, 'storage_mib' => 'hrstorage', 'storage_index' => '33', 'storage_type' => 'hrStorageFixedDisk', 'storage_descr' => '/conf', 'storage_size' => 587535360, 'storage_units' => 1024, 'storage_used' => 78972928, 'storage_free' => 0, 'storage_perc' => 0, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '1024', 'used' => 78841856, 'size' => 587535360, 'free' => 508693504, ) 13% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["78841856","508693504","587535360","1024",13,18][0m 41.16ms] Storage /content: hrstorage array ( 'storage_id' => 19, 'device_id' => 61, 'storage_mib' => 'hrstorage', 'storage_index' => '34', 'storage_type' => 'hrStorageFixedDisk', 'storage_descr' => '/content', 'storage_size' => 5801162752, 'storage_units' => 1024, 'storage_used' => 503591936, 'storage_free' => 0, 'storage_perc' => 0, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '1024', 'used' => 503041024, 'size' => 5801162752, 'free' => 5298121728, ) 9% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["503041024","5298121728","5801162752","1024",9,19][0m 32.85ms] Storage /var: hrstorage array ( 'storage_id' => 20, 'device_id' => 61, 'storage_mib' => 'hrstorage', 'storage_index' => '35', 'storage_type' => 'hrStorageFixedDisk', 'storage_descr' => '/var', 'storage_size' => 48837505024, 'storage_units' => 4096, 'storage_used' => 16630874112, 'storage_free' => 0, 'storage_perc' => 0, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '4096', 'used' => 16948080640, 'size' => 48837505024, 'free' => 31889424384, ) 35% SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["16948080640","31889424384","48837505024","4096",35,20][0m 32.86ms] >> Runtime for poller module 'storage': 0.8742 seconds with 16408 bytes >> SNMP: [1/0.61s] MySQL: [6/0.24s] #### Unload poller module storage #### 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/sophos' 'udp:HOSTNAME:161' 'icmp'[0m] icmpInMsgs.0 = 4156402 icmpInErrors.0 = 118 icmpInDestUnreachs.0 = 34463 icmpInTimeExcds.0 = 3398 icmpInParmProbs.0 = 0 icmpInSrcQuenchs.0 = 0 icmpInRedirects.0 = 741 icmpInEchos.0 = 3594919 icmpInEchoReps.0 = 522881 icmpInTimestamps.0 = 0 icmpInTimestampReps.0 = 0 icmpInAddrMasks.0 = 0 icmpInAddrMaskReps.0 = 0 icmpOutMsgs.0 = 4464915 icmpOutErrors.0 = 0 icmpOutDestUnreachs.0 = 341118 icmpOutTimeExcds.0 = 3421 icmpOutParmProbs.0 = 0 icmpOutSrcQuenchs.0 = 0 icmpOutRedirects.0 = 29 icmpOutEchos.0 = 525442 icmpOutEchoReps.0 = 3594905 icmpOutTimestamps.0 = 0 icmpOutTimestampReps.0 = 0 icmpOutAddrMasks.0 = 0 icmpOutAddrMaskReps.0 = 0 icmpStatsInMsgs.ipv4 = 4156402 icmpStatsInMsgs.ipv6 = 112685 icmpStatsInErrors.ipv4 = 118 icmpStatsInErrors.ipv6 = 0 icmpStatsOutMsgs.ipv4 = 4464915 icmpStatsOutMsgs.ipv6 = 86 icmpStatsOutErrors.ipv4 = 0 icmpStatsOutErrors.ipv6 = 0 icmpMsgStatsInPkts.ipv4.0 = 522881 icmpMsgStatsInPkts.ipv4.3 = 34463 icmpMsgStatsInPkts.ipv4.4 = 0 icmpMsgStatsInPkts.ipv4.5 = 741 icmpMsgStatsInPkts.ipv4.8 = 3594919 icmpMsgStatsInPkts.ipv4.11 = 3398 icmpMsgStatsInPkts.ipv4.12 = 0 icmpMsgStatsInPkts.ipv4.13 = 0 icmpMsgStatsInPkts.ipv4.14 = 0 icmpMsgStatsInPkts.ipv4.17 = 0 icmpMsgStatsInPkts.ipv4.18 = 0 icmpMsgStatsInPkts.ipv6.128 = 2 icmpMsgStatsInPkts.ipv6.132 = 151 icmpMsgStatsInPkts.ipv6.133 = 88751 icmpMsgStatsInPkts.ipv6.135 = 2 icmpMsgStatsInPkts.ipv6.136 = 23779 icmpMsgStatsOutPkts.ipv4.0 = 3594905 icmpMsgStatsOutPkts.ipv4.3 = 341118 icmpMsgStatsOutPkts.ipv4.4 = 0 icmpMsgStatsOutPkts.ipv4.5 = 29 icmpMsgStatsOutPkts.ipv4.8 = 525442 icmpMsgStatsOutPkts.ipv4.11 = 3421 icmpMsgStatsOutPkts.ipv4.12 = 0 icmpMsgStatsOutPkts.ipv4.13 = 0 icmpMsgStatsOutPkts.ipv4.14 = 0 icmpMsgStatsOutPkts.ipv4.17 = 0 icmpMsgStatsOutPkts.ipv4.18 = 0 icmpMsgStatsOutPkts.ipv6.129 = 2 icmpMsgStatsOutPkts.ipv6.133 = 2 icmpMsgStatsOutPkts.ipv6.135 = 4 icmpMsgStatsOutPkts.ipv6.136 = 2 icmpMsgStatsOutPkts.ipv6.143 = 76 IPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'ipForwDatagrams' 'ipInDelivers' 'ipInReceives' 'ipOutRequests' 'ipInDiscards' 'ipOutDiscards' 'ipOutNoRoutes' 'ipReasmReqds' 'ipReasmOKs' 'ipReasmFails' 'ipFragOKs' 'ipFragFails' 'ipFragCreates' 'ipInUnknownProtos' 'ipInHdrErrors' 'ipInAddrErrors'[0m] ipForwDatagrams.0 = 1988288292 ipInDelivers.0 = 1457738991 ipInReceives.0 = 0 ipOutRequests.0 = 2147483647 ipInDiscards.0 = 0 ipOutDiscards.0 = 2007 ipOutNoRoutes.0 = 4443 ipReasmReqds.0 = 725965 ipReasmOKs.0 = 360025 ipReasmFails.0 = 1130 ipFragOKs.0 = 325887 ipFragFails.0 = 250 ipFragCreates.0 = 656429 ipInUnknownProtos.0 = 0 ipInHdrErrors.0 = 2778 ipInAddrErrors.0 = 0 IP-FORWARDSNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQv' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m] No Such Object available on this agent at this OID SNMPSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'snmp'[0m] snmpInPkts.0 = 106454957 snmpOutPkts.0 = 106455487 snmpInBadVersions.0 = 0 snmpInBadCommunityNames.0 = 177 snmpInBadCommunityUses.0 = 0 snmpInASNParseErrs.0 = 0 snmpInTooBigs.0 = 0 snmpInNoSuchNames.0 = 0 snmpInBadValues.0 = 0 snmpInReadOnlys.0 = 0 snmpInGenErrs.0 = 0 snmpInTotalReqVars.0 = 106460492 snmpInTotalSetVars.0 = 0 snmpInGetRequests.0 = 6262673 snmpInGetNexts.0 = 100191525 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 = 106454781 snmpOutTraps.0 = 708 snmpEnableAuthenTraps.0 = enabled snmpSilentDrops.0 = 0 snmpProxyDrops.0 = 0 TCPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'tcpActiveOpens' 'tcpPassiveOpens' 'tcpAttemptFails' 'tcpEstabResets' 'tcpCurrEstab' 'tcpInSegs' 'tcpOutSegs' 'tcpRetransSegs' 'tcpInErrs' 'tcpOutRsts'[0m] tcpActiveOpens.0 = 11649725 tcpPassiveOpens.0 = 17063892 tcpAttemptFails.0 = 152738 tcpEstabResets.0 = 4213944 tcpCurrEstab.0 = 414 tcpInSegs.0 = 970144492 tcpOutSegs.0 = 934669352 tcpRetransSegs.0 = 3863592 tcpInErrs.0 = 52628 tcpOutRsts.0 = 2942560 TCPHCSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'TCP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'tcpHCInSegs.0' 'tcpHCOutSegs.0'[0m] tcpConnectionState.ipv4."*".2712.ipv4."*".34851 = established tcpConnectionState.ipv4."*".2712.ipv4."*".34851 = established UDPSNMP[[0;36m'/usr/bin/snmpgetnext' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UDP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'udpInDatagrams' 'udpOutDatagrams' 'udpInErrors' 'udpNoPorts'[0m] udpInDatagrams.0 = 379065365 udpOutDatagrams.0 = 378853608 udpInErrors.0 = 1073227 udpNoPorts.0 = 24842 >> Runtime for poller module 'netstats': 1.5558 seconds with 3248 bytes >> SNMP: [7/1.51s] MySQL: [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:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m] hrSystemProcesses.0 = No Such Instance currently exists at this OID hrSystemNumUsers.0 = 0 Users >> Runtime for poller module 'hr-mib': 0.1047 seconds with 3256 bytes >> SNMP: [1/0.09s] MySQL: [0/0.00s] #### 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:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'systemStats'[0m] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m] Exitcode: 1 Timeout: No Response from udp:10.180.7.1:161. Timeout: No Response from udp:10.180.7.1:161. >> Runtime for poller module 'ucd-mib': 17.3317 seconds with 1936 bytes >> SNMP: [2/17.30s] MySQL: [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:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'ipSystemStats'[0m] Exitcode: 1 Timeout: No Response from udp:10.180.7.1:161 Timeout: No Response from udp:10.180.7.1:161 >> Runtime for poller module 'ipSystemStats': 6.0286 seconds with 1976 bytes >> SNMP: [1/6.03s] MySQL: [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[61][0m 1.8ms] 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/sophos' 'udp:HOSTNAME:161' 'ifXEntry'[0m] Exitcode: 1 Timeout: No Response from udp:10.180.7.1:161 Timeout: No Response from udp:10.180.7.1:161 SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'ifEntry'[0m] ifIndex.1 = 1 ifIndex.2 = 2 ifIndex.3 = 3 ifIndex.4 = 4 ifIndex.5 = 5 ifIndex.6 = 6 ifIndex.7 = 7 ifIndex.8 = 8 ifIndex.9 = 9 ifIndex.11 = 11 ifIndex.12 = 12 ifIndex.13 = 13 ifIndex.14 = 14 ifIndex.15 = 15 ifIndex.99 = 99 ifDescr.1 = lo ifDescr.2 = ipsec0 ifDescr.3 = sit0 ifDescr.4 = ip6tnl0 ifDescr.5 = Port4 ifDescr.6 = Port1 ifDescr.7 = Port2 ifDescr.8 = Port3 ifDescr.9 = ifb0 ifDescr.11 = gre0 ifDescr.12 = gretap0 ifDescr.13 = erspan0 ifDescr.14 = host0 ifDescr.15 = host1 ifDescr.99 = spq ifType.1 = softwareLoopback ifType.2 = ethernetCsmacd ifType.3 = tunnel ifType.4 = tunnel ifType.5 = ethernetCsmacd ifType.6 = ethernetCsmacd ifType.7 = ethernetCsmacd ifType.8 = ethernetCsmacd ifType.9 = ethernetCsmacd ifType.11 = tunnel ifType.12 = ethernetCsmacd ifType.13 = ethernetCsmacd ifType.14 = ethernetCsmacd ifType.15 = ethernetCsmacd ifType.99 = ethernetCsmacd ifMtu.1 = 65536 ifMtu.2 = 16260 ifMtu.3 = 1480 ifMtu.4 = 1452 ifMtu.5 = 1500 ifMtu.6 = 1500 ifMtu.7 = 1500 ifMtu.8 = 1500 ifMtu.9 = 1500 ifMtu.11 = 1476 ifMtu.12 = 1462 ifMtu.13 = 1450 ifMtu.14 = 1500 ifMtu.15 = 1500 ifMtu.99 = 1500 ifSpeed.1 = 10000000 ifSpeed.2 = 0 ifSpeed.3 = 0 ifSpeed.4 = 0 ifSpeed.5 = 0 ifSpeed.6 = 1000000000 ifSpeed.7 = 100000000 ifSpeed.8 = 100000000 ifSpeed.9 = 0 ifSpeed.11 = 0 ifSpeed.12 = 0 ifSpeed.13 = 0 ifSpeed.14 = 0 ifSpeed.15 = 0 ifSpeed.99 = 0 ifPhysAddress.1 = ifPhysAddress.2 = 42:b1:fa:bb:7d:a2 ifPhysAddress.3 = ifPhysAddress.4 = ifPhysAddress.5 = 7c:5a:1c:d8:cb:63 ifPhysAddress.6 = 7c:5a:1c:d8:cb:60 ifPhysAddress.7 = 7c:5a:1c:d8:cb:61 ifPhysAddress.8 = 7c:5a:1c:d8:cb:62 ifPhysAddress.9 = 76:10:4e:a6:67:bb ifPhysAddress.11 = ifPhysAddress.12 = ifPhysAddress.13 = ifPhysAddress.14 = e2:98:4b:8a:7a:ae ifPhysAddress.15 = 5e:e9:7b:59:a5:2c ifPhysAddress.99 = 6:94:f:2:ee:18 ifAdminStatus.1 = up ifAdminStatus.2 = up ifAdminStatus.3 = down ifAdminStatus.4 = down ifAdminStatus.5 = down ifAdminStatus.6 = up ifAdminStatus.7 = up ifAdminStatus.8 = up ifAdminStatus.9 = up ifAdminStatus.11 = down ifAdminStatus.12 = down ifAdminStatus.13 = down ifAdminStatus.14 = down ifAdminStatus.15 = down ifAdminStatus.99 = down ifOperStatus.1 = up ifOperStatus.2 = up ifOperStatus.3 = down ifOperStatus.4 = down ifOperStatus.5 = down ifOperStatus.6 = up ifOperStatus.7 = up ifOperStatus.8 = up ifOperStatus.9 = up ifOperStatus.11 = down ifOperStatus.12 = down ifOperStatus.13 = down ifOperStatus.14 = down ifOperStatus.15 = down ifOperStatus.99 = down ifLastChange.1 = 0 ifLastChange.2 = 0 ifLastChange.3 = 0 ifLastChange.4 = 0 ifLastChange.5 = 0 ifLastChange.6 = 19641746 ifLastChange.7 = 1402107491 ifLastChange.8 = 1152479208 ifLastChange.9 = 0 ifLastChange.11 = 0 ifLastChange.12 = 0 ifLastChange.13 = 0 ifLastChange.14 = 0 ifLastChange.15 = 0 ifLastChange.99 = 1556561242 ifInOctets.1 = 2250756416 ifInOctets.2 = 0 ifInOctets.3 = 0 ifInOctets.4 = 0 ifInOctets.5 = 0 ifInOctets.6 = 54416364 ifInOctets.7 = 110949207 ifInOctets.8 = 3927296175 ifInOctets.9 = 639744849 ifInOctets.11 = 0 ifInOctets.12 = 0 ifInOctets.13 = 0 ifInOctets.14 = 0 ifInOctets.15 = 0 ifInOctets.99 = 0 ifInUcastPkts.1 = 612848820 ifInUcastPkts.2 = 0 ifInUcastPkts.3 = 0 ifInUcastPkts.4 = 0 ifInUcastPkts.5 = 0 ifInUcastPkts.6 = 879247321 ifInUcastPkts.7 = 1721348769 ifInUcastPkts.8 = 244818714 ifInUcastPkts.9 = 2617134357 ifInUcastPkts.11 = 0 ifInUcastPkts.12 = 0 ifInUcastPkts.13 = 0 ifInUcastPkts.14 = 0 ifInUcastPkts.15 = 0 ifInUcastPkts.99 = 0 ifInNUcastPkts.1 = 0 ifInNUcastPkts.2 = 0 ifInNUcastPkts.3 = 0 ifInNUcastPkts.4 = 0 ifInNUcastPkts.5 = 0 ifInNUcastPkts.6 = 1498943 ifInNUcastPkts.7 = 1 ifInNUcastPkts.8 = 66918 ifInNUcastPkts.9 = 0 ifInNUcastPkts.11 = 0 ifInNUcastPkts.12 = 0 ifInNUcastPkts.13 = 0 ifInNUcastPkts.14 = 0 ifInNUcastPkts.15 = 0 ifInNUcastPkts.99 = 0 ifInDiscards.1 = 0 ifInDiscards.2 = 0 ifInDiscards.3 = 0 ifInDiscards.4 = 0 ifInDiscards.5 = 0 ifInDiscards.6 = 0 ifInDiscards.7 = 1 ifInDiscards.8 = 0 ifInDiscards.9 = 0 ifInDiscards.11 = 0 ifInDiscards.12 = 0 ifInDiscards.13 = 0 ifInDiscards.14 = 0 ifInDiscards.15 = 0 ifInDiscards.99 = 0 ifInErrors.1 = 0 ifInErrors.2 = 0 ifInErrors.3 = 0 ifInErrors.4 = 0 ifInErrors.5 = 0 ifInErrors.6 = 0 ifInErrors.7 = 0 ifInErrors.8 = 7 ifInErrors.9 = 0 ifInErrors.11 = 0 ifInErrors.12 = 0 ifInErrors.13 = 0 ifInErrors.14 = 0 ifInErrors.15 = 0 ifInErrors.99 = 0 ifInUnknownProtos.1 = 0 ifInUnknownProtos.2 = 0 ifInUnknownProtos.3 = 0 ifInUnknownProtos.4 = 0 ifInUnknownProtos.5 = 0 ifInUnknownProtos.6 = 0 ifInUnknownProtos.7 = 0 ifInUnknownProtos.8 = 0 ifInUnknownProtos.9 = 0 ifInUnknownProtos.11 = 0 ifInUnknownProtos.12 = 0 ifInUnknownProtos.13 = 0 ifInUnknownProtos.14 = 0 ifInUnknownProtos.15 = 0 ifInUnknownProtos.99 = 0 ifOutOctets.1 = 2250756416 ifOutOctets.2 = 0 ifOutOctets.3 = 0 ifOutOctets.4 = 0 ifOutOctets.5 = 0 ifOutOctets.6 = 1463792792 ifOutOctets.7 = 4060966186 ifOutOctets.8 = 1216287765 ifOutOctets.9 = 639744849 ifOutOctets.11 = 0 ifOutOctets.12 = 0 ifOutOctets.13 = 0 ifOutOctets.14 = 0 ifOutOctets.15 = 0 ifOutOctets.99 = 0 ifOutUcastPkts.1 = 612848820 ifOutUcastPkts.2 = 0 ifOutUcastPkts.3 = 0 ifOutUcastPkts.4 = 0 ifOutUcastPkts.5 = 0 ifOutUcastPkts.6 = 1211928728 ifOutUcastPkts.7 = 1046423805 ifOutUcastPkts.8 = 438787220 ifOutUcastPkts.9 = 2617134357 ifOutUcastPkts.11 = 0 ifOutUcastPkts.12 = 0 ifOutUcastPkts.13 = 0 ifOutUcastPkts.14 = 0 ifOutUcastPkts.15 = 0 ifOutUcastPkts.99 = 0 ifOutNUcastPkts.1 = 0 ifOutNUcastPkts.2 = 0 ifOutNUcastPkts.3 = 0 ifOutNUcastPkts.4 = 0 ifOutNUcastPkts.5 = 0 ifOutNUcastPkts.6 = 0 ifOutNUcastPkts.7 = 0 ifOutNUcastPkts.8 = 0 ifOutNUcastPkts.9 = 0 ifOutNUcastPkts.11 = 0 ifOutNUcastPkts.12 = 0 ifOutNUcastPkts.13 = 0 ifOutNUcastPkts.14 = 0 ifOutNUcastPkts.15 = 0 ifOutNUcastPkts.99 = 0 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.11 = 0 ifOutDiscards.12 = 0 ifOutDiscards.13 = 0 ifOutDiscards.14 = 0 ifOutDiscards.15 = 0 ifOutDiscards.99 = 0 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.11 = 0 ifOutErrors.12 = 0 ifOutErrors.13 = 0 ifOutErrors.14 = 0 ifOutErrors.15 = 0 ifOutErrors.99 = 0 ifOutQLen.1 = 0 ifOutQLen.2 = 0 ifOutQLen.3 = 0 ifOutQLen.4 = 0 ifOutQLen.5 = 0 ifOutQLen.6 = 0 ifOutQLen.7 = 0 ifOutQLen.8 = 0 ifOutQLen.9 = 0 ifOutQLen.11 = 0 ifOutQLen.12 = 0 ifOutQLen.13 = 0 ifOutQLen.14 = 0 ifOutQLen.15 = 0 ifOutQLen.99 = 0 ifSpecific.1 = zeroDotZero ifSpecific.2 = zeroDotZero ifSpecific.3 = zeroDotZero ifSpecific.4 = zeroDotZero ifSpecific.5 = zeroDotZero ifSpecific.6 = zeroDotZero ifSpecific.7 = zeroDotZero ifSpecific.8 = zeroDotZero ifSpecific.9 = zeroDotZero ifSpecific.11 = zeroDotZero ifSpecific.12 = zeroDotZero ifSpecific.13 = zeroDotZero ifSpecific.14 = zeroDotZero ifSpecific.15 = zeroDotZero ifSpecific.99 = zeroDotZero dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m] dot3StatsDuplexStatus.1.1.3 = * dot3StatsDuplexStatus.1.1.4 = * dot3StatsDuplexStatus.1.2.3 = * dot3StatsDuplexStatus.1.2.4 = * dot3StatsDuplexStatus.1.3.3 = halfDuplex dot3StatsDuplexStatus.1.3.4 = halfDuplex dot3StatsDuplexStatus.1.4.3 = 64 dot3StatsDuplexStatus.1.4.4 = 0 dot3StatsDuplexStatus.1.5.3 = unknown dot3StatsDuplexStatus.1.5.4 = unknown dot3StatsDuplexStatus.1.6.3 = 0 dot3StatsDuplexStatus.1.6.4 = 0 SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' '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') [0;33m[61][0m 0.97ms] array ( 1 => array ( 'ifIndex' => '1', 'ifDescr' => 'lo', 'ifType' => 'softwareLoopback', 'ifMtu' => '65536', 'ifSpeed' => '10000000', 'ifPhysAddress' => '', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '0', 'ifInOctets' => '2250756416', 'ifInUcastPkts' => '612848820', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '2250756416', 'ifOutUcastPkts' => '612848820', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 2 => array ( 'ifIndex' => '2', 'ifDescr' => 'ipsec0', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '16260', 'ifSpeed' => '0', 'ifPhysAddress' => '42:b1:fa:bb:7d:a2', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '0', 'ifInOctets' => '0', 'ifInUcastPkts' => '0', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '0', 'ifOutUcastPkts' => '0', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 3 => array ( 'ifIndex' => '3', 'ifDescr' => 'sit0', 'ifType' => 'tunnel', 'ifMtu' => '1480', 'ifSpeed' => '0', 'ifPhysAddress' => '', 'ifAdminStatus' => 'down', 'ifOperStatus' => 'down', 'ifLastChange' => '0', 'ifInOctets' => '0', 'ifInUcastPkts' => '0', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '0', 'ifOutUcastPkts' => '0', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 4 => array ( 'ifIndex' => '4', 'ifDescr' => 'ip6tnl0', 'ifType' => 'tunnel', 'ifMtu' => '1452', 'ifSpeed' => '0', 'ifPhysAddress' => '', 'ifAdminStatus' => 'down', 'ifOperStatus' => 'down', 'ifLastChange' => '0', 'ifInOctets' => '0', 'ifInUcastPkts' => '0', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '0', 'ifOutUcastPkts' => '0', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 5 => array ( 'ifIndex' => '5', 'ifDescr' => 'Port4', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '1500', 'ifSpeed' => '0', 'ifPhysAddress' => '7c:5a:1c:d8:cb:63', 'ifAdminStatus' => 'down', 'ifOperStatus' => 'down', 'ifLastChange' => '0', 'ifInOctets' => '0', 'ifInUcastPkts' => '0', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '0', 'ifOutUcastPkts' => '0', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 6 => array ( 'ifIndex' => '6', 'ifDescr' => 'Port1', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '1500', 'ifSpeed' => '1000000000', 'ifPhysAddress' => '7c:5a:1c:d8:cb:60', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '19641746', 'ifInOctets' => '54416364', 'ifInUcastPkts' => '879247321', 'ifInNUcastPkts' => '1498943', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '1463792792', 'ifOutUcastPkts' => '1211928728', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 7 => array ( 'ifIndex' => '7', 'ifDescr' => 'Port2', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '1500', 'ifSpeed' => '100000000', 'ifPhysAddress' => '7c:5a:1c:d8:cb:61', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '1402107491', 'ifInOctets' => '110949207', 'ifInUcastPkts' => '1721348769', 'ifInNUcastPkts' => '1', 'ifInDiscards' => '1', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '4060966186', 'ifOutUcastPkts' => '1046423805', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 8 => array ( 'ifIndex' => '8', 'ifDescr' => 'Port3', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '1500', 'ifSpeed' => '100000000', 'ifPhysAddress' => '7c:5a:1c:d8:cb:62', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '1152479208', 'ifInOctets' => '3927296175', 'ifInUcastPkts' => '244818714', 'ifInNUcastPkts' => '66918', 'ifInDiscards' => '0', 'ifInErrors' => '7', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '1216287765', 'ifOutUcastPkts' => '438787220', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 9 => array ( 'ifIndex' => '9', 'ifDescr' => 'ifb0', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '1500', 'ifSpeed' => '0', 'ifPhysAddress' => '76:10:4e:a6:67:bb', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifLastChange' => '0', 'ifInOctets' => '639744849', 'ifInUcastPkts' => '2617134357', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '639744849', 'ifOutUcastPkts' => '2617134357', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 11 => array ( 'ifIndex' => '11', 'ifDescr' => 'gre0', 'ifType' => 'tunnel', 'ifMtu' => '1476', 'ifSpeed' => '0', 'ifPhysAddress' => '', 'ifAdminStatus' => 'down', 'ifOperStatus' => 'down', 'ifLastChange' => '0', 'ifInOctets' => '0', 'ifInUcastPkts' => '0', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '0', 'ifOutUcastPkts' => '0', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 12 => array ( 'ifIndex' => '12', 'ifDescr' => 'gretap0', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '1462', 'ifSpeed' => '0', 'ifPhysAddress' => '', 'ifAdminStatus' => 'down', 'ifOperStatus' => 'down', 'ifLastChange' => '0', 'ifInOctets' => '0', 'ifInUcastPkts' => '0', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '0', 'ifOutUcastPkts' => '0', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 13 => array ( 'ifIndex' => '13', 'ifDescr' => 'erspan0', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '1450', 'ifSpeed' => '0', 'ifPhysAddress' => '', 'ifAdminStatus' => 'down', 'ifOperStatus' => 'down', 'ifLastChange' => '0', 'ifInOctets' => '0', 'ifInUcastPkts' => '0', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '0', 'ifOutUcastPkts' => '0', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 14 => array ( 'ifIndex' => '14', 'ifDescr' => 'host0', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '1500', 'ifSpeed' => '0', 'ifPhysAddress' => 'e2:98:4b:8a:7a:ae', 'ifAdminStatus' => 'down', 'ifOperStatus' => 'down', 'ifLastChange' => '0', 'ifInOctets' => '0', 'ifInUcastPkts' => '0', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '0', 'ifOutUcastPkts' => '0', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 15 => array ( 'ifIndex' => '15', 'ifDescr' => 'host1', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '1500', 'ifSpeed' => '0', 'ifPhysAddress' => '5e:e9:7b:59:a5:2c', 'ifAdminStatus' => 'down', 'ifOperStatus' => 'down', 'ifLastChange' => '0', 'ifInOctets' => '0', 'ifInUcastPkts' => '0', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '0', 'ifOutUcastPkts' => '0', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 99 => array ( 'ifIndex' => '99', 'ifDescr' => 'spq', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '1500', 'ifSpeed' => '0', 'ifPhysAddress' => '6:94:f:2:ee:18', 'ifAdminStatus' => 'down', 'ifOperStatus' => 'down', 'ifLastChange' => '1556561242', 'ifInOctets' => '0', 'ifInUcastPkts' => '0', 'ifInNUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifInUnknownProtos' => '0', 'ifOutOctets' => '0', 'ifOutUcastPkts' => '0', 'ifOutNUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), '1.1.3' => array ( 'dot3StatsDuplexStatus' => '0.0.0.0', ), '1.1.4' => array ( 'dot3StatsDuplexStatus' => '0.0.0.0', ), '1.2.3' => array ( 'dot3StatsDuplexStatus' => '0.0.0.0', ), '1.2.4' => array ( 'dot3StatsDuplexStatus' => '0.0.0.0', ), '1.3.3' => array ( 'dot3StatsDuplexStatus' => 'halfDuplex', ), '1.3.4' => array ( 'dot3StatsDuplexStatus' => 'halfDuplex', ), '1.4.3' => array ( 'dot3StatsDuplexStatus' => '64', ), '1.4.4' => array ( 'dot3StatsDuplexStatus' => '0', ), '1.5.3' => array ( 'dot3StatsDuplexStatus' => 'unknown', ), '1.5.4' => array ( 'dot3StatsDuplexStatus' => 'unknown', ), '1.6.3' => array ( 'dot3StatsDuplexStatus' => '0', ), '1.6.4' => array ( 'dot3StatsDuplexStatus' => '0', ), ) valid SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`) VALUES (:port_id) [0;33m{"port_id":1131}[0m 35.31ms] valid SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`) VALUES (:port_id) [0;33m{"port_id":1132}[0m 32.96ms] valid SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`) VALUES (:port_id) [0;33m{"port_id":1133}[0m 33.05ms] valid SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`) VALUES (:port_id) [0;33m{"port_id":1134}[0m 116.46ms] valid SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`) VALUES (:port_id) [0;33m{"port_id":1135}[0m 74.57ms] valid SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`) VALUES (:port_id) [0;33m{"port_id":1136}[0m 33.04ms] valid SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`) VALUES (:port_id) [0;33m{"port_id":1137}[0m 33.02ms] valid SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`) VALUES (:port_id) [0;33m{"port_id":1138}[0m 32.98ms] valid SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`) VALUES (:port_id) [0;33m{"port_id":1139}[0m 32.99ms] valid SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`) VALUES (:port_id) [0;33m{"port_id":1140}[0m 32.95ms] valid SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`) VALUES (:port_id) [0;33m{"port_id":1141}[0m 33.01ms] valid SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`) VALUES (:port_id) [0;33m{"port_id":1142}[0m 32.94ms] valid SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`) VALUES (:port_id) [0;33m{"port_id":1143}[0m 33.01ms] valid SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`) VALUES (:port_id) [0;33m{"port_id":1144}[0m 41.38ms] valid SQL[[1;33mINSERT IGNORE INTO `ports_statistics` (`port_id`) VALUES (:port_id) [0;33m{"port_id":1214}[0m 32.96ms] ignored: empty ifDescr, ifAlias and ifName SQL[[1;33mUPDATE `ports` set `deleted`=? WHERE `port_id` = ? [0;33m["1",null][0m 0.22ms] ignored: empty ifDescr, ifAlias and ifName ignored: empty ifDescr, ifAlias and ifName ignored: empty ifDescr, ifAlias and ifName ignored: empty ifDescr, ifAlias and ifName ignored: empty ifDescr, ifAlias and ifName ignored: empty ifDescr, ifAlias and ifName ignored: empty ifDescr, ifAlias and ifName ignored: empty ifDescr, ifAlias and ifName ignored: empty ifDescr, ifAlias and ifName ignored: empty ifDescr, ifAlias and ifName ignored: empty ifDescr, ifAlias and ifName Port lo: lo (1 / #1131) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (10000000) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1131,"interface","2021-09-14 15:54:43",3,"ifAdminStatus: -> up",""][0m 36.24ms] ifAdminStatus: -> up SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1131,"interface","2021-09-14 15:54:43",3,"ifMtu: -> 65536",""][0m 32.82ms] ifMtu: -> 65536 SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1131,"interface","2021-09-14 15:54:43",3,"ifSpeed: 0 bps -> 10 Mbps",""][0m 32.78ms] ifSpeed: 0 bps -> 10 Mbps lobps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)RRD[[0;32mtune /opt/librenms/rrd/10.180.7.1/port-id1131.rrd --maximum INOCTETS:1250000 --maximum OUTOCTETS:1250000 --maximum INERRORS:1250000 --maximum OUTERRORS:1250000 --maximum INUCASTPKTS:1250000 --maximum OUTUCASTPKTS:1250000 --maximum INNUCASTPKTS:1250000 --maximum OUTNUCASTPKTS:1250000 --maximum INDISCARDS:1250000 --maximum OUTDISCARDS:1250000 --maximum INUNKNOWNPROTOS:1250000 --maximum INBROADCASTPKTS:1250000 --maximum OUTBROADCASTPKTS:1250000 --maximum INMULTICASTPKTS:1250000 --maximum OUTMULTICASTPKTS:1250000[0m] SQL[[1;33mUPDATE `ports` set `ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["up","up","65536","10000000","2250756416",0,"2250756416",0,"0",0,"0",0,"612848820",0,"612848820",0,1631615082,null,1631615082,1131][0m 102.54ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["0",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1131][0m 33.1ms] 2 updated Port ipsec0: ipsec0 (2 / #1132) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (0) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1132,"interface","2021-09-14 15:54:43",3,"ifAdminStatus: -> up",""][0m 32.44ms] ifAdminStatus: -> up SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1132,"interface","2021-09-14 15:54:43",3,"ifMtu: -> 16260",""][0m 32.85ms] ifMtu: -> 16260 SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1132,"interface","2021-09-14 15:54:43",3,"ifSpeed: 0 bps -> 0 bps",""][0m 32.86ms] ifSpeed: 0 bps -> 0 bps SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1132,"interface","2021-09-14 15:54:43",3,"ifPhysAddress: -> 42b1fabb7da2",""][0m 32.83ms] ifPhysAddress: -> 42b1fabb7da2 ipsec0bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifPhysAddress`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["up","up","16260","0","42b1fabb7da2","0",0,"0",0,"0",0,"0",0,"0",0,"0",0,1631615082,null,1631615082,1132][0m 32.48ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["0",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1132][0m 33.2ms] 2 updated Port sit0: sit0 (3 / #1133) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (0) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1133,"interface","2021-09-14 15:54:44",3,"ifAdminStatus: -> down",""][0m 82.53ms] ifAdminStatus: -> down SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1133,"interface","2021-09-14 15:54:44",3,"ifMtu: -> 1480",""][0m 91.17ms] ifMtu: -> 1480 SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1133,"interface","2021-09-14 15:54:44",3,"ifSpeed: 0 bps -> 0 bps",""][0m 32.83ms] ifSpeed: 0 bps -> 0 bps sit0bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["down","down","1480","0","0",0,"0",0,"0",0,"0",0,"0",0,"0",0,1631615082,null,1631615082,1133][0m 32.57ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["0",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1133][0m 33.09ms] 2 updated Port ip6tnl0: ip6tnl0 (4 / #1134) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (0) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1134,"interface","2021-09-14 15:54:44",3,"ifAdminStatus: -> down",""][0m 32.49ms] ifAdminStatus: -> down SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1134,"interface","2021-09-14 15:54:44",3,"ifMtu: -> 1452",""][0m 32.8ms] ifMtu: -> 1452 SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1134,"interface","2021-09-14 15:54:44",3,"ifSpeed: 0 bps -> 0 bps",""][0m 24.57ms] ifSpeed: 0 bps -> 0 bps ip6tnl0bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["down","down","1452","0","0",0,"0",0,"0",0,"0",0,"0",0,"0",0,1631615082,null,1631615082,1134][0m 24.2ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["0",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1134][0m 24.73ms] 2 updated Port Port4: Port4 (5 / #1135) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (0) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1135,"interface","2021-09-14 15:54:44",3,"ifAdminStatus: -> down",""][0m 24.15ms] ifAdminStatus: -> down SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1135,"interface","2021-09-14 15:54:44",3,"ifMtu: -> 1500",""][0m 24.54ms] ifMtu: -> 1500 SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1135,"interface","2021-09-14 15:54:44",3,"ifSpeed: 0 bps -> 0 bps",""][0m 24.53ms] ifSpeed: 0 bps -> 0 bps SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1135,"interface","2021-09-14 15:54:44",3,"ifPhysAddress: -> 7c5a1cd8cb63",""][0m 24.47ms] ifPhysAddress: -> 7c5a1cd8cb63 Port4bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifPhysAddress`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["down","down","1500","0","7c5a1cd8cb63","0",0,"0",0,"0",0,"0",0,"0",0,"0",0,1631615082,null,1631615082,1135][0m 24.17ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["0",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1135][0m 24.8ms] 2 updated Port Port1: Port1 (6 / #1136) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (1000000000) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1136,"interface","2021-09-14 15:54:44",3,"ifAdminStatus: -> up",""][0m 24.13ms] ifAdminStatus: -> up SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1136,"interface","2021-09-14 15:54:44",3,"ifMtu: -> 1500",""][0m 141.05ms] ifMtu: -> 1500 SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1136,"interface","2021-09-14 15:54:44",3,"ifSpeed: 0 bps -> 1 Gbps",""][0m 141.04ms] ifSpeed: 0 bps -> 1 Gbps SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1136,"interface","2021-09-14 15:54:44",3,"ifPhysAddress: -> 7c5a1cd8cb60",""][0m 24.52ms] ifPhysAddress: -> 7c5a1cd8cb60 Port1bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)RRD[[0;32mtune /opt/librenms/rrd/10.180.7.1/port-id1136.rrd --maximum INOCTETS:125000000 --maximum OUTOCTETS:125000000 --maximum INERRORS:125000000 --maximum OUTERRORS:125000000 --maximum INUCASTPKTS:125000000 --maximum OUTUCASTPKTS:125000000 --maximum INNUCASTPKTS:125000000 --maximum OUTNUCASTPKTS:125000000 --maximum INDISCARDS:125000000 --maximum OUTDISCARDS:125000000 --maximum INUNKNOWNPROTOS:125000000 --maximum INBROADCASTPKTS:125000000 --maximum OUTBROADCASTPKTS:125000000 --maximum INMULTICASTPKTS:125000000 --maximum OUTMULTICASTPKTS:125000000[0m] SQL[[1;33mUPDATE `ports` set `ifLastChange`=?,`ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifPhysAddress`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["19641746","up","up","1500","1000000000","7c5a1cd8cb60","54416364",0,"1463792792",0,"0",0,"0",0,"879247321",0,"1211928728",0,1631615082,null,1631615082,1136][0m 24.06ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["1498943",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1136][0m 24.75ms] 2 updated Port Port2: Port2 (7 / #1137) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (100000000) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1137,"interface","2021-09-14 15:54:44",3,"ifAdminStatus: -> up",""][0m 24.11ms] ifAdminStatus: -> up SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1137,"interface","2021-09-14 15:54:44",3,"ifMtu: -> 1500",""][0m 24.53ms] ifMtu: -> 1500 SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1137,"interface","2021-09-14 15:54:45",3,"ifSpeed: 0 bps -> 100 Mbps",""][0m 24.5ms] ifSpeed: 0 bps -> 100 Mbps SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1137,"interface","2021-09-14 15:54:45",3,"ifPhysAddress: -> 7c5a1cd8cb61",""][0m 24.57ms] ifPhysAddress: -> 7c5a1cd8cb61 Port2bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)RRD[[0;32mtune /opt/librenms/rrd/10.180.7.1/port-id1137.rrd --maximum INOCTETS:12500000 --maximum OUTOCTETS:12500000 --maximum INERRORS:12500000 --maximum OUTERRORS:12500000 --maximum INUCASTPKTS:12500000 --maximum OUTUCASTPKTS:12500000 --maximum INNUCASTPKTS:12500000 --maximum OUTNUCASTPKTS:12500000 --maximum INDISCARDS:12500000 --maximum OUTDISCARDS:12500000 --maximum INUNKNOWNPROTOS:12500000 --maximum INBROADCASTPKTS:12500000 --maximum OUTBROADCASTPKTS:12500000 --maximum INMULTICASTPKTS:12500000 --maximum OUTMULTICASTPKTS:12500000[0m] SQL[[1;33mUPDATE `ports` set `ifLastChange`=?,`ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifPhysAddress`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["1402107491","up","up","1500","100000000","7c5a1cd8cb61","110949207",0,"4060966186",0,"0",0,"0",0,"1721348769",0,"1046423805",0,1631615082,null,1631615082,1137][0m 24.06ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["1",0,"0",0,"1",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1137][0m 26.08ms] 2 updated Port Port3: Port3 (8 / #1138) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (100000000) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1138,"interface","2021-09-14 15:54:45",3,"ifAdminStatus: -> up",""][0m 24.04ms] ifAdminStatus: -> up SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1138,"interface","2021-09-14 15:54:45",3,"ifMtu: -> 1500",""][0m 24.53ms] ifMtu: -> 1500 SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1138,"interface","2021-09-14 15:54:45",3,"ifSpeed: 0 bps -> 100 Mbps",""][0m 49.56ms] ifSpeed: 0 bps -> 100 Mbps SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1138,"interface","2021-09-14 15:54:45",3,"ifPhysAddress: -> 7c5a1cd8cb62",""][0m 24.6ms] ifPhysAddress: -> 7c5a1cd8cb62 Port3bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)RRD[[0;32mtune /opt/librenms/rrd/10.180.7.1/port-id1138.rrd --maximum INOCTETS:12500000 --maximum OUTOCTETS:12500000 --maximum INERRORS:12500000 --maximum OUTERRORS:12500000 --maximum INUCASTPKTS:12500000 --maximum OUTUCASTPKTS:12500000 --maximum INNUCASTPKTS:12500000 --maximum OUTNUCASTPKTS:12500000 --maximum INDISCARDS:12500000 --maximum OUTDISCARDS:12500000 --maximum INUNKNOWNPROTOS:12500000 --maximum INBROADCASTPKTS:12500000 --maximum OUTBROADCASTPKTS:12500000 --maximum INMULTICASTPKTS:12500000 --maximum OUTMULTICASTPKTS:12500000[0m] SQL[[1;33mUPDATE `ports` set `ifLastChange`=?,`ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifPhysAddress`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["1152479208","up","up","1500","100000000","7c5a1cd8cb62","3927296175",0,"1216287765",0,"7",0,"0",0,"244818714",0,"438787220",0,1631615082,null,1631615082,1138][0m 24.01ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["66918",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1138][0m 24.76ms] 2 updated Port ifb0: ifb0 (9 / #1139) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (0) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1139,"interface","2021-09-14 15:54:45",3,"ifAdminStatus: -> up",""][0m 32.48ms] ifAdminStatus: -> up SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1139,"interface","2021-09-14 15:54:45",3,"ifMtu: -> 1500",""][0m 24.5ms] ifMtu: -> 1500 SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1139,"interface","2021-09-14 15:54:45",3,"ifSpeed: 0 bps -> 0 bps",""][0m 32.81ms] ifSpeed: 0 bps -> 0 bps SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1139,"interface","2021-09-14 15:54:45",3,"ifPhysAddress: -> 76104ea667bb",""][0m 32.87ms] ifPhysAddress: -> 76104ea667bb ifb0bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifPhysAddress`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["up","up","1500","0","76104ea667bb","639744849",0,"639744849",0,"0",0,"0",0,"2617134357",0,"2617134357",0,1631615082,null,1631615082,1139][0m 32.5ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["0",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1139][0m 33.09ms] 2 updated Port gre0: gre0 (11 / #1140) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (0) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1140,"interface","2021-09-14 15:54:45",3,"ifAdminStatus: -> down",""][0m 32.38ms] ifAdminStatus: -> down SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1140,"interface","2021-09-14 15:54:45",3,"ifMtu: -> 1476",""][0m 32.82ms] ifMtu: -> 1476 SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1140,"interface","2021-09-14 15:54:45",3,"ifSpeed: 0 bps -> 0 bps",""][0m 32.86ms] ifSpeed: 0 bps -> 0 bps gre0bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["down","down","1476","0","0",0,"0",0,"0",0,"0",0,"0",0,"0",0,1631615082,null,1631615082,1140][0m 32.5ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["0",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1140][0m 33.11ms] 2 updated Port gretap0: gretap0 (12 / #1141) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (0) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1141,"interface","2021-09-14 15:54:45",3,"ifAdminStatus: -> down",""][0m 32.4ms] ifAdminStatus: -> down SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1141,"interface","2021-09-14 15:54:45",3,"ifMtu: -> 1462",""][0m 32.87ms] ifMtu: -> 1462 SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1141,"interface","2021-09-14 15:54:45",3,"ifSpeed: 0 bps -> 0 bps",""][0m 32.78ms] ifSpeed: 0 bps -> 0 bps gretap0bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["down","down","1462","0","0",0,"0",0,"0",0,"0",0,"0",0,"0",0,1631615082,null,1631615082,1141][0m 32.47ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["0",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1141][0m 33.13ms] 2 updated Port erspan0: erspan0 (13 / #1142) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (0) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1142,"interface","2021-09-14 15:54:45",3,"ifAdminStatus: -> down",""][0m 32.33ms] ifAdminStatus: -> down SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1142,"interface","2021-09-14 15:54:45",3,"ifMtu: -> 1450",""][0m 32.86ms] ifMtu: -> 1450 SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1142,"interface","2021-09-14 15:54:45",3,"ifSpeed: 0 bps -> 0 bps",""][0m 32.86ms] ifSpeed: 0 bps -> 0 bps erspan0bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["down","down","1450","0","0",0,"0",0,"0",0,"0",0,"0",0,"0",0,1631615082,null,1631615082,1142][0m 32.39ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["0",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1142][0m 33.11ms] 2 updated Port host0: host0 (14 / #1143) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (0) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1143,"interface","2021-09-14 15:54:45",3,"ifAdminStatus: -> down",""][0m 32.45ms] ifAdminStatus: -> down SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1143,"interface","2021-09-14 15:54:46",3,"ifMtu: -> 1500",""][0m 32.83ms] ifMtu: -> 1500 SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1143,"interface","2021-09-14 15:54:46",3,"ifSpeed: 0 bps -> 0 bps",""][0m 32.84ms] ifSpeed: 0 bps -> 0 bps SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1143,"interface","2021-09-14 15:54:46",3,"ifPhysAddress: -> e2984b8a7aae",""][0m 32.89ms] ifPhysAddress: -> e2984b8a7aae host0bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifPhysAddress`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["down","down","1500","0","e2984b8a7aae","0",0,"0",0,"0",0,"0",0,"0",0,"0",0,1631615082,null,1631615082,1143][0m 32.48ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["0",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1143][0m 33.11ms] 2 updated Port host1: host1 (15 / #1144) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (0) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1144,"interface","2021-09-14 15:54:46",3,"ifAdminStatus: -> down",""][0m 32.47ms] ifAdminStatus: -> down SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1144,"interface","2021-09-14 15:54:46",3,"ifMtu: -> 1500",""][0m 66.23ms] ifMtu: -> 1500 SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1144,"interface","2021-09-14 15:54:46",3,"ifSpeed: 0 bps -> 0 bps",""][0m 32.84ms] ifSpeed: 0 bps -> 0 bps SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1144,"interface","2021-09-14 15:54:46",3,"ifPhysAddress: -> 5ee97b59a52c",""][0m 32.84ms] ifPhysAddress: -> 5ee97b59a52c host1bps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifPhysAddress`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["down","down","1500","0","5ee97b59a52c","0",0,"0",0,"0",0,"0",0,"0",0,"0",0,1631615082,null,1631615082,1144][0m 32.54ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["0",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1144][0m 33.13ms] 2 updated SQL[[1;33mUPDATE `ports` set `deleted`=? WHERE `device_id` = ? AND `port_id` = ? [0;33m["1",61,1145][0m 33.06ms] Port spq: spq (96 / #1145) deleted. Port spq: spq (99 / #1214) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (0) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1214,"interface","2021-09-14 15:54:46",3,"ifAdminStatus: -> down",""][0m 257.29ms] ifAdminStatus: -> down SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1214,"interface","2021-09-14 15:54:46",3,"ifMtu: -> 1500",""][0m 32.76ms] ifMtu: -> 1500 SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1214,"interface","2021-09-14 15:54:46",3,"ifSpeed: 0 bps -> 0 bps",""][0m 32.84ms] ifSpeed: 0 bps -> 0 bps SQL[[1;33minsert into `eventlog` (`device_id`, `reference`, `type`, `datetime`, `severity`, `message`, `username`) values (?, ?, ?, ?, ?, ?, ?) [0;33m[61,1214,"interface","2021-09-14 15:54:46",3,"ifPhysAddress: -> 06940f02ee18",""][0m 32.9ms] ifPhysAddress: -> 06940f02ee18 spqbps(0 bps/0 bps)bytes(0 B/0 B)pkts(0 pps/0 pps)SQL[[1;33mUPDATE `ports` set `ifLastChange`=?,`ifAdminStatus`=?,`ifOperStatus_prev`=?,`ifMtu`=?,`ifSpeed`=?,`ifPhysAddress`=?,`ifInOctets`=?,`ifInOctets_prev`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["1556561242","down","down","1500","0","06940f02ee18","0",0,"0",0,"0",0,"0",0,"0",0,"0",0,1631615082,null,1631615082,1214][0m 31.99ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=? WHERE `port_id` = ? [0;33m["0",0,"0",0,"0",0,"0",0,"0",0,0,0,0,0,0,0,0,0,1214][0m 33.1ms] 2 updated SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1631615082,null,1631615082][0m 0.21ms] 0 updated >> Runtime for poller module 'ports': 15.8551 seconds with 394808 bytes >> SNMP: [4/11.87s] MySQL: [48/1.65s] #### 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[61][0m 0.44ms] >> Runtime for poller module 'customoid': 0.0152 seconds with 2448 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module customoid #### Modules status: Global+ OS Device #### Load poller module bgp-peers #### SQL[[1;33mSELECT * FROM `bgpPeers` AS B LEFT JOIN `vrfs` AS V ON `B`.`vrf_id` = `V`.`vrf_id` WHERE `B`.`device_id` = ? [0;33m[61][0m 0.58ms] >> Runtime for poller module 'bgp-peers': 0.0070 seconds with 15152 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module bgp-peers #### 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[61][0m 0.51ms] >> Runtime for poller module 'ucd-diskio': 0.0101 seconds with 1944 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module ucd-diskio #### Modules status: Global- OS Device Module [ wifi ] disabled globally. Modules status: Global+ OS Device #### Load poller module wireless #### Attempting to initialize OS: sophos-xg Attempting to initialize OS: sophos OS initialized as Generic SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[61][0m 0.7ms] >> Runtime for poller module 'wireless': 0.0052 seconds with 104248 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### 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[61][0m 0.28ms] Processes: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'OSPF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'OSPF-MIB::ospfGeneralGroup'[0m] ospfGeneralGroup = No Such Object available on this agent at this OID Invalid snmp_walk() data = ospfGeneralGroup = No Such Object available on this agent at this OID array ( ) SQL[[1;33mdelete from `ospf_instances` where (`device_id` = ? and `context_name` = ?) and 1 = 1 [0;33m[61,""][0m 0.54ms] 0 >> Runtime for poller module 'ospf': 0.1734 seconds with 55400 bytes >> SNMP: [1/0.16s] MySQL: [0/0.00s] #### 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 #### SQL[[1;33mSELECT * FROM `entPhysical_state` WHERE `device_id` = ? [0;33m[61][0m 0.49ms] >> Runtime for poller module 'entity-physical': 0.0216 seconds with 2152 bytes >> SNMP: [0/0.00s] MySQL: [1/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[61][0m 0.44ms] >> Runtime for poller module 'applications': 0.0054 seconds with 1592 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] #### Unload poller module applications #### 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[61][0m 0.27ms] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-m' 'RSTP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/sophos' 'udp:HOSTNAME:161' 'dot1dStpProtocolSpecification.0'[0m] No Such Object available on this agent at this OID >> Runtime for poller module 'stp': 0.0944 seconds with 5400 bytes >> SNMP: [1/0.08s] MySQL: [1/0.00s] #### Unload poller module stp #### Modules status: Global+ OS Device #### Load poller module ntp #### >> Runtime for poller module 'ntp': 0.0443 seconds with 400 bytes >> SNMP: [0/0.00s] MySQL: [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.0054 seconds with 89648 bytes >> SNMP: [0/0.00s] MySQL: [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[61][0m 0.66ms] SQL[[1;33minsert into `device_graphs` (`graph`, `device_id`) values (?, ?) [0;33m["uptime",61][0m 108.38ms] +SQL[[1;33minsert into `device_graphs` (`graph`, `device_id`) values (?, ?) [0;33m["poller_perf",61][0m 66.21ms] +SQL[[1;33minsert into `device_graphs` (`graph`, `device_id`) values (?, ?) [0;33m["availability",61][0m 49.61ms] +SQL[[1;33minsert into `device_graphs` (`graph`, `device_id`) values (?, ?) [0;33m["netstat_icmp",61][0m 32.88ms] +SQL[[1;33minsert into `device_graphs` (`graph`, `device_id`) values (?, ?) [0;33m["netstat_icmp_info",61][0m 66.24ms] +SQL[[1;33minsert into `device_graphs` (`graph`, `device_id`) values (?, ?) [0;33m["netstat_ip",61][0m 33.07ms] +SQL[[1;33minsert into `device_graphs` (`graph`, `device_id`) values (?, ?) [0;33m["netstat_ip_frag",61][0m 91.22ms] +SQL[[1;33minsert into `device_graphs` (`graph`, `device_id`) values (?, ?) [0;33m["netstat_snmp",61][0m 49.56ms] +SQL[[1;33minsert into `device_graphs` (`graph`, `device_id`) values (?, ?) [0;33m["netstat_snmp_pkt",61][0m 49.67ms] +SQL[[1;33minsert into `device_graphs` (`graph`, `device_id`) values (?, ?) [0;33m["netstat_tcp",61][0m 57.91ms] +SQL[[1;33minsert into `device_graphs` (`graph`, `device_id`) values (?, ?) [0;33m["netstat_udp",61][0m 91.22ms] +SQL[[1;33minsert into `device_graphs` (`graph`, `device_id`) values (?, ?) [0;33m["hr_users",61][0m 57.91ms] +SQL[[1;33minsert into `device_graphs` (`graph`, `device_id`) values (?, ?) [0;33m["ping_perf",61][0m 24.62ms] +SQL[[1;33minsert into `device_graphs` (`graph`, `device_id`) values (?, ?) [0;33m["poller_modules_perf",61][0m 24.66ms] + SQL[[1;33mUPDATE `devices` set `uptime`=?,`last_ping`=NOW(),`last_ping_timetaken`=?,`last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[15658859,70.4,44.684,61][0m 24.74ms] Updating 10.180.7.1 Polled in 44.684 seconds ### Start Device Groups ### SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[61][0m 50.14ms] SQL[[1;33mselect * from `device_groups` [0;33m[][0m 0.2ms] SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[61][0m 0.36ms] Groups Added: Groups Removed: ### End Device Groups, runtime: 0.0521s ### #### Start Alerts #### 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 `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["2021-09-14T10:24:48.156378Z","2021-09-14T10:24:48.156378Z",0,1,"10:24:48","10:24:48","10:24:48","10:24:48","[42m%","device",61,"location",3][0m 1.1ms] SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[61][0m 0.36ms] 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[61,61,61,61,61,61,61,61][0m 1.83ms] Rule [0;35m#7 (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[61][0m 0.56ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[7,61][0m 0.31ms] SQL[[1;33mINSERT IGNORE INTO `alert_log` (`state`,`device_id`,`rule_id`) VALUES (:state,:device_id,:rule_id) [0;33m{"state":0,"device_id":61,"rule_id":7}[0m 23.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":61,"rule_id":7,"open":1,"alerted":0}[0m 24.83ms] Status: [0;32mOK[0m Rule [0;35m#8 (SNMP not responding on Device - Check on SNMP Service - Device marked Down!):[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 = "snmp" [0;33m[61][0m 0.6ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[8,61][0m 0.34ms] SQL[[1;33mINSERT IGNORE INTO `alert_log` (`state`,`device_id`,`rule_id`) VALUES (:state,:device_id,:rule_id) [0;33m{"state":0,"device_id":61,"rule_id":8}[0m 23.37ms] 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":61,"rule_id":8,"open":1,"alerted":0}[0m 149.7ms] Status: [0;32mOK[0m Rule [0;35m#9 (Device rebooted):[0m SQL[[1;33mSELECT * FROM devices WHERE (devices.device_id = ?) AND devices.uptime < 300 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> 10 [0;33m[61][0m 0.63ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[11,61][0m 0.28ms] SQL[[1;33mINSERT IGNORE INTO `alert_log` (`state`,`device_id`,`rule_id`,`details`) VALUES (:state,:device_id,:rule_id,:details) [0;33m[0m 23.15ms] SQL[[1;33mINSERT IGNORE INTO `alerts` (`state`,`device_id`,`rule_id`,`open`,`alerted`) VALUES (:state,:device_id,:rule_id,:open,:alerted) [0;33m{"state":1,"device_id":61,"rule_id":11,"open":1,"alerted":0}[0m 24.85ms] Status: [0;31mALERT[0m Rule [0;35m#13 (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[61][0m 0.78ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[13,61][0m 0.29ms] SQL[[1;33mINSERT IGNORE INTO `alert_log` (`state`,`device_id`,`rule_id`) VALUES (:state,:device_id,:rule_id) [0;33m{"state":0,"device_id":61,"rule_id":13}[0m 23.23ms] 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":61,"rule_id":13,"open":1,"alerted":0}[0m 24.8ms] Status: [0;32mOK[0m Rule [0;35m#14 (Sensor under 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 xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed xss=removed>= wireless_sensors.sensor_limit AND wireless_sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[61][0m 0.77ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[16,61][0m 0.28ms] SQL[[1;33mINSERT IGNORE INTO `alert_log` (`state`,`device_id`,`rule_id`) VALUES (:state,:device_id,:rule_id) [0;33m{"state":0,"device_id":61,"rule_id":16}[0m 23.22ms] 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":61,"rule_id":16,"open":1,"alerted":0}[0m 34.45ms] Status: [0;32mOK[0m Rule [0;35m#17 (Wireless Sensor under limit):[0m SQL[[1;33mSELECT * FROM devices,wireless_sensors WHERE (devices.device_id = ? AND devices.device_id = wireless_sensors.device_id) AND wireless_sensors.sensor_current <= wireless_sensors.sensor_limit_low AND wireless_sensors.sensor_alert = 1 AND (devices.status = 1 && (devices.disabled = 0 && devices.ignore = 0)) = 1 [0;33m[61][0m 0.76ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[17,61][0m 0.33ms] SQL[[1;33mINSERT IGNORE INTO `alert_log` (`state`,`device_id`,`rule_id`) VALUES (:state,:device_id,:rule_id) [0;33m{"state":0,"device_id":61,"rule_id":17}[0m 31.59ms] 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":61,"rule_id":17,"open":1,"alerted":0}[0m 33.12ms] Status: [0;32mOK[0m Rule [0;35m#18 (State Sensor Critical):[0m SQL[[1;33mSELECT * FROM devices,sensors,sensors_to_state_indexes,state_indexes,state_translations WHERE (devices.device_id = ? AND devices.device_id = sensors.device_id AND sensors.sensor_id = sensors_to_state_indexes.sensor_id AND sensors_to_state_indexes.state_index_id = state_indexes.state_index_id AND state_indexes.state_index_id = state_translations.state_index_id) AND (sensors.sensor_current = state_translations.state_value && state_translations.state_generic_value = 2) = 1 AND sensors.sensor_alert = 1 [0;33m[61][0m 0.92ms] SQL[[1;33mSELECT state FROM alerts WHERE rule_id = ? AND device_id = ? ORDER BY id DESC LIMIT 1 [0;33m[18,61][0m 0.31ms] SQL[[1;33mINSERT IGNORE INTO `alert_log` (`state`,`device_id`,`rule_id`) VALUES (:state,:device_id,:rule_id) [0;33m{"state":0,"device_id":61,"rule_id":18}[0m 31.31ms] 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":61,"rule_id":18,"open":1,"alerted":0}[0m 33.16ms] Status: [0;32mOK[0m #### End Alerts #### ./poller.php 10.180.7.1 2021-09-14 15:54:49 - 1 devices polled in 46.73 secs SNMP [23/38.10s]: Get[9/6.74s] Getnext[4/0.53s] Walk[10/30.82s] MySQL [113/3.36s]: Cell[12/0.01s] Row[-11/-0.01s] Rows[24/0.17s] Column[1/0.00s] Update[45/1.58s] Insert[42/1.60s] Delete[0/0.00s]