Welcome, Guest. Please login or register.

Author Topic: Nedi suddenly no longer working - help!  (Read 7118 times)

sshapery

  • Guest
Nedi suddenly no longer working - help!
« on: August 18, 2009, 11:20:31 PM »
suddenly, my nedi stopped working.

it keeps crashing out with the same error, on different 4500/Sup-5 boxes, that always worked before.

10.220.168.6    NSAN2SWIDF1B    v7Iv i255 j1    DBD::mysql::st execute failed: Duplicate entry '����������������������������������������������������������������' for key 1 at ./inc/libdb-msq.pl line 379.
DBD::mysql::st execute failed: Duplicate entry '����������������������������������������������������������������' for key 1 at ./inc/libdb-msq.pl line 379.

I've done a complete wipe and reinstall, and it's still doing the same thing.

here's a -d of the same device:

10.220.168.6     C:0OOPS+ NSAN2SWIDF1B   SV=6 TY=WS-C4510R BI=cat4500-entservicesk9-mz.122-50.SG1.bin CPU=34 Mem=323719408 Temp=36 v7 HC-Merge IvRequested table is empty or does not exist
 i255 j1        DBD::mysql::st execute failed: Duplicate entry '����������������������������������������������������������������' for key 1 at ./inc/libdb-msq.pl line 379.
DBD::mysql::st execute failed: Duplicate entry '����������������������������������������������������������������' for key 1 at ./inc/libdb-msq.pl line 379.


Thoughts?

« Last Edit: August 24, 2009, 05:46:07 PM by sshapery »

sshapery

  • Guest
Re: Nedi suddenly no longer working - help!
« Reply #1 on: August 19, 2009, 02:24:00 AM »
actually, after poking around the forum, I saw a comment on 12.2.50 having an SNMP loop in the 3560 - I will upgrade this weekend to 12.2.53SG and see if that resolves it.

rickli

  • Administrator
  • Hero Member
  • *****
  • Posts: 2697
    • View Profile
    • NeDi
Re: Nedi suddenly no longer working - help!
« Reply #2 on: August 20, 2009, 08:44:09 PM »
Ok, pls let me know of the outcome...strange stuff!
Please consider Other-Invoices on your NeDi installation for an annual contribution, tx!
-Remo

sshapery

  • Guest
Re: Nedi suddenly no longer working - help!
« Reply #3 on: August 22, 2009, 11:13:54 PM »
I think it's a smoking gun...

12.2.53SG box:

perl nedi.pl -a 10.220.134.6

NeDi 1.0.4 - 4.Apr 2009
OUI:    14892 NIC vendor entries read
Dev:    3589 devices read from nedi.devices
Link:   0 links (WHERE type = "STAT") read from nedi.links


Manual-Discovery with 1 seed(s) on Sat Aug 22 14:11:05 2009
====================================================================================
Device                          Status                               Todo/Done-Time
------------------------------------------------------------------------------------
10.220.134.6    NSAN1SWIDF2A    v9Iv i305 j1    p0/0 m8  a6      f137      0/1-32s
------------------------------------------------------------------------------------
Took 0 minutes

Devs:   1 devices discovered
Link:   241 links (ignoring 0 static) written to nedi.links
Node:   850 nodes read from nedi.nodes
Node:   5 IP and 129 non-IP nodes processed
Track:  0 IP and 2 IF changes detected
Node:   982 nodes written to nedi.nodes

12.2.50SG box:


perl nedi.pl -a 10.220.168.6

NeDi 1.0.4 - 4.Apr 2009
OUI:    14892 NIC vendor entries read
Dev:    3641 devices read from nedi.devices
Link:   0 links (WHERE type = "STAT") read from nedi.links


Manual-Discovery with 1 seed(s) on Sat Aug 22 14:12:08 2009
====================================================================================
Device                          Status                               Todo/Done-Time
------------------------------------------------------------------------------------
10.220.168.6    NSAN2SWIDF1B    v7Iv i255 j1    DBD::mysql::st execute failed: Duplicate entry '' for key 1 at ./inc/libdb-msq.pl line 379.
DBD::mysql::st execute failed: Duplicate entry '' for key 1 at ./inc/libdb-msq.pl line 379.




rickli

  • Administrator
  • Hero Member
  • *****
  • Posts: 2697
    • View Profile
    • NeDi
Re: Nedi suddenly no longer working - help!
« Reply #4 on: August 24, 2009, 01:56:33 AM »
What do you get with -vt 10.220.168.6 ? Any weird neighbours on that switch? Compare it with "show cdp ne" too...
Please consider Other-Invoices on your NeDi installation for an annual contribution, tx!
-Remo

sshapery

  • Guest
