Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Brocade ICX IronWare Addresses and VLANs detection issue #856

Open
jimaraujo6786 opened this issue Feb 8, 2022 · 5 comments
Open

Brocade ICX IronWare Addresses and VLANs detection issue #856

jimaraujo6786 opened this issue Feb 8, 2022 · 5 comments
Assignees
@ollyg
Labels
assigned-to-project

Comments

@jimaraujo6786
Copy link

Expected Behavior

Brocade ICX IronWare VLAN and/or Addresses should appear within Netdisco GUI under said device.

Current Behavior

Brocade ICX7150 Switch running Layer3 firmare does not detect VLAN or Addresses correctly

Possible Solution

Steps to Reproduce (for bugs)

Standard discover-do command with debuging

  1. Standard discover-do command
  2. Device is detected correctly
  3. Information missing with discovery

Context

Discover Brocade Switch running IronWare

Your Environment

  • Netdisco version used: 2.52.1
  • SNMP::Info version used: 3.81
  • DB Schema: 70

Config info (deployment.yml)

  • tag: 'snmpv3_readonly2'
    user: snmpv3-user
    auth:
    pass: pass123
    proto: SHA
    priv:
    pass: pass123
    proto: AES

Device information

netdisco@toolbox01:~$ ~/bin/netdisco-do discover -d coresw01 -DIQ
[2365681] 2022-02-08 14:30:33 info App::Netdisco version 2.052001 loaded.
SELECT me.version, me.installed
FROM dbix_class_schema_versions me
WHERE 1 = 0
SELECT me.version
FROM dbix_class_schema_versions me
ORDER BY installed DESC
LIMIT '1'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE me.alias = '10.22.168.1' AND me.ip = '10.22.168.1'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime, me.contact, me.name, me.location, me.layers, me.num_ports, me.mac, me.serial, me.chassis_id, me.model, me.ps1_type, me.ps2_type, me.ps1_status, me.ps2_status, me.fan, me.slots, me.vendor, me.os, me.os_ver, me.log, me.snmp_ver, me.snmp_comm, me.snmp_class, me.snmp_engineid, me.vtp_domain, me.last_discover, me.last_macsuck, me.last_arpnip, me.is_pseudo, to_char( me.creation, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_discover, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_macsuck, 'YYYY-MM-DD HH24:MI' ), extract( epoch
FROM age( now( ), me.creation ) ), extract( epoch
FROM age( now( ), me.last_arpnip ) ), extract( epoch
FROM age( now( ), me.last_discover ) ), extract( epoch
FROM age( now( ), me.last_macsuck ) ), replace( age( timestamp 'epoch' + me.uptime / 100 * interval '1 second', timestamp '1970-01-01 00:00:00-00' ) ::text, 'mon', 'month' )
FROM device me
WHERE me.ip = '10.22.168.1'
[2365681] 2022-02-08 14:30:34 info discover: [10.22.168.1] started at Tue Feb 8 09:30:34 2022
[2365681] 2022-02-08 14:30:34 debug discover: running with timeout 600s
[2365681] 2022-02-08 14:30:34 debug => running workers for phase: check
[2365681] 2022-02-08 14:30:34 debug -> run worker check/base/0
[2365681] 2022-02-08 14:30:34 debug Discover is able to run.
[2365681] 2022-02-08 14:30:34 debug => running workers for phase: early
[2365681] 2022-02-08 14:30:34 debug -> run worker early/properties/100
[2365681] 2022-02-08 14:30:34 debug snmp reader cache warm: [10.22.168.1]
SELECT me.ip, me.snmp_comm_rw, me.snmp_auth_tag_read, me.snmp_auth_tag_write
FROM community me
WHERE me.ip = '10.22.168.1'
UPDATE community
SET snmp_auth_tag_read = NULL
WHERE ip = '10.22.168.1'
[2365681] 2022-02-08 14:30:34 debug [10.22.168.1:161] try_connect with ver: 3, class: SNMP::Info::Layer3::Foundry, comm:
SNMP::Info::_global uptime : DISMAN-EVENT-MIB::sysUpTimeInstance : .1.3.6.1.2.1.1.3.0
SNMP::Info::_global layers : SNMPv2-MIB::sysServices.0 : .1.3.6.1.2.1.1.7.0
SELECT me.ip, me.snmp_comm_rw, me.snmp_auth_tag_read, me.snmp_auth_tag_write
FROM community me
WHERE me.ip = '10.22.168.1'
UPDATE community
SET snmp_auth_tag_read = 'snmpv3_readonly2'
WHERE ip = '10.22.168.1'
SNMP::Info::_global description : SNMPv2-MIB::sysDescr.0 : .1.3.6.1.2.1.1.1.0
SNMP::Info::_global id : SNMPv2-MIB::sysObjectID.0 : .1.3.6.1.2.1.1.2.0
SNMP::Info 3.81
SNMP::Info::device_type() layers:00000110 id:1991 sysDescr:"Ruckus Wireless, Inc. ICX7150-C12-POE, IronWare Version 09.0.10T213 Compiled on Dec 1 2021 at 07:57:48 labeled as SPR09010"
SNMP::Info::_validate_autoload_method(vtp_d_name) Unable to resolve method.
SNMP::Info::_global name : SNMPv2-MIB::sysName.0 : .1.3.6.1.2.1.1.5.0
SNMP::Info::_global mac : IF-MIB::ifPhysAddress.1 : .1.3.6.1.2.1.2.2.1.6.1
SNMP::Info::_global ps1_type : FOUNDRY-SN-AGENT-MIB::snChasPwrSupplyDescription.1 : .1.3.6.1.4.1.1991.1.1.1.2.1.1.2.1
SNMP::Info::_validate_autoload_method(ps2_type) Unable to resolve method.
SNMP::Info::_global ps1_status : FOUNDRY-SN-AGENT-MIB::snChasPwrSupplyOperStatus.1 : .1.3.6.1.4.1.1991.1.1.1.2.1.1.3.1
SNMP::Info::_validate_autoload_method(ps2_status) Unable to resolve method.
SNMP::Info::_global fan : FOUNDRY-SN-AGENT-MIB::snChasFanOperStatus.1 : .1.3.6.1.4.1.1991.1.1.1.3.1.1.3.1
SNMP::Info::_global(fan) (genError) A general failure occured at /home/netdisco/perl5/lib/perl5/App/Netdisco/Worker/Plugin/Discover/Properties.pm line 45.
SNMP::Info::_validate_autoload_method(slots) Unable to resolve method.
SNMP::Info::_global img_ver : FOUNDRY-SN-AGENT-MIB::snAgImgVer.0 : .1.3.6.1.4.1.1991.1.1.2.1.11.0
SNMP::Info::_global ch_serial : FOUNDRY-SN-AGENT-MIB::snChasSerNum.0 : .1.3.6.1.4.1.1991.1.1.1.1.2.0
SNMP::Info::_global serial1 : CISCO-SMI::temporary.6.3.0 : .1.3.6.1.4.1.9.3.6.3.0
SNMP::Info::_global(serial1) NOSUCHOBJECT at /home/netdisco/perl5/lib/perl5/App/Netdisco/Worker/Plugin/Discover/Properties.pm line 50.
SNMP::Info::_global contact : SNMPv2-MIB::sysContact.0 : .1.3.6.1.2.1.1.4.0
SNMP::Info::_global location : SNMPv2-MIB::sysLocation.0 : .1.3.6.1.2.1.1.6.0
SNMP::Info::_global ports : IF-MIB::ifNumber.0 : .1.3.6.1.2.1.2.1.0
SNMP::Info::_global snmpEngineID : SNMP-FRAMEWORK-MIB::snmpEngineID.0 : .1.3.6.1.6.3.10.2.1.1.0
SNMP::Info::_global(snmpEngineID) NOSUCHOBJECT at /home/netdisco/perl5/lib/perl5/App/Netdisco/Worker/Plugin/Discover/Properties.pm line 59.
BEGIN WORK
UPDATE device
SET last_discover = now( ), uptime = '49827000'
WHERE ip = '10.22.168.1'
COMMIT
[2365681] 2022-02-08 14:30:36 debug -> run worker early/properties/100
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE me.alias = '10.22.168.1' AND me.ip = '10.22.168.1'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime, me.contact, me.name, me.location, me.layers, me.num_ports, me.mac, me.serial, me.chassis_id, me.model, me.ps1_type, me.ps2_type, me.ps1_status, me.ps2_status, me.fan, me.slots, me.vendor, me.os, me.os_ver, me.log, me.snmp_ver, me.snmp_comm, me.snmp_class, me.snmp_engineid, me.vtp_domain, me.last_discover, me.last_macsuck, me.last_arpnip, me.is_pseudo, to_char( me.creation, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_discover, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_macsuck, 'YYYY-MM-DD HH24:MI' ), extract( epoch
FROM age( now( ), me.creation ) ), extract( epoch
FROM age( now( ), me.last_arpnip ) ), extract( epoch
FROM age( now( ), me.last_discover ) ), extract( epoch
FROM age( now( ), me.last_macsuck ) ), replace( age( timestamp 'epoch' + me.uptime / 100 * interval '1 second', timestamp '1970-01-01 00:00:00-00' ) ::text, 'mon', 'month' )
FROM device me
WHERE me.ip = '10.22.168.1'
[2365681] 2022-02-08 14:30:36 debug [10.22.168.1] device - OK to continue discover
[2365681] 2022-02-08 14:30:36 debug -> run worker early/properties/100
SNMP::Info::_load_attr i_description : IF-MIB::ifDescr : .1.3.6.1.2.1.2.2.1.2
SNMP::Info::_load_attr i_index : IF-MIB::ifIndex : .1.3.6.1.2.1.2.2.1.1
SNMP::Info::_load_attr i_alias : IF-MIB::ifAlias : .1.3.6.1.2.1.31.1.1.1.18
SNMP::Info::_load_attr orig_i_name : IF-MIB::ifName : .1.3.6.1.2.1.31.1.1.1.1
[2365681] 2022-02-08 14:30:37 debug [10.22.168.1] device - OK to continue discover
[2365681] 2022-02-08 14:30:37 debug -> run worker early/properties/100
SNMP::Info::_load_attr old_ip_index : IP-MIB::ipAdEntIfIndex : .1.3.6.1.2.1.4.20.1.2
SNMP::Info::_load_attr new_ip_index : IP-MIB::ipAddressIfIndex : .1.3.6.1.2.1.4.34.1.3
SNMP::Info::_load_attr new_ip_type : IP-MIB::ipAddressType : .1.3.6.1.2.1.4.34.1.4
SNMP::Info::_load_attr old_ip_netmask : IP-MIB::ipAdEntNetMask : .1.3.6.1.2.1.4.20.1.3
SNMP::Info::_load_attr new_ip_prefix : IP-MIB::ipAddressPrefix : .1.3.6.1.2.1.4.34.1.5
SNMP::Info::_load_attr ip_addr6_index : IP-MIB::ipAddressIfIndex : .1.3.6.1.2.1.4.34.1.3
SNMP::Info::IPv6::ipv6_index: data comes from IP-MIB.
SNMP::Info::IPv6::ipv6_index: data comes from IP-MIB.
SNMP::Info::_load_attr ip_addr6_type : IP-MIB::ipAddressType : .1.3.6.1.2.1.4.34.1.4
SNMP::Info::IPv6::ipv6_type: data comes from IP-MIB.
SNMP::Info::_load_attr ip_addr6_pfx : IP-MIB::ipAddressPrefix : .1.3.6.1.2.1.4.34.1.5
SNMP::Info::IPv6::ipv6_addr_prefixlength: data comes from IP-MIB.
[2365681] 2022-02-08 14:30:37 debug resolving 0 aliases with max 50 outstanding requests
BEGIN WORK
DELETE FROM device_ip
WHERE ip = '10.22.168.1'
[2365681] 2022-02-08 14:30:37 debug [10.22.168.1] device - removed 1 aliases
SAVEPOINT savepoint_0
INSERT INTO device_ip( alias, dns, ip )
VALUES( ?, ?, ? ) : 'BULK_INSERT'
RELEASE SAVEPOINT savepoint_0
COMMIT
[2365681] 2022-02-08 14:30:37 debug [10.22.168.1] aliases - added 1 new aliases
[2365681] 2022-02-08 14:30:37 debug -> run worker early/properties/100
SNMP::Info::_load_attr i_type : IF-MIB::ifType : .1.3.6.1.2.1.2.2.1.3
SNMP::Info::_load_attr i_mtu : IF-MIB::ifMtu : .1.3.6.1.2.1.2.2.1.4
SNMP::Info::_load_attr orig_i_speed : IF-MIB::ifSpeed : .1.3.6.1.2.1.2.2.1.5
SNMP::Info::_load_attr i_speed_high : IF-MIB::ifHighSpeed : .1.3.6.1.2.1.31.1.1.1.15
SNMP::Info::_validate_autoload_method(i_speed_admin) Unable to resolve method.
SNMP::Info::_load_attr i_mac : IF-MIB::ifPhysAddress : .1.3.6.1.2.1.2.2.1.6
SNMP::Info::_load_attr i_up : IF-MIB::ifOperStatus : .1.3.6.1.2.1.2.2.1.8
SNMP::Info::_load_attr i_up_admin : IF-MIB::ifAdminStatus : .1.3.6.1.2.1.2.2.1.7
SNMP::Info::_load_attr sw_index : FOUNDRY-SN-SWITCH-GROUP-MIB::snSwPortIfIndex : .1.3.6.1.4.1.1991.1.1.3.3.1.1.38
SNMP::Info::_load_attr sw_duplex : FOUNDRY-SN-SWITCH-GROUP-MIB::snSwPortInfoChnMode : .1.3.6.1.4.1.1991.1.1.3.3.1.1.4
SNMP::Info::_validate_autoload_method(i_duplex_admin) Unable to resolve method.
SNMP::Info::_load_attr bp_index : BRIDGE-MIB::dot1dBasePortIfIndex : .1.3.6.1.2.1.17.1.4.1.2
SNMP::Info::_load_attr dot1dStpPortState : BRIDGE-MIB::dot1dStpPortState : .1.3.6.1.2.1.17.2.15.1.3
SNMP::Info::_load_attr qb_i_vlan : Q-BRIDGE-MIB::dot1qPvid : .1.3.6.1.2.1.17.7.1.4.5.1.1
SNMP::Info::_load_attr i_lastchange : IF-MIB::ifLastChange : .1.3.6.1.2.1.2.2.1.9
SNMP::Info::_load_attr snMSTrunkPortList : FOUNDRY-SN-SWITCH-GROUP-MIB::snMSTrunkPortList : .1.3.6.1.4.1.1991.1.1.3.6.2.1.2
SNMP::Info::_load_attr snSwPortIfIndex : FOUNDRY-SN-SWITCH-GROUP-MIB::snSwPortIfIndex : .1.3.6.1.4.1.1991.1.1.3.3.1.1.38
SNMP::Info::_global load_uptime : DISMAN-EVENT-MIB::sysUpTimeInstance : .1.3.6.1.2.1.1.3.0
SNMP::Info::_global snmpEngineTime : SNMP-FRAMEWORK-MIB::snmpEngineTime.0 : .1.3.6.1.6.3.10.2.1.3.0
SNMP::Info::_global(snmpEngineTime) NOSUCHOBJECT at /home/netdisco/perl5/lib/perl5/App/Netdisco/Worker/Plugin/Discover/Properties.pm line 214.
BEGIN WORK
DELETE FROM device_port_power
WHERE ip IN (
SELECT me.ip
FROM device_port me
WHERE me.ip = '10.22.168.1'
)
[2365681] 2022-02-08 14:30:39 debug [10.22.168.1] db/ports - removed 17 port entries from DevicePortPower
DELETE FROM device_port_properties
WHERE ip IN (
SELECT me.ip
FROM device_port me
WHERE me.ip = '10.22.168.1'
)
[2365681] 2022-02-08 14:30:39 debug [10.22.168.1] db/ports - removed 25 port entries from DevicePortProperties
DELETE FROM device_port_ssid
WHERE ip IN (
SELECT me.ip
FROM device_port me
WHERE me.ip = '10.22.168.1'
)
[2365681] 2022-02-08 14:30:39 debug [10.22.168.1] db/ports - removed 0 port entries from DevicePortSsid
DELETE FROM device_port_vlan
WHERE ip IN (
SELECT me.ip
FROM device_port me
WHERE me.ip = '10.22.168.1'
)
[2365681] 2022-02-08 14:30:39 debug [10.22.168.1] db/ports - removed 0 port entries from DevicePortVlan
DELETE FROM device_port_wireless
WHERE ip IN (
SELECT me.ip
FROM device_port me
WHERE me.ip = '10.22.168.1'
)
[2365681] 2022-02-08 14:30:39 debug [10.22.168.1] db/ports - removed 0 port entries from DevicePortWireless
DELETE FROM device_port
WHERE ip = '10.22.168.1'
[2365681] 2022-02-08 14:30:39 debug [10.22.168.1] interfaces - removed 25 interfaces
SAVEPOINT savepoint_0
INSERT INTO device_port( descr, duplex, duplex_admin, ip, is_master, lastchange, mac, mtu, name, port, pvid, slave_of, speed, speed_admin, stp, type, up, up_admin, vlan )
VALUES( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) : 'BULK_INSERT'
RELEASE SAVEPOINT savepoint_0
COMMIT
[2365681] 2022-02-08 14:30:39 debug [10.22.168.1] interfaces - added 25 new interfaces
[2365681] 2022-02-08 14:30:39 debug => running workers for phase: main
[2365681] 2022-02-08 14:30:39 debug -> run worker main/canonicalip/100
[2365681] 2022-02-08 14:30:39 debug -> run worker main/entities/100
SNMP::Info::_load_attr entPhysicalDescr : ENTITY-MIB::entPhysicalDescr : .1.3.6.1.2.1.47.1.1.1.1.2
SNMP::Info::_load_attr orig_e_descr : ENTITY-MIB::entPhysicalDescr : .1.3.6.1.2.1.47.1.1.1.1.2
SNMP::Info::_load_attr orig_e_type : ENTITY-MIB::entPhysicalVendorType : .1.3.6.1.2.1.47.1.1.1.1.3
SNMP::Info::_load_attr orig_e_parent : ENTITY-MIB::entPhysicalContainedIn : .1.3.6.1.2.1.47.1.1.1.1.4
SNMP::Info::_load_attr orig_e_name : ENTITY-MIB::entPhysicalName : .1.3.6.1.2.1.47.1.1.1.1.7
SNMP::Info::_load_attr orig_e_class : ENTITY-MIB::entPhysicalClass : .1.3.6.1.2.1.47.1.1.1.1.5
SNMP::Info::_load_attr orig_e_pos : ENTITY-MIB::entPhysicalParentRelPos : .1.3.6.1.2.1.47.1.1.1.1.6
SNMP::Info::_load_attr e_hwver : ENTITY-MIB::entPhysicalHardwareRev : .1.3.6.1.2.1.47.1.1.1.1.8
SNMP::Info::_load_attr e_fwver : ENTITY-MIB::entPhysicalFirmwareRev : .1.3.6.1.2.1.47.1.1.1.1.9
SNMP::Info::_load_attr e_swver : ENTITY-MIB::entPhysicalSoftwareRev : .1.3.6.1.2.1.47.1.1.1.1.10
SNMP::Info::_load_attr e_model : ENTITY-MIB::entPhysicalModelName : .1.3.6.1.2.1.47.1.1.1.1.13
SNMP::Info::_load_attr orig_e_serial : ENTITY-MIB::entPhysicalSerialNum : .1.3.6.1.2.1.47.1.1.1.1.11
SNMP::Info::_load_attr e_fru : ENTITY-MIB::entPhysicalIsFRU : .1.3.6.1.2.1.47.1.1.1.1.16
BEGIN WORK
DELETE FROM device_module
WHERE ip = '10.22.168.1'
[2365681] 2022-02-08 14:30:41 debug [10.22.168.1] modules - removed 58 chassis modules
SAVEPOINT savepoint_0
INSERT INTO device_module( class, description, fru, fw_ver, hw_ver, index, ip, last_discover, model, name, parent, pos, serial, sw_ver, type )
VALUES( ?, ?, ?, ?, ?, ?, ?, now( ), ?, ?, ?, ?, ?, ?, ? ) : 'BULK_INSERT'
RELEASE SAVEPOINT savepoint_0
COMMIT
[2365681] 2022-02-08 14:30:41 debug [10.22.168.1] modules - added 58 new chassis modules
[2365681] 2022-02-08 14:30:41 debug -> run worker main/neighbors/100
BEGIN WORK
UPDATE device_port
SET manual_topo = false
WHERE ip = '10.22.168.1'
DELETE FROM topology
WHERE ( dev1 = '10.22.168.1' AND port1 NOT IN (
SELECT me.port
FROM device_port me
WHERE me.ip = '10.22.168.1'
) ) OR ( dev2 = '10.22.168.1' AND port2 NOT IN (
SELECT me.port
FROM device_port me
WHERE me.ip = '10.22.168.1'
) )
[2365681] 2022-02-08 14:30:41 debug [10.22.168.1] neigh - removed 0 outdated manual topology links
[2365681] 2022-02-08 14:30:41 debug [10.22.168.1] neigh - setting manual topology links
SELECT me.dev1, me.port1, me.dev2, me.port2
FROM topology me
WHERE dev1 = '10.22.168.1' OR dev2 = '10.22.168.1'
COMMIT
SNMP::Info::_global lldp_sys_cap : LLDP-MIB::lldpLocSysCapEnabled.0 : .1.0.8802.1.1.2.1.3.6.0
SNMP::Info::_validate_autoload_method(hasCDP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasSONMP) Unable to resolve method.
SNMP::Info::_global orig_fdp_run : FOUNDRY-SN-SWITCH-GROUP-MIB::snFdpGlobalRun.0 : .1.3.6.1.4.1.1991.1.1.3.20.1.3.1.0
SNMP::Info::_validate_autoload_method(hasEDP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasAMAP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasCDP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasSONMP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasEDP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasAMAP) Unable to resolve method.
SNMP::Info::_load_attr lldp_rem_pid : LLDP-MIB::lldpRemPortId : .1.0.8802.1.1.2.1.4.1.1.7
SNMP::Info::_load_attr lldp_lport_desc : LLDP-MIB::lldpLocPortDesc(1) : .1.0.8802.1.1.2.1.3.7.1.4.1
SNMP::Info::_load_attr lldp_lport_desc : LLDP-MIB::lldpLocPortDesc(6) : .1.0.8802.1.1.2.1.3.7.1.4.6
SNMP::Info::_load_attr lldp_lport_desc : LLDP-MIB::lldpLocPortDesc(12) : .1.0.8802.1.1.2.1.3.7.1.4.12
SNMP::Info::_load_attr lldp_lport_desc : LLDP-MIB::lldpLocPortDesc(1) : .1.0.8802.1.1.2.1.3.7.1.4.1
SNMP::Info::_load_attr lldp_lport_desc : LLDP-MIB::lldpLocPortDesc(5) : .1.0.8802.1.1.2.1.3.7.1.4.5
SNMP::Info::_load_attr lldp_lport_desc : LLDP-MIB::lldpLocPortDesc(10) : .1.0.8802.1.1.2.1.3.7.1.4.10
SNMP::Info::_load_attr lldp_lport_desc : LLDP-MIB::lldpLocPortDesc(11) : .1.0.8802.1.1.2.1.3.7.1.4.11
SNMP::Info::_load_attr lldp_lport_desc : LLDP-MIB::lldpLocPortDesc(3) : .1.0.8802.1.1.2.1.3.7.1.4.3
SNMP::Info::_load_attr lldp_lport_desc : LLDP-MIB::lldpLocPortDesc(10) : .1.0.8802.1.1.2.1.3.7.1.4.10
SNMP::Info::_load_attr lldp_lport_desc : LLDP-MIB::lldpLocPortDesc(4) : .1.0.8802.1.1.2.1.3.7.1.4.4
SNMP::Info::_load_attr lldp_lport_desc : LLDP-MIB::lldpLocPortDesc(2) : .1.0.8802.1.1.2.1.3.7.1.4.2
SNMP::Info::_load_attr lldp_lport_desc : LLDP-MIB::lldpLocPortDesc(130) : .1.0.8802.1.1.2.1.3.7.1.4.130
SNMP::Info::_load_attr lldp_lport_desc : LLDP-MIB::lldpLocPortDesc(130) : .1.0.8802.1.1.2.1.3.7.1.4.130
SNMP::Info::_load_attr fdp_ip : FOUNDRY-SN-SWITCH-GROUP-MIB::snFdpCacheAddress : .1.3.6.1.4.1.1991.1.1.3.20.1.2.1.1.5
SNMP::Info::_validate_autoload_method(hasCDP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasSONMP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasEDP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasAMAP) Unable to resolve method.
SNMP::Info::_load_attr lldp_rem_desc : LLDP-MIB::lldpRemPortDesc : .1.0.8802.1.1.2.1.4.1.1.8
SNMP::Info::_load_attr lldp_rem_pid_type : LLDP-MIB::lldpRemPortIdSubtype : .1.0.8802.1.1.2.1.4.1.1.6
SNMP::Info::_load_attr lldp_rem_sysdesc : LLDP-MIB::lldpRemSysDesc : .1.0.8802.1.1.2.1.4.1.1.10
SNMP::Info::_load_attr fdp_port : FOUNDRY-SN-SWITCH-GROUP-MIB::snFdpCacheDevicePort : .1.3.6.1.4.1.1991.1.1.3.20.1.2.1.1.7
SNMP::Info::_validate_autoload_method(hasCDP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasSONMP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasEDP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasAMAP) Unable to resolve method.
SNMP::Info::_load_attr lldp_rem_id_type : LLDP-MIB::lldpRemChassisIdSubtype : .1.0.8802.1.1.2.1.4.1.1.4
SNMP::Info::_load_attr lldp_rem_id : LLDP-MIB::lldpRemChassisId : .1.0.8802.1.1.2.1.4.1.1.5
SNMP::Info::_load_attr fdp_id : FOUNDRY-SN-SWITCH-GROUP-MIB::snFdpCacheDeviceId : .1.3.6.1.4.1.1991.1.1.3.20.1.2.1.1.3
SNMP::Info::_validate_autoload_method(hasCDP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasSONMP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasEDP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasAMAP) Unable to resolve method.
SNMP::Info::_load_attr lldp_rem_sysname : LLDP-MIB::lldpRemSysName : .1.0.8802.1.1.2.1.4.1.1.9
SNMP::Info::_load_attr fdp_platform : FOUNDRY-SN-SWITCH-GROUP-MIB::snFdpCachePlatform : .1.3.6.1.4.1.1991.1.1.3.20.1.2.1.1.8
SNMP::Info::_validate_autoload_method(hasCDP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasSONMP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasEDP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasAMAP) Unable to resolve method.
SNMP::Info::_load_attr lldp_rem_cap_spt : LLDP-MIB::lldpRemSysCapSupported : .1.0.8802.1.1.2.1.4.1.1.11
SNMP::Info::_validate_autoload_method(fdp_cap) Unable to resolve method.
SELECT me.ip, me.port, me.creation, me.descr, me.up, me.up_admin, me.type, me.duplex, me.duplex_admin, me.speed, me.speed_admin, me.name, me.mac, me.mtu, me.stp, me.remote_ip, me.remote_port, me.remote_type, me.remote_id, me.is_master, me.slave_of, me.manual_topo, me.is_uplink, me.vlan, me.pvid, me.lastchange
FROM device_port me
WHERE me.ip = '10.22.168.1'
SNMP::Info::_validate_autoload_method(hasCDP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasSONMP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasEDP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasAMAP) Unable to resolve method.
SNMP::Info::load_attr lldp_rman_addr : LLDP-MIB::lldpRemManAddrIfSubtype : .1.0.8802.1.1.2.1.4.2.1.3
[2365681] 2022-02-08 14:30:42 debug [10.22.168.1] neigh - 10.22.135.157 with ID [10.22.135.157] on GigabitEthernet1/1/1
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE me.alias = '10.22.135.157' AND me.ip = '10.22.135.157'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE alias = '10.22.135.157'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime, me.contact, me.name, me.location, me.layers, me.num_ports, me.mac, me.serial, me.chassis_id, me.model, me.ps1_type, me.ps2_type, me.ps1_status, me.ps2_status, me.fan, me.slots, me.vendor, me.os, me.os_ver, me.log, me.snmp_ver, me.snmp_comm, me.snmp_class, me.snmp_engineid, me.vtp_domain, me.last_discover, me.last_macsuck, me.last_arpnip, me.is_pseudo, to_char( me.creation, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_discover, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_macsuck, 'YYYY-MM-DD HH24:MI' ), extract( epoch
FROM age( now( ), me.creation ) ), extract( epoch
FROM age( now( ), me.last_arpnip ) ), extract( epoch
FROM age( now( ), me.last_discover ) ), extract( epoch
FROM age( now( ), me.last_macsuck ) ), replace( age( timestamp 'epoch' + me.uptime / 100 * interval '1 second', timestamp '1970-01-01 00:00:00-00' ) ::text, 'mon', 'month' )
FROM device me
WHERE me.ip = '10.22.135.157'
[2365681] 2022-02-08 14:30:42 debug is_discoverable: 10.22.135.157 matches phone_platforms but discover_phones is not enabled
[2365681] 2022-02-08 14:30:42 debug [10.22.168.1] neigh - skip: 10.22.135.157 of type [Polycom;VVX-VVX_500;3111-44500-001,7;SIP/5.9.7.3480/02-Sep-21 13:32;UP/5.9.7.45784/02-Sep-21 13:56;] excluded by discover* config
UPDATE device_port
SET is_uplink = true, manual_topo = false, remote_id = '10.22.135.157', remote_ip = '10.22.135.157', remote_port = '1', remote_type = 'Polycom;VVX-VVX_500;3111-44500-001,7;SIP/5.9.7.3480/02-Sep-21 13:32;UP/5.9.7.45784/02-Sep-21 13:56;'
WHERE ip = '10.22.168.1' AND port = 'GigabitEthernet1/1/1'
SELECT me.ip, me.port, me.creation, me.descr, me.up, me.up_admin, me.type, me.duplex, me.duplex_admin, me.speed, me.speed_admin, me.name, me.mac, me.mtu, me.stp, me.remote_ip, me.remote_port, me.remote_type, me.remote_id, me.is_master, me.slave_of, me.manual_topo, me.is_uplink, me.vlan, me.pvid, me.lastchange
FROM device_port me
WHERE me.ip = '10.22.168.1' AND me.port = 'GigabitEthernet1/1/1'
[2365681] 2022-02-08 14:30:42 debug [10.22.168.1] neigh - 254.128.0.0 with ID [AtticAP-1] on GigabitEthernet1/1/11
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE me.alias = '254.128.0.0' AND me.ip = '254.128.0.0'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE alias = '254.128.0.0'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime, me.contact, me.name, me.location, me.layers, me.num_ports, me.mac, me.serial, me.chassis_id, me.model, me.ps1_type, me.ps2_type, me.ps1_status, me.ps2_status, me.fan, me.slots, me.vendor, me.os, me.os_ver, me.log, me.snmp_ver, me.snmp_comm, me.snmp_class, me.snmp_engineid, me.vtp_domain, me.last_discover, me.last_macsuck, me.last_arpnip, me.is_pseudo, to_char( me.creation, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_discover, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_macsuck, 'YYYY-MM-DD HH24:MI' ), extract( epoch
FROM age( now( ), me.creation ) ), extract( epoch
FROM age( now( ), me.last_arpnip ) ), extract( epoch
FROM age( now( ), me.last_discover ) ), extract( epoch
FROM age( now( ), me.last_macsuck ) ), replace( age( timestamp 'epoch' + me.uptime / 100 * interval '1 second', timestamp '1970-01-01 00:00:00-00' ) ::text, 'mon', 'month' )
FROM device me
WHERE me.ip = '254.128.0.0'
UPDATE device_port
SET is_uplink = true, manual_topo = false, remote_id = 'AtticAP-1', remote_ip = '254.128.0.0', remote_port = 'GigabitEthernet0', remote_type = 'cisco CBW240AC-B'
WHERE ip = '10.22.168.1' AND port = 'GigabitEthernet1/1/11'
SELECT me.ip, me.port, me.creation, me.descr, me.up, me.up_admin, me.type, me.duplex, me.duplex_admin, me.speed, me.speed_admin, me.name, me.mac, me.mtu, me.stp, me.remote_ip, me.remote_port, me.remote_type, me.remote_id, me.is_master, me.slave_of, me.manual_topo, me.is_uplink, me.vlan, me.pvid, me.lastchange
FROM device_port me
WHERE me.ip = '10.22.168.1' AND me.port = 'GigabitEthernet1/1/11'
[2365681] 2022-02-08 14:30:42 debug [10.22.168.1] neigh - 254.128.0.0 with ID [GarageAP-1] on GigabitEthernet1/1/12
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE me.alias = '254.128.0.0' AND me.ip = '254.128.0.0'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE alias = '254.128.0.0'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime, me.contact, me.name, me.location, me.layers, me.num_ports, me.mac, me.serial, me.chassis_id, me.model, me.ps1_type, me.ps2_type, me.ps1_status, me.ps2_status, me.fan, me.slots, me.vendor, me.os, me.os_ver, me.log, me.snmp_ver, me.snmp_comm, me.snmp_class, me.snmp_engineid, me.vtp_domain, me.last_discover, me.last_macsuck, me.last_arpnip, me.is_pseudo, to_char( me.creation, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_discover, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_macsuck, 'YYYY-MM-DD HH24:MI' ), extract( epoch
FROM age( now( ), me.creation ) ), extract( epoch
FROM age( now( ), me.last_arpnip ) ), extract( epoch
FROM age( now( ), me.last_discover ) ), extract( epoch
FROM age( now( ), me.last_macsuck ) ), replace( age( timestamp 'epoch' + me.uptime / 100 * interval '1 second', timestamp '1970-01-01 00:00:00-00' ) ::text, 'mon', 'month' )
FROM device me
WHERE me.ip = '254.128.0.0'
UPDATE device_port
SET is_uplink = true, manual_topo = false, remote_id = 'GarageAP-1', remote_ip = '254.128.0.0', remote_port = 'GigabitEthernet0', remote_type = 'cisco CBW240AC-B'
WHERE ip = '10.22.168.1' AND port = 'GigabitEthernet1/1/12'
SELECT me.ip, me.port, me.creation, me.descr, me.up, me.up_admin, me.type, me.duplex, me.duplex_admin, me.speed, me.speed_admin, me.name, me.mac, me.mtu, me.stp, me.remote_ip, me.remote_port, me.remote_type, me.remote_id, me.is_master, me.slave_of, me.manual_topo, me.is_uplink, me.vlan, me.pvid, me.lastchange
FROM device_port me
WHERE me.ip = '10.22.168.1' AND me.port = 'GigabitEthernet1/1/12'
[2365681] 2022-02-08 14:30:42 debug [10.22.168.1] neigh - 10.22.168.159 with ID [ise27] on 10GigabitEthernet1/3/2
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE me.alias = '10.22.168.159' AND me.ip = '10.22.168.159'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime, me.contact, me.name, me.location, me.layers, me.num_ports, me.mac, me.serial, me.chassis_id, me.model, me.ps1_type, me.ps2_type, me.ps1_status, me.ps2_status, me.fan, me.slots, me.vendor, me.os, me.os_ver, me.log, me.snmp_ver, me.snmp_comm, me.snmp_class, me.snmp_engineid, me.vtp_domain, me.last_discover, me.last_macsuck, me.last_arpnip, me.is_pseudo, to_char( me.creation, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_discover, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_macsuck, 'YYYY-MM-DD HH24:MI' ), extract( epoch
FROM age( now( ), me.creation ) ), extract( epoch
FROM age( now( ), me.last_arpnip ) ), extract( epoch
FROM age( now( ), me.last_discover ) ), extract( epoch
FROM age( now( ), me.last_macsuck ) ), replace( age( timestamp 'epoch' + me.uptime / 100 * interval '1 second', timestamp '1970-01-01 00:00:00-00' ) ::text, 'mon', 'month' )
FROM device me
WHERE me.ip = '10.22.168.159'
UPDATE device_port
SET is_uplink = true, manual_topo = false, remote_id = 'ise27', remote_ip = '10.22.168.159', remote_port = 'eth0', remote_type = 'ISE-VM-K9'
WHERE ip = '10.22.168.1' AND port = '10GigabitEthernet1/3/2'
SELECT me.ip, me.port, me.creation, me.descr, me.up, me.up_admin, me.type, me.duplex, me.duplex_admin, me.speed, me.speed_admin, me.name, me.mac, me.mtu, me.stp, me.remote_ip, me.remote_port, me.remote_type, me.remote_id, me.is_master, me.slave_of, me.manual_topo, me.is_uplink, me.vlan, me.pvid, me.lastchange
FROM device_port me
WHERE me.ip = '10.22.168.1' AND me.port = '10GigabitEthernet1/3/2'
[2365681] 2022-02-08 14:30:42 debug [10.22.168.1] neigh - bad address 0.0.0.0 on port 10GigabitEthernet1/3/2, searching for hackthis.local instead
SELECT COUNT( * )
FROM device me
WHERE name = 'hackthis.local'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime, me.contact, me.name, me.location, me.layers, me.num_ports, me.mac, me.serial, me.chassis_id, me.model, me.ps1_type, me.ps2_type, me.ps1_status, me.ps2_status, me.fan, me.slots, me.vendor, me.os, me.os_ver, me.log, me.snmp_ver, me.snmp_comm, me.snmp_class, me.snmp_engineid, me.vtp_domain, me.last_discover, me.last_macsuck, me.last_arpnip, me.is_pseudo
FROM device me
WHERE name = 'hackthis.local'
[2365681] 2022-02-08 14:30:42 debug [10.22.168.1] neigh - found hackthis.local with IP 10.22.168.101
[2365681] 2022-02-08 14:30:42 debug [10.22.168.1] neigh - 10.22.168.101 with ID [hackthis.local] on 10GigabitEthernet1/3/2
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE me.alias = '10.22.168.101' AND me.ip = '10.22.168.101'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime, me.contact, me.name, me.location, me.layers, me.num_ports, me.mac, me.serial, me.chassis_id, me.model, me.ps1_type, me.ps2_type, me.ps1_status, me.ps2_status, me.fan, me.slots, me.vendor, me.os, me.os_ver, me.log, me.snmp_ver, me.snmp_comm, me.snmp_class, me.snmp_engineid, me.vtp_domain, me.last_discover, me.last_macsuck, me.last_arpnip, me.is_pseudo, to_char( me.creation, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_discover, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_macsuck, 'YYYY-MM-DD HH24:MI' ), extract( epoch
FROM age( now( ), me.creation ) ), extract( epoch
FROM age( now( ), me.last_arpnip ) ), extract( epoch
FROM age( now( ), me.last_discover ) ), extract( epoch
FROM age( now( ), me.last_macsuck ) ), replace( age( timestamp 'epoch' + me.uptime / 100 * interval '1 second', timestamp '1970-01-01 00:00:00-00' ) ::text, 'mon', 'month' )
FROM device me
WHERE me.ip = '10.22.168.101'
UPDATE device_port
SET is_uplink = true, manual_topo = false, remote_id = 'hackthis.local', remote_ip = '10.22.168.101', remote_port = 'vmnic6', remote_type = 'VMware ESXi'
WHERE ip = '10.22.168.1' AND port = '10GigabitEthernet1/3/2'
SELECT me.ip, me.port, me.creation, me.descr, me.up, me.up_admin, me.type, me.duplex, me.duplex_admin, me.speed, me.speed_admin, me.name, me.mac, me.mtu, me.stp, me.remote_ip, me.remote_port, me.remote_type, me.remote_id, me.is_master, me.slave_of, me.manual_topo, me.is_uplink, me.vlan, me.pvid, me.lastchange
FROM device_port me
WHERE me.ip = '10.22.168.1' AND me.port = '10GigabitEthernet1/3/2'
[2365681] 2022-02-08 14:30:42 debug [10.22.168.1] neigh - 10.22.135.150 with ID [SEP001BD5851FD3] on GigabitEthernet1/1/2
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE me.alias = '10.22.135.150' AND me.ip = '10.22.135.150'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE alias = '10.22.135.150'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime, me.contact, me.name, me.location, me.layers, me.num_ports, me.mac, me.serial, me.chassis_id, me.model, me.ps1_type, me.ps2_type, me.ps1_status, me.ps2_status, me.fan, me.slots, me.vendor, me.os, me.os_ver, me.log, me.snmp_ver, me.snmp_comm, me.snmp_class, me.snmp_engineid, me.vtp_domain, me.last_discover, me.last_macsuck, me.last_arpnip, me.is_pseudo, to_char( me.creation, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_discover, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_macsuck, 'YYYY-MM-DD HH24:MI' ), extract( epoch
FROM age( now( ), me.creation ) ), extract( epoch
FROM age( now( ), me.last_arpnip ) ), extract( epoch
FROM age( now( ), me.last_discover ) ), extract( epoch
FROM age( now( ), me.last_macsuck ) ), replace( age( timestamp 'epoch' + me.uptime / 100 * interval '1 second', timestamp '1970-01-01 00:00:00-00' ) ::text, 'mon', 'month' )
FROM device me
WHERE me.ip = '10.22.135.150'
UPDATE device_port
SET is_uplink = true, manual_topo = false, remote_id = 'SEP001BD5851FD3', remote_ip = '10.22.135.150', remote_port = 'Port 1', remote_type = 'Cisco IP Phone 7941'
WHERE ip = '10.22.168.1' AND port = 'GigabitEthernet1/1/2'
SELECT me.ip, me.port, me.creation, me.descr, me.up, me.up_admin, me.type, me.duplex, me.duplex_admin, me.speed, me.speed_admin, me.name, me.mac, me.mtu, me.stp, me.remote_ip, me.remote_port, me.remote_type, me.remote_id, me.is_master, me.slave_of, me.manual_topo, me.is_uplink, me.vlan, me.pvid, me.lastchange
FROM device_port me
WHERE me.ip = '10.22.168.1' AND me.port = 'GigabitEthernet1/1/2'
[2365681] 2022-02-08 14:30:42 debug [10.22.168.1] neigh - 254.128.0.0 with ID [KitchenAP-1] on GigabitEthernet1/1/3
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE me.alias = '254.128.0.0' AND me.ip = '254.128.0.0'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE alias = '254.128.0.0'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime, me.contact, me.name, me.location, me.layers, me.num_ports, me.mac, me.serial, me.chassis_id, me.model, me.ps1_type, me.ps2_type, me.ps1_status, me.ps2_status, me.fan, me.slots, me.vendor, me.os, me.os_ver, me.log, me.snmp_ver, me.snmp_comm, me.snmp_class, me.snmp_engineid, me.vtp_domain, me.last_discover, me.last_macsuck, me.last_arpnip, me.is_pseudo, to_char( me.creation, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_discover, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_macsuck, 'YYYY-MM-DD HH24:MI' ), extract( epoch
FROM age( now( ), me.creation ) ), extract( epoch
FROM age( now( ), me.last_arpnip ) ), extract( epoch
FROM age( now( ), me.last_discover ) ), extract( epoch
FROM age( now( ), me.last_macsuck ) ), replace( age( timestamp 'epoch' + me.uptime / 100 * interval '1 second', timestamp '1970-01-01 00:00:00-00' ) ::text, 'mon', 'month' )
FROM device me
WHERE me.ip = '254.128.0.0'
UPDATE device_port
SET is_uplink = true, manual_topo = false, remote_id = 'KitchenAP-1', remote_ip = '254.128.0.0', remote_port = 'GigabitEthernet0', remote_type = 'cisco CBW240AC-B'
WHERE ip = '10.22.168.1' AND port = 'GigabitEthernet1/1/3'
SELECT me.ip, me.port, me.creation, me.descr, me.up, me.up_admin, me.type, me.duplex, me.duplex_admin, me.speed, me.speed_admin, me.name, me.mac, me.mtu, me.stp, me.remote_ip, me.remote_port, me.remote_type, me.remote_id, me.is_master, me.slave_of, me.manual_topo, me.is_uplink, me.vlan, me.pvid, me.lastchange
FROM device_port me
WHERE me.ip = '10.22.168.1' AND me.port = 'GigabitEthernet1/1/3'
[2365681] 2022-02-08 14:30:42 debug [10.22.168.1] neigh - 10.22.135.158 with ID [SEP002414B3D417] on GigabitEthernet1/1/4
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE me.alias = '10.22.135.158' AND me.ip = '10.22.135.158'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE alias = '10.22.135.158'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime, me.contact, me.name, me.location, me.layers, me.num_ports, me.mac, me.serial, me.chassis_id, me.model, me.ps1_type, me.ps2_type, me.ps1_status, me.ps2_status, me.fan, me.slots, me.vendor, me.os, me.os_ver, me.log, me.snmp_ver, me.snmp_comm, me.snmp_class, me.snmp_engineid, me.vtp_domain, me.last_discover, me.last_macsuck, me.last_arpnip, me.is_pseudo, to_char( me.creation, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_discover, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_macsuck, 'YYYY-MM-DD HH24:MI' ), extract( epoch
FROM age( now( ), me.creation ) ), extract( epoch
FROM age( now( ), me.last_arpnip ) ), extract( epoch
FROM age( now( ), me.last_discover ) ), extract( epoch
FROM age( now( ), me.last_macsuck ) ), replace( age( timestamp 'epoch' + me.uptime / 100 * interval '1 second', timestamp '1970-01-01 00:00:00-00' ) ::text, 'mon', 'month' )
FROM device me
WHERE me.ip = '10.22.135.158'
UPDATE device_port
SET is_uplink = true, manual_topo = false, remote_id = 'SEP002414B3D417', remote_ip = '10.22.135.158', remote_port = 'Port 1', remote_type = 'Cisco IP Phone 7965'
WHERE ip = '10.22.168.1' AND port = 'GigabitEthernet1/1/4'
SELECT me.ip, me.port, me.creation, me.descr, me.up, me.up_admin, me.type, me.duplex, me.duplex_admin, me.speed, me.speed_admin, me.name, me.mac, me.mtu, me.stp, me.remote_ip, me.remote_port, me.remote_type, me.remote_id, me.is_master, me.slave_of, me.manual_topo, me.is_uplink, me.vlan, me.pvid, me.lastchange
FROM device_port me
WHERE me.ip = '10.22.168.1' AND me.port = 'GigabitEthernet1/1/4'
[2365681] 2022-02-08 14:30:42 debug [10.22.168.1] neigh - 10.22.135.156 with ID [SEP64AE0CF6789B] on GigabitEthernet1/1/5
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE me.alias = '10.22.135.156' AND me.ip = '10.22.135.156'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE alias = '10.22.135.156'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime, me.contact, me.name, me.location, me.layers, me.num_ports, me.mac, me.serial, me.chassis_id, me.model, me.ps1_type, me.ps2_type, me.ps1_status, me.ps2_status, me.fan, me.slots, me.vendor, me.os, me.os_ver, me.log, me.snmp_ver, me.snmp_comm, me.snmp_class, me.snmp_engineid, me.vtp_domain, me.last_discover, me.last_macsuck, me.last_arpnip, me.is_pseudo, to_char( me.creation, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_discover, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_macsuck, 'YYYY-MM-DD HH24:MI' ), extract( epoch
FROM age( now( ), me.creation ) ), extract( epoch
FROM age( now( ), me.last_arpnip ) ), extract( epoch
FROM age( now( ), me.last_discover ) ), extract( epoch
FROM age( now( ), me.last_macsuck ) ), replace( age( timestamp 'epoch' + me.uptime / 100 * interval '1 second', timestamp '1970-01-01 00:00:00-00' ) ::text, 'mon', 'month' )
FROM device me
WHERE me.ip = '10.22.135.156'
UPDATE device_port
SET is_uplink = true, manual_topo = false, remote_id = 'SEP64AE0CF6789B', remote_ip = '10.22.135.156', remote_port = 'Port 1', remote_type = 'Cisco IP Phone 7965'
WHERE ip = '10.22.168.1' AND port = 'GigabitEthernet1/1/5'
SELECT me.ip, me.port, me.creation, me.descr, me.up, me.up_admin, me.type, me.duplex, me.duplex_admin, me.speed, me.speed_admin, me.name, me.mac, me.mtu, me.stp, me.remote_ip, me.remote_port, me.remote_type, me.remote_id, me.is_master, me.slave_of, me.manual_topo, me.is_uplink, me.vlan, me.pvid, me.lastchange
FROM device_port me
WHERE me.ip = '10.22.168.1' AND me.port = 'GigabitEthernet1/1/5'
[2365681] 2022-02-08 14:30:42 debug [10.22.168.1] neigh - bad address 0.0.0.0 on port GigabitEthernet1/2/1, searching for hackthis.local instead
SELECT COUNT( * )
FROM device me
WHERE name = 'hackthis.local'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime, me.contact, me.name, me.location, me.layers, me.num_ports, me.mac, me.serial, me.chassis_id, me.model, me.ps1_type, me.ps2_type, me.ps1_status, me.ps2_status, me.fan, me.slots, me.vendor, me.os, me.os_ver, me.log, me.snmp_ver, me.snmp_comm, me.snmp_class, me.snmp_engineid, me.vtp_domain, me.last_discover, me.last_macsuck, me.last_arpnip, me.is_pseudo
FROM device me
WHERE name = 'hackthis.local'
[2365681] 2022-02-08 14:30:42 debug [10.22.168.1] neigh - found hackthis.local with IP 10.22.168.101
[2365681] 2022-02-08 14:30:42 debug [10.22.168.1] neigh - 10.22.168.101 with ID [hackthis.local] on GigabitEthernet1/2/1
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE me.alias = '10.22.168.101' AND me.ip = '10.22.168.101'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime, me.contact, me.name, me.location, me.layers, me.num_ports, me.mac, me.serial, me.chassis_id, me.model, me.ps1_type, me.ps2_type, me.ps1_status, me.ps2_status, me.fan, me.slots, me.vendor, me.os, me.os_ver, me.log, me.snmp_ver, me.snmp_comm, me.snmp_class, me.snmp_engineid, me.vtp_domain, me.last_discover, me.last_macsuck, me.last_arpnip, me.is_pseudo, to_char( me.creation, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_discover, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_macsuck, 'YYYY-MM-DD HH24:MI' ), extract( epoch
FROM age( now( ), me.creation ) ), extract( epoch
FROM age( now( ), me.last_arpnip ) ), extract( epoch
FROM age( now( ), me.last_discover ) ), extract( epoch
FROM age( now( ), me.last_macsuck ) ), replace( age( timestamp 'epoch' + me.uptime / 100 * interval '1 second', timestamp '1970-01-01 00:00:00-00' ) ::text, 'mon', 'month' )
FROM device me
WHERE me.ip = '10.22.168.101'
UPDATE device_port
SET is_uplink = true, manual_topo = false, remote_id = 'hackthis.local', remote_ip = '10.22.168.101', remote_port = 'vmnic1', remote_type = 'VMware ESXi'
WHERE ip = '10.22.168.1' AND port = 'GigabitEthernet1/2/1'
SELECT me.ip, me.port, me.creation, me.descr, me.up, me.up_admin, me.type, me.duplex, me.duplex_admin, me.speed, me.speed_admin, me.name, me.mac, me.mtu, me.stp, me.remote_ip, me.remote_port, me.remote_type, me.remote_id, me.is_master, me.slave_of, me.manual_topo, me.is_uplink, me.vlan, me.pvid, me.lastchange
FROM device_port me
WHERE me.ip = '10.22.168.1' AND me.port = 'GigabitEthernet1/2/1'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE me.alias = '254.128.0.0' AND me.ip = '254.128.0.0'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE alias = '254.128.0.0'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime, me.contact, me.name, me.location, me.layers, me.num_ports, me.mac, me.serial, me.chassis_id, me.model, me.ps1_type, me.ps2_type, me.ps1_status, me.ps2_status, me.fan, me.slots, me.vendor, me.os, me.os_ver, me.log, me.snmp_ver, me.snmp_comm, me.snmp_class, me.snmp_engineid, me.vtp_domain, me.last_discover, me.last_macsuck, me.last_arpnip, me.is_pseudo, to_char( me.creation, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_discover, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_macsuck, 'YYYY-MM-DD HH24:MI' ), extract( epoch
FROM age( now( ), me.creation ) ), extract( epoch
FROM age( now( ), me.last_arpnip ) ), extract( epoch
FROM age( now( ), me.last_discover ) ), extract( epoch
FROM age( now( ), me.last_macsuck ) ), replace( age( timestamp 'epoch' + me.uptime / 100 * interval '1 second', timestamp '1970-01-01 00:00:00-00' ) ::text, 'mon', 'month' )
FROM device me
WHERE me.ip = '254.128.0.0'
BEGIN WORK
SAVEPOINT savepoint_0
INSERT INTO admin( action, device, device_key, port, status, subaction, userip, username )
VALUES( ?, ?, ?, ?, ?, ?, ?, ? ) : 'BULK_INSERT'
RELEASE SAVEPOINT savepoint_0
COMMIT
[2365681] 2022-02-08 14:30:43 debug [10.22.168.1] queue - queued 254.128.0.0 for discovery (ID: [AtticAP-1])
[2365681] 2022-02-08 14:30:43 debug queue - skip: IP 254.128.0.0 is already queued from 10.22.168.1
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE me.alias = '10.22.168.159' AND me.ip = '10.22.168.159'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime, me.contact, me.name, me.location, me.layers, me.num_ports, me.mac, me.serial, me.chassis_id, me.model, me.ps1_type, me.ps2_type, me.ps1_status, me.ps2_status, me.fan, me.slots, me.vendor, me.os, me.os_ver, me.log, me.snmp_ver, me.snmp_comm, me.snmp_class, me.snmp_engineid, me.vtp_domain, me.last_discover, me.last_macsuck, me.last_arpnip, me.is_pseudo, to_char( me.creation, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_discover, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_macsuck, 'YYYY-MM-DD HH24:MI' ), extract( epoch
FROM age( now( ), me.creation ) ), extract( epoch
FROM age( now( ), me.last_arpnip ) ), extract( epoch
FROM age( now( ), me.last_discover ) ), extract( epoch
FROM age( now( ), me.last_macsuck ) ), replace( age( timestamp 'epoch' + me.uptime / 100 * interval '1 second', timestamp '1970-01-01 00:00:00-00' ) ::text, 'mon', 'month' )
FROM device me
WHERE me.ip = '10.22.168.159'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE me.alias = '10.22.168.101' AND me.ip = '10.22.168.101'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime, me.contact, me.name, me.location, me.layers, me.num_ports, me.mac, me.serial, me.chassis_id, me.model, me.ps1_type, me.ps2_type, me.ps1_status, me.ps2_status, me.fan, me.slots, me.vendor, me.os, me.os_ver, me.log, me.snmp_ver, me.snmp_comm, me.snmp_class, me.snmp_engineid, me.vtp_domain, me.last_discover, me.last_macsuck, me.last_arpnip, me.is_pseudo, to_char( me.creation, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_discover, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_macsuck, 'YYYY-MM-DD HH24:MI' ), extract( epoch
FROM age( now( ), me.creation ) ), extract( epoch
FROM age( now( ), me.last_arpnip ) ), extract( epoch
FROM age( now( ), me.last_discover ) ), extract( epoch
FROM age( now( ), me.last_macsuck ) ), replace( age( timestamp 'epoch' + me.uptime / 100 * interval '1 second', timestamp '1970-01-01 00:00:00-00' ) ::text, 'mon', 'month' )
FROM device me
WHERE me.ip = '10.22.168.101'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE me.alias = '10.22.135.150' AND me.ip = '10.22.135.150'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE alias = '10.22.135.150'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime, me.contact, me.name, me.location, me.layers, me.num_ports, me.mac, me.serial, me.chassis_id, me.model, me.ps1_type, me.ps2_type, me.ps1_status, me.ps2_status, me.fan, me.slots, me.vendor, me.os, me.os_ver, me.log, me.snmp_ver, me.snmp_comm, me.snmp_class, me.snmp_engineid, me.vtp_domain, me.last_discover, me.last_macsuck, me.last_arpnip, me.is_pseudo, to_char( me.creation, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_discover, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_macsuck, 'YYYY-MM-DD HH24:MI' ), extract( epoch
FROM age( now( ), me.creation ) ), extract( epoch
FROM age( now( ), me.last_arpnip ) ), extract( epoch
FROM age( now( ), me.last_discover ) ), extract( epoch
FROM age( now( ), me.last_macsuck ) ), replace( age( timestamp 'epoch' + me.uptime / 100 * interval '1 second', timestamp '1970-01-01 00:00:00-00' ) ::text, 'mon', 'month' )
FROM device me
WHERE me.ip = '10.22.135.150'
BEGIN WORK
SAVEPOINT savepoint_0
INSERT INTO admin( action, device, device_key, port, status, subaction, userip, username )
VALUES( ?, ?, ?, ?, ?, ?, ?, ? ) : 'BULK_INSERT'
RELEASE SAVEPOINT savepoint_0
COMMIT
[2365681] 2022-02-08 14:30:43 debug [10.22.168.1] queue - queued 10.22.135.150 for discovery (ID: [SEP001BD5851FD3])
[2365681] 2022-02-08 14:30:43 debug queue - skip: IP 254.128.0.0 is already queued from 10.22.168.1
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE me.alias = '10.22.135.158' AND me.ip = '10.22.135.158'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE alias = '10.22.135.158'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime, me.contact, me.name, me.location, me.layers, me.num_ports, me.mac, me.serial, me.chassis_id, me.model, me.ps1_type, me.ps2_type, me.ps1_status, me.ps2_status, me.fan, me.slots, me.vendor, me.os, me.os_ver, me.log, me.snmp_ver, me.snmp_comm, me.snmp_class, me.snmp_engineid, me.vtp_domain, me.last_discover, me.last_macsuck, me.last_arpnip, me.is_pseudo, to_char( me.creation, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_discover, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_macsuck, 'YYYY-MM-DD HH24:MI' ), extract( epoch
FROM age( now( ), me.creation ) ), extract( epoch
FROM age( now( ), me.last_arpnip ) ), extract( epoch
FROM age( now( ), me.last_discover ) ), extract( epoch
FROM age( now( ), me.last_macsuck ) ), replace( age( timestamp 'epoch' + me.uptime / 100 * interval '1 second', timestamp '1970-01-01 00:00:00-00' ) ::text, 'mon', 'month' )
FROM device me
WHERE me.ip = '10.22.135.158'
BEGIN WORK
SAVEPOINT savepoint_0
INSERT INTO admin( action, device, device_key, port, status, subaction, userip, username )
VALUES( ?, ?, ?, ?, ?, ?, ?, ? ) : 'BULK_INSERT'
RELEASE SAVEPOINT savepoint_0
COMMIT
[2365681] 2022-02-08 14:30:43 debug [10.22.168.1] queue - queued 10.22.135.158 for discovery (ID: [SEP002414B3D417])
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE me.alias = '10.22.135.156' AND me.ip = '10.22.135.156'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE alias = '10.22.135.156'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime, me.contact, me.name, me.location, me.layers, me.num_ports, me.mac, me.serial, me.chassis_id, me.model, me.ps1_type, me.ps2_type, me.ps1_status, me.ps2_status, me.fan, me.slots, me.vendor, me.os, me.os_ver, me.log, me.snmp_ver, me.snmp_comm, me.snmp_class, me.snmp_engineid, me.vtp_domain, me.last_discover, me.last_macsuck, me.last_arpnip, me.is_pseudo, to_char( me.creation, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_discover, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_macsuck, 'YYYY-MM-DD HH24:MI' ), extract( epoch
FROM age( now( ), me.creation ) ), extract( epoch
FROM age( now( ), me.last_arpnip ) ), extract( epoch
FROM age( now( ), me.last_discover ) ), extract( epoch
FROM age( now( ), me.last_macsuck ) ), replace( age( timestamp 'epoch' + me.uptime / 100 * interval '1 second', timestamp '1970-01-01 00:00:00-00' ) ::text, 'mon', 'month' )
FROM device me
WHERE me.ip = '10.22.135.156'
BEGIN WORK
SAVEPOINT savepoint_0
INSERT INTO admin( action, device, device_key, port, status, subaction, userip, username )
VALUES( ?, ?, ?, ?, ?, ?, ?, ? ) : 'BULK_INSERT'
RELEASE SAVEPOINT savepoint_0
COMMIT
[2365681] 2022-02-08 14:30:43 debug [10.22.168.1] queue - queued 10.22.135.156 for discovery (ID: [SEP64AE0CF6789B])
[2365681] 2022-02-08 14:30:43 debug queue - skip: IP 10.22.168.101 is already queued from 10.22.168.1
[2365681] 2022-02-08 14:30:43 debug [10.22.168.1] neigh - processed 9 neighbors
[2365681] 2022-02-08 14:30:43 debug -> run worker main/neighbors/100
SNMP::Info::_load_attr docs_if_cmts_cm_status_inet_address : DOCS-IF-MIB::docsIfCmtsCmStatusInetAddress : .1.3.6.1.2.1.10.127.1.3.3.1.21
[2365681] 2022-02-08 14:30:43 debug [10.22.168.1] neigh - no modems (probably not a DOCSIS device)
[2365681] 2022-02-08 14:30:43 debug -> run worker main/neighbors/100
SNMP::Info::_load_attr ospf_peers : OSPF-MIB::ospfNbrIpAddr : .1.3.6.1.2.1.14.10.1.1
SNMP::Info::_load_attr ospf_peer_id : OSPF-MIB::ospfNbrRtrId : .1.3.6.1.2.1.14.10.1.3
SNMP::Info::_load_attr isis_adj : ISIS-MIB::isisISAdjIPAddrAddress : .1.3.6.1.2.1.138.1.6.3.1.3
SNMP::Info::_load_attr bgp_peer_addr : BGP4-MIB::bgpPeerRemoteAddr : .1.3.6.1.2.1.15.3.1.7
SNMP::Info::_validate_autoload_method(eigrp_peers) Unable to resolve method.
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE me.alias = '192.168.11.5' AND me.ip = '192.168.11.5'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime, me.contact, me.name, me.location, me.layers, me.num_ports, me.mac, me.serial, me.chassis_id, me.model, me.ps1_type, me.ps2_type, me.ps1_status, me.ps2_status, me.fan, me.slots, me.vendor, me.os, me.os_ver, me.log, me.snmp_ver, me.snmp_comm, me.snmp_class, me.snmp_engineid, me.vtp_domain, me.last_discover, me.last_macsuck, me.last_arpnip, me.is_pseudo, to_char( me.creation, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_discover, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_macsuck, 'YYYY-MM-DD HH24:MI' ), extract( epoch
FROM age( now( ), me.creation ) ), extract( epoch
FROM age( now( ), me.last_arpnip ) ), extract( epoch
FROM age( now( ), me.last_discover ) ), extract( epoch
FROM age( now( ), me.last_macsuck ) ), replace( age( timestamp 'epoch' + me.uptime / 100 * interval '1 second', timestamp '1970-01-01 00:00:00-00' ) ::text, 'mon', 'month' )
FROM device me
WHERE me.ip = '192.168.11.5'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE me.alias = '192.168.11.5' AND me.ip = '192.168.11.5'
SELECT me.ip, me.creation, me.dns, me.description, me.uptime, me.contact, me.name, me.location, me.layers, me.num_ports, me.mac, me.serial, me.chassis_id, me.model, me.ps1_type, me.ps2_type, me.ps1_status, me.ps2_status, me.fan, me.slots, me.vendor, me.os, me.os_ver, me.log, me.snmp_ver, me.snmp_comm, me.snmp_class, me.snmp_engineid, me.vtp_domain, me.last_discover, me.last_macsuck, me.last_arpnip, me.is_pseudo, to_char( me.creation, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_discover, 'YYYY-MM-DD HH24:MI' ), to_char( me.last_macsuck, 'YYYY-MM-DD HH24:MI' ), extract( epoch
FROM age( now( ), me.creation ) ), extract( epoch
FROM age( now( ), me.last_arpnip ) ), extract( epoch
FROM age( now( ), me.last_discover ) ), extract( epoch
FROM age( now( ), me.last_macsuck ) ), replace( age( timestamp 'epoch' + me.uptime / 100 * interval '1 second', timestamp '1970-01-01 00:00:00-00' ) ::text, 'mon', 'month' )
FROM device me
WHERE me.ip = '192.168.11.5'
[2365681] 2022-02-08 14:30:44 debug [10.22.168.1] neigh - 0 peers added to queue.
[2365681] 2022-02-08 14:30:44 debug -> run worker main/portpower/100
SNMP::Info::_load_attr snAgentPoeUnitPowerCapacityTotal : FOUNDRY-POE-MIB::snAgentPoeUnitPowerCapacityTotal : .1.3.6.1.4.1.1991.1.1.2.14.4.1.1.2
SNMP::Info::_load_attr snAgentPoePortNumber : FOUNDRY-POE-MIB::snAgentPoePortNumber : .1.3.6.1.4.1.1991.1.1.2.14.2.2.1.1
SNMP::Info::_load_attr snAgentPoePortControl : FOUNDRY-POE-MIB::snAgentPoePortControl : .1.3.6.1.4.1.1991.1.1.2.14.2.2.1.2
SNMP::Info::_load_attr snAgentPoePortClass : FOUNDRY-POE-MIB::snAgentPoePortClass : .1.3.6.1.4.1.1991.1.1.2.14.2.2.1.4
SNMP::Info::_load_attr snAgentPoePortConsumed : FOUNDRY-POE-MIB::snAgentPoePortConsumed : .1.3.6.1.4.1.1991.1.1.2.14.2.2.1.6
BEGIN WORK
DELETE FROM device_power
WHERE ip = '10.22.168.1'
[2365681] 2022-02-08 14:30:44 debug [10.22.168.1] power - removed 1 power modules
SAVEPOINT savepoint_0
INSERT INTO device_power( ip, module, power, status )
VALUES( ?, ?, ?, ? ) : 'BULK_INSERT'
RELEASE SAVEPOINT savepoint_0
[2365681] 2022-02-08 14:30:44 debug [10.22.168.1] power - added 1 new power modules
COMMIT
BEGIN WORK
DELETE FROM device_port_power
WHERE ip = '10.22.168.1'
[2365681] 2022-02-08 14:30:44 debug [10.22.168.1] power - removed 0 PoE capable ports
SAVEPOINT savepoint_0
INSERT INTO device_port_power( admin, class, ip, module, port, power, status )
VALUES( ?, ?, ?, ?, ?, ?, ? ) : 'BULK_INSERT'
RELEASE SAVEPOINT savepoint_0
COMMIT
[2365681] 2022-02-08 14:30:44 debug [10.22.168.1] power - added 17 new PoE capable ports
[2365681] 2022-02-08 14:30:44 debug -> run worker main/portproperties/100
SNMP::Info::_validate_autoload_method(i_err_disable_cause) Unable to resolve method.
SNMP::Info::_validate_autoload_method(i_faststart_enabled) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasCDP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasSONMP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasEDP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasAMAP) Unable to resolve method.
SNMP::Info::_load_attr lldp_lport_desc : LLDP-MIB::lldpLocPortDesc(1) : .1.0.8802.1.1.2.1.3.7.1.4.1
SNMP::Info::_load_attr lldp_lport_desc : LLDP-MIB::lldpLocPortDesc(6) : .1.0.8802.1.1.2.1.3.7.1.4.6
SNMP::Info::_load_attr lldp_lport_desc : LLDP-MIB::lldpLocPortDesc(12) : .1.0.8802.1.1.2.1.3.7.1.4.12
SNMP::Info::_load_attr lldp_lport_desc : LLDP-MIB::lldpLocPortDesc(1) : .1.0.8802.1.1.2.1.3.7.1.4.1
SNMP::Info::_load_attr lldp_lport_desc : LLDP-MIB::lldpLocPortDesc(5) : .1.0.8802.1.1.2.1.3.7.1.4.5
SNMP::Info::_load_attr lldp_lport_desc : LLDP-MIB::lldpLocPortDesc(10) : .1.0.8802.1.1.2.1.3.7.1.4.10
SNMP::Info::_load_attr lldp_lport_desc : LLDP-MIB::lldpLocPortDesc(11) : .1.0.8802.1.1.2.1.3.7.1.4.11
SNMP::Info::_load_attr lldp_lport_desc : LLDP-MIB::lldpLocPortDesc(3) : .1.0.8802.1.1.2.1.3.7.1.4.3
SNMP::Info::_load_attr lldp_lport_desc : LLDP-MIB::lldpLocPortDesc(10) : .1.0.8802.1.1.2.1.3.7.1.4.10
SNMP::Info::_load_attr lldp_lport_desc : LLDP-MIB::lldpLocPortDesc(4) : .1.0.8802.1.1.2.1.3.7.1.4.4
SNMP::Info::_load_attr lldp_lport_desc : LLDP-MIB::lldpLocPortDesc(2) : .1.0.8802.1.1.2.1.3.7.1.4.2
SNMP::Info::_load_attr lldp_lport_desc : LLDP-MIB::lldpLocPortDesc(130) : .1.0.8802.1.1.2.1.3.7.1.4.130
SNMP::Info::_load_attr lldp_lport_desc : LLDP-MIB::lldpLocPortDesc(130) : .1.0.8802.1.1.2.1.3.7.1.4.130
SNMP::Info::_validate_autoload_method(hasCDP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasSONMP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasEDP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasAMAP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(fdp_cap) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasCDP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasSONMP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasEDP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasAMAP) Unable to resolve method.
SNMP::Info::_load_attr lldp_rem_media_cap_spt : LLDP-EXT-MED-MIB::lldpXMedRemCapSupported : .1.0.8802.1.1.2.1.5.4795.1.3.1.1.1
SNMP::Info::_load_attr lldp_rem_vendor : LLDP-EXT-MED-MIB::lldpXMedRemMfgName : .1.0.8802.1.1.2.1.5.4795.1.3.3.1.5
SNMP::Info::_load_attr lldp_rem_model : LLDP-EXT-MED-MIB::lldpXMedRemModelName : .1.0.8802.1.1.2.1.5.4795.1.3.3.1.6
SNMP::Info::_load_attr lldp_rem_sw_rev : LLDP-EXT-MED-MIB::lldpXMedRemSoftwareRev : .1.0.8802.1.1.2.1.5.4795.1.3.3.1.3
SNMP::Info::_load_attr lldp_rem_serial : LLDP-EXT-MED-MIB::lldpXMedRemSerialNum : .1.0.8802.1.1.2.1.5.4795.1.3.3.1.4
BEGIN WORK
DELETE FROM device_port_properties
WHERE ip = '10.22.168.1'
[2365681] 2022-02-08 14:30:44 debug [10.22.168.1] properties - removed 0 ports with properties
SAVEPOINT savepoint_0
INSERT INTO device_port_properties( ifindex, ip, port, raw_speed, remote_is_phone, remote_is_wap )
VALUES( ?, ?, ?, ?, ?, ? ) : 'BULK_INSERT'
RELEASE SAVEPOINT savepoint_0
COMMIT
[2365681] 2022-02-08 14:30:44 debug [10.22.168.1] properties - added 25 new port properties
[2365681] 2022-02-08 14:30:44 debug -> run worker main/vlans/100
SNMP::Info::_load_attr v_name : Q-BRIDGE-MIB::dot1qVlanStaticName : .1.3.6.1.2.1.17.7.1.4.3.1.1
SNMP::Info::_load_attr v_name : Q-BRIDGE-MIB::dot1qVlanStaticName : .1.3.6.1.2.1.17.7.1.4.3.1.1
SNMP::Info::_load_attr qb_i_vlan : Q-BRIDGE-MIB::dot1qPvid : .1.3.6.1.2.1.17.7.1.4.5.1.1
SNMP::Info::_validate_autoload_method(i_vlan_type) Unable to resolve method.
SNMP::Info::_load_attr qb_cv_egress : Q-BRIDGE-MIB::dot1qVlanCurrentEgressPorts : .1.3.6.1.2.1.17.7.1.4.2.1.4
SNMP::Info::_load_attr qb_v_egress : Q-BRIDGE-MIB::dot1qVlanStaticEgressPorts : .1.3.6.1.2.1.17.7.1.4.3.1.2
SNMP::Info::_load_attr qb_cv_untagged : Q-BRIDGE-MIB::dot1qVlanCurrentUntaggedPorts : .1.3.6.1.2.1.17.7.1.4.2.1.5
SNMP::Info::_load_attr qb_v_untagged : Q-BRIDGE-MIB::dot1qVlanStaticUntaggedPorts : .1.3.6.1.2.1.17.7.1.4.3.1.4
BEGIN WORK
DELETE FROM device_port_vlan
WHERE ip = '10.22.168.1'
[2365681] 2022-02-08 14:30:45 debug [10.22.168.1] vlans - removed 0 port VLANs
[2365681] 2022-02-08 14:30:45 debug [10.22.168.1] vlans - added 0 new port VLANs
COMMIT
BEGIN WORK
DELETE FROM device_vlan
WHERE ip = '10.22.168.1'
[2365681] 2022-02-08 14:30:45 debug [10.22.168.1] vlans - removed 0 device VLANs
[2365681] 2022-02-08 14:30:45 debug [10.22.168.1] vlans - added 0 new device VLANs
COMMIT
[2365681] 2022-02-08 14:30:45 debug [10.22.168.1] vlans - discovered for ports and device
[2365681] 2022-02-08 14:30:45 debug -> run worker main/wireless/100
SNMP::Info::_validate_autoload_method(i_ssidlist) Unable to resolve method.
[2365681] 2022-02-08 14:30:45 debug -> run worker main/withnodes/0
[2365681] 2022-02-08 14:30:45 debug Queued macsuck and arpnip for 10.22.168.1.
[2365681] 2022-02-08 14:30:45 debug => running workers for phase: late
[2365681] 2022-02-08 14:30:45 debug -> run worker late/hooks/0
[2365681] 2022-02-08 14:30:45 debug [10.22.168.1] hooks - 0 queued
[2365681] 2022-02-08 14:30:45 info discover: finished at Tue Feb 8 09:30:45 2022
[2365681] 2022-02-08 14:30:45 info discover: status done: Ended discover for 10.22.168.1
@ollyg
Copy link
Member

ollyg commented Feb 28, 2022

Hi @jimaraujo6786

Are you able and willing to share an SNMP dump of the device with me so I can work out what's happening?
Using this doc: https://github.com/netdisco/netdisco/wiki/Snapshot#share-a-snapshot
and this service: https://upload.disroot.org/

@jimaraujo6786
Copy link
Author

jimaraujo6786 commented Mar 1, 2022 via email

@ollyg ollyg self-assigned this Mar 1, 2022
@ollyg
Copy link
Member

ollyg commented Aug 18, 2023

Hi again @jimaraujo6786 sorry for the long wait. If you are still able, can you share the output of an snmpwalk on the device?

snmpwalk -v 2c -c public -ObentU 1.2.3.4 .1

@jacobghattas
Copy link

Good morning Oliver, I kind of have the same issue...
I have 2 running netdisco servers: 1 running 2.057005 and the second 2.071001.
There are few ruckus switches installed on the network.
ICX7[1-4]xx and ICX8200
Ruckus has 2 lines of OS to run on 7xxx switches, one for router code and the second for the switch code.
for the Switch code, everything is running perfectly.
for the router code, (Ruckus ICX-8200 switches running RDR10010a.bin), the situation is a bit complex:
The discovery of the switch doesn't show the vlans assigned to the ports.
unless I replace the Foundry.pm file with the one I attached here.
Foundry.zip
but then the change vlan on the port does not function.
Anyhow, if the port is not assigned to a vlan the vlan assignment works.
The port control function works on all versions, all foundry.pm files...
I will appreciate any idea and help.

Thank you in advance.
Jacob

@jacobghattas jacobghattas mentioned this issue Dec 12, 2023
Open
@inphobia inphobia mentioned this issue Feb 29, 2024
Open
11 tasks
@jfarre20
Copy link

jfarre20 commented Feb 29, 2024 •
edited
Loading

I've tried the newest public release of netdisco as of Feb 28, and my ICX 7250-48p switch isn't showing vlans or allowing vlan changes on both layer 3 and 2 firmware (09.0.10j_cd1T211). Screenshots below are from layer 2 firmware:

image

image

I do have vlans on the switch:
image

Attempts to change vlans error out with Use of uninitialized value in concatenation (.) or string at 315 for the foundry snmp code.

Line 315 on the file its talking about is
my $rv_rem = $foundry->set_snVLanByPortMemberRowStatus( 3, "$i_vlan->{$iid}.$iid" );

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@ollyg ollyg

Labels
assigned-to-project
Projects
Vendor Support
Status: No status
Milestone
No milestone
Development

No branches or pull requests
4 participants
@ollyg @jfarre20 @jacobghattas @jimaraujo6786