Subversion Repositories ALCASAR

Rev

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

Rev 3274 Rev 3277
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