Mac Track Not working

Shivaraj05 · Post by **Shivaraj05** » Tue Jul 22, 2008 12:52 am

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

Post by **TheWitness** » Fri Jul 25, 2008 1:12 pm

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

Post by **TheWitness** » Fri Jul 25, 2008 1:16 pm

Here is the post:

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

Checking SVN now.

TheWitness

Shivaraj05 · Post by **Shivaraj05** » Mon Jul 28, 2008 12:37 am

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.

Cacti Version - 0.8.7b
Plugin Architecture - 2.1
Poller Type - CMD.php
Server Info - Linux 2.6.23.1-42.fc8
Web Server - Apache/2.2.8 (Fedora)
PHP - 5.2.6
PHP Extensions - libxml, xml, wddx, tokenizer, sysvshm, sysvsem, sysvmsg, session, pcre, SimpleXML, sockets, SPL, shmop, standard, Reflection, pspell, posix, iconv, hash, gmp, gettext, ftp, filter, exif, date, curl, ctype, calendar, bz2, zlib, openssl, apache2handler, apc, dbase, dom, gd, json, ldap, mbstring, mysql, mysqli, odbc, PDO, pdo_mysql, PDO_ODBC, pdo_pgsql, pdo_sqlite, pgsql, snmp, xmlreader, xmlwriter, xsl, zip
MySQL - 5.0.45
RRDTool - 1.2.99908020600
SNMP - 5.4.1
Plugins
thold
Device Monitoring (monitor - v0.8.2)
Network Discovery (discovery - v0.8.4)
Documents (docs - v0.1)
Device Monitoring (monitor - v0.8.2)
NTop Viewer (ntop - v0.1)
Global Plugin Settings (settings - v0.5)
Host Info (hostinfo - v0.2)
Syslog Monitoring (syslog - v0.5.2)
Network Tools (tools - v0.3)
Device Tracking (mactrack - v1.1)
FlowView (flowview - v0.5.1)
Realtime for Cacti (realtime - v0.32)

07/28/2008 09:06:04 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"

CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT count(*) FROM (mac_track_macwatch "

CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1054', SQL:"UPDATE mac_track_devices SET description='''

Post by **TheWitness** » Mon Jul 28, 2008 6:28 am

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 · Post by **Shivaraj05** » Thu Jul 31, 2008 4:24 am

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 · Post by **hamish** » Thu Aug 07, 2008 5:01 am

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.