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    


Newbie with macTrack

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


Joined: 25 Jan 2008
Posts: 268
Location: California - USA
PostPosted: Tue Mar 04, 2008 9:35 am    Post subject: Newbie with macTrack Reply with quote
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:
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
Back to top
TheWitness
Developer


Joined: 14 May 2002
Posts: 9434
Location: MI, USA
PostPosted: Tue Mar 04, 2008 9:36 pm    Post subject: Reply with quote
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
Back to top
cyrill
Cacti User


Joined: 25 Jan 2008
Posts: 268
Location: California - USA
PostPosted: Wed Mar 05, 2008 1:42 am    Post subject: Reply with quote
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...

sql.JPG
 Description:
 Filesize:  25.42 KB
 Viewed:  1748 Time(s)

sql.JPG
Back to top
TheWitness
Developer


Joined: 14 May 2002
Posts: 9434
Location: MI, USA
PostPosted: Wed Mar 05, 2008 6:45 am    Post subject: Reply with quote
What version ar you running?

TheWitness
Back to top
cyrill
Cacti User


Joined: 25 Jan 2008
Posts: 268
Location: California - USA
PostPosted: Fri Mar 07, 2008 3:20 am    Post subject: Reply with quote
0.8.7a for cacti and the last for mactrack.
Back to top
litass



Joined: 09 Oct 2007
Posts: 19
PostPosted: Thu Mar 13, 2008 1:29 pm    Post subject: Reply with quote
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:

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:

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.
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