Problem populating mac_track_interfaces

Support questions about the MAC Track plugin

Moderators: Developers, Moderators

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

Problem populating mac_track_interfaces

Post by ajacobs »

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

Post by ajacobs »

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

Who is online

Users browsing this forum: No registered users and 0 guests