Messages

Just to update this thread: the issue is now resolved.

After further testing, internet connectivity started working normally on the LAN without any changes to the OPNsense configuration. At this point, it looks like the problem was not related to the OPNsense setup wizard.

We suspect the issue was related to our lab environment, possibly VMware Workstation networking or another temporary issue in the lab setup.

Thank you to everyone who took the time to read and assist.

Hello everyone,

I have performed a fresh installation of OPNsense 26.1.
After installation, I followed the initial setup wizard and applied the configuration.
Before applying the wizard settings, LAN internet access was working.
After applying the wizard changes, LAN clients no longer have internet access.

Symptoms:
LAN clients cannot ping external IPs (e.g. 8.8.8.8, 8.8.4.4)
No internet access from LAN
Issue appears immediately after applying the setup wizard configuration

Thank you.

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