Archive > 20.7 Legacy Series

[SOLVED] Captive Portal Sessions Missing

(1/1)

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 8) *
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.

Navigation

[0] Message Index