Technical Tips: How to delete an accidentally added GlobalOptionTool

Description

This article explains how to remove/delete an accidentally added globaloptiontool with a typo.

Scope

FortiNAC

Solution

1. Sometimes when typing the globaloptiontool a typo might occur, and this will ends up adding a new entry to FortiNAC Maria-db.

For example, instead of typing the following...

globaloptiontool -name security.allowedserialnumbers -setRaw "FNVX-CAxxxxxxx1,FNVX-CAxxxxxxx2" 

... The user entered this:

globaloptiontool -name secure.allowedserial -setRaw "FNVX-CAxxxxxxx1,FNVX-CAxxxxxxx2"

2. To remove this entry from FortiNAC database, run the command below to get the ID of the newly added option:

fortinac729:~$ globaloptiontool -all | grep -i 'secure.allowedserial'

149  secure.allowedserial: FNVX-
CAxxxxxxx1,FNVX-CAxxxxxxx2

Result: The ID of this entry is 149.

3. Exit the shell mode and enter the database via execute db-shell.

fortinac729:~$ exit
logout

fortinac729 # execute db-shell

4. After entering the database, run the following command to delete the entry:

"delete from GlobalOption where ID = 149;"

For example:

MariaDB [bsc]> delete from GlobalOption where ID = 149;
Query OK, 1 row affected (0.001 sec)

MariaDB [bsc]> exit
Bye

5. Verify again that the entry was removed: