Mac Track Not working

[Shivaraj05]

hi,

mac track is not working..Given below is the log file.please help me out in fixing this. If anybody helps in configuring mactrac,thold & realtime plugin, i will be really thankful.

7/22/2008 10:06:48 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'2006', SQL:"select cacti from version"
07/22/2008 10:00:01 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1054', SQL:"SELECT COUNT(mac_track_devices.device_id) FROM mac_track_sites RIGHT JOIN mac_track_devices ON mac_track_devices.site_id = mac_track_sites.site_id WHERE ((mac_track_devices.hostname like '%%%%' OR mac_track_devices.device_name like '%%%%' OR mac_track_devices.notes like '%%%%'))"
07/22/2008 10:00:00 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT mac_track_devices.site_id, mac_track_sites.site_name, mac_track_devices.device_id, mac_track_devices.device_name, mac_track_devices.notes, mac_track_devices.hostname, mac_track_devices.snmp_readstring, mac_track_devices.snmp_readstrings, mac_track_devices.snmp_version, mac_track_devices.snmp_port, mac_track_devices.snmp_timeout, mac_track_devices.snmp_retries, mac_track_devices.snmp_status, mac_track_devices.ignorePorts, mac_track_devices.disabled, mac_track_devices.scan_type, mac_track_devices.ips_total, mac_track_devices.ports_total, mac_track_devices.ports_active, mac_track_devices.ports_trunk, mac_track_devices.macs_active, mac_track_devices.last_rundate, mac_track_devices.last_runmessage, mac_track_devices.last_runduration FROM mac_track_sites RIGHT JOIN mac_track_devices ON mac_track_devices.site_id = mac_track_sites.site_id WHERE ((mac_track_devices.hostname like '%%%%' OR mac_track_devices.device_name like '%%%%' OR mac_track_devices.notes like '%%%%')) ORDER BY site_name ASC LIMIT 0,30"
07/22/2008 09:43:21 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT DISTINCT vlan_id, vlan_name FROM mac_track_vlans ORDER BY vlan_name ASC"
07/22/2008 09:43:21 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT device_id, device_name, hostname FROM mac_track_devices ORDER BY device_name"
07/22/2008 09:35:37 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT Count(*) FROM mac_track_devices"
07/22/2008 09:35:37 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT device_id FROM mac_track_devices WHERE disabled='' ORDER BY site_id"
07/22/2008 09:35:20 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select thold_data.cdef, thold_data.rra_id, thold_data.data_id, thold_data.lastread, thold_data.oldvalue, data_template_rrd.data_source_name as name, data_template_rrd.data_source_type_id from thold_data LEFT JOIN data_template_rrd on (data_template_rrd.id = thold_data.data_id) WHERE data_template_rrd.data_source_name != '' AND "

regards,
Sivaraj

[TheWitness]

I think there is a fix on the Cactiusers.org site. I fixed this a few weeks ago, and used that site to fine the issue. It was quite simple. Did not check SVN though.

TheWitness

[TheWitness]

Here is the post:

http://forums.cacti.net/post-139820.html

Checking SVN now.

TheWitness

[Shivaraj05]

hi Witness,

Itried my level best.Unable to fix it out. please help me out.If possible provide me with a walkthrough. It will help a lot of other users also. Still not able to use it. This mactrack is a wonderful piece of s/w that will help me a lot in my network administration. Kindly help me out.

[TheWitness]

Well, it would appear that you have multiple problems. One, the 1146 error is a crashed table. Also, you might be missing some tables. Review the errors one at a time. Paste the queries into MySQL Query Browser to get additional details and then let me know how it goes.

TheWitness

[Shivaraj05]

I am not an expert in mysql.......Can u plz suggest what has to be done to test it out...coz other plugins are working fine

[hamish]

Once you've found which table it is, just do a

repair table <tablename>

on it from the mysql CLI. It'll rebuild the table, and let you know if it's completely hosed or if it recovers OK.