OPNsense 25.1.5_4 - Captive Portal user authentication not working

[flaax]

The solution to the authorization problem is solved here

https://github.com/opnsense/core/commit/413f49c3ef68c0269a7163410b01a19c7a2fa4b5#diff-a83c0e9291cd5f0655cbd690b0bfaaef4b91db4ca9e04a4f36520ec2777d29c9

works! thanks

Hotfix is now available.

ty!
Just to be sure, it doesn't need a full restart, right? Just the captiveportal restart by hotfix?

[franco]

Install via GUI is enough for 25.1.5_5.

If you install the patch via opnsense-patch you need to do:

# opnsense-patch https://github.com/opnsense/core/commit/413f49c3ef
# service configd restart

Don't use opnsense-patch twice or else you remove your patch again.  ;)


Cheers,
Franco

[tong2x]

database keeps crashing and curropted, I have deleted 3 times already.
any help?

2025-04-15T08:25:22    Informational    captiveportal    AUTH anonymous@10.10.2.114 (10.10.2.114) zone 0   
2025-04-15T08:25:12    Error    captiveportal    sqlite3 /var/captiveportal/captiveportal.sqlite doesn't look like a database, renamed to /var/captiveportal/captiveportal.sqlite.20250415082512.bck   
2025-04-15T08:25:07    Informational    captiveportal    AUTH anonymous@10.10.2.114 (10.10.2.114) zone 0   
2025-04-15T08:25:07    Error    captiveportal    Forcefully repair database (Traceback (most recent call last): File "/usr/local/opnsense/scripts/OPNsense/CaptivePortal/cp-background-process.py", line 259, in main bgprocess.sync_zone(zoneid) File "/usr/local/opnsense/scripts/OPNsense/CaptivePortal/cp-background-process.py", line 140, in sync_zone expected_clients = self.db.list_clients(zoneid) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/opnsense/scripts/OPNsense/CaptivePortal/lib/db.py", line 205, in list_clients cur.execute(""" select cc.zoneid sqlite3.OperationalError: database is locked )   
2025-04-15T08:24:52    Informational    captiveportal    AUTH anonymous@10.10.2.114 (10.10.2.114) zone 0

[c-oolt]

There is still an error when CaptivePortal is running.

In version 25.1.1 I configured CP. I configured ACME + Certificate. Everything works without a problem.

After a direct update from 25.1.1 to 25.1.5_5 CP does not work.

Devices connect to WIFI but without internet.

Devices obtain correct IP address along with DNS PiHole.

Despite this, the connection is without internet. The CP login page does not pop up.

When I go back to version 25.1.1 CP + ACME + Certificate works correctly. I can log in.

I even deleted the CP database but the devices still connect to WIFI but without internet.

[white_rabbit]

... we have the same issue here with OPNsense 25.1.5_5-amd64

[white_rabbit]

Hi.
We installed the patch 09324af (https://github.com/opnsense/core/commit/09324af15d14d58c0937d74d26d451db673c3468) to fix the problem.
Now there ist the option under "Captive Portal -> Settings"

Code Select Expand

[x] Disable firewall rules

If this option is set, no automatic firewall rules for portal redirection
and traffic blocking will be generated. This option allows you to override
the default portal behavior for advanced use cases, such as redirections
for DNS.
See the documentation to see which rules you should implement in this scenario.

But it still does not work: If activated everyone is online and the captive portal does not appear
If not activated: Not online

So: What else to do in this case?
Thanks.