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.
Mactrack troubles
Moderators: Developers, Moderators
Mactrack troubles
Jacob Bergman
Pullman School District
jbergman@psd267.wednet.edu
Operating System: winserv 2003
Webserver: IIS 6.0
Cacti: BETA windows installer 1.5 (BSOD2600)
Pullman School District
jbergman@psd267.wednet.edu
Operating System: winserv 2003
Webserver: IIS 6.0
Cacti: BETA windows installer 1.5 (BSOD2600)
Who is online
Users browsing this forum: No registered users and 1 guest