For my app i needed another column in the radcheck table called `Valid` because so i dont have to delete the user and his or her account to deny access to the network. The main purpose for the hotspotsystem was to log the access times for each user and when deleting a user there will be errors because the user row dosen’t exist anymore.
Its really simple:
alter table radcheck add column `Valid` tinyint(1) default 0 not null;
than in the /etc/freeradius/sql.conf change the variable authorize_check_query by adding `and Valid = 1` after where username = “%{SQL-User-Name}” \
in the future time you can chane then the valid to serve many purposes for example email authorization like wifidog has.
