netdisco-users Digest, Vol 112, Issue 2

Sun, 04 Oct 2015 12:01:51 -0700 

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: Extend Report "Ports Multiple Nodes attached" with vlan
      and device ip (Steven Xu)
   2. Re: Extend Report "Ports Multiple Nodes attached" with vlan
      and device ip (Steven Xu)
   3. issues with using the discover_no command in      deployment.yml
      (Michael Dano)
   4. Re: Best way to discover Cisco Nexus N5K (Jeroen van Ingen)
   5. Re: issues with using the discover_no command in
      deployment.yml (Oliver Gorwits)
   6. Re: Extend Report "Ports Multiple Nodes attached" with vlan
      and device ip (Oliver Gorwits)
--- Begin Message --- Hi Sebastian,

Netdisco v2 does not use sql statements directly. It uses DBIx::Class which which is a perl interface to the database. The easiest way to find out what SQL statements that Netdisco is executing is having some sort of way of listening on Postgres or follow the instructions here to deploy and run the development version of Netdisco. Any SQL statements with the DBIC_TRACE option turned on will display the SQL statements that netdisco is executing.

You may wish to look at lib/App/Netdisco/DB/Result/Virtual for the existing reports that are written in SQL. You could use these as a template to write your own report.

Steven

-----Sebastian Rösch <[email protected]> wrote: -----
To: "[email protected]" <[email protected]>
From: Sebastian Rösch <[email protected]>
Date: 10/01/2015 12:23PM
Subject: [Netdisco] Extend Report "Ports Multiple Nodes attached" with vlan and device ip

Hello,

 

I need a report for multiple nodes attached to one port, but it I need to filter for a specific vlan  (and also for ip-address would be good). I tried different queries, but my understandings of netdisco´s database structure are limited ;) Where can I find (which file) the sql statements, that are executed for the reports in the webfrontend? (Is this the correct one? -->App-Netdisco-2.033002 / lib / App / Netdisco / Web / Plugin / Report / PortMultiNodes.pm)

 

 

Or did somebody already built such a report?

 

 

Best Regards

Sebastian

------------------------------------------------------------------------------
_______________________________________________
Netdisco mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users

--- End Message ---
--- Begin Message --- I realize I missed the point. lib/App/Netdisco/Web/Plugin/ handles HTTP requests. lib/App/Netdisco/DB/Result/Virtual/ provides SQL for many reports. In this case, this report is written purely with the DBIx::Class interface.

You would need to include a sidebar like the other reports, and write code to take these IP and VLAN fields in the handler. You would then use these parameters to change the DBIx::Class result class query in the handler. It's similar to SQL; many of the keywords and column names are the same, but the language is different.

Steven

-----Steven Xu <[email protected]> wrote: -----
To: Sebastian Rösch <[email protected]>
From: Steven Xu <[email protected]>
Date: 10/01/2015 01:55PM
Cc: "[email protected]" <[email protected]>
Subject: Re: [Netdisco] Extend Report "Ports Multiple Nodes attached" with vlan and device ip

Hi Sebastian,

Netdisco v2 does not use sql statements directly. It uses DBIx::Class which which is a perl interface to the database. The easiest way to find out what SQL statements that Netdisco is executing is having some sort of way of listening on Postgres or follow the instructions here to deploy and run the development version of Netdisco. Any SQL statements with the DBIC_TRACE option turned on will display the SQL statements that netdisco is executing.

You may wish to look at lib/App/Netdisco/DB/Result/Virtual for the existing reports that are written in SQL. You could use these as a template to write your own report.

Steven

-----Sebastian Rösch <[email protected]> wrote: -----
To: "[email protected]" <[email protected]>
From: Sebastian Rösch <[email protected]>
Date: 10/01/2015 12:23PM
Subject: [Netdisco] Extend Report "Ports Multiple Nodes attached" with vlan and device ip

Hello,

 

I need a report for multiple nodes attached to one port, but it I need to filter for a specific vlan  (and also for ip-address would be good). I tried different queries, but my understandings of netdisco´s database structure are limited ;) Where can I find (which file) the sql statements, that are executed for the reports in the webfrontend? (Is this the correct one? -->App-Netdisco-2.033002 / lib / App / Netdisco / Web / Plugin / Report / PortMultiNodes.pm)

 

 

Or did somebody already built such a report?

 

 

Best Regards

Sebastian

------------------------------------------------------------------------------
_______________________________________________
Netdisco mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users
------------------------------------------------------------------------------
_______________________________________________
Netdisco mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users

--- End Message ---
--- Begin Message --- 
All,

I have had Netdisco running for a few years and it's been running ok. I
just did some system maintenance to bring our servers up to date with the
latest release and notice some nodes that I didn't want on the server. We
recently changed some network infrastructure which now makes our 10
geographically separate sites look like one big network. In the past i was
using the discover_no command to keep a couple of the sites separate and it
worked great. I tried to use the same command to fix my new issue with the
netdisco servers discovering the other sites and now I get the following
error in the job queue.

