Messages

Hello OPNsense Team,

Every day, we are receiving crash reports due to PHP errors in the Captive Portal. Please find the logs and attached files below, and let us know if you can help us resolve this issue.

 PHP Errors:

[21-Dec-2025 23:39:26 Asia/Jerusalem] TypeError: Cannot assign null to property OPNsense\CaptivePortal\Api\AccessController::$arp of type array in /usr/local/opnsense/mvc/app/controllers/OPNsense/CaptivePortal/Api/AccessController.php:105
Stack trace:
#0 /usr/local/opnsense/mvc/app/controllers/OPNsense/CaptivePortal/Api/AccessController.php(254): OPNsense\CaptivePortal\Api\AccessController->getClientMac('10.5.90.224')
#1 /usr/local/opnsense/mvc/app/library/OPNsense/Mvc/Dispatcher.php(166): OPNsense\CaptivePortal\Api\AccessController->logonAction()
#2 /usr/local/opnsense/mvc/app/library/OPNsense/Mvc/Router.php(156): OPNsense\Mvc\Dispatcher->dispatch(Object(OPNsense\Mvc\Request), Object(OPNsense\Mvc\Response), Object(OPNsense\Mvc\Session))
#3 /usr/local/opnsense/mvc/app/library/OPNsense/Mvc/Router.php(139): OPNsense\Mvc\Router->performRequest(Object(OPNsense\Mvc\Dispatcher))
#4 /usr/local/opnsense/www/api.php(36): OPNsense\Mvc\Router->routeRequest('/api/captivepor...', Array)
#5 {main}

Thank you and Best Regards,
Saleh

Thank you so much Seimus and Franco for your support and assistance.
I hope the issue will be fixed in the upcoming release.

Best regards,
Saleh

Dear OPNsense Team,

After extensive testing on three different OPNsense hardware appliances, we identified an issue affecting upload traffic in the firewall rule traffic shaping (rule-direction).

When creating an upload pipe with a bandwidth of 5 Mbps and attaching this pipe to a firewall rule under traffic shaping (rule-direction), the internet connection does not function correctly. Some websites fail to open or display errors, requiring multiple refresh attempts. Browsing becomes very slow, and upload speed tests return errors.

Through further testing, we discovered that the issue is related to the bandwidth value configured in the upload pipe. When we set a higher value, such as 25 Mbps instead of 5 Mbps, everything works properly. Despite setting 25 Mbps, the actual upload bandwidth we measure is 5 Mbps. In other words, to achieve a real upload bandwidth of 5 Mbps, we must configure the pipe with approximately 5 × 5 Mbps.

Note: This behavior was observed on OPNsense 25.7.8 and the newly released OPNsense 25.7.9. Please find the attached images.

Thank you.

[Seimus]

Thank you so much for your quick reply, Seimus.

For Queue-any-any-UP or Queue-any-any-DOWN, do we need to configure the interface, source, destination, and direction as well, or is it enough to simply create them and attach them to their respective pipes?

Best regards,
Saleh

[@_shorty]

@_shorty Have you gotten traffic shaper in the firewall rule working? If yes, please share with us a screenshot of the pipe and firewall rule settings.
Thank you.

Hello,
I have change the repository file above as you said but after check the updates again Not update to 2.0
OPNsense 25.1.8_1
Zenarmor 1.18.6
Your packages up to date
How to fix?
Thank you

Thank you so much Franco,
We are using ZFS not UFS. We know isn't much to do once it's been corrupted but the problem we want to know what is the reason for that.
I mean the corrupted captiveportal.sqlite.
This issue does not occur immediately in the reboot or after a reboot, but it starts happening while the OPNsense router is up, running and working normal. It occurs multiple times a day.
Best Regards,
Saleh

[Services: Captive Portal: Log File]

Hello Franco,

Could you please help us to fix this issue. This issue occurs multiple times a day. When it happens  current users Sessions in the captive portal not appears and users can connect the internet without the hotspot authentication.

Services: Captive Portal: Log File

