1000,11 → 1000,17 |
EOF |
[ -e /etc/raddb/mods-config/sql/counter/mysql/noresetcounter.conf.default ] || cp /etc/raddb/mods-config/sql/counter/mysql/noresetcounter.conf /etc/raddb/mods-config/sql/counter/mysql/noresetcounter.conf.default |
cat << EOF > /etc/raddb/mods-config/sql/counter/mysql/noresetcounter.conf |
# This query was modified for ALCASAR needs (amount of time the voucher is enabled --> rename it in the future : 'Expire_on_login') |
query = "\ |
SELECT IFNULL(SUM(AcctSessionTime),0) \ |
FROM radacct \ |
WHERE username='%{\${key}}'" |
EOF |
[ -e /etc/raddb/mods-config/sql/counter/mysql/expire_on_login.conf.default ] || cp /etc/raddb/mods-config/sql/counter/mysql/expire_on_login.conf /etc/raddb/mods-config/sql/counter/mysql/expire_on_login.conf.default |
cat << EOF > /etc/raddb/mods-config/sql/counter/mysql/expire_on_login.conf |
query = "\ |
SELECT IFNULL((SELECT TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime)) \ |
FROM radacct \ |
WHERE UserName='%{\${key}}' \ |
WHERE username='%{\${key}}' \ |
ORDER BY acctstarttime \ |
LIMIT 1),0)" |
EOF |