[SOLVED] MACTRACK - how too

[kbartoletta]

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]

It uses Cacti. Unfortunately, I have not been spending time on MacTrack for a while..

TheWitness

[tdupas]

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

[yardus9]

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

[TheWitness]

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

[bhaxe]

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.

[tdupas]

hmm,

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

Mysql v3 <-> v5 as you can see,
perhaps a change in syntaxing between the versions?

[bhaxe]

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.

[bhaxe]

Ok I changed to "ENGINE=MyISAM" to "TYPE=MyISAM", and now worked.

[lga]

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.