Captive Portal Session List is empty

[tong2x]

Versions
OPNsense 25.7.7_4-amd64
FreeBSD 14.3-RELEASE-p4
OpenSSL 3.0.18

Services: Captive Portal: Sessions
is empty even if there are clients authenticating

[tong2x]

it populated after 2-3hours but the sessions does not hit the hard timedout and users are still logged in see list there are are more than 1 day users

[tong2x]

Code Select Expand

2025-11-17T20:26:25Noticeconfigd.py[019408d8-00e1-45f1-a825-c76634ff1d17] request captiveportal status
2025-11-17T20:26:25Noticeconfigd.py[1a394928-72dd-41c0-8b17-278ebb49d7f7] restarting captiveportal services
2025-11-17T20:26:20Noticeconfigd.py[1172b32d-d17d-4a74-82fe-cad27e185d3b] IPsec list legacy VirtualTunnelInterfaces
2025-11-17T20:26:20Noticeconfigd.py[2ac73fa8-9cc0-4178-8e5f-914fa47dd580] Show disk usage
2025-11-17T20:26:20Noticeconfigd.py[dfa78dcc-b6d1-46ed-aa98-0cb878561592] request captiveportal status
2025-11-17T20:26:20Noticeconfigd.py[4e05d161-4fc3-4f82-a4ff-25e7e7416b84] system status
2025-11-17T20:26:18Errorconfigd.py[b5ac6d23-7056-4ae5-8d0f-06a32e75fafe] Script action failed with Command '/usr/local/opnsense/scripts/captiveportal/listClients.py -z ''' returned non-zero exit status 1. at Traceback (most recent call last): File "/usr/local/opnsense/service/modules/actions/script_output.py", line 89, in execute subprocess.run(script_command, env=self.config_environment, shell=True, File "/usr/local/lib/python3.11/subprocess.py", line 571, in run raise CalledProcessError(retcode, process.args, subprocess.CalledProcessError: Command '/usr/local/opnsense/scripts/captiveportal/listClients.py -z ''' returned non-zero exit status 1.
2025-11-17T20:26:18Noticeconfigd.py[c8ea
seem database keeps getting currupt and cant be repaired possible to add a button to repair and/or
stop captive portal delete the dabase and start captive portal again for a fressh database