| Line 1... |
Line 1... |
| 1 |
#! /bin/bash
|
1 |
#! /bin/bash
|
| 2 |
# $Id: alcasar-mysql.sh 904 2012-06-23 11:35:25Z franck $
|
2 |
# $Id: alcasar-mysql.sh 909 2012-06-25 07:16:02Z 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 |
|
| Line 26... |
Line 26... |
| 26 |
|
26 |
|
| 27 |
}
|
27 |
}
|
| 28 |
|
28 |
|
| 29 |
expire_user ()
|
29 |
expire_user ()
|
| 30 |
{
|
30 |
{
|
| - |
|
31 |
del_date=`date +%F`
|
| 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 |
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 |
for u in $MYSQL
|
| 33 |
do
|
34 |
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 |
/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'"
|
| - |
|
36 |
if [ $? = 0 ]
|
| - |
|
37 |
then
|
| - |
|
38 |
echo "User $u was deleted $del_date" >> /var/log/mysqld/delete_user.log
|
| - |
|
39 |
else
|
| - |
|
40 |
echo "Delete User $u : Error $del_date" >> /var/log/mysqld/delete_user.log
|
| - |
|
41 |
fi
|
| 35 |
done
|
42 |
done
|
| 36 |
}
|
43 |
}
|
| 37 |
usage="Usage: alcasar-mysql.sh { -d or --dump } | { -i or --import } | { -r or --raz } | { -acct_stop } | [ --expire_user ]"
|
44 |
usage="Usage: alcasar-mysql.sh { -d or --dump } | { -i or --import } | { -r or --raz } | { -acct_stop } | [ --expire_user ]"
|
| 38 |
nb_args=$#
|
45 |
nb_args=$#
|
| 39 |
args=$1
|
46 |
args=$1
|
| 40 |
if [ $nb_args -eq 0 ]
|
47 |
if [ $nb_args -eq 0 ]
|