Tips

Delate user - after the token use - One-Time

# cd /var/www/html

# tuch sessiontime.sh

-------------------

#!/bin/bash
# MySQL credentialsDB_USER="radius"DB_PASSWORD="Daraz@123"DB_NAME="radius"
# SQL query to disable users with a non-NULL acctstoptime#QUERY="UPDATE radcheck SET attribute = 'Cleartext-Password', op = ':=', value = '' WHERE username IN (SELECT username FROM radacct WHERE acctstoptime IS NOT NULL);"QUERY="DELETE FROM radcheck WHERE username IN (SELECT username FROM radacct WHERE acctstoptime IS NOT NULL);"# Execute the querymysql -u "$DB_USER" -p"$DB_PASSWORD" -D "$DB_NAME" -e "$QUERY"
# Commit changesmysql -u "$DB_USER" -p"$DB_PASSWORD" -D "$DB_NAME" -e "COMMIT;"

-------------------------------------------

# add to cron tad

* * * * * /var/www/sessiontime.sh

*** Disable USer

# cd /var/www/html

# tuch disable.sh

-------------------

#!/bin/bash
# MySQL credentialsDB_USER="radius"DB_PASSWORD="Daraz@123"DB_NAME="radius"
# SQL query to disable users with a non-NULL acctstoptimeQUERY="UPDATE radcheck SET value = 'disabled' WHERE username IN (SELECT username FROM radacct WHERE acctstoptime IS NOT NULL);"
# Execute the querymysql -u "$DB_USER" -p"$DB_PASSWORD" -D "$DB_NAME" -e "$QUERY"
# Commit changesmysql -u "$DB_USER" -p"$DB_PASSWORD" -D "$DB_NAME" -e "COMMIT;"

----------------------------------------------------------

# add to cron tad

* * * * * /var/www/disable.sh