Cacti (home)ForumsRepositoryDocumentation
Cacti: offical forums and support  

 FAQFAQ   SearchSearch   MemberlistMemberlist    RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in    


Mactrack troubles

 
Post new topic   Reply to topic    Cacti Forum Index -> Plugin: (MAC Track)
Author Message
Dacob9906
Cacti User


Joined: 03 Apr 2007
Posts: 189
Location: Pullman Washington

PostPosted: Fri Apr 13, 2007 6:09 pm    Post subject: Mactrack troubles Reply with quote

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.
Back to top
Display posts from previous:   
Post new topic   Reply to topic    Cacti Forum Index -> Plugin: (MAC Track) All times are GMT - 5 Hours
Page 1 of 1

 



Powered by phpBB © 2001, 2005 phpBB Group