Technical Tip: Clearing license entries in the database

When the license table has additional entries of a license, it is required to have only one license in the database.

This can occur when the database is externalized and the application server is cloned or restored from backup, as the uuid is changing.

Note:

Take a snapshot for revert in case of any issues before proceeding with the below:

1. Run the following command below on FortiSOAR SSH to enter the database:

# psql -U cyberpgsql -d das <----- Password is the device uuid = # csadm license --get-device-uuid.

2. List out all existing license files and verify them accordingly:

das=# select serial_no,hardware_key from envc

3. Run the command below to truncate the env file, clearing all license entries in the database:

truncate envc;

After that, proceed to access the GUI and deploy the correct license on the FortiSOAR.