| Line 34... |
Line 34... |
| 34 |
{
|
34 |
{
|
| 35 |
echo "check (and repair if needed) the database :"
|
35 |
echo "check (and repair if needed) the database :"
|
| 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
|
39 |
remove_old_users () # Remove users who haven't logged in for more than a year (TO BE VERIFY BEFORE ACTIVATE)
|
| 40 |
{
|
40 |
{
|
| 41 |
SQL_USER=""
|
41 |
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;"`
|
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 |
for u in $SQL_USER
|
43 |
for u in $SQL_USER
|
| 44 |
do
|
44 |
do
|