Send netdisco-users mailing list submissions to
        [email protected]

To subscribe or unsubscribe via the World Wide Web, visit
        https://lists.sourceforge.net/lists/listinfo/netdisco-users
or, via email, send a message with subject or body 'help' to
        [email protected]

You can reach the person managing the list at
        [email protected]

When replying, please edit your Subject line so it is more specific
than "Re: Contents of netdisco-users digest..."
Today's Topics:

   1. Re: Add vendor name to Netdisco (Weidner,Andre)
   2. Port Report Help (Tobias Gerlach)
   3. Re: Port Report Help (Oliver Gorwits)
   4. Re: Add vendor name to Netdisco (Oliver Gorwits)
   5. macsuck on a cisco 4500-X fails (Derek Andree)
--- Begin Message ---
Hi,

thanks for your help. With the method you suggested, i could add 'Draytek' as 
vendor for our Router. The Zyxel switch however replies with an empty vendor 
field:

[30367] 2015-04-07 13:33:10  info show: started at Tue Apr  7 15:33:10 2015

[30367] 2015-04-07 13:33:10 debug [X.X.X.X] try_connect with ver: 2, class: 
SNMP::Info::Layer2, comm: <hidden>

""

[30367] 2015-04-07 13:33:10  info show: finished at Tue Apr  7 15:33:10 2015

[30367] 2015-04-07 13:33:10  info show: status done: Showed vendor response 
from X.X.X.X.

The output for a 'model'-query is on this device is "enterprises.890.5.1510". 

I'm stuck somehow.

-----Ursprüngliche Nachricht-----
Von: Oliver Gorwits [mailto:[email protected]]
Gesendet: Freitag, 3. April 2015 20:27
An: [email protected]
Betreff: Re: [Netdisco] Add vendor name to Netdisco

Hi Andre,

On 2015-04-02 12:19, Weidner,Andre wrote:
> i'm using Netdisco  2.032001. One of our switches is a Zyxel
> GS1510-16 which gets recognized as "unknown/enterprises.890.5.1510"
> (SNMP::Info::Layer2). I added the line "890  => 
> 'SNMP::Info::Layer2::Zyxel'" to 
> "/home/netdisco/perl5/lib/perl5/SNMP/Info.pm" in the " my 
> %l3sysoidmap" and " my %l2sysoidmap" sections. I restarted the 
> netdisco-daemon, deleted and rediscovered the device, but it still 
> shows up as "unknown". What changes have to be made to show the Vendor 
> correctly?

I'd take a look at the output of this command:

~netdisco/bin/netdisco-do show -d 1.2.3.4 -e vendor -D

It should show the device class (Layer2::Zyxel, if your change is working), and 
then the output of calling vendor() method on that class. 
You may need to edit the output of Layer2/Zyxel.pm to fix the output.

regards,
oliver.

------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored 
by Intel and developed in partnership with Slashdot Media, is your hub for all 
things parallel software development, from weekly thought leadership blogs to 
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Netdisco mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users



--- End Message ---
--- Begin Message ---
Hello,

I'm currently working on a custom switch port report.
But I don't know how to identify only that switch ports which were
active in the last month?
Can anybody help me with that and complete the SQL query?

select count(*) from device_port
  inner join device on device_port.ip=device.ip
   where (device.dns like 'dlnn8%') and device_port.type like 'ethernetCsmacd'
    and __ active within the last month __ ??

Thanks a lot!



--- End Message ---
--- Begin Message ---
Hi Tobias,

On 2015-04-07 14:47, Tobias Gerlach wrote:
I'm currently working on a custom switch port report.
But I don't know how to identify only that switch ports which were
active in the last month?
Can anybody help me with that and complete the SQL query?

You want the lastchange column of device_ports, but because of the specification of this data in the MIBs the SQL is a little hairy. This then needs combining with a check that the port state is UP (that is, the port changed to UP from another state). For example:

SELECT device_port.ip, device_port.port from device_port
LEFT JOIN device ON device_port.ip = device.ip
WHERE device_port.up = "up"
AND (device.last_discover - (device.uptime - device_port.lastchange) / 100 * interval '1 second')
     > (now() - interval '1 month');

You can also add something like this to show the lastchange as a column:

to_char(
(device.last_discover - (device.uptime - device_port.lastchange) / 100 * interval '1 second'),
 'YYYY-MM-DD HH24:MI:SS',
) as 'last_change'

