Mactrack troubles

Support questions about the MAC Track plugin

Moderators: Developers, Moderators

Post Reply
Dacob9906
Cacti User
Posts: 209
Joined: Tue Apr 03, 2007 1:01 pm
Location: Pullman Washington

Mactrack troubles

Post by Dacob9906 »

When I try to track a switch by IP, I hit go and nothing happens. I go and check the log, and this is what I get:

04/13/2007 04:05:41 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "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 '%10.1.1.3%' OR mac_track_devices.description LIKE '%10.1.1.3%' OR mac_track_sites.site_name LIKE '%10.1.1.3%') AND (mac_track_devices.snmp_status=3) AND (mac_track_devices.disabled = '') AND (mac_track_devices.scan_type=1)"
04/13/2007 04:05:41 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT mac_track_devices.site_id, mac_track_sites.site_name, mac_track_devices.device_id, mac_track_devices.device_type_id, mac_track_devices.description, 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.snmp_sysName, mac_track_devices.snmp_sysLocation, mac_track_devices.snmp_sysContact, mac_track_devices.snmp_sysObjectID, mac_track_devices.snmp_sysDescr, mac_track_devices.snmp_sysUptime, 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.vlans_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 '%10.1.1.3%' OR mac_track_devices.description LIKE '%10.1.1.3%' OR mac_track_sites.site_name LIKE '%10.1.1.3%') AND (mac_track_devices.snmp_status=3) AND (mac_track_devices.disabled = '') AND (mac_track_devices.scan_type=1) ORDER BY site_name ASC LIMIT 0,30"
04/13/2007 04:05:41 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed "SELECT * FROM mac_track_device_types WHERE device_type_id = '-1'"
04/13/2007 04:05:41 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT DISTINCT mac_track_devices.device_type_id, mac_track_device_types.description, mac_track_device_types.sysDescr_match FROM mac_track_device_types RIGHT JOIN mac_track_devices ON (mac_track_device_types.device_type_id = mac_track_devices.device_type_id) WHERE device_type='1' ORDER BY mac_track_device_types.description"
04/13/2007 04:05:41 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select site_id,site_name from mac_track_sites order by site_name"
04/13/2007 04:05:39 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "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 '%10.1.1.3%' OR mac_track_devices.description LIKE '%10.1.1.3%' OR mac_track_sites.site_name LIKE '%10.1.1.3%') AND (mac_track_devices.snmp_status=3) AND (mac_track_devices.disabled = '') AND (mac_track_devices.scan_type=1)"
04/13/2007 04:05:39 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT mac_track_devices.site_id, mac_track_sites.site_name, mac_track_devices.device_id, mac_track_devices.device_type_id, mac_track_devices.description, 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.snmp_sysName, mac_track_devices.snmp_sysLocation, mac_track_devices.snmp_sysContact, mac_track_devices.snmp_sysObjectID, mac_track_devices.snmp_sysDescr, mac_track_devices.snmp_sysUptime, 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.vlans_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 '%10.1.1.3%' OR mac_track_devices.description LIKE '%10.1.1.3%' OR mac_track_sites.site_name LIKE '%10.1.1.3%') AND (mac_track_devices.snmp_status=3) AND (mac_track_devices.disabled = '') AND (mac_track_devices.scan_type=1) ORDER BY site_name ASC LIMIT 0,30"
04/13/2007 04:05:39 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed "SELECT * FROM mac_track_device_types WHERE device_type_id = '-1'"
04/13/2007 04:05:39 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "SELECT DISTINCT mac_track_devices.device_type_id, mac_track_device_types.description, mac_track_device_types.sysDescr_match FROM mac_track_device_types RIGHT JOIN mac_track_devices ON (mac_track_device_types.device_type_id = mac_track_devices.device_type_id) WHERE device_type='1' ORDER BY mac_track_device_types.description"
04/13/2007 04:05:39 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "select site_id,site_name from mac_track_sites order by site_name"

Any thoughts? Thanks!


EDIT:Problem has been fixed, I just had to import the database...duh! Thanks.
Jacob Bergman
Pullman School District
jbergman@psd267.wednet.edu

Operating System: winserv 2003
Webserver: IIS 6.0
Cacti: BETA windows installer 1.5 (BSOD2600)
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest