Mactrack -> IP Ranges (only for first Site in list)

Support questions about the MAC Track plugin

Moderators: Developers, Moderators

magicone
Posts: 12
Joined: Wed Jun 13, 2012 11:41 am

Mactrack -> IP Ranges (only for first Site in list)

Post by magicone »

I have 5 sites defined, all are pulling data from the switches (both MAC and IP info)

My problem, under "Mactrack -> IP Ranges", I am seeing only the first site under Any.

Even when I select the Site name I still do not get any other information about the IPs at the other sites.

If I go to the "Mactrack -> IP Address" tab and select one of the other sites I do get details on IPs seen at that site.

It is as if the "IP Ranges" tab will not accept any other sites in the list except the first one.

The site names do contain spaces, not sure if that matters. There are no errors in the logs other than a SNMPAGENT Warning for event receivers.

Any help would be appreciated. Thank you in advance.

CentOS 7
Cacti Version 1.2.25
MariaDB 10.3.39
PHP Version 7.1.33
SPINE 1.2.25

Plugins:
Monitor 2.6
Mactrack 4.5
Routerconfigs 1.6
Thold 1.7
Weathermap 1.0
Webseer 1.1

Switches:
Cisco Nexus 9K
Cisco 9300
Cisco 3850
Cisco 2960
User avatar
Osiris
Cacti Guru User
Posts: 1424
Joined: Mon Jan 05, 2015 10:10 am

Re: Mactrack -> IP Ranges (only for first Site in list)

Post by Osiris »

You have to type a pattern. By default it will be empty by design.
Before history, there was a paradise, now dust.
User avatar
Osiris
Cacti Guru User
Posts: 1424
Joined: Mon Jan 05, 2015 10:10 am

Re: Mactrack -> IP Ranges (only for first Site in list)

Post by Osiris »

If you have not defined any devices with and arp table, you won't get them.
Before history, there was a paradise, now dust.
magicone
Posts: 12
Joined: Wed Jun 13, 2012 11:41 am

Re: Mactrack -> IP Ranges (only for first Site in list)

Post by magicone »

First off, thank you for responding, I was thinking no one used Mactrack any longer.

I've attached some screenshots. I have not problem getting the switch data as you can see.

Each router which would have Interfaces and arp data are showing IPs. MACs show up fine but when I go to the "IP Ranges" tab the only thing that shows up is the first "site" defined. If I select another site there is no data present, no IP ranges displayed.

I think its a mysql table issue or the fact that my site names have spaces between them (like full names of a building) but I'm not sure.

Ever have this issue in the past? Would really like it to work just by clicking on the links. Right now I can only use it for MAC address searches. Which has been great for finding Access Points in the switches and such.

Thank you in advance!
Attachments
sites.png
sites.png (79.25 KiB) Viewed 3463 times
only.first.site.shows.up.png
only.first.site.shows.up.png (86.29 KiB) Viewed 3463 times
ip.ranges.png
ip.ranges.png (29.75 KiB) Viewed 3463 times
devices.png
devices.png (582.25 KiB) Viewed 3463 times
User avatar
Osiris
Cacti Guru User
Posts: 1424
Joined: Mon Jan 05, 2015 10:10 am

Re: Mactrack -> IP Ranges (only for first Site in list)

Post by Osiris »

So, do you have any L3 devices or routers in those sites you are capturing Mac to Ip associations?

Yea, people are using it. TheWitness, unfortunately for MacTrack, moved to the HPC space, but he still invests time in trying to keep it relevant. He still uses it on his home network.
Before history, there was a paradise, now dust.
magicone
Posts: 12
Joined: Wed Jun 13, 2012 11:41 am

Re: Mactrack -> IP Ranges (only for first Site in list)

Post by magicone »

I was reading that he moved to big blue :) HPC is cool though

I used to run Mactrack in an old 0.8 version of Cacti and it worked fine with the same settings for the router device types. Screenshots below. The red marker indicates the routers and the IPs it sees. I included the screenshot of the "IP Addresses" and that it only shows the first site in the site list. If I select anything else it doesn't display the IPs. If I go into the MAC address search I can see the MACs and associated IPs for the various sites so I know the bulk data is there.

The bugger of it all is there are no errors that I can see in the cacti logs.... If you have any idea where I can look for errors or DB tables I'd be happy to pull that data for you.

I'm a total end user when it comes to code. Over 25 years in the networking field but coding has never been my strong suit.

Thanks again for your help!
Attachments
The is one "site" that shows up but the others dont
The is one "site" that shows up but the others dont
first.site.ips.png (229.36 KiB) Viewed 3440 times
my router definitions - these worked in older versions of MACTRACK so I used the same settings
my router definitions - these worked in older versions of MACTRACK so I used the same settings
router.types.png (42.96 KiB) Viewed 3440 times
Routers identified by RED marker
Routers identified by RED marker
Routers.png (403.3 KiB) Viewed 3440 times
User avatar
Osiris
Cacti Guru User
Posts: 1424
Joined: Mon Jan 05, 2015 10:10 am

