LibreNMS Discovery SQL[[1;33mselect `migration` from `migrations` order by `id` desc limit 1 [0;33m[][0m 0.84ms] SQL[[1;33mselect count(*) as aggregate from `migrations` [0;33m[][0m 0.63ms] SQL[[1;33mselect version() [0;33m[][0m 0.79ms] =========================================== Component | Version --------- | ------- LibreNMS | 22.10.0-113-gc26cbc9a4 (2022-11-14T10:19:08-06:00) DB Schema | 2022_08_15_084507_add_rrd_type_to_wireless_sensors_table (248) PHP | 8.1.12 Python | 3.8.10 Database | MariaDB 10.5.9-MariaDB-1:10.5.9+maria~bionic RRDTool | 1.7.2 SNMP | 5.8 =========================================== DEBUG! Updating os_def.cache Reporting disabled by user setting SQL[[1;33mSELECT * FROM `devices` WHERE disabled = 0 AND `hostname` LIKE '172.22.1.64' ORDER BY device_id DESC [0;33m[][0m 2.01ms] SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[312][0m 1.33ms] SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[312][0m 0.84ms] 172.22.1.64 312 edgeswitch [FPING] '/usr/bin/fping' '-e' '-q' '-c' '3' '-p' '500' '-t' '500' '-O' '0' '172.22.1.64' response: xmt/rcv/%loss = 3/3/0%, min/avg/max = 1.5/1.52/1.56 SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0'[0m] SNMPv2-MIB::sysObjectID.0 = EdgeSwitch-REF-MIB::broadcom Modules status: Global+ OS Device #### Load disco module core #### Attempting to initialize OS: edgeswitch OS initialized: LibreNMS\OS\Edgeswitch SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' '-v2c' '-c' 'COMMUNITY' '-OQXUte' '-On' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysObjectID.0' 'SNMPv2-MIB::sysDescr.0' 'SNMPv2-MIB::sysName.0'[0m] .*.*.0 = .*.4.1.4413 .*.*.0 = US-24-250W, *04, Linux 3.6.5 .*.*.0 = KensingtonCODC | US-24-250W, 6.3.13.14104, Linux 3.6.5 | .1.3.6.1.4.1.4413 | OS: EdgeSwitch (edgeswitch) Attempting to initialize OS: edgeswitch OS initialized: LibreNMS\OS\Edgeswitch >> Runtime for discovery module 'core': 0.4560 seconds with -52448 bytes >> [0;36mSNMP[0m: [1/0.42s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module core #### Modules status: Global+ OS Device #### Load disco module os #### Yaml location data: SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'SNMPv2-MIB::sysLocation.0'[0m] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Ovq' '-m' 'SNMPv2-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'sysContact.0'[0m] SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OUQ' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'ENTITY-MIB::entPhysicalSerialNum.1'[0m] ENTITY-MIB::entPhysicalSerialNum.1 = 7483c24a433b Yaml OS data: {"ENTITY-MIB::entPhysicalSerialNum.1":"7483c24a433b"} Location: Hardware: US-24-250W OS Version: 6.3.13.14104 OS Features: Serial: 7483c24a433b >> Runtime for discovery module 'os': 0.9800 seconds with 234688 bytes >> [0;36mSNMP[0m: [4/0.96s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module os #### Modules status: Global+ OS Device #### Load disco module ports #### SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'ifDescr'[0m] ifDescr.1 = Slot: 0 Port: 1 Gigabit - Level ifDescr.2 = Slot: 0 Port: 2 Gigabit - Level ifDescr.3 = Slot: 0 Port: 3 Gigabit - Level ifDescr.4 = Slot: 0 Port: 4 Gigabit - Level ifDescr.5 = Slot: 0 Port: 5 Gigabit - Level ifDescr.6 = Slot: 0 Port: 6 Gigabit - Level ifDescr.7 = Slot: 0 Port: 7 Gigabit - Level ifDescr.8 = Slot: 0 Port: 8 Gigabit - Level ifDescr.9 = Slot: 0 Port: 9 Gigabit - Level ifDescr.10 = Slot: 0 Port: 10 Gigabit - Level ifDescr.11 = Slot: 0 Port: 11 Gigabit - Level ifDescr.12 = Slot: 0 Port: 12 Gigabit - Level ifDescr.13 = Slot: 0 Port: 13 Gigabit - Level ifDescr.14 = Slot: 0 Port: 14 Gigabit - Level ifDescr.15 = Slot: 0 Port: 15 Gigabit - Level ifDescr.16 = Slot: 0 Port: 16 Gigabit - Level ifDescr.17 = Slot: 0 Port: 17 Gigabit - Level ifDescr.18 = Slot: 0 Port: 18 Gigabit - Level ifDescr.19 = Slot: 0 Port: 19 Gigabit - Level ifDescr.20 = Slot: 0 Port: 20 Gigabit - Level ifDescr.21 = Slot: 0 Port: 21 Gigabit - Level ifDescr.22 = Slot: 0 Port: 22 Gigabit - Level ifDescr.23 = Slot: 0 Port: 23 Gigabit - Level ifDescr.24 = Slot: 0 Port: 24 Gigabit - Level ifDescr.25 = Slot: 0 Port: 25 Gigabit - Level ifDescr.26 = Slot: 0 Port: 26 Gigabit - Level ifDescr.65 = CPU Interface for Slot: 5 Port: 1 ifDescr.66 = Link Aggregate 1 ifDescr.67 = Link Aggregate 2 ifDescr.68 = Link Aggregate 3 ifDescr.69 = Link Aggregate 4 ifDescr.70 = Link Aggregate 5 ifDescr.71 = Link Aggregate 6 ifDescr.72 = Link Aggregate 7 ifDescr.73 = Link Aggregate 8 ifDescr.74 = Link Aggregate 9 ifDescr.75 = Link Aggregate 10 ifDescr.76 = Link Aggregate 11 ifDescr.77 = Link Aggregate 12 ifDescr.78 = Link Aggregate 13 ifDescr.79 = Link Aggregate 14 ifDescr.80 = Link Aggregate 15 ifDescr.81 = Link Aggregate 16 SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'ifName'[0m] ifName.1 = 0/1 ifName.2 = 0/2 ifName.3 = 0/3 ifName.4 = 0/4 ifName.5 = 0/5 ifName.6 = 0/6 ifName.7 = 0/7 ifName.8 = 0/8 ifName.9 = 0/9 ifName.10 = 0/10 ifName.11 = 0/11 ifName.12 = 0/12 ifName.13 = 0/13 ifName.14 = 0/14 ifName.15 = 0/15 ifName.16 = 0/16 ifName.17 = 0/17 ifName.18 = 0/18 ifName.19 = 0/19 ifName.20 = 0/20 ifName.21 = 0/21 ifName.22 = 0/22 ifName.23 = 0/23 ifName.24 = 0/24 ifName.25 = 0/25 ifName.26 = 0/26 ifName.65 = CPU Interface: 5/1 ifName.66 = 3/1 ifName.67 = 3/2 ifName.68 = 3/3 ifName.69 = 3/4 ifName.70 = 3/5 ifName.71 = 3/6 ifName.72 = 3/7 ifName.73 = 3/8 ifName.74 = 3/9 ifName.75 = 3/10 ifName.76 = 3/11 ifName.77 = 3/12 ifName.78 = 3/13 ifName.79 = 3/14 ifName.80 = 3/15 ifName.81 = 3/16 SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'ifAlias'[0m] ifAlias.1 = Port 1 ifAlias.2 = Port 2 ifAlias.3 = Port 3 ifAlias.4 = Port 4 ifAlias.5 = Port 5 ifAlias.6 = Port 6 ifAlias.7 = Port 7 ifAlias.8 = Port 8 ifAlias.9 = Port 9 ifAlias.10 = Port 10 ifAlias.11 = Port 11 ifAlias.12 = Port 12 ifAlias.13 = Port 13 ifAlias.14 = Port 14 ifAlias.15 = Port 15 ifAlias.16 = Port 16 ifAlias.17 = Port 17 ifAlias.18 = Port 18 ifAlias.19 = Port 19 ifAlias.20 = Port 20 ifAlias.21 = Port 21 ifAlias.22 = Port 22 ifAlias.23 = KTown CO mFi ifAlias.24 = KTown CO AP ifAlias.25 = SFP 1 ifAlias.26 = SFP 2 ifAlias.65 = ifAlias.66 = ifAlias.67 = ifAlias.68 = ifAlias.69 = ifAlias.70 = ifAlias.71 = ifAlias.72 = ifAlias.73 = ifAlias.74 = ifAlias.75 = ifAlias.76 = ifAlias.77 = ifAlias.78 = ifAlias.79 = ifAlias.80 = ifAlias.81 = SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'ifType'[0m] ifType.1 = ethernetCsmacd ifType.2 = ethernetCsmacd ifType.3 = ethernetCsmacd ifType.4 = ethernetCsmacd ifType.5 = ethernetCsmacd ifType.6 = ethernetCsmacd ifType.7 = ethernetCsmacd ifType.8 = ethernetCsmacd ifType.9 = ethernetCsmacd ifType.10 = ethernetCsmacd ifType.11 = ethernetCsmacd ifType.12 = ethernetCsmacd ifType.13 = ethernetCsmacd ifType.14 = ethernetCsmacd ifType.15 = ethernetCsmacd ifType.16 = ethernetCsmacd ifType.17 = ethernetCsmacd ifType.18 = ethernetCsmacd ifType.19 = ethernetCsmacd ifType.20 = ethernetCsmacd ifType.21 = ethernetCsmacd ifType.22 = ethernetCsmacd ifType.23 = ethernetCsmacd ifType.24 = ethernetCsmacd ifType.25 = ethernetCsmacd ifType.26 = ethernetCsmacd ifType.65 = other ifType.66 = other ifType.67 = other ifType.68 = other ifType.69 = other ifType.70 = other ifType.71 = other ifType.72 = other ifType.73 = other ifType.74 = other ifType.75 = other ifType.76 = other ifType.77 = other ifType.78 = other ifType.79 = other ifType.80 = other ifType.81 = other SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'ifOperStatus'[0m] ifOperStatus.1 = up ifOperStatus.2 = up ifOperStatus.3 = up ifOperStatus.4 = up ifOperStatus.5 = up ifOperStatus.6 = up ifOperStatus.7 = up ifOperStatus.8 = down ifOperStatus.9 = down ifOperStatus.10 = down ifOperStatus.11 = down ifOperStatus.12 = down ifOperStatus.13 = down ifOperStatus.14 = down ifOperStatus.15 = down ifOperStatus.16 = down ifOperStatus.17 = down ifOperStatus.18 = down ifOperStatus.19 = down ifOperStatus.20 = down ifOperStatus.21 = down ifOperStatus.22 = down ifOperStatus.23 = up ifOperStatus.24 = up ifOperStatus.25 = down ifOperStatus.26 = down ifOperStatus.65 = up ifOperStatus.66 = down ifOperStatus.67 = down ifOperStatus.68 = down ifOperStatus.69 = down ifOperStatus.70 = down ifOperStatus.71 = down ifOperStatus.72 = down ifOperStatus.73 = down ifOperStatus.74 = down ifOperStatus.75 = down ifOperStatus.76 = down ifOperStatus.77 = down ifOperStatus.78 = down ifOperStatus.79 = down ifOperStatus.80 = down ifOperStatus.81 = down array ( 1 => array ( 'ifDescr' => 'Slot: 0 Port: 1 Gigabit - Level', 'ifName' => '0/1', 'ifAlias' => 'Port 1', 'ifType' => 'ethernetCsmacd', 'ifOperStatus' => 'up', ), 2 => array ( 'ifDescr' => 'Slot: 0 Port: 2 Gigabit - Level', 'ifName' => '0/2', 'ifAlias' => 'Port 2', 'ifType' => 'ethernetCsmacd', 'ifOperStatus' => 'up', ), 3 => array ( 'ifDescr' => 'Slot: 0 Port: 3 Gigabit - Level', 'ifName' => '0/3', 'ifAlias' => 'Port 3', 'ifType' => 'ethernetCsmacd', 'ifOperStatus' => 'up', ), 4 => array ( 'ifDescr' => 'Slot: 0 Port: 4 Gigabit - Level', 'ifName' => '0/4', 'ifAlias' => 'Port 4', 'ifType' => 'ethernetCsmacd', 'ifOperStatus' => 'up', ), 5 => array ( 'ifDescr' => 'Slot: 0 Port: 5 Gigabit - Level', 'ifName' => '0/5', 'ifAlias' => 'Port 5', 'ifType' => 'ethernetCsmacd', 'ifOperStatus' => 'up', ), 6 => array ( 'ifDescr' => 'Slot: 0 Port: 6 Gigabit - Level', 'ifName' => '0/6', 'ifAlias' => 'Port 6', 'ifType' => 'ethernetCsmacd', 'ifOperStatus' => 'up', ), 7 => array ( 'ifDescr' => 'Slot: 0 Port: 7 Gigabit - Level', 'ifName' => '0/7', 'ifAlias' => 'Port 7', 'ifType' => 'ethernetCsmacd', 'ifOperStatus' => 'up', ), 8 => array ( 'ifDescr' => 'Slot: 0 Port: 8 Gigabit - Level', 'ifName' => '0/8', 'ifAlias' => 'Port 8', 'ifType' => 'ethernetCsmacd', 'ifOperStatus' => 'down', ), 9 => array ( 'ifDescr' => 'Slot: 0 Port: 9 Gigabit - Level', 'ifName' => '0/9', 'ifAlias' => 'Port 9', 'ifType' => 'ethernetCsmacd', 'ifOperStatus' => 'down', ), 10 => array ( 'ifDescr' => 'Slot: 0 Port: 10 Gigabit - Level', 'ifName' => '0/10', 'ifAlias' => 'Port 10', 'ifType' => 'ethernetCsmacd', 'ifOperStatus' => 'down', ), 11 => array ( 'ifDescr' => 'Slot: 0 Port: 11 Gigabit - Level', 'ifName' => '0/11', 'ifAlias' => 'Port 11', 'ifType' => 'ethernetCsmacd', 'ifOperStatus' => 'down', ), 12 => array ( 'ifDescr' => 'Slot: 0 Port: 12 Gigabit - Level', 'ifName' => '0/12', 'ifAlias' => 'Port 12', 'ifType' => 'ethernetCsmacd', 'ifOperStatus' => 'down', ), 13 => array ( 'ifDescr' => 'Slot: 0 Port: 13 Gigabit - Level', 'ifName' => '0/13', 'ifAlias' => 'Port 13', 'ifType' => 'ethernetCsmacd', 'ifOperStatus' => 'down', ), 14 => array ( 'ifDescr' => 'Slot: 0 Port: 14 Gigabit - Level', 'ifName' => '0/14', 'ifAlias' => 'Port 14', 'ifType' => 'ethernetCsmacd', 'ifOperStatus' => 'down', ), 15 => array ( 'ifDescr' => 'Slot: 0 Port: 15 Gigabit - Level', 'ifName' => '0/15', 'ifAlias' => 'Port 15', 'ifType' => 'ethernetCsmacd', 'ifOperStatus' => 'down', ), 16 => array ( 'ifDescr' => 'Slot: 0 Port: 16 Gigabit - Level', 'ifName' => '0/16', 'ifAlias' => 'Port 16', 'ifType' => 'ethernetCsmacd', 'ifOperStatus' => 'down', ), 17 => array ( 'ifDescr' => 'Slot: 0 Port: 17 Gigabit - Level', 'ifName' => '0/17', 'ifAlias' => 'Port 17', 'ifType' => 'ethernetCsmacd', 'ifOperStatus' => 'down', ), 18 => array ( 'ifDescr' => 'Slot: 0 Port: 18 Gigabit - Level', 'ifName' => '0/18', 'ifAlias' => 'Port 18', 'ifType' => 'ethernetCsmacd', 'ifOperStatus' => 'down', ), 19 => array ( 'ifDescr' => 'Slot: 0 Port: 19 Gigabit - Level', 'ifName' => '0/19', 'ifAlias' => 'Port 19', 'ifType' => 'ethernetCsmacd', 'ifOperStatus' => 'down', ), 20 => array ( 'ifDescr' => 'Slot: 0 Port: 20 Gigabit - Level', 'ifName' => '0/20', 'ifAlias' => 'Port 20', 'ifType' => 'ethernetCsmacd', 'ifOperStatus' => 'down', ), 21 => array ( 'ifDescr' => 'Slot: 0 Port: 21 Gigabit - Level', 'ifName' => '0/21', 'ifAlias' => 'Port 21', 'ifType' => 'ethernetCsmacd', 'ifOperStatus' => 'down', ), 22 => array ( 'ifDescr' => 'Slot: 0 Port: 22 Gigabit - Level', 'ifName' => '0/22', 'ifAlias' => 'Port 22', 'ifType' => 'ethernetCsmacd', 'ifOperStatus' => 'down', ), 23 => array ( 'ifDescr' => 'Slot: 0 Port: 23 Gigabit - Level', 'ifName' => '0/23', 'ifAlias' => 'KTown CO mFi', 'ifType' => 'ethernetCsmacd', 'ifOperStatus' => 'up', ), 24 => array ( 'ifDescr' => 'Slot: 0 Port: 24 Gigabit - Level', 'ifName' => '0/24', 'ifAlias' => 'KTown CO AP', 'ifType' => 'ethernetCsmacd', 'ifOperStatus' => 'up', ), 25 => array ( 'ifDescr' => 'Slot: 0 Port: 25 Gigabit - Level', 'ifName' => '0/25', 'ifAlias' => 'SFP 1', 'ifType' => 'ethernetCsmacd', 'ifOperStatus' => 'down', ), 26 => array ( 'ifDescr' => 'Slot: 0 Port: 26 Gigabit - Level', 'ifName' => '0/26', 'ifAlias' => 'SFP 2', 'ifType' => 'ethernetCsmacd', 'ifOperStatus' => 'down', ), 65 => array ( 'ifDescr' => 'CPU Interface for Slot: 5 Port: 1', 'ifName' => 'CPU Interface: 5/1', 'ifAlias' => '', 'ifType' => 'other', 'ifOperStatus' => 'up', ), 66 => array ( 'ifDescr' => 'Link Aggregate 1', 'ifName' => '3/1', 'ifAlias' => '', 'ifType' => 'other', 'ifOperStatus' => 'down', ), 67 => array ( 'ifDescr' => 'Link Aggregate 2', 'ifName' => '3/2', 'ifAlias' => '', 'ifType' => 'other', 'ifOperStatus' => 'down', ), 68 => array ( 'ifDescr' => 'Link Aggregate 3', 'ifName' => '3/3', 'ifAlias' => '', 'ifType' => 'other', 'ifOperStatus' => 'down', ), 69 => array ( 'ifDescr' => 'Link Aggregate 4', 'ifName' => '3/4', 'ifAlias' => '', 'ifType' => 'other', 'ifOperStatus' => 'down', ), 70 => array ( 'ifDescr' => 'Link Aggregate 5', 'ifName' => '3/5', 'ifAlias' => '', 'ifType' => 'other', 'ifOperStatus' => 'down', ), 71 => array ( 'ifDescr' => 'Link Aggregate 6', 'ifName' => '3/6', 'ifAlias' => '', 'ifType' => 'other', 'ifOperStatus' => 'down', ), 72 => array ( 'ifDescr' => 'Link Aggregate 7', 'ifName' => '3/7', 'ifAlias' => '', 'ifType' => 'other', 'ifOperStatus' => 'down', ), 73 => array ( 'ifDescr' => 'Link Aggregate 8', 'ifName' => '3/8', 'ifAlias' => '', 'ifType' => 'other', 'ifOperStatus' => 'down', ), 74 => array ( 'ifDescr' => 'Link Aggregate 9', 'ifName' => '3/9', 'ifAlias' => '', 'ifType' => 'other', 'ifOperStatus' => 'down', ), 75 => array ( 'ifDescr' => 'Link Aggregate 10', 'ifName' => '3/10', 'ifAlias' => '', 'ifType' => 'other', 'ifOperStatus' => 'down', ), 76 => array ( 'ifDescr' => 'Link Aggregate 11', 'ifName' => '3/11', 'ifAlias' => '', 'ifType' => 'other', 'ifOperStatus' => 'down', ), 77 => array ( 'ifDescr' => 'Link Aggregate 12', 'ifName' => '3/12', 'ifAlias' => '', 'ifType' => 'other', 'ifOperStatus' => 'down', ), 78 => array ( 'ifDescr' => 'Link Aggregate 13', 'ifName' => '3/13', 'ifAlias' => '', 'ifType' => 'other', 'ifOperStatus' => 'down', ), 79 => array ( 'ifDescr' => 'Link Aggregate 14', 'ifName' => '3/14', 'ifAlias' => '', 'ifType' => 'other', 'ifOperStatus' => 'down', ), 80 => array ( 'ifDescr' => 'Link Aggregate 15', 'ifName' => '3/15', 'ifAlias' => '', 'ifType' => 'other', 'ifOperStatus' => 'down', ), 81 => array ( 'ifDescr' => 'Link Aggregate 16', 'ifName' => '3/16', 'ifAlias' => '', 'ifType' => 'other', 'ifOperStatus' => 'down', ), ) SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? ORDER BY port_id [0;33m[312][0m 2.43ms] ignored by ifDescr: Slot: 0 Port: 1 Gigabit - Level (matched: lo) Xignored by ifDescr: Slot: 0 Port: 2 Gigabit - Level (matched: lo) Xignored by ifDescr: Slot: 0 Port: 3 Gigabit - Level (matched: lo) Xignored by ifDescr: Slot: 0 Port: 4 Gigabit - Level (matched: lo) Xignored by ifDescr: Slot: 0 Port: 5 Gigabit - Level (matched: lo) Xignored by ifDescr: Slot: 0 Port: 6 Gigabit - Level (matched: lo) Xignored by ifDescr: Slot: 0 Port: 7 Gigabit - Level (matched: lo) Xignored by ifDescr: Slot: 0 Port: 8 Gigabit - Level (matched: lo) Xignored by ifDescr: Slot: 0 Port: 9 Gigabit - Level (matched: lo) Xignored by ifDescr: Slot: 0 Port: 10 Gigabit - Level (matched: lo) Xignored by ifDescr: Slot: 0 Port: 11 Gigabit - Level (matched: lo) Xignored by ifDescr: Slot: 0 Port: 12 Gigabit - Level (matched: lo) Xignored by ifDescr: Slot: 0 Port: 13 Gigabit - Level (matched: lo) Xignored by ifDescr: Slot: 0 Port: 14 Gigabit - Level (matched: lo) Xignored by ifDescr: Slot: 0 Port: 15 Gigabit - Level (matched: lo) Xignored by ifDescr: Slot: 0 Port: 16 Gigabit - Level (matched: lo) Xignored by ifDescr: Slot: 0 Port: 17 Gigabit - Level (matched: lo) Xignored by ifDescr: Slot: 0 Port: 18 Gigabit - Level (matched: lo) Xignored by ifDescr: Slot: 0 Port: 19 Gigabit - Level (matched: lo) Xignored by ifDescr: Slot: 0 Port: 20 Gigabit - Level (matched: lo) Xignored by ifDescr: Slot: 0 Port: 21 Gigabit - Level (matched: lo) Xignored by ifDescr: Slot: 0 Port: 22 Gigabit - Level (matched: lo) Xignored by ifDescr: Slot: 0 Port: 23 Gigabit - Level (matched: lo) Xignored by ifDescr: Slot: 0 Port: 24 Gigabit - Level (matched: lo) Xignored by ifDescr: Slot: 0 Port: 25 Gigabit - Level (matched: lo) Xignored by ifDescr: Slot: 0 Port: 26 Gigabit - Level (matched: lo) Xignored by ifDescr: CPU Interface for Slot: 5 Port: 1 (matched: lo) Xignored by ifDescr: Link Aggregate 1 (matched: gre) Xignored by ifDescr: Link Aggregate 2 (matched: gre) Xignored by ifDescr: Link Aggregate 3 (matched: gre) Xignored by ifDescr: Link Aggregate 4 (matched: gre) Xignored by ifDescr: Link Aggregate 5 (matched: gre) Xignored by ifDescr: Link Aggregate 6 (matched: gre) Xignored by ifDescr: Link Aggregate 7 (matched: gre) Xignored by ifDescr: Link Aggregate 8 (matched: gre) Xignored by ifDescr: Link Aggregate 9 (matched: gre) Xignored by ifDescr: Link Aggregate 10 (matched: gre) Xignored by ifDescr: Link Aggregate 11 (matched: gre) Xignored by ifDescr: Link Aggregate 12 (matched: gre) Xignored by ifDescr: Link Aggregate 13 (matched: gre) Xignored by ifDescr: Link Aggregate 14 (matched: gre) Xignored by ifDescr: Link Aggregate 15 (matched: gre) Xignored by ifDescr: Link Aggregate 16 (matched: gre) X >> Runtime for discovery module 'ports': 0.2760 seconds with 10232 bytes >> [0;36mSNMP[0m: [5/0.26s] [1;33mMySQL[0m: [1/0.02s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module ports #### Modules status: Global- OS Device Module [ ports-stack ] disabled globally. Modules status: Global- OS Device Module [ xdsl ] disabled globally. Modules status: Global+ OS Device #### Load disco module entity-physical #### Caching OIDs: entPhysicalEntrySNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'entPhysicalEntry'[0m] entPhysicalDescr.1 = UBNT EdgeSwitch 24-Port entPhysicalDescr.2 = UBNT ES24 - 24 GE POE + 2 GE Ethernet Line Card entPhysicalDescr.3 = Slot: 0 Port: 1 Gigabit - Level entPhysicalDescr.4 = Slot: 0 Port: 2 Gigabit - Level entPhysicalDescr.5 = Slot: 0 Port: 3 Gigabit - Level entPhysicalDescr.6 = Slot: 0 Port: 4 Gigabit - Level entPhysicalDescr.7 = Slot: 0 Port: 5 Gigabit - Level entPhysicalDescr.8 = Slot: 0 Port: 6 Gigabit - Level entPhysicalDescr.9 = Slot: 0 Port: 7 Gigabit - Level entPhysicalDescr.10 = Slot: 0 Port: 8 Gigabit - Level entPhysicalDescr.11 = Slot: 0 Port: 9 Gigabit - Level entPhysicalDescr.12 = Slot: 0 Port: 10 Gigabit - Level entPhysicalDescr.13 = Slot: 0 Port: 11 Gigabit - Level entPhysicalDescr.14 = Slot: 0 Port: 12 Gigabit - Level entPhysicalDescr.15 = Slot: 0 Port: 13 Gigabit - Level entPhysicalDescr.16 = Slot: 0 Port: 14 Gigabit - Level entPhysicalDescr.17 = Slot: 0 Port: 15 Gigabit - Level entPhysicalDescr.18 = Slot: 0 Port: 16 Gigabit - Level entPhysicalDescr.19 = Slot: 0 Port: 17 Gigabit - Level entPhysicalDescr.20 = Slot: 0 Port: 18 Gigabit - Level entPhysicalDescr.21 = Slot: 0 Port: 19 Gigabit - Level entPhysicalDescr.22 = Slot: 0 Port: 20 Gigabit - Level entPhysicalDescr.23 = Slot: 0 Port: 21 Gigabit - Level entPhysicalDescr.24 = Slot: 0 Port: 22 Gigabit - Level entPhysicalDescr.25 = Slot: 0 Port: 23 Gigabit - Level entPhysicalDescr.26 = Slot: 0 Port: 24 Gigabit - Level entPhysicalDescr.27 = Slot: 0 Port: 25 Gigabit - Level entPhysicalDescr.28 = Slot: 0 Port: 26 Gigabit - Level entPhysicalVendorType.1 = zeroDotZero entPhysicalVendorType.2 = zeroDotZero entPhysicalVendorType.3 = zeroDotZero entPhysicalVendorType.4 = zeroDotZero entPhysicalVendorType.5 = zeroDotZero entPhysicalVendorType.6 = zeroDotZero entPhysicalVendorType.7 = zeroDotZero entPhysicalVendorType.8 = zeroDotZero entPhysicalVendorType.9 = zeroDotZero entPhysicalVendorType.10 = zeroDotZero entPhysicalVendorType.11 = zeroDotZero entPhysicalVendorType.12 = zeroDotZero entPhysicalVendorType.13 = zeroDotZero entPhysicalVendorType.14 = zeroDotZero entPhysicalVendorType.15 = zeroDotZero entPhysicalVendorType.16 = zeroDotZero entPhysicalVendorType.17 = zeroDotZero entPhysicalVendorType.18 = zeroDotZero entPhysicalVendorType.19 = zeroDotZero entPhysicalVendorType.20 = zeroDotZero entPhysicalVendorType.21 = zeroDotZero entPhysicalVendorType.22 = zeroDotZero entPhysicalVendorType.23 = zeroDotZero entPhysicalVendorType.24 = zeroDotZero entPhysicalVendorType.25 = zeroDotZero entPhysicalVendorType.26 = zeroDotZero entPhysicalVendorType.27 = zeroDotZero entPhysicalVendorType.28 = zeroDotZero entPhysicalContainedIn.1 = 0 entPhysicalContainedIn.2 = 1 entPhysicalContainedIn.3 = 2 entPhysicalContainedIn.4 = 2 entPhysicalContainedIn.5 = 2 entPhysicalContainedIn.6 = 2 entPhysicalContainedIn.7 = 2 entPhysicalContainedIn.8 = 2 entPhysicalContainedIn.9 = 2 entPhysicalContainedIn.10 = 2 entPhysicalContainedIn.11 = 2 entPhysicalContainedIn.12 = 2 entPhysicalContainedIn.13 = 2 entPhysicalContainedIn.14 = 2 entPhysicalContainedIn.15 = 2 entPhysicalContainedIn.16 = 2 entPhysicalContainedIn.17 = 2 entPhysicalContainedIn.18 = 2 entPhysicalContainedIn.19 = 2 entPhysicalContainedIn.20 = 2 entPhysicalContainedIn.21 = 2 entPhysicalContainedIn.22 = 2 entPhysicalContainedIn.23 = 2 entPhysicalContainedIn.24 = 2 entPhysicalContainedIn.25 = 2 entPhysicalContainedIn.26 = 2 entPhysicalContainedIn.27 = 2 entPhysicalContainedIn.28 = 2 entPhysicalClass.1 = chassis entPhysicalClass.2 = module entPhysicalClass.3 = port entPhysicalClass.4 = port entPhysicalClass.5 = port entPhysicalClass.6 = port entPhysicalClass.7 = port entPhysicalClass.8 = port entPhysicalClass.9 = port entPhysicalClass.10 = port entPhysicalClass.11 = port entPhysicalClass.12 = port entPhysicalClass.13 = port entPhysicalClass.14 = port entPhysicalClass.15 = port entPhysicalClass.16 = port entPhysicalClass.17 = port entPhysicalClass.18 = port entPhysicalClass.19 = port entPhysicalClass.20 = port entPhysicalClass.21 = port entPhysicalClass.22 = port entPhysicalClass.23 = port entPhysicalClass.24 = port entPhysicalClass.25 = port entPhysicalClass.26 = port entPhysicalClass.27 = port entPhysicalClass.28 = port entPhysicalParentRelPos.1 = 1 entPhysicalParentRelPos.2 = 0 entPhysicalParentRelPos.3 = 1 entPhysicalParentRelPos.4 = 2 entPhysicalParentRelPos.5 = 3 entPhysicalParentRelPos.6 = 4 entPhysicalParentRelPos.7 = 5 entPhysicalParentRelPos.8 = 6 entPhysicalParentRelPos.9 = 7 entPhysicalParentRelPos.10 = 8 entPhysicalParentRelPos.11 = 9 entPhysicalParentRelPos.12 = 10 entPhysicalParentRelPos.13 = 11 entPhysicalParentRelPos.14 = 12 entPhysicalParentRelPos.15 = 13 entPhysicalParentRelPos.16 = 14 entPhysicalParentRelPos.17 = 15 entPhysicalParentRelPos.18 = 16 entPhysicalParentRelPos.19 = 17 entPhysicalParentRelPos.20 = 18 entPhysicalParentRelPos.21 = 19 entPhysicalParentRelPos.22 = 20 entPhysicalParentRelPos.23 = 21 entPhysicalParentRelPos.24 = 22 entPhysicalParentRelPos.25 = 23 entPhysicalParentRelPos.26 = 24 entPhysicalParentRelPos.27 = 25 entPhysicalParentRelPos.28 = 26 entPhysicalName.1 = Unit 1 entPhysicalName.2 = Slot 1.0 entPhysicalName.3 = 0/1 entPhysicalName.4 = 0/2 entPhysicalName.5 = 0/3 entPhysicalName.6 = 0/4 entPhysicalName.7 = 0/5 entPhysicalName.8 = 0/6 entPhysicalName.9 = 0/7 entPhysicalName.10 = 0/8 entPhysicalName.11 = 0/9 entPhysicalName.12 = 0/10 entPhysicalName.13 = 0/11 entPhysicalName.14 = 0/12 entPhysicalName.15 = 0/13 entPhysicalName.16 = 0/14 entPhysicalName.17 = 0/15 entPhysicalName.18 = 0/16 entPhysicalName.19 = 0/17 entPhysicalName.20 = 0/18 entPhysicalName.21 = 0/19 entPhysicalName.22 = 0/20 entPhysicalName.23 = 0/21 entPhysicalName.24 = 0/22 entPhysicalName.25 = 0/23 entPhysicalName.26 = 0/24 entPhysicalName.27 = 0/25 entPhysicalName.28 = 0/26 entPhysicalHardwareRev.1 = entPhysicalHardwareRev.2 = entPhysicalHardwareRev.3 = entPhysicalHardwareRev.4 = entPhysicalHardwareRev.5 = entPhysicalHardwareRev.6 = entPhysicalHardwareRev.7 = entPhysicalHardwareRev.8 = entPhysicalHardwareRev.9 = entPhysicalHardwareRev.10 = entPhysicalHardwareRev.11 = entPhysicalHardwareRev.12 = entPhysicalHardwareRev.13 = entPhysicalHardwareRev.14 = entPhysicalHardwareRev.15 = entPhysicalHardwareRev.16 = entPhysicalHardwareRev.17 = entPhysicalHardwareRev.18 = entPhysicalHardwareRev.19 = entPhysicalHardwareRev.20 = entPhysicalHardwareRev.21 = entPhysicalHardwareRev.22 = entPhysicalHardwareRev.23 = entPhysicalHardwareRev.24 = entPhysicalHardwareRev.25 = entPhysicalHardwareRev.26 = entPhysicalHardwareRev.27 = entPhysicalHardwareRev.28 = entPhysicalFirmwareRev.1 = entPhysicalFirmwareRev.2 = entPhysicalFirmwareRev.3 = entPhysicalFirmwareRev.4 = entPhysicalFirmwareRev.5 = entPhysicalFirmwareRev.6 = entPhysicalFirmwareRev.7 = entPhysicalFirmwareRev.8 = entPhysicalFirmwareRev.9 = entPhysicalFirmwareRev.10 = entPhysicalFirmwareRev.11 = entPhysicalFirmwareRev.12 = entPhysicalFirmwareRev.13 = entPhysicalFirmwareRev.14 = entPhysicalFirmwareRev.15 = entPhysicalFirmwareRev.16 = entPhysicalFirmwareRev.17 = entPhysicalFirmwareRev.18 = entPhysicalFirmwareRev.19 = entPhysicalFirmwareRev.20 = entPhysicalFirmwareRev.21 = entPhysicalFirmwareRev.22 = entPhysicalFirmwareRev.23 = entPhysicalFirmwareRev.24 = entPhysicalFirmwareRev.25 = entPhysicalFirmwareRev.26 = entPhysicalFirmwareRev.27 = entPhysicalFirmwareRev.28 = entPhysicalSoftwareRev.1 = *04 entPhysicalSoftwareRev.2 = entPhysicalSoftwareRev.3 = entPhysicalSoftwareRev.4 = entPhysicalSoftwareRev.5 = entPhysicalSoftwareRev.6 = entPhysicalSoftwareRev.7 = entPhysicalSoftwareRev.8 = entPhysicalSoftwareRev.9 = entPhysicalSoftwareRev.10 = entPhysicalSoftwareRev.11 = entPhysicalSoftwareRev.12 = entPhysicalSoftwareRev.13 = entPhysicalSoftwareRev.14 = entPhysicalSoftwareRev.15 = entPhysicalSoftwareRev.16 = entPhysicalSoftwareRev.17 = entPhysicalSoftwareRev.18 = entPhysicalSoftwareRev.19 = entPhysicalSoftwareRev.20 = entPhysicalSoftwareRev.21 = entPhysicalSoftwareRev.22 = entPhysicalSoftwareRev.23 = entPhysicalSoftwareRev.24 = entPhysicalSoftwareRev.25 = entPhysicalSoftwareRev.26 = entPhysicalSoftwareRev.27 = entPhysicalSoftwareRev.28 = entPhysicalSerialNum.1 = 7483c24a433b entPhysicalSerialNum.2 = entPhysicalSerialNum.3 = entPhysicalSerialNum.4 = entPhysicalSerialNum.5 = entPhysicalSerialNum.6 = entPhysicalSerialNum.7 = entPhysicalSerialNum.8 = entPhysicalSerialNum.9 = entPhysicalSerialNum.10 = entPhysicalSerialNum.11 = entPhysicalSerialNum.12 = entPhysicalSerialNum.13 = entPhysicalSerialNum.14 = entPhysicalSerialNum.15 = entPhysicalSerialNum.16 = entPhysicalSerialNum.17 = entPhysicalSerialNum.18 = entPhysicalSerialNum.19 = entPhysicalSerialNum.20 = entPhysicalSerialNum.21 = entPhysicalSerialNum.22 = entPhysicalSerialNum.23 = entPhysicalSerialNum.24 = entPhysicalSerialNum.25 = entPhysicalSerialNum.26 = entPhysicalSerialNum.27 = entPhysicalSerialNum.28 = entPhysicalMfgName.1 = entPhysicalMfgName.2 = entPhysicalMfgName.3 = entPhysicalMfgName.4 = entPhysicalMfgName.5 = entPhysicalMfgName.6 = entPhysicalMfgName.7 = entPhysicalMfgName.8 = entPhysicalMfgName.9 = entPhysicalMfgName.10 = entPhysicalMfgName.11 = entPhysicalMfgName.12 = entPhysicalMfgName.13 = entPhysicalMfgName.14 = entPhysicalMfgName.15 = entPhysicalMfgName.16 = entPhysicalMfgName.17 = entPhysicalMfgName.18 = entPhysicalMfgName.19 = entPhysicalMfgName.20 = entPhysicalMfgName.21 = entPhysicalMfgName.22 = entPhysicalMfgName.23 = entPhysicalMfgName.24 = entPhysicalMfgName.25 = entPhysicalMfgName.26 = entPhysicalMfgName.27 = entPhysicalMfgName.28 = entPhysicalModelName.1 = UBNT-ES24 entPhysicalModelName.2 = UBNT-ES24-24GE-POE-2GIG entPhysicalModelName.3 = entPhysicalModelName.4 = entPhysicalModelName.5 = entPhysicalModelName.6 = entPhysicalModelName.7 = entPhysicalModelName.8 = entPhysicalModelName.9 = entPhysicalModelName.10 = entPhysicalModelName.11 = entPhysicalModelName.12 = entPhysicalModelName.13 = entPhysicalModelName.14 = entPhysicalModelName.15 = entPhysicalModelName.16 = entPhysicalModelName.17 = entPhysicalModelName.18 = entPhysicalModelName.19 = entPhysicalModelName.20 = entPhysicalModelName.21 = entPhysicalModelName.22 = entPhysicalModelName.23 = entPhysicalModelName.24 = entPhysicalModelName.25 = entPhysicalModelName.26 = entPhysicalModelName.27 = entPhysicalModelName.28 = entPhysicalAlias.1 = entPhysicalAlias.2 = entPhysicalAlias.3 = entPhysicalAlias.4 = entPhysicalAlias.5 = entPhysicalAlias.6 = entPhysicalAlias.7 = entPhysicalAlias.8 = entPhysicalAlias.9 = entPhysicalAlias.10 = entPhysicalAlias.11 = entPhysicalAlias.12 = entPhysicalAlias.13 = entPhysicalAlias.14 = entPhysicalAlias.15 = entPhysicalAlias.16 = entPhysicalAlias.17 = entPhysicalAlias.18 = entPhysicalAlias.19 = entPhysicalAlias.20 = entPhysicalAlias.21 = entPhysicalAlias.22 = entPhysicalAlias.23 = entPhysicalAlias.24 = entPhysicalAlias.25 = entPhysicalAlias.26 = entPhysicalAlias.27 = entPhysicalAlias.28 = entPhysicalAssetID.1 = entPhysicalAssetID.2 = entPhysicalAssetID.3 = entPhysicalAssetID.4 = entPhysicalAssetID.5 = entPhysicalAssetID.6 = entPhysicalAssetID.7 = entPhysicalAssetID.8 = entPhysicalAssetID.9 = entPhysicalAssetID.10 = entPhysicalAssetID.11 = entPhysicalAssetID.12 = entPhysicalAssetID.13 = entPhysicalAssetID.14 = entPhysicalAssetID.15 = entPhysicalAssetID.16 = entPhysicalAssetID.17 = entPhysicalAssetID.18 = entPhysicalAssetID.19 = entPhysicalAssetID.20 = entPhysicalAssetID.21 = entPhysicalAssetID.22 = entPhysicalAssetID.23 = entPhysicalAssetID.24 = entPhysicalAssetID.25 = entPhysicalAssetID.26 = entPhysicalAssetID.27 = entPhysicalAssetID.28 = entPhysicalIsFRU.1 = false entPhysicalIsFRU.2 = false entPhysicalIsFRU.3 = false entPhysicalIsFRU.4 = false entPhysicalIsFRU.5 = false entPhysicalIsFRU.6 = false entPhysicalIsFRU.7 = false entPhysicalIsFRU.8 = false entPhysicalIsFRU.9 = false entPhysicalIsFRU.10 = false entPhysicalIsFRU.11 = false entPhysicalIsFRU.12 = false entPhysicalIsFRU.13 = false entPhysicalIsFRU.14 = false entPhysicalIsFRU.15 = false entPhysicalIsFRU.16 = false entPhysicalIsFRU.17 = false entPhysicalIsFRU.18 = false entPhysicalIsFRU.19 = false entPhysicalIsFRU.20 = false entPhysicalIsFRU.21 = false entPhysicalIsFRU.22 = false entPhysicalIsFRU.23 = false entPhysicalIsFRU.24 = false entPhysicalIsFRU.25 = false entPhysicalIsFRU.26 = false entPhysicalIsFRU.27 = false entPhysicalIsFRU.28 = false MIB search path: /opt/librenms/mibs:/opt/librenms/mibs/edgeswitch Cannot find module (CISCO-ENTITY-VENDORTYPE-OID-MIB): At line 1 in (none) entAliasMappingIdentifierSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'ENTITY-MIB:IF-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'entAliasMappingIdentifier'[0m] entAliasMappingIdentifier = No Such Instance currently exists at this OID Discover Inventory Item: 1, UBNT EdgeSwitch 24-Port, chassis, Unit 1, UBNT-ES24, 7483c24a433b, 0, , 1, zeroDotZero, , , 6.3.13.14104, false, , , 0 SQL[[1;33mSELECT COUNT(entPhysical_id) FROM `entPhysical` WHERE `device_id` = ? AND `entPhysicalIndex` = ? [0;33m[312,1][0m 2.26ms] .SQL[[1;33mUPDATE `entPhysical` set `entPhysicalIndex`=?,`entPhysicalDescr`=?,`entPhysicalClass`=?,`entPhysicalName`=?,`entPhysicalModelName`=?,`entPhysicalSerialNum`=?,`entPhysicalContainedIn`=?,`entPhysicalMfgName`=?,`entPhysicalParentRelPos`=?,`entPhysicalVendorType`=?,`entPhysicalHardwareRev`=?,`entPhysicalFirmwareRev`=?,`entPhysicalSoftwareRev`=?,`entPhysicalIsFRU`=?,`entPhysicalAlias`=?,`entPhysicalAssetID`=?,`ifIndex`=? WHERE `device_id`=? AND `entPhysicalIndex`=? [0;33m[1,"UBNT EdgeSwitch 24-Port","chassis","Unit 1","UBNT-ES24","7483c24a433b","0","","1","zeroDotZero","","","6.3.13.14104","false","","",0,312,1][0m 1.58ms] Discover Inventory Item: 2, UBNT ES24 - 24 GE POE + 2 GE Ethernet Line Card, module, Slot 1.0, UBNT-ES24-24GE-POE-2GIG, , 1, , 0, zeroDotZero, , , , false, , , 0 SQL[[1;33mSELECT COUNT(entPhysical_id) FROM `entPhysical` WHERE `device_id` = ? AND `entPhysicalIndex` = ? [0;33m[312,2][0m 1.16ms] .SQL[[1;33mUPDATE `entPhysical` set `entPhysicalIndex`=?,`entPhysicalDescr`=?,`entPhysicalClass`=?,`entPhysicalName`=?,`entPhysicalModelName`=?,`entPhysicalSerialNum`=?,`entPhysicalContainedIn`=?,`entPhysicalMfgName`=?,`entPhysicalParentRelPos`=?,`entPhysicalVendorType`=?,`entPhysicalHardwareRev`=?,`entPhysicalFirmwareRev`=?,`entPhysicalSoftwareRev`=?,`entPhysicalIsFRU`=?,`entPhysicalAlias`=?,`entPhysicalAssetID`=?,`ifIndex`=? WHERE `device_id`=? AND `entPhysicalIndex`=? [0;33m[2,"UBNT ES24 - 24 GE POE + 2 GE Ethernet Line Card","module","Slot 1.0","UBNT-ES24-24GE-POE-2GIG","","1","","0","zeroDotZero","","","","false","","",0,312,2][0m 1.45ms] Discover Inventory Item: 3, Slot: 0 Port: 1 Gigabit - Level, port, 0/1, , , 2, , 1, zeroDotZero, , , , false, , , 0 SQL[[1;33mSELECT COUNT(entPhysical_id) FROM `entPhysical` WHERE `device_id` = ? AND `entPhysicalIndex` = ? [0;33m[312,3][0m 1.14ms] .SQL[[1;33mUPDATE `entPhysical` set `entPhysicalIndex`=?,`entPhysicalDescr`=?,`entPhysicalClass`=?,`entPhysicalName`=?,`entPhysicalModelName`=?,`entPhysicalSerialNum`=?,`entPhysicalContainedIn`=?,`entPhysicalMfgName`=?,`entPhysicalParentRelPos`=?,`entPhysicalVendorType`=?,`entPhysicalHardwareRev`=?,`entPhysicalFirmwareRev`=?,`entPhysicalSoftwareRev`=?,`entPhysicalIsFRU`=?,`entPhysicalAlias`=?,`entPhysicalAssetID`=?,`ifIndex`=? WHERE `device_id`=? AND `entPhysicalIndex`=? [0;33m[3,"Slot: 0 Port: 1 Gigabit - Level","port","0\/1","","","2","","1","zeroDotZero","","","","false","","",0,312,3][0m 1.44ms] Discover Inventory Item: 4, Slot: 0 Port: 2 Gigabit - Level, port, 0/2, , , 2, , 2, zeroDotZero, , , , false, , , 0 SQL[[1;33mSELECT COUNT(entPhysical_id) FROM `entPhysical` WHERE `device_id` = ? AND `entPhysicalIndex` = ? [0;33m[312,4][0m 1.13ms] .SQL[[1;33mUPDATE `entPhysical` set `entPhysicalIndex`=?,`entPhysicalDescr`=?,`entPhysicalClass`=?,`entPhysicalName`=?,`entPhysicalModelName`=?,`entPhysicalSerialNum`=?,`entPhysicalContainedIn`=?,`entPhysicalMfgName`=?,`entPhysicalParentRelPos`=?,`entPhysicalVendorType`=?,`entPhysicalHardwareRev`=?,`entPhysicalFirmwareRev`=?,`entPhysicalSoftwareRev`=?,`entPhysicalIsFRU`=?,`entPhysicalAlias`=?,`entPhysicalAssetID`=?,`ifIndex`=? WHERE `device_id`=? AND `entPhysicalIndex`=? [0;33m[4,"Slot: 0 Port: 2 Gigabit - Level","port","0\/2","","","2","","2","zeroDotZero","","","","false","","",0,312,4][0m 1.44ms] Discover Inventory Item: 5, Slot: 0 Port: 3 Gigabit - Level, port, 0/3, , , 2, , 3, zeroDotZero, , , , false, , , 0 SQL[[1;33mSELECT COUNT(entPhysical_id) FROM `entPhysical` WHERE `device_id` = ? AND `entPhysicalIndex` = ? [0;33m[312,5][0m 1.29ms] .SQL[[1;33mUPDATE `entPhysical` set `entPhysicalIndex`=?,`entPhysicalDescr`=?,`entPhysicalClass`=?,`entPhysicalName`=?,`entPhysicalModelName`=?,`entPhysicalSerialNum`=?,`entPhysicalContainedIn`=?,`entPhysicalMfgName`=?,`entPhysicalParentRelPos`=?,`entPhysicalVendorType`=?,`entPhysicalHardwareRev`=?,`entPhysicalFirmwareRev`=?,`entPhysicalSoftwareRev`=?,`entPhysicalIsFRU`=?,`entPhysicalAlias`=?,`entPhysicalAssetID`=?,`ifIndex`=? WHERE `device_id`=? AND `entPhysicalIndex`=? [0;33m[5,"Slot: 0 Port: 3 Gigabit - Level","port","0\/3","","","2","","3","zeroDotZero","","","","false","","",0,312,5][0m 1.81ms] Discover Inventory Item: 6, Slot: 0 Port: 4 Gigabit - Level, port, 0/4, , , 2, , 4, zeroDotZero, , , , false, , , 0 SQL[[1;33mSELECT COUNT(entPhysical_id) FROM `entPhysical` WHERE `device_id` = ? AND `entPhysicalIndex` = ? [0;33m[312,6][0m 1.2ms] .SQL[[1;33mUPDATE `entPhysical` set `entPhysicalIndex`=?,`entPhysicalDescr`=?,`entPhysicalClass`=?,`entPhysicalName`=?,`entPhysicalModelName`=?,`entPhysicalSerialNum`=?,`entPhysicalContainedIn`=?,`entPhysicalMfgName`=?,`entPhysicalParentRelPos`=?,`entPhysicalVendorType`=?,`entPhysicalHardwareRev`=?,`entPhysicalFirmwareRev`=?,`entPhysicalSoftwareRev`=?,`entPhysicalIsFRU`=?,`entPhysicalAlias`=?,`entPhysicalAssetID`=?,`ifIndex`=? WHERE `device_id`=? AND `entPhysicalIndex`=? [0;33m[6,"Slot: 0 Port: 4 Gigabit - Level","port","0\/4","","","2","","4","zeroDotZero","","","","false","","",0,312,6][0m 1.42ms] Discover Inventory Item: 7, Slot: 0 Port: 5 Gigabit - Level, port, 0/5, , , 2, , 5, zeroDotZero, , , , false, , , 0 SQL[[1;33mSELECT COUNT(entPhysical_id) FROM `entPhysical` WHERE `device_id` = ? AND `entPhysicalIndex` = ? [0;33m[312,7][0m 1.07ms] .SQL[[1;33mUPDATE `entPhysical` set `entPhysicalIndex`=?,`entPhysicalDescr`=?,`entPhysicalClass`=?,`entPhysicalName`=?,`entPhysicalModelName`=?,`entPhysicalSerialNum`=?,`entPhysicalContainedIn`=?,`entPhysicalMfgName`=?,`entPhysicalParentRelPos`=?,`entPhysicalVendorType`=?,`entPhysicalHardwareRev`=?,`entPhysicalFirmwareRev`=?,`entPhysicalSoftwareRev`=?,`entPhysicalIsFRU`=?,`entPhysicalAlias`=?,`entPhysicalAssetID`=?,`ifIndex`=? WHERE `device_id`=? AND `entPhysicalIndex`=? [0;33m[7,"Slot: 0 Port: 5 Gigabit - Level","port","0\/5","","","2","","5","zeroDotZero","","","","false","","",0,312,7][0m 1.43ms] Discover Inventory Item: 8, Slot: 0 Port: 6 Gigabit - Level, port, 0/6, , , 2, , 6, zeroDotZero, , , , false, , , 0 SQL[[1;33mSELECT COUNT(entPhysical_id) FROM `entPhysical` WHERE `device_id` = ? AND `entPhysicalIndex` = ? [0;33m[312,8][0m 1.06ms] .SQL[[1;33mUPDATE `entPhysical` set `entPhysicalIndex`=?,`entPhysicalDescr`=?,`entPhysicalClass`=?,`entPhysicalName`=?,`entPhysicalModelName`=?,`entPhysicalSerialNum`=?,`entPhysicalContainedIn`=?,`entPhysicalMfgName`=?,`entPhysicalParentRelPos`=?,`entPhysicalVendorType`=?,`entPhysicalHardwareRev`=?,`entPhysicalFirmwareRev`=?,`entPhysicalSoftwareRev`=?,`entPhysicalIsFRU`=?,`entPhysicalAlias`=?,`entPhysicalAssetID`=?,`ifIndex`=? WHERE `device_id`=? AND `entPhysicalIndex`=? [0;33m[8,"Slot: 0 Port: 6 Gigabit - Level","port","0\/6","","","2","","6","zeroDotZero","","","","false","","",0,312,8][0m 1.41ms] Discover Inventory Item: 9, Slot: 0 Port: 7 Gigabit - Level, port, 0/7, , , 2, , 7, zeroDotZero, , , , false, , , 0 SQL[[1;33mSELECT COUNT(entPhysical_id) FROM `entPhysical` WHERE `device_id` = ? AND `entPhysicalIndex` = ? [0;33m[312,9][0m 1.06ms] .SQL[[1;33mUPDATE `entPhysical` set `entPhysicalIndex`=?,`entPhysicalDescr`=?,`entPhysicalClass`=?,`entPhysicalName`=?,`entPhysicalModelName`=?,`entPhysicalSerialNum`=?,`entPhysicalContainedIn`=?,`entPhysicalMfgName`=?,`entPhysicalParentRelPos`=?,`entPhysicalVendorType`=?,`entPhysicalHardwareRev`=?,`entPhysicalFirmwareRev`=?,`entPhysicalSoftwareRev`=?,`entPhysicalIsFRU`=?,`entPhysicalAlias`=?,`entPhysicalAssetID`=?,`ifIndex`=? WHERE `device_id`=? AND `entPhysicalIndex`=? [0;33m[9,"Slot: 0 Port: 7 Gigabit - Level","port","0\/7","","","2","","7","zeroDotZero","","","","false","","",0,312,9][0m 1.39ms] Discover Inventory Item: 10, Slot: 0 Port: 8 Gigabit - Level, port, 0/8, , , 2, , 8, zeroDotZero, , , , false, , , 0 SQL[[1;33mSELECT COUNT(entPhysical_id) FROM `entPhysical` WHERE `device_id` = ? AND `entPhysicalIndex` = ? [0;33m[312,10][0m 1.08ms] .SQL[[1;33mUPDATE `entPhysical` set `entPhysicalIndex`=?,`entPhysicalDescr`=?,`entPhysicalClass`=?,`entPhysicalName`=?,`entPhysicalModelName`=?,`entPhysicalSerialNum`=?,`entPhysicalContainedIn`=?,`entPhysicalMfgName`=?,`entPhysicalParentRelPos`=?,`entPhysicalVendorType`=?,`entPhysicalHardwareRev`=?,`entPhysicalFirmwareRev`=?,`entPhysicalSoftwareRev`=?,`entPhysicalIsFRU`=?,`entPhysicalAlias`=?,`entPhysicalAssetID`=?,`ifIndex`=? WHERE `device_id`=? AND `entPhysicalIndex`=? [0;33m[10,"Slot: 0 Port: 8 Gigabit - Level","port","0\/8","","","2","","8","zeroDotZero","","","","false","","",0,312,10][0m 1.41ms] Discover Inventory Item: 11, Slot: 0 Port: 9 Gigabit - Level, port, 0/9, , , 2, , 9, zeroDotZero, , , , false, , , 0 SQL[[1;33mSELECT COUNT(entPhysical_id) FROM `entPhysical` WHERE `device_id` = ? AND `entPhysicalIndex` = ? [0;33m[312,11][0m 1.07ms] .SQL[[1;33mUPDATE `entPhysical` set `entPhysicalIndex`=?,`entPhysicalDescr`=?,`entPhysicalClass`=?,`entPhysicalName`=?,`entPhysicalModelName`=?,`entPhysicalSerialNum`=?,`entPhysicalContainedIn`=?,`entPhysicalMfgName`=?,`entPhysicalParentRelPos`=?,`entPhysicalVendorType`=?,`entPhysicalHardwareRev`=?,`entPhysicalFirmwareRev`=?,`entPhysicalSoftwareRev`=?,`entPhysicalIsFRU`=?,`entPhysicalAlias`=?,`entPhysicalAssetID`=?,`ifIndex`=? WHERE `device_id`=? AND `entPhysicalIndex`=? [0;33m[11,"Slot: 0 Port: 9 Gigabit - Level","port","0\/9","","","2","","9","zeroDotZero","","","","false","","",0,312,11][0m 1.41ms] Discover Inventory Item: 12, Slot: 0 Port: 10 Gigabit - Level, port, 0/10, , , 2, , 10, zeroDotZero, , , , false, , , 0 SQL[[1;33mSELECT COUNT(entPhysical_id) FROM `entPhysical` WHERE `device_id` = ? AND `entPhysicalIndex` = ? [0;33m[312,12][0m 1.19ms] .SQL[[1;33mUPDATE `entPhysical` set `entPhysicalIndex`=?,`entPhysicalDescr`=?,`entPhysicalClass`=?,`entPhysicalName`=?,`entPhysicalModelName`=?,`entPhysicalSerialNum`=?,`entPhysicalContainedIn`=?,`entPhysicalMfgName`=?,`entPhysicalParentRelPos`=?,`entPhysicalVendorType`=?,`entPhysicalHardwareRev`=?,`entPhysicalFirmwareRev`=?,`entPhysicalSoftwareRev`=?,`entPhysicalIsFRU`=?,`entPhysicalAlias`=?,`entPhysicalAssetID`=?,`ifIndex`=? WHERE `device_id`=? AND `entPhysicalIndex`=? [0;33m[12,"Slot: 0 Port: 10 Gigabit - Level","port","0\/10","","","2","","10","zeroDotZero","","","","false","","",0,312,12][0m 1.72ms] Discover Inventory Item: 13, Slot: 0 Port: 11 Gigabit - Level, port, 0/11, , , 2, , 11, zeroDotZero, , , , false, , , 0 SQL[[1;33mSELECT COUNT(entPhysical_id) FROM `entPhysical` WHERE `device_id` = ? AND `entPhysicalIndex` = ? [0;33m[312,13][0m 1.53ms] .SQL[[1;33mUPDATE `entPhysical` set `entPhysicalIndex`=?,`entPhysicalDescr`=?,`entPhysicalClass`=?,`entPhysicalName`=?,`entPhysicalModelName`=?,`entPhysicalSerialNum`=?,`entPhysicalContainedIn`=?,`entPhysicalMfgName`=?,`entPhysicalParentRelPos`=?,`entPhysicalVendorType`=?,`entPhysicalHardwareRev`=?,`entPhysicalFirmwareRev`=?,`entPhysicalSoftwareRev`=?,`entPhysicalIsFRU`=?,`entPhysicalAlias`=?,`entPhysicalAssetID`=?,`ifIndex`=? WHERE `device_id`=? AND `entPhysicalIndex`=? [0;33m[13,"Slot: 0 Port: 11 Gigabit - Level","port","0\/11","","","2","","11","zeroDotZero","","","","false","","",0,312,13][0m 1.49ms] Discover Inventory Item: 14, Slot: 0 Port: 12 Gigabit - Level, port, 0/12, , , 2, , 12, zeroDotZero, , , , false, , , 0 SQL[[1;33mSELECT COUNT(entPhysical_id) FROM `entPhysical` WHERE `device_id` = ? AND `entPhysicalIndex` = ? [0;33m[312,14][0m 1.21ms] .SQL[[1;33mUPDATE `entPhysical` set `entPhysicalIndex`=?,`entPhysicalDescr`=?,`entPhysicalClass`=?,`entPhysicalName`=?,`entPhysicalModelName`=?,`entPhysicalSerialNum`=?,`entPhysicalContainedIn`=?,`entPhysicalMfgName`=?,`entPhysicalParentRelPos`=?,`entPhysicalVendorType`=?,`entPhysicalHardwareRev`=?,`entPhysicalFirmwareRev`=?,`entPhysicalSoftwareRev`=?,`entPhysicalIsFRU`=?,`entPhysicalAlias`=?,`entPhysicalAssetID`=?,`ifIndex`=? WHERE `device_id`=? AND `entPhysicalIndex`=? [0;33m[14,"Slot: 0 Port: 12 Gigabit - Level","port","0\/12","","","2","","12","zeroDotZero","","","","false","","",0,312,14][0m 1.47ms] Discover Inventory Item: 15, Slot: 0 Port: 13 Gigabit - Level, port, 0/13, , , 2, , 13, zeroDotZero, , , , false, , , 0 SQL[[1;33mSELECT COUNT(entPhysical_id) FROM `entPhysical` WHERE `device_id` = ? AND `entPhysicalIndex` = ? [0;33m[312,15][0m 1.11ms] .SQL[[1;33mUPDATE `entPhysical` set `entPhysicalIndex`=?,`entPhysicalDescr`=?,`entPhysicalClass`=?,`entPhysicalName`=?,`entPhysicalModelName`=?,`entPhysicalSerialNum`=?,`entPhysicalContainedIn`=?,`entPhysicalMfgName`=?,`entPhysicalParentRelPos`=?,`entPhysicalVendorType`=?,`entPhysicalHardwareRev`=?,`entPhysicalFirmwareRev`=?,`entPhysicalSoftwareRev`=?,`entPhysicalIsFRU`=?,`entPhysicalAlias`=?,`entPhysicalAssetID`=?,`ifIndex`=? WHERE `device_id`=? AND `entPhysicalIndex`=? [0;33m[15,"Slot: 0 Port: 13 Gigabit - Level","port","0\/13","","","2","","13","zeroDotZero","","","","false","","",0,312,15][0m 1.47ms] Discover Inventory Item: 16, Slot: 0 Port: 14 Gigabit - Level, port, 0/14, , , 2, , 14, zeroDotZero, , , , false, , , 0 SQL[[1;33mSELECT COUNT(entPhysical_id) FROM `entPhysical` WHERE `device_id` = ? AND `entPhysicalIndex` = ? [0;33m[312,16][0m 1.18ms] .SQL[[1;33mUPDATE `entPhysical` set `entPhysicalIndex`=?,`entPhysicalDescr`=?,`entPhysicalClass`=?,`entPhysicalName`=?,`entPhysicalModelName`=?,`entPhysicalSerialNum`=?,`entPhysicalContainedIn`=?,`entPhysicalMfgName`=?,`entPhysicalParentRelPos`=?,`entPhysicalVendorType`=?,`entPhysicalHardwareRev`=?,`entPhysicalFirmwareRev`=?,`entPhysicalSoftwareRev`=?,`entPhysicalIsFRU`=?,`entPhysicalAlias`=?,`entPhysicalAssetID`=?,`ifIndex`=? WHERE `device_id`=? AND `entPhysicalIndex`=? [0;33m[16,"Slot: 0 Port: 14 Gigabit - Level","port","0\/14","","","2","","14","zeroDotZero","","","","false","","",0,312,16][0m 1.48ms] Discover Inventory Item: 17, Slot: 0 Port: 15 Gigabit - Level, port, 0/15, , , 2, , 15, zeroDotZero, , , , false, , , 0 SQL[[1;33mSELECT COUNT(entPhysical_id) FROM `entPhysical` WHERE `device_id` = ? AND `entPhysicalIndex` = ? [0;33m[312,17][0m 1.11ms] .SQL[[1;33mUPDATE `entPhysical` set `entPhysicalIndex`=?,`entPhysicalDescr`=?,`entPhysicalClass`=?,`entPhysicalName`=?,`entPhysicalModelName`=?,`entPhysicalSerialNum`=?,`entPhysicalContainedIn`=?,`entPhysicalMfgName`=?,`entPhysicalParentRelPos`=?,`entPhysicalVendorType`=?,`entPhysicalHardwareRev`=?,`entPhysicalFirmwareRev`=?,`entPhysicalSoftwareRev`=?,`entPhysicalIsFRU`=?,`entPhysicalAlias`=?,`entPhysicalAssetID`=?,`ifIndex`=? WHERE `device_id`=? AND `entPhysicalIndex`=? [0;33m[17,"Slot: 0 Port: 15 Gigabit - Level","port","0\/15","","","2","","15","zeroDotZero","","","","false","","",0,312,17][0m 1.46ms] Discover Inventory Item: 18, Slot: 0 Port: 16 Gigabit - Level, port, 0/16, , , 2, , 16, zeroDotZero, , , , false, , , 0 SQL[[1;33mSELECT COUNT(entPhysical_id) FROM `entPhysical` WHERE `device_id` = ? AND `entPhysicalIndex` = ? [0;33m[312,18][0m 1.12ms] .SQL[[1;33mUPDATE `entPhysical` set `entPhysicalIndex`=?,`entPhysicalDescr`=?,`entPhysicalClass`=?,`entPhysicalName`=?,`entPhysicalModelName`=?,`entPhysicalSerialNum`=?,`entPhysicalContainedIn`=?,`entPhysicalMfgName`=?,`entPhysicalParentRelPos`=?,`entPhysicalVendorType`=?,`entPhysicalHardwareRev`=?,`entPhysicalFirmwareRev`=?,`entPhysicalSoftwareRev`=?,`entPhysicalIsFRU`=?,`entPhysicalAlias`=?,`entPhysicalAssetID`=?,`ifIndex`=? WHERE `device_id`=? AND `entPhysicalIndex`=? [0;33m[18,"Slot: 0 Port: 16 Gigabit - Level","port","0\/16","","","2","","16","zeroDotZero","","","","false","","",0,312,18][0m 1.46ms] Discover Inventory Item: 19, Slot: 0 Port: 17 Gigabit - Level, port, 0/17, , , 2, , 17, zeroDotZero, , , , false, , , 0 SQL[[1;33mSELECT COUNT(entPhysical_id) FROM `entPhysical` WHERE `device_id` = ? AND `entPhysicalIndex` = ? [0;33m[312,19][0m 1.13ms] .SQL[[1;33mUPDATE `entPhysical` set `entPhysicalIndex`=?,`entPhysicalDescr`=?,`entPhysicalClass`=?,`entPhysicalName`=?,`entPhysicalModelName`=?,`entPhysicalSerialNum`=?,`entPhysicalContainedIn`=?,`entPhysicalMfgName`=?,`entPhysicalParentRelPos`=?,`entPhysicalVendorType`=?,`entPhysicalHardwareRev`=?,`entPhysicalFirmwareRev`=?,`entPhysicalSoftwareRev`=?,`entPhysicalIsFRU`=?,`entPhysicalAlias`=?,`entPhysicalAssetID`=?,`ifIndex`=? WHERE `device_id`=? AND `entPhysicalIndex`=? [0;33m[19,"Slot: 0 Port: 17 Gigabit - Level","port","0\/17","","","2","","17","zeroDotZero","","","","false","","",0,312,19][0m 1.46ms] Discover Inventory Item: 20, Slot: 0 Port: 18 Gigabit - Level, port, 0/18, , , 2, , 18, zeroDotZero, , , , false, , , 0 SQL[[1;33mSELECT COUNT(entPhysical_id) FROM `entPhysical` WHERE `device_id` = ? AND `entPhysicalIndex` = ? [0;33m[312,20][0m 1.21ms] .SQL[[1;33mUPDATE `entPhysical` set `entPhysicalIndex`=?,`entPhysicalDescr`=?,`entPhysicalClass`=?,`entPhysicalName`=?,`entPhysicalModelName`=?,`entPhysicalSerialNum`=?,`entPhysicalContainedIn`=?,`entPhysicalMfgName`=?,`entPhysicalParentRelPos`=?,`entPhysicalVendorType`=?,`entPhysicalHardwareRev`=?,`entPhysicalFirmwareRev`=?,`entPhysicalSoftwareRev`=?,`entPhysicalIsFRU`=?,`entPhysicalAlias`=?,`entPhysicalAssetID`=?,`ifIndex`=? WHERE `device_id`=? AND `entPhysicalIndex`=? [0;33m[20,"Slot: 0 Port: 18 Gigabit - Level","port","0\/18","","","2","","18","zeroDotZero","","","","false","","",0,312,20][0m 1.44ms] Discover Inventory Item: 21, Slot: 0 Port: 19 Gigabit - Level, port, 0/19, , , 2, , 19, zeroDotZero, , , , false, , , 0 SQL[[1;33mSELECT COUNT(entPhysical_id) FROM `entPhysical` WHERE `device_id` = ? AND `entPhysicalIndex` = ? [0;33m[312,21][0m 1.11ms] .SQL[[1;33mUPDATE `entPhysical` set `entPhysicalIndex`=?,`entPhysicalDescr`=?,`entPhysicalClass`=?,`entPhysicalName`=?,`entPhysicalModelName`=?,`entPhysicalSerialNum`=?,`entPhysicalContainedIn`=?,`entPhysicalMfgName`=?,`entPhysicalParentRelPos`=?,`entPhysicalVendorType`=?,`entPhysicalHardwareRev`=?,`entPhysicalFirmwareRev`=?,`entPhysicalSoftwareRev`=?,`entPhysicalIsFRU`=?,`entPhysicalAlias`=?,`entPhysicalAssetID`=?,`ifIndex`=? WHERE `device_id`=? AND `entPhysicalIndex`=? [0;33m[21,"Slot: 0 Port: 19 Gigabit - Level","port","0\/19","","","2","","19","zeroDotZero","","","","false","","",0,312,21][0m 1.44ms] Discover Inventory Item: 22, Slot: 0 Port: 20 Gigabit - Level, port, 0/20, , , 2, , 20, zeroDotZero, , , , false, , , 0 SQL[[1;33mSELECT COUNT(entPhysical_id) FROM `entPhysical` WHERE `device_id` = ? AND `entPhysicalIndex` = ? [0;33m[312,22][0m 1.06ms] .SQL[[1;33mUPDATE `entPhysical` set `entPhysicalIndex`=?,`entPhysicalDescr`=?,`entPhysicalClass`=?,`entPhysicalName`=?,`entPhysicalModelName`=?,`entPhysicalSerialNum`=?,`entPhysicalContainedIn`=?,`entPhysicalMfgName`=?,`entPhysicalParentRelPos`=?,`entPhysicalVendorType`=?,`entPhysicalHardwareRev`=?,`entPhysicalFirmwareRev`=?,`entPhysicalSoftwareRev`=?,`entPhysicalIsFRU`=?,`entPhysicalAlias`=?,`entPhysicalAssetID`=?,`ifIndex`=? WHERE `device_id`=? AND `entPhysicalIndex`=? [0;33m[22,"Slot: 0 Port: 20 Gigabit - Level","port","0\/20","","","2","","20","zeroDotZero","","","","false","","",0,312,22][0m 1.45ms] Discover Inventory Item: 23, Slot: 0 Port: 21 Gigabit - Level, port, 0/21, , , 2, , 21, zeroDotZero, , , , false, , , 0 SQL[[1;33mSELECT COUNT(entPhysical_id) FROM `entPhysical` WHERE `device_id` = ? AND `entPhysicalIndex` = ? [0;33m[312,23][0m 1.03ms] .SQL[[1;33mUPDATE `entPhysical` set `entPhysicalIndex`=?,`entPhysicalDescr`=?,`entPhysicalClass`=?,`entPhysicalName`=?,`entPhysicalModelName`=?,`entPhysicalSerialNum`=?,`entPhysicalContainedIn`=?,`entPhysicalMfgName`=?,`entPhysicalParentRelPos`=?,`entPhysicalVendorType`=?,`entPhysicalHardwareRev`=?,`entPhysicalFirmwareRev`=?,`entPhysicalSoftwareRev`=?,`entPhysicalIsFRU`=?,`entPhysicalAlias`=?,`entPhysicalAssetID`=?,`ifIndex`=? WHERE `device_id`=? AND `entPhysicalIndex`=? [0;33m[23,"Slot: 0 Port: 21 Gigabit - Level","port","0\/21","","","2","","21","zeroDotZero","","","","false","","",0,312,23][0m 1.42ms] Discover Inventory Item: 24, Slot: 0 Port: 22 Gigabit - Level, port, 0/22, , , 2, , 22, zeroDotZero, , , , false, , , 0 SQL[[1;33mSELECT COUNT(entPhysical_id) FROM `entPhysical` WHERE `device_id` = ? AND `entPhysicalIndex` = ? [0;33m[312,24][0m 1.03ms] .SQL[[1;33mUPDATE `entPhysical` set `entPhysicalIndex`=?,`entPhysicalDescr`=?,`entPhysicalClass`=?,`entPhysicalName`=?,`entPhysicalModelName`=?,`entPhysicalSerialNum`=?,`entPhysicalContainedIn`=?,`entPhysicalMfgName`=?,`entPhysicalParentRelPos`=?,`entPhysicalVendorType`=?,`entPhysicalHardwareRev`=?,`entPhysicalFirmwareRev`=?,`entPhysicalSoftwareRev`=?,`entPhysicalIsFRU`=?,`entPhysicalAlias`=?,`entPhysicalAssetID`=?,`ifIndex`=? WHERE `device_id`=? AND `entPhysicalIndex`=? [0;33m[24,"Slot: 0 Port: 22 Gigabit - Level","port","0\/22","","","2","","22","zeroDotZero","","","","false","","",0,312,24][0m 1.41ms] Discover Inventory Item: 25, Slot: 0 Port: 23 Gigabit - Level, port, 0/23, , , 2, , 23, zeroDotZero, , , , false, , , 0 SQL[[1;33mSELECT COUNT(entPhysical_id) FROM `entPhysical` WHERE `device_id` = ? AND `entPhysicalIndex` = ? [0;33m[312,25][0m 1.09ms] .SQL[[1;33mUPDATE `entPhysical` set `entPhysicalIndex`=?,`entPhysicalDescr`=?,`entPhysicalClass`=?,`entPhysicalName`=?,`entPhysicalModelName`=?,`entPhysicalSerialNum`=?,`entPhysicalContainedIn`=?,`entPhysicalMfgName`=?,`entPhysicalParentRelPos`=?,`entPhysicalVendorType`=?,`entPhysicalHardwareRev`=?,`entPhysicalFirmwareRev`=?,`entPhysicalSoftwareRev`=?,`entPhysicalIsFRU`=?,`entPhysicalAlias`=?,`entPhysicalAssetID`=?,`ifIndex`=? WHERE `device_id`=? AND `entPhysicalIndex`=? [0;33m[25,"Slot: 0 Port: 23 Gigabit - Level","port","0\/23","","","2","","23","zeroDotZero","","","","false","","",0,312,25][0m 1.37ms] Discover Inventory Item: 26, Slot: 0 Port: 24 Gigabit - Level, port, 0/24, , , 2, , 24, zeroDotZero, , , , false, , , 0 SQL[[1;33mSELECT COUNT(entPhysical_id) FROM `entPhysical` WHERE `device_id` = ? AND `entPhysicalIndex` = ? [0;33m[312,26][0m 1.06ms] .SQL[[1;33mUPDATE `entPhysical` set `entPhysicalIndex`=?,`entPhysicalDescr`=?,`entPhysicalClass`=?,`entPhysicalName`=?,`entPhysicalModelName`=?,`entPhysicalSerialNum`=?,`entPhysicalContainedIn`=?,`entPhysicalMfgName`=?,`entPhysicalParentRelPos`=?,`entPhysicalVendorType`=?,`entPhysicalHardwareRev`=?,`entPhysicalFirmwareRev`=?,`entPhysicalSoftwareRev`=?,`entPhysicalIsFRU`=?,`entPhysicalAlias`=?,`entPhysicalAssetID`=?,`ifIndex`=? WHERE `device_id`=? AND `entPhysicalIndex`=? [0;33m[26,"Slot: 0 Port: 24 Gigabit - Level","port","0\/24","","","2","","24","zeroDotZero","","","","false","","",0,312,26][0m 1.37ms] Discover Inventory Item: 27, Slot: 0 Port: 25 Gigabit - Level, port, 0/25, , , 2, , 25, zeroDotZero, , , , false, , , 0 SQL[[1;33mSELECT COUNT(entPhysical_id) FROM `entPhysical` WHERE `device_id` = ? AND `entPhysicalIndex` = ? [0;33m[312,27][0m 1.04ms] .SQL[[1;33mUPDATE `entPhysical` set `entPhysicalIndex`=?,`entPhysicalDescr`=?,`entPhysicalClass`=?,`entPhysicalName`=?,`entPhysicalModelName`=?,`entPhysicalSerialNum`=?,`entPhysicalContainedIn`=?,`entPhysicalMfgName`=?,`entPhysicalParentRelPos`=?,`entPhysicalVendorType`=?,`entPhysicalHardwareRev`=?,`entPhysicalFirmwareRev`=?,`entPhysicalSoftwareRev`=?,`entPhysicalIsFRU`=?,`entPhysicalAlias`=?,`entPhysicalAssetID`=?,`ifIndex`=? WHERE `device_id`=? AND `entPhysicalIndex`=? [0;33m[27,"Slot: 0 Port: 25 Gigabit - Level","port","0\/25","","","2","","25","zeroDotZero","","","","false","","",0,312,27][0m 1.39ms] Discover Inventory Item: 28, Slot: 0 Port: 26 Gigabit - Level, port, 0/26, , , 2, , 26, zeroDotZero, , , , false, , , 0 SQL[[1;33mSELECT COUNT(entPhysical_id) FROM `entPhysical` WHERE `device_id` = ? AND `entPhysicalIndex` = ? [0;33m[312,28][0m 1.06ms] .SQL[[1;33mUPDATE `entPhysical` set `entPhysicalIndex`=?,`entPhysicalDescr`=?,`entPhysicalClass`=?,`entPhysicalName`=?,`entPhysicalModelName`=?,`entPhysicalSerialNum`=?,`entPhysicalContainedIn`=?,`entPhysicalMfgName`=?,`entPhysicalParentRelPos`=?,`entPhysicalVendorType`=?,`entPhysicalHardwareRev`=?,`entPhysicalFirmwareRev`=?,`entPhysicalSoftwareRev`=?,`entPhysicalIsFRU`=?,`entPhysicalAlias`=?,`entPhysicalAssetID`=?,`ifIndex`=? WHERE `device_id`=? AND `entPhysicalIndex`=? [0;33m[28,"Slot: 0 Port: 26 Gigabit - Level","port","0\/26","","","2","","26","zeroDotZero","","","","false","","",0,312,28][0m 1.35ms] SQL[[1;33mSELECT * FROM `entPhysical` WHERE `device_id` = ? [0;33m[312][0m 1.5ms] >> Runtime for discovery module 'entity-physical': 0.3120 seconds with 76632 bytes >> [0;36mSNMP[0m: [1/0.15s] [1;33mMySQL[0m: [57/0.75s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module entity-physical #### Modules status: Global+ OS Device #### Load disco module entity-state #### SQL[[1;33mSELECT entPhysical_id, entPhysicalIndex FROM entPhysical WHERE device_id=? [0;33m[312][0m 1.03ms] Entity States: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUsetX' '-m' 'ENTITY-STATE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'entStateTable'[0m] entStateTable = No Such Object available on this agent at this OID SQL[[1;33mSELECT * FROM entityState WHERE device_id=? [0;33m[312][0m 1.17ms] >> Runtime for discovery module 'entity-state': 0.0500 seconds with -696 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [2/0.02s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module entity-state #### Modules status: Global- OS Device Module [ isis ] disabled globally. Modules status: Global+ OS Device #### Load disco module processors #### No YAML Discovery data. SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Ovq' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' '.1.3.6.1.4.1.4413.1.1.1.1.4.9.0'[0m] " 5 Secs ( 10.6642%) 60 Secs ( 13.6265%) 300 Secs ( 14.6229%)" Discovered LibreNMS\Device\Processor Array ( [processor_id] => [entPhysicalIndex] => 0 [hrDeviceIndex] => 0 [device_id] => 312 [processor_oid] => .1.3.6.1.4.1.4413.1.1.1.1.4.9.0 [processor_index] => 0 [processor_type] => edgeswitch [processor_usage] => 10.6642 [processor_descr] => Processor [processor_precision] => 1 [processor_perc_warn] => 75 ) SQL[[1;33mSELECT * FROM `processors` WHERE device_id=? AND processor_index=? AND processor_type=? [0;33m[312,"0","edgeswitch"][0m 1.69ms] .SQL[[1;33mSELECT * FROM `processors` WHERE device_id=? AND processor_index=? AND processor_type=? [0;33m[312,"0","edgeswitch"][0m 0.76ms] .SQL[[1;33mSELECT * FROM `processors` WHERE `device_id`=? AND `processor_id` NOT IN (?,?) [0;33m[312,939,939][0m 1.03ms] SQL[[1;33mDELETE T FROM `processors` T LEFT JOIN `devices` ON `devices`.`device_id` = T.`device_id` WHERE `devices`.`device_id` IS NULL [0;33m[][0m 2.86ms] >> Runtime for discovery module 'processors': 0.4300 seconds with 121144 bytes >> [0;36mSNMP[0m: [1/0.42s] [1;33mMySQL[0m: [4/0.06s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module processors #### Modules status: Global+ OS Device #### Load disco module mempools #### SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUb' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'EdgeSwitch-SWITCHING-MIB::agentSwitchCpuProcessMemAvailable'[0m] EdgeSwitch-SWITCHING-MIB::agentSwitchCpuProcessMemAvailable.0 = 256232 SQL[[1;33mselect * from `cache` where `key` = ? limit 1 [0;33m["laravel_cacheOid:toNumeric:EdgeSwitch-SWITCHING-MIB::agentSwitchCpuProcessMemAvailable\/"][0m 1.58ms] SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUb' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'EdgeSwitch-SWITCHING-MIB::agentSwitchCpuProcessMemFree'[0m] EdgeSwitch-SWITCHING-MIB::agentSwitchCpuProcessMemFree.0 = 113432 SQL[[1;33mselect * from `cache` where `key` = ? limit 1 [0;33m["laravel_cacheOid:toNumeric:EdgeSwitch-SWITCHING-MIB::agentSwitchCpuProcessMemFree\/"][0m 1.25ms] SQL[[1;33mselect * from `mempools` where `mempools`.`device_id` = ? and `mempools`.`device_id` is not null [0;33m[312][0m 1.37ms] SQL[[1;33mupdate `mempools` set `mempool_used` = ?, `mempool_free` = ? where `mempool_id` = ? [0;33m[146227200,116154368,643][0m 5.78ms] Updated data: array ( 'mempool_used' => 146227200, 'mempool_free' => 116154368, ) edgeswitch [system]: Memory: 569.45 MiB / 250.23 MiB >> Runtime for discovery module 'mempools': 0.9660 seconds with 402472 bytes >> [0;36mSNMP[0m: [2/0.93s] [1;33mMySQL[0m: [4/0.10s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module mempools #### Modules status: Global- OS Device+ #### Load disco module cisco-vrf-lite #### SQL[[1;33mSELECT * FROM vrf_lite_cisco WHERE device_id = ? [0;33m[312][0m 1.53ms] >> Runtime for discovery module 'cisco-vrf-lite': 0.0020 seconds with -224 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.02s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module cisco-vrf-lite #### Modules status: Global- OS Device+ #### Load disco module cisco-mac-accounting #### >> Runtime for discovery module 'cisco-mac-accounting': 0.0000 seconds with 832 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module cisco-mac-accounting #### Modules status: Global- OS Device+ #### Load disco module cisco-pw #### >> Runtime for discovery module 'cisco-pw': 0.0000 seconds with 1352 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module cisco-pw #### Modules status: Global- OS Device+ #### Load disco module vrf #### SQL[[1;33mSELECT * FROM ports WHERE device_id = '312' [0;33m[][0m 1.43ms] SQL[[1;33mSELECT * FROM vrfs WHERE device_id = '312' [0;33m[][0m 1.4ms] >> Runtime for discovery module 'vrf': 0.0050 seconds with 6704 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [2/0.03s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module vrf #### Modules status: Global- OS Device+ #### Load disco module cisco-cef #### SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'CISCO-CEF-MIB::cefSwitchingPath'[0m] Exitcode: 1 MIB search path: /opt/librenms/mibs:/opt/librenms/mibs/edgeswitch Cannot find module (CISCO-CEF-MIB): At line 1 in (none) CISCO-CEF-MIB::cefSwitchingPath: Unknown Object Identifier MIB search path: /opt/librenms/mibs:/opt/librenms/mibs/edgeswitch Cannot find module (CISCO-CEF-MIB): At line 1 in (none) CISCO-CEF-MIB::cefSwitchingPath: Unknown Object Identifier array ( ) Caching OIDs: entPhysicalDescrSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'ENTITY-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'entPhysicalDescr'[0m] entPhysicalDescr.1 = UBNT EdgeSwitch 24-Port entPhysicalDescr.2 = UBNT ES24 - 24 GE POE + 2 GE Ethernet Line Card entPhysicalDescr.3 = Slot: 0 Port: 1 Gigabit - Level entPhysicalDescr.4 = Slot: 0 Port: 2 Gigabit - Level entPhysicalDescr.5 = Slot: 0 Port: 3 Gigabit - Level entPhysicalDescr.6 = Slot: 0 Port: 4 Gigabit - Level entPhysicalDescr.7 = Slot: 0 Port: 5 Gigabit - Level entPhysicalDescr.8 = Slot: 0 Port: 6 Gigabit - Level entPhysicalDescr.9 = Slot: 0 Port: 7 Gigabit - Level entPhysicalDescr.10 = Slot: 0 Port: 8 Gigabit - Level entPhysicalDescr.11 = Slot: 0 Port: 9 Gigabit - Level entPhysicalDescr.12 = Slot: 0 Port: 10 Gigabit - Level entPhysicalDescr.13 = Slot: 0 Port: 11 Gigabit - Level entPhysicalDescr.14 = Slot: 0 Port: 12 Gigabit - Level entPhysicalDescr.15 = Slot: 0 Port: 13 Gigabit - Level entPhysicalDescr.16 = Slot: 0 Port: 14 Gigabit - Level entPhysicalDescr.17 = Slot: 0 Port: 15 Gigabit - Level entPhysicalDescr.18 = Slot: 0 Port: 16 Gigabit - Level entPhysicalDescr.19 = Slot: 0 Port: 17 Gigabit - Level entPhysicalDescr.20 = Slot: 0 Port: 18 Gigabit - Level entPhysicalDescr.21 = Slot: 0 Port: 19 Gigabit - Level entPhysicalDescr.22 = Slot: 0 Port: 20 Gigabit - Level entPhysicalDescr.23 = Slot: 0 Port: 21 Gigabit - Level entPhysicalDescr.24 = Slot: 0 Port: 22 Gigabit - Level entPhysicalDescr.25 = Slot: 0 Port: 23 Gigabit - Level entPhysicalDescr.26 = Slot: 0 Port: 24 Gigabit - Level entPhysicalDescr.27 = Slot: 0 Port: 25 Gigabit - Level entPhysicalDescr.28 = Slot: 0 Port: 26 Gigabit - Level entPhysicalNameSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'ENTITY-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'entPhysicalName'[0m] entPhysicalName.1 = Unit 1 entPhysicalName.2 = Slot 1.0 entPhysicalName.3 = 0/1 entPhysicalName.4 = 0/2 entPhysicalName.5 = 0/3 entPhysicalName.6 = 0/4 entPhysicalName.7 = 0/5 entPhysicalName.8 = 0/6 entPhysicalName.9 = 0/7 entPhysicalName.10 = 0/8 entPhysicalName.11 = 0/9 entPhysicalName.12 = 0/10 entPhysicalName.13 = 0/11 entPhysicalName.14 = 0/12 entPhysicalName.15 = 0/13 entPhysicalName.16 = 0/14 entPhysicalName.17 = 0/15 entPhysicalName.18 = 0/16 entPhysicalName.19 = 0/17 entPhysicalName.20 = 0/18 entPhysicalName.21 = 0/19 entPhysicalName.22 = 0/20 entPhysicalName.23 = 0/21 entPhysicalName.24 = 0/22 entPhysicalName.25 = 0/23 entPhysicalName.26 = 0/24 entPhysicalName.27 = 0/25 entPhysicalName.28 = 0/26 entPhysicalModelNameSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'ENTITY-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'entPhysicalModelName'[0m] entPhysicalModelName.1 = UBNT-ES24 entPhysicalModelName.2 = UBNT-ES24-24GE-POE-2GIG entPhysicalModelName.3 = entPhysicalModelName.4 = entPhysicalModelName.5 = entPhysicalModelName.6 = entPhysicalModelName.7 = entPhysicalModelName.8 = entPhysicalModelName.9 = entPhysicalModelName.10 = entPhysicalModelName.11 = entPhysicalModelName.12 = entPhysicalModelName.13 = entPhysicalModelName.14 = entPhysicalModelName.15 = entPhysicalModelName.16 = entPhysicalModelName.17 = entPhysicalModelName.18 = entPhysicalModelName.19 = entPhysicalModelName.20 = entPhysicalModelName.21 = entPhysicalModelName.22 = entPhysicalModelName.23 = entPhysicalModelName.24 = entPhysicalModelName.25 = entPhysicalModelName.26 = entPhysicalModelName.27 = entPhysicalModelName.28 = >> Runtime for discovery module 'cisco-cef': 0.5500 seconds with 44224 bytes >> [0;36mSNMP[0m: [3/0.13s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module cisco-cef #### Modules status: Global- OS Device Module [ slas ] disabled globally. Modules status: Global- OS Device+ #### Load disco module cisco-cbqos #### >> Runtime for discovery module 'cisco-cbqos': 0.0010 seconds with 2704 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module cisco-cbqos #### Modules status: Global- OS Device+ #### Load disco module cisco-otv #### >> Runtime for discovery module 'cisco-otv': 0.0010 seconds with 4216 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module cisco-otv #### Modules status: Global- OS Device+ #### Load disco module cisco-qfp #### >> Runtime for discovery module 'cisco-qfp': 0.0000 seconds with 1112 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module cisco-qfp #### Modules status: Global+ OS Device #### Load disco module ipv4-addresses #### SQL[[1;33mselect * from `vrf_lite_cisco` where `vrf_lite_cisco`.`device_id` = ? and `vrf_lite_cisco`.`device_id` is not null [0;33m[312][0m 1.17ms] SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-Osq' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'ipAdEntIfIndex'[0m] ipAdEntIfIndex.* 65 SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-m' 'IP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'ipAdEntNetMask.172.22.1.64'[0m] * SQL[[1;33mSELECT COUNT(*) FROM `ports` WHERE device_id = ? AND `ifIndex` = ? [0;33m[312,"65"][0m 1.45ms] !SQL[[1;33mSELECT `ipv4_addresses`.*, `ports`.`device_id`, `ports`.`ifIndex` FROM `ipv4_addresses` LEFT JOIN `ports` ON `ipv4_addresses`.`port_id` = `ports`.`port_id` WHERE `ports`.device_id = ? OR `ports`.`device_id` IS NULL [0;33m[312][0m 4.92ms] >> Runtime for discovery module 'ipv4-addresses': 0.1010 seconds with 36952 bytes >> [0;36mSNMP[0m: [2/0.09s] [1;33mMySQL[0m: [3/0.08s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module ipv4-addresses #### Modules status: Global- OS Device+ #### Load disco module ipv6-addresses #### SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' '-v2c' '-c' 'COMMUNITY' '-OQXUt' 'udp:HOSTNAME:161' 'IP-MIB::ipAddressIfIndex.ipv6'[0m] IP-MIB::ipAddressIfIndex[ipv6] = No Such Object available on this agent at this OID SNMP query failed. Exit Code: 0 Empty: false Bad String: No Such Object available on this agent at this OID SNMP failed walking IP-MIB::ipAddressIfIndex.ipv6 of IP-MIB::ipAddressIfIndex.ipv6,IP-MIB::ipAddressOrigin.ipv6,IP-MIB::ipAddressPrefix.ipv6 aborting. SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OsqnU' '-Ln' '-m' 'IPV6-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'ipv6AddrPfxLength'[0m] .*.*.8.1.2 No Such Object available on this agent at this OID Invalid snmp_walk() data = .1.3.6.1.2.1.55.1.8.1.2 No Such Object available on this agent at this OID SQL[[1;33mSELECT `ipv6_addresses`.*, `ports`.`device_id`, `ports`.`ifIndex` FROM `ipv6_addresses` LEFT JOIN `ports` ON `ipv6_addresses`.`port_id` = `ports`.`port_id` WHERE `ports`.device_id = ? OR `ports`.`device_id` IS NULL [0;33m[312][0m 1.55ms] >> Runtime for discovery module 'ipv6-addresses': 0.4650 seconds with -104 bytes >> [0;36mSNMP[0m: [2/0.46s] [1;33mMySQL[0m: [1/0.02s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module ipv6-addresses #### Modules status: Global- OS Device+ #### Load disco module route #### SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Osqn' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'IP-FORWARD-MIB::inetCidrRouteNumber.0'[0m] .*.*.6.0 No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'IP-FORWARD-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'inetCidrRouteNumber.0' 'ipCidrRouteNumber.0'[0m] inetCidrRouteNumber.0 = No Such Object available on this agent at this OID ipCidrRouteNumber.0 = No Such Object available on this agent at this OID SQL[[1;33mselect now() as now [0;33m[][0m 0.87ms] SQL[[1;33mselect * from `route` where `device_id` = ? [0;33m[312][0m 2.51ms] SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUsetX' '-m' 'RFC1213-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' '.1.3.6.1.2.1.4.21'[0m] ipRouteDest[*] = * ipRouteDest[*] = * ipRouteIfIndex[*] = 3 ipRouteIfIndex[*] = 3 ipRouteMetric1[*] = 0 ipRouteMetric1[*] = 0 ipRouteMetric2[*] = -1 ipRouteMetric2[*] = -1 ipRouteMetric3[*] = -1 ipRouteMetric3[*] = -1 ipRouteMetric4[*] = -1 ipRouteMetric4[*] = -1 ipRouteNextHop[*] = * ipRouteNextHop[*] = * ipRouteType[*] = 4 ipRouteType[*] = 3 ipRouteProto[*] = 1 ipRouteProto[*] = 1 ipRouteAge[*] = 0 ipRouteAge[*] = 0 ipRouteMask[*] = * ipRouteMask[*] = * ipRouteMetric5[*] = -1 ipRouteMetric5[*] = -1 ipRouteInfo[*] = ccitt.0 ipRouteInfo[*] = ccitt.0 Routing table: array ( '0.0.0.0' => array ( 'ipRouteDest' => '0.0.0.0', 'ipRouteIfIndex' => '3', 'ipRouteMetric1' => '0', 'ipRouteMetric2' => '-1', 'ipRouteMetric3' => '-1', 'ipRouteMetric4' => '-1', 'ipRouteNextHop' => '172.22.1.2', 'ipRouteType' => '4', 'ipRouteProto' => '1', 'ipRouteAge' => '0', 'ipRouteMask' => '0.0.0.0', 'ipRouteMetric5' => '-1', 'ipRouteInfo' => 'ccitt.0', ), '172.22.0.0' => array ( 'ipRouteDest' => '172.22.0.0', 'ipRouteIfIndex' => '3', 'ipRouteMetric1' => '0', 'ipRouteMetric2' => '-1', 'ipRouteMetric3' => '-1', 'ipRouteMetric4' => '-1', 'ipRouteNextHop' => '0.0.0.0', 'ipRouteType' => '3', 'ipRouteProto' => '1', 'ipRouteAge' => '0', 'ipRouteMask' => '255.255.0.0', 'ipRouteMetric5' => '-1', 'ipRouteInfo' => 'ccitt.0', ), ) RFC1213 SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[312][0m 2.1ms] SQL[[1;33mselect * from `ports` where `ports`.`device_id` = ? and `ports`.`device_id` is not null and `ifIndex` = ? limit 1 [0;33m[312,"3"][0m 1.47ms] SQL[[1;33mselect * from `devices` where `devices`.`device_id` = ? limit 1 [0;33m[312][0m 0.9ms] SQL[[1;33mselect * from `ports` where `ports`.`device_id` = ? and `ports`.`device_id` is not null and `ifIndex` = ? limit 1 [0;33m[312,"3"][0m 0.99ms] SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUsetX' '-m' 'MPLS-L3VPN-STD-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'mplsL3VpnVrfPerfCurrNumRoutes'[0m] mplsL3VpnVrfPerfCurrNumRoutes = No Such Object available on this agent at this OID mplsL3VpnVrfRteTable SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUsetX' '-m' 'MPLS-L3VPN-STD-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'mplsL3VpnVrfRteTable'[0m] mplsL3VpnVrfRteTable = No Such Object available on this agent at this OID Processing: SQL[[1;33mDELETE FROM `route` WHERE `route_id` = ? [0;33m[29786][0m 5.61ms] -array ( 'route_id' => 29786, 'created_at' => '2022-11-14 11:14:04', 'updated_at' => '2022-11-14 11:14:04', 'device_id' => 312, 'port_id' => 0, 'context_name' => '', 'inetCidrRouteIfIndex' => 3, 'inetCidrRouteType' => 4, 'inetCidrRouteProto' => 1, 'inetCidrRouteNextHopAS' => 0, 'inetCidrRouteMetric1' => 0, 'inetCidrRouteDestType' => 'ipv4', 'inetCidrRouteDest' => '0.0.0.0', 'inetCidrRouteNextHopType' => 'ipv4', 'inetCidrRouteNextHop' => '172.22.1.2', 'inetCidrRoutePolicy' => 'ccitt.0', 'inetCidrRoutePfxLen' => 0, ) SQL[[1;33mDELETE FROM `route` WHERE `route_id` = ? [0;33m[29787][0m 5.13ms] -array ( 'route_id' => 29787, 'created_at' => '2022-11-14 11:14:04', 'updated_at' => '2022-11-14 11:14:04', 'device_id' => 312, 'port_id' => 0, 'context_name' => '', 'inetCidrRouteIfIndex' => 3, 'inetCidrRouteType' => 3, 'inetCidrRouteProto' => 1, 'inetCidrRouteNextHopAS' => 0, 'inetCidrRouteMetric1' => 0, 'inetCidrRouteDestType' => 'ipv4', 'inetCidrRouteDest' => '172.22.0.0', 'inetCidrRouteNextHopType' => 'ipv4', 'inetCidrRouteNextHop' => '0.0.0.0', 'inetCidrRoutePolicy' => 'ccitt.0', 'inetCidrRoutePfxLen' => 16, ) SQL[[1;33mINSERT IGNORE INTO `route` (`inetCidrRouteDestType`,`inetCidrRouteDest`,`inetCidrRoutePfxLen`,`inetCidrRoutePolicy`,`inetCidrRouteNextHopType`,`inetCidrRouteNextHop`,`inetCidrRouteMetric1`,`inetCidrRouteNextHopAS`,`inetCidrRouteProto`,`inetCidrRouteType`,`inetCidrRouteIfIndex`,`context_name`,`device_id`,`port_id`,`updated_at`,`created_at`) VALUES (:inetCidrRouteDestType,:inetCidrRouteDest,:inetCidrRoutePfxLen,:inetCidrRoutePolicy,:inetCidrRouteNextHopType,:inetCidrRouteNextHop,:inetCidrRouteMetric1,:inetCidrRouteNextHopAS,:inetCidrRouteProto,:inetCidrRouteType,:inetCidrRouteIfIndex,:context_name,:device_id,:port_id,:updated_at,:created_at) [0;33m{"inetCidrRouteDestType":"ipv4","inetCidrRouteDest":"0.0.0.0","inetCidrRoutePfxLen":0,"inetCidrRoutePolicy":"ccitt.0","inetCidrRouteNextHopType":"ipv4","inetCidrRouteNextHop":"172.22.1.2","inetCidrRouteMetric1":"0","inetCidrRouteNextHopAS":"0","inetCidrRouteProto":"1","inetCidrRouteType":"4","inetCidrRouteIfIndex":"3","context_name":"","device_id":312,"port_id":null,"updated_at":"2022-11-14 11:19:51","created_at":"2022-11-14 11:19:51"}[0m 4.88ms] +SQL[[1;33mINSERT IGNORE INTO `route` (`inetCidrRouteDestType`,`inetCidrRouteDest`,`inetCidrRoutePfxLen`,`inetCidrRoutePolicy`,`inetCidrRouteNextHopType`,`inetCidrRouteNextHop`,`inetCidrRouteMetric1`,`inetCidrRouteNextHopAS`,`inetCidrRouteProto`,`inetCidrRouteType`,`inetCidrRouteIfIndex`,`context_name`,`device_id`,`port_id`,`updated_at`,`created_at`) VALUES (:inetCidrRouteDestType,:inetCidrRouteDest,:inetCidrRoutePfxLen,:inetCidrRoutePolicy,:inetCidrRouteNextHopType,:inetCidrRouteNextHop,:inetCidrRouteMetric1,:inetCidrRouteNextHopAS,:inetCidrRouteProto,:inetCidrRouteType,:inetCidrRouteIfIndex,:context_name,:device_id,:port_id,:updated_at,:created_at) [0;33m{"inetCidrRouteDestType":"ipv4","inetCidrRouteDest":"172.22.0.0","inetCidrRoutePfxLen":16,"inetCidrRoutePolicy":"ccitt.0","inetCidrRouteNextHopType":"ipv4","inetCidrRouteNextHop":"0.0.0.0","inetCidrRouteMetric1":"0","inetCidrRouteNextHopAS":"0","inetCidrRouteProto":"1","inetCidrRouteType":"3","inetCidrRouteIfIndex":"3","context_name":"","device_id":312,"port_id":null,"updated_at":"2022-11-14 11:19:51","created_at":"2022-11-14 11:19:51"}[0m 4.95ms] + >> Runtime for discovery module 'route': 0.6650 seconds with 93968 bytes >> [0;36mSNMP[0m: [2/0.46s] [1;33mMySQL[0m: [10/0.29s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module route #### Modules status: Global+ OS Device #### Load disco module sensors #### Caching data: mempools os sensors SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OteQUsa' '-Ih' '-m' 'EdgeSwitch-BOXSERVICES-PRIVATE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'boxServicesTempUnitEntry'[0m] boxServicesTempUnitIndex.1 = 1 boxServicesTempUnitState.1 = 1 boxServicesTempUnitTemperature.1 = 33 SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OteQUsa' '-Ih' '-m' 'EdgeSwitch-BOXSERVICES-PRIVATE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'boxServicesTempSensorsEntry'[0m] boxServicesUnitIndex.1.0 = 1 boxServicesUnitIndex.1.1 = 1 boxServicesUnitIndex.1.2 = 1 boxServicesUnitIndex.1.3 = 1 boxServicesUnitIndex.1.4 = 1 boxServicesUnitIndex.1.5 = 1 boxServicesUnitIndex.1.6 = 1 boxServicesUnitIndex.1.7 = 1 boxServicesTempSensorIndex.1.0 = 0 boxServicesTempSensorIndex.1.1 = 1 boxServicesTempSensorIndex.1.2 = 2 boxServicesTempSensorIndex.1.3 = 3 boxServicesTempSensorIndex.1.4 = 4 boxServicesTempSensorIndex.1.5 = 5 boxServicesTempSensorIndex.1.6 = 6 boxServicesTempSensorIndex.1.7 = 7 boxServicesTempSensorType.1.0 = 1 boxServicesTempSensorType.1.1 = 1 boxServicesTempSensorType.1.2 = 1 boxServicesTempSensorType.1.3 = 1 boxServicesTempSensorType.1.4 = 1 boxServicesTempSensorType.1.5 = 1 boxServicesTempSensorType.1.6 = 1 boxServicesTempSensorType.1.7 = 1 boxServicesTempSensorState.1.0 = 1 boxServicesTempSensorState.1.1 = 1 boxServicesTempSensorState.1.2 = 1 boxServicesTempSensorState.1.3 = 1 boxServicesTempSensorState.1.4 = 1 boxServicesTempSensorState.1.5 = 1 boxServicesTempSensorState.1.6 = 1 boxServicesTempSensorState.1.7 = 1 boxServicesTempSensorTemperature.1.0 = 32 boxServicesTempSensorTemperature.1.1 = 19 boxServicesTempSensorTemperature.1.2 = 33 boxServicesTempSensorTemperature.1.3 = 29 boxServicesTempSensorTemperature.1.4 = 29 boxServicesTempSensorTemperature.1.5 = 31 boxServicesTempSensorTemperature.1.6 = 29 boxServicesTempSensorTemperature.1.7 = 29 SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OteQUsa' '-Ih' '-m' 'EdgeSwitch-BOXSERVICES-PRIVATE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'boxServicesFansEntry'[0m] boxServicesFansIndex.1.0 = 0 boxServicesFansIndex.1.1 = 1 boxServicesFansIndex.1.2 = 2 boxServicesFansIndex.1.3 = 3 boxServicesFanItemType.1.0 = 1 boxServicesFanItemType.1.1 = 1 boxServicesFanItemType.1.2 = 1 boxServicesFanItemType.1.3 = 1 boxServicesFanItemState.1.0 = 2 boxServicesFanItemState.1.1 = 2 boxServicesFanItemState.1.2 = 2 boxServicesFanItemState.1.3 = 2 boxServicesFanSpeed.1.0 = 0 boxServicesFanSpeed.1.1 = 0 boxServicesFanSpeed.1.2 = 0 boxServicesFanSpeed.1.3 = 0 boxServicesFanDutyLevel.1.0 = 50 boxServicesFanDutyLevel.1.1 = 50 boxServicesFanDutyLevel.1.2 = 50 boxServicesFanDutyLevel.1.3 = 50 boxServicesFanUnitIndex.1.0 = 1 boxServicesFanUnitIndex.1.1 = 1 boxServicesFanUnitIndex.1.2 = 1 boxServicesFanUnitIndex.1.3 = 1 ENTITY-SENSOR: Caching OIDs: entPhysicalDescr entPhysicalName entPhySensorTypeSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'ENTITY-SENSOR-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'entPhySensorType'[0m] entPhySensorType = No Such Object available on this agent at this OID Invalid snmp_walk() data = entPhySensorType = No Such Object available on this agent at this OID entPhySensorScaleSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'ENTITY-SENSOR-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'entPhySensorScale'[0m] entPhySensorScale = No Such Object available on this agent at this OID Invalid snmp_walk() data = entPhySensorScale = No Such Object available on this agent at this OID entPhySensorPrecisionSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'ENTITY-SENSOR-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'entPhySensorPrecision'[0m] entPhySensorPrecision = No Such Object available on this agent at this OID Invalid snmp_walk() data = entPhySensorPrecision = No Such Object available on this agent at this OID entPhySensorValueSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'ENTITY-SENSOR-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'entPhySensorValue'[0m] entPhySensorValue = No Such Object available on this agent at this OID Invalid snmp_walk() data = entPhySensorValue = No Such Object available on this agent at this OID entPhySensorOperStatusSNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'ENTITY-SENSOR-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'entPhySensorOperStatus'[0m] entPhySensorOperStatus = No Such Object available on this agent at this OID Invalid snmp_walk() data = entPhySensorOperStatus = No Such Object available on this agent at this OID SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["voltage",312,"ipmi"][0m 2.76ms] SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["temperature",312,"ipmi"][0m 1.89ms] SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["fanspeed",312,"ipmi"][0m 1.82ms] SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["power",312,"ipmi"][0m 1.75ms] Airflow: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["airflow",312,"snmp"][0m 1.68ms] Current: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["current",312,"snmp"][0m 1.74ms] Charge: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["charge",312,"snmp"][0m 1.67ms] Dbm: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["dbm",312,"snmp"][0m 1.71ms] Fanspeed: Dynamic Discovery (fanspeed): array ( 'data' => array ( 0 => array ( 'oid' => 'boxServicesFansEntry', 'value' => 'boxServicesFanSpeed', 'num_oid' => '.1.3.6.1.4.1.4413.1.1.43.1.6.1.4.{{ $index }}', 'index' => 'boxServicesFanSpeed.{{ $index }}', 'descr' => 'Fan {{ $index }}', ), ), ) Data boxServicesFansEntry: array ( '1.0' => array ( 'boxServicesFansIndex' => '0', 'boxServicesFanItemType' => '1', 'boxServicesFanItemState' => '2', 'boxServicesFanSpeed' => '0', 'boxServicesFanDutyLevel' => '50', 'boxServicesFanUnitIndex' => '1', ), '1.1' => array ( 'boxServicesFansIndex' => '1', 'boxServicesFanItemType' => '1', 'boxServicesFanItemState' => '2', 'boxServicesFanSpeed' => '0', 'boxServicesFanDutyLevel' => '50', 'boxServicesFanUnitIndex' => '1', ), '1.2' => array ( 'boxServicesFansIndex' => '2', 'boxServicesFanItemType' => '1', 'boxServicesFanItemState' => '2', 'boxServicesFanSpeed' => '0', 'boxServicesFanDutyLevel' => '50', 'boxServicesFanUnitIndex' => '1', ), '1.3' => array ( 'boxServicesFansIndex' => '3', 'boxServicesFanItemType' => '1', 'boxServicesFanItemState' => '2', 'boxServicesFanSpeed' => '0', 'boxServicesFanDutyLevel' => '50', 'boxServicesFanUnitIndex' => '1', ), ) Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.4413.1.1.43.1.6.1.4.1.0, boxServicesFanSpeed.1.0, edgeswitch, Fan 1.0, snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ), rrd_type = SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","fanspeed",312,"edgeswitch","boxServicesFanSpeed.1.0"][0m 1.74ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["fanspeed",312,"edgeswitch","boxServicesFanSpeed.1.0"][0m 1.51ms] .Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.4413.1.1.43.1.6.1.4.1.1, boxServicesFanSpeed.1.1, edgeswitch, Fan 1.1, snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ), rrd_type = SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","fanspeed",312,"edgeswitch","boxServicesFanSpeed.1.1"][0m 1.43ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["fanspeed",312,"edgeswitch","boxServicesFanSpeed.1.1"][0m 1.43ms] .Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.4413.1.1.43.1.6.1.4.1.2, boxServicesFanSpeed.1.2, edgeswitch, Fan 1.2, snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ), rrd_type = SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","fanspeed",312,"edgeswitch","boxServicesFanSpeed.1.2"][0m 1.64ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["fanspeed",312,"edgeswitch","boxServicesFanSpeed.1.2"][0m 1.5ms] .Sensor fetched value: 0 Cur 0, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.4413.1.1.43.1.6.1.4.1.3, boxServicesFanSpeed.1.3, edgeswitch, Fan 1.3, snmp, 1, 1, , 0, (limits: LL: , LW: , W: , H: ), rrd_type = SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","fanspeed",312,"edgeswitch","boxServicesFanSpeed.1.3"][0m 1.26ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["fanspeed",312,"edgeswitch","boxServicesFanSpeed.1.3"][0m 1.42ms] .array ( 'edgeswitch' => array ( 'boxServicesFanSpeed.1.0' => 1, 'boxServicesFanSpeed.1.1' => 1, 'boxServicesFanSpeed.1.2' => 1, 'boxServicesFanSpeed.1.3' => 1, ), ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["fanspeed",312,"snmp"][0m 1.92ms] boxServicesFanSpeed.1.0 -> edgeswitch boxServicesFanSpeed.1.1 -> edgeswitch boxServicesFanSpeed.1.2 -> edgeswitch boxServicesFanSpeed.1.3 -> edgeswitch Frequency: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["frequency",312,"snmp"][0m 1.67ms] Humidity: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["humidity",312,"snmp"][0m 1.66ms] Load: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["load",312,"snmp"][0m 1.77ms] Loss: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["loss",312,"snmp"][0m 1.88ms] Power: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["power",312,"snmp"][0m 1.89ms] Power_consumed: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["power_consumed",312,"snmp"][0m 1.9ms] Power_factor: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["power_factor",312,"snmp"][0m 1.71ms] Runtime: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["runtime",312,"snmp"][0m 1.66ms] Signal: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["signal",312,"snmp"][0m 1.74ms] State: Dynamic Discovery (state): array ( 'data' => array ( 0 => array ( 'oid' => 'boxServicesTempUnitEntry', 'value' => 'boxServicesTempUnitState', 'num_oid' => '.1.3.6.1.4.1.4413.1.1.43.1.15.1.2.{{ $index }}', 'descr' => 'Chassis state', 'index' => 'boxServicesTempUnitState.{{ $index }}', 'states' => array ( 0 => array ( 'value' => 0, 'descr' => 'low', 'graph' => 1, 'generic' => 1, ), 1 => array ( 'value' => 1, 'descr' => 'normal', 'graph' => 1, 'generic' => 0, ), 2 => array ( 'value' => 2, 'descr' => 'warning', 'graph' => 1, 'generic' => 1, ), 3 => array ( 'value' => 3, 'descr' => 'critical', 'graph' => 1, 'generic' => 2, ), 4 => array ( 'value' => 4, 'descr' => 'shutdown', 'graph' => 1, 'generic' => 2, ), 5 => array ( 'value' => 5, 'descr' => 'notpresent', 'graph' => 1, 'generic' => 3, ), 6 => array ( 'value' => 6, 'descr' => 'notoperational', 'graph' => 1, 'generic' => 2, ), ), ), 1 => array ( 'oid' => 'boxServicesTempSensorsEntry', 'value' => 'boxServicesTempSensorState', 'num_oid' => '.1.3.6.1.4.1.4413.1.1.43.1.8.1.4.{{ $index }}', 'descr' => 'Temp Sensor {{ $index }}', 'index' => 'boxServicesTempSensorState.{{ $index }}', 'states' => array ( 0 => array ( 'value' => 0, 'descr' => 'low', 'graph' => 1, 'generic' => 1, ), 1 => array ( 'value' => 1, 'descr' => 'normal', 'graph' => 1, 'generic' => 0, ), 2 => array ( 'value' => 2, 'descr' => 'warning', 'graph' => 1, 'generic' => 1, ), 3 => array ( 'value' => 3, 'descr' => 'critical', 'graph' => 1, 'generic' => 2, ), 4 => array ( 'value' => 4, 'descr' => 'shutdown', 'graph' => 1, 'generic' => 2, ), 5 => array ( 'value' => 5, 'descr' => 'notpresent', 'graph' => 1, 'generic' => 3, ), 6 => array ( 'value' => 6, 'descr' => 'notoperational', 'graph' => 1, 'generic' => 2, ), ), ), 2 => array ( 'oid' => 'boxServicesFansEntry', 'value' => 'boxServicesFanItemState', 'num_oid' => '.1.3.6.1.4.1.4413.1.1.43.1.6.1.3.{{ $index }}', 'descr' => 'Fan {{ $index }}', 'index' => 'boxServicesFanItemState.{{ $index }}', 'states' => array ( 0 => array ( 'value' => 1, 'descr' => 'notpresent', 'graph' => 1, 'generic' => 3, ), 1 => array ( 'value' => 2, 'descr' => 'operational', 'graph' => 1, 'generic' => 0, ), 2 => array ( 'value' => 3, 'descr' => 'failed', 'graph' => 1, 'generic' => 2, ), 3 => array ( 'value' => 4, 'descr' => 'powering', 'graph' => 1, 'generic' => 0, ), 4 => array ( 'value' => 5, 'descr' => 'nopower', 'graph' => 1, 'generic' => 2, ), 5 => array ( 'value' => 6, 'descr' => 'notpowering', 'graph' => 1, 'generic' => 2, ), 6 => array ( 'value' => 7, 'descr' => 'incompatible', 'graph' => 1, 'generic' => 1, ), ), ), ), ) Data boxServicesTempUnitEntry: array ( 1 => array ( 'boxServicesTempUnitIndex' => '1', 'boxServicesTempUnitState' => '1', 'boxServicesTempUnitTemperature' => '33', ), ) Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["boxServicesTempUnitEntry"][0m 1.03ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[29][0m 1.26ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.4413.1.1.43.1.15.1.2.1, boxServicesTempUnitState.1, boxServicesTempUnitEntry, Chassis state, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ), rrd_type = SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",312,"boxServicesTempUnitEntry","boxServicesTempUnitState.1"][0m 1.36ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",312,"boxServicesTempUnitEntry","boxServicesTempUnitState.1"][0m 1.41ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",312,"boxServicesTempUnitEntry","boxServicesTempUnitState.1"][0m 1.23ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["boxServicesTempUnitEntry"][0m 0.83ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":7859,"state_index_id":29}[0m 5.79ms] Data boxServicesTempSensorsEntry: array ( '1.0' => array ( 'boxServicesUnitIndex' => '1', 'boxServicesTempSensorIndex' => '0', 'boxServicesTempSensorType' => '1', 'boxServicesTempSensorState' => '1', 'boxServicesTempSensorTemperature' => '32', ), '1.1' => array ( 'boxServicesUnitIndex' => '1', 'boxServicesTempSensorIndex' => '1', 'boxServicesTempSensorType' => '1', 'boxServicesTempSensorState' => '1', 'boxServicesTempSensorTemperature' => '19', ), '1.2' => array ( 'boxServicesUnitIndex' => '1', 'boxServicesTempSensorIndex' => '2', 'boxServicesTempSensorType' => '1', 'boxServicesTempSensorState' => '1', 'boxServicesTempSensorTemperature' => '33', ), '1.3' => array ( 'boxServicesUnitIndex' => '1', 'boxServicesTempSensorIndex' => '3', 'boxServicesTempSensorType' => '1', 'boxServicesTempSensorState' => '1', 'boxServicesTempSensorTemperature' => '29', ), '1.4' => array ( 'boxServicesUnitIndex' => '1', 'boxServicesTempSensorIndex' => '4', 'boxServicesTempSensorType' => '1', 'boxServicesTempSensorState' => '1', 'boxServicesTempSensorTemperature' => '29', ), '1.5' => array ( 'boxServicesUnitIndex' => '1', 'boxServicesTempSensorIndex' => '5', 'boxServicesTempSensorType' => '1', 'boxServicesTempSensorState' => '1', 'boxServicesTempSensorTemperature' => '31', ), '1.6' => array ( 'boxServicesUnitIndex' => '1', 'boxServicesTempSensorIndex' => '6', 'boxServicesTempSensorType' => '1', 'boxServicesTempSensorState' => '1', 'boxServicesTempSensorTemperature' => '29', ), '1.7' => array ( 'boxServicesUnitIndex' => '1', 'boxServicesTempSensorIndex' => '7', 'boxServicesTempSensorType' => '1', 'boxServicesTempSensorState' => '1', 'boxServicesTempSensorTemperature' => '29', ), ) Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["boxServicesTempSensorsEntry"][0m 1.07ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[30][0m 1.16ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.4413.1.1.43.1.8.1.4.1.0, boxServicesTempSensorState.1.0, boxServicesTempSensorsEntry, Temp Sensor 1.0, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ), rrd_type = SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",312,"boxServicesTempSensorsEntry","boxServicesTempSensorState.1.0"][0m 1.67ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",312,"boxServicesTempSensorsEntry","boxServicesTempSensorState.1.0"][0m 1.87ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",312,"boxServicesTempSensorsEntry","boxServicesTempSensorState.1.0"][0m 1.32ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["boxServicesTempSensorsEntry"][0m 0.88ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":7860,"state_index_id":30}[0m 4.75ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["boxServicesTempSensorsEntry"][0m 0.58ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[30][0m 0.71ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.4413.1.1.43.1.8.1.4.1.1, boxServicesTempSensorState.1.1, boxServicesTempSensorsEntry, Temp Sensor 1.1, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ), rrd_type = SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",312,"boxServicesTempSensorsEntry","boxServicesTempSensorState.1.1"][0m 1.41ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",312,"boxServicesTempSensorsEntry","boxServicesTempSensorState.1.1"][0m 1.56ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",312,"boxServicesTempSensorsEntry","boxServicesTempSensorState.1.1"][0m 1.31ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["boxServicesTempSensorsEntry"][0m 0.65ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":7861,"state_index_id":30}[0m 5ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["boxServicesTempSensorsEntry"][0m 0.58ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[30][0m 0.63ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.4413.1.1.43.1.8.1.4.1.2, boxServicesTempSensorState.1.2, boxServicesTempSensorsEntry, Temp Sensor 1.2, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ), rrd_type = SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",312,"boxServicesTempSensorsEntry","boxServicesTempSensorState.1.2"][0m 1.44ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",312,"boxServicesTempSensorsEntry","boxServicesTempSensorState.1.2"][0m 1.54ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",312,"boxServicesTempSensorsEntry","boxServicesTempSensorState.1.2"][0m 1.32ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["boxServicesTempSensorsEntry"][0m 0.62ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":7862,"state_index_id":30}[0m 4.69ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["boxServicesTempSensorsEntry"][0m 0.58ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[30][0m 0.67ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.4413.1.1.43.1.8.1.4.1.3, boxServicesTempSensorState.1.3, boxServicesTempSensorsEntry, Temp Sensor 1.3, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ), rrd_type = SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",312,"boxServicesTempSensorsEntry","boxServicesTempSensorState.1.3"][0m 1.43ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",312,"boxServicesTempSensorsEntry","boxServicesTempSensorState.1.3"][0m 1.54ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",312,"boxServicesTempSensorsEntry","boxServicesTempSensorState.1.3"][0m 1.34ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["boxServicesTempSensorsEntry"][0m 0.55ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":7863,"state_index_id":30}[0m 4.91ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["boxServicesTempSensorsEntry"][0m 0.58ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[30][0m 0.59ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.4413.1.1.43.1.8.1.4.1.4, boxServicesTempSensorState.1.4, boxServicesTempSensorsEntry, Temp Sensor 1.4, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ), rrd_type = SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",312,"boxServicesTempSensorsEntry","boxServicesTempSensorState.1.4"][0m 1.45ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",312,"boxServicesTempSensorsEntry","boxServicesTempSensorState.1.4"][0m 1.64ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",312,"boxServicesTempSensorsEntry","boxServicesTempSensorState.1.4"][0m 1.4ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["boxServicesTempSensorsEntry"][0m 0.56ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":7864,"state_index_id":30}[0m 5.46ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["boxServicesTempSensorsEntry"][0m 0.6ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[30][0m 0.66ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.4413.1.1.43.1.8.1.4.1.5, boxServicesTempSensorState.1.5, boxServicesTempSensorsEntry, Temp Sensor 1.5, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ), rrd_type = SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",312,"boxServicesTempSensorsEntry","boxServicesTempSensorState.1.5"][0m 1.51ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",312,"boxServicesTempSensorsEntry","boxServicesTempSensorState.1.5"][0m 1.65ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",312,"boxServicesTempSensorsEntry","boxServicesTempSensorState.1.5"][0m 1.57ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["boxServicesTempSensorsEntry"][0m 0.61ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":7865,"state_index_id":30}[0m 5.08ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["boxServicesTempSensorsEntry"][0m 0.58ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[30][0m 0.6ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.4413.1.1.43.1.8.1.4.1.6, boxServicesTempSensorState.1.6, boxServicesTempSensorsEntry, Temp Sensor 1.6, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ), rrd_type = SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",312,"boxServicesTempSensorsEntry","boxServicesTempSensorState.1.6"][0m 1.39ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",312,"boxServicesTempSensorsEntry","boxServicesTempSensorState.1.6"][0m 1.55ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",312,"boxServicesTempSensorsEntry","boxServicesTempSensorState.1.6"][0m 1.3ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["boxServicesTempSensorsEntry"][0m 0.61ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":7866,"state_index_id":30}[0m 5.14ms] Sensor fetched value: 1 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["boxServicesTempSensorsEntry"][0m 0.58ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[30][0m 0.75ms] Cur 1, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.4413.1.1.43.1.8.1.4.1.7, boxServicesTempSensorState.1.7, boxServicesTempSensorsEntry, Temp Sensor 1.7, snmp, 1, 1, , 1, (limits: LL: , LW: , W: , H: ), rrd_type = SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",312,"boxServicesTempSensorsEntry","boxServicesTempSensorState.1.7"][0m 1.39ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",312,"boxServicesTempSensorsEntry","boxServicesTempSensorState.1.7"][0m 1.56ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",312,"boxServicesTempSensorsEntry","boxServicesTempSensorState.1.7"][0m 1.37ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["boxServicesTempSensorsEntry"][0m 0.6ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":7867,"state_index_id":30}[0m 5.45ms] Data boxServicesFansEntry: array ( '1.0' => array ( 'boxServicesFansIndex' => '0', 'boxServicesFanItemType' => '1', 'boxServicesFanItemState' => '2', 'boxServicesFanSpeed' => '0', 'boxServicesFanDutyLevel' => '50', 'boxServicesFanUnitIndex' => '1', ), '1.1' => array ( 'boxServicesFansIndex' => '1', 'boxServicesFanItemType' => '1', 'boxServicesFanItemState' => '2', 'boxServicesFanSpeed' => '0', 'boxServicesFanDutyLevel' => '50', 'boxServicesFanUnitIndex' => '1', ), '1.2' => array ( 'boxServicesFansIndex' => '2', 'boxServicesFanItemType' => '1', 'boxServicesFanItemState' => '2', 'boxServicesFanSpeed' => '0', 'boxServicesFanDutyLevel' => '50', 'boxServicesFanUnitIndex' => '1', ), '1.3' => array ( 'boxServicesFansIndex' => '3', 'boxServicesFanItemType' => '1', 'boxServicesFanItemState' => '2', 'boxServicesFanSpeed' => '0', 'boxServicesFanDutyLevel' => '50', 'boxServicesFanUnitIndex' => '1', ), ) Sensor fetched value: 2 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["boxServicesFansEntry"][0m 0.9ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[31][0m 1.05ms] Cur 2, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.4413.1.1.43.1.6.1.3.1.0, boxServicesFanItemState.1.0, boxServicesFansEntry, Fan 1.0, snmp, 1, 1, , 2, (limits: LL: , LW: , W: , H: ), rrd_type = SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",312,"boxServicesFansEntry","boxServicesFanItemState.1.0"][0m 1.37ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",312,"boxServicesFansEntry","boxServicesFanItemState.1.0"][0m 1.44ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",312,"boxServicesFansEntry","boxServicesFanItemState.1.0"][0m 1.39ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["boxServicesFansEntry"][0m 0.83ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":7868,"state_index_id":31}[0m 5.24ms] Sensor fetched value: 2 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["boxServicesFansEntry"][0m 0.64ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[31][0m 0.64ms] Cur 2, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.4413.1.1.43.1.6.1.3.1.1, boxServicesFanItemState.1.1, boxServicesFansEntry, Fan 1.1, snmp, 1, 1, , 2, (limits: LL: , LW: , W: , H: ), rrd_type = SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",312,"boxServicesFansEntry","boxServicesFanItemState.1.1"][0m 1.37ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",312,"boxServicesFansEntry","boxServicesFanItemState.1.1"][0m 1.46ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",312,"boxServicesFansEntry","boxServicesFanItemState.1.1"][0m 1.28ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["boxServicesFansEntry"][0m 0.63ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":7869,"state_index_id":31}[0m 5.16ms] Sensor fetched value: 2 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["boxServicesFansEntry"][0m 0.63ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[31][0m 0.64ms] Cur 2, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.4413.1.1.43.1.6.1.3.1.2, boxServicesFanItemState.1.2, boxServicesFansEntry, Fan 1.2, snmp, 1, 1, , 2, (limits: LL: , LW: , W: , H: ), rrd_type = SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",312,"boxServicesFansEntry","boxServicesFanItemState.1.2"][0m 1.38ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",312,"boxServicesFansEntry","boxServicesFanItemState.1.2"][0m 1.47ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",312,"boxServicesFansEntry","boxServicesFanItemState.1.2"][0m 1.3ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["boxServicesFansEntry"][0m 0.64ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":7870,"state_index_id":31}[0m 5.53ms] Sensor fetched value: 2 SQL[[1;33mSELECT `state_index_id` FROM state_indexes WHERE state_name = ? LIMIT 1 [0;33m["boxServicesFansEntry"][0m 0.63ms] SQL[[1;33mSELECT `state_index_id`,`state_descr`,`state_draw_graph`,`state_value`,`state_generic_value` FROM `state_translations` WHERE `state_index_id`=? [0;33m[31][0m 0.64ms] Cur 2, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.4413.1.1.43.1.6.1.3.1.3, boxServicesFanItemState.1.3, boxServicesFansEntry, Fan 1.3, snmp, 1, 1, , 2, (limits: LL: , LW: , W: , H: ), rrd_type = SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","state",312,"boxServicesFansEntry","boxServicesFanItemState.1.3"][0m 1.37ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",312,"boxServicesFansEntry","boxServicesFanItemState.1.3"][0m 1.64ms] .SQL[[1;33mSELECT sensor_id FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["state",312,"boxServicesFansEntry","boxServicesFanItemState.1.3"][0m 1.29ms] SQL[[1;33mSELECT state_index_id FROM `state_indexes` WHERE `state_name` = ? [0;33m["boxServicesFansEntry"][0m 0.6ms] SQL[[1;33mINSERT IGNORE INTO `sensors_to_state_indexes` (`sensor_id`,`state_index_id`) VALUES (:sensor_id,:state_index_id) [0;33m{"sensor_id":7871,"state_index_id":31}[0m 5.27ms] array ( 'boxServicesTempUnitEntry' => array ( 'boxServicesTempUnitState.1' => 1, ), 'boxServicesTempSensorsEntry' => array ( 'boxServicesTempSensorState.1.0' => 1, 'boxServicesTempSensorState.1.1' => 1, 'boxServicesTempSensorState.1.2' => 1, 'boxServicesTempSensorState.1.3' => 1, 'boxServicesTempSensorState.1.4' => 1, 'boxServicesTempSensorState.1.5' => 1, 'boxServicesTempSensorState.1.6' => 1, 'boxServicesTempSensorState.1.7' => 1, ), 'boxServicesFansEntry' => array ( 'boxServicesFanItemState.1.0' => 1, 'boxServicesFanItemState.1.1' => 1, 'boxServicesFanItemState.1.2' => 1, 'boxServicesFanItemState.1.3' => 1, ), ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["state",312,"snmp"][0m 2.49ms] boxServicesTempUnitState.1 -> boxServicesTempUnitEntry boxServicesTempSensorState.1.0 -> boxServicesTempSensorsEntry boxServicesTempSensorState.1.1 -> boxServicesTempSensorsEntry boxServicesTempSensorState.1.2 -> boxServicesTempSensorsEntry boxServicesTempSensorState.1.3 -> boxServicesTempSensorsEntry boxServicesTempSensorState.1.4 -> boxServicesTempSensorsEntry boxServicesTempSensorState.1.5 -> boxServicesTempSensorsEntry boxServicesTempSensorState.1.6 -> boxServicesTempSensorsEntry boxServicesTempSensorState.1.7 -> boxServicesTempSensorsEntry boxServicesFanItemState.1.0 -> boxServicesFansEntry boxServicesFanItemState.1.1 -> boxServicesFansEntry boxServicesFanItemState.1.2 -> boxServicesFansEntry boxServicesFanItemState.1.3 -> boxServicesFansEntry Count: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["count",312,"snmp"][0m 1.97ms] Temperature: Dynamic Discovery (temperature): array ( 'data' => array ( 0 => array ( 'oid' => 'boxServicesTempSensorsEntry', 'value' => 'boxServicesTempSensorTemperature', 'num_oid' => '.1.3.6.1.4.1.4413.1.1.43.1.8.1.5.{{ $index }}', 'index' => 'boxServicesTempSensorTemperature.{{ $index }}', 'descr' => 'Temperature {{ $index }}', ), ), ) Data boxServicesTempSensorsEntry: array ( '1.0' => array ( 'boxServicesUnitIndex' => '1', 'boxServicesTempSensorIndex' => '0', 'boxServicesTempSensorType' => '1', 'boxServicesTempSensorState' => '1', 'boxServicesTempSensorTemperature' => '32', ), '1.1' => array ( 'boxServicesUnitIndex' => '1', 'boxServicesTempSensorIndex' => '1', 'boxServicesTempSensorType' => '1', 'boxServicesTempSensorState' => '1', 'boxServicesTempSensorTemperature' => '19', ), '1.2' => array ( 'boxServicesUnitIndex' => '1', 'boxServicesTempSensorIndex' => '2', 'boxServicesTempSensorType' => '1', 'boxServicesTempSensorState' => '1', 'boxServicesTempSensorTemperature' => '33', ), '1.3' => array ( 'boxServicesUnitIndex' => '1', 'boxServicesTempSensorIndex' => '3', 'boxServicesTempSensorType' => '1', 'boxServicesTempSensorState' => '1', 'boxServicesTempSensorTemperature' => '29', ), '1.4' => array ( 'boxServicesUnitIndex' => '1', 'boxServicesTempSensorIndex' => '4', 'boxServicesTempSensorType' => '1', 'boxServicesTempSensorState' => '1', 'boxServicesTempSensorTemperature' => '29', ), '1.5' => array ( 'boxServicesUnitIndex' => '1', 'boxServicesTempSensorIndex' => '5', 'boxServicesTempSensorType' => '1', 'boxServicesTempSensorState' => '1', 'boxServicesTempSensorTemperature' => '31', ), '1.6' => array ( 'boxServicesUnitIndex' => '1', 'boxServicesTempSensorIndex' => '6', 'boxServicesTempSensorType' => '1', 'boxServicesTempSensorState' => '1', 'boxServicesTempSensorTemperature' => '29', ), '1.7' => array ( 'boxServicesUnitIndex' => '1', 'boxServicesTempSensorIndex' => '7', 'boxServicesTempSensorType' => '1', 'boxServicesTempSensorState' => '1', 'boxServicesTempSensorTemperature' => '29', ), ) Sensor fetched value: 32 Cur 32, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.4413.1.1.43.1.8.1.5.1.0, boxServicesTempSensorTemperature.1.0, edgeswitch, Temperature 1.0, snmp, 1, 1, , 32, (limits: LL: , LW: , W: , H: ), rrd_type = SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","temperature",312,"edgeswitch","boxServicesTempSensorTemperature.1.0"][0m 1.49ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["temperature",312,"edgeswitch","boxServicesTempSensorTemperature.1.0"][0m 1.62ms] .Sensor fetched value: 19 Cur 19, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.4413.1.1.43.1.8.1.5.1.1, boxServicesTempSensorTemperature.1.1, edgeswitch, Temperature 1.1, snmp, 1, 1, , 19, (limits: LL: , LW: , W: , H: ), rrd_type = SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","temperature",312,"edgeswitch","boxServicesTempSensorTemperature.1.1"][0m 1.45ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["temperature",312,"edgeswitch","boxServicesTempSensorTemperature.1.1"][0m 1.75ms] .Sensor fetched value: 33 Cur 33, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.4413.1.1.43.1.8.1.5.1.2, boxServicesTempSensorTemperature.1.2, edgeswitch, Temperature 1.2, snmp, 1, 1, , 33, (limits: LL: , LW: , W: , H: ), rrd_type = SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","temperature",312,"edgeswitch","boxServicesTempSensorTemperature.1.2"][0m 1.39ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["temperature",312,"edgeswitch","boxServicesTempSensorTemperature.1.2"][0m 1.68ms] .Sensor fetched value: 29 Cur 29, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.4413.1.1.43.1.8.1.5.1.3, boxServicesTempSensorTemperature.1.3, edgeswitch, Temperature 1.3, snmp, 1, 1, , 29, (limits: LL: , LW: , W: , H: ), rrd_type = SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","temperature",312,"edgeswitch","boxServicesTempSensorTemperature.1.3"][0m 1.46ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["temperature",312,"edgeswitch","boxServicesTempSensorTemperature.1.3"][0m 1.59ms] .Sensor fetched value: 29 Cur 29, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.4413.1.1.43.1.8.1.5.1.4, boxServicesTempSensorTemperature.1.4, edgeswitch, Temperature 1.4, snmp, 1, 1, , 29, (limits: LL: , LW: , W: , H: ), rrd_type = SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","temperature",312,"edgeswitch","boxServicesTempSensorTemperature.1.4"][0m 1.45ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["temperature",312,"edgeswitch","boxServicesTempSensorTemperature.1.4"][0m 1.55ms] .Sensor fetched value: 31 Cur 31, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.4413.1.1.43.1.8.1.5.1.5, boxServicesTempSensorTemperature.1.5, edgeswitch, Temperature 1.5, snmp, 1, 1, , 31, (limits: LL: , LW: , W: , H: ), rrd_type = SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","temperature",312,"edgeswitch","boxServicesTempSensorTemperature.1.5"][0m 1.44ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["temperature",312,"edgeswitch","boxServicesTempSensorTemperature.1.5"][0m 1.65ms] .Sensor fetched value: 29 Cur 29, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.4413.1.1.43.1.8.1.5.1.6, boxServicesTempSensorTemperature.1.6, edgeswitch, Temperature 1.6, snmp, 1, 1, , 29, (limits: LL: , LW: , W: , H: ), rrd_type = SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","temperature",312,"edgeswitch","boxServicesTempSensorTemperature.1.6"][0m 1.4ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["temperature",312,"edgeswitch","boxServicesTempSensorTemperature.1.6"][0m 1.6ms] .Sensor fetched value: 29 Cur 29, Low: null, Low Warn: null, Warn: null, High: null Discover sensor: .1.3.6.1.4.1.4413.1.1.43.1.8.1.5.1.7, boxServicesTempSensorTemperature.1.7, edgeswitch, Temperature 1.7, snmp, 1, 1, , 29, (limits: LL: , LW: , W: , H: ), rrd_type = SQL[[1;33mSELECT COUNT(sensor_id) FROM `sensors` WHERE `poller_type`= ? AND `sensor_class` = ? AND `device_id` = ? AND sensor_type = ? AND `sensor_index` = ? [0;33m["snmp","temperature",312,"edgeswitch","boxServicesTempSensorTemperature.1.7"][0m 1.4ms] SQL[[1;33mSELECT * FROM `sensors` WHERE `sensor_class` = ? AND `device_id` = ? AND `sensor_type` = ? AND `sensor_index` = ? [0;33m["temperature",312,"edgeswitch","boxServicesTempSensorTemperature.1.7"][0m 1.57ms] .array ( 'edgeswitch' => array ( 'boxServicesTempSensorTemperature.1.0' => 1, 'boxServicesTempSensorTemperature.1.1' => 1, 'boxServicesTempSensorTemperature.1.2' => 1, 'boxServicesTempSensorTemperature.1.3' => 1, 'boxServicesTempSensorTemperature.1.4' => 1, 'boxServicesTempSensorTemperature.1.5' => 1, 'boxServicesTempSensorTemperature.1.6' => 1, 'boxServicesTempSensorTemperature.1.7' => 1, ), ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["temperature",312,"snmp"][0m 2.02ms] boxServicesTempSensorTemperature.1.0 -> edgeswitch boxServicesTempSensorTemperature.1.1 -> edgeswitch boxServicesTempSensorTemperature.1.2 -> edgeswitch boxServicesTempSensorTemperature.1.3 -> edgeswitch boxServicesTempSensorTemperature.1.4 -> edgeswitch boxServicesTempSensorTemperature.1.5 -> edgeswitch boxServicesTempSensorTemperature.1.6 -> edgeswitch boxServicesTempSensorTemperature.1.7 -> edgeswitch Tv_signal: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["tv_signal",312,"snmp"][0m 1.69ms] Bitrate: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["bitrate",312,"snmp"][0m 1.63ms] Voltage: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["voltage",312,"snmp"][0m 1.98ms] Snr: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["snr",312,"snmp"][0m 1.65ms] Pressure: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["pressure",312,"snmp"][0m 1.61ms] Cooling: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["cooling",312,"snmp"][0m 1.63ms] Delay: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["delay",312,"snmp"][0m 1.67ms] Quality_factor: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["quality_factor",312,"snmp"][0m 1.59ms] Chromatic_dispersion: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["chromatic_dispersion",312,"snmp"][0m 1.62ms] Ber: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["ber",312,"snmp"][0m 1.68ms] Eer: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["eer",312,"snmp"][0m 1.63ms] Waterflow: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["waterflow",312,"snmp"][0m 1.65ms] Percent: array ( ) SQL[[1;33mSELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class=? AND S.device_id = D.device_id AND D.device_id = ? AND S.poller_type = ? [0;33m["percent",312,"snmp"][0m 1.65ms] >> Runtime for discovery module 'sensors': 0.6820 seconds with 10624 bytes >> [0;36mSNMP[0m: [8/0.30s] [1;33mMySQL[0m: [149/2.49s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module sensors #### Modules status: Global+ OS- Device Module [ storage ] disabled on os. Modules status: Global+ OS Device #### Load disco module hr-device #### SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'hrDeviceTable'[0m] hrDeviceTable = No Such Object available on this agent at this OID Invalid snmp_walk() data = hrDeviceTable = No Such Object available on this agent at this OID SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'hrProcessorTable'[0m] hrProcessorTable = No Such Object available on this agent at this OID Invalid snmp_walk() data = hrProcessorTable = No Such Object available on this agent at this OID array ( ) SQL[[1;33mSELECT * FROM `hrDevice` WHERE `device_id` = '312' [0;33m[][0m 1.34ms] >> Runtime for discovery module 'hr-device': 0.0810 seconds with 816 bytes >> [0;36mSNMP[0m: [2/0.08s] [1;33mMySQL[0m: [1/0.01s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module hr-device #### Modules status: Global- OS+ Device+ #### Load disco module discovery-protocols #### CISCO-CDP-MIB: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUsetX' '-m' 'CISCO-CDP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'cdpCache'[0m] Exitcode: 1 MIB search path: /opt/librenms/mibs:/opt/librenms/mibs/edgeswitch Cannot find module (CISCO-CDP-MIB): At line 1 in (none) cdpCache: Unknown Object Identifier (Sub-id not found: (top) -> cdpCache) MIB search path: /opt/librenms/mibs:/opt/librenms/mibs/edgeswitch Cannot find module (CISCO-CDP-MIB): At line 1 in (none) cdpCache: Unknown Object Identifier (Sub-id not found: (top) -> cdpCache) LLDP-MIB: SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUsetX' '-m' 'LLDP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'lldpRemTable'[0m] lldpRemChassisIdSubtype[67][1][1] = 7 lldpRemChassisId[67][1][1] = "E7-2:SN81101310031" lldpRemPortIdSubtype[67][1][1] = 7 lldpRemPortId[67][1][1] = "1/g1" lldpRemPortDesc[67][1][1] = RTA LAN lldpRemSysName[67][1][1] = KETN-CAL-E7-01 lldpRemSysDesc[67][1][1] = Kensington lldpRemSysCapSupported[67][1][1] = "00 20 " lldpRemSysCapEnabled[67][1][1] = "00 20 " SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQun' '-m' 'LLDP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' '.1.0.8802.1.1.2.1.4.2.1.3'[0m] .1.0.88*.*.3 = No Such Instance currently exists at this OID Invalid snmp_walk() data = .1.0.8802.1.1.2.1.4.2.1.3 = No Such Instance currently exists at this OID SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUsetX' '-m' 'BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'dot1dBasePortIfIndex'[0m] dot1dBasePortIfIndex[1] = 1 dot1dBasePortIfIndex[2] = 2 dot1dBasePortIfIndex[3] = 3 dot1dBasePortIfIndex[4] = 4 dot1dBasePortIfIndex[5] = 5 dot1dBasePortIfIndex[6] = 6 dot1dBasePortIfIndex[7] = 7 dot1dBasePortIfIndex[8] = 8 dot1dBasePortIfIndex[9] = 9 dot1dBasePortIfIndex[10] = 10 dot1dBasePortIfIndex[11] = 11 dot1dBasePortIfIndex[12] = 12 dot1dBasePortIfIndex[13] = 13 dot1dBasePortIfIndex[14] = 14 dot1dBasePortIfIndex[15] = 15 dot1dBasePortIfIndex[16] = 16 dot1dBasePortIfIndex[17] = 17 dot1dBasePortIfIndex[18] = 18 dot1dBasePortIfIndex[19] = 19 dot1dBasePortIfIndex[20] = 20 dot1dBasePortIfIndex[21] = 21 dot1dBasePortIfIndex[22] = 22 dot1dBasePortIfIndex[23] = 23 dot1dBasePortIfIndex[24] = 24 dot1dBasePortIfIndex[25] = 25 dot1dBasePortIfIndex[26] = 26 dot1dBasePortIfIndex[66] = 66 dot1dBasePortIfIndex[67] = 67 dot1dBasePortIfIndex[68] = 68 dot1dBasePortIfIndex[69] = 69 dot1dBasePortIfIndex[70] = 70 dot1dBasePortIfIndex[71] = 71 dot1dBasePortIfIndex[72] = 72 dot1dBasePortIfIndex[73] = 73 dot1dBasePortIfIndex[74] = 74 dot1dBasePortIfIndex[75] = 75 dot1dBasePortIfIndex[76] = 76 dot1dBasePortIfIndex[77] = 77 dot1dBasePortIfIndex[78] = 78 dot1dBasePortIfIndex[79] = 79 dot1dBasePortIfIndex[80] = 80 dot1dBasePortIfIndex[81] = 81 SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUsetX' '-m' 'LLDP-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'lldpLocPortId'[0m] lldpLocPortId[1] = "Port 1" lldpLocPortId[2] = "Port 2" lldpLocPortId[3] = "Port 3" lldpLocPortId[4] = "Port 4" lldpLocPortId[5] = "Port 5" lldpLocPortId[6] = "Port 6" lldpLocPortId[7] = "Port 7" lldpLocPortId[8] = "Port 8" lldpLocPortId[9] = "Port 9" lldpLocPortId[10] = "Port 10" lldpLocPortId[11] = "Port 11" lldpLocPortId[12] = "Port 12" lldpLocPortId[13] = "Port 13" lldpLocPortId[14] = "Port 14" lldpLocPortId[15] = "Port 15" lldpLocPortId[16] = "Port 16" lldpLocPortId[17] = "Port 17" lldpLocPortId[18] = "Port 18" lldpLocPortId[19] = "Port 19" lldpLocPortId[20] = "Port 20" lldpLocPortId[21] = "Port 21" lldpLocPortId[22] = "Port 22" lldpLocPortId[23] = "Port 23" lldpLocPortId[24] = "Port 24" lldpLocPortId[25] = "Port 25" lldpLocPortId[26] = "Port 26" SQL[[1;33mSELECT * FROM (SELECT `port_id` FROM `ports` WHERE `device_id`=? AND (`ifDescr`=? OR `ifName`=?) UNION SELECT `port_id` FROM `ports` WHERE `device_id`=? AND (`ifIndex`=? OR `ifAlias`=?) UNION SELECT `port_id` FROM `ports` WHERE `device_id`=? AND `ifAlias`=? LIMIT 1) p [0;33m[312,"Port 1","Port 1",312,"1","1",312,"Port 1"][0m 3.11ms] SQL[[1;33mSELECT * FROM `ports` WHERE `port_id` = ? [0;33m[0][0m 1.4ms] array ( 1 => array ( 'lldpRemChassisIdSubtype' => '7', 'lldpRemChassisId' => 'E7-2:SN81101310031', 'lldpRemPortIdSubtype' => '7', 'lldpRemPortId' => '1/g1', 'lldpRemPortDesc' => 'RTA LAN', 'lldpRemSysName' => 'KETN-CAL-E7-01', 'lldpRemSysDesc' => 'Kensington', 'lldpRemSysCapSupported' => '00 20', 'lldpRemSysCapEnabled' => '00 20', ), ) SQL[[1;33mSELECT `device_id` FROM `devices` WHERE `hostname`=? [0;33m["KETN-CAL-E7-01"][0m 0.96ms] SQL[[1;33mSELECT `device_id` FROM `devices` WHERE `sysName`=? LIMIT 2 [0;33m["KETN-CAL-E7-01"][0m 1.04ms] SQL[[1;33mselect * from `devices` where `device_id` = ? limit 1 [0;33m[126][0m 1.55ms] SQL[[1;33mselect * from `locations` where `locations`.`id` = ? limit 1 [0;33m[12][0m 0.74ms] SQL[[1;33mselect * from `devices_attribs` where `devices_attribs`.`device_id` = ? and `devices_attribs`.`device_id` is not null [0;33m[126][0m 1.09ms] SQL[[1;33mSELECT * FROM (SELECT `port_id` FROM `ports` WHERE `device_id`=? AND (`ifDescr`=? OR `ifName`=?) UNION SELECT `port_id` FROM `ports` WHERE `device_id`=? AND (`ifDescr`=? OR `ifName`=?) UNION SELECT `port_id` FROM `ports` WHERE `device_id`=? AND `ifAlias`=? LIMIT 1) p [0;33m[126,"RTA LAN","RTA LAN",126,"1\/g1","1\/g1",126,"RTA LAN"][0m 2.52ms] OSPF Discovery: SQL[[1;33mSELECT DISTINCT(`ospfNbrIpAddr`),`device_id` FROM `ospf_nbrs` WHERE `device_id`=? [0;33m[312][0m 1.26ms] SQL[[1;33mSELECT * FROM `links` AS L, `ports` AS I WHERE L.local_port_id = I.port_id AND I.device_id = ? [0;33m[312][0m 1.71ms] SQL[[1;33mDELETE T FROM `links` T LEFT JOIN `devices` ON `devices`.`device_id` = T.`local_device_id` WHERE `devices`.`device_id` IS NULL [0;33m[][0m 2.6ms] 0 orphaned links deleted >> Runtime for discovery module 'discovery-protocols': 0.2870 seconds with 191408 bytes >> [0;36mSNMP[0m: [1/0.05s] [1;33mMySQL[0m: [11/0.18s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module discovery-protocols #### Modules status: Global- OS+ Device+ #### Load disco module arp-table #### SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUsetX' '-m' 'EdgeSwitch-SWITCHING-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'agentDynamicDsBindingTable'[0m] agentDynamicDsBindingIfIndex[0:d0:2d:dc:73:f7] = 24 agentDynamicDsBindingIfIndex[0:d0:2d:dc:a3:1f] = 24 agentDynamicDsBindingIfIndex[6a:5f:17:1f:6f:82] = 1 agentDynamicDsBindingIfIndex[dc:9f:db:40:fb:74] = 23 agentDynamicDsBindingVlanId[0:d0:2d:dc:73:f7] = 1 agentDynamicDsBindingVlanId[0:d0:2d:dc:a3:1f] = 1 agentDynamicDsBindingVlanId[6a:5f:17:1f:6f:82] = 1 agentDynamicDsBindingVlanId[dc:9f:db:40:fb:74] = 1 agentDynamicDsBindingMacAddr[0:d0:2d:dc:73:f7] = 0:d0:2d:dc:73:f7 agentDynamicDsBindingMacAddr[0:d0:2d:dc:a3:1f] = 0:d0:2d:dc:a3:1f agentDynamicDsBindingMacAddr[6a:5f:17:1f:6f:82] = 6a:5f:17:1f:6f:82 agentDynamicDsBindingMacAddr[dc:9f:db:40:fb:74] = dc:9f:db:40:fb:74 agentDynamicDsBindingIpAddr[0:d0:2d:dc:73:f7] = * agentDynamicDsBindingIpAddr[0:d0:2d:dc:a3:1f] = * agentDynamicDsBindingIpAddr[6a:5f:17:1f:6f:82] = * agentDynamicDsBindingIpAddr[dc:9f:db:40:fb:74] = * agentDynamicDsBindingLeaseRemainingTime[0:d0:2d:dc:73:f7] = 664500 agentDynamicDsBindingLeaseRemainingTime[0:d0:2d:dc:a3:1f] = 665200 agentDynamicDsBindingLeaseRemainingTime[6a:5f:17:1f:6f:82] = 662100 agentDynamicDsBindingLeaseRemainingTime[dc:9f:db:40:fb:74] = 570500 SQL[[1;33mSELECT * from `ipv4_mac` WHERE `device_id`=? AND `context_name`=? [0;33m[312,""][0m 10.34ms] SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,24][0m 1.36ms] : SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,1][0m 1.36ms] : SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,23][0m 1.25ms] : SQL[[1;33mDELETE T FROM `ipv4_mac` T LEFT JOIN `ports` ON `ports`.`port_id` = T.`port_id` LEFT JOIN `devices` ON `devices`.`device_id` = T.`device_id` WHERE `ports`.`port_id` IS NULL AND `devices`.`device_id` IS NULL [0;33m[][0m 16.99ms] >> Runtime for discovery module 'arp-table': 0.1140 seconds with 6560 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [5/0.31s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module arp-table #### Modules status: Global- OS Device+ #### Load disco module discovery-arp #### SQL[[1;33m SELECT * FROM ipv4_mac as m, ports as i WHERE m.port_id = i.port_id AND i.device_id = ? AND i.deleted = 0 AND NOT EXISTS ( SELECT * FROM ipv4_addresses a WHERE a.ipv4_address = m.ipv4_address ) GROUP BY ipv4_address ORDER BY ipv4_address [0;33m[312][0m 2.02ms] >> Runtime for discovery module 'discovery-arp': 0.0030 seconds with 656 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [1/0.02s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module discovery-arp #### Modules status: Global- OS Device+ #### Load disco module junose-atm-vp #### >> Runtime for discovery module 'junose-atm-vp': 0.0000 seconds with 624 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module junose-atm-vp #### Modules status: Global- OS Device+ #### Load disco module bgp-peers #### >> Runtime for discovery module 'bgp-peers': 0.0010 seconds with 3008 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module bgp-peers #### Modules status: Global+ OS+ Device #### Load disco module vlans #### SQL[[1;33mSELECT * FROM `vlans` WHERE `device_id` = ? [0;33m[312][0m 1.3ms] SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'dot1dBasePortIfIndex'[0m] dot1dBasePortIfIndex.1 = 1 dot1dBasePortIfIndex.2 = 2 dot1dBasePortIfIndex.3 = 3 dot1dBasePortIfIndex.4 = 4 dot1dBasePortIfIndex.5 = 5 dot1dBasePortIfIndex.6 = 6 dot1dBasePortIfIndex.7 = 7 dot1dBasePortIfIndex.8 = 8 dot1dBasePortIfIndex.9 = 9 dot1dBasePortIfIndex.10 = 10 dot1dBasePortIfIndex.11 = 11 dot1dBasePortIfIndex.12 = 12 dot1dBasePortIfIndex.13 = 13 dot1dBasePortIfIndex.14 = 14 dot1dBasePortIfIndex.15 = 15 dot1dBasePortIfIndex.16 = 16 dot1dBasePortIfIndex.17 = 17 dot1dBasePortIfIndex.18 = 18 dot1dBasePortIfIndex.19 = 19 dot1dBasePortIfIndex.20 = 20 dot1dBasePortIfIndex.21 = 21 dot1dBasePortIfIndex.22 = 22 dot1dBasePortIfIndex.23 = 23 dot1dBasePortIfIndex.24 = 24 dot1dBasePortIfIndex.25 = 25 dot1dBasePortIfIndex.26 = 26 dot1dBasePortIfIndex.66 = 66 dot1dBasePortIfIndex.67 = 67 dot1dBasePortIfIndex.68 = 68 dot1dBasePortIfIndex.69 = 69 dot1dBasePortIfIndex.70 = 70 dot1dBasePortIfIndex.71 = 71 dot1dBasePortIfIndex.72 = 72 dot1dBasePortIfIndex.73 = 73 dot1dBasePortIfIndex.74 = 74 dot1dBasePortIfIndex.75 = 75 dot1dBasePortIfIndex.76 = 76 dot1dBasePortIfIndex.77 = 77 dot1dBasePortIfIndex.78 = 78 dot1dBasePortIfIndex.79 = 79 dot1dBasePortIfIndex.80 = 80 dot1dBasePortIfIndex.81 = 81 IEEE8021-Q-BRIDGE-MIB VLANs: SNMP[[0;36m'/usr/bin/snmpget' '-v2c' '-c' 'COMMUNITY' '-Oqv' '-m' 'IEEE8021-Q-BRIDGE-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'dot1qVlanVersionNumber.0'[0m] version1 ver version1 SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'Q-BRIDGE-MIB::dot1qVlanCurrentUntaggedPorts'[0m] Q-BRIDGE-MIB::dot1qVlanCurrentUntaggedPorts[0][1] = "FF FF FF C0 00 00 00 00 00 03 80 00 00 " Q-BRIDGE-MIB::dot1qVlanCurrentUntaggedPorts[0][25] = "00 00 00 00 00 00 00 00 00 00 00 00 00 " Q-BRIDGE-MIB::dot1qVlanCurrentUntaggedPorts[0][200] = "00 00 00 00 00 00 00 00 00 00 00 00 00 " SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'Q-BRIDGE-MIB::dot1qVlanCurrentEgressPorts'[0m] Q-BRIDGE-MIB::dot1qVlanCurrentEgressPorts[0][1] = "FF FF FF C0 00 00 00 00 00 03 80 00 00 " Q-BRIDGE-MIB::dot1qVlanCurrentEgressPorts[0][25] = "FF FF FF C0 00 00 00 00 00 00 00 00 00 " Q-BRIDGE-MIB::dot1qVlanCurrentEgressPorts[0][200] = "FF FF FF C0 00 00 00 00 00 00 00 00 00 " SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'Q-BRIDGE-MIB::dot1qVlanStaticName'[0m] Q-BRIDGE-MIB::dot1qVlanStaticName[1] = default Q-BRIDGE-MIB::dot1qVlanStaticName[25] = VLAN0025 Q-BRIDGE-MIB::dot1qVlanStaticName[200] = VLAN0200 Processing vlan ID: 1 SQL[[1;33mselect * from `vlans` where (`device_id` = ? and `vlan_vlan` = ?) limit 1 [0;33m[312,1][0m 2.06ms] Processing vlan ID: 25 SQL[[1;33mselect * from `vlans` where (`device_id` = ? and `vlan_vlan` = ?) limit 1 [0;33m[312,25][0m 1.07ms] Processing vlan ID: 200 SQL[[1;33mselect * from `vlans` where (`device_id` = ? and `vlan_vlan` = ?) limit 1 [0;33m[312,200][0m 1.4ms] VLAN 1 dot1d id ifIndex Port Name Priority State Cost SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,1][0m 1.13ms] 1 1 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,1][0m 0.99ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":1,"baseport":1,"priority":0,"state":"unknown","cost":0,"untagged":1}[0m 6.33ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,2][0m 1.39ms] 2 2 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,1][0m 0.73ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":1,"baseport":2,"priority":0,"state":"unknown","cost":0,"untagged":1}[0m 5.12ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,3][0m 1.29ms] 3 3 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,1][0m 0.66ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":1,"baseport":3,"priority":0,"state":"unknown","cost":0,"untagged":1}[0m 5.09ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,4][0m 1.35ms] 4 4 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,1][0m 0.66ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":1,"baseport":4,"priority":0,"state":"unknown","cost":0,"untagged":1}[0m 9.11ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,5][0m 1.32ms] 5 5 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,1][0m 0.65ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":1,"baseport":5,"priority":0,"state":"unknown","cost":0,"untagged":1}[0m 5.42ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,6][0m 1.27ms] 6 6 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,1][0m 0.65ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":1,"baseport":6,"priority":0,"state":"unknown","cost":0,"untagged":1}[0m 4.91ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,7][0m 1.38ms] 7 7 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,1][0m 0.86ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":1,"baseport":7,"priority":0,"state":"unknown","cost":0,"untagged":1}[0m 5.62ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,8][0m 1.37ms] 8 8 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,1][0m 0.61ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":1,"baseport":8,"priority":0,"state":"unknown","cost":0,"untagged":1}[0m 5ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,9][0m 1.25ms] 9 9 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,1][0m 0.73ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":1,"baseport":9,"priority":0,"state":"unknown","cost":0,"untagged":1}[0m 5.05ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,10][0m 1.4ms] 10 10 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,1][0m 0.71ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":1,"baseport":10,"priority":0,"state":"unknown","cost":0,"untagged":1}[0m 5.47ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,11][0m 1.36ms] 11 11 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,1][0m 0.67ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":1,"baseport":11,"priority":0,"state":"unknown","cost":0,"untagged":1}[0m 5.05ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,12][0m 1.33ms] 12 12 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,1][0m 0.67ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":1,"baseport":12,"priority":0,"state":"unknown","cost":0,"untagged":1}[0m 4.97ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,13][0m 1.39ms] 13 13 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,1][0m 0.71ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":1,"baseport":13,"priority":0,"state":"unknown","cost":0,"untagged":1}[0m 5.34ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,14][0m 1.36ms] 14 14 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,1][0m 0.67ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":1,"baseport":14,"priority":0,"state":"unknown","cost":0,"untagged":1}[0m 5.15ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,15][0m 1.35ms] 15 15 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,1][0m 0.67ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":1,"baseport":15,"priority":0,"state":"unknown","cost":0,"untagged":1}[0m 5.04ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,16][0m 1.39ms] 16 16 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,1][0m 0.71ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":1,"baseport":16,"priority":0,"state":"unknown","cost":0,"untagged":1}[0m 4.88ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,17][0m 1.36ms] 17 17 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,1][0m 0.67ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":1,"baseport":17,"priority":0,"state":"unknown","cost":0,"untagged":1}[0m 4.97ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,18][0m 1.37ms] 18 18 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,1][0m 0.73ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":1,"baseport":18,"priority":0,"state":"unknown","cost":0,"untagged":1}[0m 5.01ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,19][0m 1.29ms] 19 19 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,1][0m 0.67ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":1,"baseport":19,"priority":0,"state":"unknown","cost":0,"untagged":1}[0m 5.19ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,20][0m 1.42ms] 20 20 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,1][0m 0.67ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":1,"baseport":20,"priority":0,"state":"unknown","cost":0,"untagged":1}[0m 4.8ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,21][0m 1.33ms] 21 21 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,1][0m 0.66ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":1,"baseport":21,"priority":0,"state":"unknown","cost":0,"untagged":1}[0m 4.95ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,22][0m 1.29ms] 22 22 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,1][0m 0.66ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":1,"baseport":22,"priority":0,"state":"unknown","cost":0,"untagged":1}[0m 4.94ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,23][0m 0.89ms] 23 23 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,1][0m 0.65ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":1,"baseport":23,"priority":0,"state":"unknown","cost":0,"untagged":1}[0m 5.11ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,24][0m 0.96ms] 24 24 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,1][0m 0.7ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":1,"baseport":24,"priority":0,"state":"unknown","cost":0,"untagged":1}[0m 5.01ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,25][0m 1.37ms] 25 25 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,1][0m 0.67ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":1,"baseport":25,"priority":0,"state":"unknown","cost":0,"untagged":1}[0m 5.1ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,26][0m 1.39ms] 26 26 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,1][0m 0.73ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":1,"baseport":26,"priority":0,"state":"unknown","cost":0,"untagged":1}[0m 5.32ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,79][0m 8.57ms] 79 79 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,1][0m 0.64ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":1,"baseport":79,"priority":0,"state":"unknown","cost":0,"untagged":1}[0m 5.15ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,80][0m 1.39ms] 80 80 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,1][0m 0.67ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":1,"baseport":80,"priority":0,"state":"unknown","cost":0,"untagged":1}[0m 5.05ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,81][0m 1.41ms] 81 81 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,1][0m 0.72ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":1,"baseport":81,"priority":0,"state":"unknown","cost":0,"untagged":1}[0m 7.09ms] Inserted VLAN 25 dot1d id ifIndex Port Name Priority State Cost SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,1][0m 0.93ms] 1 1 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,25][0m 0.93ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":25,"baseport":1,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.04ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,2][0m 0.96ms] 2 2 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,25][0m 1.07ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":25,"baseport":2,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.49ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,3][0m 0.92ms] 3 3 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,25][0m 0.67ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":25,"baseport":3,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.54ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,4][0m 0.96ms] 4 4 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,25][0m 0.7ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":25,"baseport":4,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.43ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,5][0m 0.96ms] 5 5 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,25][0m 0.67ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":25,"baseport":5,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.07ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,6][0m 0.97ms] 6 6 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,25][0m 0.72ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":25,"baseport":6,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.44ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,7][0m 0.92ms] 7 7 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,25][0m 0.67ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":25,"baseport":7,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.61ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,8][0m 0.92ms] 8 8 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,25][0m 0.67ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":25,"baseport":8,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.07ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,9][0m 1.23ms] 9 9 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,25][0m 0.67ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":25,"baseport":9,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.67ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,10][0m 1.25ms] 10 10 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,25][0m 0.88ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":25,"baseport":10,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 9.37ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,11][0m 0.96ms] 11 11 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,25][0m 0.67ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":25,"baseport":11,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 4.94ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,12][0m 1.01ms] 12 12 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,25][0m 0.67ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":25,"baseport":12,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.05ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,13][0m 0.92ms] 13 13 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,25][0m 0.77ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":25,"baseport":13,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,14][0m 1.01ms] 14 14 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,25][0m 0.78ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":25,"baseport":14,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.03ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,15][0m 1.05ms] 15 15 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,25][0m 0.67ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":25,"baseport":15,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.53ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,16][0m 0.92ms] 16 16 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,25][0m 0.76ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":25,"baseport":16,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.13ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,17][0m 0.92ms] 17 17 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,25][0m 0.8ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":25,"baseport":17,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.08ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,18][0m 0.98ms] 18 18 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,25][0m 0.66ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":25,"baseport":18,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 4.99ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,19][0m 0.91ms] 19 19 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,25][0m 0.67ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":25,"baseport":19,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 4.84ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,20][0m 0.95ms] 20 20 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,25][0m 0.66ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":25,"baseport":20,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 4.91ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,21][0m 0.91ms] 21 21 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,25][0m 0.76ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":25,"baseport":21,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.06ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,22][0m 0.96ms] 22 22 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,25][0m 0.66ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":25,"baseport":22,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.02ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,23][0m 0.96ms] 23 23 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,25][0m 0.7ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":25,"baseport":23,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.19ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,24][0m 0.92ms] 24 24 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,25][0m 0.66ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":25,"baseport":24,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,25][0m 0.98ms] 25 25 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,25][0m 0.66ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":25,"baseport":25,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.3ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,26][0m 0.97ms] 26 26 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,25][0m 0.73ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":25,"baseport":26,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.07ms] Inserted VLAN 200 dot1d id ifIndex Port Name Priority State Cost SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,1][0m 1.03ms] 1 1 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,200][0m 1.03ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":200,"baseport":1,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.24ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,2][0m 0.98ms] 2 2 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,200][0m 0.72ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":200,"baseport":2,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.22ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,3][0m 0.97ms] 3 3 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,200][0m 0.73ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":200,"baseport":3,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.13ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,4][0m 0.92ms] 4 4 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,200][0m 0.67ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":200,"baseport":4,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 4.91ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,5][0m 0.97ms] 5 5 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,200][0m 0.72ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":200,"baseport":5,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.16ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,6][0m 0.92ms] 6 6 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,200][0m 0.66ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":200,"baseport":6,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.04ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,7][0m 0.95ms] 7 7 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,200][0m 0.66ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":200,"baseport":7,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.07ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,8][0m 0.92ms] 8 8 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,200][0m 0.74ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":200,"baseport":8,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 4.91ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,9][0m 0.92ms] 9 9 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,200][0m 0.67ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":200,"baseport":9,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.39ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,10][0m 0.98ms] 10 10 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,200][0m 0.7ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":200,"baseport":10,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.1ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,11][0m 0.97ms] 11 11 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,200][0m 0.66ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":200,"baseport":11,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.45ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,12][0m 0.92ms] 12 12 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,200][0m 0.75ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":200,"baseport":12,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 4.92ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,13][0m 0.92ms] 13 13 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,200][0m 0.67ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":200,"baseport":13,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.18ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,14][0m 0.96ms] 14 14 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,200][0m 0.71ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":200,"baseport":14,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.17ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,15][0m 0.92ms] 15 15 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,200][0m 0.66ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":200,"baseport":15,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.01ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,16][0m 0.96ms] 16 16 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,200][0m 0.66ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":200,"baseport":16,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.36ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,17][0m 0.92ms] 17 17 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,200][0m 0.71ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":200,"baseport":17,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.2ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,18][0m 0.92ms] 18 18 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,200][0m 0.66ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":200,"baseport":18,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 4.96ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,19][0m 0.97ms] 19 19 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,200][0m 0.7ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":200,"baseport":19,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.5ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,20][0m 0.95ms] 20 20 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,200][0m 0.66ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":200,"baseport":20,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 4.94ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,21][0m 0.95ms] 21 21 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,200][0m 0.67ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":200,"baseport":21,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.26ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,22][0m 0.92ms] 22 22 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,200][0m 0.67ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":200,"baseport":22,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 4.84ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,23][0m 0.92ms] 23 23 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,200][0m 0.66ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":200,"baseport":23,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.01ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,24][0m 0.96ms] 24 24 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,200][0m 0.69ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":200,"baseport":24,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.13ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,25][0m 0.92ms] 25 25 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,200][0m 0.67ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":200,"baseport":25,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.07ms] Inserted SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,26][0m 0.95ms] 26 26 0 unknown 0 SQL[[1;33mSELECT * FROM `ports_vlans` WHERE device_id = ? AND port_id = ? AND `vlan` = ? [0;33m[312,null,200][0m 0.66ms] SQL[[1;33mINSERT IGNORE INTO `ports_vlans` (`device_id`,`port_id`,`vlan`,`baseport`,`priority`,`state`,`cost`,`untagged`) VALUES (:device_id,:port_id,:vlan,:baseport,:priority,:state,:cost,:untagged) [0;33m{"device_id":312,"port_id":null,"vlan":200,"baseport":26,"priority":0,"state":"unknown","cost":0,"untagged":0}[0m 5.13ms] Inserted SQL[[1;33mDELETE FROM `ports_vlans` WHERE `device_id`=? AND `port_vlan_id` NOT IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [0;33m[312,"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","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","0","0","0","0","0","0","0","0","0"][0m 5.56ms] Deleted 3 vlan mappings >> Runtime for discovery module 'vlans': 2.1530 seconds with 58696 bytes >> [0;36mSNMP[0m: [5/1.38s] [1;33mMySQL[0m: [248/5.91s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module vlans #### Modules status: Global- OS Device+ #### Load disco module vmware-vminfo #### >> Runtime for discovery module 'vmware-vminfo': 0.0000 seconds with 1184 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module vmware-vminfo #### Modules status: Global- OS Device+ #### Load disco module libvirt-vminfo #### >> Runtime for discovery module 'libvirt-vminfo': 0.0010 seconds with 1752 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module libvirt-vminfo #### Modules status: Global- OS Device Module [ printer-supplies ] disabled globally. Modules status: Global+ OS- Device Module [ ucd-diskio ] disabled on os. Modules status: Global- OS Device Module [ applications ] disabled globally. Modules status: Global+ OS- Device Module [ services ] disabled on os. Modules status: Global- OS Device+ #### Load disco module stp #### Instances: SNMP[[0;36m'/usr/bin/snmpget' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' '-v2c' '-c' 'COMMUNITY' '-OQXUte' 'udp:HOSTNAME:161' 'BRIDGE-MIB::dot1dStpProtocolSpecification.0'[0m] BRIDGE-MIB::dot1dStpProtocolSpecification.0 = No Such Object available on this agent at this OID SQL[[1;33mselect * from `stp` where `stp`.`device_id` = ? and `stp`.`device_id` is not null [0;33m[312][0m 1ms] Ports: SQL[[1;33mselect * from `ports_stp` where `ports_stp`.`device_id` = ? and `ports_stp`.`device_id` is not null [0;33m[312][0m 0.75ms] >> Runtime for discovery module 'stp': 0.4320 seconds with 76360 bytes >> [0;36mSNMP[0m: [1/0.42s] [1;33mMySQL[0m: [2/0.02s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module stp #### Modules status: Global- OS Device+ #### Load disco module ntp #### >> Runtime for discovery module 'ntp': 0.0000 seconds with 232 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module ntp #### Modules status: Global- OS Device+ #### Load disco module loadbalancers #### >> Runtime for discovery module 'loadbalancers': 0.0000 seconds with 272 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module loadbalancers #### Modules status: Global- OS Device+ #### Load disco module mef #### SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUs' '-m' 'MEF-UNI-EVC-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'MefServiceEvcCfgEntry'[0m] mefServiceEvcCfgEntry = No Such Object available on this agent at this OID Invalid snmp_walk() data = mefServiceEvcCfgEntry = No Such Object available on this agent at this OID MEF : SQL[[1;33mSELECT id, mefID, mefIdent FROM mefinfo WHERE device_id = '312' [0;33m[][0m 1.52ms] >> Runtime for discovery module 'mef': 0.0680 seconds with 848 bytes >> [0;36mSNMP[0m: [1/0.06s] [1;33mMySQL[0m: [1/0.02s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module mef #### Modules status: Global- OS Device Module [ wireless ] disabled globally. Modules status: Global- OS+ Device+ #### Load disco module fdb-table #### SQL[[1;33mSELECT `vlan_id`, `vlan_vlan` from `vlans` WHERE `device_id` = ? [0;33m[312][0m 1.25ms] SQL[[1;33mSELECT * FROM `ports_fdb` WHERE `device_id` = ? [0;33m[312][0m 1.7ms] SNMP[[0;36m'/usr/bin/snmpbulkwalk' '-Cr10' '-v2c' '-c' 'COMMUNITY' '-OQUsetX' '-m' 'EdgeSwitch-SWITCHING-MIB' '-M' '/opt/librenms/mibs:/opt/librenms/mibs/edgeswitch' 'udp:HOSTNAME:161' 'agentDynamicDsBindingTable'[0m] agentDynamicDsBindingIfIndex[0:d0:2d:dc:73:f7] = 24 agentDynamicDsBindingIfIndex[0:d0:2d:dc:a3:1f] = 24 agentDynamicDsBindingIfIndex[6a:5f:17:1f:6f:82] = 1 agentDynamicDsBindingIfIndex[dc:9f:db:40:fb:74] = 23 agentDynamicDsBindingVlanId[0:d0:2d:dc:73:f7] = 1 agentDynamicDsBindingVlanId[0:d0:2d:dc:a3:1f] = 1 agentDynamicDsBindingVlanId[6a:5f:17:1f:6f:82] = 1 agentDynamicDsBindingVlanId[dc:9f:db:40:fb:74] = 1 agentDynamicDsBindingMacAddr[0:d0:2d:dc:73:f7] = 0:d0:2d:dc:73:f7 agentDynamicDsBindingMacAddr[0:d0:2d:dc:a3:1f] = 0:d0:2d:dc:a3:1f agentDynamicDsBindingMacAddr[6a:5f:17:1f:6f:82] = 6a:5f:17:1f:6f:82 agentDynamicDsBindingMacAddr[dc:9f:db:40:fb:74] = dc:9f:db:40:fb:74 agentDynamicDsBindingIpAddr[0:d0:2d:dc:73:f7] = * agentDynamicDsBindingIpAddr[0:d0:2d:dc:a3:1f] = * agentDynamicDsBindingIpAddr[6a:5f:17:1f:6f:82] = * agentDynamicDsBindingIpAddr[dc:9f:db:40:fb:74] = * agentDynamicDsBindingLeaseRemainingTime[0:d0:2d:dc:73:f7] = 664200 agentDynamicDsBindingLeaseRemainingTime[0:d0:2d:dc:a3:1f] = 664900 agentDynamicDsBindingLeaseRemainingTime[6a:5f:17:1f:6f:82] = 661800 agentDynamicDsBindingLeaseRemainingTime[dc:9f:db:40:fb:74] = 570200 SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,"24"][0m 2ms] vlan 1 mac 00d02ddc73f7 port SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,"24"][0m 1.07ms] vlan 1 mac 00d02ddca31f port SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,"1"][0m 1.51ms] vlan 1 mac 6a5f171f6f82 port SQL[[1;33mSELECT * FROM `ports` WHERE `device_id` = ? AND `ifIndex` = ? [0;33m[312,"23"][0m 1.29ms] vlan 1 mac dc9fdb40fb74 port 1: .... SQL[[1;33mupdate `ports_fdb` set `updated_at` = ? where `ports_fdb_id` in (14897, 14898, 14896, 14902) [0;33m["2022-11-14 11:19:56"][0m 5.38ms] >> Runtime for discovery module 'fdb-table': 0.1130 seconds with 4800 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [7/0.14s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module fdb-table #### Modules status: Global- OS Device+ #### Load disco module mpls #### >> Runtime for discovery module 'mpls': 0.0010 seconds with 36712 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module mpls #### Modules status: Global- OS Device+ #### Load disco module charge #### >> Runtime for discovery module 'charge': 0.0000 seconds with 0 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module charge #### Modules status: Global- OS Device+ #### Load disco module cisco-sla #### >> Runtime for discovery module 'cisco-sla': 0.0000 seconds with 0 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module cisco-sla #### Modules status: Global- OS Device+ #### Load disco module toner #### >> Runtime for discovery module 'toner': 0.0000 seconds with 0 bytes >> [0;36mSNMP[0m: [0/0.00s] [1;33mMySQL[0m: [0/0.00s] [0;32mRRD[0m: [0/0.00s] #### Unload disco module toner #### SQL[[1;33mUPDATE `devices` set `last_discovered`=NOW(),`last_discovered_timetaken`=? WHERE `device_id` = ? [0;33m[10.744,312][0m 5.72ms] Discovered in 10.744 seconds ./discovery.php 172.22.1.64 2022-11-14 11:19:56 - 1 devices discovered in 11.54 secs [0;36mSNMP[0m [42/7.00s]: Snmpget[12/3.21s] Snmpwalk[30/3.79s] [1;33mSQL[0m [518/10.63s]: Select[384/4.59s] Update[31/0.58s] Delete[6/0.39s] Insert[96/5.05s] [1/0.02s] [0;32mRRD[0m [0/0.00s]: