| Line 36... |
Line 36... |
| 36 |
mariadb-check --databases $DB_RADIUS -u $DB_USER -p$DB_PASS --auto-repair
|
36 |
mariadb-check --databases $DB_RADIUS -u $DB_USER -p$DB_PASS --auto-repair
|
| 37 |
}
|
37 |
}
|
| 38 |
|
38 |
|
| 39 |
remove_old_users () # Remove users who haven't logged in for more than a year (TO BE VERIFY BEFORE ACTIVATE)
|
39 |
remove_old_users () # Remove users who haven't logged in for more than a year (TO BE VERIFY BEFORE ACTIVATE)
|
| 40 |
{
|
40 |
{
|
| - |
|
41 |
del_date=`date +%F`
|
| 41 |
SQL_USER=""
|
42 |
SQL_USER=""
|
| 42 |
SQL_USER=`/usr/bin/mariadb -u$DB_USER -p$DB_PASS $DB_RADIUS -ss --execute "SELECT username FROM (SELECT DISTINCT username FROM radacct WHERE acctstarttime >= NOW() - INTERVAL 1 YEAR) AS actifs;"`
|
43 |
SQL_USER=`/usr/bin/mariadb -u$DB_USER -p$DB_PASS $DB_RADIUS -ss --execute "SELECT username FROM userinfo WHERE username NOT IN (SELECT DISTINCT username FROM radacct WHERE acctstarttime >= NOW() - INTERVAL 1 YEAR) ;"`
|
| 43 |
for u in $SQL_USER
|
44 |
for u in $SQL_USER
|
| 44 |
do
|
45 |
do
|
| 45 |
/usr/bin/mariadb -u$DB_USER -p$DB_PASS $DB_RADIUS --execute "DELETE FROM radusergroup WHERE username = '$u'; DELETE FROM radreply WHERE username = '$u'; DELETE FROM userinfo WHERE UserName = '$u'; DELETE FROM radcheck WHERE username = '$u';"
|
46 |
/usr/bin/mariadb -u$DB_USER -p$DB_PASS $DB_RADIUS --execute "DELETE FROM radusergroup WHERE username = '$u'; DELETE FROM radreply WHERE username = '$u'; DELETE FROM userinfo WHERE UserName = '$u'; DELETE FROM radcheck WHERE username = '$u';"
|
| 46 |
if [ $? = 0 ]
|
47 |
if [ $? = 0 ]
|
| 47 |
then
|
48 |
then
|