Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Thu Apr 27, 2017 10:02 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Problem populating mac_track_interfaces
PostPosted: Tue Jan 03, 2017 3:24 am 
Offline

Joined: Tue Jan 03, 2017 2:58 am
Posts: 2
Hi

I am trying to get mac_track to work on a rather new cacti installation, I quickly found 2 sql error in the cacti log, and the first was too long description from the Cisco switches, but that was easy to fix. Now I have a more difficult problem, I get a 1366 mysql error on a "INSERT INTO mac_track_interfaces (site_id, ...." statement, but i expect the real problem is that the SQL statement is more than 450000 chars long, is this a known problem with a fix, or should i try to patch the source ?

Best regards
Allan Jacobsen


Top
 Profile  
 
 Post subject: Re: Problem populating mac_track_interfaces
PostPosted: Tue Jan 03, 2017 7:21 am 
Offline

Joined: Tue Jan 03, 2017 2:58 am
Posts: 2
Hi

I found out what the problem was, there were a lot of errors because of integer values that were '', and timestamp of '0', so in the end the real problem might be that my database is running in strict mode, but at least, now i have no errors in the cacti log.

Best regards
Allan


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group