|
|
| Author |
Message |
kbartoletta
Cacti User
Joined: 04 Oct 2005
Posts: 97
Location: suwanee, ga
|
 Posted: Wed Oct 04, 2006 10:43 pm Post subject: MACTRACK - how too |
 |
|
| Is there any documentation/ installation instructions for this plugin? I.E - does it require a new DB specifically for mactrack or does it use the cacti DB?
|
|
| Back to top |
|
 |
TheWitness
Developer
Joined: 14 May 2002
Posts: 9695
Location: MI, USA
|
| Posted: Wed Oct 04, 2006 11:44 pm Post subject: |
|
|
It uses Cacti. Unfortunately, I have not been spending time on MacTrack for a while..
TheWitness
|
|
| Back to top |
|
|
tdupas
Joined: 03 Oct 2006
Posts: 17
|
| Posted: Thu Oct 05, 2006 9:20 am Post subject: |
|
|
TheWitness: Do you have any clues on this issue?
I run cacti 0.8.6.h, patched it with the Plugin Architecture - v0.9
I extracted Mac Track - v0.0.1b in the plugins folders, altered the plugin/config.php as follows
| Code: |
$plugins = array();
$plugins[] = 'mactrack';
/* Do not edit this line */
$config = array();
|
I read in another topic that you should leave the "patched_files" unless you are using the svn version of mactrack with the stable (h) version of cacti. Is this correct?
Should you inject the mactrack.sql in the cacti table?
I tried it with and without the patched files, with and without the sql injection. But I don't receive the mactrack tab in the navigation header (and therefor can't access the mactrack section  )
a quick-and-dirty guideline would be handy to include in the package 
/edit: for the record, because I think this will be the first question:
I did give permissions to my user in the user permissions tab
currently it has the following mactrack items enabled:
View MacTrack Data
Update MacTrack Sites/Devices/Types
/edit2: I really have to stop correcting my own mistakes
After cross-checking filesizes between the vanilla cacti-plugin-architecture and my current install I noticed 3 files who weren't altered (probably already during the patching fase).
Things work after overwriting those.
Unfortunatly I can't recall which files ...
|
|
| Back to top |
|
|
yardus9
Cacti User
Joined: 27 Jan 2004
Posts: 77
|
| Posted: Thu Oct 19, 2006 1:56 pm Post subject: |
|
|
I am kinda stuck in the same place. I installed it as a plug-in, and can veiw the pages in the console, but keep getting this error when I try to create a site or device:
Error: Save Failed
I have been reading through that 46 page forum, but cannot find any solution. I also could not find any post on how you get started with the plugin.
I tried to install mactrack.sql as its own database. Also tried to run the database_upgrade.php. Do I need to run a patch? Anybody got any ideas?'
Thanks
|
|
| Back to top |
|
|
TheWitness
Developer
Joined: 14 May 2002
Posts: 9695
Location: MI, USA
|
| Posted: Thu Oct 19, 2006 8:56 pm Post subject: |
|
|
MacTrack belongs in the Cacti database, not by itself. I wish I could make that happen. That is likely your issue:
mysql -u root -p cacti < macktrack.sql
TheWitness
|
|
| Back to top |
|
|
bhaxe
Joined: 19 Oct 2006
Posts: 3
|
| Posted: Sun Oct 22, 2006 11:48 pm Post subject: |
|
|
Hi,
I also installed mactrack but no data shown.
I use show tables in mysql and confirmed that no new tables is created in cacti database.
I execute this command and get the following error:
mysql -u root -p cacti < mactrack.sql
Enter password:
ERROR 1064 at line 6: You have an error in your SQL syntax near 'ENGINE=MyISAM' at line 14
May I have some hits please?
Below please find the software version:-
cacti : Version 0.8.6i
mysqladmin version -u root -p
Server version 3.23.58
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 1 hour 49 min 28 sec
php -v
PHP 4.3.9 (cgi) (built: Oct 20 2004 14:52:04)
Copyright (c) 1997-2004 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies
+------------------------------+
| Tables_in_cacti |
+------------------------------+
| cdef |
| cdef_items |
| colors |
| data_input |
| data_input_data |
| data_input_fields |
| data_local |
| data_template |
| data_template_data |
| data_template_data_rra |
| data_template_rrd |
| graph_local |
| graph_template_input |
| graph_template_input_defs |
| graph_templates |
| graph_templates_gprint |
| graph_templates_graph |
| graph_templates_item |
| graph_tree |
| graph_tree_items |
| host |
| host_graph |
| host_snmp_cache |
| host_snmp_query |
| host_template |
| host_template_graph |
| host_template_snmp_query |
| mac_track_ip_ranges |
| mac_track_scan_dates |
| mac_track_scanning_functions |
| plugin_discover_hosts |
| plugin_discover_os |
| poller |
| poller_command |
| poller_item |
| poller_output |
| poller_reindex |
| poller_time |
| rra |
| rra_cf |
| settings |
| settings_graphs |
| settings_tree |
| snmp_query |
| snmp_query_graph |
| snmp_query_graph_rrd |
| snmp_query_graph_rrd_sv |
| snmp_query_graph_sv |
| thold |
| thold_data |
| thold_template |
| tholdset |
| user_auth |
| user_auth_perms |
| user_auth_realm |
| user_log |
| version |
+------------------------------+
Thank you very much.
Ben.
|
|
| Back to top |
|
|
tdupas
Joined: 03 Oct 2006
Posts: 17
|
| Posted: Mon Oct 23, 2006 12:04 am Post subject: |
|
|
hmm,
I get this:
| Code: |
cacti@Blizzard ~ $ mysqladmin version -u root -p
Enter password:
mysqladmin Ver 8.41 Distrib 5.0.22, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 5.0.22
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 65 days 14 hours 16 min 54 sec
Threads: 2 Questions: 16021902 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 59 Queries per second avg: 2.827 |
Mysql v3 <-> v5 as you can see,
perhaps a change in syntaxing between the versions?
|
|
| Back to top |
|
|
bhaxe
Joined: 19 Oct 2006
Posts: 3
|
| Posted: Mon Oct 23, 2006 1:19 am Post subject: |
|
|
Oh really? I'm not expert but I will try to modify SQL script(by try and error  ).. if any one have one, please post it.
|
|
| Back to top |
|
|
bhaxe
Joined: 19 Oct 2006
Posts: 3
|
| Posted: Mon Oct 23, 2006 4:58 am Post subject: |
|
|
Ok I changed to "ENGINE=MyISAM" to "TYPE=MyISAM", and now worked.
| Description: |
|
Download |
| Filename: |
mactrack_4mysqlv3.txt |
| Filesize: |
14.03 KB |
| Downloaded: |
307 Time(s) |
|
|
| Back to top |
|
|
lga
Joined: 23 May 2005
Posts: 21
Location: Belgium
|
| Posted: Thu Oct 26, 2006 2:52 pm Post subject: |
|
|
Hi,
Just a post to thank TheWitness for mactrack and he continues to improve this plugin 
I'm using cacti with more 6500 graphs and mactrack with more 2300 mac-address ... All works perfectly (with differents materials like catalyst 6500, 7600, ...)
A great work ;p
Thks.
Lionel.
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Register
Profile
Log in to check your private messages
Log in
