Problems with the latest Mactrack svn

[chadd]

here are the errors in the cacti log:

02/15/2007 08:49:13 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "CREATE TABLE `cacti086`.`mac_track_interfaces` (`site_id` int(10) unsigned NOT NULL default '0', `device_id` int(10) unsigned NOT NULL default '0', `ifIndex` int(10) unsigned NOT NULL default '0', `ifName` varchar(128) NOT NULL, `ifAlias` varchar(255) NOT NULL, `ifDescr` varchar(128) NOT NULL, `ifType` int(10) unsigned NOT NULL default '0', `ifMtu` int(10) unsigned NOT NULL default '0', `ifSpeed` int(10) unsigned NOT NULL default '0', `ifPhysAddress` varchar(20) NOT NULL, `ifAdminStatus` int(10) unsigned NOT NULL default '0', `ifOperStatus` int(10) unsigned NOT NULL default '0', `ifLastChange` int(10) unsigned NOT NULL default '0', `linkPort` tinyint(3) unsigned NOT NULL default '0', `vlan_id` int(10) unsigned NOT NULL, `vlan_name` varchar(128) NOT NULL, `vlan_trunk_status` int(10) unsigned NOT NULL, `ifInDiscards` int(10) unsigned NOT NULL default '0', `ifInErrors` int(10) unsigned NOT NULL default '0', `ifInUnknownProtos` int(10) unsigned NOT NULL default '0', `ifOutDiscards` int(10) unsigned default '0', `ifOutErrors` int(10) unsigned default '0', `last_up_time` timestamp NOT NULL default '0000-00-00 00:00:00', `last_down_time` timestamp NOT NULL default '0000-00-00 00:00:00', `stateChanges` int(10) unsigned NOT NULL default '0', `int_discards_present` tinyint(3) unsigned NOT NULL default '0', `int_errors_present` tinyint(3) unsigned NOT NULL default '0', `present` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`site_id`,`device_id`,`ifIndex`), KEY `ifDescr` (`ifDescr`), KEY `ifType` (`ifType`), KEY `ifSpeed` (`ifSpeed`), KEY `ifMTU` (`ifMtu`), KEY `ifAdminStatus` (`ifAdminStatus`), KEY `ifOperStatus` (`ifOperStatus`), KEY `ifInDiscards` USING BTREE (`ifInUnknownProtos`), KEY `ifInErrors` USING BTREE (`ifInUnknownProtos`)) TYPE=MyISAM;"
02/15/2007 08:49:13 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "UPDATE mac_track_devices SET description=''"
02/15/2007 08:49:13 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "UPDATE mac_track_devices SET device_name=description WHERE device_name IS NULL OR device_name=''"
02/15/2007 08:49:13 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_devices` ADD INDEX `asset_id`(`asset_id`), TYPE = MyISAM;"
02/15/2007 08:49:13 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_devices` ADD INDEX `serial_number`(`serial_number`), TYPE = MyISAM;"
02/15/2007 08:49:13 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_devices` ADD COLUMN `asset_id` VARCHAR(25) DEFAULT '' AFTER `serial_number`, TYPE = MyISAM;"
02/15/2007 08:49:13 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_devices` ADD COLUMN `serial_number` VARCHAR(25) DEFAULT '' AFTER `description`, TYPE = MyISAM;"


Here is the output from the database upgrade:

