Subversion Repositories ALCASAR

Rev

Rev 873 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log

Rev 873 Rev 904
Line 1... Line 1...
1 
#! /bin/bash
 1 
#! /bin/bash
2 
# $Id: alcasar-mysql.sh 873 2012-05-21 17:56:25Z franck $
 2 
# $Id: alcasar-mysql.sh 904 2012-06-23 11:35:25Z franck $
3 
 
 3 
 
4 
# alcasar-mysql.sh
 4 
# alcasar-mysql.sh
5 
# by Franck BOUIJOUX, Pascal LEVANT and Richard REY
 5 
# by Franck BOUIJOUX, Pascal LEVANT and Richard REY
6 
# This script is distributed under the Gnu General Public License (GPL)
 6 
# This script is distributed under the Gnu General Public License (GPL)
7 
 
 7 
 
8 
# Gestion (sauvegarde / import / RAZ) de la base MySQL 'radius'. Fermeture des sessions de comptabilité ouvertes
 8 
# Gestion (sauvegarde / import / RAZ) de la base MySQL 'radius'. Fermeture des sessions de comptabilité ouvertes
9 
# Management of mysql 'radius' database (save / import / RAZ). Close the accounting open sessions
 9 
# Management of mysql 'radius' database (save / import / RAZ). Close the accounting open sessions
10 
 
 10 
 
11 
rep_tr="/var/Save/base" 	 	# répertoire d'accueil des sauvegardes
 11 
rep_tr="/var/Save/base" 	 	# répertoire d'accueil des sauvegardes
12 
ext="sql"  				# extension des fichiers de sauvegarde
 12 
ext="sql"  				# extension des fichiers de sauvegarde
13 
DB_RADIUS="db_radius"
 13 
DB_RADIUS="radius"
14 
DB_USER="db_user"
 14 
DB_USER="radius"
15 
radiuspwd="radius_pwd"
 15 
radiuspwd="9dthW7VG"
16 
new="$(date +%G%m%d-%Hh%M)"  		# date et heure des fichiers
 16 
new="$(date +%G%m%d-%Hh%M)"  		# date et heure des fichiers
17 
fichier="$DB_RADIUS-$new.$ext"		# nom du fichier de sauvegarde
 17 
fichier="$DB_RADIUS-$new.$ext"		# nom du fichier de sauvegarde
18 
 
 18 
 
- 
 
 19 
#USER="franck"
- 
 
 20 
#MYSQLCMD="/usr/bin/mysql -u$DB_USER -p$radiuspwd $DB_RADIUS --exec"
- 
 
 21 
 
19 
stop_acct ()
 22 
stop_acct ()
20 
{
 23 
{
21 
	date_now=`date "+%F %X"`
 24 
	date_now=`date "+%F %X"`
22 
	echo "UPDATE radacct SET acctstoptime = '$date_now', acctterminatecause = 'Admin-Reset' WHERE acctstoptime IS NULL" | mysql -u$DB_USER -p$radiuspwd $DB_RADIUS
 25 
	echo "UPDATE radacct SET acctstoptime = '$date_now', acctterminatecause = 'Admin-Reset' WHERE acctstoptime IS NULL" | mysql -u$DB_USER -p$radiuspwd $DB_RADIUS
23 
 
 26 
 
24 
}
 27 
}
- 
 
 28 
 
- 
 
 29 
expire_user ()
- 
 
 30 
{
- 
 
 31 
	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';"`
- 
 
 32 
	for u in $MYSQL
- 
 
 33 
	do
- 
 
 34 
		 /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'"
- 
 
 35 
	done
- 
 
 36 
}
25 
usage="Usage: alcasar-mysql.sh { -d or --dump } | { -i or --import } | { -r or --raz } | { -acct_stop }"
 37 
usage="Usage: alcasar-mysql.sh { -d or --dump } | { -i or --import } | { -r or --raz } | { -acct_stop } | [ --expire_user ]"
26 
nb_args=$#
 38 
nb_args=$#
27 
args=$1
 39 
args=$1
28 
if [ $nb_args -eq 0 ]
 40 
if [ $nb_args -eq 0 ]
29 
then
 41 
then
30 
	nb_args=1
 42 
	nb_args=1
Line 59... Line 71...
59 
		mysql -u$DB_USER -p$radiuspwd $DB_RADIUS < /etc/raddb/radiusd-db-vierge.sql
 71 
		mysql -u$DB_USER -p$radiuspwd $DB_RADIUS < /etc/raddb/radiusd-db-vierge.sql
60 
		;;
 72 
		;;
61 
	-acct_stop)
 73 
	-acct_stop)
62 
		stop_acct
 74 
		stop_acct
63 
		;;
 75 
		;;
- 
 
 76 
	--expire_user)
- 
 
 77 
		expire_user
- 
 
 78 
		;;
64 
	*)
 79 
	*)
65 
		echo "Argument inconnu :$1";
 80 
		echo "Argument inconnu :$1";
66 
		echo "$usage"
 81 
		echo "$usage"
67 
		exit 1
 82 
		exit 1
68 
		;;
 83 
		;;