987,44 → 987,12 |
[ -e /etc/raddb/mods-available/sqlcounter.default ] || cp /etc/raddb/mods-available/sqlcounter /etc/raddb/mods-available/sqlcounter.default |
cp -f $DIR_CONF/radius/sqlcounter /etc/raddb/mods-available/sqlcounter |
chown -R radius:radius /etc/raddb/mods-available/sqlcounter |
[ -e /etc/raddb/mods-config/sql/counter/mysql/dailycounter.conf.default ] || cp /etc/raddb/mods-config/sql/counter/mysql/dailycounter.conf /etc/raddb/mods-config/sql/counter/mysql/dailycounter.conf.default |
cat << EOF > /etc/raddb/mods-config/sql/counter/mysql/dailycounter.conf |
query = "\ |
SELECT IFNULL((SELECT SUM(acctsessiontime - GREATEST((%%b - UNIX_TIMESTAMP(acctstarttime)),0)) \ |
FROM radacct \ |
WHERE username = '%{\${key}}' \ |
AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '%%b'),0)" |
EOF |
[ -e /etc/raddb/mods-config/sql/counter/mysql/monthlycounter.conf.default ] || cp /etc/raddb/mods-config/sql/counter/mysql/monthlycounter.conf /etc/raddb/mods-config/sql/counter/mysql/monthlycounter.conf.default |
cat << EOF > /etc/raddb/mods-config/sql/counter/mysql/monthlycounter.conf |
query = "\ |
SELECT IFNULL((SELECT SUM(acctsessiontime - GREATEST((%%b - UNIX_TIMESTAMP(acctstarttime)), 0)) \ |
FROM radacct \ |
WHERE username='%{\${key}}' \ |
AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '%%b'),0)" |
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 |
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}}' \ |
ORDER BY acctstarttime \ |
LIMIT 1),0)" |
EOF |
# make certain that mysql is up before freeradius start |
[ -e /lib/systemd/system/radiusd.service.default ] || cp /lib/systemd/system/radiusd.service /lib/systemd/system/radiusd.service.default |
$SED "s?^After=.*?After=syslog.target network.target mysqld.service?g" /lib/systemd/system/radiusd.service |
/usr/bin/systemctl daemon-reload |
# Allow apache to change some conf files (ie : ldap on/off) |
chgrp apache /etc/raddb /etc/raddb/sites-available /etc/raddb/mods-available |
# Allow apache to change some conf files (ie : ldap on/off) |
chgrp apache /etc/raddb /etc/raddb/sites-available /etc/raddb/mods-available |
|
} # End freeradius () |
|