| 10,12 → 10,15 |
|---|
| |
| rep_tr="/var/Save/base" # répertoire d'accueil des sauvegardes |
| ext="sql" # extension des fichiers de sauvegarde |
| DB_RADIUS="db_radius" |
| DB_USER="db_user" |
| radiuspwd="radius_pwd" |
| DB_RADIUS="radius" |
| DB_USER="radius" |
| radiuspwd="9dthW7VG" |
| new="$(date +%G%m%d-%Hh%M)" # date et heure des fichiers |
| fichier="$DB_RADIUS-$new.$ext" # nom du fichier de sauvegarde |
| |
| #USER="franck" |
| #MYSQLCMD="/usr/bin/mysql -u$DB_USER -p$radiuspwd $DB_RADIUS --exec" |
| |
| stop_acct () |
| { |
| date_now=`date "+%F %X"` |
| 22,7 → 25,16 |
|---|
| echo "UPDATE radacct SET acctstoptime = '$date_now', acctterminatecause = 'Admin-Reset' WHERE acctstoptime IS NULL" | mysql -u$DB_USER -p$radiuspwd $DB_RADIUS |
| |
| } |
| usage="Usage: alcasar-mysql.sh { -d or --dump } | { -i or --import } | { -r or --raz } | { -acct_stop }" |
| |
| expire_user () |
| { |
| MYSQL=`/usr/bin/mysql -u$DB_USER -p$radiuspwd $DB_RADIUS -ss --exec "SELECT username FROM radcheck WHERE ( DATE_SUB(CURDATE(),INTERVAL 7 DAY) > STR_TO_DATE(value,'%d %M %Y')) AND attribute='Expiration';"` |
| for u in $MYSQL |
| do |
| /usr/bin/mysql -u$DB_USER -p$radiuspwd $DB_RADIUS --exec "DELETE FROM radusergroup WHERE username = '$u'; DELETE FROM radreply WHERE username = '$u'; DELETE FROM userinfo WHERE UserName = '$u'; DELETE FROM radcheck WHERE username = '$u'" |
| done |
| } |
| usage="Usage: alcasar-mysql.sh { -d or --dump } | { -i or --import } | { -r or --raz } | { -acct_stop } | [ --expire_user ]" |
| nb_args=$# |
| args=$1 |
| if [ $nb_args -eq 0 ] |
| 61,6 → 73,9 |
|---|
| -acct_stop) |
| stop_acct |
| ;; |
| --expire_user) |
| expire_user |
| ;; |
| *) |
| echo "Argument inconnu :$1"; |
| echo "$usage" |