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? Damn yeah! 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 traffic reports and show customers […]

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 to run it every so often.   begin update SI_BD.glpi_tracking t set t.fk_group= ( SELECT g.id FROM SI_BD.glpi_users u, SI_BD.glpi_groups […]

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 intervals As a […]

30 responses so far

Next »