How to unlock and write Captive Portal Database ?
Hi All! How to unlock and update database columns in captive portal databases ?
You mean this file /var/db/captiveportalxxxxxxxx.db ?
This is SQLite3 file - it says so itself :
As pfSense, you need this to interact with it.
Good news ; pfSense has the sqlite3 PHP extension loaded.
Friendly warning : the simple fact you had to this (IMHO : simple to find out yourself) means that you should not 'mess' with it.
Removing a 'record' in that database is can be done with these button button :
The other info stored in it (per record) is :
Changing these values isn't useful, the underlying captive portal "ipfw" firewall rule won't get changed.