6 # Set an account to expire T seconds after first login.
7 # Requires the Expire-After attribute to be set, in seconds.
8 # You may need to edit raddb/dictionary to add the Expire-After
11 # This example is for MySQL. Other SQL variants should be similar.
13 sqlcounter expire_on_login {
14 counter-name = Expire-After-Initial-Login
15 check-name = Expire-After
19 query = "SELECT TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)) \
21 WHERE UserName='%{%k}' \
22 ORDER BY acctstarttime \