New errors after sync of latest PR's

[jdcoats]

@xxconn from my logs it looks like it started after grabbing the commits from the 19th. I am current today also though.

2026/01/22 09:22:45 - CMDPHP MAILER ERROR Backtrace: (/plugins/mactrack/poller_mactrack.php[278]:collect_mactrack_data(), /plugins/mactrack/poller_mactrack.php[980]:mactrack_process_mac_auth_report(), /plugins/mactrack/poller_mactrack.php[1063]:mactrack_mail(), /plugins/mactrack/lib/mactrack_functions.php[3316]:mailer(), /lib/functions.php[4984]:cacti_debug_backtrace())
2026/01/22 09:13:04 - CMDPHP PHP ERROR WARNING Backtrace: (/plugins/mactrack/mactrack_scanner.php[175]:get_IOS_dot1dTpFdbEntry_ports(), /plugins/mactrack/lib/mactrack_cisco.php[288]:build_InterfacesTable(), /plugins/mactrack/lib/mactrack_functions.php[751]:CactiErrorHandler())
2026/01/22 09:13:04 - ERROR PHP WARNING in Plugin 'mactrack': Undefined array key 2 in file: /var/www/localhost/htdocs/cacti/plugins/mactrack/lib/mactrack_functions.php on line: 751

[xxconn]

@jdcoats

About MAILER ERROR issue, would you see whether there are another general logs that mail sender or recipient weren’t configured. If you wouldn’t like to send email report, please disable it, or configure the necessary parameters.

Another PHP WARNING, I also meet the same frequently, because there are some network issues (like network down suddenly or high bandwidth usage) or target device high cpu performance. I will fix this soon.

[jdcoats]

You mean these?
2026/01/23 04:39:00 - SYSTEM WARNING: Primary Admin account notifications disabled! Unable to send administrative Email.
I have now configured the report email.

[jdcoats]

Also notice that I cannot authorize macs. No matter if i select 1 or 1000 it never authorizes them and does not give an error or debug message

[xxconn]

Could you post the screenshot of the ‘View MACs’ tab?

[jdcoats]

i cant get anything to show anymore after subsequent runs, I think i have to roll back.

[jdcoats]

queries got very slow hung up cacti and dont provide data

[jdcoats]

finally got a page to load

[xxconn]

What version of Mactrack are you using?
I'm using Version 4.8 and my pull request is under the 4.8
I tried to show the most IP address's site (197 IPs), it need 3.857 sec

MariaDB [cacti]> SELECT site_name, device_id, device_name, hostname, mtp.mac_address, vendor_name, ip_address, dns_hostname, port_number, port_name, vlan_id, vlan_name, MAX( scan_date) AS scan_date, mtm.mac_id FROM mac_track_ports AS mtp LEFT JOIN mac_track_sites AS mts ON mtp.site_id = mts.site_id LEFT JOIN mac_track_macauth AS mtm ON mtm.mac_a ddress = mtp.mac_address LEFT JOIN mac_track_oui_database AS mtod ON mtod.vendor_mac = mtp.vendor_mac WHERE mtp.site_id = 202 GROUP BY device_id, mtp.mac_address, port_numbe r, ip_address ORDER BY site_name ASC LIMIT 0,100;
100 rows in set (3.857 sec)

[jdcoats]

your PR's are all going into develop which is 4.9

site with 190 IP's = 100 rows in set (16.976 sec)
site with 478 IP's = 100 rows in set (31.164 sec)
site with 16,343 IP's = 100 rows in set (2 min 25.433 sec)

[xxconn]

Could you tell me which version you rolled back? I just want to check what different about the SQL query statements with 4.9.

[jdcoats]

i didn't roll anything back, I'm still running current Develop 4.9

[jdcoats]

maybe my 8month data retention is to much?

