netdisco-users Digest, Vol 112, Issue 9

Mon, 19 Oct 2015 06:53:40 -0700 

Send netdisco-users mailing list submissions to
        netdisco-users@lists.sourceforge.net

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
        netdisco-users-requ...@lists.sourceforge.net

You can reach the person managing the list at
        netdisco-users-ow...@lists.sourceforge.net

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 (Sebastian R?sch)
   2. Re: Portlist on some won?t show up, postgresql uses high cpu
      (Sebastian R?sch)
   3. Re: Portlist on some won?t show up, postgresql uses high cpu
      (Steven Xu)
--- Begin Message --- 
Hi Oliver,

thanks for the VLAN filter on that report, that’s exactly what I´m looking for. 
My problem is actually, that I need to go deeper in how netdisco works, to know 
how to create such reports. Actually, my problems are the sql querys and the 
different tables... But I will try to find out, how it works. Steven also had 
some hints for me, that I will follow first.

With filtering by IP-address I meant the same as filtering by vlan. Normally / 
as an proposal for netdisco development I think it would be useful, if netdisco 
would offer a "filter-bar" ontop of such reports, where users can click 
together their filter of desire with different columns to select/filter for.

An example for you regarding this report: I´m using netdisco to discover 
devices in several different locations. In the most cases I can separate the 
locations by the devicename (Netdisco uses wildcard search in the "filter 
records field"), because a locationcode is part of the devicename. But there 
also different cases, where I can only filter by ip address. The different 
locations have different management vlans and so I can "select" the locations. 
I need this report to get to know which VLAN1 Ports in a specific Location have 
multiple nodes attached.... 


 

Mit freundlichen Grüßen / Best Regards

Sebastian Rösch

alcera Kommunikationstechnik GmbH
    …und das Netz läuft

Empelder Str. 96  30455 Hannover
Sebastian Rösch

 tel.:      +49 (511)  458066-23
 fax.:     +49 (511)  458066-55
mobil:  +49 (163)   5060730
m roe...@alcera.de
  www.alcera.de

alcera Kommunikationstechnik GmbH, Empelder Straße 96, D-30455 Hannover
Amtsgericht Hannover HRB 60994
Ust.-ID.-Nr.  DE 227 580 599
Geschäftsführer: Ulfert von Schassen
Der Inhalt dieser E-Mail, inklusive seiner Anhänge, ist vertraulich und 
ausschließlich für den bezeichneten Empfänger bestimmt. Wenn Sie nicht der 
vorgesehene Empfänger dieser e-Mail oder dessen Vertreter sind, so beachten Sie 
bitte, dass jede Form der Kenntnisnahme, Nutzung, Veröffentlichung, 
Vervielfältigung oder Weitergabe unzulässig ist. Wir bitten Sie in diesem Fall, 
sich mit dem Absender dieser E-Mail in Verbindung zu setzen. Vielen Dank für 
Ihre freundliche Unterstützung!
This e-mail (including any attachments) is confidential and may be legally 
privileged.  If you are not an intended recipient or an authorized 
representative of an intended recipient, you are prohibited from using, copying 
or distributing the information in this e-mail or its attachments. If you have 
received this e-mail in error, please notify the sender immediately by return 
e-mail and delete all copies of this message and any attachments.  Thank you.

-----Ursprüngliche Nachricht-----
Von: Oliver Gorwits [mailto:oli...@cpan.org] 
Gesendet: Sonntag, 4. Oktober 2015 21:00
An: netdisco-users@lists.sourceforge.net
Betreff: Re: [Netdisco] Extend Report "Ports Multiple Nodes attached" with vlan 
and device ip

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 ---
--- Begin Message --- 
Hi Steven,

I tried to reduce the columns and that helped a little. For example I used the 
settings Port, Name, Native VLAN, VLANMembership, Connected Node, Connected 
Device, Status and at Node Properties I set only Ipv4. In this case the 
errormessage will appear. As soon as unclick "IPv4 addresses" the Portlist will 
be shown.

I can´t also say, that this depends on devices with many ports.... I have a 
Cisco 3750 with 12 Ports, where this behavior occurs.... Hopefully it´s fixed 
the next time.


Thanks for your help
Sebastian

Von: Steven Xu [mailto:stev...@yorku.ca]
Gesendet: Dienstag, 13. Oktober 2015 11:35
An: Sebastian Rösch <roe...@alcera.de>
Cc: netdisco-users@lists.sourceforge.net
Betreff: Re: [Netdisco] Portlist on some won´t show up, postgresql uses high cpu

Hi Sebastian,

I know that for certain devices with many ports (1,500 does it for me) and 
having many columns enabled, will eat up a great deal of RAM (you could try 
monitoring it yourself to confirm) and cause one of the server workers to 
crash. This would result in an error in the web interface.

Reducing the columns may help. Increasing the RAM on my machine to 8GB sufficed 
as a workaround for me. I'm already working on a code fix for this.

Steven

-----Sebastian Rösch <roe...@alcera.de<mailto:roe...@alcera.de>> wrote: -----
To: 
"netdisco-users@lists.sourceforge.net<mailto:netdisco-users@lists.sourceforge.net>"
 
<netdisco-users@lists.sourceforge.net<mailto:netdisco-users@lists.sourceforge.net>>
From: Sebastian Rösch <roe...@alcera.de<mailto:roe...@alcera.de>>
Date: 10/13/2015 03:18AM
Subject: [Netdisco] Portlist on some won´t show up, postgresql uses high cpu
Hello,

I don´t know, since when exactly, but perhaps since the last update  to 
2.033002 I recognize, that opening the Ports-Tab on some devices will bring a 
postgresql process to consume 100% cpu (on one core). After 1-2 minutes, the 
process leaves but no result in the webinterface. I only see the "search 
failed" error.


Does somebody know what to do here?


Best Regards
Sebastian
------------------------------------------------------------------------------
_______________________________________________
Netdisco mailing list
netdisco-users@lists.sourceforge.net<mailto:netdisco-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/netdisco-users

--- End Message ---
--- Begin Message --- It could be a bug with the latest patch. I don't have the feature with ipv4 and ipv6 yet. You should open a bug report.

Steve

-----Sebastian Rösch <roe...@alcera.de> wrote: -----
To: Steven Xu <stev...@yorku.ca>
From: Sebastian Rösch <roe...@alcera.de>
Date: 10/19/2015 06:10AM
Cc: "netdisco-users@lists.sourceforge.net" <netdisco-users@lists.sourceforge.net>
Subject: AW: [Netdisco] Portlist on some won´t show up, postgresql uses high cpu

Hi Steven,

 

I tried to reduce the columns and that helped a little. For example I used the settings Port, Name, Native VLAN, VLANMembership, Connected Node, Connected Device, Status and at Node Properties I set only Ipv4. In this case the errormessage will appear. As soon as unclick “IPv4 addresses” the Portlist will be shown.

 

I can´t also say, that this depends on devices with many ports…. I have a Cisco 3750 with 12 Ports, where this behavior occurs…. Hopefully it´s fixed the next time.

 

 

Thanks for your help

Sebastian

 

Von: Steven Xu [mailto:stev...@yorku.ca]
Gesendet: Dienstag, 13. Oktober 2015 11:35
An: Sebastian Rösch <roe...@alcera.de>
Cc: netdisco-users@lists.sourceforge.net
Betreff: Re: [Netdisco] Portlist on some won´t show up, postgresql uses high cpu

 

Hi Sebastian,

I know that for certain devices with many ports (1,500 does it for me) and having many columns enabled, will eat up a great deal of RAM (you could try monitoring it yourself to confirm) and cause one of the server workers to crash. This would result in an error in the web interface.

Reducing the columns may help. Increasing the RAM on my machine to 8GB sufficed as a workaround for me. I'm already working on a code fix for this.

 Steven

-----Sebastian Rösch < roe...@alcera.de > wrote: -----

To: " netdisco-users@lists.sourceforge.net " < netdisco-users@lists.sourceforge.net >
From: Sebastian Rösch < roe...@alcera.de >
Date: 10/13/2015 03:18AM
Subject: [Netdisco] Portlist on some won´t show up, postgresql uses high cpu

Hello,

 

I don´t know, since when exactly, but perhaps since the last update  to 2.033002 I recognize, that opening the Ports-Tab on some devices will bring a postgresql process to consume 100% cpu (on one core). After 1-2 minutes, the process leaves but no result in the webinterface. I only see the “search failed” error.

 

 

Does somebody know what to do here?

 

 

Best Regards

Sebastian

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

_______________________________________________
Netdisco mailing list
 netdisco-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/netdisco-users


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

_______________________________________________
Netdisco mailing list - Digest Mode
netdisco-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/netdisco-users

Reply via email to