Re: Mactrack -> IP Ranges (only for first Site in list)

Post by Osiris »

How are your database skills?
Before history, there was a paradise, now dust.
magicone
Posts: 12
Joined: Wed Jun 13, 2012 11:41 am

Re: Mactrack -> IP Ranges (only for first Site in list)

Post by magicone »

I can spell database :)

I google most commands - do you have an idea of where I can start looking?

ran a linux desktop for over 10 years so familiar with CLI in general
User avatar
TheWitness
Developer
Posts: 17047
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:

Re: Mactrack -> IP Ranges (only for first Site in list)

Post by TheWitness »

Try this:

Code: Select all

mysql -A cacti
SELECT DISTINCT site_id FROM mac_track_ips;
SELECT site_id, COUNT(*) AS ips FROM mac_track_ips GROUP BY site_id;
quit;
That'll tell you how many site's are inserting IP address information into the database.
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages


For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
magicone
Posts: 12
Joined: Wed Jun 13, 2012 11:41 am

Re: Mactrack -> IP Ranges (only for first Site in list)

Post by magicone »

Thank you for the mysql query string. Below you can see all of the IP data is present and the 8 site ids also exist.

Even went out on a limb and looked in /var/lib/mysql/cacti/ and saw the mac_track_sites so tried site_name and it returned all 8 of the sites names also

As there are no errors in the logs what can I do to to figure out why the webui isn't showing the IPs and IP ranges?

Thank you again for the help.


[cactiadmin@cacti-2023 ~]$ mysql -A cacti -u cactiuser -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 893289
Server version: 10.3.39-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [cacti]> SELECT DISTINCT site_id FROM mac_track_ips;
+---------+
| site_id |
+---------+
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
+---------+
8 rows in set (0.001 sec)

MariaDB [cacti]> SELECT site_id, COUNT(*) AS ips FROM mac_track_ips GROUP BY site_id;
+---------+--------+
| site_id | ips |
+---------+--------+
| 1 | 93581 |
| 2 | 63259 |
| 3 | 61669 |
| 4 | 510834 |
| 5 | 67078 |
| 6 | 2976 |
| 7 | 74498 |
| 8 | 47073 |
+---------+--------+
8 rows in set (0.309 sec)
MariaDB [cacti]>

(removed names of sites except first character in the name)

MariaDB [cacti]> SELECT DISTINCT site_name FROM mac_track_sites;
+------------------------------------+
| site_name |
+------------------------------------+
| C---------------l |
| D--------------- |
| H------------------- |
| H------------------ |
| H--------------------- |
| N-------------------- |
| P---------------------------- |
| W------------------------- |
+------------------------------------+
8 rows in set (0.000 sec)

MariaDB [cacti]>
MariaDB [cacti]> quit;
User avatar
Osiris
Cacti Guru User
Posts: 1424
Joined: Mon Jan 05, 2015 10:10 am

Re: Mactrack -> IP Ranges (only for first Site in list)

Post by Osiris »

Well, that's encouraging.
Before history, there was a paradise, now dust.
User avatar
Osiris
Cacti Guru User
Posts: 1424
Joined: Mon Jan 05, 2015 10:10 am

Re: Mactrack -> IP Ranges (only for first Site in list)

Post by Osiris »

I suspect this is some issue in the GUI. Database looks good.
Before history, there was a paradise, now dust.
magicone
Posts: 12
Joined: Wed Jun 13, 2012 11:41 am

Re: Mactrack -> IP Ranges (only for first Site in list)

Post by magicone »

Not for me, ha! :lol: I know the data is there but the tabs don't show anything and there is nothing in the logs to point me to a problem.....

I don't see any debugging options to enable.

Should I run any of the utils? maybe purge the data and see if a fresh collection fixes it? or refresh scanning functions?

What else can I try.

Thanks again for the help.
Attachments
utils.png
utils.png (47.99 KiB) Viewed 3377 times
User avatar
Osiris
Cacti Guru User
Posts: 1424
Joined: Mon Jan 05, 2015 10:10 am

Re: Mactrack -> IP Ranges (only for first Site in list)

Post by Osiris »

I have to review the code, but it's time to sleep...
Before history, there was a paradise, now dust.
magicone
Posts: 12
Joined: Wed Jun 13, 2012 11:41 am

Re: Mactrack -> IP Ranges (only for first Site in list)

Post by magicone »

Thank you, understood - I'm running on 4hrs myself.... time to sleep :)
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest