[SOLVED] cactiEZ-cd: mactrack - 'Error:Save Failed'

[Fuchs]

I have installed the cactiEZ-cd which gives this versions:

Cacti Version - 0.8.7c
Plugin Architecture - 2.2
Poller Type - Cactid v
Server Info - Linux 2.6.9-78.0.13.plus.c4smp
Web Server - Apache/2.0.63 (CentOS)
PHP - 5.1.6
PHP Extensions - libxml, xml, wddx, tokenizer, sysvshm, sysvsem, sysvmsg, standard, SimpleXML, sockets, SPL, shmop, session, Reflection, pspell, posix, mime_magic, iconv, hash, gmp, gettext, ftp, exif, date, curl, ctype, calendar, bz2, zlib, pcre, openssl, apache2handler, gd, ldap, mysql, mysqli, PDO, pdo_mysql, pdo_sqlite, snmp, eAccelerator
MySQL - 5.0.68
RRDTool - 1.2.23
SNMP - 5.1.2
Plugins

• Global Plugin Settings (settings - v0.5)
  Large Site Performane Booster for Cacti (boost - v2.2)
  Device Monitoring (monitor - v0.8.2)
  Network Discovery (discovery - v0.8.5)
  Network Tools (tools - v0.3)
  Syslog Monitoring (syslog - v0.5.2)
  Device Tracking (mactrack - v1.1)
  Login Page Mod (loginmod - v1.0)
  Update Checker (update - v0.4)
  FlowView (flowview - v0.6)
  Host Info (hostinfo - v0.2)
  Error Images (errorimage - v0.1)
  PHP Network Weathermap (weathermap - v0.95b)
  docs
  Cacti-ReportIt (reportit - v0.6.1)
  NTop Viewer (ntop - v0.1)
  Router Configs (routerconfigs - v0.1)
  WMI Query (wmi - v0.1)
  Realtime for Cacti (realtime - v0.35)

All my tries to create something in mactrack (sites, devices, ..) are answered with: Error: Save Failed.

please give me some hints.

[mcutting]

Did you run the database upgrade script ?

[Fuchs]

No. I think the cd is 'ready to use'
mysql cacti show tables
shows these tables beginning with 'mac_track):

mac_track_approved_macs |
| mac_track_device_types |
| mac_track_devices |
| mac_track_ip_ranges |
| mac_track_ips |
| mac_track_macauth |
| mac_track_macwatch |
| mac_track_oui_database |
| mac_track_ports |
| mac_track_processes |
| mac_track_scan_dates |
| mac_track_scanning_functions |
| mac_track_sites |
| mac_track_temp_ports |

[mcutting]

I think you still need to run this script.

[Fuchs]

foregive my dumb questions, but I am very new to cacti:

Now I have run:

mysql cacti < /var/www/html/plugins/mactrack/mactrack.sql
without changes to the database, because all tables existed already

mysql cacti < /var/www/html/plugins/mactrack/mactrack.sql.0.0.1
with changes to the database.

But the result ist unchanged: all saves to the database give 'Error: Save Failed.'.

The only success with mactrack was with:
Tracking Utilities -> Refresh IEEE Vendor MAC/OUI Database

with filled the table: mac_track_oui_database

BTW.: In /var/www/html/plugins/mactrack/docs
there is an file: mactrack_documentation.doc which is damaged. Do you know a url to download a intact copy?

[TheWitness]

The best documentation was on the Docs site. However, some of the data was lost. There is a database upgrade script in the mactrack plugin directory. Please run it. I do not know if this is required or not, but it should not hurt to try.

The bottom line is that for each site you need >= 1 Router and >1 Switch/Hub that is supported. You need to setup a scanning frequency, and then use PHP 5.1 or better, and running on Linux is best.

Beyond that everything is pretty strait forward. There are a few features that are not complete, but I am doing some pretty heavy development for 2.0 right now and will be fixing that.

TheWitness

[Fuchs]

Thank you for your tips. You were right running database_upgrade.php
dit the trick. But it was not in the cd-distribution.

[TheWitness]

Sorry about that. Working on 2.0 as we speak.

TheWitness

[obeygiant]

Thank you for your tips. You were right running database_upgrade.php
dit the trick. But it was not in the cd-distribution.

Here's what I did to resolve the issue.

Code: Select all

 cd /var/www/html/plugins/mactrack/

Code: Select all

php database_upgrade.php

Here are the results

