NeDi Community

NeDi General => News => Topic started by: rickli on August 02, 2015, 01:55:29 PM

Title: Test NeDi 1.4 Patch5
Post by: rickli on August 02, 2015, 01:55:29 PM
Here it is. Please post your findings. I'll make it public, if all your issues are fixed...

http://www.nedi.ch/pub/nedi-1.4p5.tgz
Title: Re: Test NeDi 1.4 Patch5
Post by: ascii on August 04, 2015, 09:25:26 AM
everythink is working for me.
devices can be added to monitoring again
Title: Re: Test NeDi 1.4 Patch5
Post by: jacobl on August 05, 2015, 05:27:40 PM
I've run into some errors and unexpected behavior doing a discovery after re-initializing the database. I recall not having these issues on a virgin install (NeDiO ISO + patch3). Not quite ready to do a detailed bug report as I need to narrow it down to the specific patch or configuration setting, which I will try to do in the next few days.
Title: Re: Test NeDi 1.4 Patch5
Post by: Kasper on August 12, 2015, 12:11:21 PM
I have run this patch for about a week and not noticed any problems.
I'm not the most advanced NeDi user but I thought I should at least report back the success for us at least.
Title: Re: Test NeDi 1.4 Patch5
Post by: rickli on August 12, 2015, 03:19:47 PM
Such feedback is always welcome :)
Title: Re: Test NeDi 1.4 Patch5
Post by: sjobergh on August 12, 2015, 11:40:00 PM
When using Nodes,List,  adding column "user" in the scrollbox I dont get the username,  I get numerical value in return.
Looking in the database I can see the user in alpha
Title: Re: Test NeDi 1.4 Patch5
Post by: Hannu Liljemark on August 13, 2015, 09:13:01 AM
1.4p5 looking pretty good here.

Is anyone else running it somewhere with PoE devices? I have so far one instance where the "Total PoE" graph isn't graphing any more after going from 1.0.9 to 1.4p5 (environment with mainly Cisco switches), and two instances where the total poe graph is ok after upgrade (Procurve switches).

nedi.conf has "usepoe ifmib" in all cases.

Br,
Hannu
Title: Re: Test NeDi 1.4 Patch5
Post by: Grisu on August 26, 2015, 10:14:00 AM
The mysql deadlock errors are still present with Patch 5  :'(

Try restarting transaction at /var/nedi/inc/libdb.pm line 1874
Try restarting transaction at /var/nedi/inc/libdb.pm line 1541
Title: Re: Test NeDi 1.4 Patch5
Post by: Hannu Liljemark on August 26, 2015, 11:30:50 AM
FYI, deleting a node deletes the node but last line is this:

Unknown column 'mac' in 'where clause'

Br,
Hannu
Title: Re: Test NeDi 1.4 Patch5
Post by: rickli on August 27, 2015, 08:46:28 PM
Tx, Hannu. The unknown column is ugly, but can be ignored (it's marked for Patch6 should there be a need for it). 1.4 support the Power-Ethernet Mib, which is used for total power consumption rather than adding all interfaces as 1.0.9 did. Check the .def where this is not showing...

Grisu, do you have any parallel discoveries?
Title: Re: Test NeDi 1.4 Patch5
Post by: Hannu Liljemark on August 28, 2015, 09:00:56 AM
1.4 support the Power-Ethernet Mib, which is used for total power consumption rather than adding all interfaces as 1.0.9 did. Check the .def where this is not showing...

Thanks, figured out this def issue on my own yesterday after started poking around, before seeing your response. Feels like deja vu... I think I've done something like this before. Anyway, I had to modify these definitions:

1.3.6.1.4.1.11.2.3.7.11.55.def, IFpowr  1.3.6.1.4.1.11.2.14.11.1.9.1.1.1.3.1    P
1.3.6.1.4.1.11.2.3.7.11.155.def, IFpowr  1.3.6.1.4.1.11.2.14.11.1.9.1.1.1.3.1    P
1.3.6.1.4.1.9.1.951.def, IFpowr  1.3.6.1.4.1.9.9.402.1.2.1.7     P
1.3.6.1.4.1.9.1.950.def, IFpowr  1.3.6.1.4.1.9.9.402.1.2.1.7     P
1.3.6.1.4.1.9.1.1016.def, IFpowr  1.3.6.1.4.1.9.9.402.1.2.1.7     P
1.3.6.1.4.1.9.1.1830.def, IFpowr  1.3.6.1.4.1.9.9.402.1.2.1.9     P

I'm not sure if it matters on Cisco devices whether you use 1.3.6.1.4.1.9.9.402.1.2.1.9 (consumption) or 1.3.6.1.4.1.9.9.402.1.2.1.7 (allocated).

Br,
Hannu
Title: Re: Test NeDi 1.4 Patch5
Post by: rickli on August 28, 2015, 02:35:19 PM
Tx, added the missing info. I'd go for whatever is closer to real life, so consumption?
Title: Re: Test NeDi 1.4 Patch5
Post by: Hannu Liljemark on August 29, 2015, 09:03:11 AM
Tx, added the missing info. I'd go for whatever is closer to real life, so consumption?

Real life value would give you accurate number of how much power is drawn by PoE devices. I wonder how e.g. a Cisco switch works regarding the allocated value - if connected devices draw power 100W but switch has allocated 200W, you probably can't over-subscribe the switch or can you.

I recall an instance with 48p switch that had maybe 20-30 phones and next phone didn't get power as we hit the switch PSU's limit. Anyway, just wondering if people use Nedi PoE data to see if their switches still have room for new PoE clients... or maybe this doesn't matter at all - Nedi is your creation and you set the rules :D

Right now the defs seem to be mixing 1.3.6.1.4.1.9.9.402.1.2.1.9 (consumption) and 1.3.6.1.4.1.9.9.402.1.2.1.7 (allocated).

Br,
Hannu
Title: Re: Test NeDi 1.4 Patch5
Post by: rickli on August 30, 2015, 10:21:46 AM
People using NeDi should get the most useful data out of it, thus we all decide :) However a mix is definitely not what we want, so it boils down to the question whether the switch acts upon real or allocated values. I can change them all to 1.3.6.1.4.1.9.9.402.1.2.1.9 until further enlightenment...
Title: Re: Test NeDi 1.4 Patch5
Post by: Hannu Liljemark on August 30, 2015, 12:26:42 PM
However a mix is definitely not what we want, so it boils down to the question whether the switch acts upon real or allocated values. I can change them all to 1.3.6.1.4.1.9.9.402.1.2.1.9 until further enlightenment...

