session of captive portal missing,
but I can see logs of user authenticating
and captive portal is working
captive portal is in no authentication (portal only mode)
no issue before
OPNsense 20.7.2-amd64
FreeBSD 12.1-RELEASE-p8-HBSD
OpenSSL 1.1.1g 21 Apr 2020
solution
delete corrupt captive portal file
STOP captive portal service
* goto shell (press 8) *
cd /
cd var
cd captiveportal
rm captiveportal.sqlite
exit
START captive portal service
Thanks man. Saved my @$$ today.
good!
maybe a button can be addedin captive portal to "reset"/"fix the database in the future
btw found this code in other pages I cant seem to find the source, but someone recommended this
mv /var/captiveportal/captiveportal.sqlite /var/captiveportal/captiveportalbad.sqlite
sqlite3 /var/captiveportal/captiveportalbad.sqlite ".recover" | sqlite3 /var/captiveportal/captiveportal.sqlite
supposed to fix the database, last option would be to delete the database since captive portal will automatically generate a new db.