LibreNMS Poller SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.9ms] SQL[[1;33mselect count(*) as aggregate from `migrations` limit 1 [0;33m[][0m 0.98ms] SQL[[1;33mselect version() [0;33m[][0m 0.89ms] =================================== Version info: Commit SHA: Commit Date: DB Schema: 2022_04_08_085504_isis_adjacencies_table_add_index (236) PHP: 7.4.29 MySQL: 10.5.16-MariaDB-1:10.5.16+maria~focal RRDTool: 1.7.2 SNMP: 5.9.1 ==================================DEBUG! Updating os_def.cache Starting polling run: SQL[[1;33mSELECT * FROM `devices` WHERE `disabled` = 0 AND `hostname` = '10.10.7.10' ORDER BY `device_id` ASC [0;33m[][0m 1.25ms] SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[5][0m 0.9ms] SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[5][0m 0.81ms] Attempting to initialize OS: linux Attempting to initialize Group OS: unix OS initialized: LibreNMS\OS\Shared\Unix Hostname: 10.10.7.10 Device ID: 5 OS: linux (unix) [FPING] '/usr/sbin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '-O' '0' '10.10.7.10' response: xmt/rcv/%loss = 3/3/0%, min/avg/max = 23.6/24/24.8 SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m] SNMPv2-MIB::sysObjectID.0 = SNMPv2-SMI::enterprises.243*.* SQL[[1;33minsert into `device_perf` (`min`, `max`, `avg`, `xmt`, `rcv`, `loss`, `device_id`, `timestamp`) values (?, ?, ?, ?, ?, ?, ?, ?) [0;33m[23.6,24.8,24,3,3,0,5,"2022-06-08 09:34:22"][0m 12.22ms] SQL[[1;33mupdate `devices` set `last_ping_timetaken` = ? where `device_id` = ? [0;33m[24,5][0m 12.21ms] RRD[[0;32mupdate /data/rrd/10.10.7.10/ping-perf.rrd N:24[0m] SQL[[1;33mselect * from `device_outages` where `device_outages`.`device_id` = ? and `device_outages`.`device_id` is not null and `up_again` is null order by `going_down` desc limit 1 [0;33m[5][0m 1.17ms] Modules status: Global+ OS Device #### Load poller module core #### SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-On' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysDescr.0' 'SNMPv2-MIB::sysObjectID.0' 'SNMPv2-MIB::sysUpTime.0' 'SNMPv2-MIB::sysName.0'[0m] .*.*.0 = Linux dcp2000sala1.dc.doremilabs.com * #5 SMP PREEMPT Mon Aug 26 16:11:57 CEST 2013 i686 .*.*.0 = .*.4.1.243*.* .*.*.0 = 14918958 .*.*.0 = dcp2000sala1.dc.doremilabs.com SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMP-FRAMEWORK-MIB::snmpEngineTime.0' 'HOST-RESOURCES-MIB::hrSystemUptime.0'[0m] SNMP-FRAMEWORK-MIB::snmpEngineTime.0 = 149190 HOST-RESOURCES-MIB::hrSystemUptime.0 = 14925372 Uptime seconds: 149254 RRD[[0;32mupdate /data/rrd/10.10.7.10/uptime.rrd N:149254[0m] Uptime: 1 day 17 hours 27 minutes 34 seconds SQL[[1;33mupdate `devices` set `uptime` = ? where `device_id` = ? [0;33m[149254,5][0m 10.19ms] >> Runtime for poller module 'core': 0.1341 seconds with 5312 bytes >> [0;36mSNMP[0m: [2/0.12s] [1;33mMySQL[0m: [1/0.10s] [0;32mRRD[0m: [1/0.00s] #### Unload poller module core #### RRD[[0;32mupdate /data/rrd/10.10.7.10/poller-perf-core.rrd N:0.1340548992157[0m] Modules status: Global- OS Device Module [ unix-agent ] disabled globally. Modules status: Global+ OS Device #### Load poller module os #### Generic :( SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[3][0m 0.71ms] Location: Unknown Hardware: Generic x86 OS Version: 2.6.18.2 OS Features: Serial: >> Runtime for poller module 'os': 0.0047 seconds with 44656 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [1/0.00s] #### Unload poller module os #### RRD[[0;32mupdate /data/rrd/10.10.7.10/poller-perf-os.rrd N:0.0046889781951904[0m] Modules status: Global+ OS Device #### Load poller module availability #### SQL[[1;33mSELECT duration FROM availability WHERE device_id = ? [0;33m[5][0m 0.67ms] Availability: SQL[[1;33mSELECT * FROM availability WHERE device_id = ? [0;33m[5][0m 0.49ms] SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[5,1654587262][0m 0.62ms] RRD[[0;32mupdate /data/rrd/10.10.7.10/availability-86400.rrd N:100[0m] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,17][0m 0.41ms] 1 day : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[5,1654068862][0m 0.46ms] RRD[[0;32mupdate /data/rrd/10.10.7.10/availability-604800.rrd N:100[0m] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,18][0m 0.38ms] 7 days : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[5,1652081662][0m 0.65ms] RRD[[0;32mupdate /data/rrd/10.10.7.10/availability-2592000.rrd N:100[0m] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,19][0m 0.37ms] 30 days : 100% SQL[[1;33mselect * from `device_outages` where `device_id` = ? and `up_again` >= ? order by `going_down` asc [0;33m[5,1623137662][0m 0.47ms] RRD[[0;32mupdate /data/rrd/10.10.7.10/availability-31536000.rrd N:100[0m] SQL[[1;33mUPDATE `availability` set `availability_perc`=? WHERE `availability_id` = ? [0;33m[100,20][0m 0.35ms] 365 days : 100% >> Runtime for poller module 'availability': 0.0092 seconds with 3176 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [10/0.05s] [0;32mRRD[0m: [5/0.00s] #### Unload poller module availability #### RRD[[0;32mupdate /data/rrd/10.10.7.10/poller-perf-availability.rrd N:0.0092461109161377[0m] Modules status: Global+ OS Device #### Load poller module ipmi #### SQL[[1;33mSELECT * FROM sensors WHERE device_id = ? AND poller_type='ipmi' [0;33m[5][0m 0.67ms] array ( ) >> Runtime for poller module 'ipmi': 0.0016 seconds with 88 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [1/0.00s] #### Unload poller module ipmi #### RRD[[0;32mupdate /data/rrd/10.10.7.10/poller-perf-ipmi.rrd N:0.0015881061553955[0m] Modules status: Global+ OS Device #### Load poller module sensors #### SQL[[1;33mSELECT `sensor_class` FROM `sensors` WHERE `device_id` = ? GROUP BY `sensor_class` [0;33m[5][0m 0.57ms] >> Runtime for poller module 'sensors': 0.0010 seconds with 80 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [1/0.00s] #### Unload poller module sensors #### RRD[[0;32mupdate /data/rrd/10.10.7.10/poller-perf-sensors.rrd N:0.00099611282348633[0m] Modules status: Global+ OS Device #### Load poller module processors #### Attempting to initialize OS: linux Attempting to initialize Group OS: unix OS initialized: LibreNMS\OS\Shared\Unix SQL[[1;33mSELECT * FROM processors WHERE device_id=? [0;33m[5][0m 0.58ms] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQn' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.2021.11.11.0'[0m] .*.4.1.2* = 98 array ( '.1.3.6.1.4.1.2021.11.11.0' => '98', ) CPU: 2% RRD[[0;32mupdate /data/rrd/10.10.7.10/processor-ucd-old-0.rrd N:2[0m] >> Runtime for poller module 'processors': 0.0628 seconds with 3448 bytes >> [0;36mSNMP[0m: [1/0.06s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [2/0.00s] #### Unload poller module processors #### RRD[[0;32mupdate /data/rrd/10.10.7.10/poller-perf-processors.rrd N:0.062812089920044[0m] 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[5][0m 1.32ms] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQn' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' '.1.3.6.1.2.1.25.2.3.1.6.2' '.1.3.6.1.2.1.25.2.3.1.6.3'[0m] .*.*.* = 811224 .*.*.* = 0 hrstorage [system]: Real Memory: 62y2.21 MiB / 1.25 GiB SQL[[1;33mupdate `mempools` set `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[830693376,515706880,14][0m 4.2ms] RRD[[0;32mupdate /data/rrd/10.10.7.10/mempool-hrstorage-system-2.rrd N:830693376:515706880[0m] hrstorage [swap]: Swap Space: 0 / 49.18 MiB RRD[[0;32mupdate /data/rrd/10.10.7.10/mempool-hrstorage-swap-3.rrd N:0:51568640[0m] >> Runtime for poller module 'mempools': 0.0732 seconds with 37208 bytes >> [0;36mSNMP[0m: [1/0.06s] [1;33mMySQL[0m: [2/0.06s] [0;32mRRD[0m: [3/0.00s] #### Unload poller module mempools #### RRD[[0;32mupdate /data/rrd/10.10.7.10/poller-perf-mempools.rrd N:0.073221921920776[0m] Modules status: Global+ OS Device #### Load poller module storage #### SQL[[1;33mSELECT * FROM storage WHERE device_id = ? [0;33m[5][0m 0.91ms] Storage /: hrstorage SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'hrStorageEntry'[0m] hrStorageIndex.1 = 1 hrStorageIndex.2 = 2 hrStorageIndex.3 = 3 hrStorageIndex.4 = 4 hrStorageIndex.5 = 5 hrStorageIndex.6 = 6 hrStorageIndex.7 = 7 hrStorageIndex.8 = 8 hrStorageIndex.9 = 9 hrStorageIndex.10 = 10 hrStorageIndex.11 = 11 hrStorageIndex.12 = 12 hrStorageIndex.13 = 13 hrStorageType.1 = hrStorageOther hrStorageType.2 = hrStorageRam hrStorageType.3 = hrStorageVirtualMemory hrStorageType.4 = hrStorageFixedDisk hrStorageType.5 = hrStorageFixedDisk hrStorageType.6 = hrStorageFixedDisk hrStorageType.7 = hrStorageFixedDisk hrStorageType.8 = hrStorageFixedDisk hrStorageType.9 = hrStorageFixedDisk hrStorageType.10 = hrStorageFixedDisk hrStorageType.11 = hrStorageFixedDisk hrStorageType.12 = hrStorageFixedDisk hrStorageType.13 = hrStorageFixedDisk hrStorageDescr.1 = Memory Buffers hrStorageDescr.2 = Real Memory hrStorageDescr.3 = Swap Space hrStorageDescr.4 = / hrStorageDescr.5 = /sys hrStorageDescr.6 = / hrStorageDescr.7 = /dev/.static/dev hrStorageDescr.8 = /proc/bus/usb hrStorageDescr.9 = /doremi hrStorageDescr.10 = /var hrStorageDescr.11 = /boot hrStorageDescr.12 = /data hrStorageDescr.13 = /opt hrStorageAllocationUnits.1 = 1024 hrStorageAllocationUnits.2 = 1024 hrStorageAllocationUnits.3 = 1024 hrStorageAllocationUnits.4 = 4096 hrStorageAllocationUnits.5 = 4096 hrStorageAllocationUnits.6 = 4096 hrStorageAllocationUnits.7 = 4096 hrStorageAllocationUnits.8 = 4096 hrStorageAllocationUnits.9 = 4096 hrStorageAllocationUnits.10 = 1024 hrStorageAllocationUnits.11 = 1024 hrStorageAllocationUnits.12 = 4096 hrStorageAllocationUnits.13 = 4096 hrStorageSize.1 = 1314844 hrStorageSize.2 = 1314844 hrStorageSize.3 = 50360 hrStorageSize.4 = 186014 hrStorageSize.5 = 0 hrStorageSize.6 = 186014 hrStorageSize.7 = 186014 hrStorageSize.8 = 0 hrStorageSize.9 = 136406 hrStorageSize.10 = 390440 hrStorageSize.11 = 73165 hrStorageSize.12 = 483089920 hrStorageSize.13 = 5198335 hrStorageUsed.1 = 129168 hrStorageUsed.2 = 811224 hrStorageUsed.3 = 0 hrStorageUsed.4 = 146501 hrStorageUsed.5 = 0 hrStorageUsed.6 = 146501 hrStorageUsed.7 = 146501 hrStorageUsed.8 = 0 hrStorageUsed.9 = 53960 hrStorageUsed.10 = 32726 hrStorageUsed.11 = 19382 hrStorageUsed.12 = 371409107 hrStorageUsed.13 = 45701 array ( 'hrstorage' => array ( 1 => array ( 'hrStorageIndex' => '1', 'hrStorageType' => 'hrStorageOther', 'hrStorageDescr' => 'Memory Buffers', 'hrStorageAllocationUnits' => '1024', 'hrStorageSize' => '1314844', 'hrStorageUsed' => '129168', ), 2 => array ( 'hrStorageIndex' => '2', 'hrStorageType' => 'hrStorageRam', 'hrStorageDescr' => 'Real Memory', 'hrStorageAllocationUnits' => '1024', 'hrStorageSize' => '1314844', 'hrStorageUsed' => '811224', ), 3 => array ( 'hrStorageIndex' => '3', 'hrStorageType' => 'hrStorageVirtualMemory', 'hrStorageDescr' => 'Swap Space', 'hrStorageAllocationUnits' => '1024', 'hrStorageSize' => '50360', 'hrStorageUsed' => '0', ), 4 => array ( 'hrStorageIndex' => '4', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/', 'hrStorageAllocationUnits' => '4096', 'hrStorageSize' => '186014', 'hrStorageUsed' => '146501', ), 5 => array ( 'hrStorageIndex' => '5', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/sys', 'hrStorageAllocationUnits' => '4096', 'hrStorageSize' => '0', 'hrStorageUsed' => '0', ), 6 => array ( 'hrStorageIndex' => '6', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/', 'hrStorageAllocationUnits' => '4096', 'hrStorageSize' => '186014', 'hrStorageUsed' => '146501', ), 7 => array ( 'hrStorageIndex' => '7', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/dev/.static/dev', 'hrStorageAllocationUnits' => '4096', 'hrStorageSize' => '186014', 'hrStorageUsed' => '146501', ), 8 => array ( 'hrStorageIndex' => '8', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/proc/bus/usb', 'hrStorageAllocationUnits' => '4096', 'hrStorageSize' => '0', 'hrStorageUsed' => '0', ), 9 => array ( 'hrStorageIndex' => '9', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/doremi', 'hrStorageAllocationUnits' => '4096', 'hrStorageSize' => '136406', 'hrStorageUsed' => '53960', ), 10 => array ( 'hrStorageIndex' => '10', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/var', 'hrStorageAllocationUnits' => '1024', 'hrStorageSize' => '390440', 'hrStorageUsed' => '32726', ), 11 => array ( 'hrStorageIndex' => '11', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/boot', 'hrStorageAllocationUnits' => '1024', 'hrStorageSize' => '73165', 'hrStorageUsed' => '19382', ), 12 => array ( 'hrStorageIndex' => '12', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/data', 'hrStorageAllocationUnits' => '4096', 'hrStorageSize' => '483089920', 'hrStorageUsed' => '371409107', ), 13 => array ( 'hrStorageIndex' => '13', 'hrStorageType' => 'hrStorageFixedDisk', 'hrStorageDescr' => '/opt', 'hrStorageAllocationUnits' => '4096', 'hrStorageSize' => '5198335', 'hrStorageUsed' => '45701', ), ), ) array ( 'storage_id' => 24, 'device_id' => 5, 'storage_mib' => 'hrstorage', 'storage_index' => '4', 'storage_type' => 'hrStorageFixedDisk', 'storage_descr' => '/', 'storage_size' => 761913344, 'storage_units' => 4096, 'storage_used' => 600068096, 'storage_free' => 161845248, 'storage_perc' => 79, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '4096', 'used' => 600068096, 'size' => 761913344, 'free' => 161845248, ) 79% RRD[[0;32mupdate /data/rrd/10.10.7.10/storage-hrstorage-_.rrd N:600068096:161845248[0m] SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["600068096","161845248","761913344",4096,79,24][0m 0.94ms] Storage /: hrstorage array ( 'storage_id' => 25, 'device_id' => 5, 'storage_mib' => 'hrstorage', 'storage_index' => '6', 'storage_type' => 'hrStorageFixedDisk', 'storage_descr' => '/', 'storage_size' => 761913344, 'storage_units' => 4096, 'storage_used' => 600068096, 'storage_free' => 161845248, 'storage_perc' => 79, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '4096', 'used' => 600068096, 'size' => 761913344, 'free' => 161845248, ) 79% RRD[[0;32mupdate /data/rrd/10.10.7.10/storage-hrstorage-_.rrd N:600068096:161845248[0m] SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["600068096","161845248","761913344",4096,79,25][0m 0.76ms] Storage /dev/.static/dev: hrstorage array ( 'storage_id' => 26, 'device_id' => 5, 'storage_mib' => 'hrstorage', 'storage_index' => '7', 'storage_type' => 'hrStorageFixedDisk', 'storage_descr' => '/dev/.static/dev', 'storage_size' => 761913344, 'storage_units' => 4096, 'storage_used' => 600068096, 'storage_free' => 161845248, 'storage_perc' => 79, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '4096', 'used' => 600068096, 'size' => 761913344, 'free' => 161845248, ) 79% RRD[[0;32mupdate /data/rrd/10.10.7.10/storage-hrstorage-_dev_.static_dev.rrd N:600068096:161845248[0m] SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["600068096","161845248","761913344",4096,79,26][0m 0.89ms] Storage /doremi: hrstorage array ( 'storage_id' => 27, 'device_id' => 5, 'storage_mib' => 'hrstorage', 'storage_index' => '9', 'storage_type' => 'hrStorageFixedDisk', 'storage_descr' => '/doremi', 'storage_size' => 558718976, 'storage_units' => 4096, 'storage_used' => 221020160, 'storage_free' => 337698816, 'storage_perc' => 40, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '4096', 'used' => 221020160, 'size' => 558718976, 'free' => 337698816, ) 40% RRD[[0;32mupdate /data/rrd/10.10.7.10/storage-hrstorage-_doremi.rrd N:221020160:337698816[0m] SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["221020160","337698816","558718976",4096,40,27][0m 0.92ms] Storage /var: hrstorage array ( 'storage_id' => 28, 'device_id' => 5, 'storage_mib' => 'hrstorage', 'storage_index' => '10', 'storage_type' => 'hrStorageFixedDisk', 'storage_descr' => '/var', 'storage_size' => 399810560, 'storage_units' => 1024, 'storage_used' => 33511424, 'storage_free' => 366299136, 'storage_perc' => 8, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '1024', 'used' => 33511424, 'size' => 399810560, 'free' => 366299136, ) 8% RRD[[0;32mupdate /data/rrd/10.10.7.10/storage-hrstorage-_var.rrd N:33511424:366299136[0m] SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["33511424","366299136","399810560",1024,8,28][0m 0.7ms] Storage /boot: hrstorage array ( 'storage_id' => 29, 'device_id' => 5, 'storage_mib' => 'hrstorage', 'storage_index' => '11', 'storage_type' => 'hrStorageFixedDisk', 'storage_descr' => '/boot', 'storage_size' => 74920960, 'storage_units' => 1024, 'storage_used' => 19847168, 'storage_free' => 55073792, 'storage_perc' => 26, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '1024', 'used' => 19847168, 'size' => 74920960, 'free' => 55073792, ) 26% RRD[[0;32mupdate /data/rrd/10.10.7.10/storage-hrstorage-_boot.rrd N:19847168:55073792[0m] SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["19847168","55073792","74920960",1024,26,29][0m 0.62ms] Storage /data: hrstorage array ( 'storage_id' => 30, 'device_id' => 5, 'storage_mib' => 'hrstorage', 'storage_index' => '12', 'storage_type' => 'hrStorageFixedDisk', 'storage_descr' => '/data', 'storage_size' => 1978736312320, 'storage_units' => 4096, 'storage_used' => 1521291702272, 'storage_free' => 457444610048, 'storage_perc' => 77, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '4096', 'used' => 1521291702272, 'size' => 1978736312320, 'free' => 457444610048, ) 77% RRD[[0;32mupdate /data/rrd/10.10.7.10/storage-hrstorage-_data.rrd N:1521291702272:457444610048[0m] SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["1521291702272","457444610048","1978736312320",4096,77,30][0m 0.7ms] Storage /opt: hrstorage array ( 'storage_id' => 31, 'device_id' => 5, 'storage_mib' => 'hrstorage', 'storage_index' => '13', 'storage_type' => 'hrStorageFixedDisk', 'storage_descr' => '/opt', 'storage_size' => 21292380160, 'storage_units' => 4096, 'storage_used' => 187191296, 'storage_free' => 21105188864, 'storage_perc' => 1, 'storage_perc_warn' => 60, 'storage_deleted' => 0, 'units' => '4096', 'used' => 187191296, 'size' => 21292380160, 'free' => 21105188864, ) 1% RRD[[0;32mupdate /data/rrd/10.10.7.10/storage-hrstorage-_opt.rrd N:187191296:21105188864[0m] SQL[[1;33mUPDATE `storage` set `storage_used`=?,`storage_free`=?,`storage_size`=?,`storage_units`=?,`storage_perc`=? WHERE `storage_id` = ? [0;33m["187191296","21105188864","21292380160",4096,1,31][0m 0.7ms] >> Runtime for poller module 'storage': 0.2344 seconds with 14080 bytes >> [0;36mSNMP[0m: [1/0.22s] [1;33mMySQL[0m: [9/0.07s] [0;32mRRD[0m: [9/0.00s] #### Unload poller module storage #### RRD[[0;32mupdate /data/rrd/10.10.7.10/poller-perf-storage.rrd N:0.23438811302185[0m] Modules status: Global+ OS Device #### Load poller module netstats #### icmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::icmpInMsgs.0' 'IP-MIB::icmpOutMsgs.0' 'IP-MIB::icmpInErrors.0' 'IP-MIB::icmpOutErrors.0' 'IP-MIB::icmpInEchos.0' 'IP-MIB::icmpOutEchos.0' 'IP-MIB::icmpInEchoReps.0' 'IP-MIB::icmpOutEchoReps.0' 'IP-MIB::icmpInDestUnreachs.0' 'IP-MIB::icmpOutDestUnreachs.0' 'IP-MIB::icmpInParmProbs.0' 'IP-MIB::icmpInTimeExcds.0' 'IP-MIB::icmpInSrcQuenchs.0' 'IP-MIB::icmpInRedirects.0' 'IP-MIB::icmpInTimestamps.0' 'IP-MIB::icmpInTimestampReps.0' 'IP-MIB::icmpInAddrMasks.0' 'IP-MIB::icmpInAddrMaskReps.0' 'IP-MIB::icmpOutTimeExcds.0' 'IP-MIB::icmpOutParmProbs.0' 'IP-MIB::icmpOutSrcQuenchs.0' 'IP-MIB::icmpOutRedirects.0' 'IP-MIB::icmpOutTimestamps.0' 'IP-MIB::icmpOutTimestampReps.0' 'IP-MIB::icmpOutAddrMasks.0' 'IP-MIB::icmpOutAddrMaskReps.0'[0m] IP-MIB::icmpInMsgs.0 = 20893 IP-MIB::icmpOutMsgs.0 = 909 IP-MIB::icmpInErrors.0 = 0 IP-MIB::icmpOutErrors.0 = 0 IP-MIB::icmpInEchos.0 = 905 IP-MIB::icmpOutEchos.0 = 0 IP-MIB::icmpInEchoReps.0 = 994 IP-MIB::icmpOutEchoReps.0 = 905 IP-MIB::icmpInDestUnreachs.0 = 18994 IP-MIB::icmpOutDestUnreachs.0 = 4 IP-MIB::icmpInParmProbs.0 = 0 IP-MIB::icmpInTimeExcds.0 = 0 IP-MIB::icmpInSrcQuenchs.0 = 0 IP-MIB::icmpInRedirects.0 = 0 IP-MIB::icmpInTimestamps.0 = 0 IP-MIB::icmpInTimestampReps.0 = 0 IP-MIB::icmpInAddrMasks.0 = 0 IP-MIB::icmpInAddrMaskReps.0 = 0 IP-MIB::icmpOutTimeExcds.0 = 0 IP-MIB::icmpOutParmProbs.0 = 0 IP-MIB::icmpOutSrcQuenchs.0 = 0 IP-MIB::icmpOutRedirects.0 = 0 IP-MIB::icmpOutTimestamps.0 = 0 IP-MIB::icmpOutTimestampReps.0 = 0 IP-MIB::icmpOutAddrMasks.0 = 0 IP-MIB::icmpOutAddrMaskReps.0 = 0 RRD[[0;32mupdate /data/rrd/10.10.7.10/netstats-icmp.rrd N:20893:909:0:0:905:0:994:905:18994:4:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0:0[0m] ip SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-MIB::ipForwDatagrams.0' 'IP-MIB::ipInDelivers.0' 'IP-MIB::ipInReceives.0' 'IP-MIB::ipOutRequests.0' 'IP-MIB::ipInDiscards.0' 'IP-MIB::ipOutDiscards.0' 'IP-MIB::ipOutNoRoutes.0' 'IP-MIB::ipReasmReqds.0' 'IP-MIB::ipReasmOKs.0' 'IP-MIB::ipReasmFails.0' 'IP-MIB::ipFragOKs.0' 'IP-MIB::ipFragFails.0' 'IP-MIB::ipFragCreates.0' 'IP-MIB::ipInUnknownProtos.0' 'IP-MIB::ipInHdrErrors.0' 'IP-MIB::ipInAddrErrors.0'[0m] IP-MIB::ipForwDatagrams.0 = 0 IP-MIB::ipInDelivers.0 = 23551083 IP-MIB::ipInReceives.0 = 23551085 IP-MIB::ipOutRequests.0 = 23704466 IP-MIB::ipInDiscards.0 = 0 IP-MIB::ipOutDiscards.0 = 0 IP-MIB::ipOutNoRoutes.0 = 0 IP-MIB::ipReasmReqds.0 = 0 IP-MIB::ipReasmOKs.0 = 0 IP-MIB::ipReasmFails.0 = 0 IP-MIB::ipFragOKs.0 = 0 IP-MIB::ipFragFails.0 = 0 IP-MIB::ipFragCreates.0 = 0 IP-MIB::ipInUnknownProtos.0 = 0 IP-MIB::ipInHdrErrors.0 = 0 IP-MIB::ipInAddrErrors.0 = 0 RRD[[0;32mupdate /data/rrd/10.10.7.10/netstats-ip.rrd N:0:23551083:23551085:23704466:0:0:0:0:0:0:0:0:0:0:0:0[0m] ip_forward SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::ipCidrRouteNumber.0'[0m] IP-FORWARD-MIB::ipCidrRouteNumber.0 = No Such Object available on this agent at this OID snmp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::snmpInPkts.0' 'SNMPv2-MIB::snmpOutPkts.0' 'SNMPv2-MIB::snmpInBadVersions.0' 'SNMPv2-MIB::snmpInBadCommunityNames.0' 'SNMPv2-MIB::snmpInBadCommunityUses.0' 'SNMPv2-MIB::snmpInASNParseErrs.0' 'SNMPv2-MIB::snmpInTooBigs.0' 'SNMPv2-MIB::snmpInNoSuchNames.0' 'SNMPv2-MIB::snmpInBadValues.0' 'SNMPv2-MIB::snmpInReadOnlys.0' 'SNMPv2-MIB::snmpInGenErrs.0' 'SNMPv2-MIB::snmpInTotalReqVars.0' 'SNMPv2-MIB::snmpInTotalSetVars.0' 'SNMPv2-MIB::snmpInGetRequests.0' 'SNMPv2-MIB::snmpInGetNexts.0' 'SNMPv2-MIB::snmpInSetRequests.0' 'SNMPv2-MIB::snmpInGetResponses.0' 'SNMPv2-MIB::snmpInTraps.0' 'SNMPv2-MIB::snmpOutTooBigs.0' 'SNMPv2-MIB::snmpOutNoSuchNames.0' 'SNMPv2-MIB::snmpOutBadValues.0' 'SNMPv2-MIB::snmpOutGenErrs.0' 'SNMPv2-MIB::snmpOutGetRequests.0' 'SNMPv2-MIB::snmpOutGetNexts.0' 'SNMPv2-MIB::snmpOutSetRequests.0' 'SNMPv2-MIB::snmpOutGetResponses.0' 'SNMPv2-MIB::snmpOutTraps.0' 'SNMPv2-MIB::snmpSilentDrops.0' 'SNMPv2-MIB::snmpProxyDrops.0'[0m] SNMPv2-MIB::snmpInPkts.0 = 628068 SNMPv2-MIB::snmpOutPkts.0 = 628067 SNMPv2-MIB::snmpInBadVersions.0 = 0 SNMPv2-MIB::snmpInBadCommunityNames.0 = 0 SNMPv2-MIB::snmpInBadCommunityUses.0 = 0 SNMPv2-MIB::snmpInASNParseErrs.0 = 0 SNMPv2-MIB::snmpInTooBigs.0 = 0 SNMPv2-MIB::snmpInNoSuchNames.0 = 0 SNMPv2-MIB::snmpInBadValues.0 = 0 SNMPv2-MIB::snmpInReadOnlys.0 = 0 SNMPv2-MIB::snmpInGenErrs.0 = 0 SNMPv2-MIB::snmpInTotalReqVars.0 = 843186 SNMPv2-MIB::snmpInTotalSetVars.0 = 0 SNMPv2-MIB::snmpInGetRequests.0 = 16730 SNMPv2-MIB::snmpInGetNexts.0 = 597785 SNMPv2-MIB::snmpInSetRequests.0 = 0 SNMPv2-MIB::snmpInGetResponses.0 = 0 SNMPv2-MIB::snmpInTraps.0 = 0 SNMPv2-MIB::snmpOutTooBigs.0 = 0 SNMPv2-MIB::snmpOutNoSuchNames.0 = 0 SNMPv2-MIB::snmpOutBadValues.0 = 0 SNMPv2-MIB::snmpOutGenErrs.0 = 0 SNMPv2-MIB::snmpOutGetRequests.0 = 0 SNMPv2-MIB::snmpOutGetNexts.0 = 0 SNMPv2-MIB::snmpOutSetRequests.0 = 0 SNMPv2-MIB::snmpOutGetResponses.0 = 628067 SNMPv2-MIB::snmpOutTraps.0 = 0 SNMPv2-MIB::snmpSilentDrops.0 = 0 SNMPv2-MIB::snmpProxyDrops.0 = 0 RRD[[0;32mupdate /data/rrd/10.10.7.10/netstats-snmp.rrd N:628068:628067:0:0:0:0:0:0:0:0:0:843186:0:16730:597785:0:0:0:0:0:0:0:0:0:0:628067:0:0:0[0m] udp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'UDP-MIB::udpInDatagrams.0' 'UDP-MIB::udpOutDatagrams.0' 'UDP-MIB::udpInErrors.0' 'UDP-MIB::udpNoPorts.0'[0m] UDP-MIB::udpInDatagrams.0 = 12130872 UDP-MIB::udpOutDatagrams.0 = 11952682 UDP-MIB::udpInErrors.0 = 0 UDP-MIB::udpNoPorts.0 = 4 RRD[[0;32mupdate /data/rrd/10.10.7.10/netstats-udp.rrd N:12130872:11952682:0:4[0m] tcp SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'TCP-MIB::tcpActiveOpens.0' 'TCP-MIB::tcpPassiveOpens.0' 'TCP-MIB::tcpAttemptFails.0' 'TCP-MIB::tcpEstabResets.0' 'TCP-MIB::tcpCurrEstab.0' 'TCP-MIB::tcpInSegs.0' 'TCP-MIB::tcpOutSegs.0' 'TCP-MIB::tcpRetransSegs.0' 'TCP-MIB::tcpInErrs.0' 'TCP-MIB::tcpOutRsts.0'[0m] TCP-MIB::tcpActiveOpens.0 = 164483 TCP-MIB::tcpPassiveOpens.0 = 5822 TCP-MIB::tcpAttemptFails.0 = 148808 TCP-MIB::tcpEstabResets.0 = 0 TCP-MIB::tcpCurrEstab.0 = 56 TCP-MIB::tcpInSegs.0 = 11371544 TCP-MIB::tcpOutSegs.0 = 11747198 TCP-MIB::tcpRetransSegs.0 = 2722 TCP-MIB::tcpInErrs.0 = 0 TCP-MIB::tcpOutRsts.0 = 150994 RRD[[0;32mupdate /data/rrd/10.10.7.10/netstats-tcp.rrd N:164483:5822:148808:0:56:11371544:11747198:2722:0:150994[0m] >> Runtime for poller module 'netstats': 0.3845 seconds with 1816 bytes >> [0;36mSNMP[0m: [6/0.38s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [6/0.00s] #### Unload poller module netstats #### RRD[[0;32mupdate /data/rrd/10.10.7.10/poller-perf-netstats.rrd N:0.3844621181488[0m] Modules status: Global+ OS Device #### Load poller module hr-mib #### SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQs' '-m' 'HOST-RESOURCES-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'hrSystemMaxProcesses.0' 'hrSystemProcesses.0' 'hrSystemNumUsers.0'[0m] hrSystemMaxProcesses.0 = 0 hrSystemProcesses.0 = 120 hrSystemNumUsers.0 = 0 RRD[[0;32mupdate /data/rrd/10.10.7.10/hr_processes.rrd N:120[0m] ProcessesRRD[[0;32mupdate /data/rrd/10.10.7.10/hr_users.rrd N:0[0m] SQL[[1;33mselect * from `hrSystem` where (`device_id` = ?) limit 1 [0;33m[5][0m 1.18ms] Users >> Runtime for poller module 'hr-mib': 0.0500 seconds with 32704 bytes >> [0;36mSNMP[0m: [1/0.05s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [3/0.00s] #### Unload poller module hr-mib #### RRD[[0;32mupdate /data/rrd/10.10.7.10/poller-perf-hr-mib.rrd N:0.049960136413574[0m] Modules status: Global+ OS Device #### Load poller module ucd-mib #### SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'systemStats'[0m] ssIndex.0 = 1 ssErrorName.0 = systemStats ssSwapIn.0 = 0 ssSwapOut.0 = 0 ssIOSent.0 = 80 ssIOReceive.0 = 12 ssSysInterrupts.0 = 56 ssSysContext.0 = 71 ssCpuUser.0 = 0 ssCpuSystem.0 = 0 ssCpuIdle.0 = 98 ssCpuRawUser.0 = 205078 ssCpuRawNice.0 = 0 ssCpuRawSystem.0 = 295183 ssCpuRawIdle.0 = 28588046 ssCpuRawWait.0 = 762768 ssCpuRawKernel.0 = 256272 ssCpuRawInterrupt.0 = 17679 ssIORawSent.0 = 6909782 ssIORawReceived.0 = 2280085978 ssRawInterrupts.0 = 59282113 ssRawContexts.0 = 192525967 ssCpuRawSoftIRQ.0 = 21232 ssRawSwapIn.0 = 0 ssRawSwapOut.0 = 0 RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_cpu.rrd N:205078:295183:0:28588046[0m] RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_ssCpuRawUser.rrd N:205078[0m] RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_ssCpuRawNice.rrd N:0[0m] RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_ssCpuRawSystem.rrd N:295183[0m] RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_ssCpuRawIdle.rrd N:28588046[0m] RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_ssCpuRawInterrupt.rrd N:17679[0m] RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_ssCpuRawSoftIRQ.rrd N:21232[0m] RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_ssCpuRawKernel.rrd N:256272[0m] RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_ssCpuRawWait.rrd N:762768[0m] RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_ssIORawSent.rrd N:6909782[0m] RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_ssIORawReceived.rrd N:2280085978[0m] RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_ssRawInterrupts.rrd N:59282113[0m] RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_ssRawContexts.rrd N:192525967[0m] RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_ssRawSwapIn.rrd N:0[0m] RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_ssRawSwapOut.rrd N:0[0m] RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_ssCpuRawWait.rrd N:762768[0m] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-SNMP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'laLoadInt.1' 'laLoadInt.2' 'laLoadInt.3'[0m] laLoadInt.1 = 8 laLoadInt.2 = 2 laLoadInt.3 = 1 RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_load.rrd N:8:2:1[0m] >> Runtime for poller module 'ucd-mib': 0.1400 seconds with 1560 bytes >> [0;36mSNMP[0m: [2/0.13s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [18/0.01s] #### Unload poller module ucd-mib #### RRD[[0;32mupdate /data/rrd/10.10.7.10/poller-perf-ucd-mib.rrd N:0.14004898071289[0m] Modules status: Global+ OS Device #### Load poller module ipSystemStats #### SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ipSystemStats'[0m] ipSystemStatsTable = No Such Object available on this agent at this OID Invalid snmp_walk() data = ipSystemStatsTable = No Such Object available on this agent at this OID >> Runtime for poller module 'ipSystemStats': 0.0908 seconds with 48 bytes >> [0;36mSNMP[0m: [1/0.09s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [1/0.00s] #### Unload poller module ipSystemStats #### RRD[[0;32mupdate /data/rrd/10.10.7.10/poller-perf-ipSystemStats.rrd N:0.090752124786377[0m] Modules status: Global+ OS Device #### Load poller module ports #### SQL[[1;33mSELECT *, `ports_statistics`.`port_id` AS `ports_statistics_port_id`, `ports`.`port_id` AS `port_id` FROM `ports` LEFT OUTER JOIN `ports_statistics` ON `ports`.`port_id` = `ports_statistics`.`port_id` WHERE `ports`.`device_id` = ? ORDER BY ports.port_id [0;33m[5][0m 1.64ms] Caching Oids: Full ports polling SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifXEntry'[0m] ifXEntry = No Such Object available on this agent at this OID Invalid snmp_walk() data = ifXEntry = No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUst' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'ifEntry'[0m] ifIndex.1 = 1 ifIndex.2 = 2 ifIndex.3 = 3 ifIndex.4 = 4 ifIndex.5 = 5 ifDescr.1 = lo ifDescr.2 = eth0 ifDescr.3 = eth1 ifDescr.4 = asix0 ifDescr.5 = sit0 ifType.1 = softwareLoopback ifType.2 = ethernetCsmacd ifType.3 = ethernetCsmacd ifType.4 = ethernetCsmacd ifType.5 = tunnel ifMtu.1 = 16436 ifMtu.2 = 1500 ifMtu.3 = 1500 ifMtu.4 = 1500 ifMtu.5 = 1480 ifSpeed.1 = 10000000 ifSpeed.2 = 100000000 ifSpeed.3 = 100000000 ifSpeed.4 = 10000000 ifSpeed.5 = 0 ifPhysAddress.1 = ifPhysAddress.2 = 0:25:90:22:a5:aa ifPhysAddress.3 = 0:25:90:22:a5:ab ifPhysAddress.4 = 0:11:1f:9:ff:ff ifPhysAddress.5 = 0:0:0:0:ff:ff ifAdminStatus.1 = up ifAdminStatus.2 = up ifAdminStatus.3 = up ifAdminStatus.4 = up ifAdminStatus.5 = down ifOperStatus.1 = up ifOperStatus.2 = up ifOperStatus.3 = up ifOperStatus.4 = up ifOperStatus.5 = down ifInOctets.1 = 1645868320 ifInOctets.2 = 265987631 ifInOctets.3 = 131491272 ifInOctets.4 = 80941222 ifInOctets.5 = 0 ifInUcastPkts.1 = 21862177 ifInUcastPkts.2 = 1454069 ifInUcastPkts.3 = 131510 ifInUcastPkts.4 = 130230 ifInUcastPkts.5 = 0 ifInDiscards.1 = 0 ifInDiscards.2 = 0 ifInDiscards.3 = 0 ifInDiscards.4 = 0 ifInDiscards.5 = 0 ifInErrors.1 = 0 ifInErrors.2 = 0 ifInErrors.3 = 0 ifInErrors.4 = 0 ifInErrors.5 = 0 ifOutOctets.1 = 1645869154 ifOutOctets.2 = 257638324 ifOutOctets.3 = 31890900 ifOutOctets.4 = 39209326 ifOutOctets.5 = 0 ifOutUcastPkts.1 = 21862187 ifOutUcastPkts.2 = 1699217 ifOutUcastPkts.3 = 29812 ifOutUcastPkts.4 = 137667 ifOutUcastPkts.5 = 0 ifOutDiscards.1 = 0 ifOutDiscards.2 = 0 ifOutDiscards.3 = 0 ifOutDiscards.4 = 0 ifOutDiscards.5 = 0 ifOutErrors.1 = 0 ifOutErrors.2 = 0 ifOutErrors.3 = 0 ifOutErrors.4 = 0 ifOutErrors.5 = 0 ifOutQLen.1 = 0 ifOutQLen.2 = 0 ifOutQLen.3 = 0 ifOutQLen.4 = 0 ifOutQLen.5 = 0 ifSpecific.1 = zeroDotZero ifSpecific.2 = zeroDotZero ifSpecific.3 = zeroDotZero ifSpecific.4 = zeroDotZero ifSpecific.5 = zeroDotZero dot3StatsDuplexStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'EtherLike-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot3StatsDuplexStatus'[0m] dot3StatsDuplexStatus = No Such Object available on this agent at this OID Invalid snmp_walk() data = dot3StatsDuplexStatus = No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'dot1qPvid'[0m] dot1qPvid = No Such Object available on this agent at this OID Invalid snmp_walk() data = dot1qPvid = No Such Object available on this agent at this OID SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE `device_id` = ? AND `ifType` in ('adsl','vdsl','vdsl2') [0;33m[5][0m 0.96ms] array ( 1 => array ( 'ifIndex' => '1', 'ifDescr' => 'lo', 'ifType' => 'softwareLoopback', 'ifMtu' => '16436', 'ifSpeed' => '10000000', 'ifPhysAddress' => '', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifInOctets' => '1645868320', 'ifInUcastPkts' => '21862177', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifOutOctets' => '1645869154', 'ifOutUcastPkts' => '21862187', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 2 => array ( 'ifIndex' => '2', 'ifDescr' => 'eth0', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '1500', 'ifSpeed' => '100000000', 'ifPhysAddress' => '0:25:90:22:a5:aa', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifInOctets' => '265987631', 'ifInUcastPkts' => '1454069', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifOutOctets' => '257638324', 'ifOutUcastPkts' => '1699217', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 3 => array ( 'ifIndex' => '3', 'ifDescr' => 'eth1', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '1500', 'ifSpeed' => '100000000', 'ifPhysAddress' => '0:25:90:22:a5:ab', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifInOctets' => '131491272', 'ifInUcastPkts' => '131510', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifOutOctets' => '31890900', 'ifOutUcastPkts' => '29812', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 4 => array ( 'ifIndex' => '4', 'ifDescr' => 'asix0', 'ifType' => 'ethernetCsmacd', 'ifMtu' => '1500', 'ifSpeed' => '10000000', 'ifPhysAddress' => '0:11:1f:9:ff:ff', 'ifAdminStatus' => 'up', 'ifOperStatus' => 'up', 'ifInOctets' => '80941222', 'ifInUcastPkts' => '130230', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifOutOctets' => '39209326', 'ifOutUcastPkts' => '137667', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), 5 => array ( 'ifIndex' => '5', 'ifDescr' => 'sit0', 'ifType' => 'tunnel', 'ifMtu' => '1480', 'ifSpeed' => '0', 'ifPhysAddress' => '0:0:0:0:ff:ff', 'ifAdminStatus' => 'down', 'ifOperStatus' => 'down', 'ifInOctets' => '0', 'ifInUcastPkts' => '0', 'ifInDiscards' => '0', 'ifInErrors' => '0', 'ifOutOctets' => '0', 'ifOutUcastPkts' => '0', 'ifOutDiscards' => '0', 'ifOutErrors' => '0', 'ifOutQLen' => '0', 'ifSpecific' => 'zeroDotZero', ), ) valid valid valid valid valid Port lo: lo (1 / #26) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (10000000) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName lo ifInOctets (315866 B) 9024.7428571429 Bps 35 secs ifOutOctets (316283 B) 9036.6571428571 Bps 35 secs ifInErrors (0 B) 0 Bps 35 secs ifOutErrors (0 B) 0 Bps 35 secs ifInUcastPkts (3852 B) 110.05714285714 Bps 35 secs ifOutUcastPkts (3857 B) 110.2 Bps 35 secs ifInNUcastPkts (0 B) 0 Bps 35 secs ifOutNUcastPkts (0 B) 0 Bps 35 secs ifInDiscards (0 B) 0 Bps 35 secs ifOutDiscards (0 B) 0 Bps 35 secs ifInUnknownProtos (0 B) 0 Bps 35 secs ifInBroadcastPkts (0 B) 0 Bps 35 secs ifOutBroadcastPkts (0 B) 0 Bps 35 secs ifInMulticastPkts (0 B) 0 Bps 35 secs ifOutMulticastPkts (0 B) 0 Bps 35 secs bps(72.2 kbps/72.29 kbps)bytes(308.46 KiB/308.87 KiB)pkts(110.06 pps/110.2 pps)RRD warning: unused data sent ifInUcastPkts_rate RRD warning: unused data sent ifOutUcastPkts_rate RRD warning: unused data sent ifInErrors_rate RRD warning: unused data sent ifOutErrors_rate RRD warning: unused data sent ifInOctets_rate RRD warning: unused data sent ifOutOctets_rate RRD warning: unused data sent ifInBits_rate RRD warning: unused data sent ifOutBits_rate RRD[[0;32mupdate /data/rrd/10.10.7.10/port-id26.rrd N:1645868320:1645869154:0:0:21862177:21862187:U:U:0:0:U:U:U:U:U[0m] SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["1645868320",1645552454,9024.742857142857,315866,"1645869154",1645552871,9036.657142857142,316283,"0",0,0,0,"0",0,0,0,"21862177",21858325,110.05714285714286,3852,"21862187",21858330,110.2,3857,1654673663,1654673628,35,26][0m 3.98ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m[0,0,0,0,0,0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,26][0m 0.72ms] 1 updated Port eth0: eth0 (2 / #27) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (100000000) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName eth0 ifInOctets (72354 B) 2067.2571428571 Bps 35 secs ifOutOctets (67680 B) 1933.7142857143 Bps 35 secs ifInErrors (0 B) 0 Bps 35 secs ifOutErrors (0 B) 0 Bps 35 secs ifInUcastPkts (442 B) 12.628571428571 Bps 35 secs ifOutUcastPkts (468 B) 13.371428571429 Bps 35 secs ifInNUcastPkts (0 B) 0 Bps 35 secs ifOutNUcastPkts (0 B) 0 Bps 35 secs ifInDiscards (0 B) 0 Bps 35 secs ifOutDiscards (0 B) 0 Bps 35 secs ifInUnknownProtos (0 B) 0 Bps 35 secs ifInBroadcastPkts (0 B) 0 Bps 35 secs ifOutBroadcastPkts (0 B) 0 Bps 35 secs ifInMulticastPkts (0 B) 0 Bps 35 secs ifOutMulticastPkts (0 B) 0 Bps 35 secs bps(16.54 kbps/15.47 kbps)bytes(70.66 KiB/66.09 KiB)pkts(12.63 pps/13.37 pps)RRD warning: unused data sent ifInUcastPkts_rate RRD warning: unused data sent ifOutUcastPkts_rate RRD warning: unused data sent ifInErrors_rate RRD warning: unused data sent ifOutErrors_rate RRD warning: unused data sent ifInOctets_rate RRD warning: unused data sent ifOutOctets_rate RRD warning: unused data sent ifInBits_rate RRD warning: unused data sent ifOutBits_rate RRD[[0;32mupdate /data/rrd/10.10.7.10/port-id27.rrd N:265987631:257638324:0:0:1454069:1699217:U:U:0:0:U:U:U:U:U[0m] SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["265987631",265915277,2067.2571428571428,72354,"257638324",257570644,1933.7142857142858,67680,"0",0,0,0,"0",0,0,0,"1454069",1453627,12.628571428571428,442,"1699217",1698749,13.371428571428572,468,1654673663,1654673628,35,27][0m 5.95ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m[0,0,0,0,0,0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,27][0m 0.81ms] 1 updated Port eth1: eth1 (3 / #28) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (100000000) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName eth1 ifInOctets (34196 B) 977.02857142857 Bps 35 secs ifOutOctets (7490 B) 214 Bps 35 secs ifInErrors (0 B) 0 Bps 35 secs ifOutErrors (0 B) 0 Bps 35 secs ifInUcastPkts (34 B) 0.97142857142857 Bps 35 secs ifOutUcastPkts (7 B) 0.2 Bps 35 secs ifInNUcastPkts (0 B) 0 Bps 35 secs ifOutNUcastPkts (0 B) 0 Bps 35 secs ifInDiscards (0 B) 0 Bps 35 secs ifOutDiscards (0 B) 0 Bps 35 secs ifInUnknownProtos (0 B) 0 Bps 35 secs ifInBroadcastPkts (0 B) 0 Bps 35 secs ifOutBroadcastPkts (0 B) 0 Bps 35 secs ifInMulticastPkts (0 B) 0 Bps 35 secs ifOutMulticastPkts (0 B) 0 Bps 35 secs bps(7.82 kbps/1.71 kbps)bytes(33.39 KiB/7.31 KiB)pkts(0.97 pps/0.2 pps)RRD warning: unused data sent ifInUcastPkts_rate RRD warning: unused data sent ifOutUcastPkts_rate RRD warning: unused data sent ifInErrors_rate RRD warning: unused data sent ifOutErrors_rate RRD warning: unused data sent ifInOctets_rate RRD warning: unused data sent ifOutOctets_rate RRD warning: unused data sent ifInBits_rate RRD warning: unused data sent ifOutBits_rate RRD[[0;32mupdate /data/rrd/10.10.7.10/port-id28.rrd N:131491272:31890900:0:0:131510:29812:U:U:0:0:U:U:U:U:U[0m] SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["131491272",131457076,977.0285714285715,34196,"31890900",31883410,214,7490,"0",0,0,0,"0",0,0,0,"131510",131476,0.9714285714285714,34,"29812",29805,0.2,7,1654673663,1654673628,35,28][0m 6.37ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m[0,0,0,0,0,0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,28][0m 0.53ms] 1 updated Port asix0: asix0 (4 / #29) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (10000000) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName asix0 ifInOctets (32350 B) 924.28571428571 Bps 35 secs ifOutOctets (15652 B) 447.2 Bps 35 secs ifInErrors (0 B) 0 Bps 35 secs ifOutErrors (0 B) 0 Bps 35 secs ifInUcastPkts (52 B) 1.4857142857143 Bps 35 secs ifOutUcastPkts (55 B) 1.5714285714286 Bps 35 secs ifInNUcastPkts (0 B) 0 Bps 35 secs ifOutNUcastPkts (0 B) 0 Bps 35 secs ifInDiscards (0 B) 0 Bps 35 secs ifOutDiscards (0 B) 0 Bps 35 secs ifInUnknownProtos (0 B) 0 Bps 35 secs ifInBroadcastPkts (0 B) 0 Bps 35 secs ifOutBroadcastPkts (0 B) 0 Bps 35 secs ifInMulticastPkts (0 B) 0 Bps 35 secs ifOutMulticastPkts (0 B) 0 Bps 35 secs bps(7.39 kbps/3.58 kbps)bytes(31.59 KiB/15.29 KiB)pkts(1.49 pps/1.57 pps)RRD warning: unused data sent ifInUcastPkts_rate RRD warning: unused data sent ifOutUcastPkts_rate RRD warning: unused data sent ifInErrors_rate RRD warning: unused data sent ifOutErrors_rate RRD warning: unused data sent ifInOctets_rate RRD warning: unused data sent ifOutOctets_rate RRD warning: unused data sent ifInBits_rate RRD warning: unused data sent ifOutBits_rate RRD[[0;32mupdate /data/rrd/10.10.7.10/port-id29.rrd N:80941222:39209326:0:0:130230:137667:U:U:0:0:U:U:U:U:U[0m] SQL[[1;33mUPDATE `ports` set `ifInOctets`=?,`ifInOctets_prev`=?,`ifInOctets_rate`=?,`ifInOctets_delta`=?,`ifOutOctets`=?,`ifOutOctets_prev`=?,`ifOutOctets_rate`=?,`ifOutOctets_delta`=?,`ifInErrors`=?,`ifInErrors_prev`=?,`ifInErrors_rate`=?,`ifInErrors_delta`=?,`ifOutErrors`=?,`ifOutErrors_prev`=?,`ifOutErrors_rate`=?,`ifOutErrors_delta`=?,`ifInUcastPkts`=?,`ifInUcastPkts_prev`=?,`ifInUcastPkts_rate`=?,`ifInUcastPkts_delta`=?,`ifOutUcastPkts`=?,`ifOutUcastPkts_prev`=?,`ifOutUcastPkts_rate`=?,`ifOutUcastPkts_delta`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["80941222",80908872,924.2857142857143,32350,"39209326",39193674,447.2,15652,"0",0,0,0,"0",0,0,0,"130230",130178,1.4857142857142858,52,"137667",137612,1.5714285714285714,55,1654673663,1654673628,35,29][0m 7.95ms] SQL[[1;33mUPDATE `ports_statistics` set `ifInNUcastPkts`=?,`ifInNUcastPkts_prev`=?,`ifInNUcastPkts_rate`=?,`ifInNUcastPkts_delta`=?,`ifOutNUcastPkts`=?,`ifOutNUcastPkts_prev`=?,`ifOutNUcastPkts_rate`=?,`ifOutNUcastPkts_delta`=?,`ifInDiscards`=?,`ifInDiscards_prev`=?,`ifInDiscards_rate`=?,`ifInDiscards_delta`=?,`ifOutDiscards`=?,`ifOutDiscards_prev`=?,`ifOutDiscards_rate`=?,`ifOutDiscards_delta`=?,`ifInUnknownProtos`=?,`ifInUnknownProtos_prev`=?,`ifInUnknownProtos_rate`=?,`ifInUnknownProtos_delta`=?,`ifInBroadcastPkts`=?,`ifInBroadcastPkts_prev`=?,`ifInBroadcastPkts_rate`=?,`ifInBroadcastPkts_delta`=?,`ifOutBroadcastPkts`=?,`ifOutBroadcastPkts_prev`=?,`ifOutBroadcastPkts_rate`=?,`ifOutBroadcastPkts_delta`=?,`ifInMulticastPkts`=?,`ifInMulticastPkts_prev`=?,`ifInMulticastPkts_rate`=?,`ifInMulticastPkts_delta`=?,`ifOutMulticastPkts`=?,`ifOutMulticastPkts_prev`=?,`ifOutMulticastPkts_rate`=?,`ifOutMulticastPkts_delta`=? WHERE `port_id` = ? [0;33m[0,0,0,0,0,0,0,0,"0",0,0,0,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,29][0m 0.61ms] 1 updated Port sit0: sit0 (5 / #30) ifInOctets ifOutOctets ifInUcastPkts ifOutUcastPkts ifInBroadcastPkts ifOutBroadcastPkts ifInMulticastPkts ifOutMulticastPkts ifSpeed (0) VLAN = Using ifDescr as ifAlias Using ifDescr as ifName sit030 skipped because port is still down since last polling. SQL[[1;33mUPDATE `ports` set `ifSpeed_prev`=?,`poll_time`=?,`poll_prev`=?,`poll_period`=? WHERE `port_id` = ? [0;33m["0",1654673663,1654673628,35,30][0m 10.1ms] 1 updated SQL[[1;33mupdate `ports` set `poll_time` = ?, `poll_prev` = ?, `poll_period` = ? where 0 = 1 [0;33m[1654673663,1654673628,null][0m 0.42ms] 0 updated >> Runtime for poller module 'ports': 0.6404 seconds with 20104 bytes >> [0;36mSNMP[0m: [4/0.58s] [1;33mMySQL[0m: [12/0.40s] [0;32mRRD[0m: [5/0.00s] #### Unload poller module ports #### RRD[[0;32mupdate /data/rrd/10.10.7.10/poller-perf-ports.rrd N:0.64040112495422[0m] Modules status: Global+ OS Device #### Load poller module customoid #### SQL[[1;33mSELECT * FROM `customoids` WHERE `customoid_passed` = 1 AND `device_id` = ? [0;33m[5][0m 0.71ms] >> Runtime for poller module 'customoid': 0.0015 seconds with 40 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [1/0.00s] #### Unload poller module customoid #### RRD[[0;32mupdate /data/rrd/10.10.7.10/poller-perf-customoid.rrd N:0.0014641284942627[0m] Modules status: Global+ OS- Device Module [ bgp-peers ] disabled on os. 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[5][0m 0.85ms] SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'UCD-DISKIO-MIB' '-M' '/opt/librenms/mibs' 'udp:HOSTNAME:161' 'diskIOEntry'[0m] diskIOIndex.1 = 1 diskIOIndex.2 = 2 diskIOIndex.3 = 3 diskIOIndex.4 = 4 diskIOIndex.5 = 5 diskIOIndex.6 = 6 diskIOIndex.7 = 7 diskIOIndex.8 = 8 diskIOIndex.9 = 9 diskIOIndex.10 = 10 diskIOIndex.11 = 11 diskIOIndex.12 = 12 diskIOIndex.13 = 13 diskIOIndex.14 = 14 diskIOIndex.15 = 15 diskIOIndex.16 = 16 diskIOIndex.17 = 17 diskIOIndex.18 = 18 diskIOIndex.19 = 19 diskIOIndex.20 = 20 diskIOIndex.21 = 21 diskIOIndex.22 = 22 diskIOIndex.23 = 23 diskIOIndex.24 = 24 diskIOIndex.25 = 25 diskIOIndex.26 = 26 diskIOIndex.27 = 27 diskIOIndex.28 = 28 diskIOIndex.29 = 29 diskIODevice.1 = fd0 diskIODevice.2 = loop0 diskIODevice.3 = loop1 diskIODevice.4 = loop2 diskIODevice.5 = loop3 diskIODevice.6 = loop4 diskIODevice.7 = loop5 diskIODevice.8 = loop6 diskIODevice.9 = loop7 diskIODevice.10 = sda diskIODevice.11 = sda1 diskIODevice.12 = sda2 diskIODevice.13 = sdb diskIODevice.14 = sdb1 diskIODevice.15 = sdb2 diskIODevice.16 = sdc diskIODevice.17 = sdc1 diskIODevice.18 = sdc2 diskIODevice.19 = sdg diskIODevice.20 = sdg1 diskIODevice.21 = sdg2 diskIODevice.22 = sdg5 diskIODevice.23 = sdg6 diskIODevice.24 = sdg7 diskIODevice.25 = sdg8 diskIODevice.26 = sdg9 diskIODevice.27 = sr0 diskIODevice.28 = md0 diskIODevice.29 = md1 diskIONRead.1 = 0 diskIONRead.2 = 0 diskIONRead.3 = 0 diskIONRead.4 = 0 diskIONRead.5 = 0 diskIONRead.6 = 0 diskIONRead.7 = 0 diskIONRead.8 = 0 diskIONRead.9 = 0 diskIONRead.10 = 2398318592 diskIONRead.11 = 138235904 diskIONRead.12 = 2241069056 diskIONRead.13 = 4085986304 diskIONRead.14 = 87031808 diskIONRead.15 = 2193248256 diskIONRead.16 = 4086192640 diskIONRead.17 = 86962176 diskIONRead.18 = 2191581184 diskIONRead.19 = 4767744 diskIONRead.20 = 5755904 diskIONRead.21 = 2048 diskIONRead.22 = 467968 diskIONRead.23 = 91452928 diskIONRead.24 = 4517888 diskIONRead.25 = 191031296 diskIONRead.26 = 189440 diskIONRead.27 = 0 diskIONRead.28 = 3070787584 diskIONRead.29 = 0 diskIONWritten.1 = 0 diskIONWritten.2 = 0 diskIONWritten.3 = 0 diskIONWritten.4 = 0 diskIONWritten.5 = 0 diskIONWritten.6 = 0 diskIONWritten.7 = 0 diskIONWritten.8 = 0 diskIONWritten.9 = 0 diskIONWritten.10 = 1263439872 diskIONWritten.11 = 875409408 diskIONWritten.12 = 10932224 diskIONWritten.13 = 748871680 diskIONWritten.14 = 836308992 diskIONWritten.15 = 9953280 diskIONWritten.16 = 2367307776 diskIONWritten.17 = 832241664 diskIONWritten.18 = 10199040 diskIONWritten.19 = 33855488 diskIONWritten.20 = 7168 diskIONWritten.21 = 0 diskIONWritten.22 = 0 diskIONWritten.23 = 1900544 diskIONWritten.24 = 304080896 diskIONWritten.25 = 1376366592 diskIONWritten.26 = 0 diskIONWritten.27 = 0 diskIONWritten.28 = 11317248 diskIONWritten.29 = 0 diskIOReads.1 = 0 diskIOReads.2 = 0 diskIOReads.3 = 0 diskIOReads.4 = 0 diskIOReads.5 = 0 diskIOReads.6 = 0 diskIOReads.7 = 0 diskIOReads.8 = 0 diskIOReads.9 = 0 diskIOReads.10 = 3075920 diskIOReads.11 = 71213 diskIOReads.12 = 94957952 diskIOReads.13 = 3065997 diskIOReads.14 = 21284 diskIOReads.15 = 94908327 diskIOReads.16 = 3065343 diskIOReads.17 = 21267 diskIOReads.18 = 94907885 diskIOReads.19 = 12387 diskIOReads.20 = 1651 diskIOReads.21 = 2 diskIOReads.22 = 690 diskIOReads.23 = 7906 diskIOReads.24 = 3154 diskIOReads.25 = 7875 diskIOReads.26 = 370 diskIOReads.27 = 0 diskIOReads.28 = 9235932 diskIOReads.29 = 65 diskIOWrites.1 = 0 diskIOWrites.2 = 0 diskIOWrites.3 = 0 diskIOWrites.4 = 0 diskIOWrites.5 = 0 diskIOWrites.6 = 0 diskIOWrites.7 = 0 diskIOWrites.8 = 0 diskIOWrites.9 = 0 diskIOWrites.10 = 138390 diskIOWrites.11 = 213723 diskIOWrites.12 = 2669 diskIOWrites.13 = 759459576 diskIOWrites.14 = 204177 diskIOWrites.15 = 2430 diskIOWrites.16 = 759457568 diskIOWrites.17 = 203184 diskIOWrites.18 = 2490 diskIOWrites.19 = 573513 diskIOWrites.20 = 8 diskIOWrites.21 = 0 diskIOWrites.22 = 0 diskIOWrites.23 = 464 diskIOWrites.24 = 296960 diskIOWrites.25 = 336034 diskIOWrites.26 = 0 diskIOWrites.27 = 0 diskIOWrites.28 = 783 diskIOWrites.29 = 634 sda array ( 'diskIOIndex' => '10', 'diskIODevice' => 'sda', 'diskIONRead' => '2398318592', 'diskIONWritten' => '1263439872', 'diskIOReads' => '3075920', 'diskIOWrites' => '138390', ) RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_diskio-sda.rrd N:U:U:3075920:138390[0m] sda1 array ( 'diskIOIndex' => '11', 'diskIODevice' => 'sda1', 'diskIONRead' => '138235904', 'diskIONWritten' => '875409408', 'diskIOReads' => '71213', 'diskIOWrites' => '213723', ) RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_diskio-sda1.rrd N:U:U:71213:213723[0m] sda2 array ( 'diskIOIndex' => '12', 'diskIODevice' => 'sda2', 'diskIONRead' => '2241069056', 'diskIONWritten' => '10932224', 'diskIOReads' => '94957952', 'diskIOWrites' => '2669', ) RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_diskio-sda2.rrd N:U:U:94957952:2669[0m] sdb array ( 'diskIOIndex' => '13', 'diskIODevice' => 'sdb', 'diskIONRead' => '4085986304', 'diskIONWritten' => '748871680', 'diskIOReads' => '3065997', 'diskIOWrites' => '759459576', ) RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_diskio-sdb.rrd N:U:U:3065997:759459576[0m] sdb1 array ( 'diskIOIndex' => '14', 'diskIODevice' => 'sdb1', 'diskIONRead' => '87031808', 'diskIONWritten' => '836308992', 'diskIOReads' => '21284', 'diskIOWrites' => '204177', ) RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_diskio-sdb1.rrd N:U:U:21284:204177[0m] sdb2 array ( 'diskIOIndex' => '15', 'diskIODevice' => 'sdb2', 'diskIONRead' => '2193248256', 'diskIONWritten' => '9953280', 'diskIOReads' => '94908327', 'diskIOWrites' => '2430', ) RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_diskio-sdb2.rrd N:U:U:94908327:2430[0m] sdc array ( 'diskIOIndex' => '16', 'diskIODevice' => 'sdc', 'diskIONRead' => '4086192640', 'diskIONWritten' => '2367307776', 'diskIOReads' => '3065343', 'diskIOWrites' => '759457568', ) RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_diskio-sdc.rrd N:U:U:3065343:759457568[0m] sdc1 array ( 'diskIOIndex' => '17', 'diskIODevice' => 'sdc1', 'diskIONRead' => '86962176', 'diskIONWritten' => '832241664', 'diskIOReads' => '21267', 'diskIOWrites' => '203184', ) RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_diskio-sdc1.rrd N:U:U:21267:203184[0m] sdc2 array ( 'diskIOIndex' => '18', 'diskIODevice' => 'sdc2', 'diskIONRead' => '2191581184', 'diskIONWritten' => '10199040', 'diskIOReads' => '94907885', 'diskIOWrites' => '2490', ) RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_diskio-sdc2.rrd N:U:U:94907885:2490[0m] sdg array ( 'diskIOIndex' => '19', 'diskIODevice' => 'sdg', 'diskIONRead' => '4767744', 'diskIONWritten' => '33855488', 'diskIOReads' => '12387', 'diskIOWrites' => '573513', ) RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_diskio-sdg.rrd N:U:U:12387:573513[0m] sdg1 array ( 'diskIOIndex' => '20', 'diskIODevice' => 'sdg1', 'diskIONRead' => '5755904', 'diskIONWritten' => '7168', 'diskIOReads' => '1651', 'diskIOWrites' => '8', ) RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_diskio-sdg1.rrd N:U:U:1651:8[0m] sdg2 array ( 'diskIOIndex' => '21', 'diskIODevice' => 'sdg2', 'diskIONRead' => '2048', 'diskIONWritten' => '0', 'diskIOReads' => '2', 'diskIOWrites' => '0', ) RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_diskio-sdg2.rrd N:U:U:2:0[0m] sdg5 array ( 'diskIOIndex' => '22', 'diskIODevice' => 'sdg5', 'diskIONRead' => '467968', 'diskIONWritten' => '0', 'diskIOReads' => '690', 'diskIOWrites' => '0', ) RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_diskio-sdg5.rrd N:U:U:690:0[0m] sdg6 array ( 'diskIOIndex' => '23', 'diskIODevice' => 'sdg6', 'diskIONRead' => '91452928', 'diskIONWritten' => '1900544', 'diskIOReads' => '7906', 'diskIOWrites' => '464', ) RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_diskio-sdg6.rrd N:U:U:7906:464[0m] sdg7 array ( 'diskIOIndex' => '24', 'diskIODevice' => 'sdg7', 'diskIONRead' => '4517888', 'diskIONWritten' => '304080896', 'diskIOReads' => '3154', 'diskIOWrites' => '296960', ) RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_diskio-sdg7.rrd N:U:U:3154:296960[0m] sdg8 array ( 'diskIOIndex' => '25', 'diskIODevice' => 'sdg8', 'diskIONRead' => '191031296', 'diskIONWritten' => '1376366592', 'diskIOReads' => '7875', 'diskIOWrites' => '336034', ) RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_diskio-sdg8.rrd N:U:U:7875:336034[0m] sdg9 array ( 'diskIOIndex' => '26', 'diskIODevice' => 'sdg9', 'diskIONRead' => '189440', 'diskIONWritten' => '0', 'diskIOReads' => '370', 'diskIOWrites' => '0', ) RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_diskio-sdg9.rrd N:U:U:370:0[0m] md0 array ( 'diskIOIndex' => '28', 'diskIODevice' => 'md0', 'diskIONRead' => '3070787584', 'diskIONWritten' => '11317248', 'diskIOReads' => '9235932', 'diskIOWrites' => '783', ) RRD[[0;32mupdate /data/rrd/10.10.7.10/ucd_diskio-md0.rrd N:U:U:9235932:783[0m] >> Runtime for poller module 'ucd-diskio': 0.4631 seconds with 4176 bytes >> [0;36mSNMP[0m: [1/0.46s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [19/0.00s] #### Unload poller module ucd-diskio #### RRD[[0;32mupdate /data/rrd/10.10.7.10/poller-perf-ucd-diskio.rrd N:0.46312594413757[0m] Modules status: Global- OS Device Module [ wifi ] disabled globally. Modules status: Global+ OS Device #### Load poller module wireless #### Attempting to initialize OS: linux Attempting to initialize Group OS: unix OS initialized: LibreNMS\OS\Shared\Unix SQL[[1;33mSELECT * FROM `wireless_sensors` WHERE `device_id` = ? [0;33m[5][0m 1.16ms] >> Runtime for poller module 'wireless': 0.0059 seconds with 97616 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [1/0.00s] #### Unload poller module wireless #### RRD[[0;32mupdate /data/rrd/10.10.7.10/poller-perf-wireless.rrd N:0.0059030055999756[0m] Modules status: Global+ OS- Device Module [ ospf ] disabled on os. Modules status: Global- OS Device Module [ isis ] disabled globally. Modules status: Global- OS Device Module [ cisco-ipsec-flow-monitor ] disabled globally. Modules status: Global- OS Device Module [ cisco-remote-access-monitor ] disabled globally. Modules status: Global- OS Device Module [ cisco-cef ] disabled globally. Modules status: Global- OS Device Module [ slas ] disabled globally. Modules status: Global- OS Device Module [ cisco-mac-accounting ] disabled globally. Modules status: Global- OS Device Module [ cipsec-tunnels ] disabled globally. Modules status: Global- OS Device Module [ cisco-ace-loadbalancer ] disabled globally. Modules status: Global- OS Device Module [ cisco-ace-serverfarms ] disabled globally. Modules status: Global- OS Device Module [ cisco-asa-firewall ] disabled globally. Modules status: Global- OS Device Module [ cisco-voice ] disabled globally. Modules status: Global- OS Device Module [ cisco-cbqos ] disabled globally. Modules status: Global- OS Device Module [ cisco-otv ] disabled globally. Modules status: Global- OS Device Module [ cisco-qfp ] disabled globally. Modules status: Global- OS Device Module [ cisco-vpdn ] disabled globally. Modules status: Global- OS Device Module [ nac ] disabled globally. Modules status: Global- OS Device Module [ netscaler-vsvr ] disabled globally. Modules status: Global- OS Device Module [ aruba-controller ] disabled globally. Modules status: Global+ OS Device #### Load poller module entity-physical #### >> Runtime for poller module 'entity-physical': 0.0002 seconds with 80 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [1/0.00s] #### Unload poller module entity-physical #### RRD[[0;32mupdate /data/rrd/10.10.7.10/poller-perf-entity-physical.rrd N:0.00024986267089844[0m] Modules status: Global- OS Device Module [ entity-state ] disabled globally. Modules status: Global+ OS Device #### Load poller module applications #### SQL[[1;33mSELECT * FROM `applications` WHERE `device_id` = ? [0;33m[5][0m 0.89ms] >> Runtime for poller module 'applications': 0.0014 seconds with 80 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [1/0.00s] #### Unload poller module applications #### RRD[[0;32mupdate /data/rrd/10.10.7.10/poller-perf-applications.rrd N:0.001431941986084[0m] Modules status: Global- OS Device Module [ mib ] disabled globally. Modules status: Global+ OS- Device Module [ stp ] disabled on os. Modules status: Global+ OS Device #### Load poller module ntp #### >> Runtime for poller module 'ntp': 0.0002 seconds with 80 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [1/0.00s] #### Unload poller module ntp #### RRD[[0;32mupdate /data/rrd/10.10.7.10/poller-perf-ntp.rrd N:0.00022602081298828[0m] 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.0009 seconds with 488 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [1/0.00s] #### Unload poller module mpls #### RRD[[0;32mupdate /data/rrd/10.10.7.10/poller-perf-mpls.rrd N:0.00092911720275879[0m] RRD[[0;32mupdate /data/rrd/10.10.7.10/poller-perf.rrd N:3.471[0m] Enabling graphs: SQL[[1;33mselect * from `device_graphs` where `device_graphs`.`device_id` = ? and `device_graphs`.`device_id` is not null [0;33m[5][0m 1.06ms] SQL[[1;33mUPDATE `devices` set `last_polled`=NOW(),`last_polled_timetaken`=? WHERE `device_id` = ? [0;33m[3.471,5][0m 9.85ms] Updating 10.10.7.10 Polled in 3.471 seconds ### Start Device Groups ### SQL[[1;33mselect * from `device_groups` [0;33m[][0m 31.61ms] SQL[[1;33mselect `devices`.`device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id`, `device_group_device`.`device_id` as `pivot_device_id` from `devices` inner join `device_group_device` on `devices`.`device_id` = `device_group_device`.`device_id` where `device_group_device`.`device_group_id` in (1, 2, 3, 4) [0;33m[][0m 1.25ms] SQL[[1;33mselect exists(select * from `devices` left join `ports` on `devices`.`device_id` = `ports`.`device_id` left join `ipv4_addresses` on `ports`.`port_id` = `ipv4_addresses`.`port_id` where (`ipv4_addresses`.`ipv4_address` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[41m92.168.10.%",5][0m 1.26ms] SQL[[1;33mselect exists(select * from `devices` left join `ports` on `devices`.`device_id` = `ports`.`device_id` left join `ipv4_addresses` on `ports`.`port_id` = `ipv4_addresses`.`port_id` where (`ipv4_addresses`.`ipv4_address` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[41m0.10.7.%",5][0m 0.98ms] SQL[[1;33mselect exists(select * from `devices` left join `ports` on `devices`.`device_id` = `ports`.`device_id` left join `ipv4_addresses` on `ports`.`port_id` = `ipv4_addresses`.`port_id` where (`ipv4_addresses`.`ipv4_address` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[41m0.10.10.%",5][0m 1.03ms] SQL[[1;33mselect exists(select * from `devices` left join `ports` on `devices`.`device_id` = `ports`.`device_id` left join `ipv4_addresses` on `ports`.`port_id` = `ipv4_addresses`.`port_id` where (`ipv4_addresses`.`ipv4_address` LIKE ?) and `devices`.`device_id` = ?) as `exists` [0;33m["[41m0.10.31.%",5][0m 0.97ms] SQL[[1;33mselect * from `device_group_device` where `device_group_device`.`device_id` = ? [0;33m[5][0m 0.85ms] Groups Added: Groups Removed: ### End Device Groups, runtime: 0.0622s ### #### Start Alerts #### SQL[[1;33mselect `device_groups`.*, `device_group_device`.`device_id` as `pivot_device_id`, `device_group_device`.`device_group_id` as `pivot_device_group_id` from `device_groups` inner join `device_group_device` on `device_groups`.`id` = `device_group_device`.`device_group_id` where `device_group_device`.`device_id` = ? [0;33m[5][0m 1.14ms] SQL[[1;33mselect exists(select * from `alert_schedule` where (`start` <= ? and `end` >= ? and (`recurring` = ? or (`recurring` = ? and ((time(`start`) < time xss=removed> ?) or (time(`start`) > time(`end`) and (time(`end`) <= ? or time(`start`) > ?))) and (`recurring_day` like ? or `recurring_day` is null)))) and (exists (select * from `devices` inner join `alert_schedulables` on `devices`.`device_id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?) or exists (select * from `device_groups` inner join `alert_schedulables` on `device_groups`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` in (2)) or exists (select * from `locations` inner join `alert_schedulables` on `locations`.`id` = `alert_schedulables`.`alert_schedulable_id` where `alert_schedule`.`schedule_id` = `alert_schedulables`.`schedule_id` and `alert_schedulables`.`alert_schedulable_type` = ? and `alert_schedulables`.`alert_schedulable_id` = ?))) as `exists` [0;33m["2022-06-08T07:34:24.566066Z","2022-06-08T07:34:24.566066Z",0,1,"07:34:24","07:34:24","07:34:24","07:34:24","[43m%","device",5,"device_group","location",3][0m 1.71ms] SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[5][0m 1.06ms] 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[5,5,5,5,5,5,5,5][0m 2.24ms] #### End Alerts #### ./poller.php 10.10.7.10 2022-06-08 09:34:24 - 1 devices polled in 3.910 secs [0;36mSNMP[0m [21/2.20s]: Snmpget[13/0.77s] Snmpwalk[8/1.43s] [1;33mSQL[0m [68/1.69s]: Select[41/0.75s] Insert[1/0.12s] Update[26/0.82s] [0;32mRRD[0m [84/0.02s]: Update[84/0.02s]