3.17.3. DeleteQuery Previous topic Parent topic Child topic Next topic

This SQL statement is executed whenever a user session finishes (i.e. when an Accounting-Request Stop message is received). It is expected to remove the details of the session from the SQL database. Special formatting characters may be used. %1 by the NAS IP address, %2 by the NAS-Port, %3 by the SQL quoted Acct-Session-Id and %4 by the Framed-IP-Address. If DeleteQuery is defined as an empty string, then the query will not be executed.
%0 is formatted as defined in section Section 3.17.2. AddQuery. Section 3.8.1. SQL bind variables are supported.
It defaults to:
delete from RADONLINE where NASIDENTIFIER='%1' and NASPORT=0%2