12,19 → 12,21 |
ext="sql" # extension des fichiers de sauvegarde |
DB_RADIUS="radius" |
DB_USER="radius" |
radiuspwd="9dthW7VG" |
radiuspwd="iDTxxBGa" |
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"` |
echo "UPDATE radacct SET acctstoptime = '$date_now', acctterminatecause = 'Admin-Reset' WHERE acctstoptime IS NULL" | mysql -u$DB_USER -p$radiuspwd $DB_RADIUS |
|
} |
check () |
{ |
echo "check (and repair if needed) the database :" |
mysqlcheck --databases $DB_RADIUS -u $DB_USER -p$radiuspwd --auto-repair |
} |
|
expire_user () |
{ |
41,7 → 43,7 |
fi |
done |
} |
usage="Usage: alcasar-mysql.sh { -d or --dump } | { -i or --import } | { -r or --raz } | { -acct_stop } | [ --expire_user ]" |
usage="Usage: alcasar-mysql.sh { -d or --dump } | { -c or --check } | { -i or --import } | { -r or --raz } | { -acct_stop } | [ --expire_user ]" |
nb_args=$# |
args=$1 |
if [ $nb_args -eq 0 ] |
59,14 → 61,18 |
if [ -e $fichier ]; |
then rm -f $fichier |
fi |
echo "Export de la base 'db_radius' dans le fichier : $fichier" |
check |
echo "Export the database in file : $fichier" |
mysqldump -u $DB_USER -p$radiuspwd --opt -BcQC $DB_RADIUS > $rep_tr/$fichier |
echo "Fin de Sauvegarde mysql $( date "+%Hh %Mmn" )" |
echo "End of export $( date "+%Hh %Mmn" )" |
;; |
-c | --check | -check) |
check |
;; |
-i | --import | -import) |
if [ $nb_args -ne 2 ] |
then |
echo "Entrez le nom d'un fichier SQL (.sql)" |
echo "Enter a SQL file name (.sql)" |
exit 0 |
else |
mysql -u $DB_USER -p$radiuspwd < $2 |
84,7 → 90,7 |
expire_user |
;; |
*) |
echo "Argument inconnu :$1"; |
echo "Unknown argument :$1"; |
echo "$usage" |
exit 1 |
;; |