Archive for the tag 'SQL'

 

 

Aug 16 2010

GLPI Ticket User Group Auto Assignment

Published by dave 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 dave 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 [...]

15 responses so far

Jul 22 2008

Freeradius IP Pools

Published by dave 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 »