netdisco-users Digest, Vol 107, Issue 2

Sat, 09 May 2015 04:46:00 -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: ND2 Worker configuration and Server Performance       problems
      (Tobias Gerlach)
   2. Re: ND2 Worker configuration and Server Performance problems
      (Oliver Gorwits)
   3. IBM BNT device model number problem (Andy Ruhl)
   4. Re: Port Report Help (Tobias Gerlach)
   5. Re: Port Report Help (Oliver Gorwits)
   6. Error During Update (Bavo Seesink)
--- Begin Message --- 
Hi Oliver,
I've deactivated BULKWALK globally for test reason and run a full
discovery. As expected, because of latency etc., the polling time for
each device is slightly longer but in summary for all devices the time
was shorter and I didn't noticed any memory issues again. A single
worker process didn't allocated more than about 120KB in maximum,
which is ok and didn't caused any issues like swapping, high CPU load
etc.
I wanted to give you this short feedback and looking forward to the
global master timeout feature which will be very usefull :)
Thanks a lot in advance.
Regards Tobias

--- End Message ---
--- Begin Message --- 
Hi Tobias,
Many thanks indeed for running these tests, it's good to have confirmation of the problem even at the same time as working on the solution (or workaround).
I'm very keen to implement the timeout features, so I hope we'll see them in a release soon. In the meantime I'm glad that you once again have a working Netdisco discovery. 

regards,
oliver.

On 2015-05-05 08:03, Tobias Gerlach wrote:

Hi Oliver,
I've deactivated BULKWALK globally for test reason and run a full
discovery. As expected, because of latency etc., the polling time for
each device is slightly longer but in summary for all devices the time 
was shorter and I didn't noticed any memory issues again. A single
worker process didn't allocated more than about 120KB in maximum,
which is ok and didn't caused any issues like swapping, high CPU load
etc.
I wanted to give you this short feedback and looking forward to the
global master timeout feature which will be very usefull :)
Thanks a lot in advance.
Regards Tobias


------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud 
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights 
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
Netdisco mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users

--- End Message ---
--- Begin Message --- 
I have some IBM BNT devices which don't show their os_ver numbers in
netdisco properly. The G8124 device works, the G8052 and G8264 devices
don't.

For example:

netdisco=> select model,os,os_ver from device where ip='IP1';
  model  | os  | os_ver
---------+-----+--------
 G8124-E | ibm | 7.11.1
(1 row)

netdisco=> select model,os,os_ver from device where ip='IP2';
 model | os  | os_ver
-------+-----+--------
 G8052 | ibm |
(1 row)

netdisco=> select model,os,os_ver from device where ip='IP3';
    model     | os  | os_ver
--------------+-----+--------
 G8264, Stack | ibm |

The correct data shows up in bulkwalk:

