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 [...]
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 [...]
Jul 26 2008
It is generally good practice to respect the two following points when backing up databases. The backup has to be: consistent fast Consistency is easily achieved putting a read lock on all tables beforehands. However, this isn’t always applied, and WILL definately lead to a database integrity problem at some stage. Once a lock has [...]