[SOLVED] Captive Portal Sessions Missing

[tong2x]

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

[tong2x]

solution
delete corrupt captive portal file



STOP captive portal service
* goto shell (press *
cd /
cd var
cd captiveportal
rm captiveportal.sqlite
exit
START captive portal service

[amitis5]

Thanks man.  Saved my @$$ today.

[tong2x]

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.