Hope that helps,

regards,
oliver.




select count(*) from device_port
  inner join device on device_port.ip=device.ip
   where (device.dns like 'dlnn8%') and device_port.type like
'ethernetCsmacd'
    and __ active within the last month __ ??

Thanks a lot!


------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_

source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
Netdisco mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users




--- End Message ---
--- Begin Message ---
Hi Andre,

On 2015-04-07 14:45, Weidner,Andre wrote:
thanks for your help. With the method you suggested, i could add
'Draytek' as vendor for our Router. The Zyxel switch however replies
with an empty vendor field:

[30367] 2015-04-07 13:33:10 info show: started at Tue Apr 7 15:33:10 2015

[30367] 2015-04-07 13:33:10 debug [X.X.X.X] try_connect with ver: 2,
class: SNMP::Info::Layer2, comm: <hidden>

According to this, the device is not identified as Zyxel, because the class reported is the generic "SNMP::Info::Layer2".

So perhaps revisit your device selection patch to make sure the Zyxel class is activated for the platform?

And for info, the methods used on the class are model(), vendor(), os() and os_ver().

regards,
oliver.


""

[30367] 2015-04-07 13:33:10 info show: finished at Tue Apr 7 15:33:10 2015

[30367] 2015-04-07 13:33:10  info show: status done: Showed vendor
response from X.X.X.X.

The output for a 'model'-query is on this device is
"enterprises.890.5.1510".

I'm stuck somehow.

-----Ursprüngliche Nachricht-----
Von: Oliver Gorwits [mailto:[email protected]]
Gesendet: Freitag, 3. April 2015 20:27
An: [email protected]
Betreff: Re: [Netdisco] Add vendor name to Netdisco

Hi Andre,

On 2015-04-02 12:19, Weidner,Andre wrote:
i'm using Netdisco  2.032001. One of our switches is a Zyxel
GS1510-16 which gets recognized as "unknown/enterprises.890.5.1510"
(SNMP::Info::Layer2). I added the line "890  =>
'SNMP::Info::Layer2::Zyxel'" to
"/home/netdisco/perl5/lib/perl5/SNMP/Info.pm" in the " my
%l3sysoidmap" and " my %l2sysoidmap" sections. I restarted the
netdisco-daemon, deleted and rediscovered the device, but it still
shows up as "unknown". What changes have to be made to show the Vendor
correctly?

I'd take a look at the output of this command:

~netdisco/bin/netdisco-do show -d 1.2.3.4 -e vendor -D

It should show the device class (Layer2::Zyxel, if your change is
working), and then the output of calling vendor() method on that
class.
You may need to edit the output of Layer2/Zyxel.pm to fix the output.

regards,
oliver.


------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media,
is your hub for all things parallel software development, from weekly
thought leadership blogs to news, videos, case studies, tutorials and
more. Take a look and join the conversation now.
http://goparallel.sourceforge.net/
_______________________________________________
Netdisco mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users


------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_

source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
Netdisco mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users




--- End Message ---
--- Begin Message ---
I've been trying to macsuck on our new Cisco 4500-X switches and have been 
having the "Port X has no bp_index mapping. Skipping" issue which I've seen a 
few times on the mailing list.

The switch in question is:

Cisco 4500X32 running ios-xe version 03.07.00.E

Version(s) of various software:
[netdisco@netdis01 netdisco]$ ./netdisco -v
n e t  d i s c o
--------------------------------------------------
Netdisco Version   : 1.3.2
SNMP::Info Version : 3.26
Net-SNMP Version   : 5.05
Perl Version       : 118.53.46.49.48.46.49

Here is the abbreviated output from a debug enabled macsuck showing the problem:

[netdisco@netdis01 netdisco]$ ./netdisco -D -M 10.20.2.89
n e t  d i s c o
--------------------------------------------------
Using Config File : /usr/local/netdisco/netdisco.conf
macsuck(10.20.2.89) :
load_old_devices()
mac_getportmacs() ... found 3196 MACs.
  get_device(10.20.2.89)
  get_device(10.20.2.89) - Connecting using cached info: 10.20.2.89/t/2
  create_device(10.20.2.89,t,2*,AutoSpecify,bw:default)
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/allied
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/apc
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/arista
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/aruba
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/asante
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/cabletron
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/cisco
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/cyclades
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/dell
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/enterasys
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/extreme
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/foundry
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/hp
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/juniper
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/netscreen
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/nortel
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/rfc
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/net-snmp
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.26
SNMP::Info::device_type() layers:00000110 id:9 sysDescr:"Cisco IOS Software, 
IOS-XE Software, Catalyst 4500 L3 Switch  Software (cat4500e-UNIVERSALK9-M), 
Version 03.07.00.E RELEASE SOFTWARE (fc4) Technical Support: 
http://www.cisco.com/techsupport Copyright (c) 1986-2014 by Cisco Systems, Inc. 
Compiled Sun 0"
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/allied
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/apc
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/arista
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/aruba
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/asante
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/cabletron
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/cisco
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/cyclades
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/dell
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/enterasys
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/extreme
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/foundry
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/hp
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/juniper
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/netscreen
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/nortel
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/rfc
SNMP::Info::init() - Adding new mibdir:/usr/local/netdisco/mibs/net-snmp
SNMP::Info::specify() - Changed Class to SNMP::Info::Layer3::C4000.
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
[10.20.2.89]  Device Type : SNMP::Info::Layer3::C4000
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 qb_fw_port : Q-BRIDGE-MIB::dot1qTpFdbPort : 
.1.3.6.1.2.1.17.7.1.2.2.1.2
SNMP::Info::_load_attr orig_fw_mac : BRIDGE-MIB::dot1dTpFdbAddress : 
.1.3.6.1.2.1.17.4.3.1.1
SNMP::Info::_load_attr qb_fw_port : Q-BRIDGE-MIB::dot1qTpFdbPort : 
.1.3.6.1.2.1.17.7.1.2.2.1.2
SNMP::Info::_load_attr orig_fw_port : BRIDGE-MIB::dot1dTpFdbPort : 
.1.3.6.1.2.1.17.4.3.1.2
SNMP::Info::_load_attr qb_fw_port : Q-BRIDGE-MIB::dot1qTpFdbPort : 
.1.3.6.1.2.1.17.7.1.2.2.1.2
SNMP::Info::_load_attr dot1qVlanFdbId : Q-BRIDGE-MIB::dot1qVlanFdbId : 
.1.3.6.1.2.1.17.7.1.4.2.1.3
SNMP::Info::_load_attr bp_index : BRIDGE-MIB::dot1dBasePortIfIndex : 
.1.3.6.1.2.1.17.1.4.1.2
  e4:1f:13:6a:da:70: Port 1291 has no bp_index mapping. Skipping
  e4:1f:13:6a:66:e8: Port 1291 has no bp_index mapping. Skipping
  e4:1f:13:e6:5f:04: Port 1291 has no bp_index mapping. Skipping
  00:21:28:6f:2a:80: Port 1285 has no bp_index mapping. Skipping
  5c:f3:fc:4d:f5:4c: Port 1291 has no bp_index mapping. Skipping
  00:e0:ed:17:34:5d: Port 1291 has no bp_index mapping. Skipping
  e4:1f:13:6a:6c:48: Port 1291 has no bp_index mapping. Skipping
  5c:f3:fc:4d:f5:98: Port 1291 has no bp_index mapping. Skipping
  e4:1f:13:6a:6a:28: Port 1291 has no bp_index mapping. Skipping
  e4:1f:13:6a:13:d4: Port 1291 has no bp_index mapping. Skipping
  e4:1f:13:6a:da:a8: Port 1291 has no bp_index mapping. Skipping
  e4:1f:13:6b:62:b8: Port 1291 has no bp_index mapping. Skipping
  00:e0:ed:15:fd:eb: Port 1291 has no bp_index mapping. Skipping
  00:21:28:6f:27:24: Port 1286 has no bp_index mapping. Skipping
  e4:1f:13:6a:59:80: Port 1291 has no bp_index mapping. Skipping
  e4:1f:13:6a:d2:d4: Port 1291 has no bp_index mapping. Skipping
  e4:1f:13:6a:43:4c: Port 1291 has no bp_index mapping. Skipping
  00:10:db:ff:10:02: Port 1291 has no bp_index mapping. Skipping


Any help or ideas would be greatly appreciated.  Also if there are other steps 
I can take to gather more information on this please let me know.

Thanks,
-Derek


--- End Message ---
------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
Netdisco mailing list - Digest Mode
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users

Reply via email to