su-2.05b# 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, Already Exists!
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, Already Exists!
SUCCESS: Add Index, Table -> mac_track_ports, Index -> vendor_mac, Already Exists!
SUCCESS: Add Column, Table -> mac_track_temp_ports, Column -> vendor_mac, Already Exists!
SUCCESS: Add Index, Table -> mac_track_temp_ports, Index -> vendor_mac, Already Exists!
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, Already Exists!
SUCCESS: Add Index, Table -> mac_track_temp_ports, Index -> authorized, Already Exists!
SUCCESS: Add Column, Table -> mac_track_ports, Column -> authorized, Already Exists!
SUCCESS: Add Index, Table -> mac_track_ports, Index -> authorized, Already Exists!
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, Already Exists!
SUCCESS: Execute SQL, Add VLANS to VLAN Table, Ok
ERROR: Modify Column, Table -> mac_track_devices, Column -> description, Column Does NOT Exist!
SUCCESS: Add Column, Table -> mac_track_devices, Column -> device_name, Already Exists!
ERROR: Add Column, Table -> mac_track_devices, Column -> serial_number, Failed!
ERROR: Add Column, Table -> mac_track_devices, Column -> asset_id, Failed!
SUCCESS: Add Index, Table -> mac_track_devices, Index -> device_name, Already Exists!
ERROR: Add Index, Table -> mac_track_devices, Index -> serial_number, Failed!
ERROR: Add Index, Table -> mac_track_devices, Index -> asset_id, Failed!
SUCCESS: Add Column, Table -> mac_track_sites, Column -> customer_contact, Already Exists!
SUCCESS: Add Column, Table -> mac_track_sites, Column -> netops_contact, Already Exists!
SUCCESS: Add Column, Table -> mac_track_sites, Column -> facilities_contact, Already Exists!
SUCCESS: Add Column, Table -> mac_track_sites, Column -> site_info, Already Exists!
SUCCESS: Add Column, Table -> mac_track_device_types, Column -> serial_number_oid, Already Exists!
ERROR: Execute SQL, Move Device Names from the 'description' field to the 'device_name' field., Failed!
ERROR: Execute SQL, Blank out the 'description' field as it will now be used for something else, Failed!
SUCCESS: Add Column, Table -> mac_track_macwatch, Column -> email_addresses, Already Exists!
SUCCESS: Add Column, Table -> mac_track_macwatch, Column -> mac_id, Already Exists!
SUCCESS: Add Column, Table -> mac_track_macwatch, Column -> date_last_seen, Already Exists!
SUCCESS: Add Column, Table -> mac_track_macauth, Column -> mac_id, Already Exists!
SUCCESS: Add Column, Table -> mac_track_ports, Column -> device_name, Already Exists!
SUCCESS: Add Column, Table -> mac_track_temp_ports, Column -> device_name, Already Exists!
SUCCESS: Add Column, Table -> mac_track_devices, Column -> notes, Already Exists!
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!
ERROR: Create Table, Table -> mac_track_interfaces, Failed!

Updating Device Types in Devices Table. Please be patient.
...................

Device Types Updated, You have '196' 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

Getting OUI Database from the IEEE
OUI Database Download from IEEE Complete
.....................................................................................................
There were '10039' Entries Added/Updated in the database.
There were '0' Records Removed from the database.

Database Upgrade Complete
su-2.05b#

[lavermil]

I got the same error. I wonder if cacti086 is suppose to be there. I thinking that was accidentially left in.

I removed it and I was successful with the install. At least from the database_upgrade.php stand point.

[lavermil]

I got the same error. I wonder if cacti086 is suppose to be there. I thinking that was accidentially left in.

I removed it and I was successful with the install. At least from the database_upgrade.php stand point.

The crappy thing for me was all of my vendor stuff got trashed.

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.

[lavermil]

I got the same error. I wonder if cacti086 is suppose to be there. I thinking that was accidentially left in.

I removed it and I was successful with the install. At least from the database_upgrade.php stand point.

The crappy thing for me was all of my vendor stuff got trashed.

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.

nm about the vendor stuff, as it is there. The message is incorrect.

[lavermil]

I got the same error. I wonder if cacti086 is suppose to be there. I thinking that was accidentially left in.

I removed it and I was successful with the install. At least from the database_upgrade.php stand point.

I get this error though.

Notice: Undefined index: site_info in /srv/www/htdocs/cacti/plugins/mactrack/mactrack_sites.php on line 66

Notice: Undefined index: site_info in /srv/www/htdocs/cacti/plugins/mactrack/mactrack_sites.php on line 248

Warning: Cannot modify header information - headers already sent by (output started at /srv/www/htdocs/cacti/plugins/mactrack/mactrack_sites.php:66) in /srv/www/htdocs/cacti/plugins/mactrack/mactrack_sites.php on line 71

[TheWitness]

I plan on working on this on Monday. I will post in Announcements sometime Monday as to what is good/bad.

TheWitness

[noskill]

where does one download the svn version of mactrack?

[TheWitness]

Frome the same repository as Cacti, except that you have to change the last bit to "mactrack" instead of "cacti".

http://www.cacti.net/svn.php

TheWitness

[goncal]

I have indeed tried "svn checkout svn://svn.cacti.net/var/svnroot/mactrack" but so far with no luck

Has it moved to a new place?

Thanks in advance!

[apperrault]

Here is where i get the SVN versions from. Hope this helps.

[url]svn://svn.cacti.net/var/svnroot/cacti_plugins[/url]

Enjoy

app