[root@localhost mactrack]# php database_upgrade.php
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> snmp_timeout, Ok
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> snmp_retries, Ok
SUCCESS: Add Column, Table -> mac_track_ports, Column -> dns_hostname, Already Exists!
SUCCESS: Add Column, Table -> mac_track_temp_ports, Column -> dns_hostname, Already Exists!
SUCCESS: Add Column, Table -> mac_track_ips, Column -> dns_hostname, Already Exists!
SUCCESS: Add Column, Table -> mac_track_devices, Column -> snmp_port, Already Exists!
SUCCESS: Add Column, Table -> mac_track_devices, Column -> macs_active, Already Exists!
SUCCESS: Add Column, Table -> mac_track_devices, Column -> snmp_sysName, Already Exists!
SUCCESS: Add Column, Table -> mac_track_devices, Column -> snmp_sysLocation, Already Exists!
SUCCESS: Add Column, Table -> mac_track_devices, Column -> snmp_sysContact, Already Exists!
SUCCESS: Create Table, Table -> mac_track_scanning_functions, Already Exists!
SUCCESS: Execute SQL, Change Primary Key For 'mac_track_devices', Ok
SUCCESS: Add Index, Table -> mac_track_devices, Index -> device_id, Already Exists!
SUCCESS: Add Column, Table -> mac_track_sites, Column -> total_oper_ports, Already Exists!
SUCCESS: Execute SQL, Change Primary Key For 'mac_track_device_types', Ok
SUCCESS: Add Index, Table -> mac_track_device_types, Index -> device_type_id, Already Exists!
SUCCESS: Modify Column, Table -> mac_track_scanning_functions, Column -> scanning_function, Ok
SUCCESS: Modify Column, Table -> mac_track_scanning_functions, Column -> description, Ok
SUCCESS: Create Table, Table -> mac_track_scan_dates, Already Exists!
SUCCESS: Execute SQL, Addition of Scan Dates, Ok
SUCCESS: Add Index, Table -> mac_track_devices, Index -> snmp_sysDescr, Already Exists!
SUCCESS: Add Index, Table -> mac_track_devices, Index -> snmp_sysObjectID, Already Exists!
SUCCESS: Add Column, Table -> mac_track_devices, Column -> device_type_id, Already Exists!
SUCCESS: Add Index, Table -> mac_track_devices, Index -> device_type_id, Already Exists!
SUCCESS: Add Index, Table -> mac_track_ports, Index -> port_name, Already Exists!
SUCCESS: Add Index, Table -> mac_track_ports, Index -> dns_hostname, Already Exists!
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> ips_total, Ok
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> vlans_total, Ok
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> ports_total, Ok
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> ports_active, Ok
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> ports_trunk, Ok
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> macs_active, Ok
SUCCESS: Add Column, Table -> mac_track_temp_ports, Column -> updated, Already Exists!
SUCCESS: Add Index, Table -> mac_track_temp_ports, Index -> updated, Already Exists!
SUCCESS: Add Index, Table -> mac_track_temp_ports, Index -> ip_address, Already Exists!
SUCCESS: Create Table, Table -> mac_track_ip_ranges, Already Exists!
SUCCESS: Add Column, Table -> mac_track_ip_ranges, Column -> ips_max_date, Already Exists!
SUCCESS: Add Column, Table -> mac_track_ip_ranges, Column -> ips_current_date, Ok
SUCCESS: Add Column, Table -> mac_track_processes, Column -> device_id, Already Exists!
SUCCESS: Add Column, Table -> mac_track_processes, Column -> process_id, Already Exists!
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> snmp_readstring, Ok
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> snmp_readstrings, Ok
SUCCESS: Execute SQL, Change mac_track_temp_ports to Memory Table, Ok
SUCCESS: Execute SQL, Change mac_track_ips to Memory Table, Ok
SUCCESS: Create Table, Table -> mac_track_approved_macs, Already Exists!
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> ignorePorts, Ok
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> snmp_readstring, Ok
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> snmp_readstrings, Ok
SUCCESS: Create Table, Table -> mac_track_oui_database, Already Exists!
SUCCESS: Add Column, Table -> mac_track_ports, Column -> vendor_mac, Ok
SUCCESS: Add Index, Table -> mac_track_ports, Index -> vendor_mac, Ok
SUCCESS: Add Column, Table -> mac_track_temp_ports, Column -> vendor_mac, Ok
SUCCESS: Add Index, Table -> mac_track_temp_ports, Index -> vendor_mac, Ok
SUCCESS: Execute SQL, Add Vendor Macs To 'mac_track_ports', Ok
SUCCESS: Execute SQL, Add Vendor Macs To 'mac_track_temp_ports', Ok
SUCCESS: Add Column, Table -> mac_track_temp_ports, Column -> authorized, Ok
SUCCESS: Add Index, Table -> mac_track_temp_ports, Index -> authorized, Ok
SUCCESS: Add Column, Table -> mac_track_ports, Column -> authorized, Ok
SUCCESS: Add Index, Table -> mac_track_ports, Index -> authorized, Ok
SUCCESS: Create Table, Table -> mac_track_macwatch, Already Exists!
SUCCESS: Create Table, Table -> mac_track_macauth, Already Exists!
SUCCESS: Create Table, Table -> mac_track_vlans, Ok
SUCCESS: Execute SQL, Add VLANS to VLAN Table, Ok
SUCCESS: Modify Column, Table -> mac_track_devices, Column -> description, Ok
SUCCESS: Add Column, Table -> mac_track_devices, Column -> device_name, Ok
SUCCESS: Add Index, Table -> mac_track_devices, Index -> device_name, Ok
SUCCESS: Add Column, Table -> mac_track_sites, Column -> customer_contact, Ok
SUCCESS: Add Column, Table -> mac_track_sites, Column -> netops_contact, Ok
SUCCESS: Add Column, Table -> mac_track_sites, Column -> facilities_contact, Ok
SUCCESS: Add Column, Table -> mac_track_sites, Column -> site_info, Ok
SUCCESS: Add Column, Table -> mac_track_device_types, Column -> serial_number_oid, Ok
SUCCESS: Execute SQL, Move Device Names from the 'description' field to the 'device_name' field., Ok
SUCCESS: Execute SQL, Blank out the 'description' field as it will now be used for something else, Ok
SUCCESS: Add Column, Table -> mac_track_macwatch, Column -> email_addresses, Ok
SUCCESS: Add Column, Table -> mac_track_macwatch, Column -> mac_id, Ok
SUCCESS: Add Column, Table -> mac_track_macwatch, Column -> date_last_seen, Ok
SUCCESS: Add Column, Table -> mac_track_macauth, Column -> mac_id, Ok
SUCCESS: Add Column, Table -> mac_track_ports, Column -> device_name, Ok
SUCCESS: Add Column, Table -> mac_track_temp_ports, Column -> device_name, Ok
SUCCESS: Add Column, Table -> mac_track_devices, Column -> notes, Ok
SUCCESS: Modify Column, Table -> mac_track_ips, Column -> description, Ok
SUCCESS: Delete Column, Table -> mac_track_devices, Column -> serial_number, Column Does NOT Exist!
SUCCESS: Delete Column, Table -> mac_track_devices, Column -> asset_id, Column Does NOT Exist!
SUCCESS: Create Table, Table -> mac_track_interfaces, Ok
SUCCESS: Add Column, Table -> mac_track_scanning_functions, Column -> type, Ok
SUCCESS: Add Column, Table -> mac_track_device_types, Column -> ip_scanning_function, Ok
SUCCESS: Execute SQL, Update the Scanning Function Type to 'Mac' for undefined types, Ok
SUCCESS: Execute SQL, Set the IP Scanning function to N/A for Device Type 1, Ok
SUCCESS: Execute SQL, Set the IP Scanning function to 'get_standard_arp_table' for Routers and L3 Switches, Ok
SUCCESS: Add Column, Table -> mac_track_interfaces, Column -> vlan_trunk, Ok
SUCCESS: Add Column, Table -> mac_track_devices, Column -> user_name, Ok
SUCCESS: Add Column, Table -> mac_track_devices, Column -> user_password, Ok

Updating Device Types in Devices Table. Please be patient.


Device Types Updated, You have '0' Good Device Type Mapping and '0' Bad Device Type Mapping.
If the Bad Device type mapping is greater than '0', you should inspect your devices for unmapped device types.

Importing the Vendor MAC Address Table from the IEEE

PHP Notice: Undefined variable: oui_file in /var/www/html/plugins/mactrack/mactrack_import_ouidb.php on line 70

Notice: Undefined variable: oui_file in /var/www/html/plugins/mactrack/mactrack_import_ouidb.php on line 70
Getting OUI Database from the IEEE
OUI Database Download from IEEE Complete

There were '0' Entries Added/Updated in the database.
There were '0' Records Removed from the database.

Database Upgrade Complete