[SOLVED] MACTRACK - how too
Moderators: Developers, Moderators
-
- Cacti User
- Posts: 146
- Joined: Tue Oct 04, 2005 4:20 pm
- Location: suwanee, ga
- Contact:
[SOLVED] 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?
- TheWitness
- Developer
- Posts: 17047
- Joined: Tue May 14, 2002 5:08 pm
- Location: MI, USA
- Contact:
It uses Cacti. Unfortunately, I have not been spending time on MacTrack for a while..
TheWitness
TheWitness
True understanding begins only when we realize how little we truly understand...
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
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
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 ...
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: Select all
$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 ...
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
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
- TheWitness
- Developer
- Posts: 17047
- Joined: Tue May 14, 2002 5:08 pm
- Location: MI, USA
- Contact:
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
mysql -u root -p cacti < macktrack.sql
TheWitness
True understanding begins only when we realize how little we truly understand...
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Life is an adventure, let yours begin with Cacti!
Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages
For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
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.
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.
hmm,
I get this:
Mysql v3 <-> v5 as you can see,
perhaps a change in syntaxing between the versions?
I get this:
Code: Select all
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
perhaps a change in syntaxing between the versions?
Ok I changed to "ENGINE=MyISAM" to "TYPE=MyISAM", and now worked.
- Attachments
-
- mactrack_4mysqlv3.txt
- (14.03 KiB) Downloaded 674 times
Who is online
Users browsing this forum: No registered users and 2 guests