3.18.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.
Delete is executed by default when an Access-Request message is received or a new session is added. This attempts to clear any defunct existing session for the port. If the port is not unique for a session, or there's some other reason to control session database updates, see SessionDatabaseOptions.
%0 is formatted as defined in section Section 3.18.2. AddQuery. Section 3.8.1. SQL bind variables are supported.
It defaults to:
delete from RADONLINE where NASIDENTIFIER='%1' and NASPORT=0%2