[RADIATOR] Quota Deduction using Authby SQL realm

[Thomas KCCG]

Dear All,

 

I am using Authby SQL realm for authentication purpose. Once the session is
end for a quota based user it should deduct the used quota
(Acct-input-octets in bytes) from the quota left.(Acct-input-octets gives
the number of bytes used and this will be available with accounting stop
packet from the NAS at user's session end.  

 

How can I do this using Authby SQL realm.

 

Please give me one example for the queries related to it. I did see one
example in goodies directory called goodies/blocktime.txt but it is all time
based and is difficult to relate in terms of quota deduction. 
 
An example like blocktime.txt with contents for quota deduction, is my
requirement.

 

 

Regards,

 

Thomas Kurian

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.open.com.au/pipermail/radiator/attachments/20130128/fcd1701e/attachment.html