Archive for the tag 'Mysql'

 

 

May 11 2013

Freeradius Usage Graphs

Published by under Freeradius

Radius servers generate a lot of accounting records. Is it worth keeping them? Damn yeah! Beside the fact they could be used to check if a customer was connected at a given date, or find out who got IP address X.X.X.X that same day, the most interesting is to generate traffic reports and show customers […]

4 responses so far

May 08 2013

Mysql Stored Procedures Backup

Published by under Mysql

Be aware while backing up Mysql databases: triggers are included by default but NOT the stored procedures/functions. Do not forget to add the –routines switch when running a backup.   mysqldump -u user -p my_database –routines backup.sql   Check your backup scripts before running into a disaster recovery.

No responses yet

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

Next »