Doesn´t work..
preacct {
preproccess
acct_unique
suffix
sql.authorize
}
accouting {
if (Check-Quota == "1") {
if (Acct-Status-Type == "Start") {
onda_startquota
}
elsif (Acct-Status-Type == "Interim-Update") {
onda_updatequota
}
}
}
Debug:
# Executing section post-auth from file
/etc/freeradius/sites-enabled/default
Sending Access-Accept of id 128 to 192.168.2.200 port 38896
Framed-Compression := Van-Jacobson-TCP-IP
Framed-MTU := 1492
Acct-Interim-Interval := 600
Framed-Protocol := PPP
Mikrotik-Rate-Limit := "64k/64k"
Check-Quota := 1
Finished request 0.
Going to the next request
Waking up in 4.9 seconds.
rad_recv: Accounting-Request packet from host 192.168.2.200 port 55834,
id=129, length=149
Service-Type = Framed-User
Framed-Protocol = PPP
NAS-Port = 11
NAS-Port-Type = Ethernet
User-Name = "xande"
Calling-Station-Id = "1C:75:08:21:91:30"
Called-Station-Id = "pppoe-main"
NAS-Port-Id = "ether2"
Acct-Session-Id = "81400005"
Framed-IP-Address = 10.55.0.255
Acct-Authentic = RADIUS
Event-Timestamp = "Dec 5 2012 10:45:52 BRST"
Acct-Status-Type = Start
NAS-Identifier = "PPPOE-TESTE"
Acct-Delay-Time = 0
NAS-IP-Address = 192.168.2.200
# Executing section preacct from file /etc/freeradius/sites-enabled/default
+- entering group preacct {...}
++[preprocess] returns ok
...
...
++[sql.authorize] returns ok
++? if (Check-Quota == "1")
(Attribute Check-Quota was not found)
? Evaluating (Check-Quota == "1") -> FALSE
++? if (Check-Quota == "1") -> FALSE
Sending Accounting-Response of id 129 to 192.168.2.200 port 55834
Framed-Compression := Van-Jacobson-TCP-IP
Framed-MTU := 1492
Acct-Interim-Interval := 60
Framed-Protocol := PPP
Mikrotik-Rate-Limit := "64k/64k"
Check-Quota := 1
Finished request 1.
i tried putting 'sql.authorize' into accouting { }, but same 'problem' .
My radgroupreply:
GroupName Attribute Value op prio
ondaX Check-Quota 1 := 0
any suggestion ?
On 04/12/2012 19:36, Arran Cudbard-Bell wrote:
On 4 Dec 2012, at 20:50, "Alexandre J. Correa (Onda)" <alexan...@onda.net.br>
wrote:
Hello,
I need to track some type of 'user group'. i´m doing this to not overload my
database servers.
into the radgroupreply table i need to 'create' one attribute like:
Check-Bandwidth := [0,1]
i added this attribute in groupreply, in my dictionary file and i can see this
attribute in the 'authorization' section.
How i can pass it to 'accouting' section ? maybe setting global variable for
this session ?
Call sql.authorize in preacct.
-Arran
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
--
Sds.
Alexandre Jeronimo Correa
Sócio-Administrador
Office: +55 34 3351 3077
Onda Internet
www.onda.net.br
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
