An update to that RADIUS post

An update to that RADIUS post

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!



Professional site reliability engineer, amateur chef, practicing traveller.

View Comments
Next Post

Rebuilding the NAS, Part I

Previous Post

Bye bye Delicious. Hello Evernote!

Success! Your membership now is active.