OPNsense Forum

Archive => 19.7 Legacy Series => Topic started by: Wyrm on September 16, 2019, 10:41:40 am

Title: Captive portal - problems with sessions
Post by: Wyrm on September 16, 2019, 10:41:40 am
I have opnsense on Supermicro HW and it was working about 1 your ok.
About 2 weeks ago there started problem with captive portal. Users could not login and sessions was not visible and there was not possible to delete them.
That time there was version 19.1 and I upgraded to last versions.
I have also done clean of captive portal DB by command line
Now the problem is still there - in log are some users as AUTH some as DENY, but there is no session in GUI visible and it is not working well.
Is there some solution for this strange behavior ?

Thanks for answers
Title: Re: Captive portal - problems with sessions
Post by: Wyrm on September 16, 2019, 10:49:25 pm
I have looked at the log and it shows:
captiveportal: Traceback (most recent call last): File "/usr/local/opnsense/scripts/OPNsense/CaptivePortal/cp-background-process.py", line 213, in main bgprocess.db.update_accounting_info(bgprocess.ipfw.list_accounting_info()) File "/usr/local/opnsense/scripts/OPNsense/CaptivePortal/lib/db.py", line 283, in update_accounting_info for row in cur.fetchall(): sqlite3.DatabaseError: database disk image is malformed

Does anybody know how to solve this ?