Re: Nedi suddenly no longer working - help!
« Reply #5 on: August 24, 2009, 05:43:30 PM »
odd, -vt worked without erroring out.

-va works now too - the only change this weekend was an upgrade of our callmanager, which in turn upgraded the code on our IP phones.  I am starting to suspect some odd interaction between the older version of phone code in conjunction with the 12.2.50 code on the switch.

I am running a full-seed discovery now, I will let you know the results.

rufer

  • Guest
Re: Nedi suddenly no longer working - help!
« Reply #6 on: August 25, 2009, 11:59:56 AM »
IOS 12.2(50)SE wasn't working at all for me, but they fixed the SNMP loop in 12.2(50)SE1 and up. So the recent releases _should_ work again.

Greetings
Rufer

rickli

  • Administrator
  • Hero Member
  • *****
  • Posts: 2697
    • View Profile
    • NeDi
Re: Nedi suddenly no longer working - help!
« Reply #7 on: August 25, 2009, 07:46:08 PM »
I remember buggy phones and the fix for it:

$neb{$k[14]}{$k[15]}{'na'} =~ s/(\xff){1,}/BADCDP/;      # Fixes some phone weirdness

Maybe this is related, but using those yyy characters instead...
Please consider Other-Invoices on your NeDi installation for an annual contribution, tx!
-Remo

spiffturk

  • Guest
Re: Nedi suddenly no longer working - help!
« Reply #8 on: September 25, 2009, 06:41:01 PM »
I remember buggy phones and the fix for it:

$neb{$k[14]}{$k[15]}{'na'} =~ s/(\xff){1,}/BADCDP/;      # Fixes some phone weirdness

Maybe this is related, but using those yyy characters instead...

I was one of the people with that problem some time ago.  And I've come across it again.  I've spent the last half hour or so trying to find the old thread and I can only assume it got purged at some point because my searching has turned up empty (I can't even find my old posts about it) .

Anyway, as I said I've got the problem again with a fresh installation of 1.0.4.  As I recall, it's a bug in how the phones identify themselves via CDP-- they tell their neighbor that their name is an integer of all ones (i forget how many bytes) rather than a string.

I don't remember exactly what the solution was-- even replacing it with "BADCDP" won't fix it because there will still be the duplicate entry that MySQL complains about.  Any idea how we fixed this last time?  I think I suggested replacing the bad cdp name with SEP+{MAC} but I don't remember what we actually did to get around this.  Any suggestions?

Thanks,

--
Will

rickli

  • Administrator
  • Hero Member
  • *****
  • Posts: 2697
    • View Profile
    • NeDi
Re: Nedi suddenly no longer working - help!
« Reply #9 on: September 26, 2009, 07:05:10 PM »
This will be in the next release:

$neb{$k[14]}{$k[15]}{'na'} =~ s/(\xff){1,}/BadCDP-$k[15]/;      # Fixes some phone weirdness


But now, that I look at it, BADCDP-$k[14] might work better. Can you give it a try?

Oh, yes and I'm sorry for loosing those posts. Thought I could restore them, but it got pretty messy  :-\
Please consider Other-Invoices on your NeDi installation for an annual contribution, tx!
-Remo

spiffturk

  • Guest
Re: Nedi suddenly no longer working - help!
« Reply #10 on: September 28, 2009, 07:33:11 PM »
This will be in the next release:

$neb{$k[14]}{$k[15]}{'na'} =~ s/(\xff){1,}/BadCDP-$k[15]/;      # Fixes some phone weirdness


But now, that I look at it, BADCDP-$k[14] might work better. Can you give it a try?

Oh, yes and I'm sorry for loosing those posts. Thought I could restore them, but it got pretty messy  :-\

I'd be happy to give it a try... Where should I put it?

--
Will

rickli

  • Administrator
  • Hero Member
  • *****
  • Posts: 2697
    • View Profile
    • NeDi
Re: Nedi suddenly no longer working - help!
« Reply #11 on: September 28, 2009, 07:36:34 PM »
Since you posted a similar one, I thought you'd know already :)

Search libsnmp.pl for "Extract from CatOS" and put it afterwards...
Please consider Other-Invoices on your NeDi installation for an annual contribution, tx!
-Remo

spiffturk

  • Guest
Re: Nedi suddenly no longer working - help!
« Reply #12 on: September 28, 2009, 08:50:23 PM »
Hey, that was a long time ago :)

Anyway, putting it there and running gave me four confused phones with these names:
BadCDP-10002
BadCDP-10004
BadCDP-100032
BadCDP-10009SCCP41

What's in $k[14]?  I recognize SCCP as being part of the code the phone is running, but I couldn't say why it's only in the name of one and not the others...

Certainly an improvement, though.

--
Will