$ snmpbulkwalk -v2c -c public IP1 | egrep "version|G8124"
SNMPv2-MIB::sysDescr.0 = STRING: IBM Networking Operating System RackSwitch
G8124-E
HOST-RESOURCES-MIB::hrDeviceDescr.2 = STRING: image1, version 7.11.1,
downloaded  6:47:01 Fri Mar 13, 2015
HOST-RESOURCES-MIB::hrDeviceDescr.3 = STRING: image2, version 7.11.1,
downloaded  6:49:34 Fri Mar 13, 2015
HOST-RESOURCES-MIB::hrDeviceDescr.4 = STRING: linux-kernel, version 7.11.1
SNMPv2-SMI::mib-2.47.1.1.1.1.2.1 = STRING: "IBM Networking Operating System
RackSwitch G8124-E"
SNMPv2-SMI::mib-2.47.1.1.1.1.7.1 = STRING: "RS G8124-E"
$ snmpbulkwalk -v2c -c public IP2 | egrep "version|G8052"
SNMPv2-MIB::sysDescr.0 = STRING: IBM Networking Operating System RackSwitch
G8052
HOST-RESOURCES-MIB::hrDeviceDescr.2 = STRING: image1, version 7.11.2,
downloaded  6:16:37 Fri Mar 13, 2015
HOST-RESOURCES-MIB::hrDeviceDescr.3 = STRING: image2, version 7.11.2,
downloaded  6:19:08 Fri Mar 13, 2015
HOST-RESOURCES-MIB::hrDeviceDescr.4 = STRING: linux-kernel, version 7.11.2
SNMPv2-SMI::mib-2.47.1.1.1.1.2.1 = STRING: "IBM Networking Operating System
RackSwitch G8052"
SNMPv2-SMI::mib-2.47.1.1.1.1.7.1 = STRING: "RS G8052"
$ snmpbulkwalk -v2c -c public IP3 | egrep "version|G8264"
SNMPv2-MIB::sysDescr.0 = STRING: IBM Networking Operating System RackSwitch
G8264, Stack
HOST-RESOURCES-MIB::hrDeviceDescr.2 = STRING: image1, version 7.11.1,
downloaded 17:35:51 Sat Dec 31, 2000
HOST-RESOURCES-MIB::hrDeviceDescr.3 = STRING: image2, version 7.11.1,
downloaded 13:25:24 Thu May  7, 2015
HOST-RESOURCES-MIB::hrDeviceDescr.4 = STRING: linux-kernel, version 7.11.1
SNMPv2-SMI::mib-2.47.1.1.1.1.2.1 = STRING: "IBM Networking Operating System
RackSwitch G8264, Stack"
SNMPv2-SMI::mib-2.47.1.1.1.1.2.156 = STRING: "IBM Networking Operating
System RackSwitch G8264, Stack"
SNMPv2-SMI::mib-2.47.1.1.1.1.7.1 = STRING: "RS G8264"
SNMPv2-SMI::mib-2.47.1.1.1.1.7.156 = STRING: "RS G8264"

Is it possible to fix this?

Thanks.

Andy

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

I currently try to configure a custom report in ND2 (latest version).
The SQL query (see below) works fine on the CLI but not within ND2.
The web interface freezes and isn't accessible any longer when the
report is configured.