Agreed!

Two more needed modifications:

1.3.6.1.4.1.9.1.950.def, IFpowr  1.3.6.1.4.1.9.9.402.1.2.1.9
1.3.6.1.4.1.9.1.1229.def, IFpowr  1.3.6.1.4.1.9.9.402.1.2.1.9

I also noticed that there's 1.3.6.1.4.1.9.9.402.1.2.1.7.def file in 1.4 for WS-C3750V2-24PS-S. I wonder if the filename is a typo (as it's the oid for this poe stuff). Looking at http://tools.cisco.com/Support/SNMP/do/BrowseOID.do?objectInput=1.3.6.1.4.1.9.1&translate=Translate&submitValue=SUBMIT&submitClicked=true the correct type oid for WS-C3750V2-24PS-S might be 1.3.6.1.4.1.9.9.1023.

Br,
Hannu
Title: Re: Test NeDi 1.4 Patch5
Post by: rickli on August 30, 2015, 03:41:18 PM
Good observation, tx. In case you're wondering about some ending with .1, this is what I've found working with some products. Hope we find all PEM options as well (the N,P and S letters) for correct mapping to if-indexes.
Title: Re: Test NeDi 1.4 Patch5
Post by: Hannu Liljemark on August 31, 2015, 02:39:09 PM
Very strange... all of a sudden 1.4p5 started doing this during discovery with a WLC 5508 running 7.6 software:

1.2.3.4   wlc1    SgSfIl i9  j6   Dcp0 b0          a1   DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's macbook$')' at line 1 at /var/nedi/inc/libdb.pm line 1849.
DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's macbook$')' at line 1 at /var/nedi/inc/libdb.pm line 1849.

I wonder if there was a client that had "'s macbook" in its name... I'll try to investigate a bit more.

Br,
Hannu
Title: Re: Test NeDi 1.4 Patch5
Post by: rickli on September 03, 2015, 10:19:10 PM
Or the ' ? Try with changing libdb.pm to:

1690                         my $us = ($m->{$dv}{$mcvl}{us})?$db::dbh->quote($m->{$dv}{$mcvl}{us}):'';
Title: Re: Test NeDi 1.4 Patch5
Post by: Hannu Liljemark on September 23, 2015, 10:23:06 AM
Or the ' ? Try with changing libdb.pm to:

1690                         my $us = ($m->{$dv}{$mcvl}{us})?$db::dbh->quote($m->{$dv}{$mcvl}{us}):'';

Okay, back from vacation. I gave this change a try but now get a slightly different error:

1.2.3.4   wlc1    SgSfIl i9  j6   Dcp0 b0          a1   DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'host/ladidaa.internal.domain.foo'' WHERE mac='5ce0c5f34ae9'' at line 1 at ./inc/libdb.pm line 1904.

Doing "snmpwalk -c foo -v2c .1.2.3.4 .1.3.6.1.4.1.14179.2.1.4.1.3" gives one entry of:

STRING: "our-ad-domain\\username's macbook$"

which I guess is the one causing the problem.

Br,
Hannu
Title: Re: Test NeDi 1.4 Patch5
Post by: rickli on September 23, 2015, 10:18:14 PM
Hmm, I think the single quotes need to be removed in the following queries, where $us is used. Sorry, for not being more competent..
Title: Re: Test NeDi 1.4 Patch5
Post by: fraggy on October 29, 2015, 10:17:09 AM
Hi,

I tried to use the OS detection with
Code: [Select]
nedi.pl -sOupdate and I think that your rewrite of this option doesn't work.

Code: [Select]
srvupdate > $now-$misc::rrdstep order by srvupdateThe value of srvupdate is 0 (zero) for all new nodes and the mysql select returns no IPs.

As a workaround I've changed it to
Code: [Select]
srvupdate > $now-$misc::rrdstep or srvupdate=0 order by srvupdate
Title: Re: Test NeDi 1.4 Patch5
Post by: rickli on October 30, 2015, 09:18:15 AM
Makes sense, I'll include this in patch6...tx