LibreNMS Discovery =================================== Version info: Commit SHA: 69bedd0101c86e2682570e5bc12edae87cbb0c21 Commit Date: 1521150410 DB Schema: 245 PHP: 7.0.22-0ubuntu0.16.04.1 MySQL: 10.0.34-MariaDB-0ubuntu0.16.04.1 RRDTool: 1.5.5 SNMP: NET-SNMP 5.7.3 ==================================DEBUG! Updating os_def.cache... Done SQL[SELECT * FROM `devices` WHERE disabled = 0 AND snmp_disable = 0 AND `hostname` LIKE 'pavlovce-siae' ORDER BY device_id DESC] SQL[SELECT * FROM devices_attribs WHERE `device_id` = '73'] pavlovce-siae 73 generic SQL[INSERT INTO `device_perf` (`xmt`,`rcv`,`loss`,`min`,`max`,`avg`,`device_id`,`timestamp`) VALUES ('3','3','0','2.96','20.7','8.94','73',NOW())] SNMP Check response code: 0 SNMP[/usr/bin/snmpget -v1 -c COMMUNITY -Ovq -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 SNMPv2-MIB::sysDescr.0] ALFOplus2 - SIAE Microelettronica SNMP[/usr/bin/snmpget -v1 -c COMMUNITY -Ovqn -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 SNMPv2-MIB::sysObjectID.0] .*.4.1.3373.1103 | ALFOplus2 - SIAE Microelettronica | .1.3.6.1.4.1.3373.1103 | SNMP[/usr/bin/snmpget -v1 -c COMMUNITY -Oqv -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 .1.3.6.1.4.1.12148.10.2.6.0] SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = '73' AND `attrib_type` = 'poll_mib' ] Attempting to initialize OS: generic OS initialized: LibreNMS\OS\Generic Modules status: Global+ OS Device #### Load disco module core #### SNMP[/usr/bin/snmpget -v1 -c COMMUNITY -OUQn -m SNMPv2-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 sysName.0 sysObjectID.0 sysDescr.0] .*.*.0 = SIAE target .*.*.0 = .*.4.1.3373.1103 .*.*.0 = ALFOplus2 - SIAE Microelettronica >> Runtime for discovery module 'core': 0.0430 seconds with 1056 bytes >> SNMP: [5/0.23s] MySQL: [8/0.21s] RRD: [0/0.00s] #### Unload disco module core #### Modules status: Global+ OS+ Device #### Load disco module os #### SNMP[/usr/bin/snmpget -v1 -c COMMUNITY -Ovq -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 SNMPv2-MIB::sysDescr.0] ALFOplus2 - SIAE Microelettronica SNMP[/usr/bin/snmpget -v1 -c COMMUNITY -Ovqn -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 SNMPv2-MIB::sysObjectID.0] .*.4.1.3373.1103 | ALFOplus2 - SIAE Microelettronica | .1.3.6.1.4.1.3373.1103 | SNMP[/usr/bin/snmpget -v1 -c COMMUNITY -Oqv -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 .1.3.6.1.4.1.12148.10.2.6.0] OS: Generic Device (generic) >> Runtime for discovery module 'os': 0.1030 seconds with 1368 bytes >> SNMP: [3/0.10s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload disco module os #### Modules status: Global+ OS+ Device #### Load disco module ports #### SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m IF-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 ifDescr] ifDescr.1 = Ethernet Interface Port 01 ifDescr.2 = Ethernet Interface Port 02 ifDescr.3 = Ethernet Interface Port 03 ifDescr.4 = Ethernet Interface Port 04 ifDescr.5 = Ethernet Interface Port 05 ifDescr.6 = Ethernet Interface Port 06 ifDescr.7 = Ethernet Interface Port 07 ifDescr.8 = Ethernet Interface Port 08 ifDescr.9 = Ethernet Interface Port 09 ifDescr.10 = Ethernet Interface Port 10 ifDescr.22 = L3IPVLAN Interface SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m IF-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 ifName] ifName.1 = Slot0/4 ifName.2 = Slot0/2 ifName.3 = Slot0/3 ifName.4 = Slot0/1 ifName.5 = Slot0/5 ifName.6 = Slot0/6 ifName.7 = Slot0/7 ifName.8 = Slot0/8 ifName.9 = Slot0/9 ifName.10 = Slot0/10 ifName.22 = vlan260 SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m IF-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 ifAlias] ifAlias.1 = Slot0/4 ifAlias.2 = Slot0/2 ifAlias.3 = Slot0/3 ifAlias.4 = Slot0/1 ifAlias.5 = Slot0/5 ifAlias.6 = Slot0/6 ifAlias.7 = Slot0/7 ifAlias.8 = Slot0/8 ifAlias.9 = Slot0/9 ifAlias.10 = Slot0/10 ifAlias.22 = vlan260 SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m IF-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 ifType] 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.22 = l3ipvlan Array ( [1] => Array ( [ifDescr] => Ethernet Interface Port 01 [ifName] => Slot0/4 [ifAlias] => Slot0/4 [ifType] => ethernetCsmacd ) [2] => Array ( [ifDescr] => Ethernet Interface Port 02 [ifName] => Slot0/2 [ifAlias] => Slot0/2 [ifType] => ethernetCsmacd ) [3] => Array ( [ifDescr] => Ethernet Interface Port 03 [ifName] => Slot0/3 [ifAlias] => Slot0/3 [ifType] => ethernetCsmacd ) [4] => Array ( [ifDescr] => Ethernet Interface Port 04 [ifName] => Slot0/1 [ifAlias] => Slot0/1 [ifType] => ethernetCsmacd ) [5] => Array ( [ifDescr] => Ethernet Interface Port 05 [ifName] => Slot0/5 [ifAlias] => Slot0/5 [ifType] => ethernetCsmacd ) [6] => Array ( [ifDescr] => Ethernet Interface Port 06 [ifName] => Slot0/6 [ifAlias] => Slot0/6 [ifType] => ethernetCsmacd ) [7] => Array ( [ifDescr] => Ethernet Interface Port 07 [ifName] => Slot0/7 [ifAlias] => Slot0/7 [ifType] => ethernetCsmacd ) [8] => Array ( [ifDescr] => Ethernet Interface Port 08 [ifName] => Slot0/8 [ifAlias] => Slot0/8 [ifType] => ethernetCsmacd ) [9] => Array ( [ifDescr] => Ethernet Interface Port 09 [ifName] => Slot0/9 [ifAlias] => Slot0/9 [ifType] => ethernetCsmacd ) [10] => Array ( [ifDescr] => Ethernet Interface Port 10 [ifName] => Slot0/10 [ifAlias] => Slot0/10 [ifType] => ethernetCsmacd ) [22] => Array ( [ifDescr] => L3IPVLAN Interface [ifName] => vlan260 [ifAlias] => vlan260 [ifType] => l3ipvlan ) ) SQL[SELECT `name` FROM `port_association_mode` WHERE pom_id = '1'] SQL[SELECT * FROM `ports` WHERE `device_id` = '73' ORDER BY port_id] ........... >> Runtime for discovery module 'ports': 0.3750 seconds with 4352 bytes >> SNMP: [4/0.35s] MySQL: [2/0.00s] RRD: [0/0.00s] #### Unload disco module ports #### Modules status: Global+ OS+ Device #### Load disco module ports-stack #### SQL[SELECT * FROM `ports_stack` WHERE `device_id` = '73'] SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 ifStackStatus] >> Runtime for discovery module 'ports-stack': 0.0380 seconds with 1768 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload disco module ports-stack #### Modules status: Global+ OS+ Device #### Load disco module entity-physical #### Caching OIDs: entPhysicalEntrySNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m ENTITY-MIB:CISCO-ENTITY-VENDORTYPE-OID-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 entPhysicalEntry] entPhysicalDescr.1 = Network Element entPhysicalDescr.2 = entPhysicalDescr.3 = entPhysicalDescr.4 = entPhysicalDescr.5 = entPhysicalDescr.6 = entPhysicalDescr.7 = entPhysicalDescr.8 = entPhysicalDescr.9 = entPhysicalDescr.10 = Ethernet Interface Port 01 entPhysicalDescr.11 = Ethernet Interface Port 02 entPhysicalDescr.12 = Ethernet Interface Port 03 entPhysicalDescr.13 = Ethernet Interface Port 04 entPhysicalDescr.14 = Ethernet Interface Port 05 entPhysicalDescr.15 = Ethernet Interface Port 06 entPhysicalDescr.16 = Ethernet Interface Port 07 entPhysicalDescr.17 = Ethernet Interface Port 08 entPhysicalDescr.18 = Ethernet Interface Port 09 entPhysicalDescr.19 = Ethernet Interface Port 10 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 entPhysicalContainedIn.1 = 0 entPhysicalContainedIn.2 = 1 entPhysicalContainedIn.3 = 1 entPhysicalContainedIn.4 = 1 entPhysicalContainedIn.5 = 1 entPhysicalContainedIn.6 = 1 entPhysicalContainedIn.7 = 1 entPhysicalContainedIn.8 = 1 entPhysicalContainedIn.9 = 1 entPhysicalContainedIn.10 = 9 entPhysicalContainedIn.11 = 9 entPhysicalContainedIn.12 = 9 entPhysicalContainedIn.13 = 9 entPhysicalContainedIn.14 = 9 entPhysicalContainedIn.15 = 9 entPhysicalContainedIn.16 = 9 entPhysicalContainedIn.17 = 9 entPhysicalContainedIn.18 = 9 entPhysicalContainedIn.19 = 9 entPhysicalClass.1 = chassis entPhysicalClass.2 = cpu entPhysicalClass.3 = powerSupply entPhysicalClass.4 = fan entPhysicalClass.5 = fan entPhysicalClass.6 = fan entPhysicalClass.7 = fan entPhysicalClass.8 = fan entPhysicalClass.9 = module 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 entPhysicalParentRelPos.1 = 0 entPhysicalParentRelPos.2 = 1 entPhysicalParentRelPos.3 = 2 entPhysicalParentRelPos.4 = 3 entPhysicalParentRelPos.5 = 4 entPhysicalParentRelPos.6 = 5 entPhysicalParentRelPos.7 = 6 entPhysicalParentRelPos.8 = 7 entPhysicalParentRelPos.9 = 8 entPhysicalParentRelPos.10 = 1 entPhysicalParentRelPos.11 = 2 entPhysicalParentRelPos.12 = 3 entPhysicalParentRelPos.13 = 4 entPhysicalParentRelPos.14 = 5 entPhysicalParentRelPos.15 = 6 entPhysicalParentRelPos.16 = 7 entPhysicalParentRelPos.17 = 8 entPhysicalParentRelPos.18 = 9 entPhysicalParentRelPos.19 = 10 entPhysicalName.1 = ISS entPhysicalName.2 = entPhysicalName.3 = entPhysicalName.4 = entPhysicalName.5 = entPhysicalName.6 = entPhysicalName.7 = entPhysicalName.8 = entPhysicalName.9 = entPhysicalName.10 = Gi0/4 entPhysicalName.11 = Gi0/2 entPhysicalName.12 = Gi0/3 entPhysicalName.13 = Gi0/1 entPhysicalName.14 = Gi0/5 entPhysicalName.15 = Gi0/6 entPhysicalName.16 = Gi0/7 entPhysicalName.17 = Gi0/8 entPhysicalName.18 = Gi0/9 entPhysicalName.19 = Gi0/10 entPhysicalHardwareRev.1 = 5.9.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 = entPhysicalFirmwareRev.1 = 6.7.2 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 = entPhysicalSoftwareRev.1 = 6.2.0 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 = entPhysicalSerialNum.1 = 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 = entPhysicalMfgName.1 = Aricent 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 = entPhysicalModelName.1 = entPhysicalModelName.2 = 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 = entPhysicalAlias.1 = DummyName entPhysicalAlias.2 = entPhysicalAlias.3 = entPhysicalAlias.4 = entPhysicalAlias.5 = entPhysicalAlias.6 = entPhysicalAlias.7 = entPhysicalAlias.8 = entPhysicalAlias.9 = entPhysicalAlias.10 = Slot0/4 entPhysicalAlias.11 = Slot0/2 entPhysicalAlias.12 = Slot0/3 entPhysicalAlias.13 = Slot0/1 entPhysicalAlias.14 = Slot0/5 entPhysicalAlias.15 = Slot0/6 entPhysicalAlias.16 = Slot0/7 entPhysicalAlias.17 = Slot0/8 entPhysicalAlias.18 = Slot0/9 entPhysicalAlias.19 = Slot0/10 entPhysicalAssetID.1 = DummyId 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 = entPhysicalIsFRU.1 = true entPhysicalIsFRU.2 = true entPhysicalIsFRU.3 = true entPhysicalIsFRU.4 = true entPhysicalIsFRU.5 = true entPhysicalIsFRU.6 = true entPhysicalIsFRU.7 = true entPhysicalIsFRU.8 = true entPhysicalIsFRU.9 = true 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 entPhysicalMfgDate.1 = 2009-8-6,13:30:30.1 entPhysicalMfgDate.2 = 0-0-0,0:0:0.0 entPhysicalMfgDate.3 = 0-0-0,0:0:0.0 entPhysicalMfgDate.4 = 0-0-0,0:0:0.0 entPhysicalMfgDate.5 = 0-0-0,0:0:0.0 entPhysicalMfgDate.6 = 0-0-0,0:0:0.0 entPhysicalMfgDate.7 = 0-0-0,0:0:0.0 entPhysicalMfgDate.8 = 0-0-0,0:0:0.0 entPhysicalMfgDate.9 = 0-0-0,0:0:0.0 entPhysicalMfgDate.10 = 0-0-0,0:0:0.0 entPhysicalMfgDate.11 = 0-0-0,0:0:0.0 entPhysicalMfgDate.12 = 0-0-0,0:0:0.0 entPhysicalMfgDate.13 = 0-0-0,0:0:0.0 entPhysicalMfgDate.14 = 0-0-0,0:0:0.0 entPhysicalMfgDate.15 = 0-0-0,0:0:0.0 entPhysicalMfgDate.16 = 0-0-0,0:0:0.0 entPhysicalMfgDate.17 = 0-0-0,0:0:0.0 entPhysicalMfgDate.18 = 0-0-0,0:0:0.0 entPhysicalMfgDate.19 = 0-0-0,0:0:0.0 entPhysicalUris.1 = "" entPhysicalUris.2 = "" entPhysicalUris.3 = "" entPhysicalUris.4 = "" entPhysicalUris.5 = "" entPhysicalUris.6 = "" entPhysicalUris.7 = "" entPhysicalUris.8 = "" entPhysicalUris.9 = "" entPhysicalUris.10 = "" entPhysicalUris.11 = "" entPhysicalUris.12 = "" entPhysicalUris.13 = "" entPhysicalUris.14 = "" entPhysicalUris.15 = "" entPhysicalUris.16 = "" entPhysicalUris.17 = "" entPhysicalUris.18 = "" entPhysicalUris.19 = "" entAliasMappingIdentifierSNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m ENTITY-MIB:IF-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 entAliasMappingIdentifier] entAliasMappingIdentifier.10.0 = zeroDotZero.*.0 entAliasMappingIdentifier.11.0 = zeroDotZero.*.0 entAliasMappingIdentifier.12.0 = zeroDotZero.*.0 entAliasMappingIdentifier.13.0 = zeroDotZero.*.0 entAliasMappingIdentifier.14.0 = zeroDotZero.*.0 entAliasMappingIdentifier.15.0 = zeroDotZero.*.0 entAliasMappingIdentifier.16.0 = zeroDotZero.*.0 entAliasMappingIdentifier.17.0 = zeroDotZero.*.0 entAliasMappingIdentifier.18.0 = zeroDotZero.*.0 entAliasMappingIdentifier.19.0 = zeroDotZero.*.0.0 SQL[SELECT entPhysical_id FROM `entPhysical` WHERE device_id = '73' AND entPhysicalIndex = '1'] SQL[UPDATE `entPhysical` set `entPhysicalIndex` ='1',`entPhysicalDescr` ='Network Element',`entPhysicalClass` ='chassis',`entPhysicalName` ='ISS',`entPhysicalModelName` ='',`entPhysicalSerialNum` ='',`entPhysicalContainedIn` ='0',`entPhysicalMfgName` ='Aricent',`entPhysicalParentRelPos` ='0',`entPhysicalVendorType` ='zeroDotZero',`entPhysicalHardwareRev` ='5.9.1',`entPhysicalFirmwareRev` ='6.7.2',`entPhysicalSoftwareRev` ='6.2.0',`entPhysicalIsFRU` ='true',`entPhysicalAlias` ='DummyName',`entPhysicalAssetID` ='DummyId' WHERE device_id='73' AND entPhysicalIndex='1'] .SQL[SELECT entPhysical_id FROM `entPhysical` WHERE device_id = '73' AND entPhysicalIndex = '10'] SQL[UPDATE `entPhysical` set `entPhysicalIndex` ='10',`entPhysicalDescr` ='Ethernet Interface Port 01',`entPhysicalClass` ='port',`entPhysicalName` ='Gi0/4',`entPhysicalModelName` ='',`entPhysicalSerialNum` ='',`entPhysicalContainedIn` ='9',`entPhysicalMfgName` ='',`entPhysicalParentRelPos` ='1',`entPhysicalVendorType` ='zeroDotZero',`entPhysicalHardwareRev` ='',`entPhysicalFirmwareRev` ='',`entPhysicalSoftwareRev` ='',`entPhysicalIsFRU` ='false',`entPhysicalAlias` ='Slot0/4',`entPhysicalAssetID` ='' WHERE device_id='73' AND entPhysicalIndex='10'] .SQL[SELECT entPhysical_id FROM `entPhysical` WHERE device_id = '73' AND entPhysicalIndex = '11'] SQL[UPDATE `entPhysical` set `entPhysicalIndex` ='11',`entPhysicalDescr` ='Ethernet Interface Port 02',`entPhysicalClass` ='port',`entPhysicalName` ='Gi0/2',`entPhysicalModelName` ='',`entPhysicalSerialNum` ='',`entPhysicalContainedIn` ='9',`entPhysicalMfgName` ='',`entPhysicalParentRelPos` ='2',`entPhysicalVendorType` ='zeroDotZero',`entPhysicalHardwareRev` ='',`entPhysicalFirmwareRev` ='',`entPhysicalSoftwareRev` ='',`entPhysicalIsFRU` ='false',`entPhysicalAlias` ='Slot0/2',`entPhysicalAssetID` ='' WHERE device_id='73' AND entPhysicalIndex='11'] .SQL[SELECT entPhysical_id FROM `entPhysical` WHERE device_id = '73' AND entPhysicalIndex = '12'] SQL[UPDATE `entPhysical` set `entPhysicalIndex` ='12',`entPhysicalDescr` ='Ethernet Interface Port 03',`entPhysicalClass` ='port',`entPhysicalName` ='Gi0/3',`entPhysicalModelName` ='',`entPhysicalSerialNum` ='',`entPhysicalContainedIn` ='9',`entPhysicalMfgName` ='',`entPhysicalParentRelPos` ='3',`entPhysicalVendorType` ='zeroDotZero',`entPhysicalHardwareRev` ='',`entPhysicalFirmwareRev` ='',`entPhysicalSoftwareRev` ='',`entPhysicalIsFRU` ='false',`entPhysicalAlias` ='Slot0/3',`entPhysicalAssetID` ='' WHERE device_id='73' AND entPhysicalIndex='12'] .SQL[SELECT entPhysical_id FROM `entPhysical` WHERE device_id = '73' AND entPhysicalIndex = '13'] SQL[UPDATE `entPhysical` set `entPhysicalIndex` ='13',`entPhysicalDescr` ='Ethernet Interface Port 04',`entPhysicalClass` ='port',`entPhysicalName` ='Gi0/1',`entPhysicalModelName` ='',`entPhysicalSerialNum` ='',`entPhysicalContainedIn` ='9',`entPhysicalMfgName` ='',`entPhysicalParentRelPos` ='4',`entPhysicalVendorType` ='zeroDotZero',`entPhysicalHardwareRev` ='',`entPhysicalFirmwareRev` ='',`entPhysicalSoftwareRev` ='',`entPhysicalIsFRU` ='false',`entPhysicalAlias` ='Slot0/1',`entPhysicalAssetID` ='' WHERE device_id='73' AND entPhysicalIndex='13'] .SQL[SELECT entPhysical_id FROM `entPhysical` WHERE device_id = '73' AND entPhysicalIndex = '14'] SQL[UPDATE `entPhysical` set `entPhysicalIndex` ='14',`entPhysicalDescr` ='Ethernet Interface Port 05',`entPhysicalClass` ='port',`entPhysicalName` ='Gi0/5',`entPhysicalModelName` ='',`entPhysicalSerialNum` ='',`entPhysicalContainedIn` ='9',`entPhysicalMfgName` ='',`entPhysicalParentRelPos` ='5',`entPhysicalVendorType` ='zeroDotZero',`entPhysicalHardwareRev` ='',`entPhysicalFirmwareRev` ='',`entPhysicalSoftwareRev` ='',`entPhysicalIsFRU` ='false',`entPhysicalAlias` ='Slot0/5',`entPhysicalAssetID` ='' WHERE device_id='73' AND entPhysicalIndex='14'] .SQL[SELECT entPhysical_id FROM `entPhysical` WHERE device_id = '73' AND entPhysicalIndex = '15'] SQL[UPDATE `entPhysical` set `entPhysicalIndex` ='15',`entPhysicalDescr` ='Ethernet Interface Port 06',`entPhysicalClass` ='port',`entPhysicalName` ='Gi0/6',`entPhysicalModelName` ='',`entPhysicalSerialNum` ='',`entPhysicalContainedIn` ='9',`entPhysicalMfgName` ='',`entPhysicalParentRelPos` ='6',`entPhysicalVendorType` ='zeroDotZero',`entPhysicalHardwareRev` ='',`entPhysicalFirmwareRev` ='',`entPhysicalSoftwareRev` ='',`entPhysicalIsFRU` ='false',`entPhysicalAlias` ='Slot0/6',`entPhysicalAssetID` ='' WHERE device_id='73' AND entPhysicalIndex='15'] .SQL[SELECT entPhysical_id FROM `entPhysical` WHERE device_id = '73' AND entPhysicalIndex = '16'] SQL[UPDATE `entPhysical` set `entPhysicalIndex` ='16',`entPhysicalDescr` ='Ethernet Interface Port 07',`entPhysicalClass` ='port',`entPhysicalName` ='Gi0/7',`entPhysicalModelName` ='',`entPhysicalSerialNum` ='',`entPhysicalContainedIn` ='9',`entPhysicalMfgName` ='',`entPhysicalParentRelPos` ='7',`entPhysicalVendorType` ='zeroDotZero',`entPhysicalHardwareRev` ='',`entPhysicalFirmwareRev` ='',`entPhysicalSoftwareRev` ='',`entPhysicalIsFRU` ='false',`entPhysicalAlias` ='Slot0/7',`entPhysicalAssetID` ='' WHERE device_id='73' AND entPhysicalIndex='16'] .SQL[SELECT entPhysical_id FROM `entPhysical` WHERE device_id = '73' AND entPhysicalIndex = '17'] SQL[UPDATE `entPhysical` set `entPhysicalIndex` ='17',`entPhysicalDescr` ='Ethernet Interface Port 08',`entPhysicalClass` ='port',`entPhysicalName` ='Gi0/8',`entPhysicalModelName` ='',`entPhysicalSerialNum` ='',`entPhysicalContainedIn` ='9',`entPhysicalMfgName` ='',`entPhysicalParentRelPos` ='8',`entPhysicalVendorType` ='zeroDotZero',`entPhysicalHardwareRev` ='',`entPhysicalFirmwareRev` ='',`entPhysicalSoftwareRev` ='',`entPhysicalIsFRU` ='false',`entPhysicalAlias` ='Slot0/8',`entPhysicalAssetID` ='' WHERE device_id='73' AND entPhysicalIndex='17'] .SQL[SELECT entPhysical_id FROM `entPhysical` WHERE device_id = '73' AND entPhysicalIndex = '18'] SQL[UPDATE `entPhysical` set `entPhysicalIndex` ='18',`entPhysicalDescr` ='Ethernet Interface Port 09',`entPhysicalClass` ='port',`entPhysicalName` ='Gi0/9',`entPhysicalModelName` ='',`entPhysicalSerialNum` ='',`entPhysicalContainedIn` ='9',`entPhysicalMfgName` ='',`entPhysicalParentRelPos` ='9',`entPhysicalVendorType` ='zeroDotZero',`entPhysicalHardwareRev` ='',`entPhysicalFirmwareRev` ='',`entPhysicalSoftwareRev` ='',`entPhysicalIsFRU` ='false',`entPhysicalAlias` ='Slot0/9',`entPhysicalAssetID` ='' WHERE device_id='73' AND entPhysicalIndex='18'] .SQL[SELECT entPhysical_id FROM `entPhysical` WHERE device_id = '73' AND entPhysicalIndex = '19'] SQL[UPDATE `entPhysical` set `entPhysicalIndex` ='19',`entPhysicalDescr` ='Ethernet Interface Port 10',`entPhysicalClass` ='port',`entPhysicalName` ='Gi0/10',`entPhysicalModelName` ='',`entPhysicalSerialNum` ='',`entPhysicalContainedIn` ='9',`entPhysicalMfgName` ='',`entPhysicalParentRelPos` ='10',`entPhysicalVendorType` ='zeroDotZero',`entPhysicalHardwareRev` ='',`entPhysicalFirmwareRev` ='',`entPhysicalSoftwareRev` ='',`entPhysicalIsFRU` ='false',`entPhysicalAlias` ='Slot0/10',`entPhysicalAssetID` ='' WHERE device_id='73' AND entPhysicalIndex='19'] . SQL[SELECT * FROM `entPhysical` WHERE `device_id` = '73'] >> Runtime for discovery module 'entity-physical': 5.5340 seconds with 9240 bytes >> SNMP: [1/3.22s] MySQL: [23/2.20s] RRD: [0/0.00s] #### Unload disco module entity-physical #### Modules status: Global- OS- Device Module [ entity-state ] disabled on os. Modules status: Global+ OS+ Device #### Load disco module processors #### No YAML Discovery data. Host Resources: SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m HOST-RESOURCES-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 hrProcessorLoad] UCD Resources: SQL[SELECT * FROM `devices` WHERE `device_id` = '73'] SQL[SELECT * FROM devices_attribs WHERE `device_id` = '73'] SQL[SELECT * FROM `vrf_lite_cisco` WHERE `device_id` = '73'] SNMP[/usr/bin/snmpget -v1 -c COMMUNITY -Ovq -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 .1.3.6.1.4.1.2021.11.11.0] SQL[SELECT * FROM `processors` WHERE `device_id`='73'] SQL[DELETE T FROM `processors` T LEFT JOIN `devices` ON `devices`.`device_id` = T.`device_id` WHERE `devices`.`device_id` IS NULL] >> Runtime for discovery module 'processors': 0.1370 seconds with 70384 bytes >> SNMP: [2/0.13s] MySQL: [5/0.01s] RRD: [0/0.00s] #### Unload disco module processors #### Modules status: Global+ OS+ Device #### Load disco module mempools #### SQL[SELECT COUNT(*) FROM `mempools` WHERE `device_id` = '73' AND `mempool_type` = 'cemp'] SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m NETSWITCH-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/hp -t 1 -r 2 udp:HOSTNAME:161 hpLocal] SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m NETSWITCH-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/hp -t 1 -r 2 udp:HOSTNAME:161 hpGlobal] SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES:NetWare-Host-Ext-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 hrStorageEntry] SQL[SELECT * FROM `mempools` WHERE `device_id` = '73'] >> Runtime for discovery module 'mempools': 0.1450 seconds with 43416 bytes >> SNMP: [3/0.14s] MySQL: [2/0.00s] RRD: [0/0.00s] #### Unload disco module mempools #### Modules status: Global+ OS+ Device #### Load disco module cisco-vrf-lite #### SQL[SELECT * FROM vrf_lite_cisco WHERE device_id = '73' ] >> Runtime for discovery module 'cisco-vrf-lite': 0.0000 seconds with 2696 bytes >> SNMP: [0/0.00s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload disco module cisco-vrf-lite #### Modules status: Global- OS- Device Module [ cisco-mac-accounting ] disabled on os. Modules status: Global- OS- Device Module [ cisco-pw ] disabled on os. Modules status: Global- OS- Device Module [ vrf ] disabled on os. Modules status: Global- OS- Device Module [ cisco-cef ] disabled on os. Modules status: Global- OS- Device Module [ cisco-sla ] disabled on os. Modules status: Global- OS- Device Module [ cisco-cbqos ] disabled on os. Modules status: Global- OS- Device Module [ cisco-otv ] disabled on os. Modules status: Global+ OS+ Device #### Load disco module ipv4-addresses #### SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -Osq -m IP-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 ipAdEntIfIndex] ipAdEntIfIndex.* 22 SNMP[/usr/bin/snmpget -v1 -c COMMUNITY -Oqv -m IP-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 ipAdEntNetMask.10.1.26.3] * SQL[SELECT COUNT(*) FROM `ports` WHERE device_id = '73' AND `ifIndex` = '22'] SQL[SELECT `port_id` FROM `ports` WHERE `device_id` = '73' AND `ifIndex` = '22'] SQL[SELECT COUNT(*) FROM `ipv4_networks` WHERE `ipv4_network` = '10.1.26.3/24'] SQL[UPDATE `ipv4_networks` set `context_name` ='' WHERE `ipv4_network` = '10.1.26.3/24'] sSQL[SELECT `ipv4_network_id` FROM `ipv4_networks` WHERE `ipv4_network` = '10.1.26.3/24'] SQL[SELECT COUNT(*) FROM `ipv4_addresses` WHERE `ipv4_address` = '10.1.26.3' AND `ipv4_prefixlen` = '24' AND `port_id` = '1132' ] SQL[UPDATE `ipv4_addresses` set `context_name` ='' WHERE `ipv4_address` = '10.1.26.3' AND `ipv4_prefixlen` = '24' AND `port_id` = '1132'] .SQL[SELECT `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 = '73' OR `ports`.`device_id` IS NULL] >> Runtime for discovery module 'ipv4-addresses': 0.4090 seconds with 34872 bytes >> SNMP: [2/0.07s] MySQL: [8/0.34s] RRD: [0/0.00s] #### Unload disco module ipv4-addresses #### Modules status: Global+ OS+ Device #### Load disco module ipv6-addresses #### SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -Ln -Osq -m IP-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 ipAddressIfIndex.ipv6] SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -Ln -Osq -OnU -m IPV6-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 ipv6AddrPfxLength] SQL[SELECT `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 = '73' OR `ports`.`device_id` IS NULL] >> Runtime for discovery module 'ipv6-addresses': 0.1010 seconds with 3432 bytes >> SNMP: [2/0.10s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload disco module ipv6-addresses #### Modules status: Global- OS- Device Module [ route ] disabled on os. Modules status: Global+ OS+ Device #### Load disco module sensors #### ENTITY-SENSOR: Caching OIDs: entPhysicalDescrSNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m CISCO-ENTITY-SENSOR-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 entPhysicalDescr] entPhysicalDescr.1 = Network Element entPhysicalDescr.2 = entPhysicalDescr.3 = entPhysicalDescr.4 = entPhysicalDescr.5 = entPhysicalDescr.6 = entPhysicalDescr.7 = entPhysicalDescr.8 = entPhysicalDescr.9 = entPhysicalDescr.10 = Ethernet Interface Port 01 entPhysicalDescr.11 = Ethernet Interface Port 02 entPhysicalDescr.12 = Ethernet Interface Port 03 entPhysicalDescr.13 = Ethernet Interface Port 04 entPhysicalDescr.14 = Ethernet Interface Port 05 entPhysicalDescr.15 = Ethernet Interface Port 06 entPhysicalDescr.16 = Ethernet Interface Port 07 entPhysicalDescr.17 = Ethernet Interface Port 08 entPhysicalDescr.18 = Ethernet Interface Port 09 entPhysicalDescr.19 = Ethernet Interface Port 10 entPhysicalNameSNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m CISCO-ENTITY-SENSOR-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 entPhysicalName] entPhysicalName.1 = ISS entPhysicalName.2 = entPhysicalName.3 = entPhysicalName.4 = entPhysicalName.5 = entPhysicalName.6 = entPhysicalName.7 = entPhysicalName.8 = entPhysicalName.9 = entPhysicalName.10 = Gi0/4 entPhysicalName.11 = Gi0/2 entPhysicalName.12 = Gi0/3 entPhysicalName.13 = Gi0/1 entPhysicalName.14 = Gi0/5 entPhysicalName.15 = Gi0/6 entPhysicalName.16 = Gi0/7 entPhysicalName.17 = Gi0/8 entPhysicalName.18 = Gi0/9 entPhysicalName.19 = Gi0/10 entPhySensorTypeSNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m ENTITY-SENSOR-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 entPhySensorType] entPhySensorScaleSNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m ENTITY-SENSOR-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 entPhySensorScale] entPhySensorPrecisionSNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m ENTITY-SENSOR-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 entPhySensorPrecision] entPhySensorValueSNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m ENTITY-SENSOR-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 entPhySensorValue] SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = '73' AND `attrib_type` = 'ipmi_hostname' ] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='voltage' AND S.device_id = D.device_id AND D.device_id = '73' AND S.poller_type = 'ipmi'] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='temperature' AND S.device_id = D.device_id AND D.device_id = '73' AND S.poller_type = 'ipmi'] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='fanspeed' AND S.device_id = D.device_id AND D.device_id = '73' AND S.poller_type = 'ipmi'] SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='power' AND S.device_id = D.device_id AND D.device_id = '73' AND S.poller_type = 'ipmi'] Airflow: SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='airflow' AND S.device_id = D.device_id AND D.device_id = '73' AND S.poller_type = 'snmp'] Current: SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='current' AND S.device_id = D.device_id AND D.device_id = '73' AND S.poller_type = 'snmp'] Charge: SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='charge' AND S.device_id = D.device_id AND D.device_id = '73' AND S.poller_type = 'snmp'] Dbm: SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='dbm' AND S.device_id = D.device_id AND D.device_id = '73' AND S.poller_type = 'snmp'] Fanspeed: SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='fanspeed' AND S.device_id = D.device_id AND D.device_id = '73' AND S.poller_type = 'snmp'] Frequency: SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='frequency' AND S.device_id = D.device_id AND D.device_id = '73' AND S.poller_type = 'snmp'] Humidity: SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='humidity' AND S.device_id = D.device_id AND D.device_id = '73' AND S.poller_type = 'snmp'] Load: SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='load' AND S.device_id = D.device_id AND D.device_id = '73' AND S.poller_type = 'snmp'] Power: SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='power' AND S.device_id = D.device_id AND D.device_id = '73' AND S.poller_type = 'snmp'] Runtime: SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='runtime' AND S.device_id = D.device_id AND D.device_id = '73' AND S.poller_type = 'snmp'] Signal: SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='signal' AND S.device_id = D.device_id AND D.device_id = '73' AND S.poller_type = 'snmp'] State: SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='state' AND S.device_id = D.device_id AND D.device_id = '73' AND S.poller_type = 'snmp'] Temperature: SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='temperature' AND S.device_id = D.device_id AND D.device_id = '73' AND S.poller_type = 'snmp'] Voltage: SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='voltage' AND S.device_id = D.device_id AND D.device_id = '73' AND S.poller_type = 'snmp'] Snr: SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='snr' AND S.device_id = D.device_id AND D.device_id = '73' AND S.poller_type = 'snmp'] Pressure: SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='pressure' AND S.device_id = D.device_id AND D.device_id = '73' AND S.poller_type = 'snmp'] Cooling: SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='cooling' AND S.device_id = D.device_id AND D.device_id = '73' AND S.poller_type = 'snmp'] Delay: SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='delay' AND S.device_id = D.device_id AND D.device_id = '73' AND S.poller_type = 'snmp'] Quality_factor: SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='quality_factor' AND S.device_id = D.device_id AND D.device_id = '73' AND S.poller_type = 'snmp'] Chromatic_dispersion: SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='chromatic_dispersion' AND S.device_id = D.device_id AND D.device_id = '73' AND S.poller_type = 'snmp'] Ber: SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='ber' AND S.device_id = D.device_id AND D.device_id = '73' AND S.poller_type = 'snmp'] Eer: SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='eer' AND S.device_id = D.device_id AND D.device_id = '73' AND S.poller_type = 'snmp'] Waterflow: SQL[SELECT * FROM sensors AS S, devices AS D WHERE S.sensor_class='waterflow' AND S.device_id = D.device_id AND D.device_id = '73' AND S.poller_type = 'snmp'] >> Runtime for discovery module 'sensors': 0.5120 seconds with 67168 bytes >> SNMP: [6/0.48s] MySQL: [28/0.02s] RRD: [0/0.00s] #### Unload disco module sensors #### Modules status: Global+ OS+ Device #### Load disco module storage #### SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m EQLVOLUME-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/equallogic -t 1 -r 2 udp:HOSTNAME:161 EqliscsiVolumeEntry] SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUsetX -m CPQHOST-MIB -M /opt/librenms/mibs:/opt/librenms/mibs/hp -t 1 -r 2 udp:HOSTNAME:161 cpqHoFileSysEntry] HPE ILO4 SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES:NetWare-Host-Ext-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 hrStorageEntry] SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m NETAPP-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 dfEntry] SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m UCD-SNMP-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 dskTable] SQL[SELECT `storage_descr` FROM `storage` WHERE `device_id` = '73' AND `storage_type` != 'dsk'] SQL[SELECT * FROM `storage` WHERE `device_id` = '73'] >> Runtime for discovery module 'storage': 0.2750 seconds with 6688 bytes >> SNMP: [4/0.23s] MySQL: [2/0.00s] RRD: [0/0.00s] #### Unload disco module storage #### Modules status: Global+ OS+ Device #### Load disco module hr-device #### SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 hrDeviceEntry] SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m HOST-RESOURCES-MIB:HOST-RESOURCES-TYPES -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 hrProcessorEntry] Array ( ) SQL[SELECT * FROM `hrDevice` WHERE `device_id` = '73'] >> Runtime for discovery module 'hr-device': 0.0680 seconds with 3704 bytes >> SNMP: [2/0.07s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload disco module hr-device #### Modules status: Global+ OS+ Device #### Load disco module discovery-protocols #### CISCO-CDP-MIB: OSPF Discovery: SQL[SELECT DISTINCT(`ospfNbrIpAddr`),`device_id` FROM `ospf_nbrs` WHERE `device_id`='73'] SQL[SELECT * FROM `links` AS L, `ports` AS I WHERE L.local_port_id = I.port_id AND I.device_id = '73'] SQL[DELETE T FROM `links` T LEFT JOIN `devices` ON `devices`.`device_id` = T.`local_device_id` WHERE `devices`.`device_id` IS NULL] 0 orphaned links deleted >> Runtime for discovery module 'discovery-protocols': 0.0030 seconds with 4752 bytes >> SNMP: [0/0.00s] MySQL: [3/0.00s] RRD: [0/0.00s] #### Unload disco module discovery-protocols #### Modules status: Global+ OS+ Device #### Load disco module arp-table #### SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUsetX -m IP-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 ipNetToPhysicalPhysAddress] ipNetToPhysicalPhysAddress[22][ipv4]["*"] = c0:62:6b:aa:64:46 SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUsetX -m IP-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 ipNetToMediaPhysAddress] ipNetToMediaPhysAddress[22][*] = c0:62:6b:aa:64:46 SQL[SELECT * from `ipv4_mac` WHERE `device_id`='73' AND `context_name`=''] SQL[SELECT * FROM `ports` WHERE `device_id` = '73' AND `ifIndex` = '22'] vlan260: c0:62:6b:aa:64:46 => 10.1.26.1 SQL[DELETE 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] >> Runtime for discovery module 'arp-table': 0.3060 seconds with 17808 bytes >> SNMP: [0/0.00s] MySQL: [3/0.24s] RRD: [0/0.00s] #### Unload disco module arp-table #### Modules status: Global- OS- Device Module [ discovery-arp ] disabled on os. Modules status: Global- OS- Device Module [ junose-atm-vp ] disabled on os. Modules status: Global+ OS+ Device #### Load disco module bgp-peers #### SNMP[/usr/bin/snmpgetnext -v1 -c COMMUNITY -Oqvn -m BGP4-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 bgpLocalAs] 0 AS0 SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -Oq -m BGP4-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 bgpPeerRemoteAs] Peers : SQL[DELETE FROM `bgpPeers` WHERE device_id='73' AND context_name=''] SQL[DELETE FROM `bgpPeers_cbgp` WHERE device_id='73' AND context_name=''] SQL[SELECT DISTINCT context_name FROM bgpPeers WHERE device_id='73'] >> Runtime for discovery module 'bgp-peers': 0.0640 seconds with 5456 bytes >> SNMP: [2/0.06s] MySQL: [3/0.00s] RRD: [0/0.00s] #### Unload disco module bgp-peers #### Modules status: Global+ OS+ Device #### Load disco module vlans #### SQL[SELECT * FROM `vlans` WHERE `device_id` = '73'] SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m BRIDGE-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 dot1dBasePortIfIndex] 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 IEEE8021-Q-BRIDGE-MIB VLANs: SNMP[/usr/bin/snmpget -v1 -c COMMUNITY -Oqv -m IEEE8021-Q-BRIDGE-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 dot1qVlanVersionNumber.0] version1 ver version1 SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m Q-BRIDGE-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 dot1qVlanStaticName] dot1qVlanStaticName.1 = dot1qVlanStaticName.15 = VLAN 15 dot1qVlanStaticName.25 = VLAN 25 dot1qVlanStaticName.260 = data-pavlovce SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs --hexOutputLength=0 -m Q-BRIDGE-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 dot1qVlanCurrentEgressPorts] dot1qVlanCurrentEgressPorts.1600.1 = "AE 80 00 00 " dot1qVlanCurrentEgressPorts.1600.260 = "AE 80 00 00 " dot1qVlanCurrentEgressPorts.51500.15 = "2E 80 00 00 " dot1qVlanCurrentEgressPorts.52700.25 = "2E 80 00 00 " SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs --hexOutputLength=0 -m Q-BRIDGE-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 dot1qVlanCurrentUntaggedPorts] dot1qVlanCurrentUntaggedPorts.1600.1 = "80 00 00 00 " dot1qVlanCurrentUntaggedPorts.1600.260 = "AE 80 00 00 " dot1qVlanCurrentUntaggedPorts.51500.15 = "00 00 00 00 " dot1qVlanCurrentUntaggedPorts.52700.25 = "00 00 00 00 " 1. 15. 25. 260. VLAN 1 VLAN 15 VLAN 25 VLAN 260 >> Runtime for discovery module 'vlans': 0.3160 seconds with 16392 bytes >> SNMP: [5/0.31s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload disco module vlans #### Modules status: Global- OS- Device Module [ vmware-vminfo ] disabled on os. Modules status: Global- OS- Device Module [ libvirt-vminfo ] disabled on os. Modules status: Global- OS- Device Module [ toner ] disabled on os. Modules status: Global+ OS+ Device #### Load disco module ucd-diskio #### SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m UCD-DISKIO-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 diskIOEntry] Array ( ) SQL[SELECT * FROM `ucd_diskio` where `device_id` = '73'] >> Runtime for discovery module 'ucd-diskio': 0.0430 seconds with 3120 bytes >> SNMP: [1/0.04s] MySQL: [1/0.00s] RRD: [0/0.00s] #### Unload disco module ucd-diskio #### Modules status: Global- OS- Device Module [ applications ] disabled on os. Modules status: Global+ OS+ Device #### Load disco module services #### >> Runtime for discovery module 'services': 0.0000 seconds with 328 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload disco module services #### Modules status: Global+ OS+ Device #### Load disco module stp #### SQL[SELECT * FROM `stp` WHERE `device_id` = '73'] SNMP[/usr/bin/snmpget -v1 -c COMMUNITY -Oqv -m RSTP-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 dot1dStpProtocolSpecification.0] ieee8021d SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUs -m RSTP-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 dot1dStp] dot1dStpProtocolSpecification.0 = ieee8021d dot1dStpPriority.0 = 0 dot1dStpTimeSinceTopologyChange.0 = 0:0:00:00.00 dot1dStpTopChanges.0 = 0 dot1dStpDesignatedRoot.0 = "00 00 00 00 00 00 00 00 " dot1dStpRootCost.0 = 0 dot1dStpRootPort.0 = 0 dot1dStpMaxAge.0 = 2000 dot1dStpHelloTime.0 = 200 dot1dStpHoldTime.0 = 100 dot1dStpForwardDelay.0 = 1500 dot1dStpBridgeMaxAge.0 = 2000 dot1dStpBridgeHelloTime.0 = 200 dot1dStpBridgeForwardDelay.0 = 1500 dot1dStpVersion.0 = rstp dot1dStpTxHoldCount.0 = 6 SNMP[/usr/bin/snmpget -v1 -c COMMUNITY -Oqv -m RSTP-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 dot1dBaseBridgeAddress.0] 0:b0:ac:e:34:b9 SNMP[/usr/bin/snmpget -v1 -c COMMUNITY -Ovt -m RSTP-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 dot1dStpTimeSinceTopologyChange.0] 0 Array ( [protocolSpecification] => ieee8021d [priority] => 0 [topChanges] => 0 [rootCost] => 0 [rootPort] => 0 [maxAge] => 20 [helloTime] => 2 [holdTime] => 1 [forwardDelay] => 15 [bridgeMaxAge] => 20 [bridgeHelloTime] => 2 [bridgeForwardDelay] => 15 [device_id] => 73 [timeSinceTopologyChange] => 0 [designatedRoot] => 000000000000 [bridgeAddress] => 00b0ac0e34b9 [rootBridge] => 0 ) STP SQL[SELECT * FROM `ports_stp` WHERE `device_id` = '73'] >> Runtime for discovery module 'stp': 0.2580 seconds with 8712 bytes >> SNMP: [4/0.25s] MySQL: [2/0.00s] RRD: [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 144 bytes >> SNMP: [0/0.00s] MySQL: [0/0.00s] RRD: [0/0.00s] #### Unload disco module ntp #### Modules status: Global- OS- Device Module [ loadbalancers ] disabled on os. Modules status: Global- OS- Device Module [ mef ] disabled on os. Modules status: Global+ OS+ Device #### Load disco module wireless #### SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`='73' AND `sensor_class`='ap-count'] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`='73' AND `sensor_class`='clients'] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`='73' AND `sensor_class`='quality'] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`='73' AND `sensor_class`='capacity'] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`='73' AND `sensor_class`='utilization'] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`='73' AND `sensor_class`='rate'] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`='73' AND `sensor_class`='ccq'] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`='73' AND `sensor_class`='snr'] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`='73' AND `sensor_class`='ssr'] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`='73' AND `sensor_class`='mse'] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`='73' AND `sensor_class`='rssi'] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`='73' AND `sensor_class`='power'] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`='73' AND `sensor_class`='noise-floor'] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`='73' AND `sensor_class`='errors'] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`='73' AND `sensor_class`='error-ratio'] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`='73' AND `sensor_class`='error-rate'] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`='73' AND `sensor_class`='frequency'] SQL[SELECT * FROM `wireless_sensors` WHERE `device_id`='73' AND `sensor_class`='distance'] >> Runtime for discovery module 'wireless': 0.0240 seconds with 186000 bytes >> SNMP: [0/0.00s] MySQL: [18/0.02s] RRD: [0/0.00s] #### Unload disco module wireless #### Modules status: Global+ OS+ Device #### Load disco module fdb-table #### SQL[SELECT `vlan_id`, `vlan_vlan` from `vlans` WHERE `device_id` = '73'] SQL[SELECT * FROM `ports_fdb` WHERE `device_id` = '73'] SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUsetX -m Q-BRIDGE-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 dot1qTpFdbPort] dot1qTpFdbPort[1][c0:62:6b:aa:64:9] = 3 dot1qTpFdbPort[15][0:13:c3:e9:72:c1] = 7 dot1qTpFdbPort[15][98:4b:e1:6f:74:6e] = 3 dot1qTpFdbPort[15][c0:62:6b:aa:64:9] = 3 dot1qTpFdbPort[25][0:13:c3:e9:72:c2] = 7 dot1qTpFdbPort[25][c0:62:6b:aa:64:9] = 3 dot1qTpFdbPort[25][e0:2f:6d:14:b5:ff] = 3 dot1qTpFdbPort[260][0:13:c3:e9:72:81] = 7 dot1qTpFdbPort[260][0:b0:ac:c:bf:7] = 3 dot1qTpFdbPort[260][c0:62:6b:aa:64:9] = 3 dot1qTpFdbPort[260][c0:62:6b:aa:64:46] = 3 Q-BRIDGE-MIB:SNMP[/usr/bin/snmpwalk -v1 -c COMMUNITY -OQUsetX -m BRIDGE-MIB -M /opt/librenms/mibs -t 1 -r 2 udp:HOSTNAME:161 dot1dBasePortIfIndex] 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 SQL[SELECT * FROM `ports` WHERE `device_id` = '73' AND `ifIndex` = '1'] SQL[SELECT * FROM `ports` WHERE `device_id` = '73' AND `ifIndex` = '2'] SQL[SELECT * FROM `ports` WHERE `device_id` = '73' AND `ifIndex` = '3'] SQL[SELECT * FROM `ports` WHERE `device_id` = '73' AND `ifIndex` = '4'] SQL[SELECT * FROM `ports` WHERE `device_id` = '73' AND `ifIndex` = '5'] SQL[SELECT * FROM `ports` WHERE `device_id` = '73' AND `ifIndex` = '6'] SQL[SELECT * FROM `ports` WHERE `device_id` = '73' AND `ifIndex` = '7'] SQL[SELECT * FROM `ports` WHERE `device_id` = '73' AND `ifIndex` = '8'] SQL[SELECT * FROM `ports` WHERE `device_id` = '73' AND `ifIndex` = '9'] SQL[SELECT * FROM `ports` WHERE `device_id` = '73' AND `ifIndex` = '10'] vlan 1 mac c0626baa6409 port (3) 1124 vlan 15 mac 0013c3e972c1 port (7) 1128 vlan 15 mac 984be16f746e port (3) 1124 vlan 15 mac c0626baa6409 port (3) 1124 vlan 25 mac 0013c3e972c2 port (7) 1128 vlan 25 mac c0626baa6409 port (3) 1124 vlan 25 mac e02f6d14b5ff port (3) 1124 vlan 260 mac 0013c3e97281 port (7) 1128 vlan 260 mac 00b0ac0cbf07 port (3) 1124 vlan 260 mac c0626baa6409 port (3) 1124 vlan 260 mac c0626baa6446 port (3) 1124 1: . 15: ... 25: ... 260: .... >> Runtime for discovery module 'fdb-table': 0.2400 seconds with 157616 bytes >> SNMP: [0/0.00s] MySQL: [12/0.01s] RRD: [0/0.00s] #### Unload disco module fdb-table #### SQL[SELECT attrib_value FROM devices_attribs WHERE `device_id` = '73' AND `attrib_type` = 'poll_mib' ] SQL[UPDATE `devices` set `last_discovered` =NOW(),`last_discovered_timetaken` ='10.401' WHERE `device_id` = '73'] Discovered in 10.401 seconds SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`,`poller`) VALUES ('discover','pavlovce-siae','1521189443.7313','45.62','1','librenms')] /opt/librenms/discovery.php pavlovce-siae 2018-03-16 09:38:09 - 1 devices discovered in 45.62 secs SNMP [46/5.78s]: Get[14/0.58s] Getnext[1/0.03s] Walk[31/5.17s] MySQL [128/3.43s]: Cell[20/0.02s] Row[16/0.02s] Rows[69/0.19s] Column[2/0.00s] Update[14/2.70s] Insert[2/0.35s] Delete[5/0.15s] RRD [0/0.00s]: Update[0/0.00s] Create [0/0.00s] Other[0/0.00s]