Hi all,
I'm trying to analyze an issue (not sure if it is the device or the opnsense, expect the device to be the problem) and not i'm struggeling a little bit to "read" the session IDs of my Captive Portal.
In the Logfile I can find entries like:
captiveportal: session Myj4rkqH[removed by author]9S11w== hit idletimeout
captiveportal: remove concurrent session lTALy[removed by author]3Zv7+ug==
captiveportal: session G0K+5K[removed by author]RQ== hit idletimeout
but how can I translate / lookup those cryptic session IDs?
Thx and KR
Itchy2
everything related to the captive portal is stored in a SQLite DB.
ok. Sounds interesting. Do you know where the file is located? So I can check out if it helps to understand the session ids. But shouldn't it be visible somewhere in the logfiles / frontend also?
Thx and KR
Itchy2
The SQLite database is located here (https://github.com/opnsense/core/blob/master/src/opnsense/scripts/OPNsense/CaptivePortal/process_accounting_messages.php):
$database_filename = '/var/captiveportal/captiveportal.sqlite';
You can also make the SessionId visible in Services > Captive Portal > Sessions
Then click the column drop-down list -right to the search field- to enable Session. The list will now show the SessionId information in the Web GUI.
Thanks a lot. Thats very helpful. I was a little bit disappointed by checking the database. Only current valid information are stored. Nothing historic.
Thx and KR
Itchy2