Description
Filters created with a "!" in the filter name cannot be deleted from the GUI. When attempting to remove, they appear do be removed until the page is refreshed.
When attempting to rename the filter, it appears to be changed, but reverts when page is refreshed.
Scope
Version: 8.7.5
Solution
Workaround: Remove Filter from the database via CLI. Contact Support for assistance.
Note: Procedure requires a shutdown of management processes.
Solution: This behavior is considered a Known Anomaly. A complete list of Known Anomalies is available in the Fortinet Document Library.
ID 0666660
Workaround: Remove Filter from the database via CLI:
1. Search for name with "!" in the database:
mysql bsc -e "select name from SharedClientFilter"
Example:
> mysql bsc -e "select name from SharedClientFilter"
+-------------------+
| name |
+-------------------+
| Corporate Managed |
| UPS |
| Security Camera |
| BYOD |
| Guest |
| IP Phone |
| Printer |
| Test123 |
| Copy_of_Test123 |
| !Linux |
+-------------------+
2. Backup database
cd /bsc/campusMgr/master_loader/mysql
ydb_dated_backup
3. Shutdown processes
shutdownNAC
4. Delete filter from database
mysql bsc
delete from SharedClientFilter where name = '<filter name>';
quit
Example:
> mysql bsc
mysql> delete from SharedClientFilter where name = '!linux';
Query OK, 1 row affected (0.00 sec)
mysql> quit
Bye
5. Verify filter has been deleted
mysql bsc -e "select name from SharedClientFilter"
Example:
> mysql bsc -e "select name from SharedClientFilter"
+-------------------+
| name |
+-------------------+
| Corporate Managed |
| UPS |
| Security Camera |
| BYOD |
| Guest |
| IP Phone |
| Printer |
| Test123 |
| Copy_of_Test123 |
+-------------------+
6. Startup processes
startupNAC