does authorize and revoke work

[scubabri]

It seems to work on date and time that it was authorized, but when the scan runs again, nothing is authorized on the most recent view, which makes it difficult to find new macs coming on the network.

sb

[scubabri]

so it appears that I have data in the mactrack_mac_auth table, but it appears that it's being ignored on queries.

any ideas?

[scubabri]

so it appears that subsequent runs of poller_mactrack.php do not check to see if the authorized flag is set, and it gets overwritten by the default of 0

can anyone confirm this is the problem?

[scubabri]

Grr, this is very frustrating, subsequent runs, and new data is inserted, so I have duplicates, one authorized and one not. Can anyone fix?

mysql> SELECT * FROM `mac_track_ports` WHERE `mac_address` LIKE CONVERT( _utf8 '00:19:BB:32:C8:E2' USING latin1 ) COLLATE latin1_swedish_ci LIMIT 0 , 30;
+---------+-----------+---------------------------+-------------+---------+-----------+-------------------+------------+-------------+--------------------------+-------------+-----------------+---------------------+------------+
| site_id | device_id | hostname | device_name | vlan_id | vlan_name | mac_address | vendor_mac | ip_address | dns_hostname | port_number | port_name | scan_date | authorized |
+---------+-----------+---------------------------+-------------+---------+-----------+-------------------+------------+-------------+--------------------------+-------------+-----------------+---------------------+------------+
| 1 | 3 | sb-cab1-sw1.xxxxxx | sb-cab1-sw1 | 10 | VLAN0010 | 00:19:BB:32:C8:E2 | NULL | 172.27.1.23 | sb-ofiler3.xxxxxx | Gi2/0/7 | sb-ofiler3-eth1 | 2008-09-26 00:46:14 | 1 |
| 1 | 3 | sb-cab1-sw1.xxxxxx | sb-cab1-sw1 | 10 | VLAN0010 | 00:19:BB:32:C8:E2 | NULL | 172.27.1.23 | sb-ofiler3.xxxxxx | Gi2/0/7 | sb-ofiler3-eth1 | 2008-09-26 00:56:55 | 0 |
+---------+-----------+---------------------------+-------------+---------+-----------+-------------------+------------+-------------+--------------------------+-------------+-----------------+---------------------+------------+
2 rows in set (0.00 sec)