Hey, Rafael!

An update to that RADIUS post

Introduction

Rafael Fonseca

Rafael Fonseca


An update to that RADIUS post

Posted by Rafael Fonseca on .
Featured

An update to that RADIUS post

Posted by Rafael Fonseca on .

After a lot of research and endless nights watching logs, trying to figure out why some users were successfully disconnected while others weren't, I have finally managed to understand the concept that FreeRADIUS does not handle counters bigger than 4GB well.

So while the original post had the query in bytes, I suggest using the one below instead, which returns data in kilobytes. And, for the future, you can add an additional /1024 to the query to have it return the values in megabytes.

SELECT IFNULL(SUM(AcctInputOctets + AcctOutputOctets)/1024,0) FROM radacct WHERE username = '%{%k}';

And don't forget to update your Check Items as well to ensure they are in kilobytes (or megabytes). Otherwise the comparisons won't work!

PS: Yes, I did just randomly post again. Woohoo!

Rafael Fonseca

Rafael Fonseca

View Comments...