Aug
16
2010
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 [...]
Tags: GLPI, Mysql, SQL
May
30
2009
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 [...]
Tags: accounting, billing software, Cisco, daily, Database, Freeradius, Mysql, quota, radius, report, SQL, traffic
Jul
22
2008
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 ippool main_pool { range-start = 192.168.0.2 range-stop = [...]
Tags: Freeradius, ip, linux, Mysql, pool, radclient, radius, release, SQL