How do I see if the user has disconnected?

[Mark Antony]

I have made further progress and believe this could be a solution.
But it seems I have a syntax issue:

accounting {
        switch "%{Acct-Status-Type}" {
            case 'Stop' {
                query = "SELECT TRUE;"
            }
        }

Error:

/etc/freeradius/3.0/sites-enabled/default[650]: Unknown action 'SELECT TRUE;'.

Thanks,
Mark




Sent with ProtonMail Secure Email.

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Saturday, 15 May 2021 08:01, Mark Antony via Freeradius-Users <freeradius-users at lists.freeradius.org> wrote:

> I would like to run an sql update statement, every time the user disconnects a session.
>
> Correct me if I'm wrong, but I believe I should capture that inside accounting { ... } where the final acctstoptime etc get stored into radacct table.
>
> But I don't know how exactly to achieve this.
> I suppose something like this below, but how do I know if the user actually disconnected?
> accounting {
> update request {
> ...
> }
> }
>
> Thanks,
> Mark
>
> Sent with ProtonMail Secure Email.
>
> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html