Technical Tip: Filter names with '!' cannot be renamed or deleted

Description

This article describes an issue when search filter names with characters such as '!' are created but can never be renamed or deleted afterward.

Scope

FortiNAC v8.7.5.

Solution

Filters created with a '!' in the filter name cannot be deleted from the GUI. When attempting to remove, they appear to be removed until the page is refreshed.

When attempting to rename the filter, it appears to be changed but reverts when pthe age is refreshed.

1. Search for a 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