MACTRACK SQL errors.

rloteck · Joined: 03 Jun 2007 Posts: 4

Hi All!

I am getting the following errors on the Cacti error log:

06/03/2007 03:24:38 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_vlans (vlan_id, site_id, device_id, vlan_name, present) SELECT vlan_id, site_id, device_id, vlan_name, '1' AS present FROM mac_track_temp_ports ON DUPLICATE KEY UPDATE vlan_name=VALUES(vlan_name), present=VALUES(present);"

However, when I check the log again, I find this right about it..

06/03/2007 03:24:43 PM - SYSTEM MACTRACK STATS: Time:8.4840 ConcurrentProcesses:7 Devices:1

The problem is that when I click on the Mactrack link to see what MAC address it discovered from my switch, I don't see any....

Any ideas?

Rlo

rloteck · Joined: 03 Jun 2007 Posts: 4

Does anyone know how to fix this problem.

TheWitness · Posted: Thu Jun 07, 2007 8:19 am Post subject:

What version are you using?

TheWitness

rloteck · Joined: 03 Jun 2007 Posts: 4

MacTrack: 1.0
Cacti: 0.8.6j
MySQL: 4.1.12a-nt

TheWitness · Posted: Sat Jun 09, 2007 9:21 am Post subject:

Did you run the database upgrade? Are you using mysql 5.x or above? If running mysql 5.x and above, do you have strict mode off?

TheWitness

rloteck · Joined: 03 Jun 2007 Posts: 4

Did you run the database upgrade?

TheWitness · Posted: Sun Jun 10, 2007 6:42 am Post subject:

Ok, can you change the syntax from INSERT ... SELECT ... to INSERT ... SELECT DISTINCT ...?

Tell me if that get's it. You will likely find this code in plugins/mactrack/lib/mactrack_functions.php. Oh, and do you have the table mac_track_vlans?

TheWitness