MariaDB [(none)]> SELECT
    TABLE_NAME AS `Table`,
    ROUND(((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024), 2) AS `Size (MB)`
FROM
    information_schema.TABLES
WHERE
    TABLE_SCHEMA = 'cacti'
AND
    TABLE_NAME = 'mac_track_ips';
+---------------+-----------+
| Table         | Size (MB) |
+---------------+-----------+
| mac_track_ips |  13515.91 |
+---------------+-----------+
1 row in set (0.000 sec)

MariaDB [(none)]> SELECT
    TABLE_NAME AS `Table`,
    ROUND(((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024), 2) AS `Size (MB)`
FROM
    information_schema.TABLES
WHERE
    TABLE_SCHEMA = 'cacti'
AND
    TABLE_NAME = 'mac_track_ports';
+-----------------+-----------+
| Table           | Size (MB) |
+-----------------+-----------+
| mac_track_ports |  16072.81 |
+-----------------+-----------+
1 row in set (0.000 sec)

[TheWitness]

SHOW CREATE TABLE mac_track_ports;
SHOW CREATE TABLE mac_track_ips;

They should be partitioned to ensure they can be dropped as they age out over having to delete and then constantly have to optimize those tables over time.

@xxconn, something to put on the list.

[TheWitness]

Then, apply a time range on the IP query to read from only a single or maybe just two partitions.

[jdcoats]

| mac_track_ports | CREATE TABLE `mac_track_ports` (
  `site_id` int(10) unsigned NOT NULL DEFAULT 0,
  `device_id` int(10) unsigned NOT NULL DEFAULT 0,
  `hostname` varchar(40) NOT NULL DEFAULT '',
  `device_name` varchar(100) NOT NULL DEFAULT '',
  `vlan_id` varchar(5) NOT NULL DEFAULT 'N/A',
  `vlan_name` varchar(50) NOT NULL DEFAULT '',
  `mac_address` varchar(20) NOT NULL DEFAULT '',
  `vendor_mac` varchar(8) DEFAULT '',
  `ip_address` varchar(20) NOT NULL DEFAULT '',
  `dns_hostname` varchar(200) DEFAULT '',
  `port_number` varchar(30) NOT NULL DEFAULT '',
  `port_name` varchar(50) NOT NULL DEFAULT '',
  `scan_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `authorized` tinyint(3) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`port_number`,`scan_date`,`mac_address`,`device_id`),
  KEY `site_id` (`site_id`),
  KEY `scan_date` (`scan_date`) USING BTREE,
  KEY `description` (`device_name`),
  KEY `mac` (`mac_address`),
  KEY `hostname` (`hostname`),
  KEY `vlan_name` (`vlan_name`),
  KEY `vlan_id` (`vlan_id`),
  KEY `device_id` (`device_id`),
  KEY `ip_address` (`ip_address`),
  KEY `port_name` (`port_name`),
  KEY `dns_hostname` (`dns_hostname`),
  KEY `vendor_mac` (`vendor_mac`),
  KEY `authorized` (`authorized`),
  KEY `site_id_device_id` (`site_id`,`device_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='Database for Tracking Device MACs' |

| mac_track_ips | CREATE TABLE `mac_track_ips` (
  `site_id` int(10) unsigned NOT NULL DEFAULT 0,
  `device_id` int(10) unsigned NOT NULL DEFAULT 0,
  `hostname` varchar(40) NOT NULL DEFAULT '',
  `device_name` varchar(100) NOT NULL DEFAULT '',
  `port_number` varchar(30) NOT NULL DEFAULT '',
  `mac_address` varchar(20) NOT NULL DEFAULT '',
  `ip_address` varchar(20) NOT NULL DEFAULT '',
  `dns_hostname` varchar(200) DEFAULT '',
  `scan_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`scan_date`,`ip_address`,`mac_address`,`site_id`),
  KEY `ip` (`ip_address`),
  KEY `port_number` (`port_number`),
  KEY `mac` (`mac_address`),
  KEY `device_id` (`device_id`),
  KEY `site_id` (`site_id`),
  KEY `hostname` (`hostname`),
  KEY `scan_date` (`scan_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC |