--- Begin Message ---
I looked at the source, and I think I see that discovering a device and
building neighbors are different, and no, OSPF discovery doesn't create
neighborship.
Moving on, I used the manual topology option to create the connection between
the two. It appears in the database and various reports, but still doesn't
show as a neighbor from either side. What do I need to do to get this to work?
ERM
Evan R Moore
Network Engineer and Bitwrangler
FirstLight
5 Canal Street | Bellows Falls, VT 05101 Office 802-463-2111 | Fax 802-460-2113
mailto:[email protected] | http://www.firstlight.net This email may contain
FirstLight confidential and/or privileged information. If you are not the
intended recipient, you are directed not to read, disclose or otherwise use
this transmission and to immediately delete same. Delivery of this message is
not intended to waive any applicable privileges.
-----Original Message-----
From: Evan Moore
Sent: Thursday, March 11, 2021 9:58 AM
To: [email protected]
Subject: Finding OSPF peers as neighbors
Greetings all.
Netdisco newbie. I hope this is a simple question and I've missed something
obvious. It looks like netdisco is discovering my OSPF peers, but not using
the information to create neighbor relationships. Example:
netdisco@milton:~$ bin/netdisco-do -DISQ discover -d 172.17.212.3
[33474] 2021-03-11 14:33:12 info App::Netdisco version 2.047005 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 = '172.17.212.3' AND me.ip = '172.17.212.3'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE alias = '172.17.212.3'
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.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, 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 = '172.17.213.10'
[33474] 2021-03-11 14:33:12 info discover: [172.17.213.10] started at Thu Mar
11 09:33:12 2021
[33474] 2021-03-11 14:33:12 debug discover: running with timeout 600s
[33474] 2021-03-11 14:33:12 debug => running workers for phase: check
[33474] 2021-03-11 14:33:12 debug -> run worker check/_base_/0
[33474] 2021-03-11 14:33:12 debug Discover is able to run.
[33474] 2021-03-11 14:33:12 debug => running workers for phase: early
[33474] 2021-03-11 14:33:12 debug -> run worker early/properties/100
[33474] 2021-03-11 14:33:12 debug snmp reader cache warm: [172.17.213.10]
SELECT me.ip, me.snmp_comm_rw, me.snmp_auth_tag_read, me.snmp_auth_tag_write
FROM community me
WHERE me.ip = '172.17.213.10'
SELECT me.ip, me.snmp_comm_rw, me.snmp_auth_tag_read, me.snmp_auth_tag_write
FROM community me
WHERE me.ip = '172.17.213.10'
SELECT me.ip, me.snmp_comm_rw, me.snmp_auth_tag_read, me.snmp_auth_tag_write
FROM community me
WHERE me.ip = '172.17.213.10'
[33474] 2021-03-11 14:33:12 debug [172.17.213.10:161] try_connect with ver: 2,
class: SNMP::Info::Layer3::C3550, comm: <hidden>
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/3com
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/adtran
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/aerohive
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/alcatel
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/allied
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/apc
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/arista
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/aruba
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/asante
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/avaya
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/bluecoat
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/bluesocket
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/brother
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/cabletron
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/ceragon
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/checkpoint
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/ciena
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/cisco
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/ciscosb
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/citrix
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/clavister
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/cloudgenix
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/colubris
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/cyclades
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/d-link
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/dell
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/eaton
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/efficientip
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/enterasys
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/etherwan
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/exinda
snmp_add_mib_dir: Failed to add /home/netdisco/netdisco-mibs/EXTRAS
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/extreme
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/extricom
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/f5
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/force10
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/fortinet
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/foundry
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/gigamon
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/h3c
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/hirschmann
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/hp
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/hpe
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/huawei
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/ibm
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/juniper
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/lancom
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/lantronix
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/lenovo
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/liebert
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/mediant
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/meraki
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/meru
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/microsens
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/mikrotik
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/moser-baer
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/motorola
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/moxa
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/nateks
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/net-snmp
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/netapp
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/netgear
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/netonix
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/netscreen
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/nexans
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/nortel
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/northerndesign
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/oneaccess
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/opengear
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/packetfront
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/paloalto
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/pica8
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/pulsesecure-gateway
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/rad
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/redlionram
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/rfc
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/rittal
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/riverbed
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/ruckus
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/schleifenbauer
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/sentry
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/siemens
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/sixnet
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/sonicwall
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/teleste
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/teltonika
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/tplink
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/trapeze
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/vmware
snmp_add_mib_dir: Added mib dir /home/netdisco/netdisco-mibs/xirrus
Read LLDP-EXT-DOT1-MIB
Read ISIS-MIB
Read ENTITY-MIB
Read CISCO-IETF-IP-MIB
Read CISCO-IMAGE-MIB
Read DOCS-IF-MIB
Read OLD-CISCO-SYS-MIB
Read CISCO-VLAN-MEMBERSHIP-MIB
Read POWER-ETHERNET-MIB
Read CISCO-STACK-MIB
Read IPV6-MIB
Read DOCS-IF3-MIB
Read Q-BRIDGE-MIB
Read CISCO-EIGRP-MIB
Read OSPF-MIB
Read CISCO-PORT-SECURITY-MIB
Read CISCO-VTP-MIB
Read CISCO-ERR-DISABLE-MIB
Read CISCO-IF-EXTENSION-MIB
Read CISCO-CLASS-BASED-QOS-MIB
Read CISCO-STP-EXTENSIONS-MIB
Read CISCO-PAGP-MIB
Read CISCO-PRODUCTS-MIB
Read IEEE8023-LAG-MIB
Read CISCO-PAE-MIB
Read ADSL-LINE-MIB
Read LLDP-EXT-DOT3-MIB
Read CISCO-RTTMON-MIB
Read BGP4-MIB
Read CISCO-CDP-MIB
Read CISCO-CONFIG-COPY-MIB
Read IF-MIB
Read SNMPv2-MIB
Read IP-MIB
Read BRIDGE-MIB
Read CISCO-LAG-MIB
Read LLDP-MIB
Read CISCO-PROCESS-MIB
Read CISCO-MEMORY-POOL-MIB
Read CISCO-POWER-ETHERNET-EXT-MIB
Read IEEE8021-PAE-MIB
Read RSTP-MIB
Read CISCO-ENTITY-VENDORTYPE-OID-MIB
Read LLDP-EXT-MED-MIB
Read EtherLike-MIB
Read CISCO-VLAN-IFTABLE-RELATIONSHIP-MIB
Read OLD-CISCO-SYSTEM-MIB
Read CISCO-FLASH-MIB
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
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.71
SNMP::Info::device_type() layers:00000110 id:9 sysDescr:"Cisco IOS Software,
ME340x Software (ME340x-METROIPACCESSK9-M), Version 12.2(60)EZ8, RELEASE
SOFTWARE (fc2) Technical Support: http://www.cisco.com/techsupport Copyright
(c) 1986-2015 by Cisco Systems, Inc. Compiled Fri 26-Jun-15 08:15 by
prod_rel_team"
SNMP::Info::_load_attr vtp_d_name : CISCO-VTP-MIB::managementDomainName :
.1.3.6.1.4.1.9.9.46.1.2.1.1.2
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 : CISCO-STACK-MIB::chassisPs1Type.0 :
.1.3.6.1.4.1.9.5.1.2.3.0
SNMP::Info::_global ps2_type : CISCO-STACK-MIB::chassisPs2Type.0 :
.1.3.6.1.4.1.9.5.1.2.6.0
SNMP::Info::_global ps1_status : CISCO-STACK-MIB::chassisPs1Status.0 :
.1.3.6.1.4.1.9.5.1.2.4.0
SNMP::Info::_global ps2_status : CISCO-STACK-MIB::chassisPs2Status.0 :
.1.3.6.1.4.1.9.5.1.2.7.0
SNMP::Info::_global fan : CISCO-STACK-MIB::chassisFanStatus.0 :
.1.3.6.1.4.1.9.5.1.2.9.0
SNMP::Info::_global slots : CISCO-STACK-MIB::chassisNumSlots.0 :
.1.3.6.1.4.1.9.5.1.2.14.0
SNMP::Info::_global serial1 : CISCO-STACK-MIB::chassisSerialNumber.0 :
.1.3.6.1.4.1.9.5.1.2.17.0
SNMP::Info::_global(serial1) NOSUCHOBJECT at
/home/netdisco/perl5/lib/perl5/SNMP/Info/CiscoStack.pm line 122.
SNMP::Info::_global serial2 : CISCO-STACK-MIB::chassisSerialNumberString.0 :
.1.3.6.1.4.1.9.5.1.2.19.0
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 orig_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
BEGIN WORK
UPDATE device
SET last_discover = now( ), uptime = '2605028488'
WHERE ip = '172.17.213.10'
COMMIT
[33474] 2021-03-11 14:33:13 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 = '172.17.213.10' AND me.ip = '172.17.213.10'
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.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, 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 = '172.17.213.10'
[33474] 2021-03-11 14:33:13 debug [172.17.213.10] device - OK to continue
discover
[33474] 2021-03-11 14:33:13 debug -> run worker early/properties/100
SNMP::Info::_load_attr i_index : IF-MIB::ifIndex : .1.3.6.1.2.1.2.2.1.1
SNMP::Info::_load_attr i_description : IF-MIB::ifDescr : .1.3.6.1.2.1.2.2.1.2
[33474] 2021-03-11 14:33:13 debug [172.17.213.10] device - OK to continue
discover
[33474] 2021-03-11 14:33:13 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 old_ip_netmask : IP-MIB::ipAdEntNetMask :
.1.3.6.1.2.1.4.20.1.3
error:snmp_translate_obj:Unknown OID vrf_name
SNMP::Info::_validate_autoload_method(vrf_name) Unable to resolve method.
[33474] 2021-03-11 14:33:13 debug [172.17.213.10] device - aliased as
172.17.212.3
[33474] 2021-03-11 14:33:13 debug [172.17.213.10] device - aliased as
10.35.12.129
[33474] 2021-03-11 14:33:13 debug [172.17.213.10] device - aliased as
10.35.12.1
[33474] 2021-03-11 14:33:13 debug [172.17.213.10] device - aliased as
10.43.126.90
[33474] 2021-03-11 14:33:13 debug [172.17.213.10] device - aliased as
172.17.213.14
[33474] 2021-03-11 14:33:13 debug [172.17.213.10] device - aliased as
172.17.214.249
[33474] 2021-03-11 14:33:13 debug [172.17.213.10] device - aliased as
10.48.160.49
[33474] 2021-03-11 14:33:13 debug [172.17.213.10] device - aliased as
172.17.213.10
[33474] 2021-03-11 14:33:13 debug [172.17.213.10] device - aliased as
172.17.213.17
[33474] 2021-03-11 14:33:13 debug [172.17.213.10] device - aliased as
172.17.214.1
SNMP::Info::_load_attr ip_addr6_index : IP-MIB::ipAddressIfIndex :
.1.3.6.1.2.1.4.34.1.3
SNMP::Info::_load_attr c_addr6_index : CISCO-IETF-IP-MIB::cIpAddressIfIndex :
.1.3.6.1.4.1.9.10.86.1.1.2.1.3
SNMP::Info::IPv6::ipv6_index: data comes from none of the MIBs.
SNMP::Info::_load_attr ip_addr6_index : IP-MIB::ipAddressIfIndex :
.1.3.6.1.2.1.4.34.1.3
SNMP::Info::_load_attr c_addr6_index : CISCO-IETF-IP-MIB::cIpAddressIfIndex :
.1.3.6.1.4.1.9.10.86.1.1.2.1.3
SNMP::Info::IPv6::ipv6_index: data comes from none of the MIBs.
SNMP::Info::_load_attr ip_addr6_type : IP-MIB::ipAddressType :
.1.3.6.1.2.1.4.34.1.4
SNMP::Info::_load_attr c_addr6_type : CISCO-IETF-IP-MIB::cIpAddressType :
.1.3.6.1.4.1.9.10.86.1.1.2.1.4
SNMP::Info::IPv6::ipv6_type: data comes from none of the MIBs.
SNMP::Info::_load_attr ip_addr6_pfx : IP-MIB::ipAddressPrefix :
.1.3.6.1.2.1.4.34.1.5
SNMP::Info::_load_attr c_addr6_pfx : CISCO-IETF-IP-MIB::cIpAddressPrefix :
.1.3.6.1.4.1.9.10.86.1.1.2.1.5
SNMP::Info::IPv6::ipv6_addr_prefixlength: data comes from none of the MIBs.
error:snmp_translate_obj:Unknown OID vrf_name
SNMP::Info::_validate_autoload_method(vrf_name) Unable to resolve method.
[33474] 2021-03-11 14:33:13 debug resolving 10 aliases with max 50 outstanding
requests
BEGIN WORK
DELETE FROM device_ip
WHERE ip = '172.17.213.10'
[33474] 2021-03-11 14:33:13 debug [172.17.213.10] device - removed 10 aliases
SAVEPOINT savepoint_0
INSERT INTO device_ip( alias, dns, ip, port, subnet )
VALUES( ?, ?, ?, ?, ? ) : '__BULK_INSERT__'
RELEASE SAVEPOINT savepoint_0
COMMIT
[33474] 2021-03-11 14:33:13 debug [172.17.213.10] aliases - added 10 new
aliases
[33474] 2021-03-11 14:33:13 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
error:snmp_translate_obj:Unknown OID i_ignore
SNMP::Info::_validate_autoload_method(i_ignore) Unable to resolve method.
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::_load_attr p_port : CISCO-STACK-MIB::portIfIndex :
.1.3.6.1.4.1.9.5.1.4.1.1.11
SNMP::Info::_load_attr p_speed : CISCO-STACK-MIB::portAdminSpeed :
.1.3.6.1.4.1.9.5.1.4.1.1.9
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 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
SNMP::Info::_load_attr el_duplex : EtherLike-MIB::dot3StatsDuplexStatus :
.1.3.6.1.2.1.10.7.2.1.19
SNMP::Info::_load_attr p_duplex : CISCO-STACK-MIB::portDuplex :
.1.3.6.1.4.1.9.5.1.4.1.1.10
SNMP::Info::_load_attr bp_index : BRIDGE-MIB::dot1dBasePortIfIndex :
.1.3.6.1.2.1.17.1.4.1.2
SNMP::Info::_load_attr stp_p_state : BRIDGE-MIB::dot1dStpPortState :
.1.3.6.1.2.1.17.2.15.1.3
SNMP::Info::_load_attr vtp_trunk_native :
CISCO-VTP-MIB::vlanTrunkPortNativeVlan : .1.3.6.1.4.1.9.9.46.1.6.1.1.5
SNMP::Info::_load_attr i_vlan2 : CISCO-VLAN-MEMBERSHIP-MIB::vmVlan :
.1.3.6.1.4.1.9.9.68.1.2.2.1.2
SNMP::Info::_load_attr vtp_trunk_dyn : CISCO-VTP-MIB::vlanTrunkPortDynamicState
: .1.3.6.1.4.1.9.9.46.1.6.1.1.13
SNMP::Info::_load_attr vtp_trunk_dyn_stat :
CISCO-VTP-MIB::vlanTrunkPortDynamicStatus : .1.3.6.1.4.1.9.9.46.1.6.1.1.14
SNMP::Info::_load_attr v_cvi_if :
CISCO-VLAN-IFTABLE-RELATIONSHIP-MIB::cviRoutedVlanIfIndex :
.1.3.6.1.4.1.9.9.128.1.1.1.1.3
SNMP::Info::_load_attr i_lastchange : IF-MIB::ifLastChange :
.1.3.6.1.2.1.2.2.1.9
SNMP::Info::_load_attr pagpGroupIfIndex : CISCO-PAGP-MIB::pagpGroupIfIndex :
.1.3.6.1.4.1.9.9.98.1.1.1.1.8
SNMP::Info::_load_attr dot3adAggPortSelectedAggID :
IEEE8023-LAG-MIB::dot3adAggPortSelectedAggID : .1.2.840.10006.300.43.1.2.1.1.12
SNMP::Info::_load_attr lag_members :
CISCO-LAG-MIB::clagAggPortListInterfaceIndexList :
.1.3.6.1.4.1.9.9.225.1.4.1.1.2
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
BEGIN WORK
DELETE FROM device_port_power
WHERE ip IN (
SELECT me.ip
FROM device_port me
WHERE me.ip = '172.17.213.10'
)
[33474] 2021-03-11 14:33:14 debug [172.17.213.10] db/ports - removed 0 port
entries from DevicePortPower
DELETE FROM device_port_properties
WHERE ip IN (
SELECT me.ip
FROM device_port me
WHERE me.ip = '172.17.213.10'
)
[33474] 2021-03-11 14:33:14 debug [172.17.213.10] db/ports - removed 39 port
entries from DevicePortProperties
DELETE FROM device_port_vlan
WHERE ip IN (
SELECT me.ip
FROM device_port me
WHERE me.ip = '172.17.213.10'
)
[33474] 2021-03-11 14:33:14 debug [172.17.213.10] db/ports - removed 48 port
entries from DevicePortVlan
DELETE FROM device_port_wireless
WHERE ip IN (
SELECT me.ip
FROM device_port me
WHERE me.ip = '172.17.213.10'
)
[33474] 2021-03-11 14:33:14 debug [172.17.213.10] db/ports - removed 0 port
entries from DevicePortWireless
DELETE FROM device_port_ssid
WHERE ip IN (
SELECT me.ip
FROM device_port me
WHERE me.ip = '172.17.213.10'
)
[33474] 2021-03-11 14:33:14 debug [172.17.213.10] db/ports - removed 0 port
entries from DevicePortSsid
DELETE FROM device_port
WHERE ip = '172.17.213.10'
[33474] 2021-03-11 14:33:14 debug [172.17.213.10] interfaces - removed 39
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
[33474] 2021-03-11 14:33:14 debug [172.17.213.10] interfaces - added 39 new
interfaces
[33474] 2021-03-11 14:33:14 debug => running workers for phase: main
[33474] 2021-03-11 14:33:14 debug -> run worker main/canonicalip/100
[33474] 2021-03-11 14:33:14 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 e_descr : ENTITY-MIB::entPhysicalDescr :
.1.3.6.1.2.1.47.1.1.1.1.2
SNMP::Info::_load_attr e_type : ENTITY-MIB::entPhysicalVendorType :
.1.3.6.1.2.1.47.1.1.1.1.3
SNMP::Info::_load_attr e_parent : ENTITY-MIB::entPhysicalContainedIn :
.1.3.6.1.2.1.47.1.1.1.1.4
SNMP::Info::_load_attr e_name : ENTITY-MIB::entPhysicalName :
.1.3.6.1.2.1.47.1.1.1.1.7
SNMP::Info::_load_attr e_class : ENTITY-MIB::entPhysicalClass :
.1.3.6.1.2.1.47.1.1.1.1.5
SNMP::Info::_load_attr 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 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 = '172.17.213.10'
[33474] 2021-03-11 14:33:15 debug [172.17.213.10] modules - removed 52 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
[33474] 2021-03-11 14:33:15 debug [172.17.213.10] modules - added 52 new
chassis modules
[33474] 2021-03-11 14:33:15 debug -> run worker main/neighbors/100
BEGIN WORK
UPDATE device_port
SET manual_topo = false
WHERE ip = '172.17.213.10'
DELETE FROM topology
WHERE ( dev1 = '172.17.213.10' AND port1 NOT IN (
SELECT me.port
FROM device_port me
WHERE me.ip = '172.17.213.10'
) ) OR ( dev2 = '172.17.213.10' AND port2 NOT IN (
SELECT me.port
FROM device_port me
WHERE me.ip = '172.17.213.10'
) )
[33474] 2021-03-11 14:33:15 debug [172.17.213.10] neigh - removed 0 outdated
manual topology links
[33474] 2021-03-11 14:33:15 debug [172.17.213.10] neigh - setting manual
topology links
SELECT me.dev1, me.port1, me.dev2, me.port2
FROM topology me
WHERE dev1 = '172.17.213.10' OR dev2 = '172.17.213.10'
COMMIT
SNMP::Info::_global lldp_sys_cap : LLDP-MIB::lldpLocSysCapEnabled.0 :
.1.0.8802.1.1.2.1.3.6.0
SNMP::Info::_global cdp_run : CISCO-CDP-MIB::cdpGlobalRun.0 :
.1.3.6.1.4.1.9.9.23.1.3.1.0
error:snmp_translate_obj:Unknown OID hasSONMP
SNMP::Info::_validate_autoload_method(hasSONMP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasFDP
SNMP::Info::_validate_autoload_method(hasFDP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasEDP
SNMP::Info::_validate_autoload_method(hasEDP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasAMAP
SNMP::Info::_validate_autoload_method(hasAMAP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasSONMP
SNMP::Info::_validate_autoload_method(hasSONMP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasFDP
SNMP::Info::_validate_autoload_method(hasFDP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasEDP
SNMP::Info::_validate_autoload_method(hasEDP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasAMAP
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 cdp_addr : CISCO-CDP-MIB::cdpCacheAddress :
.1.3.6.1.4.1.9.9.23.1.2.1.1.4
SNMP::Info::_load_attr cdp_proto : CISCO-CDP-MIB::cdpCacheAddressType :
.1.3.6.1.4.1.9.9.23.1.2.1.1.3
error:snmp_translate_obj:Unknown OID hasSONMP
SNMP::Info::_validate_autoload_method(hasSONMP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasFDP
SNMP::Info::_validate_autoload_method(hasFDP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasEDP
SNMP::Info::_validate_autoload_method(hasEDP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasAMAP
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 : LLDP-MIB::lldpRemPortId :
.1.0.8802.1.1.2.1.4.1.1.7
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 cdp_dev_port : CISCO-CDP-MIB::cdpCacheDevicePort :
.1.3.6.1.4.1.9.9.23.1.2.1.1.7
error:snmp_translate_obj:Unknown OID hasSONMP
SNMP::Info::_validate_autoload_method(hasSONMP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasFDP
SNMP::Info::_validate_autoload_method(hasFDP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasEDP
SNMP::Info::_validate_autoload_method(hasEDP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasAMAP
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 cdp_dev_id : CISCO-CDP-MIB::cdpCacheDeviceId :
.1.3.6.1.4.1.9.9.23.1.2.1.1.6
error:snmp_translate_obj:Unknown OID hasSONMP
SNMP::Info::_validate_autoload_method(hasSONMP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasFDP
SNMP::Info::_validate_autoload_method(hasFDP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasEDP
SNMP::Info::_validate_autoload_method(hasEDP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasAMAP
SNMP::Info::_validate_autoload_method(hasAMAP) Unable to resolve method.
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 lldp_rem_sysdesc : LLDP-MIB::lldpRemSysDesc :
.1.0.8802.1.1.2.1.4.1.1.10
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 cdp_platform : CISCO-CDP-MIB::cdpCachePlatform :
.1.3.6.1.4.1.9.9.23.1.2.1.1.8
error:snmp_translate_obj:Unknown OID hasSONMP
SNMP::Info::_validate_autoload_method(hasSONMP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasFDP
SNMP::Info::_validate_autoload_method(hasFDP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasEDP
SNMP::Info::_validate_autoload_method(hasEDP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasAMAP
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::_load_attr cdp_capabilities_raw :
CISCO-CDP-MIB::cdpCacheCapabilities : .1.3.6.1.4.1.9.9.23.1.2.1.1.9
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 = '172.17.213.10'
error:snmp_translate_obj:Unknown OID hasSONMP
SNMP::Info::_validate_autoload_method(hasSONMP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasFDP
SNMP::Info::_validate_autoload_method(hasFDP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasEDP
SNMP::Info::_validate_autoload_method(hasEDP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasAMAP
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
SNMP::Info::_load_attr lldp_rman_addr : LLDP-MIB::lldpRemManAddrIfSubtype :
.1.0.8802.1.1.2.1.4.2.1.3
[33474] 2021-03-11 14:33:19 debug [172.17.213.10] neigh - 172.17.213.9 with ID
[ONNTNYOAMS0.mgmt.firstlight.net] on GigabitEthernet0/2
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE me.alias = '172.17.213.9' AND me.ip = '172.17.213.9'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE alias = '172.17.213.9'
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.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, 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 = '172.17.213.6'
UPDATE device_port
SET is_uplink = true, manual_topo = false, remote_id =
'ONNTNYOAMS0.mgmt.firstlight.net', remote_ip = '172.17.213.9', remote_port =
'GigabitEthernet0/1', remote_type = 'cisco ME-3400E-24TS-M'
WHERE ip = '172.17.213.10' AND port = 'GigabitEthernet0/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 = '172.17.213.10' AND me.port = 'GigabitEthernet0/2'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE me.alias = '172.17.213.9' AND me.ip = '172.17.213.9'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE alias = '172.17.213.9'
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.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, 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 = '172.17.213.6'
[33474] 2021-03-11 14:33:19 debug [172.17.213.10] neigh - processed 1 neighbors
[33474] 2021-03-11 14:33:19 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::_load_attr c_eigrp_peers : CISCO-EIGRP-MIB::cEigrpPeerAddr :
.1.3.6.1.4.1.9.9.449.1.4.1.1.3
SNMP::Info::_load_attr c_eigrp_peer_types : CISCO-EIGRP-MIB::cEigrpPeerAddrType
: .1.3.6.1.4.1.9.9.449.1.4.1.1.2
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE me.alias = '172.17.213.9' AND me.ip = '172.17.213.9'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE alias = '172.17.213.9'
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.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, 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 = '172.17.213.6'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE me.alias = '172.17.213.18' AND me.ip = '172.17.213.18'
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.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, 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 = '172.17.213.18'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE me.alias = '172.17.212.2' AND me.ip = '172.17.212.2'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE alias = '172.17.212.2'
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.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, 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 = '172.17.213.6'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE me.alias = '172.17.212.4' AND me.ip = '172.17.212.4'
SELECT me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
FROM device_ip me
WHERE alias = '172.17.212.4'
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.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, 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 = '172.17.213.18'
[33474] 2021-03-11 14:33:19 debug [172.17.213.10] neigh - 0 peers added to
queue.
[33474] 2021-03-11 14:33:19 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
[33474] 2021-03-11 14:33:19 debug [172.17.213.10] neigh - no modems (probably
not a DOCSIS device)
[33474] 2021-03-11 14:33:19 debug -> run worker main/portpower/100
SNMP::Info::_load_attr peth_power_watts : POWER-ETHERNET-MIB::pethMainPsePower
: .1.3.6.1.2.1.105.1.3.1.1.2
SNMP::Info::_load_attr peth_power_status :
POWER-ETHERNET-MIB::pethMainPseOperStatus : .1.3.6.1.2.1.105.1.3.1.1.3
[33474] 2021-03-11 14:33:19 debug [172.17.213.10] power - 0 power modules
[33474] 2021-03-11 14:33:19 debug -> run worker main/portproperties/100
SNMP::Info::_load_attr cerr_i_cause :
CISCO-ERR-DISABLE-MIB::cErrDisableIfStatusCause : .1.3.6.1.4.1.9.9.548.1.3.1.1.2
SNMP::Info::_global stpx_faststart_default :
CISCO-STP-EXTENSIONS-MIB::stpxFastStartGlobalDefaultMode.0 :
.1.3.6.1.4.1.9.9.82.1.9.4.0
SNMP::Info::_load_attr stpx_faststart_enabled :
CISCO-STP-EXTENSIONS-MIB::stpxFastStartPortEnable :
.1.3.6.1.4.1.9.9.82.1.9.3.1.2
SNMP::Info::_load_attr stpx_faststart_operational :
CISCO-STP-EXTENSIONS-MIB::stpxFastStartPortMode : .1.3.6.1.4.1.9.9.82.1.9.3.1.3
error:snmp_translate_obj:Unknown OID hasSONMP
SNMP::Info::_validate_autoload_method(hasSONMP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasFDP
SNMP::Info::_validate_autoload_method(hasFDP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasEDP
SNMP::Info::_validate_autoload_method(hasEDP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasAMAP
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
error:snmp_translate_obj:Unknown OID hasSONMP
SNMP::Info::_validate_autoload_method(hasSONMP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasFDP
SNMP::Info::_validate_autoload_method(hasFDP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasEDP
SNMP::Info::_validate_autoload_method(hasEDP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasAMAP
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
error:snmp_translate_obj:Unknown OID hasSONMP
SNMP::Info::_validate_autoload_method(hasSONMP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasFDP
SNMP::Info::_validate_autoload_method(hasFDP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasEDP
SNMP::Info::_validate_autoload_method(hasEDP) Unable to resolve method.
error:snmp_translate_obj:Unknown OID hasAMAP
SNMP::Info::_validate_autoload_method(hasAMAP) Unable to resolve method.
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 lldp_rem_sysdesc : LLDP-MIB::lldpRemSysDesc :
.1.0.8802.1.1.2.1.4.1.1.10
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 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 = '172.17.213.10'
[33474] 2021-03-11 14:33:21 debug [172.17.213.10] properties - removed 0 ports
with properties
SAVEPOINT savepoint_0
INSERT INTO device_port_properties( faststart, ifindex, ip, port, raw_speed )
VALUES( ?, ?, ?, ?, ? ) : '__BULK_INSERT__'
RELEASE SAVEPOINT savepoint_0
COMMIT
[33474] 2021-03-11 14:33:21 debug [172.17.213.10] properties - added 39 new
port properties
[33474] 2021-03-11 14:33:21 debug -> run worker main/vlans/100
SNMP::Info::_load_attr v_name : CISCO-VTP-MIB::vtpVlanName :
.1.3.6.1.4.1.9.9.46.1.3.1.1.4
SNMP::Info::_load_attr i_vlan_type : CISCO-VLAN-MEMBERSHIP-MIB::vmVlanType :
.1.3.6.1.4.1.9.9.68.1.2.2.1.1
SNMP::Info::_load_attr vtp_trunk_vlans :
CISCO-VTP-MIB::vlanTrunkPortVlansEnabled : .1.3.6.1.4.1.9.9.46.1.6.1.1.4
SNMP::Info::_load_attr vtp_trunk_vlans_2k :
CISCO-VTP-MIB::vlanTrunkPortVlansEnabled2k : .1.3.6.1.4.1.9.9.46.1.6.1.1.17
SNMP::Info::_load_attr vtp_trunk_vlans_3k :
CISCO-VTP-MIB::vlanTrunkPortVlansEnabled3k : .1.3.6.1.4.1.9.9.46.1.6.1.1.18
SNMP::Info::_load_attr vtp_trunk_vlans_4k :
CISCO-VTP-MIB::vlanTrunkPortVlansEnabled4k : .1.3.6.1.4.1.9.9.46.1.6.1.1.19
SNMP::Info::_load_attr v_state : CISCO-VTP-MIB::vtpVlanState :
.1.3.6.1.4.1.9.9.46.1.3.1.1.2
SNMP::Info::_load_attr i_voice_vlan : CISCO-VLAN-MEMBERSHIP-MIB::vmVoiceVlanId
: .1.3.6.1.4.1.9.9.68.1.5.1.1.1
BEGIN WORK
DELETE FROM device_port_vlan
WHERE ip = '172.17.213.10'
[33474] 2021-03-11 14:33:22 debug [172.17.213.10] vlans - removed 0 port VLANs
SAVEPOINT savepoint_0
INSERT INTO device_port_vlan( egress_tag, ip, last_discover, native, port,
vlan, vlantype )
VALUES( ?, ?, now( ), ?, ?, ?, ? ) : '__BULK_INSERT__'
RELEASE SAVEPOINT savepoint_0
[33474] 2021-03-11 14:33:22 debug [172.17.213.10] vlans - added 48 new port
VLANs
COMMIT
BEGIN WORK
DELETE FROM device_vlan
WHERE ip = '172.17.213.10'
[33474] 2021-03-11 14:33:22 debug [172.17.213.10] vlans - removed 14 device
VLANs
SAVEPOINT savepoint_0
INSERT INTO device_vlan( description, ip, last_discover, vlan )
VALUES( ?, ?, now( ), ? ) : '__BULK_INSERT__'
RELEASE SAVEPOINT savepoint_0
[33474] 2021-03-11 14:33:22 debug [172.17.213.10] vlans - added 14 new device
VLANs
COMMIT
[33474] 2021-03-11 14:33:22 debug [172.17.213.10] vlans - discovered for ports
and device
[33474] 2021-03-11 14:33:22 debug -> run worker main/wireless/100
error:snmp_translate_obj:Unknown OID i_ssidlist
SNMP::Info::_validate_autoload_method(i_ssidlist) Unable to resolve method.
[33474] 2021-03-11 14:33:22 debug -> run worker main/withnodes/0
[33474] 2021-03-11 14:33:22 debug Queued macsuck and arpnip for 172.17.213.10.
[33474] 2021-03-11 14:33:22 debug => running workers for phase: late
[33474] 2021-03-11 14:33:22 debug -> run worker late/hooks/0
[33474] 2021-03-11 14:33:22 debug [172.17.213.10] hooks - 0 queued
[33474] 2021-03-11 14:33:22 info discover: finished at Thu Mar 11 09:33:22 2021
[33474] 2021-03-11 14:33:22 info discover: status done: Ended discover for
172.17.213.10
This is a fresh installation that just started looking at my network:
Statistics for this installation
307 devices with 4,072 IPs
11,476 interfaces of which 6,016 are up
336 layer 2 links between devices
11,893 nodes logged, of which 10,470 are active
9,102 IPs logged, of which 9,092 are active
Statistics last generated on 2021-03-10
Built using Open Source
Software Version
App::Netdisco 2.47.5
SNMP::Info 3.71
DB Schema 64
PostgreSQL 10.00.16
Perl 5.26.1
My sample node has two links, one which has CDP and OSPF on it, and a second
which only has OSPF.
What have I missed?
ERM
Evan R Moore
Network Engineer and Bitwrangler
FirstLight
5 Canal Street | Bellows Falls, VT 05101 Office 802-463-2111 | Fax 802-460-2113
mailto:[email protected] | http://www.firstlight.net This email may contain
FirstLight confidential and/or privileged information. If you are not the
intended recipient, you are directed not to read, disclose or otherwise use
this transmission and to immediately delete same. Delivery of this message is
not intended to waive any applicable privileges.
--- End Message ---
