Subversion Repositories ALCASAR

Compare Revisions

Ignore whitespace Rev 2513 → Rev 2512

/conf/freeradius-web/sql.attrmap
51,8 → 51,4
replyitem Reply-Message Reply-Message
replyItem Dialup-Lock-Msg Reply-Message
replyItem User-Password User-Password
replyItem WISPr-Redirection-URL WISPr-Redirection-URL
 
checkItem Alcasar-Expire-After Alcasar-Expire-After
checkItem CoovaChilli-Max-Total-Octets-Daily CoovaChilli-Max-Total-Octets-Daily
checkItem CoovaChilli-Max-Total-Octets-Monthly CoovaChilli-Max-Total-Octets-Monthly
replyItem WISPr-Redirection-URL WISPr-Redirection-URL
/conf/freeradius-web/user_edit.attrs
17,8 → 17,6
Login-Time <a href="help/login_time_help.html" target=lt_help onclick=window.open("help/login_time_help.html","lt_help","width=600,height=370,toolbar=no,scrollbars=no,resizable=yes") title="Login-Time Help Page"><font color="blue">P&eacute;riode hebdomadaire</font></a>
CoovaChilli-Max-Input-Octets <a href="help/coovachilli_max_input_octets_help.html" target=st_help onclick=window.open("help/coovachilli_max_input_octets_help.html","st_help","width=600,height=250,toolbar=no,scrollbars=no,resizable=yes") title="CoovaChilli Max Input Octets Help Page"><font color="blue">Nombre d'octets max. en &eacute;mission</font></a><BR>(en octets)
CoovaChilli-Max-Output-Octets <a href="help/coovachilli_max_output_octets_help.html" target=st_help onclick=window.open("help/coovachilli_max_output_octets_help.html","st_help","width=600,height=250,toolbar=no,scrollbars=no,resizable=yes") title="CoovaChilli Max Output Octets Help Page"><font color="blue">Nombre d'octets max. en r&eacute;ception</font></a><BR>(en octets)
CoovaChilli-Max-Total-Octets-Daily <a href="help/coovachilli_max_total_octets_help.html" target=st_help onclick=window.open("help/coovachilli_max_total_octets_help.html","st_help","width=600,height=250,toolbar=no,scrollbars=no,resizable=yes") title="CoovaChilli Max Total Octets Daily Help Page"><font color="blue">Nombre d'octets max. total transmit par jour</font></a><BR>(en octets)
CoovaChilli-Max-Total-Octets-Monthly <a href="help/coovachilli_max_total_octets_help.html" target=st_help onclick=window.open("help/coovachilli_max_total_octets_help.html","st_help","width=600,height=250,toolbar=no,scrollbars=no,resizable=yes") title="CoovaChilli Max Total Octets Monthly Help Page"><font color="blue">Nombre d'octets max. total transmit par mois</font></a><BR>(en octets)
CoovaChilli-Max-Total-Octets <a href="help/coovachilli_max_total_octets_help.html" target=st_help onclick=window.open("help/coovachilli_max_total_octets_help.html","st_help","width=600,height=250,toolbar=no,scrollbars=no,resizable=yes") title="CoovaChilli Max Total Octets Help Page"><font color="blue">Nombre d'octets max. total transmit</font></a><BR>(en octets)
CoovaChilli-Bandwidth-Max-Up <a href="help/coovachilli_bandwidth_max_up_help.html" target=st_help onclick=window.open("help/coovachilli_bandwidth_max_up_help.html","st_help","width=600,height=250,toolbar=no,scrollbars=no,resizable=yes") title="CoovaChilli Bandwidth Max Up Help Page"><font color="blue">Bande passante montante max.</font></a><BR>(en kbits/seconde)
CoovaChilli-Bandwidth-Max-Down <a href="help/coovachilli_bandwidth_max_down_help.html" target=st_help onclick=window.open("help/coovachilli_bandwidth_max_down_help.html","st_help","width=600,height=250,toolbar=no,scrollbars=no,resizable=yes") title="CoovaChilli Bandwidth Max Down Help Page"><font color="blue">Bande passante descendante max.</font></a><BR>(en kbits/seconde)
/conf/radius/sqlcounter
35,27 → 35,3
reset = never
$INCLUDE ${modconfdir}/sql/counter/mysql/${.:instance}.conf
}
 
sqlcounter counterCoovaChilliMaxTotalOctetsDaily {
sql_module_instance = sql
counter_name = CoovaChilli-Max-Total-Octets-Daily
check_name = CoovaChilli-Max-Total-Octets-Daily
counter_type = data
reply_name = CoovaChilli-Max-Total-Octets
sqlmod-inst = sql
key = User-Name
reset = daily
query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0) FROM radacct WHERE username='%{${key}}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'"
}
 
sqlcounter counterCoovaChilliMaxTotalOctetsMonthly {
sql_module_instance = sql
counter_name = CoovaChilli-Max-Total-Octets-Monthly
check_name = CoovaChilli-Max-Total-Octets-Monthly
counter_type = data
reply_name = CoovaChilli-Max-Total-Octets
sqlmod-inst = sql
key = User-Name
reset = monthly
query = "SELECT IFNULL((SUM(AcctInputOctets + AcctOutputOctets)),0)FROM radacct WHERE username='%{${key}}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%%b'"
}
/conf/radius/alcasar
21,13 → 21,10
 
authorize {
sql
expire_on_login
noresetcounter
dailycounter
monthlycounter
expiration
counterCoovaChilliMaxTotalOctetsDaily
counterCoovaChilliMaxTotalOctetsMonthly
logintime
pap
}
/conf/radius/alcasar-with-ldap
21,13 → 21,10
 
authorize {
sql
expire_on_login
noresetcounter
dailycounter
monthlycounter
expiration
counterCoovaChilliMaxTotalOctetsDaily
counterCoovaChilliMaxTotalOctetsMonthly
logintime
pap
ldap {