| 12,7 → 12,7 |
|---|
| ext="sql" # extension des fichiers de sauvegarde |
| DB_RADIUS="radius" |
| DB_USER="radius" |
| radiuspwd="iDTxxBGa" |
| radiuspwd="MotdePasse" # Mot de passe adapté à l'install |
| new="$(date +%G%m%d-%Hh%M)" # date et heure des fichiers |
| fichier="$DB_RADIUS-$new.$ext" # nom du fichier de sauvegarde |
| |
| 31,10 → 31,11 |
|---|
| expire_user () |
| { |
| del_date=`date +%F` |
| 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 |
| MYSQL_USER="" |
| MYSQL_USER=`/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_USER |
| 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'" |
| /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';" |
| if [ $? = 0 ] |
| then |
| echo "User $u was deleted $del_date" >> /var/log/mysqld/delete_user.log |
| 43,7 → 44,37 |
|---|
| fi |
| done |
| } |
| usage="Usage: alcasar-mysql.sh { -d or --dump } | { -c or --check } | { -i or --import } | { -r or --raz } | { -acct_stop } | [ --expire_user ]" |
| |
| expire_group () |
| { |
| del_date=`date +%F` |
| MYSQL_GROUP="" |
| MYSQL_GROUP=`/usr/bin/mysql -u$DB_USER -p$radiuspwd $DB_RADIUS -ss --exec "SELECT groupname FROM radgroupcheck WHERE ( DATE_SUB(CURDATE(),INTERVAL 7 DAY) > STR_TO_DATE(value,'%d %M %Y')) AND attribute='Expiration';"` |
| for g in $MYSQL_GROUP |
| do |
| MYSQL_USERGROUP="" |
| MYSQL_USERGROUP=`/usr/bin/mysql -u$DB_USER -p$radiuspwd $DB_RADIUS -ss --exec "SELECT username FROM radusergroup WHERE groupname = '$g';"` |
| for u in $MYSQL_USERGROUP |
| 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';" |
| if [ $? = 0 ] |
| then |
| echo "User $u was deleted $del_date" >> /var/log/mysqld/delete_user.log |
| else |
| echo "Delete User $u : Error $del_date" >> /var/log/mysqld/delete_user.log |
| fi |
| done |
| /usr/bin/mysql -u$DB_USER -p$radiuspwd $DB_RADIUS --exec "DELETE FROM radgroupreply WHERE groupname = '$g'; DELETE FROM radgroupcheck WHERE groupname = '$g';" |
| if [ $? = 0 ] |
| then |
| echo "Group $g was deleted $del_date" >> /var/log/mysqld/delete_group.log |
| else |
| echo "Delete Group $g : Error $del_date" >> /var/log/mysqld/delete_group.log |
| fi |
| done |
| } |
| |
| usage="Usage: alcasar-mysql.sh { -d or --dump } | { -c or --check } | { -i or --import } | { -r or --raz } | { -a or --acct_stop } | [ -e or --expire_user ]" |
| nb_args=$# |
| args=$1 |
| if [ $nb_args -eq 0 ] |
| 83,11 → 114,12 |
|---|
| mysqldump -u $DB_USER -p$radiuspwd --opt -BcQC $DB_RADIUS > $rep_tr/$fichier && \ |
| mysql -u$DB_USER -p$radiuspwd $DB_RADIUS < /etc/raddb/radiusd-db-vierge.sql |
| ;; |
| -acct_stop) |
| -a | --acct_stop | -acct_stop) |
| stop_acct |
| ;; |
| --expire_user) |
| -e | --expire_user) |
| expire_user |
| expire_group |
| ;; |
| *) |
| echo "Unknown argument :$1"; |