Captive Portal seems to be broken following update to 23.1.2

[BondiBlueBalls]

Thanks, Franco!

I upgraded, rebooted immediately after (just in case), and everything works as expected.

I really appreciate all of the time you and the team put into this, and I hope you're sleeping well tonight. :)

Thanks again!

[Shild73]

Hello. Updated to 23.1.3, but still gives errors and doesn't work. Tell me what can be done?

Code Select Expand


2023-03-10T09:36:54 Error captiveportal sqlite3 repair /var/captiveportal/captiveportal.sqlite [done]
2023-03-10T09:36:53 Error captiveportal sqlite3 repair /var/captiveportal/captiveportal.sqlite
2023-03-10T09:36:53 Error captiveportal Forcefully repair database (Traceback (most recent call last): File "/usr/local/opnsense/scripts/OPNsense/CaptivePortal/cp-background-process.py", line 219, in main bgprocess.sync_zone(zoneid) File "/usr/local/opnsense/scripts/OPNsense/CaptivePortal/cp-background-process.py", line 115, in sync_zone concurrent_users = self.db.find_concurrent_user_sessions(zoneid) File "/usr/local/opnsense/scripts/OPNsense/CaptivePortal/lib/db.py", line 245, in find_concurrent_user_sessions cur.execute(""" select cc.sessionid sessionId sqlite3.OperationalError: no such column: )

[franco]

> Tell me what can be done?

Perhaps read the last two posts in this thread for recommendations. ;)


Cheers,
Franco

[Shild73]

I tried the methods described above, it did not help.

[Stig]

Thanks, Franco!

I upgraded, rebooted immediately after (just in case), and everything works as expected.

I really appreciate all of the time you and the team put into this, and I hope you're sleeping well tonight. :)

Thanks again!

Working here as well. Thanks for solving the problem!

[mty620]

Worked after reboot here too :)

Really appreciate how difficult it is to keep on top of so many moving parts.

[franco]

It also looks like FreeBSD ports will keep DQS option for the full year after we stated our case there.

Unfortunate, but it happens.


Cheers,
Franco