My deployment.yml report section looks like
...
reports:
  - tag: ports_installed_emea_de_ABC_office
    label: 'Ports Installed EMEA DE ABC Office'
    category: 'Port'
    columns:
      - {t1.region: 'Region'}
      - {t1.country: 'Country'}
      - {t1.site: 'Site'}
      - {t1.zone: 'Zone'}
      - {speed: 'Speed'}
      - {up: 'Status'}
      - {count: 'Count'}
    query: |
    SELECT t1.region,t1.country,t1.site,t1.zone,speed,up,count(*)
    from device_port
    LEFT JOIN device ON device_port.ip = device.ip
    INNER JOIN
    (select * from dblink('dbname=environment','select
ip,zone,left(upper(site),3) as site,country,region from devices
where upper(region) like ''%'' AND upper(country) like ''%'' AND
left(upper(site),3) like ''ABC'' AND upper(zone) like ''%OFFICE%''')
AS t1(ip inet,zone text,site text,country text,region text)) as t1 ON
device_port.ip = t1.ip
    WHERE device_port.type like 'ethernetCsmacd' AND speed not like '0'
    group by t1.region,t1.country,t1.site,t1.zone,speed,up
    order by 1,2,3,4
...

After turning on debug I found the following error message in the
netdisco-daemon.log:
---
## netdisco-daemon-fg: caught signal (TERM), exiting

Unable to parse the configuration file:
/usr/local/netdisco/environments/deployment.yml: YAML::XS::Load Error:
The problem:

    did not find expected '-' indicator

was found at document: 1, line: 188, column: 8
while parsing a block collection at line: 181, column: 7
 at /usr/local/netdisco/perl5/lib/perl5/Dancer/Config.pm line 233
        
Dancer::Config::load_settings_from_yaml('/usr/local/netdisco/environments/deployment.yml')
called at /usr/local/netdisco/perl5/lib/perl5/Dancer/Config.pm line
211
        Dancer::Config::load('Dancer::Config') called at
/usr/local/netdisco/perl5/lib/perl5/Dancer.pm line 274
        Dancer::import('Dancer', ':script') called at
/usr/local/netdisco/perl5/lib/perl5/App/Netdisco/Configuration.pm line
4
        App::Netdisco::Configuration::BEGIN() called at
/usr/local/netdisco/perl5/lib/perl5/Dancer.pm line 4
        eval {...} called at
/usr/local/netdisco/perl5/lib/perl5/Dancer.pm line 4
        require App/Netdisco/Configuration.pm called at
/usr/local/netdisco/perl5/lib/perl5/App/Netdisco.pm line 8
        App::Netdisco::BEGIN() called at
/usr/local/netdisco/perl5/lib/perl5/Dancer.pm line 4
        eval {...} called at
/usr/local/netdisco/perl5/lib/perl5/Dancer.pm line 4
        require App/Netdisco.pm called at
/usr/local/netdisco/perl5/bin/netdisco-daemon-fg line 23
        main::BEGIN() called at
/usr/local/netdisco/perl5/lib/perl5/Dancer.pm line 4
        eval {...} called at
/usr/local/netdisco/perl5/lib/perl5/Dancer.pm line 4
BEGIN failed--compilation aborted at
/usr/local/netdisco/perl5/lib/perl5/App/Netdisco/Configuration.pm line
4.
Compilation failed in require at
/usr/local/netdisco/perl5/lib/perl5/App/Netdisco.pm line 8.
BEGIN failed--compilation aborted at
/usr/local/netdisco/perl5/lib/perl5/App/Netdisco.pm line 8.
Compilation failed in require at
/usr/local/netdisco/perl5/bin/netdisco-daemon-fg line 23.
BEGIN failed--compilation aborted at
/usr/local/netdisco/perl5/bin/netdisco-daemon-fg line 23.

Looks like ND is missing a "-" indicator, but I don't know where?
When I uncomment the query part within the report section of the
deployment.yml than ND is starting fine and prints out no error.

Is it possible that there's maybe a special character in the SQL query
that ND couldn't handle?

Thanks a lot in advance for any help!

Regards Tobias

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

On 2015-05-08 15:49, Tobias Gerlach wrote:

    query: |
    SELECT t1.region,t1.country,t1.site,t1.zone,speed,up,count(*)
    from device_port
    LEFT JOIN device ON device_port.ip = device.ip
    INNER JOIN
    (select * from dblink('dbname=environment','select
ip,zone,left(upper(site),3) as site,country,region from devices
where upper(region) like ''%'' AND upper(country) like ''%'' AND
left(upper(site),3) like ''ABC'' AND upper(zone) like ''%OFFICE%''')
AS t1(ip inet,zone text,site text,country text,region text)) as t1 ON
device_port.ip = t1.ip
WHERE device_port.type like 'ethernetCsmacd' AND speed not like '0' 
    group by t1.region,t1.country,t1.site,t1.zone,speed,up
    order by 1,2,3,4
...
Is it possible that there's maybe a special character in the SQL query 
that ND couldn't handle?
To me it looks like the SQL query has inconsistent indenting, and unfortunately YAML configuration format is sensitive to this.
My advice is to make sure the whole SQL query is indented at more than the "query: |" statement: 

    query: |
      SELECT t1.region,t1.country,t1.site,t1.zone,speed,up,count(*)
      from device_port
      LEFT JOIN device ON device_port.ip = device.ip
      INNER JOIN
      (select * from dblink('dbname=environment','select
        ip,zone,left(upper(site),3) as site,country,region from devices
where upper(region) like ''%'' AND upper(country) like ''%'' AND left(upper(site),3) like ''ABC'' AND upper(zone) like ''%OFFICE%''') AS t1(ip inet,zone text,site text,country text,region text)) as t1 ON 
        device_port.ip = t1.ip
WHERE device_port.type like 'ethernetCsmacd' AND speed not like '0' 
      group by t1.region,t1.country,t1.site,t1.zone,speed,up
      order by 1,2,3,4
Please let me know how you get on. Obviously I can't reproduce the DBLINK environment here (but nice work for using this!). 

regards,
oliver.

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

I`f installed version 2.032002 a few weeks back.
Now i want to upgrade to 2.032003. 

I`f logged in as the netdisco user.
If I execute the update command "~/bin/localenv cpanm --notest App::Netdisco”
I`m receiving the following error: "/root: Permission denied at 
/home/netdisco/perl5/bin/cpanm line 118.”

What do in need to do to get permissions?

Thanks in advanced.
Greetings
Palermo

--- End Message ---
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud 
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
Netdisco mailing list - Digest Mode
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users

Reply via email to