Captive Portal: Sessions - how to read session id in Logfiles

[itchy2]

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

[fabian]

everything related to the captive portal is stored in a SQLite DB.

[itchy2]

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

[fvanroie]

The SQLite database is located here:

Code Select Expand

$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.

[itchy2]

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