Archive for the tag 'SQL'



May 11 2013

Freeradius Usage Graphs

Published by under Freeradius

Radius servers generate a lot of accounting records. Is it worth keeping them? Of course! Beside the fact they could be used to check if a customer was connected at a given date, or find out who got IP address X.X.X.X that same day, the most interesting is to generate Freeradius traffic usage graphs and […]

4 responses so far

Aug 16 2010

GLPI Ticket User Group Auto Assignment

Published by under GLPI

GLPI user has to select the group he belongs to when creating a ticket or else the field remains empty.This stored procedure automatically assigns all tickets to the user’s group. Setup a cron job on your Mysql server to run it as often as you need.  Also check out how to do a full hardware […]

No responses yet

May 30 2009

Daily Accounting in Freeradius

Published by under Cisco,Freeradius

We have seen a few posts on Freeradius user list and other forums asking how to collect accounting periodically. The Radius protocol provides accounting but not in the way that many would like. Here’s a short list of things we would like to modify or improve: Traffic is not collected at regular intervalsAs a result, […]

33 responses so far

Jul 22 2008

Feedback on Freeradius IP Pools

Published by under Freeradius

If you wonder if you should use rlm_ippool or rlm_sqlippool to turn your Radius into a “DHCP” server, read on! rlm_ippool We first configured Freeradius to provide IP addresses through the ippool module. IPs are stored internally in a binary data file. radiusd.conf  Users In users, we’ve got: On startup, db.ippool and db.ipindex are created […]

7 responses so far

Aug 01 2007

Gigawords Support in Radius

Published by under Cisco,Freeradius

Many people using Radius for accounting don’t know there are counters limits. Values defined in the protocol are stored in 32 bit fields meaning you will never go any higher than 4294967296 bits, that is fairly more than 4GB. If a session stays up for days, there are good chances that the counter resets to […]

9 responses so far

Next »