[FIXED] Missing Vendor Name(s) after IP Address Discovered

[Leddy]

Is this a bug, or by design? I like knowing the Vendor Names. However once I resolved an issue with no IP's those devices that it was able to ascertain the IP of aren't showing their Vendor names anymore.

I'm assuming not all IP addresses are shown because of arp cache clearing and no activity before running the poller. Feel free to correct me if I'm wrong

[m10]

I got the same problem with you.
I think this is a bug in the mactrack_resolver.php at line 145. Should fix by replace the follow insert_string.

Code: Select all

$insert_string = "REPLACE INTO mac_track_temp_ports " .
				"(site_id,device_id,hostname,dns_hostname,device_name,vlan_id,vlan_name," .
				"mac_address,vendor_mac,ip_address,port_number,port_name,scan_date)" .
				" VALUES ('" .
				$unresolved_ip["site_id"] . "','" .
				$unresolved_ip["device_id"] . "','" .
				$unresolved_ip["hostname"] . "','" .
				$unresolved_ip["dns_hostname"] . "','" .
				$unresolved_ip["device_name"] . "','" .
				$unresolved_ip["vlan_id"] . "','" .
				$unresolved_ip["vlan_name"] . "','" .
				$unresolved_ip["mac_address"] . "','" .
				$unresolved_ip["vendor_mac"] . "','" .
				$unresolved_ip["ip_address"] . "','" .
				$unresolved_ip["port_number"] . "','" .
				$unresolved_ip["port_name"] . "','" .
				$unresolved_ip["scan_date"] . "')";

[tommyj]

Thanks for this, had the same issue myself and adding the row

Code: Select all

           $unresolved_ip["vendor_mac"] . "','" . 

to mactrack_resolver.php resolved for me

[tommyj]

Update: It seems that if I add the row mentioned above I do get the vendor field but it seems that the resolver function stops working, I.E no hostnames will be resolved, I only get the IP address. Removing the vendor row the reslover function starts working again.

[streaker69]

Here's the fix for this problem.

Apparently the SUBSTRING command which is supposed to work in MySQL apparently doesn't. But SUBSTR does.

Change the following line in poller_mactrack.php, clear your MacTrack data and let it start polling again. You'll see that the vendor_mac field in mactrack_ports gets populated correctly, which it wasn't before.

[janchan88]

I ran into the exact same problem but changing SUBSTRING to SUBSTR did not work for me, any idea?

Cacti Version - 0.8.7c
Plugin Architecture - 2.2
Poller Type - Cactid v
Server Info - Linux 2.6.9-89.0.15.plus.c4
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.82sp1
RRDTool - 1.2.23
SNMP - 5.1.2
Plugins

• Global Plugin Settings (settings - v0.5)
  Large Site Performane Booster (boost - v2.4)
  Device Monitoring (monitor - v0.8.2)
  Network Discovery (discovery - v0.9)
  Network Tools (tools - v0.3)
  Syslog Monitoring (syslog - v0.5.2)
  Device Tracking (mactrack - v2.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.96a)
  docs
  Cacti-ReportIt (reportit - v0.6.1)
  SSL Redirector (ssl - v0.1)
  Router Configs (routerconfigs - v0.1)
  wmi
  Realtime for Cacti (realtime - v0.35)

[janchan88]

Never mind, I figured it out. There was a bug in mactrack_resolver.php file. Just modify the file as below:

[TheWitness]

Fixed in SVN.