Archive for the tag 'SQL'

 

 

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 [...]

17 responses so far

Jul 22 2008

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 ippool main_pool { range-start = 192.168.0.2 range-stop = [...]

4 responses so far

Next »