SOLVED Locked out of GUI because of bad SSL Certificate

[Sean Hasson]

Hi

Was locked out of the GUI - using FreeNas v11.1-Stable. Imported the CA Auth to the browser and inadvertently selected https only.

IF you have enabled SSH already - you can do the following.
ssh on to the box - in my case i had root enabled..

In my case I had the Redirect to HTTPs From HTTP setting checked:

1.Have a look at the System Settings in SQL Lite

Code:

sqlite3 /data/freenas-v1.db "PRAGMA table_info(system_settings)"

From Here Take note of the following fields - protocol and httpsredirect:.

2.

Code:

sqlite3 /data/freenas-v1.db "select * from system_settings"

3. Run the following to reset the settings.

Code:

sqlite3 /data/freenas-v1.db "update system_settings set stg_guihttpsredirect = 0, stg_guiprotocol='http';"

Now you should be able to hit the gui HTTP and go to general and SAVE again to commit settings

Mod note:
Moved here from the Corral section.
- Ericloewe