2025-05-15T08:34:11   Error   captiveportal   sqlite3 repair /var/captiveportal/captiveportal.sqlite   
2025-05-15T08:34:11   Error   captiveportal   Forcefully repair database (Traceback (most recent call last): File "/usr/local/opnsense/scripts/OPNsense/CaptivePortal/cp-background-process.py", line 251, in main bgprocess.db.cleanup_sessions() File "/usr/local/opnsense/scripts/OPNsense/CaptivePortal/lib/db.py", line 360, in cleanup_sessions cur.execute(""" delete sqlite3.OperationalError: no such table: accounting_state )   
2025-05-15T08:33:11   Error   captiveportal   sqlite3 repair /var/captiveportal/captiveportal.sqlite [done]   
2025-05-15T08:32:40   Error   captiveportal   sqlite3 repair /var/captiveportal/captiveportal.sqlite   
2025-05-15T08:32:40   Error   captiveportal   Forcefully repair database (Traceback (most recent call last): File "/usr/local/opnsense/scripts/OPNsense/CaptivePortal/cp-background-process.py", line 251, in main bgprocess.db.cleanup_sessions() File "/usr/local/opnsense/scripts/OPNsense/CaptivePortal/lib/db.py", line 360, in cleanup_sessions cur.execute(""" delete sqlite3.OperationalError: no such table: accounting_state )   

Thank you.

Hello,
We are getting every day many log errors in the captive portal service regarding captiveportal.sqlite, what is the reson that the captiveportal.sqlite file is corrupted. please see the below logs and images.

025-05-14T13:44:39    Error    captiveportal    sqlite3 repair /var/captiveportal/captiveportal.sqlite   
2025-05-14T13:44:39    Error    captiveportal    Forcefully repair database (Traceback (most recent call last): File "/usr/local/opnsense/scripts/OPNsense/CaptivePortal/cp-background-process.py", line 251, in main bgprocess.db.cleanup_sessions() File "/usr/local/opnsense/scripts/OPNsense/CaptivePortal/lib/db.py", line 360, in cleanup_sessions cur.execute(""" delete sqlite3.OperationalError: no such table: accounting_state )

Thank you

[Services: Captive Portal: Log File]

Note: Another thing there are no logs in the
Services: Captive Portal: Log File

[Services: Captive Portal: Sessions]

After updating to the latest version 25.1.5_5, we are experiencing empty sessions in the Captive Portal Sessions. This issue does not occur immediately after a reboot, but it starts happening while the OPNsense router is running. It occurs multiple times a day. The sessions only reappear after we stop the captive portal, delete the captiveportal.sqlite file, and then restart the captive portal.

We are only facing this issue after updating OPNsense to version 25.1. Why is the captiveportal.sqlite file getting corrupted?

Services: Captive Portal: Sessions

Thank you

[OPNsense 25.1.5]

Today I upgrade OPNsense 25.1.5 to the latest hotfix release 25.1.5_4 after that the Captive Portal user authentication not working and give the message "authentication failed" although the username and password is correct. Removing the captive portal and recreating it didn't solve the issue.
Note: Allowed addresses is working but the Captive Portal user authentication not working although the username and password is correct and tested with System: Access: Tester.

Thank you.

Is there any example for JSON body for addRule?
Thank you

Hello,

We need to update captive portal accounting every 600 seconds. In the current setting the update made every 6 seconds. We think to use the Acct-Interim-Interval attribute so that we have changed the test user profile like the below:

test Cleartext-Password := "testing123", Simultaneous-Use := "1"
        Acct-Interim-Interval := 600,
        Framed-Protocol = PPP

But after testing we found the Acct-Interim-Interval attribute have no effect (Not working) and the accounting update made every 6 seconds like the below example:

Sat Aug 24 20:57:55 2024
        NAS-Identifier = "66c122ef7fec9"
        Service-Type = Framed-User
        Framed-Protocol = 15
        NAS-Port = 0
        NAS-Port-Type = Ethernet
        User-Name = "test"
        Acct-Status-Type = Interim-Update
        Acct-Session-Id = "mf2CWztLHGcqmOs11VvR+A=="
        Acct-Authentic = Local
        Acct-Session-Time = 683
        Acct-Input-Octets = 5252767
        Acct-Output-Octets = 6038308
        Framed-IP-Address = 192.168.1.201
        NAS-IP-Address = 127.0.0.1
        Event-Timestamp = "Aug 24 2024 20:57:55 EEST"
        Acct-Unique-Session-Id = "912d036be955f3df393c422e346ffa99"
        Timestamp = 1724522275

Sat Aug 24 20:58:01 2024
        NAS-Identifier = "66c122ef7fec9"
        Service-Type = Framed-User
        Framed-Protocol = 15
        NAS-Port = 0
        NAS-Port-Type = Ethernet
        User-Name = "test"
        Acct-Status-Type = Interim-Update
        Acct-Session-Id = "mf2CWztLHGcqmOs11VvR+A=="
        Acct-Authentic = Local
        Acct-Session-Time = 689
        Acct-Input-Octets = 5253158
        Acct-Output-Octets = 6038468
        Framed-IP-Address = 192.168.1.201
        NAS-IP-Address = 127.0.0.1
        Event-Timestamp = "Aug 24 2024 20:58:01 EEST"
        Acct-Unique-Session-Id = "912d036be955f3df393c422e346ffa99"
        Timestamp = 1724522281

Any idea how to fix this issue.
Thank you

We are using static route without BGP on IPSEC route based but we are sure that after upgrade to latest version  23.1.7_3 the static routing not working. I think there is a problem on the manual  created VPN Gateway.

System: Gateways: Single