[SOLVED] Newbie with macTrack

[cyrill]

Hello

I installed the plugin but I can't create a new site. I set up all field and when I click on the button save, i've the message : Error : Save Failed

I don't know if it's important bug in the log fail, i've the folowing error :

Code: Select all

03/04/2008 03:43:13 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(mac_track_sites.site_id) FROM mac_track_sites "  
03/04/2008 03:43:13 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT mac_track_sites.site_id, mac_track_sites.site_name, mac_track_sites.total_devices, mac_track_sites.total_device_errors, mac_track_sites.total_macs, mac_track_sites.total_ips, mac_track_sites.total_oper_ports, mac_track_sites.total_user_ports FROM mac_track_sites ORDER BY site_name ASC LIMIT 0,30"  
03/04/2008 03:43:13 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1146', SQL:"SELECT * FROM mac_track_device_types WHERE device_type_id = '-1'"  

thanks for your precious help

[TheWitness]

Looks like you don't have the table structure in place. An 1146 error means the table does not exist. There is a mac_track.sql file that you have to source in MySQL.

TheWitness

[cyrill]

yes you are right. Now i've inserted the file mactrack.sql but I've always the same error. in cacti. But in the log I haven't error...

[TheWitness]

What version ar you running?

TheWitness

[cyrill]

0.8.7a for cacti and the last for mactrack.

[litass]

I've a similar problem too. mactrack.sql was inserted. When i add a new site, it show Error: Save failed. Below as event log:

Code: Select all

03/14/2008 02:10:14 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 '%%%%'))"
03/14/2008 02:10:14 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" 

MySql database information:

Code: Select all

mac_track_approved_macs  	0  	MyISAM  	latin1_swedish_ci  	OK
mac_track_device_types 	0 	MyISAM 	latin1_swedish_ci 	OK
mac_track_devices 	0 	MyISAM 	latin1_swedish_ci 	OK
mac_track_ip_ranges 	0 	MyISAM 	latin1_swedish_ci 	OK
mac_track_ips 	0 	MEMORY 	latin1_swedish_ci 	The storage engine for the table doesn't support check
mac_track_macauth 	0 	InnoDB 	latin1_swedish_ci 	OK
mac_track_macwatch 	0 	MyISAM 	latin1_swedish_ci 	OK
mac_track_oui_database 	0 	MyISAM 	latin1_swedish_ci 	OK
mac_track_ports 	0 	MyISAM 	latin1_swedish_ci 	OK
mac_track_processes 	1 	MyISAM 	latin1_swedish_ci 	OK
mac_track_scan_dates 	0 	MyISAM 	latin1_swedish_ci 	OK
mac_track_scanning_functions 	0 	MyISAM 	latin1_swedish_ci 	OK
mac_track_sites 	0 	MyISAM 	latin1_swedish_ci 	OK
mac_track_temp_ports 	0 	MEMORY 	latin1_swedish_ci 	The storage engine for the table doesn't support check

Any advice?

Edit: Solved. I saw this problem at other thread. Solution:
Under mactrack folder run: php database_upgade.php
Now can add site.