error running job: Can't use string ("10.242.242.0/24") as an ARRAY ref
while "strict refs" in use at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Util/Device.pm line 167,
<__ANONIO__> line 41.

I'm not really sure how to start to fix this issue and any assistance would
be great.

Mike Dano
IT Engineer
Security Services
Baker College
Information Technology
1050 W. Bristol Rd
Flint, MI 48507
1(810)766-4120 Office
1(810)650-0947 Cell
1(810)766-4279 Fax
[email protected]

--- End Message ---
--- Begin Message --- 
Hi Sebastian,
The base design for Netdisco didn't include support for VRFs; I don't expect any real VRF support coming to 2.x releases either, it's more likely to be added when a lot of the code is redesigned for Netdisco 3.
In the mean time, I guess you've already found the options: live without the ARP entries in different VRFs, treat every VRF on a box as an extra box in the network, or hack around with custom data collection.
Do you happen to know if you can at least list the VRFs that are present via SNMP? If so, that would open up possibilities to extend SNMP::Info to collect the data you need. 


Regards,

Jeroen van Ingen
ICT Service Centre
University of Twente, P.O.Box 217, 7500 AE Enschede, The Netherlands


On 10/01/2015 05:59 PM, Sebastian Rösch wrote:

Hi,

I would like to know, if somebody uses netdisco to discover Cisco Nexus
stuff? We have 4x Nexus 5000 and the problem is, that we´re using
multiple vrf´s. To get the ARP entries from all the different vrfs, I
cannot use the management address, I have to use IP-Adresses from every
vrf. The same management address is present in all discovered nexus
devices/instances.

Therefore I created different snmp communities, mapped to the different
vrfs.

Looks like this:

snmp-server context netdisco_wan vrf WAN

snmp-server context netdisco_dmz vrf DMZ

snmp-server context netdisco_server_prod_neu vrf Server_Prod_neu

snmp-server community netdisco_wan

snmp-server community netdisco_dmz

snmp-server community netdisco_server_prod_neu

snmp-server mib community-map netdisco_wan context netdisco_wan

snmp-server mib community-map netdisco_dmz context netdisco_dmz

snmp-server mib community-map netdisco_server_prod_neu context
netdisco_server_prod_neu

I needed to force netdisco to use snmpv2, v3 wasn´t working.

But now, netdisco shows several different entries for the same system,
because it treats it as different devices. Isn´t there a way to improve
that?

I also tried to use ssh-collector, with a little modified Cisco IOS-XR
Script. The command line needs to be “show ip arp vrf all”. But I didn´t
work. I think there also other dependencies, that needs to be modified,
I don´t know about…

Did somebody found a better way to include nexus devices with vrf?

Best Regards

Sebastian



------------------------------------------------------------------------------



_______________________________________________
Netdisco mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users

--- End Message ---
--- Begin Message --- 
Hi Mike,

On 2015-10-01 20:15, Michael Dano wrote:

error running job: Can't use string ("10.242.242.0/24 [1]") as an
ARRAY ref while "strict refs" in use at
/home/netdisco/perl5/lib/perl5/App/Netdisco/Util/Device.pm line 167,
<__ANONIO__> line 41.


Do you have just the one entry in your discover_no configuration?
The config needs to be a list (in YAML format), even if it's just one item. For example: 

discover_no: ['10.242.242.0/24']

or

discover_no:
  - '10.242.242.0/24'

regards,
oliver.


I'm not really sure how to start to fix this issue and any assistance
would be great.

Mike Dano
IT Engineer
Security Services
Baker College 
Information Technology
1050 W. Bristol Rd
Flint, MI 48507
1(810)766-4120 Office
1(810)650-0947 Cell
1(810)766-4279 Fax
[email protected] [2]

Links:
------
[1] http://10.242.242.0/24
[2] mailto:[email protected]

--- End Message ---
--- Begin Message --- 
Hi Sebastian,

On 2015-10-01 17:22, Sebastian Rösch wrote:
I need a report for multiple nodes attached to one port, but it I need to filter for a specific vlan (and also for ip-address would be good).
I've implemented a basic VLAN filter option because that's pretty easy; this will be in the next release. I'm not sure I understand what you mean by filtering by IP address.
Steven is also correct in his reply that you can examine the SQL and create a custom report fairly easily, even with parameters: 

https://metacpan.org/pod/distribution/App-Netdisco/lib/App/Netdisco/Manual/Configuration.pod#reports

regards,
oliver.



I tried different queries, but my understandings of netdisco´s
database structure are limited ;) Where can I find (which file) the
sql statements, that are executed for the reports in the webfrontend?
(Is this the correct one? -->App-Netdisco-2.033002 / lib / App /
Netdisco / Web / Plugin / Report / PortMultiNodes.pm)

Or did somebody already built such a report?

Best Regards

Sebastian

--- End Message ---
------------------------------------------------------------------------------

_______________________________________________
Netdisco mailing list - Digest Mode
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users

Reply via email to