Problem populating mac_track_interfaces

Support questions about the MAC Track plugin

Moderators: Moderators, Developers

Post Reply
Author
Message
ajacobs
Posts: 2
Joined: Tue Jan 03, 2017 2:58 am

Problem populating mac_track_interfaces

#1 Post by ajacobs » Tue Jan 03, 2017 3:24 am

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

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

Re: Problem populating mac_track_interfaces

#2 Post by ajacobs » Tue Jan 03, 2017 7:21 am

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

Post Reply