Welcome, Guest. Please login or register.

Author Topic: mysql issue?  (Read 4932 times)

MagnAxiom

  • Guest
mysql issue?
« on: February 06, 2009, 09:35:30 PM »
New windows install... I ran into the issue where I couldn't find the mysql for perl, so I did a google search and found a copy.  Did the install and finally it looked like things were going to work!!

Then, after putting a seed device in, it still doesn't discover all my network devices, even though I KNOW they all have the same SNMP community strings, and all have the same tacacs logins.

At the end of the discover phase, I get these errors:

Took 9 minutes

Use of uninitialized value in hash element at ./inc/libmisc.pl line 611.
Use of uninitialized value in hash element at ./inc/libmisc.pl line 612.
Use of uninitialized value in hash element at ./inc/libmisc.pl line 618.
Node:   73 nodes read from nedi.nodes
Node:   1931 IP and 20 non-IP nodes processed
Track:  6 IP and 1 IF changes detected
Node:   0 nodes have been retired
Stock:  0 devices and 0 modules removed from nedi.stock
Dev:    26 devices written to nedi.devices
DBD::mysql::st execute failed: Incorrect integer value: '' for column 'ifidx' at
 row 1 at ./inc/libdb-msq.pl line 496.
DBD::mysql::st execute failed: Incorrect integer value: '' for column 'ifidx' at
 row 1 at ./inc/libdb-msq.pl line 496.
Issuing rollback() for database handle being DESTROY'd without explicit disconne
ct().

C:\var\NeDi>

So, I'm completely stumped... Do i have a bad version of the perl mysql?

rickli

  • Administrator
  • Hero Member
  • *****
  • Posts: 2695
    • View Profile
    • NeDi
Re: mysql issue?
« Reply #1 on: February 07, 2009, 07:09:10 PM »
Some devices use very high IF indexes (Chinese ones for example), so increasing the ifidx integer to bigint could help (change line 85 in inc/libdb-msq.pl so after the ifidx is a BIGINT instead of SMALLINT). This will be fixed in the next release...
Please consider Other-Invoices on your NeDi installation for an annual contribution, tx!
-Remo

MagnAxiom

  • Guest
Re: mysql issue?
« Reply #2 on: February 09, 2009, 11:48:17 PM »
Thanks for the response, but alas, it didn't help.

I've changed line 85 of the int/libdb-msq.pl to the following

Code: [Select]
$dbh->do("CREATE TABLE interfaces( device VARCHAR(64) BINARY, ifname VARCHAR(32), ifidx BIGINT unsigned,
I then did a "nedi.pl -i" to initialize my database.

Then did a "nedi.pl -clor"

And, received:
Took 7 minutes

Use of uninitialized value in hash element at ./inc/libmisc.pl line 611.
Use of uninitialized value in hash element at ./inc/libmisc.pl line 612.
Use of uninitialized value in hash element at ./inc/libmisc.pl line 618.
Node:   0 nodes read from nedi.nodes
Node:   383 IP and 19 non-IP nodes processed
Track:  0 IP and 0 IF changes detected
Node:   0 nodes have been retired
Stock:  0 devices and 0 modules removed from nedi.stock
Dev:    16 devices written to nedi.devices
DBD::mysql::st execute failed: Incorrect integer value: '' for column 'ifidx' at
 row 1 at ./inc/libdb-msq.pl line 496.
DBD::mysql::st execute failed: Incorrect integer value: '' for column 'ifidx' at
 row 1 at ./inc/libdb-msq.pl line 496.
Issuing rollback() for database handle being DESTROY'd without explicit disconnect().

C:\var\NeDi>

After I see the "Use of uninitialized value" lines, the system just sits there for over 15 minutes before giving me the failed execution.

The Highest Interface Index looks to be 10101. (Doing some current monitoring with MRTG, looking for a better solution with NeDi) These are all Cisco Routers/Switches.

Any help would be appreciated.

rickli

  • Administrator
  • Hero Member
  • *****
  • Posts: 2695
    • View Profile
    • NeDi
Re: mysql issue?
« Reply #3 on: February 10, 2009, 07:58:34 PM »
 ??? Can you print some lines of snmpwalk?

BTW ./nedi.pl -dt <ip> will be quicker for debugging...
Please consider Other-Invoices on your NeDi installation for an annual contribution, tx!
-Remo