--- Begin Message ---
Thank you for your support. If it wasn't bizarre, then it probably
wouldn't be an issue
> You said you disabled arpnip and macsuck, but I'm still seeing log
entries for arpnip and macsuck. Did you restart the netdisco daemon?
The issue is some where in the discovery code, so the macwalk and the
arpwalk are just cluttering up the logs.
I will disable them.
> Can you confirm that there were no physical changes to the device
while you were running discovers? How many actual interfaces are on this
device?
No one is making any changes to the device (physical or configuration).
The device has 68 interfaces.
My device table now has only 16 devices:
I am still trying to isolate the issue.
So I am going to disable the aprwalk, disable the macwalk, and set the
discover to run once an hour during the day.
I have also set my works back to "AUTO * 2" == 32 workers
schedule:
discoverall:
when: '1 9,10,11,12,1,2,3,4,5 * * *'
expire:
when: '20 23 * * *'
workers:
tasks: 'AUTO * 2'
---------------
This is getting really bizarre.
I just ran a manual discover on the device (which has 68 interface), but
the discover only found 2 interfaces,
and 1 of the interfaces got set with ifindex value. Attached are some
log files.
--Ed.
On 02/10/16 16:22, Steven Xu wrote:
Hi Edward,
I don't have a solution yet, but I'm offering my observations in case
anyone wants to add to this. I'll ponder a solution tomorrow
(hopefully after you can answer some of the following questions).
You have no shortage of /bizarre/ results:
You said you disabled arpnip and macsuck, but I'm still seeing log
entries for arpnip and macsuck. Did you restart the netdisco daemon?
On several occasions, Netdisco is trying to connect to the same
device with different SNMP Classes and SNMP versions, timing out
after 20 seconds if it isn't able to connect. I suspect this is
caused by your Netdisco SNMP configuration or with the code.
I find it interesting that at 15:07:37 of your logs, it says the
device has 9 interfaces, but on the next discover at 16:07:37, it
removes 68 interfaces. How is netdisco removing more interfaces
than were already there?
Is this after you purged your database? Still very confusing to me.
Can you confirm that there were no physical changes to the device
while you were running discovers? How many actual interfaces are
on this device?
In addition, on two discovers, it fails to update the ports
because it is not able to get the uptime for the device. This
might be caused by the fact that you are discovering this device
too often, but this only happens to 1 of our 300 devices, and we
discover every four hours.
Netdisco also complains about a wrapped uptime two times out of
the four times it successfully updates device port entries, but
these messages aren't after sequential discovers. I would expect
that it would complain about a wrapped uptime all four times.
Steven
> select * from device_port where ip = '10.255.32.81';
ip | port | creation | descr
| up | up_admin | type | duplex | duplex_admin | speed |
name | mac | mtu | stp | remote_ip | remote_port |
remote_type | remote_id | vlan | pvid | lastchange | manual_topo | is_uplink |
slave_of | is_master
--------------+-----------------+----------------------------+-----------------+------+----------+----------------+--------+--------------+----------+----------------------+-------------------+------+-----+-----------+-------------+-------------+-----------+------+------+------------+-------------+-----------+----------+-----------
10.255.32.81 | FastEthernet0/0 | 2016-02-11 08:54:40.978831 | FastEthernet0/0
| up | up | ethernetCsmacd | full | | 100 Mbps |
[L]HLETS01K Fa1/0/13 | 00:15:fa:2f:e1:80 | 1500 | | |
| | | | | 4779 | f |
| | f
10.255.32.81 | 2 | 2016-02-11 08:54:40.978831 |
| down | down | ethernetCsmacd | | | 100 Mbps | Fa0/1
| 00:15:fa:2f:e1:81 | 1500 | | | |
| | | | 4208 | f | |
| f
(2 rows)
$ netdisco-do -DIQS discover -d 10.255.32.81
---------------------------------------------------
[27181] 2016-02-11 14:48:58 info App::Netdisco version 2.033005 loaded.
[31mSELECT[0m me.version, me.installed
[36mFROM[0m dbix_class_schema_versions me
[32mWHERE[0m 1 = 0
[31mSELECT[0m me.version
[36mFROM[0m dbix_class_schema_versions me
[33mORDER BY[0m installed DESC
[32mLIMIT[0m [30;45m'1'[0m
[31mSELECT[0m me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
[36mFROM[0m device_ip me
[32mWHERE[0m me.alias = [30;45m'10.255.32.81'[0m AND me.ip =
[30;45m'10.255.32.81'[0m
[31mSELECT[0m me.ip, me.creation, me.dns, me.description, me.uptime,
me.contact, me.name, me.location, me.layers, me.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.vtp_domain, me.last_discover, me.last_macsuck,
me.last_arpnip, to_char( last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char(
last_discover, 'YYYY-MM-DD HH24:MI' ), to_char( last_macsuck, 'YYYY-MM-DD
HH24:MI' ), extract( epoch
[36mFROM[0m age( now( ), last_arpnip ) ), extract( epoch
[36mFROM[0m age( now( ), last_discover ) ), extract( epoch
[36mFROM[0m age( now( ), last_macsuck ) ), replace( age( timestamp
'epoch' + uptime / 100 * interval '1 second', timestamp '1970-01-01
00:00:00-00' ) ::text, 'mon', 'month' )
[36mFROM[0m device me
[32mWHERE[0m me.ip = [30;45m'10.255.32.81'[0m
[27181] 2016-02-11 14:48:59 info discover: started at Thu Feb 11 08:48:59 2016
[31mSELECT[0m me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
[36mFROM[0m device_ip me
[32mWHERE[0m me.alias = [30;45m'10.255.32.81'[0m AND me.ip =
[30;45m'10.255.32.81'[0m
[31mSELECT[0m me.ip, me.creation, me.dns, me.description, me.uptime,
me.contact, me.name, me.location, me.layers, me.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.vtp_domain, me.last_discover, me.last_macsuck,
me.last_arpnip, to_char( last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char(
last_discover, 'YYYY-MM-DD HH24:MI' ), to_char( last_macsuck, 'YYYY-MM-DD
HH24:MI' ), extract( epoch
[36mFROM[0m age( now( ), last_arpnip ) ), extract( epoch
[36mFROM[0m age( now( ), last_discover ) ), extract( epoch
[36mFROM[0m age( now( ), last_macsuck ) ), replace( age( timestamp
'epoch' + uptime / 100 * interval '1 second', timestamp '1970-01-01
00:00:00-00' ) ::text, 'mon', 'month' )
[36mFROM[0m device me
[32mWHERE[0m me.ip = [30;45m'10.255.32.81'[0m
[31mSELECT[0m me.ip, me.snmp_comm_rw, me.snmp_auth_tag
[36mFROM[0m community me
[32mWHERE[0m me.ip = [30;45m'10.255.32.81'[0m
[31mSELECT[0m me.ip, me.snmp_comm_rw, me.snmp_auth_tag
[36mFROM[0m community me
[32mWHERE[0m me.ip = [30;45m'10.255.32.81'[0m
[31mSELECT[0m me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
[36mFROM[0m device_ip me
[32mWHERE[0m me.alias = [30;45m'10.255.32.81'[0m AND me.ip =
[30;45m'10.255.32.81'[0m
[31mSELECT[0m me.ip, me.creation, me.dns, me.description, me.uptime,
me.contact, me.name, me.location, me.layers, me.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.vtp_domain, me.last_discover, me.last_macsuck,
me.last_arpnip, to_char( last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char(
last_discover, 'YYYY-MM-DD HH24:MI' ), to_char( last_macsuck, 'YYYY-MM-DD
HH24:MI' ), extract( epoch
[36mFROM[0m age( now( ), last_arpnip ) ), extract( epoch
[36mFROM[0m age( now( ), last_discover ) ), extract( epoch
[36mFROM[0m age( now( ), last_macsuck ) ), replace( age( timestamp
'epoch' + uptime / 100 * interval '1 second', timestamp '1970-01-01
00:00:00-00' ) ::text, 'mon', 'month' )
[36mFROM[0m device me
[32mWHERE[0m me.ip = [30;45m'10.255.32.81'[0m
[31mSELECT[0m me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
[36mFROM[0m device_ip me
[32mWHERE[0m me.alias = [30;45m'10.255.32.81'[0m AND me.ip =
[30;45m'10.255.32.81'[0m
[31mSELECT[0m me.ip, me.creation, me.dns, me.description, me.uptime,
me.contact, me.name, me.location, me.layers, me.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.vtp_domain, me.last_discover, me.last_macsuck,
me.last_arpnip, to_char( last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char(
last_discover, 'YYYY-MM-DD HH24:MI' ), to_char( last_macsuck, 'YYYY-MM-DD
HH24:MI' ), extract( epoch
[36mFROM[0m age( now( ), last_arpnip ) ), extract( epoch
[36mFROM[0m age( now( ), last_discover ) ), extract( epoch
[36mFROM[0m age( now( ), last_macsuck ) ), replace( age( timestamp
'epoch' + uptime / 100 * interval '1 second', timestamp '1970-01-01
00:00:00-00' ) ::text, 'mon', 'month' )
[36mFROM[0m device me
[32mWHERE[0m me.ip = [30;45m'10.255.32.81'[0m
[31mSELECT[0m me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
[36mFROM[0m device_ip me
[32mWHERE[0m me.alias = [30;45m'10.255.32.81'[0m AND me.ip =
[30;45m'10.255.32.81'[0m
[31mSELECT[0m me.ip, me.creation, me.dns, me.description, me.uptime,
me.contact, me.name, me.location, me.layers, me.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.vtp_domain, me.last_discover, me.last_macsuck,
me.last_arpnip, to_char( last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char(
last_discover, 'YYYY-MM-DD HH24:MI' ), to_char( last_macsuck, 'YYYY-MM-DD
HH24:MI' ), extract( epoch
[36mFROM[0m age( now( ), last_arpnip ) ), extract( epoch
[36mFROM[0m age( now( ), last_discover ) ), extract( epoch
[36mFROM[0m age( now( ), last_macsuck ) ), replace( age( timestamp
'epoch' + uptime / 100 * interval '1 second', timestamp '1970-01-01
00:00:00-00' ) ::text, 'mon', 'month' )
[36mFROM[0m device me
[32mWHERE[0m me.ip = [30;45m'10.255.32.81'[0m
[27181] 2016-02-11 14:48:59 debug [10.255.32.81] try_connect with ver: 2,
class: SNMP::Info::Layer3::Cisco, comm: <hidden>
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/rfc
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/net-snmp
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/cisco
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/avaya
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/nortel
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/hp
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/h3c
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/3com
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/apc
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/aruba
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/checkpoint
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/dell
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/d-link
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/f5
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/huawei
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/juniper
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/netgear
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/netapp
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/paloalto
Read CISCO-VLAN-IFTABLE-RELATIONSHIP-MIB
Read OLD-CISCO-SYS-MIB
Read BRIDGE-MIB
Read EtherLike-MIB
Read ADSL-LINE-MIB
Read CISCO-POWER-ETHERNET-EXT-MIB
Read SNMPv2-MIB
Read OSPF-MIB
Read CISCO-IETF-IP-MIB
Read CISCO-PRODUCTS-MIB
Read LLDP-MIB
Read CISCO-RTTMON-MIB
Read POWER-ETHERNET-MIB
Read IP-MIB
Read Q-BRIDGE-MIB
Read IPV6-MIB
Read CISCO-VTP-MIB
Read LLDP-EXT-DOT1-MIB
Read CISCO-CLASS-BASED-QOS-MIB
Read CISCO-CDP-MIB
Read OLD-CISCO-SYSTEM-MIB
Read CISCO-EIGRP-MIB
Read CISCO-IMAGE-MIB
Read CISCO-STACK-MIB
Read CISCO-CONFIG-COPY-MIB
Read CISCO-STP-EXTENSIONS-MIB
Read CISCO-FLASH-MIB
Read CISCO-ENTITY-VENDORTYPE-OID-MIB
Read ENTITY-MIB
Read LLDP-EXT-DOT3-MIB
Read BGP4-MIB
Read CISCO-VLAN-MEMBERSHIP-MIB
Read CISCO-MEMORY-POOL-MIB
Read CISCO-PROCESS-MIB
SNMP::Info::_global(uptime) Timeout at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Util/SNMP.pm line 176.
[27181] 2016-02-11 14:49:19 debug [10.255.32.81] try_connect with ver: 2,
class: SNMP::Info, comm: <hidden>
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/rfc
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/net-snmp
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/cisco
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/avaya
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/nortel
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/hp
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/h3c
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/3com
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/apc
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/aruba
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/checkpoint
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/dell
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/d-link
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/f5
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/huawei
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/juniper
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/netgear
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/netapp
snmp_add_mib_dir: Added mib dir /opt/NetDisco/netdisco/netdisco-mibs/paloalto
[30;47mBEGIN WORK[0m
[30;47mCOMMIT[0m
[30;47mBEGIN WORK[0m
[30;47mCOMMIT[0m
[27181] 2016-02-11 14:49:20 debug [10.255.32.81] try_connect with ver: 2, new
class: SNMP::Info::Layer3::Cisco, comm: <hidden>
Looping on: ip_index iid:10.255.32.81. at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 95.
Looping on: i_index iid:2. at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 96.
Looping on: i_description iid:1. at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 96.
[27181] 2016-02-11 14:50:20 debug [10.255.32.81] device - aliased as
10.255.32.81
[27181] 2016-02-11 14:50:20 debug resolving 1 aliases with max 80 outstanding
requests
SNMP::Info::_global(uptime) Timeout at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 155.
error:snmp_translate_obj:Unknown OID ps1_type
error:snmp_translate_obj:Unknown OID ps2_type
error:snmp_translate_obj:Unknown OID ps1_status
error:snmp_translate_obj:Unknown OID ps2_status
error:snmp_translate_obj:Unknown OID fan
error:snmp_translate_obj:Unknown OID slots
Looping on: e_parent iid:3. at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 159.
[30;47mBEGIN WORK[0m
[31mDELETE FROM[0m device_ip
[32mWHERE[0m ip = [30;45m'10.255.32.81'[0m
[27181] 2016-02-11 14:51:00 debug [10.255.32.81] device - removed 1 aliases
[30;47mSAVEPOINT[0m savepoint_0
[31mUPDATE[0m device
[36mSET[0m last_discover = now( ), uptime = [30;45mNULL[0m
[32mWHERE[0m ip = [30;45m'10.255.32.81'[0m
[30;47mRELEASE SAVEPOINT[0m savepoint_0
[30;47mSAVEPOINT[0m savepoint_0
[31mINSERT INTO[0m device_ip( alias, dns, ip, port, subnet )
[33mVALUES[0m( ?, ?, ?, ?, ? ) : '__BULK_INSERT__'
[30;47mRELEASE SAVEPOINT[0m savepoint_0
[27181] 2016-02-11 14:51:00 debug [10.255.32.81] device - added 1 new aliases
[30;47mCOMMIT[0m
Looping on: i_type iid:7. at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 189.
error:snmp_translate_obj:Unknown OID i_ignore
Looping on: i_mtu iid:16. at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 192.
Looping on: orig_i_speed iid:8. at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 193.
Looping on: i_speed_high iid:1. at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 193.
Looping on: i_up iid:4. at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 195.
Looping on: i_up_admin iid:11. at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 196.
Looping on: orig_i_name iid:5. at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 197.
error:snmp_translate_obj:Unknown OID i_duplex_admin
SNMP::Info::_load_attr: stp_p_state not here at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 200.
Looping on: i_lastchange iid:7. at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 202.
error:snmp_translate_obj:Unknown OID agg_ports
[27181] 2016-02-11 14:54:40 info [10.255.32.81] interface - device uptime
wrapped 2 times - correcting
[30;47mBEGIN WORK[0m
[31mDELETE FROM[0m device_port_power
[32mWHERE[0m ip IN (
[31mSELECT[0m me.ip
[36mFROM[0m device_port me
[32mWHERE[0m me.ip = [30;45m'10.255.32.81'[0m
)
[31mDELETE FROM[0m device_port_vlan
[32mWHERE[0m ip IN (
[31mSELECT[0m me.ip
[36mFROM[0m device_port me
[32mWHERE[0m me.ip = [30;45m'10.255.32.81'[0m
)
[31mDELETE FROM[0m device_port_wireless
[32mWHERE[0m ip IN (
[31mSELECT[0m me.ip
[36mFROM[0m device_port me
[32mWHERE[0m me.ip = [30;45m'10.255.32.81'[0m
)
[31mDELETE FROM[0m device_port_ssid
[32mWHERE[0m ip IN (
[31mSELECT[0m me.ip
[36mFROM[0m device_port me
[32mWHERE[0m me.ip = [30;45m'10.255.32.81'[0m
)
[31mDELETE FROM[0m device_port
[32mWHERE[0m ip = [30;45m'10.255.32.81'[0m
[27181] 2016-02-11 14:54:41 debug [10.255.32.81] interfaces - removed 7
interfaces
[30;47mSAVEPOINT[0m savepoint_0
[31mUPDATE[0m device
[36mSET[0m uptime = [30;45m'12664147750'[0m
[32mWHERE[0m ip = [30;45m'10.255.32.81'[0m
[30;47mRELEASE SAVEPOINT[0m savepoint_0
[30;47mSAVEPOINT[0m savepoint_0
[31mINSERT INTO[0m device_port( descr, duplex, duplex_admin, ip, is_master,
lastchange, mac, mtu, name, port, pvid, slave_of, speed, stp, type, up,
up_admin, vlan )
[33mVALUES[0m( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) :
'__BULK_INSERT__'
[30;47mRELEASE SAVEPOINT[0m savepoint_0
[27181] 2016-02-11 14:54:41 debug [10.255.32.81] interfaces - added 2 new
interfaces
[30;47mCOMMIT[0m
error:snmp_translate_obj:Unknown OID i_ssidlist
SNMP::Info::_load_attr: vtp_trunk_dyn not here at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 429.
SNMP::Info::_load_attr: v_state not here at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 430.
SNMP::Info::_load_attr: i_vlan2 not here at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 430.
SNMP::Info::_load_attr: i_vlan_type not here at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 431.
[30;47mBEGIN WORK[0m
[31mDELETE FROM[0m device_vlan
[32mWHERE[0m ip = [30;45m'10.255.32.81'[0m
[27181] 2016-02-11 14:56:01 debug [10.255.32.81] vlans - removed 3 device VLANs
[30;47mSAVEPOINT[0m savepoint_0
[31mINSERT INTO[0m device_vlan( description, ip, last_discover, vlan )
[33mVALUES[0m( ?, ?, now( ), ? ) : '__BULK_INSERT__'
[30;47mRELEASE SAVEPOINT[0m savepoint_0
[27181] 2016-02-11 14:56:01 debug [10.255.32.81] vlans - added 5 new device
VLANs
[30;47mCOMMIT[0m
[30;47mBEGIN WORK[0m
[31mDELETE FROM[0m device_port_vlan
[32mWHERE[0m ip = [30;45m'10.255.32.81'[0m
[27181] 2016-02-11 14:56:01 debug [10.255.32.81] vlans - removed 0 port VLANs
[27181] 2016-02-11 14:56:01 debug [10.255.32.81] vlans - added 0 new port VLANs
[30;47mCOMMIT[0m
[27181] 2016-02-11 14:56:01 debug [10.255.32.81] power - 0 power modules
Looping on: entPhysicalDescr iid:2. at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 576.
Looping on: e_descr iid:14. at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 608.
Looping on: e_type iid:4. at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 609.
SNMP::Info::_load_attr: e_name not here at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 611.
Looping on: e_class iid:1. at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 612.
Looping on: e_pos iid:4. at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 613.
SNMP::Info::_load_attr: e_fwver not here at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 615.
SNMP::Info::_load_attr: e_swver not here at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 616.
Looping on: e_model iid:5. at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 617.
SNMP::Info::_load_attr: e_serial not here at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 618.
Looping on: e_fru iid:2. at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 619.
[30;47mBEGIN WORK[0m
[31mDELETE FROM[0m device_module
[32mWHERE[0m ip = [30;45m'10.255.32.81'[0m
[27181] 2016-02-11 15:00:01 debug [10.255.32.81] modules - removed 5 chassis
modules
[30;47mSAVEPOINT[0m savepoint_0
[31mINSERT INTO[0m device_module( class, description, fru, fw_ver, hw_ver,
index, ip, last_discover, model, name, parent, pos, serial, sw_ver, type )
[33mVALUES[0m( ?, ?, ?, ?, ?, ?, ?, now( ), ?, ?, ?, ?, ?, ?, ? ) :
'__BULK_INSERT__'
[30;47mRELEASE SAVEPOINT[0m savepoint_0
[27181] 2016-02-11 15:00:01 debug [10.255.32.81] modules - added 2 new chassis
modules
[30;47mCOMMIT[0m
[30;47mBEGIN WORK[0m
[31mUPDATE[0m device_port
[36mSET[0m manual_topo = false
[32mWHERE[0m ip = [30;45m'10.255.32.81'[0m
[27181] 2016-02-11 15:00:01 debug [10.255.32.81] neigh - setting manual
topology links
[31mSELECT[0m me.dev1, me.port1, me.dev2, me.port2
[36mFROM[0m topology me
[32mWHERE[0m dev1 = [30;45m'10.255.32.81'[0m OR dev2 =
[30;45m'10.255.32.81'[0m
[30;47mCOMMIT[0m
SNMP::Info::_global uptime : DISMAN-EVENT-MIB::sysUpTimeInstance :
.1.3.6.1.2.1.1.3.0
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.31
SNMP::Info::device_type() layers:01001110 id:9 sysDescr:"Cisco IOS Software,
2800 Software (C2800NM-SPSERVICESK9-M), Version 12.4(25d), RELEASE SOFTWARE
(fc1) Technical Support: http://www.cisco.com/techsupport Copyright (c)
1986-2010 by Cisco Systems, Inc. Compiled Wed 18-Aug-10 06:10 by prod_rel_team"
SNMP::Info 3.31
SNMP::Info::device_type() layers:01001110 id:9 sysDescr:"Cisco IOS Software,
2800 Software (C2800NM-SPSERVICESK9-M), Version 12.4(25d), RELEASE SOFTWARE
(fc1) Technical Support: http://www.cisco.com/techsupport Copyright (c)
1986-2010 by Cisco Systems, Inc. Compiled Wed 18-Aug-10 06:10 by prod_rel_team"
SNMP::Info::_load_attr ip_index : IP-MIB::ipAdEntIfIndex : .1.3.6.1.2.1.4.20.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_description : IF-MIB::ifDescr : .1.3.6.1.2.1.2.2.1.2
SNMP::Info::_load_attr ip_netmask : IP-MIB::ipAdEntNetMask :
.1.3.6.1.2.1.4.20.1.3
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 description : SNMPv2-MIB::sysDescr.0 : .1.3.6.1.2.1.1.1.0
SNMP::Info::_global uptime : DISMAN-EVENT-MIB::sysUpTimeInstance :
.1.3.6.1.2.1.1.3.0
SNMP::Info::_global contact : SNMPv2-MIB::sysContact.0 : .1.3.6.1.2.1.1.4.0
SNMP::Info::_global name : SNMPv2-MIB::sysName.0 : .1.3.6.1.2.1.1.5.0
SNMP::Info::_global location : SNMPv2-MIB::sysLocation.0 : .1.3.6.1.2.1.1.6.0
SNMP::Info::_global layers : SNMPv2-MIB::sysServices.0 : .1.3.6.1.2.1.1.7.0
SNMP::Info::_global ports : IF-MIB::ifNumber.0 : .1.3.6.1.2.1.2.1.0
SNMP::Info::_global mac : IF-MIB::ifPhysAddress.1 : .1.3.6.1.2.1.2.2.1.6.1
SNMP::Info::_validate_autoload_method(ps1_type) Unable to resolve method.
SNMP::Info::_validate_autoload_method(ps2_type) Unable to resolve method.
SNMP::Info::_validate_autoload_method(ps1_status) Unable to resolve method.
SNMP::Info::_validate_autoload_method(ps2_status) Unable to resolve method.
SNMP::Info::_validate_autoload_method(fan) Unable to resolve method.
SNMP::Info::_validate_autoload_method(slots) Unable to resolve method.
SNMP::Info::_global id : SNMPv2-MIB::sysObjectID.0 : .1.3.6.1.2.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::_load_attr e_parent : ENTITY-MIB::entPhysicalContainedIn :
.1.3.6.1.2.1.47.1.1.1.1.4
SNMP::Info::_load_attr e_serial : ENTITY-MIB::entPhysicalSerialNum(1) :
.1.3.6.1.2.1.47.1.1.1.1.11.1
SNMP::Info::_load_attr i_type : IF-MIB::ifType : .1.3.6.1.2.1.2.2.1.3
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 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_index : EtherLike-MIB::dot3StatsIndex :
.1.3.6.1.2.1.10.7.2.1.1
SNMP::Info::_load_attr el_duplex : EtherLike-MIB::dot3StatsDuplexStatus :
.1.3.6.1.2.1.10.7.2.1.19
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 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::_validate_autoload_method(agg_ports) Unable to resolve method.
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::_validate_autoload_method(i_ssidlist) Unable to resolve method.
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 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 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_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_stat :
CISCO-VTP-MIB::vlanTrunkPortDynamicStatus : .1.3.6.1.4.1.9.9.46.1.6.1.1.14
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 i_voice_vlan : CISCO-VLAN-MEMBERSHIP-MIB::vmVoiceVlanId
: .1.3.6.1.4.1.9.9.68.1.5.1.1.1
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 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
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_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
SNMPSNMP::Info::_global(lldp_sys_cap) NOSUCHOBJECT at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 676.
error:snmp_translate_obj:Unknown OID hasSONMP
error:snmp_translate_obj:Unknown OID hasFDP
error:snmp_translate_obj:Unknown OID hasEDP
error:snmp_translate_obj:Unknown OID hasAMAP
Looping on: cdp_proto iid:1.13022. at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 676.
SNMP::Info::_global(lldp_sys_cap) Timeout at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 683.
SNMP::Info::_load_attr: lldp_rem_id not here at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 683.
error:snmp_translate_obj:Unknown OID hasSONMP
error:snmp_translate_obj:Unknown OID hasFDP
error:snmp_translate_obj:Unknown OID hasEDP
error:snmp_translate_obj:Unknown OID hasAMAP
SNMP::Info::_global(lldp_sys_cap) Timeout at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 684.
error:snmp_translate_obj:Unknown OID hasSONMP
error:snmp_translate_obj:Unknown OID hasFDP
error:snmp_translate_obj:Unknown OID hasEDP
error:snmp_translate_obj:Unknown OID hasAMAP
Looping on: cdp_port iid:1.13022. at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 684.
SNMP::Info::_global(lldp_sys_cap) NOSUCHOBJECT at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 685.
error:snmp_translate_obj:Unknown OID hasSONMP
error:snmp_translate_obj:Unknown OID hasFDP
error:snmp_translate_obj:Unknown OID hasEDP
error:snmp_translate_obj:Unknown OID hasAMAP
Looping on: cdp_dev_id iid:1.13022. at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 685.
SNMP::Info::_global(lldp_sys_cap) NOSUCHOBJECT at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 686.
error:snmp_translate_obj:Unknown OID hasSONMP
error:snmp_translate_obj:Unknown OID hasFDP
error:snmp_translate_obj:Unknown OID hasEDP
error:snmp_translate_obj:Unknown OID hasAMAP
SNMP::Info::_global(lldp_sys_cap) NOSUCHOBJECT at
/opt/NetDisco/netdisco/perl5/lib/perl5/App/Netdisco/Core/Discover.pm line 687.
error:snmp_translate_obj:Unknown OID hasSONMP
error:snmp_translate_obj:Unknown OID hasFDP
error:snmp_translate_obj:Unknown OID hasEDP
error:snmp_translate_obj:Unknown OID hasAMAP
[31mSELECT[0m me.ip, me.port, me.creation, me.descr, me.up, me.up_admin,
me.type, me.duplex, me.duplex_admin, me.speed, 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
[36mFROM[0m device_port me
[32mWHERE[0m ip = [30;45m'10.255.32.81'[0m AND port =
[30;45m'FastEthernet0/0'[0m
[30;47mBEGIN WORK[0m
[31mUPDATE[0m device_port
[36mSET[0m remote_type = [30;45m'cisco WS-C3750-24FS'[0m
[32mWHERE[0m ip = [30;45m'10.255.32.81'[0m AND port =
[30;45m'FastEthernet0/0'[0m
[30;47mCOMMIT[0m
[27181] 2016-02-11 15:02:01 debug [10.255.32.81] neigh - adding neighbor
10.255.32.69, type [cisco WS-C3750-24FS], on FastEthernet0/0 to discovery queue
[31mSELECT[0m me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
[36mFROM[0m device_ip me
[32mWHERE[0m me.alias = [30;45m'10.255.32.69'[0m AND me.ip =
[30;45m'10.255.32.69'[0m
[31mSELECT[0m me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
[36mFROM[0m device_ip me
[32mWHERE[0m alias = [30;45m'10.255.32.69'[0m
[31mSELECT[0m me.ip, me.creation, me.dns, me.description, me.uptime,
me.contact, me.name, me.location, me.layers, me.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.vtp_domain, me.last_discover, me.last_macsuck,
me.last_arpnip, to_char( last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char(
last_discover, 'YYYY-MM-DD HH24:MI' ), to_char( last_macsuck, 'YYYY-MM-DD
HH24:MI' ), extract( epoch
[36mFROM[0m age( now( ), last_arpnip ) ), extract( epoch
[36mFROM[0m age( now( ), last_discover ) ), extract( epoch
[36mFROM[0m age( now( ), last_macsuck ) ), replace( age( timestamp
'epoch' + uptime / 100 * interval '1 second', timestamp '1970-01-01
00:00:00-00' ) ::text, 'mon', 'month' )
[36mFROM[0m device me
[32mWHERE[0m me.ip = [30;45m'10.255.32.69'[0m
[30;47mBEGIN WORK[0m
[31mUPDATE[0m device_port
[36mSET[0m is_uplink = true, manual_topo = false, remote_id =
[30;45m'hlets01k.itg.ti.com'[0m, remote_ip = [30;45m'10.255.32.69'[0m,
remote_port = [30;45m'FastEthernet1/0/13'[0m
[32mWHERE[0m ip = [30;45m'10.255.32.81'[0m AND port =
[30;45m'FastEthernet0/0'[0m
[30;47mCOMMIT[0m
[31mSELECT[0m me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
[36mFROM[0m device_ip me
[32mWHERE[0m me.alias = [30;45m'10.255.32.69'[0m AND me.ip =
[30;45m'10.255.32.69'[0m
[31mSELECT[0m me.ip, me.alias, me.subnet, me.port, me.dns, me.creation
[36mFROM[0m device_ip me
[32mWHERE[0m alias = [30;45m'10.255.32.69'[0m
[31mSELECT[0m me.ip, me.creation, me.dns, me.description, me.uptime,
me.contact, me.name, me.location, me.layers, me.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.vtp_domain, me.last_discover, me.last_macsuck,
me.last_arpnip, to_char( last_arpnip, 'YYYY-MM-DD HH24:MI' ), to_char(
last_discover, 'YYYY-MM-DD HH24:MI' ), to_char( last_macsuck, 'YYYY-MM-DD
HH24:MI' ), extract( epoch
[36mFROM[0m age( now( ), last_arpnip ) ), extract( epoch
[36mFROM[0m age( now( ), last_discover ) ), extract( epoch
[36mFROM[0m age( now( ), last_macsuck ) ), replace( age( timestamp
'epoch' + uptime / 100 * interval '1 second', timestamp '1970-01-01
00:00:00-00' ) ::text, 'mon', 'month' )
[36mFROM[0m device me
[32mWHERE[0m me.ip = [30;45m'10.255.32.69'[0m
[27181] 2016-02-11 15:02:01 debug is_discoverable: device failed to match
discover_only
[27181] 2016-02-11 15:02:01 debug queue - 10.255.32.69, type [cisco
WS-C3750-24FS] excluded by discover_* config
[27181] 2016-02-11 15:02:01 info discover: finished at Thu Feb 11 09:02:01 2016
[27181] 2016-02-11 15:02:01 info discover: status done: Ended discover for
10.255.32.81
::Info::_global lldp_sys_cap : LLDP-MIB::lldpLocSysCapEnabled.0 :
.1.0.8802.1.1.2.1.3.6.0
SNMP::Info::_load_attr lldp_rem_id : LLDP-MIB::lldpRemChassisId :
.1.0.8802.1.1.2.1.4.1.1.5
SNMP::Info::_global cdp_run : CISCO-CDP-MIB::cdpGlobalRun.0 :
.1.3.6.1.4.1.9.9.23.1.3.1.0
SNMP::Info::_validate_autoload_method(hasSONMP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasFDP) 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 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
SNMP::Info::_global lldp_sys_cap : LLDP-MIB::lldpLocSysCapEnabled.0 :
.1.0.8802.1.1.2.1.3.6.0
SNMP::Info::_load_attr lldp_rem_id : LLDP-MIB::lldpRemChassisId :
.1.0.8802.1.1.2.1.4.1.1.5
SNMP::Info::_validate_autoload_method(hasSONMP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasFDP) 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(cdp_index :
.1.3.6.1.4.1.9.9.23.1.2.1.1.1) Not accessable for requested operation.
SNMP::Info::_global lldp_sys_cap : LLDP-MIB::lldpLocSysCapEnabled.0 :
.1.0.8802.1.1.2.1.3.6.0
SNMP::Info::_load_attr lldp_rem_id : LLDP-MIB::lldpRemChassisId :
.1.0.8802.1.1.2.1.4.1.1.5
SNMP::Info::_validate_autoload_method(hasSONMP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasFDP) 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 cdp_port : CISCO-CDP-MIB::cdpCacheDevicePort :
.1.3.6.1.4.1.9.9.23.1.2.1.1.7
SNMP::Info::_global lldp_sys_cap : LLDP-MIB::lldpLocSysCapEnabled.0 :
.1.0.8802.1.1.2.1.3.6.0
SNMP::Info::_load_attr lldp_rem_id : LLDP-MIB::lldpRemChassisId :
.1.0.8802.1.1.2.1.4.1.1.5
SNMP::Info::_validate_autoload_method(hasSONMP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasFDP) 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 cdp_dev_id : CISCO-CDP-MIB::cdpCacheDeviceId :
.1.3.6.1.4.1.9.9.23.1.2.1.1.6
SNMP::Info::_global lldp_sys_cap : LLDP-MIB::lldpLocSysCapEnabled.0 :
.1.0.8802.1.1.2.1.3.6.0
SNMP::Info::_load_attr lldp_rem_id : LLDP-MIB::lldpRemChassisId :
.1.0.8802.1.1.2.1.4.1.1.5
SNMP::Info::_validate_autoload_method(hasSONMP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasFDP) 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 cdp_platform : CISCO-CDP-MIB::cdpCachePlatform :
.1.3.6.1.4.1.9.9.23.1.2.1.1.8
SNMP::Info::_global lldp_sys_cap : LLDP-MIB::lldpLocSysCapEnabled.0 :
.1.0.8802.1.1.2.1.3.6.0
SNMP::Info::_load_attr lldp_rem_id : LLDP-MIB::lldpRemChassisId :
.1.0.8802.1.1.2.1.4.1.1.5
SNMP::Info::_validate_autoload_method(hasSONMP) Unable to resolve method.
SNMP::Info::_validate_autoload_method(hasFDP) 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 cdp_capabilities_raw :
CISCO-CDP-MIB::cdpCacheCapabilities : .1.3.6.1.4.1.9.9.23.1.2.1.1.9
--- End Message ---