Cacti / plugin_mactrack

Mactrack Plugin for Cacti
GNU General Public License v2.0
12 stars 25 forks source link

Dot1x search function does not work #141

Closed jdcoats closed 3 years ago

jdcoats commented 3 years ago

I've tried search for username, IP address and mac address in the dot1x search field, search does not produce results.

TheWitness commented 3 years ago

Awesome.

TheWitness commented 3 years ago

I just did an update Dan. Try again.

jdcoats commented 3 years ago

The search field still does not appear to work. The filters for Port Name, IP & Mac work but the "Search" still does not.

TheWitness commented 3 years ago

Oh, okay. What fields are you assuming it searches?

TheWitness commented 3 years ago

And would you prefer regular expressions of simple search?

jdcoats commented 3 years ago

I expected that maybe it should work like this: but mainly the username since other fields are already filterable. Maybe Just make a username filter? 👍 dot1x-search

jdcoats commented 3 years ago

okay, with recent commit, I thought it worked on my 1st search but then when confirming a few it does not and I see


020/10/25 17:09:14 - CMDPHP SQL Backtrace: (/plugins/mactrack/mactrack_view_dot1x.php[43]:mactrack_view_dot1x(), /plugins/mactrack/mactrack_view_dot1x.php[387]:db_fetch_cell(), /lib/database.php[386]:db_fetch_cell_prepared(), /lib/database.php[402]:db_execute_prepared())
--
2020/10/25 17:09:14 - CMDPHP ERROR: A DB Cell Failed!, Error: Unknown column 'mti.ifName' in 'where clause'
2020/10/25 17:08:49 - CMDPHP SQL Backtrace: (/plugins/mactrack/mactrack_view_dot1x.php[43]:mactrack_view_dot1x(), /plugins/mactrack/mactrack_view_dot1x.php[387]:db_fetch_cell(), /lib/database.php[386]:db_fetch_cell_prepared(), /lib/database.php[402]:db_execute_prepared())
2020/10/25 17:08:49 - CMDPHP ERROR: A DB Cell Failed!, Error: Unknown column 'mti.ifName' in 'where clause'
2020/10/25 17:08:26 - CMDPHP SQL Backtrace: (/plugins/mactrack/mactrack_view_dot1x.php[43]:mactrack_view_dot1x(), /plugins/mactrack/mactrack_view_dot1x.php[387]:db_fetch_cell(), /lib/database.php[386]:db_fetch_cell_prepared(), /lib/database.php[402]:db_execute_prepared())
2020/10/25 17:08:26 - CMDPHP ERROR: A DB Cell Failed!, Error: Unknown column 'mti.ifName' in 'where clause'
TheWitness commented 3 years ago

Try again.

jdcoats commented 3 years ago

okay progress, mac ip and port are searchable but username is not so you can find mac, ip or port with either the search or the filter options but username cannot be searched, so it needs either a filter or just to work in search.

TheWitness commented 3 years ago

Give it one more shot.

jdcoats commented 3 years ago

works as expected :) Thanks!