May 08 2013
Most of us use mysqldump utility to backup Mysql databases. Be aware because mysqldump includes triggers by default but stored procedures and functions are ignored.Stored procedures and functions are called routines in Mysql all together. Run mysqldump –help and you will see FALSE for routine’s default value. You can include stored procedures and functions adding […]
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 on your Mysql server to run it as often as you need. Also check out how to do a full hardware […]
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 intervalsAs a result, […]
Jul 26 2008
It is generally good practice to respect the two following rules when backing up databases. The backup has to be: consistent fast Consistency is easily achieved putting a read lock on all tables beforehand. However, this isn’t always applied, and WILL definitely lead to a database integrity problem when restoring.Once a lock has been set […]
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 Users In users, we’ve got: On startup, db.ippool and db.ipindex are created […]