Place Your Feature Requests & Bug Reports Here

[chadd]

I am now getting results in the MAC/IP report UI for Vendor Name, but again, like 90% are still NULL in the database. Actually, now that I am looking harder, it appears as though the results are spurious. I get Vendor name results if I use the 'Search' field in the MAC/IP Report, but not simply by choosing a site. And, I get results if I just use the search field and choose no site, but again, not with the default report. I think some code is missing in that section of the mactrack_view.php file... That's my guess anyway.. Anyway, I hope I have helped some at least..

Also, there is a small issue with the UI on the MAC/IP report page as show in the attached png.

LARRY EDIT: Colspan - Done

[TheWitness]

I may have missed something in the poller update. Look at the database_upgrade.php script and run it again. In the SVN from two day's ago, I moved the MacTrack updates to a reference table. You will know you are running that version if you are able to sort on the Vendor Name. If you can't, you are back a release.

Also, see if any of the ports in the "mac_track_ports" table have a blank VENDOR_MAC. If they do, then either the update script is hosed, or the poller script. Please let me know what you find out.

TheWitness

[TheWitness]

streaker69,

Post what you have and let me compare it with the IEEE database.

Thanks,

Larry

[streaker69]

[TheWitness]

Chadd etal,

I have just pushed an update to SVN to remove quote characters. Please test it.

TheWitness

[MagicOneXXX]

[chadd]

Here is the cacti log from the database_upgrade from the latest svn version:

01/05/2007 05:25:29 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "CREATE TABLE `mac_track_macauth` (`mac_address` varchar(20) NOT NULL, `description` varchar(100) NOT NULL, `added_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `added_by` varchar(20) NOT NULL, PRIMARY KEY (`mac_address`)) TYPE = MyISAM DEFAULT;"
01/05/2007 05:25:29 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "CREATE TABLE `mac_track_macwatch` ( `mac_address` varchar(20) NOT NULL, `name` varchar(45) NOT NULL, `description` varchar(255) NOT NULL, `ticket_number` varchar(45) NOT NULL, `notify_schedule` tinyint(3) unsigned NOT NULL, `e-mail_addresses` varchar(255) NOT NULL, `discovered` tinyint(3) unsigned NOT NULL, `date_first_seen` timestamp NOT NULL default '0000-00-00 00:00:00', `data_last_seen` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`mac_address`)) TYPE=MyISAM;"
01/05/2007 05:25:29 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_ports` ADD COLUMN `authorized` TINYINT UNSIGNED NOT NULL DEFAULT 0 AFTER `scan_date`, ADD INDEX `authorized`(`authorized`), TYPE = MyISAM;"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_temp_ports` ADD COLUMN `authorized` TINYINT UNSIGNED NOT NULL DEFAULT 0 AFTER `updated`, ADD INDEX `authorized`(`authorized`), TYPE = HEAP;"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_temp_ports` ADD COLUMN `vendor_mac` VARCHAR( NULL AFTER `mac_address`, ADD INDEX `vendor_mac`(`vendor_mac`), TYPE = HEAP;"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_ports` ADD COLUMN `vendor_mac` VARCHAR( NULL AFTER `mac_address`, ADD INDEX `vendor_mac`(`vendor_mac`), TYPE = MyISAM;"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "CREATE TABLE `mac_track_oui_database` (`vendor_mac` varchar( NOT NULL,`vendor_name` varchar(100) NOT NULL,`vendor_address` text NOT NULL,`present` tinyint(3) unsigned NOT NULL default '1', PRIMARY KEY (`vendor_mac`), KEY `vendor_name` (`vendor_name`)) TYPE=MyISAM"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "CREATE TABLE `mac_track_approved_macs` (`mac_prefix` VARCHAR(20) NOT NULL, `vendor` VARCHAR(50) NOT NULL, `description` VARCHAR(255) NOT NULL, PRIMARY KEY(`mac_prefix`)) TYPE = MyISAM;"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_processes` ADD COLUMN `process_id` INTEGER UNSIGNED AFTER `device_id`;"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_processes` CHANGE COLUMN `process_id` `device_id` INTEGER NOT NULL DEFAULT 0;"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_ip_ranges` ADD COLUMN `ips_current_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `ips_max_date`;"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_ip_ranges` ADD COLUMN `ips_max_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER `ips_current`;"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "CREATE TABLE `mac_track_ip_ranges` (`ip_range` VARCHAR(20) NOT NULL, `site_id` INTEGER UNSIGNED NOT NULL, `ips_max` INTEGER UNSIGNED NOT NULL, `ips_current` INTEGER UNSIGNED NOT NULL, PRIMARY KEY(`ip_range`, `site_id`), INDEX `site_id`(`site_id`))"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_temp_ports` ADD INDEX `ip_address`(`ip_address`);"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_temp_ports` ADD INDEX `updated`(`updated`);"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_temp_ports` ADD COLUMN `updated` TINYINT UNSIGNED NOT NULL DEFAULT 0 AFTER `scan_date`;"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_ports` ADD INDEX `dns_hostname`(`dns_hostname`);"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_ports` ADD INDEX `port_name`(`port_name`);"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_devices` ADD INDEX `device_type_id`(`device_type_id`);"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_devices` ADD COLUMN `device_type_id` INT(10) UNSIGNED DEFAULT 0 AFTER `device_id`;"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_devices` ADD INDEX `snmp_sysDescr`(`snmp_sysDescr`), ADD INDEX `snmp_sysObjectID`(`snmp_sysObjectID`);"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "CREATE TABLE `mac_track_scan_dates` (`scan_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY(`scan_date`));"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_device_types` DROP PRIMARY KEY, ADD PRIMARY KEY(`sysDescr_match`, `sysObjectID_match`, `device_type`), ADD INDEX `device_type_id`(`device_type_id`);"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_sites` ADD COLUMN `total_oper_ports` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `total_user_ports`;"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_devices` DROP PRIMARY KEY, ADD PRIMARY KEY(`hostname`, `snmp_port`, `site_id`), ADD INDEX `device_id`(`device_id`);"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "CREATE TABLE `mac_track_scanning_functions` (`scanning_function` VARCHAR(100) NOT NULL DEFAULT '', `description` VARCHAR(200) NOT NULL DEFAULT '', PRIMARY KEY(`scanning_function`));"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_devices` ADD COLUMN `snmp_sysContact` VARCHAR(100) DEFAULT '' AFTER `snmp_sysLocation`;"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_devices` ADD COLUMN `snmp_sysLocation` VARCHAR(100) DEFAULT '' AFTER `snmp_sysName`;"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_devices` ADD COLUMN `snmp_sysName` VARCHAR(100) DEFAULT '' AFTER `snmp_retries`;"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_devices` ADD COLUMN `macs_active` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `ports_trunk`;"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_devices` ADD COLUMN `snmp_port` INT(10) UNSIGNED NOT NULL DEFAULT '161' AFTER `snmp_version`;"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_ips` ADD COLUMN `dns_hostname` VARCHAR(200) DEFAULT '' AFTER `ip_address`;"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_temp_ports` ADD COLUMN `dns_hostname` VARCHAR(200) DEFAULT '' AFTER `ip_address`;"
01/05/2007 05:25:28 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE `mac_track_ports` ADD COLUMN `dns_hostname` VARCHAR(200) DEFAULT '' AFTER `ip_address`;"

I will look into it more on Monday.

LARRY EDIT: Done! Write several import scripts. No more ERRORS in the Cacti log and informative messages from the command line

[TheWitness]

I am going to make the update logic aware of wether or not the script has already been run so that you don't get those error messages in the log. I will not have time to work on this this weekend. So, if you see anything on Monday, you will be lucky.

TheWitness

[chadd]

Ok. Thanks for the help.

[TheWitness]

Chadd, can you dump your mac_track_ports table and send to me. If you need a place to send it to, I can open a port on my system. You'll have to hook up with me via IM or PM though.

TheWitness

[chadd]

[shakey_1]

Would it be possible to show duplex settings and port speeds?

LARRY EDIT: Done!

[TheWitness]

shakey_1,

This is a feature that I was considering. That of adding a static "status" page for every device. However, most of this information can be obtained real-time. Is there a reason you want historical "duplex" history?

TheWitness

[shakey_1]

Basically, we have a Netdisco system being used that I would like to do away with as the only thing it gets used for is to check those settings. Ensuring that speeds are showing 100 Mbps and what the duplex settings show as. I'm fairly new to the networking world, so I may be missing something, but it just seems like a waste to me to have that system running when everything else I use is within Cacti. Short of Nagios and my NDT server.

[egarnel]

Oooh, oooh....

The ability to schedule mac-track result exports. this would be really cool!