Ad blocker detected: Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker on our website.
tadavis wrote:I've attached a diff file, that can be applied by doing 'patch -p0 < mactrack.diff' in the mactrack plugin directory.
This is what I had to modify to get IP reports to work.
Have you just tried to add the ips_current_date column to your mac_track_ip_ranges table?
After I did that I did not need to edit any of the scripts...
Ah, now I understand more..
After looking at the generated report, I'll sad to say my changes breaks it differently. The ips_current_date column is missing, and it's supposed to be there.
Ok, the problem is the missing ips_current_date from the sql database; you can do the mysql in the previous, or just download this attached database_upgrade.php and run which will fix the database for you.
You can ignore everything I've posted before this..
what issues are you having? Do you have DNS resolution turned on in the console? Do you have valid DNS server in your configuration in the console? Can the box that is running MacTrack use those DNS servers to resolve the names you are having problems with? Let me know, and I will try to help.
chadd wrote:what issues are you having? Do you have DNS resolution turned on in the console? Do you have valid DNS server in your configuration in the console? Can the box that is running MacTrack use those DNS servers to resolve the names you are having problems with? Let me know, and I will try to help.
-chadd.
The issue is that it isn't resolving hostnames. Yes to everything else.
DNS Configuration Information
Reverse DNS Resolution is ENABLED
Primary DNS Server: *.*.22.24
Secondary DNS Server: *.*.23.26
DNS Resoution Timeout: 1000 milliseconds
I had some problems after I made the changes, so I did the 'Remove All Scan Results' and that seemed to clear things up. I don't know why, but it did. Just Refresh 'Scanning Functions', or doing a 'Perform Database Maintenance' did not do the trick. I also started getting errors from the MacTrack poller that I was exceeding the timeout limit for DNS resolution as well, so I upped it to 2000ms and the errors stopped for now.. My box is pretty loaded down through, and most of my 190 + devices are remote on slow frame links - so, it could be one of those things too. I also changed the 'DNS Prime Interval' to 200 sec, as my MacTrack polls are taking nearly 5min to complete. I am not sure about the 'DNS Prime Interval' setting, but I think that if it is greater than the length of your poll cycle, you could have problems... (but I am talking out of my #&$$ on that one..).. Hope something here helps, but the first thing I would do is 'Remove All Scan Results'. Also, have you ran poller_mactrack from the command line in debug mode? Maybe that could give some insight..
chadd wrote:Also, have you ran poller_mactrack from the command line in debug mode? Maybe that could give some insight..
It just runs through the MIBs and exits. <shrug>?
I do see this in the logs, and it looks borked:
04/07/2006 01:52:05 PM - SYSTEM STATS: Time:122.0911 Method:cmd.php Processes:8 Threads:N/A Hosts:58 HostsPerProcess:8 DataSources:4617 RRDsProcessed:2372
I'll play around some more with the settings and clean the data, etc..
tadavis wrote:That is correct, the plugin database_upgrade script is missing the ips_current_date field.
Actually, so is the native version. The plugin version of the upgrade script is the exact same as the native version, its just in a different location. Actually it is missing from both mactrack.sql files also.
As far as why DNS is not working, add ethereal to the box and review the packet capture data after a poll and see if the DNS calls are successful. If so, then it's in the database. Please let me know.
TheWitness
True understanding begins only when we realize how little we truly understand...
Problem: mactrack would retrieve VLAN and port information on my Cisco switches but would not retrieve any MAC addresses.
Solution: The mactrack_functions.php script checks dot1dTpFdbStatus (.1.3.6.1.2.1.17.4.3.1.3) and if it equals '3' continues on. This will only retrieve dynamic entries in the CAM table. I had to add a check for '5' also to retrieve static entries in the table. This is necessary if you are using features such as Cisco's port security which stores learned entries as static.
