Welcome, Guest. Please login or register.

Author Topic: NeDi014 db failed error  (Read 2380 times)

kamintech

  • Newbie
  • *
  • Posts: 33
    • View Profile
NeDi014 db failed error
« on: March 11, 2015, 02:20:31 PM »
I've been running the NeDi014 version for several weeks and now and really like the improvements that you have made. GREAT JOB!! I have come across an error when I try to add a couple of Cisco AP's 1200 series. I'm using NeDi to add the IP address and it goes through all of the normal steps but fails before it completes with this error. I'm only getting these on 3 Cisco AP's while others are working normally. I also did not have this problem in the NeDio09 version. Hope you can point me in the right direction to resolve this.

Write Nodes -- 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 'to Calcine Scale House,'M',1426079306,'')' at line 1 at /var/nedi/inc/libdb.pm line 1849. DBD::mysql::db do failed:
 

Thanks again for such a great product.
Kenny

rickli

  • Administrator
  • Hero Member
  • *****
  • Posts: 2494
    • View Profile
    • NeDi
Re: NeDi014 db failed error
« Reply #1 on: March 11, 2015, 06:49:32 PM »
tx for the feedback!

Do you use a ' in the location?
Please consider Other-Invoices on your NeDi installation for an annual contribution, tx!
-Remo

kamintech

  • Newbie
  • *
  • Posts: 33
    • View Profile
Re: NeDi014 db failed error
« Reply #2 on: March 12, 2015, 12:46:14 PM »
Here is the location names that are being used:

XXXX Calcine;Plant;ScaleHouse
XXXX Calcine;Office;Front Room
XXXX Mine;Plant;Scalehouse
XXXX Mine Scalehouse

Kenny

rickli

  • Administrator
  • Hero Member
  • *****
  • Posts: 2494
    • View Profile
    • NeDi
Re: NeDi014 db failed error
« Reply #3 on: March 12, 2015, 08:21:18 PM »
Try updating with patch3...
Please consider Other-Invoices on your NeDi installation for an annual contribution, tx!
-Remo

Grisu

  • Newbie
  • *
  • Posts: 12
    • View Profile
Re: NeDi014 db failed error
« Reply #4 on: April 15, 2015, 10:10:45 AM »
I have also a problem in the line 1849
This error occurs when the backup configuration job is running.
If I delete the device and re-discover the Configuration backup works

/var/nedi/nedi.pl -v -B0 -SAFGgsjmvpadobewit -a “IP”

.
.
.
Configbackup ------------------------------------------------------------------
WCFF:Config written to /var/nedi/conf/”name”/2015-0415-0956.cfg

EVNT:MOD=B/1 L=50 CL=cfgc TGT=”name” MSG=Config changed by 461 characters:    1- Current configuration : 61417 bytes
1+ Current configuration : 61416 bytes
3- ! Last configuration change at 09:39:55 MET Thu Mar 19 2015 by User
4- ! NVRAM config last updated at 09:01:51 MET Thu Mar 19 2015 by User
3+ ! Last configuration change at 14:38:16 MDT Wed Apr 8 2015 by User
4+ ! NVRAM config last updated at 17:02:13 MDT Wed Apr 8 2015 by User
1412-  switchport access vlan 72
1412+  switchport access vlan 445

DBD::mysql::db do failed: Data too long for column 'info' at row 1 at /var/nedi/inc/libdb.pm line 1849.
DBD::mysql::db do failed: Data too long for column 'info' at row 1 at /var/nedi/inc/libdb.pm line 1849.

greeting Rainer

rickli

  • Administrator
  • Hero Member
  • *****
  • Posts: 2494
    • View Profile
    • NeDi
Re: NeDi014 db failed error
« Reply #5 on: April 15, 2015, 07:15:22 PM »
Bugger, I've banished this one several times and it still comes back! I think I've found the root cause now. Wait for patch4...

This mysql setting might help for now: Disable STRICT_TRANS_TABLES and STRICT_ALL_TABLES for automatic truncation of the inserted string...
« Last Edit: April 15, 2015, 07:26:16 PM by rickli »
Please consider Other-Invoices on your NeDi installation for an annual contribution, tx!
-Remo